API tools faq
paste
Guest User

spyne_server_sqlalchemy.log

a guest
Dec 2nd, 2015
171
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 32.44 KB | None | 0 0
raw download clone embed print report
  1. DEBUG:spyne.model.complex:Got bases for ComplexModel from meta: (<class 'spyne.model.complex.ComplexModelBase'>,)
  2. DEBUG:spyne.model.complex:Got bases for Array from meta: (<class 'spyne.model.complex.ComplexModelBase'>,)
  3. DEBUG:spyne.model.complex:Got bases for Iterable from meta: (<class 'spyne.model.complex.Array'>,)
  4. DEBUG:spyne.model.complex:Got bases for Fault from meta: (<class 'spyne.model.complex.ComplexModelBase'>, <class 'Exception'>)
  5. DEBUG:spyne.model.complex:Got bases for InvalidCredentialsError from meta: (<class 'spyne.model.fault.Fault'>,)
  6. DEBUG:spyne.model.complex:Got bases for RequestTooLongError from meta: (<class 'spyne.model.fault.Fault'>,)
  7. DEBUG:spyne.model.complex:Got bases for RequestNotAllowed from meta: (<class 'spyne.model.fault.Fault'>,)
  8. DEBUG:spyne.model.complex:Got bases for ArgumentError from meta: (<class 'spyne.model.fault.Fault'>,)
  9. DEBUG:spyne.model.complex:Got bases for InvalidInputError from meta: (<class 'spyne.model.fault.Fault'>,)
  10. DEBUG:spyne.model.complex:Got bases for ValidationError from meta: (<class 'spyne.model.fault.Fault'>,)
  11. DEBUG:spyne.model.complex:Got bases for InternalError from meta: (<class 'spyne.model.fault.Fault'>,)
  12. DEBUG:spyne.model.complex:Got bases for ResourceNotFoundError from meta: (<class 'spyne.model.fault.Fault'>,)
  13. DEBUG:spyne.model.complex:Got bases for RespawnError from meta: (<class 'spyne.error.ResourceNotFoundError'>,)
  14. DEBUG:spyne.model.complex:Got bases for ResourceAlreadyExistsError from meta: (<class 'spyne.model.fault.Fault'>,)
  15. DEBUG:spyne.model.complex:Got bases for Redirect from meta: (<class 'spyne.model.fault.Fault'>,)
  16. DEBUG:spyne.model.complex:Got bases for _Value from meta: (<class 'spyne.model.complex.ComplexModel'>,)
  17. DEBUG:spyne.model.complex:Got bases for SchemaValidationError from meta: (<class 'spyne.model.fault.Fault'>,)
  18. DEBUG:spyne.model.complex:Got bases for HttpRedirect from meta: (<class 'spyne.error.Redirect'>,)
  19. DEBUG:spyne.model.complex:Got bases for SchemaBase from meta: (<class 'spyne.model.complex.ComplexModelBase'>,)
  20. DEBUG:spyne.model.complex:Got bases for Import from meta: (<class 'spyne.interface.xml_schema.defn.SchemaBase'>,)
  21. DEBUG:spyne.model.complex:Got bases for Element from meta: (<class 'spyne.interface.xml_schema.defn.SchemaBase'>,)
  22. DEBUG:spyne.model.complex:Got bases for IntegerAttribute from meta: (<class 'spyne.interface.xml_schema.defn.SchemaBase'>,)
  23. DEBUG:spyne.model.complex:Got bases for StringAttribute from meta: (<class 'spyne.interface.xml_schema.defn.SchemaBase'>,)
  24. DEBUG:spyne.model.complex:Got bases for List from meta: (<class 'spyne.interface.xml_schema.defn.SchemaBase'>,)
  25. DEBUG:spyne.model.complex:Got bases for SimpleType from meta: (<class 'spyne.interface.xml_schema.defn.SchemaBase'>,)
  26. DEBUG:spyne.model.complex:Got bases for SimpleType from orig: (<class 'spyne.interface.xml_schema.defn.SchemaBase'>,)
  27. DEBUG:spyne.model.complex:Got bases for Attribute from meta: (<class 'spyne.interface.xml_schema.defn.SchemaBase'>,)
  28. DEBUG:spyne.model.complex:Got bases for IntegerAttribute from orig: (<class 'spyne.interface.xml_schema.defn.SchemaBase'>,)
  29. DEBUG:spyne.model.complex:Got bases for IntegerAttribute from orig: (<class 'spyne.interface.xml_schema.defn.SchemaBase'>,)
  30. DEBUG:spyne.model.complex:Got bases for StringAttribute from orig: (<class 'spyne.interface.xml_schema.defn.SchemaBase'>,)
  31. DEBUG:spyne.model.complex:Got bases for Attribute from orig: (<class 'spyne.interface.xml_schema.defn.SchemaBase'>,)
  32. DEBUG:spyne.model.complex:Got bases for Restriction from meta: (<class 'spyne.interface.xml_schema.defn.SchemaBase'>,)
  33. DEBUG:spyne.model.complex:Got bases for Element from orig: (<class 'spyne.interface.xml_schema.defn.SchemaBase'>,)
  34. DEBUG:spyne.model.complex:Got bases for Choice from meta: (<class 'spyne.interface.xml_schema.defn.SchemaBase'>,)
  35. DEBUG:spyne.model.complex:Got bases for Element from orig: (<class 'spyne.interface.xml_schema.defn.SchemaBase'>,)
  36. DEBUG:spyne.model.complex:Got bases for Choice from orig: (<class 'spyne.interface.xml_schema.defn.SchemaBase'>,)
  37. DEBUG:spyne.model.complex:Got bases for Sequence from meta: (<class 'spyne.interface.xml_schema.defn.SchemaBase'>,)
  38. DEBUG:spyne.model.complex:Got bases for Attribute from orig: (<class 'spyne.interface.xml_schema.defn.SchemaBase'>,)
  39. DEBUG:spyne.model.complex:Got bases for Extension from meta: (<class 'spyne.interface.xml_schema.defn.SchemaBase'>,)
  40. DEBUG:spyne.model.complex:Got bases for SimpleContent from meta: (<class 'spyne.interface.xml_schema.defn.SchemaBase'>,)
  41. DEBUG:spyne.model.complex:Got bases for SimpleContent from orig: (<class 'spyne.interface.xml_schema.defn.SchemaBase'>,)
  42. DEBUG:spyne.model.complex:Got bases for Attribute from orig: (<class 'spyne.interface.xml_schema.defn.SchemaBase'>,)
  43. DEBUG:spyne.model.complex:Got bases for ComplexType from meta: (<class 'spyne.interface.xml_schema.defn.SchemaBase'>,)
  44. DEBUG:spyne.model.complex:Got bases for Include from meta: (<class 'spyne.interface.xml_schema.defn.SchemaBase'>,)
  45. DEBUG:spyne.model.complex:Got bases for Import from orig: (<class 'spyne.interface.xml_schema.defn.SchemaBase'>,)
  46. DEBUG:spyne.model.complex:Got bases for Include from orig: (<class 'spyne.interface.xml_schema.defn.SchemaBase'>,)
  47. DEBUG:spyne.model.complex:Got bases for Element from orig: (<class 'spyne.interface.xml_schema.defn.SchemaBase'>,)
  48. DEBUG:spyne.model.complex:Got bases for SimpleType from orig: (<class 'spyne.interface.xml_schema.defn.SchemaBase'>,)
  49. DEBUG:spyne.model.complex:Got bases for ComplexType from orig: (<class 'spyne.interface.xml_schema.defn.SchemaBase'>,)
  50. DEBUG:spyne.model.complex:Got bases for Attribute from orig: (<class 'spyne.interface.xml_schema.defn.SchemaBase'>,)
  51. DEBUG:spyne.model.complex:Got bases for XmlSchema10 from meta: (<class 'spyne.interface.xml_schema.defn.SchemaBase'>,)
  52. DEBUG:spyne.model.complex:Got bases for FileData from meta: (<class 'spyne.model.complex.ComplexModel'>,)
  53. DEBUG:spyne.model.complex:Got bases for TableModel from meta: (<class 'spyne.model.complex.TTableModelBase.<locals>.TableModelBase'>,)
  54. DEBUG:spyne.model.complex:Got bases for Permission from meta: (<class 'spyne.model.complex.TableModel'>,)
  55. DEBUG:spyne.model.complex:Got bases for Array from orig: (<class 'spyne.model.complex.ComplexModelBase'>,)
  56. DEBUG:spyne.model.complex:Got bases for Permission from orig: (<class 'spyne.model.complex.TableModel'>,)
  57. DEBUG:spyne.model.complex:Got bases for Array from orig: (<class 'spyne.model.complex.ComplexModelBase'>,)
  58. DEBUG:spyne.model.complex:Got bases for User from meta: (<class 'spyne.model.complex.TableModel'>,)
  59. DEBUG:spyne.model.complex:Got bases for Iterable from orig: (<class 'spyne.model.complex.Array'>,)
  60. DEBUG:spyne.model.complex:Got bases for Permission from orig: (<class 'spyne.model.complex.TableModel'>,)
  61. DEBUG:spyne.model.complex:Got bases for Iterable from orig: (<class 'spyne.model.complex.Array'>,)
  62. DEBUG:spyne.model.complex:Got bases for User from orig: (<class 'spyne.model.complex.TableModel'>,)
  63. DEBUG:spyne.model.complex:Got bases for put_permission from meta: (<class 'spyne.model.complex.ComplexModel'>,)
  64. DEBUG:spyne.model.complex:Got bases for put_permissionResponse from meta: (<class 'spyne.model.complex.ComplexModel'>,)
  65. DEBUG:spyne.model.complex:Got bases for put_user from meta: (<class 'spyne.model.complex.ComplexModel'>,)
  66. DEBUG:spyne.model.complex:Got bases for put_userResponse from meta: (<class 'spyne.model.complex.ComplexModel'>,)
  67. DEBUG:spyne.model.complex:Got bases for del_user from meta: (<class 'spyne.model.complex.ComplexModel'>,)
  68. DEBUG:spyne.model.complex:Got bases for del_userResponse from meta: (<class 'spyne.model.complex.ComplexModel'>,)
  69. DEBUG:spyne.model.complex:Got bases for get_all_permission from meta: (<class 'spyne.model.complex.ComplexModel'>,)
  70. DEBUG:spyne.model.complex:Got bases for get_all_permissionResponse from meta: (<class 'spyne.model.complex.ComplexModel'>,)
  71. DEBUG:spyne.model.complex:Got bases for get_all_user from meta: (<class 'spyne.model.complex.ComplexModel'>,)
  72. DEBUG:spyne.model.complex:Got bases for get_all_userResponse from meta: (<class 'spyne.model.complex.ComplexModel'>,)
  73. DEBUG:spyne.model.complex:Got bases for get_user from meta: (<class 'spyne.model.complex.ComplexModel'>,)
  74. DEBUG:spyne.model.complex:Got bases for get_userResponse from meta: (<class 'spyne.model.complex.ComplexModel'>,)
  75. DEBUG:spyne.model.complex:Got bases for get_permission from meta: (<class 'spyne.model.complex.ComplexModel'>,)
  76. DEBUG:spyne.model.complex:Got bases for get_permissionResponse from meta: (<class 'spyne.model.complex.ComplexModel'>,)
  77. DEBUG:spyne.interface._base:populating '__main__.UserManagerService ({spyne.examples.user_manager}UserManagerService)' types...
  78. DEBUG:spyne.interface._base: enumerating classes for method 'del_user'
  79. DEBUG:spyne.interface._base: adding class "<class 'spyne.model.complex.del_user'>" for '{spyne.examples.user_manager}del_user'
  80. DEBUG:spyne.interface._base: adding del_user.user_id = <class 'spyne.model.primitive.number._BoundedUnsignedInteger'>
  81. DEBUG:spyne.interface._base: adding class "<class 'spyne.model.primitive.number._BoundedUnsignedInteger'>" for '{http://www.w3.org/2001/XMLSchema}unsignedInt'
  82. DEBUG:spyne.interface._base: adding class "<class 'spyne.model.complex.del_userResponse'>" for '{spyne.examples.user_manager}del_userResponse'
  83. DEBUG:spyne.interface._base: enumerating classes for method 'put_user'
  84. DEBUG:spyne.interface._base: adding class "<class 'spyne.model.complex.put_user'>" for '{spyne.examples.user_manager}put_user'
  85. DEBUG:spyne.interface._base: adding put_user.user = <class '__main__.User'>
  86. DEBUG:spyne.interface._base: adding class "<class '__main__.User'>" for '{spyne.examples.user_manager}User'
  87. DEBUG:spyne.interface._base: adding User.user_name = <class 'spyne.model.primitive.string.Unicode'>
  88. DEBUG:spyne.interface._base: adding class "<class 'spyne.model.primitive.string.Unicode'>" for '{spyne.examples.user_manager}User_user_nameType'
  89. DEBUG:spyne.interface._base: adding class "<class 'spyne.model.primitive.string.Unicode'>" for '{http://www.w3.org/2001/XMLSchema}string'
  90. DEBUG:spyne.interface._base: adding User.permissions = <class 'spyne.model.complex.Array'>
  91. DEBUG:spyne.interface._base: adding class "<class 'spyne.model.complex.Array'>" for '{spyne.examples.user_manager}PermissionArray'
  92. DEBUG:spyne.interface._base: adding PermissionArray.Permission = <class '__main__.Permission'>
  93. DEBUG:spyne.interface._base: adding class "<class '__main__.Permission'>" for '{spyne.examples.user_manager}Permission'
  94. DEBUG:spyne.interface._base: adding Permission.operation = <class 'spyne.model.primitive.string.Unicode'>
  95. DEBUG:spyne.interface._base: adding class "<class 'spyne.model.primitive.string.Unicode'>" for '{spyne.examples.user_manager}Permission_operationType'
  96. DEBUG:spyne.interface._base: adding Permission.id = <class 'spyne.model.primitive.number._BoundedUnsignedInteger'>
  97. DEBUG:spyne.interface._base: adding Permission.application = <class 'spyne.model.primitive.string.Unicode'>
  98. DEBUG:spyne.interface._base: adding class "<class 'spyne.model.primitive.string.Unicode'>" for '{spyne.examples.user_manager}Permission_applicationType'
  99. DEBUG:spyne.interface._base: adding User.id = <class 'spyne.model.primitive.number._BoundedUnsignedInteger'>
  100. DEBUG:spyne.interface._base: adding User.email = <class 'spyne.model.primitive.string.Unicode'>
  101. DEBUG:spyne.interface._base: adding class "<class 'spyne.model.primitive.string.Unicode'>" for '{spyne.examples.user_manager}User_emailType'
  102. DEBUG:spyne.interface._base: adding User.full_name = <class 'spyne.model.primitive.string.Unicode'>
  103. DEBUG:spyne.interface._base: adding class "<class 'spyne.model.primitive.string.Unicode'>" for '{spyne.examples.user_manager}User_full_nameType'
  104. DEBUG:spyne.interface._base: adding class "<class 'spyne.model.complex.put_userResponse'>" for '{spyne.examples.user_manager}put_userResponse'
  105. DEBUG:spyne.interface._base: adding put_userResponse.put_userResult = <class 'spyne.model.primitive.number.TBoundedUnsignedInteger.<locals>._BoundedUnsignedInteger'>
  106. DEBUG:spyne.interface._base: enumerating classes for method 'put_permission'
  107. DEBUG:spyne.interface._base: adding class "<class 'spyne.model.complex.put_permission'>" for '{spyne.examples.user_manager}put_permission'
  108. DEBUG:spyne.interface._base: adding put_permission.permission = <class '__main__.Permission'>
  109. DEBUG:spyne.interface._base: adding class "<class 'spyne.model.complex.put_permissionResponse'>" for '{spyne.examples.user_manager}put_permissionResponse'
  110. DEBUG:spyne.interface._base: adding put_permissionResponse.put_permissionResult = <class 'spyne.model.primitive.number.TBoundedUnsignedInteger.<locals>._BoundedUnsignedInteger'>
  111. DEBUG:spyne.interface._base: enumerating classes for method 'get_all_permission'
  112. DEBUG:spyne.interface._base: adding class "<class 'spyne.model.complex.get_all_permission'>" for '{spyne.examples.user_manager}get_all_permission'
  113. DEBUG:spyne.interface._base: adding class "<class 'spyne.model.complex.get_all_permissionResponse'>" for '{spyne.examples.user_manager}get_all_permissionResponse'
  114. DEBUG:spyne.interface._base: adding get_all_permissionResponse.get_all_permissionResult = <class 'spyne.model.complex.Iterable'>
  115. DEBUG:spyne.interface._base: enumerating classes for method 'get_all_user'
  116. DEBUG:spyne.interface._base: adding class "<class 'spyne.model.complex.get_all_user'>" for '{spyne.examples.user_manager}get_all_user'
  117. DEBUG:spyne.interface._base: adding class "<class 'spyne.model.complex.get_all_userResponse'>" for '{spyne.examples.user_manager}get_all_userResponse'
  118. DEBUG:spyne.interface._base: adding get_all_userResponse.get_all_userResult = <class 'spyne.model.complex.Iterable'>
  119. DEBUG:spyne.interface._base: adding class "<class 'spyne.model.complex.Iterable'>" for '{spyne.examples.user_manager}UserArray'
  120. DEBUG:spyne.interface._base: adding UserArray.User = <class '__main__.User'>
  121. DEBUG:spyne.interface._base: enumerating classes for method 'get_user'
  122. DEBUG:spyne.interface._base: adding class "<class 'spyne.model.complex.get_user'>" for '{spyne.examples.user_manager}get_user'
  123. DEBUG:spyne.interface._base: adding get_user.user_id = <class 'spyne.model.primitive.number._BoundedUnsignedInteger'>
  124. DEBUG:spyne.interface._base: adding class "<class 'spyne.model.complex.get_userResponse'>" for '{spyne.examples.user_manager}get_userResponse'
  125. DEBUG:spyne.interface._base: adding get_userResponse.get_userResult = <class '__main__.User'>
  126. DEBUG:spyne.interface._base: enumerating classes for method 'get_permission'
  127. DEBUG:spyne.interface._base: adding class "<class 'spyne.model.complex.get_permission'>" for '{spyne.examples.user_manager}get_permission'
  128. DEBUG:spyne.interface._base: adding get_permission.permission_id = <class 'spyne.model.primitive.number._BoundedUnsignedInteger'>
  129. DEBUG:spyne.interface._base: adding class "<class 'spyne.model.complex.get_permissionResponse'>" for '{spyne.examples.user_manager}get_permissionResponse'
  130. DEBUG:spyne.interface._base: adding get_permissionResponse.get_permissionResult = <class '__main__.Permission'>
  131. DEBUG:spyne.interface._base:populating '__main__.UserManagerService' routes...
  132. DEBUG:spyne.interface._base: adding method UserManagerService.del_user to match '{spyne.examples.user_manager}del_user' tag.
  133. DEBUG:spyne.interface._base: adding method UserManagerService.put_user to match '{spyne.examples.user_manager}put_user' tag.
  134. DEBUG:spyne.interface._base: adding method UserManagerService.put_permission to match '{spyne.examples.user_manager}put_permission' tag.
  135. DEBUG:spyne.interface._base: adding method UserManagerService.get_all_permission to match '{spyne.examples.user_manager}get_all_permission' tag.
  136. DEBUG:spyne.interface._base: adding method UserManagerService.get_all_user to match '{spyne.examples.user_manager}get_all_user' tag.
  137. DEBUG:spyne.interface._base: adding method UserManagerService.get_user to match '{spyne.examples.user_manager}get_user' tag.
  138. DEBUG:spyne.interface._base: adding method UserManagerService.get_permission to match '{spyne.examples.user_manager}get_permission' tag.
  139. DEBUG:spyne.interface._base:From this point on, you're not supposed to make any changes to the class and method structure of the exposed services.
  140. DEBUG:spyne.interface.xml_schema:generating schema for targetNamespace='spyne.examples.user_manager', prefix: 'tns' in dir 'C:\\Users\\GOUTHA~1\\AppData\\Local\\Temp\\spyneh0ajw52z'
  141. DEBUG:spyne.interface.xml_schema:writing 'C:\\Users\\GOUTHA~1\\AppData\\Local\\Temp\\spyneh0ajw52z\\tns.xsd' for ns spyne.examples.user_manager
  142. DEBUG:spyne.interface.xml_schema:Schema built. Removed 'C:\\Users\\GOUTHA~1\\AppData\\Local\\Temp\\spyneh0ajw52z'
  143. DEBUG:spyne.util.appreg:Registering <__main__.MyApplication object at 0x000000000549B5C0> as ('spyne.examples.user_manager', 'MyApplication')
  144. INFO:sqlalchemy.engine.base.Engine:SELECT CAST('test plain returns' AS VARCHAR(60)) AS anon_1
  145. INFO:sqlalchemy.engine.base.Engine:()
  146. INFO:sqlalchemy.engine.base.Engine:SELECT CAST('test unicode returns' AS VARCHAR(60)) AS anon_1
  147. INFO:sqlalchemy.engine.base.Engine:()
  148. INFO:sqlalchemy.engine.base.Engine:PRAGMA table_info("permission")
  149. INFO:sqlalchemy.engine.base.Engine:()
  150. INFO:sqlalchemy.engine.base.Engine:PRAGMA table_info("user")
  151. INFO:sqlalchemy.engine.base.Engine:()
  152. INFO:sqlalchemy.engine.base.Engine:PRAGMA table_info("user_permissions")
  153. INFO:sqlalchemy.engine.base.Engine:()
  154. INFO:sqlalchemy.engine.base.Engine:
  155. CREATE TABLE permission (
  156. operation TEXT,
  157. id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
  158. application TEXT
  159. )
  160.  
  161.  
  162. INFO:sqlalchemy.engine.base.Engine:()
  163. INFO:sqlalchemy.engine.base.Engine:COMMIT
  164. INFO:sqlalchemy.engine.base.Engine:
  165. CREATE TABLE user (
  166. user_name VARCHAR(32),
  167. id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
  168. email VARCHAR(64),
  169. full_name VARCHAR(64)
  170. )
  171.  
  172.  
  173. INFO:sqlalchemy.engine.base.Engine:()
  174. INFO:sqlalchemy.engine.base.Engine:COMMIT
  175. INFO:sqlalchemy.engine.base.Engine:
  176. CREATE TABLE user_permissions (
  177. user_id INTEGER,
  178. permissions_id INTEGER,
  179. PRIMARY KEY (user_id, permissions_id),
  180. FOREIGN KEY(user_id) REFERENCES user (id),
  181. CONSTRAINT permission_permissions_id_fkey FOREIGN KEY(permissions_id) REFERENCES permission (id)
  182. )
  183.  
  184.  
  185. INFO:sqlalchemy.engine.base.Engine:()
  186. INFO:sqlalchemy.engine.base.Engine:COMMIT
  187. INFO:root:listening to http://127.0.0.1:8000
  188. INFO:root:wsdl is at: http://localhost:8000/?wsdl
  189. 127.0.0.1 - - [02/Dec/2015 16:24:15] "GET /?wsdl HTTP/1.1" 200 11492
  190. DEBUG:spyne.protocol.soap.soap11:ValueError: Deserializing from unicode strings with encoding declaration is not supported by lxml.
  191. DEBUG:spyne.protocol.xml:Validated ? True
  192. DEBUG:spyne.protocol.xml:Method request string: {spyne.examples.user_manager}put_permission
  193. DEBUG:spyne.protocol.xml:b'<SOAP-ENV:Envelope xmlns:ns0="spyne.examples.user_manager" xmlns:ns1="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/">\n <SOAP-ENV:Header/>\n <ns1:Body>\n <ns0:put_permission>\n <ns0:permission>\n <ns0:operation>modify</ns0:operation>\n <ns0:application>usermgr</ns0:application>\n </ns0:permission>\n </ns0:put_permission>\n </ns1:Body>\n</SOAP-ENV:Envelope>\n'
  194. INFO:sqlalchemy.engine.base.Engine:BEGIN (implicit)
  195. INFO:sqlalchemy.engine.base.Engine:INSERT INTO permission (operation, application) VALUES (?, ?)
  196. INFO:sqlalchemy.engine.base.Engine:('modify', 'usermgr')
  197. DEBUG:spyne.protocol.xml:Response b'<soap11env:Envelope xmlns:soap11env="http://schemas.xmlsoap.org/soap/envelope/" xmlns:tns="spyne.examples.user_manager">\n <soap11env:Body>\n <tns:put_permissionResponse>\n <tns:put_permissionResult>1</tns:put_permissionResult>\n </tns:put_permissionResponse>\n </soap11env:Body>\n</soap11env:Envelope>\n'
  198. INFO:sqlalchemy.engine.base.Engine:COMMIT
  199. 127.0.0.1 - - [02/Dec/2015 16:24:51] "POST / HTTP/1.1" 200 324
  200. DEBUG:spyne.protocol.soap.soap11:ValueError: Deserializing from unicode strings with encoding declaration is not supported by lxml.
  201. DEBUG:spyne.protocol.xml:Validated ? True
  202. DEBUG:spyne.protocol.xml:Method request string: {spyne.examples.user_manager}put_permission
  203. DEBUG:spyne.protocol.xml:b'<SOAP-ENV:Envelope xmlns:ns0="spyne.examples.user_manager" xmlns:ns1="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/">\n <SOAP-ENV:Header/>\n <ns1:Body>\n <ns0:put_permission>\n <ns0:permission>\n <ns0:operation>read</ns0:operation>\n <ns0:application>accountmgr</ns0:application>\n </ns0:permission>\n </ns0:put_permission>\n </ns1:Body>\n</SOAP-ENV:Envelope>\n'
  204. INFO:sqlalchemy.engine.base.Engine:BEGIN (implicit)
  205. INFO:sqlalchemy.engine.base.Engine:INSERT INTO permission (operation, application) VALUES (?, ?)
  206. INFO:sqlalchemy.engine.base.Engine:('read', 'accountmgr')
  207. DEBUG:spyne.protocol.xml:Response b'<soap11env:Envelope xmlns:soap11env="http://schemas.xmlsoap.org/soap/envelope/" xmlns:tns="spyne.examples.user_manager">\n <soap11env:Body>\n <tns:put_permissionResponse>\n <tns:put_permissionResult>2</tns:put_permissionResult>\n </tns:put_permissionResponse>\n </soap11env:Body>\n</soap11env:Envelope>\n'
  208. INFO:sqlalchemy.engine.base.Engine:COMMIT
  209. 127.0.0.1 - - [02/Dec/2015 16:25:38] "POST / HTTP/1.1" 200 324
  210. DEBUG:spyne.protocol.soap.soap11:ValueError: Deserializing from unicode strings with encoding declaration is not supported by lxml.
  211. DEBUG:spyne.protocol.xml:Validated ? True
  212. DEBUG:spyne.protocol.xml:Method request string: {spyne.examples.user_manager}put_user
  213. DEBUG:spyne.protocol.xml:b'<SOAP-ENV:Envelope xmlns:ns0="spyne.examples.user_manager" xmlns:ns1="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/">\n <SOAP-ENV:Header/>\n <ns1:Body>\n <ns0:put_user>\n <ns0:user>\n <ns0:user_name>abcd</ns0:user_name>\n <ns0:permissions>\n <ns0:Permission>\n <ns0:operation>modify</ns0:operation>\n <ns0:id>1</ns0:id>\n <ns0:application>usermgr</ns0:application>\n </ns0:Permission>\n <ns0:Permission>\n <ns0:operation>read</ns0:operation>\n <ns0:id>2</ns0:id>\n <ns0:application>accountmgr</ns0:application>\n </ns0:Permission>\n </ns0:permissions>\n <ns0:email>[email protected]</ns0:email>\n <ns0:full_name>abcd xyz</ns0:full_name>\n </ns0:user>\n </ns0:put_user>\n </ns1:Body>\n</SOAP-ENV:Envelope>\n'
  214. INFO:sqlalchemy.engine.base.Engine:BEGIN (implicit)
  215. INFO:sqlalchemy.engine.base.Engine:INSERT INTO permission (operation, id, application) VALUES (?, ?, ?)
  216. INFO:sqlalchemy.engine.base.Engine:(('modify', 1, 'usermgr'), ('read', 2, 'accountmgr'))
  217. INFO:sqlalchemy.engine.base.Engine:ROLLBACK
  218. ERROR:root:(sqlite3.IntegrityError) UNIQUE constraint failed: permission.id [SQL: 'INSERT INTO permission (operation, id, application) VALUES (?, ?, ?)'] [parameters: (('modify', 1, 'usermgr'), ('read', 2, 'accountmgr'))]
  219. Traceback (most recent call last):
  220. File "C:\Python34\lib\site-packages\sqlalchemy\engine\base.py", line 1116, in _execute_context
  221. context)
  222. File "C:\Python34\lib\site-packages\sqlalchemy\engine\default.py", line 447, in do_executemany
  223. cursor.executemany(statement, parameters)
  224. sqlite3.IntegrityError: UNIQUE constraint failed: permission.id
  225.  
  226. The above exception was the direct cause of the following exception:
  227.  
  228. Traceback (most recent call last):
  229. File "D:\Projects\urpy\server_sqlalchemy2.py", line 180, in call_wrapper
  230. return ctx.service_class.call_wrapper(ctx)
  231. File "C:\Python34\lib\site-packages\spyne\service.py", line 209, in call_wrapper
  232. return ctx.function(ctx, *args)
  233. File "D:\Projects\urpy\server_sqlalchemy2.py", line 118, in put_user
  234. ctx.udc.session.flush() # so that we get the user.id value
  235. File "C:\Python34\lib\site-packages\sqlalchemy\orm\session.py", line 2015, in flush
  236. self._flush(objects)
  237. File "C:\Python34\lib\site-packages\sqlalchemy\orm\session.py", line 2133, in _flush
  238. transaction.rollback(_capture_exception=True)
  239. File "C:\Python34\lib\site-packages\sqlalchemy\util\langhelpers.py", line 60, in __exit__
  240. compat.reraise(exc_type, exc_value, exc_tb)
  241. File "C:\Python34\lib\site-packages\sqlalchemy\util\compat.py", line 182, in reraise
  242. raise value
  243. File "C:\Python34\lib\site-packages\sqlalchemy\orm\session.py", line 2097, in _flush
  244. flush_context.execute()
  245. File "C:\Python34\lib\site-packages\sqlalchemy\orm\unitofwork.py", line 373, in execute
  246. rec.execute(self)
  247. File "C:\Python34\lib\site-packages\sqlalchemy\orm\unitofwork.py", line 532, in execute
  248. uow
  249. File "C:\Python34\lib\site-packages\sqlalchemy\orm\persistence.py", line 174, in save_obj
  250. mapper, table, insert)
  251. File "C:\Python34\lib\site-packages\sqlalchemy\orm\persistence.py", line 752, in _emit_insert_statements
  252. execute(statement, multiparams)
  253. File "C:\Python34\lib\site-packages\sqlalchemy\engine\base.py", line 914, in execute
  254. return meth(self, multiparams, params)
  255. File "C:\Python34\lib\site-packages\sqlalchemy\sql\elements.py", line 323, in _execute_on_connection
  256. return connection._execute_clauseelement(self, multiparams, params)
  257. File "C:\Python34\lib\site-packages\sqlalchemy\engine\base.py", line 1010, in _execute_clauseelement
  258. compiled_sql, distilled_params
  259. File "C:\Python34\lib\site-packages\sqlalchemy\engine\base.py", line 1146, in _execute_context
  260. context)
  261. File "C:\Python34\lib\site-packages\sqlalchemy\engine\base.py", line 1341, in _handle_dbapi_exception
  262. exc_info
  263. File "C:\Python34\lib\site-packages\sqlalchemy\util\compat.py", line 188, in raise_from_cause
  264. reraise(type(exception), exception, tb=exc_tb, cause=exc_value)
  265. File "C:\Python34\lib\site-packages\sqlalchemy\util\compat.py", line 181, in reraise
  266. raise value.with_traceback(tb)
  267. File "C:\Python34\lib\site-packages\sqlalchemy\engine\base.py", line 1116, in _execute_context
  268. context)
  269. File "C:\Python34\lib\site-packages\sqlalchemy\engine\default.py", line 447, in do_executemany
  270. cursor.executemany(statement, parameters)
  271. sqlalchemy.exc.IntegrityError: (sqlite3.IntegrityError) UNIQUE constraint failed: permission.id [SQL: 'INSERT INTO permission (operation, id, application) VALUES (?, ?, ?)'] [parameters: (('modify', 1, 'usermgr'), ('read', 2, 'accountmgr'))]
  272. ERROR:spyne.application:Fault(Server: 'InternalError: An unknown error has occured.')
  273. Traceback (most recent call last):
  274. File "C:\Python34\lib\site-packages\sqlalchemy\engine\base.py", line 1116, in _execute_context
  275. context)
  276. File "C:\Python34\lib\site-packages\sqlalchemy\engine\default.py", line 447, in do_executemany
  277. cursor.executemany(statement, parameters)
  278. sqlite3.IntegrityError: UNIQUE constraint failed: permission.id
  279.  
  280. The above exception was the direct cause of the following exception:
  281.  
  282. Traceback (most recent call last):
  283. File "D:\Projects\urpy\server_sqlalchemy2.py", line 180, in call_wrapper
  284. return ctx.service_class.call_wrapper(ctx)
  285. File "C:\Python34\lib\site-packages\spyne\service.py", line 209, in call_wrapper
  286. return ctx.function(ctx, *args)
  287. File "D:\Projects\urpy\server_sqlalchemy2.py", line 118, in put_user
  288. ctx.udc.session.flush() # so that we get the user.id value
  289. File "C:\Python34\lib\site-packages\sqlalchemy\orm\session.py", line 2015, in flush
  290. self._flush(objects)
  291. File "C:\Python34\lib\site-packages\sqlalchemy\orm\session.py", line 2133, in _flush
  292. transaction.rollback(_capture_exception=True)
  293. File "C:\Python34\lib\site-packages\sqlalchemy\util\langhelpers.py", line 60, in __exit__
  294. compat.reraise(exc_type, exc_value, exc_tb)
  295. File "C:\Python34\lib\site-packages\sqlalchemy\util\compat.py", line 182, in reraise
  296. raise value
  297. File "C:\Python34\lib\site-packages\sqlalchemy\orm\session.py", line 2097, in _flush
  298. flush_context.execute()
  299. File "C:\Python34\lib\site-packages\sqlalchemy\orm\unitofwork.py", line 373, in execute
  300. rec.execute(self)
  301. File "C:\Python34\lib\site-packages\sqlalchemy\orm\unitofwork.py", line 532, in execute
  302. uow
  303. File "C:\Python34\lib\site-packages\sqlalchemy\orm\persistence.py", line 174, in save_obj
  304. mapper, table, insert)
  305. File "C:\Python34\lib\site-packages\sqlalchemy\orm\persistence.py", line 752, in _emit_insert_statements
  306. execute(statement, multiparams)
  307. File "C:\Python34\lib\site-packages\sqlalchemy\engine\base.py", line 914, in execute
  308. return meth(self, multiparams, params)
  309. File "C:\Python34\lib\site-packages\sqlalchemy\sql\elements.py", line 323, in _execute_on_connection
  310. return connection._execute_clauseelement(self, multiparams, params)
  311. File "C:\Python34\lib\site-packages\sqlalchemy\engine\base.py", line 1010, in _execute_clauseelement
  312. compiled_sql, distilled_params
  313. File "C:\Python34\lib\site-packages\sqlalchemy\engine\base.py", line 1146, in _execute_context
  314. context)
  315. File "C:\Python34\lib\site-packages\sqlalchemy\engine\base.py", line 1341, in _handle_dbapi_exception
  316. exc_info
  317. File "C:\Python34\lib\site-packages\sqlalchemy\util\compat.py", line 188, in raise_from_cause
  318. reraise(type(exception), exception, tb=exc_tb, cause=exc_value)
  319. File "C:\Python34\lib\site-packages\sqlalchemy\util\compat.py", line 181, in reraise
  320. raise value.with_traceback(tb)
  321. File "C:\Python34\lib\site-packages\sqlalchemy\engine\base.py", line 1116, in _execute_context
  322. context)
  323. File "C:\Python34\lib\site-packages\sqlalchemy\engine\default.py", line 447, in do_executemany
  324. cursor.executemany(statement, parameters)
  325. sqlalchemy.exc.IntegrityError: (sqlite3.IntegrityError) UNIQUE constraint failed: permission.id [SQL: 'INSERT INTO permission (operation, id, application) VALUES (?, ?, ?)'] [parameters: (('modify', 1, 'usermgr'), ('read', 2, 'accountmgr'))]
  326.  
  327. During handling of the above exception, another exception occurred:
  328.  
  329. Traceback (most recent call last):
  330. File "C:\Python34\lib\site-packages\spyne\application.py", line 151, in process_request
  331. ctx.out_object = self.call_wrapper(ctx)
  332. File "D:\Projects\urpy\server_sqlalchemy2.py", line 191, in call_wrapper
  333. raise InternalError(e)
  334. spyne.error.InternalError: Fault(Server: 'InternalError: An unknown error has occured.')
  335. DEBUG:spyne.protocol.xml:Response b'<soap11env:Envelope xmlns:soap11env="http://schemas.xmlsoap.org/soap/envelope/">\n <soap11env:Body>\n <soap11env:Fault>\n <faultcode>soap11env:Server</faultcode>\n <faultstring>InternalError: An unknown error has occured.</faultstring>\n <faultactor></faultactor>\n </soap11env:Fault>\n </soap11env:Body>\n</soap11env:Envelope>\n'
  336. Traceback (most recent call last):
  337. File "C:\Python34\lib\wsgiref\handlers.py", line 137, in run
  338. self.result = application(self.environ, self.start_response)
  339. File "C:\Python34\lib\site-packages\spyne\server\wsgi.py", line 244, in __call__
  340. return self.handle_rpc(req_env, start_response)
  341. File "C:\Python34\lib\site-packages\spyne\server\wsgi.py", line 365, in handle_rpc
  342. start_response)
  343. File "C:\Python34\lib\site-packages\spyne\server\wsgi.py", line 339, in handle_error
  344. return itertools.chain(p_ctx.out_string, self.__finalize(p_ctx))
  345. File "C:\Python34\lib\site-packages\spyne\server\wsgi.py", line 447, in __finalize
  346. p_ctx.close()
  347. File "C:\Python34\lib\site-packages\spyne\_base.py", line 381, in close
  348. self.app.event_manager.fire_event("method_context_closed", self)
  349. File "C:\Python34\lib\site-packages\spyne\_base.py", line 613, in fire_event
  350. handler(ctx, *args, **kwargs)
  351. File "D:\Projects\urpy\server_sqlalchemy2.py", line 164, in _on_method_context_closed
  352. ctx.udc.session.commit()
  353. File "C:\Python34\lib\site-packages\sqlalchemy\orm\session.py", line 801, in commit
  354. self.transaction.commit()
  355. File "C:\Python34\lib\site-packages\sqlalchemy\orm\session.py", line 390, in commit
  356. self._assert_active(prepared_ok=True)
  357. File "C:\Python34\lib\site-packages\sqlalchemy\orm\session.py", line 214, in _assert_active
  358. % self._rollback_exception
  359. sqlalchemy.exc.InvalidRequestError: This Session's transaction has been rolled back due to a previous exception during flush. To begin a new transaction with this Session, first issue Session.rollback(). Original exception was: (sqlite3.IntegrityError) UNIQUE constraint failed: permission.id [SQL: 'INSERT INTO permission (operation, id, application) VALUES (?, ?, ?)'] [parameters: (('modify', 1, 'usermgr'), ('read', 2, 'accountmgr'))]
  360. 127.0.0.1 - - [02/Dec/2015 16:26:45] "POST / HTTP/1.1" 500 59
Add Comment
Please, Sign In to add comment
Public Pastes
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!