API tools faq
paste
Advertisement
mamanegoryu1

Untitled

mamanegoryu1
Apr 19th, 2017
408
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 10.66 KB | None | 0 0
raw download clone embed print report
  1. roman@D85:~/work/sqg$ python main-tests.py -n odbc
  2.  
  3.  
  4.  
  5.  
  6.  
  7.  
  8.  
  9.  
  10.  
  11.  
  12.  
  13. -------- Testing Namespace --------
  14. -------- Testing Expression --------
  15. -------- Testing ConvTypes --------
  16. Warning: Can't convert 'not a number' to number. Converting to 0.
  17.  
  18. -------- Testing Source --------
  19. Warning: Skipping blank URL
  20. Warning: Can't convert data of unknown type to "image/jpeg". Leaving as is.
  21. ----------------------------------------
  22. Error retrieving document "http://google.com/nopage". Details follow:
  23. Error: HTTP response code: 404
  24. Node: SELECT1
  25. ----------------------------------------
  26.  
  27. ----------------------------------------
  28. Error retrieving document "http://google.com/nopage". Details follow:
  29. Error: HTTP response code: 404
  30. Node: SELECT1
  31. ----------------------------------------
  32.  
  33. ----------------------------------------
  34. Error retrieving document "file:testfiles/input/frames/a.html". Details follow:
  35. Error: Couldn't retrieve child frame "file:testfiles/input/frames/c.html" from "file:testfiles/input/frames/a.html": Error: Maximum number of child frames reached
  36. Node: SELECT1
  37. ----------------------------------------
  38.  
  39. Warning: Couldn't retrieve child frame "file:testfiles/input/frames/c.html" from "file:testfiles/input/frames/a.html": Error: Maximum number of child frames reached
  40.  
  41. -------- Testing Html --------
  42. -------- Testing Http --------
  43. Warning: Cookie file "/home/roman/work/sqg/testfiles/tmpOut/cookieState" missing or malformed. Loading blank cookie state.
  44. Warning: "www.1.2.3.4" is an invalid host name. Ignoring cookies.
  45. Warning: "www.1.2.3.4" is an invalid host name. Ignoring cookies.
  46. Warning: "2.3.4" is an invalid host name. Ignoring cookies.
  47. Warning: "2.3.4" is an invalid host name. Ignoring cookies.
  48. ----------------------------------------
  49. Error retrieving document "https://secure.donauversicherung.at". Details follow:
  50. Error: Host "secure.donauversicherung.at" not found in certificate DNS list: www.donauversicherung.at, www.donauassicurazioni.it, m.donauversicherung.at, dl.donauversicherung.at, dev.donauversicherung.at, donauassicurazioni.it, donauversicherung.at
  51. Node: SELECT1
  52. ----------------------------------------
  53.  
  54. -------- Testing Misc --------
  55. Test warning message output successfully
  56.  
  57. -------- Testing Func --------
  58. Warning: Can't convert 'not a number' to number. Converting to 0.
  59. Warning: Can't convert 'hammerhead shark' to number. Converting to 0.
  60. Warning: Can't convert 'hammerhead shark' to number. Converting to 0.
  61. Warning: Can't convert 'apple' to number. Converting to 0.
  62. Warning: Invalid pattern "(?=\w))"
  63. Warning: Can't convert 'a' to number. Converting to 0.
  64. Warning: Can't convert '' to number. Converting to 0.
  65. Warning: Problem parsing date string "Jun 2, 2012 6:00:30 PM" using pattern "badpattern". Returning NULL.
  66. Warning: Problem parsing date string "3/27/1994 00" using pattern "mm/dd/yyyy hh". Returning NULL.
  67. Warning: Problem parsing date string "Jan 12th, 2012th" using pattern "mon dd, yyyy". Returning NULL.
  68. Warning: Problem parsing date string "Aaa 2, 2012 6:00:30 AM EDT" using pattern "xd2 xt2 tzd". Returning NULL.
  69. Warning: Problem parsing date string "Jun 2, 2012 6:00:30" using pattern "xd2 xt2". Returning NULL.
  70. Warning: Problem parsing date string "01-16, 1959" using pattern "mm-dd yyyy". Returning NULL.
  71. Warning: Can't convert 'not a number' to number. Converting to 0.
  72.  
  73. -------- Testing Parser --------
  74. <f.182>:2:24: Trying to find one of r"\[", r"{", OPS_MULT, OPS_ADD, OPS_SHIFT, OPS_COMP, "(?i)not", "(?i)case", "(?i)containing", "(?i)matching", "(?i)umatching", "(?i)is", OPS_BWISE, "(?i)and", "(?i)or", r"\.\.\.", "(?i)AS", r"\]", r"}", ":", r"\)", ",", r"(?i)CONVERTING\s+FROM", r"(?i)CONVERTING\s+TO", r"(?i)CONVERTING\s+AS", r"(?i)CONVERT\s+USING", r"(?i)POOL\s+BY", r"(?i)PRIORITIZE\s+BY", r"(?i)FOLLOWING\s+IF", r"(?i)TO\s+DEPTH", "(?i)POST", "(?i)SUBMITTING", r"(?i)CACHE\s+FORMS", r"(?i)FORGET\s+FORMS", r"(?i)CLEAR\s+FORMS", r"(?i)FORGET\s+COOKIES", r"(?i)ADDING\s+COOKIE", "(?i)ADDING\s+HEADER", "(?i)DELAY", "(?i)TIMEOUT", "(?i)PROXY", "(?i)UNGUARDED", r"(?i)WITH\s+ERRORS", "(?i)RETRY", r"(?i)ALLOW\s+PARTIAL", r"(?i)ACCEPTING\s+ANY", "(?i)ACCEPTING", "(?i)IGNORE", "(?i)SANITIZE", "(?i)AT", "(?i)then", "(?i)FOR", "(?i)ALWAYS", "(?i)HEADER", "(?i)SPREAD", "(?i)WHERE", "(?i)FROM", "(?i)HAVING", "(?i)TERMINATE", r"(?i)GROUP\s+BY", r"(?i)SORT\s+BY", "(?i)INTO", "(?i)IF", "(?i)VALUES", "(?i)FILE", r"(?i)NOTHING\s+FOR", "(?i)BUTTON", "(?i)end", r"(?i)TO\s+FORM", r"(?i)TO\s+FORM\s+TARGET", "(?i)TO", "(?i)else", "(?i)when", "(?i)APPEND", r"(?i)DELIMIT\s+WITH", "(?i)STYLESHEET", "(?i)TRANSFORM", "(?i)ENCODING", r"(?i)WITH\s+HEADINGS", r"(?i)PARENT\s+WAIT", r"(?i)WAIT", r"(?i)UNION", r"(?i)UNION\s+JOIN", r"(?i)JOIN", r"(?i)LEFT\s+OUTER\s+JOIN", r"(?i)RIGHT\s+OUTER\s+JOIN", r"(?i)FULL\s+OUTER\s+JOIN", r"(?i)THEN\s+SUBMITTING", END, "(?i)SELECT"
  75. > select unique distinct 1
  76. > ^
  77. while parsing ops_index():
  78. > '/home/roman/work/sqg'
  79. > ^
  80. while parsing ops_unary():
  81. > '/home/roman/work/sqg'
  82. > ^
  83. while parsing ops_mult():
  84. > '/home/roman/work/sqg'
  85. > ^
  86. while parsing ops_add():
  87. > '/home/roman/work/sqg'
  88. > ^
  89. while parsing ops_shift():
  90. > '/home/roman/work/sqg'
  91. > ^
  92. while parsing ops_comp():
  93. > '/home/roman/work/sqg'
  94. > ^
  95. while parsing ops_bwise():
  96. > '/home/roman/work/sqg'
  97. > ^
  98. while parsing ops_and():
  99. > '/home/roman/work/sqg'
  100. > ^
  101. while parsing expr():
  102. > '/home/roman/work/sqg'
  103. > ^
  104. while parsing selectexpr(0, {'unique': True, 'name': 'SELECT1', 'select': []}):
  105. > '/home/roman/work/sqg'
  106. > ^
  107. while parsing node(1, [], '/home/roman/work/sqg'):
  108. > '/home/roman/work/sqg'
  109. > ^
  110. while parsing joins('/home/roman/work/sqg',):
  111. > '/home/roman/work/sqg'
  112. > ^
  113. while parsing script():
  114. > '/home/roman/work/sqg'
  115. > ^
  116. <f.183>:2:24: Trying to find one of r"\[", r"{", OPS_MULT, OPS_ADD, OPS_SHIFT, OPS_COMP, "(?i)not", "(?i)case", "(?i)containing", "(?i)matching", "(?i)umatching", "(?i)is", OPS_BWISE, "(?i)and", "(?i)or", r"\.\.\.", "(?i)AS", r"\]", r"}", ":", r"\)", ",", r"(?i)CONVERTING\s+FROM", r"(?i)CONVERTING\s+TO", r"(?i)CONVERTING\s+AS", r"(?i)CONVERT\s+USING", r"(?i)POOL\s+BY", r"(?i)PRIORITIZE\s+BY", r"(?i)FOLLOWING\s+IF", r"(?i)TO\s+DEPTH", "(?i)POST", "(?i)SUBMITTING", r"(?i)CACHE\s+FORMS", r"(?i)FORGET\s+FORMS", r"(?i)CLEAR\s+FORMS", r"(?i)FORGET\s+COOKIES", r"(?i)ADDING\s+COOKIE", "(?i)ADDING\s+HEADER", "(?i)DELAY", "(?i)TIMEOUT", "(?i)PROXY", "(?i)UNGUARDED", r"(?i)WITH\s+ERRORS", "(?i)RETRY", r"(?i)ALLOW\s+PARTIAL", r"(?i)ACCEPTING\s+ANY", "(?i)ACCEPTING", "(?i)IGNORE", "(?i)SANITIZE", "(?i)AT", "(?i)then", "(?i)FOR", "(?i)ALWAYS", "(?i)HEADER", "(?i)SPREAD", "(?i)WHERE", "(?i)FROM", "(?i)HAVING", "(?i)TERMINATE", r"(?i)GROUP\s+BY", r"(?i)SORT\s+BY", "(?i)INTO", "(?i)IF", "(?i)VALUES", "(?i)FILE", r"(?i)NOTHING\s+FOR", "(?i)BUTTON", "(?i)end", r"(?i)TO\s+FORM", r"(?i)TO\s+FORM\s+TARGET", "(?i)TO", "(?i)else", "(?i)when", "(?i)APPEND", r"(?i)DELIMIT\s+WITH", "(?i)STYLESHEET", "(?i)TRANSFORM", "(?i)ENCODING", r"(?i)WITH\s+HEADINGS", r"(?i)PARENT\s+WAIT", r"(?i)WAIT", r"(?i)UNION", r"(?i)UNION\s+JOIN", r"(?i)JOIN", r"(?i)LEFT\s+OUTER\s+JOIN", r"(?i)RIGHT\s+OUTER\s+JOIN", r"(?i)FULL\s+OUTER\s+JOIN", r"(?i)THEN\s+SUBMITTING", END, "(?i)SELECT"
  117. > select distinct unique 1
  118. > ^
  119. while parsing ops_index():
  120. > '/home/roman/work/sqg'
  121. > ^
  122. while parsing ops_unary():
  123. > '/home/roman/work/sqg'
  124. > ^
  125. while parsing ops_mult():
  126. > '/home/roman/work/sqg'
  127. > ^
  128. while parsing ops_add():
  129. > '/home/roman/work/sqg'
  130. > ^
  131. while parsing ops_shift():
  132. > '/home/roman/work/sqg'
  133. > ^
  134. while parsing ops_comp():
  135. > '/home/roman/work/sqg'
  136. > ^
  137. while parsing ops_bwise():
  138. > '/home/roman/work/sqg'
  139. > ^
  140. while parsing ops_and():
  141. > '/home/roman/work/sqg'
  142. > ^
  143. while parsing expr():
  144. > '/home/roman/work/sqg'
  145. > ^
  146. while parsing selectexpr(0, {'unique': True, 'name': 'SELECT1', 'select': []}):
  147. > '/home/roman/work/sqg'
  148. > ^
  149. while parsing node(1, [], '/home/roman/work/sqg'):
  150. > '/home/roman/work/sqg'
  151. > ^
  152. while parsing joins('/home/roman/work/sqg',):
  153. > '/home/roman/work/sqg'
  154. > ^
  155. while parsing script():
  156. > '/home/roman/work/sqg'
  157. > ^
  158. Parser warning: INTO TABLE has been deprecated. No effect.
  159. Parser warning: INTO TABLE has been deprecated. No effect.
  160. <f.218>:2:32: Trying to find one of "(?i)WITHIN"
  161. > select * from empty remove html, empty within http://test.com
  162. > ^
  163. while parsing fromopts(['SELECT1', 'TRANSLATOR1'], '/home/roman/work/sqg'):
  164. > '/home/roman/work/sqg'
  165. > ^
  166. while parsing node(1, [], '/home/roman/work/sqg'):
  167. > '/home/roman/work/sqg'
  168. > ^
  169. while parsing joins('/home/roman/work/sqg',):
  170. > '/home/roman/work/sqg'
  171. > ^
  172. while parsing script():
  173. > '/home/roman/work/sqg'
  174. > ^
  175.  
  176. -------- Testing Node --------
  177. ----------------------------------------
  178. Error: Query terminated (Message: "hello there")
  179. Node: SELECT1
  180. ----------------------------------------
  181.  
  182. -------- Testing Connector --------
  183. Warning: Number of fields in union join don't match
  184. Warning: Number of fields in union join don't match
  185. Warning: Number of fields in union join don't match
  186. Warning: OUTER JOIN performed as JOIN due to absent WHERE clause
  187. ----------------------------------------
  188. Error: OUTER JOIN must have exactly two parents
  189. Node: SELECT2
  190. ----------------------------------------
  191.  
  192. ----------------------------------------
  193. Internal Error: Can't get output columns from failed node SELECT2
  194. Node: DEFAULT
  195. ----------------------------------------
  196.  
  197. ----------------------------------------
  198. Error: OUTER JOIN must have exactly two parents
  199. Node: SELECT4
  200. ----------------------------------------
  201.  
  202. ----------------------------------------
  203. Internal Error: Can't get output columns from failed node SELECT4
  204. Node: DEFAULT
  205. ----------------------------------------
  206.  
  207.  
  208. -------- Testing Translators --------
  209. -------- Testing Output --------
  210. -------- Testing Queue --------
  211. Warning: Skipping blank URL
  212.  
  213. -------- Testing Query --------
  214. Warning: Number of fields in union join don't match
  215. ----------------------------------------
  216. Error retrieving document "http://localhost:777". Details follow:
  217. Error: Socket failed. [Errno 111] Connection refused
  218. Node: SELECT2
  219. ----------------------------------------
  220.  
  221.  
  222. *** TESTING SUCCESSFULLY COMPLETED ***
  223.  
  224. roman@D85:~/work/sqg$
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!