|
From: SourceForge.net <no...@so...> - 2009-10-21 13:10:03
|
Patches item #2883211, was opened at 2009-10-21 08:10 Message generated for change (Tracker Item Submitted) made by mdomsch You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=540674&aid=2883211&group_id=74338 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: None Group: None Status: Open Resolution: None Priority: 5 Private: No Submitted By: Matt Domsch (mdomsch) Assigned to: Nobody/Anonymous (nobody) Summary: executing scripts with sqlite backend Initial Comment: When trying to execute a multi-line sql script using sqlobject-admin upgrade, sqlobject fails Traceback (most recent call last): File "/usr/bin/tg-admin", line 8, in <module> load_entry_point('TurboGears==1.0.8', 'console_scripts', 'tg-admin')() File "/usr/lib/python2.5/site-packages/turbogears/command/base.py", line 400, in main command.run() File "/usr/lib/python2.5/site-packages/turbogears/command/base.py", line 138, in run command.the_runner.run(sys.argv) File "/usr/lib/python2.5/site-packages/sqlobject/manager/command.py", line 101, in run runner.run() File "/usr/lib/python2.5/site-packages/sqlobject/manager/command.py", line 307, in run self.command() File "/usr/lib/python2.5/site-packages/sqlobject/manager/command.py", line 1191, in command conn.query(sql) File "/usr/lib/python2.5/site-packages/sqlobject/dbconnection.py", line 337, in query return self._runWithConnection(self._query, s) File "/usr/lib/python2.5/site-packages/sqlobject/dbconnection.py", line 250, in _runWithConnection val = meth(conn, *args) File "/usr/lib/python2.5/site-packages/sqlobject/dbconnection.py", line 334, in _query self._executeRetry(conn, conn.cursor(), s) File "/usr/lib/python2.5/site-packages/sqlobject/sqlite/sqliteconnection.py", line 197, in _executeRetry raise Warning(ErrorMessage(e)) sqlobject.dberrors.Warning: You can only execute one statement at a time. However, for updating database schemas, I need to be able to execute more than one statement at a time. Patch attached looks at the query string for multiple lines, and if so, calls executescript() instead of execute(). ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=540674&aid=2883211&group_id=74338 |
