Thanks. That all sounds like what I am looking for. I'm using sqlite3 
for my backend (with Windows 7, python 2.7, wxpython 2.9, 
SQLObject-1.0.0-py2.6).

Tim
>     Plain old SQL and perhaps tricky one. Can I ask - what backend
> do you use, MySQL?
>> Can I issue SQL commands to my database through
>> SQLObject? Thanks again for your help.
>     Yes, from a script or even from python interactive prompt. Just open
> your connection the way you do in your programs and call
> connection.query() or connection.queryAll(). Examples:
>
> from sqlobject import connectionForURI
> connection = connectionForURI('mysql://...')
> print connection.queryAll('SHOW INDEX FOR sentence')
> connection.query('DROP INDEX sentence_video_unique')
>
> Oleg.

------------------------------------------------------------------------------
AppSumo Presents a FREE Video for the SourceForge Community by Eric 
Ries, the creator of the Lean Startup Methodology on "Lean Startup 
Secrets Revealed." This video shows you how to validate your ideas, 
optimize your ideas and identify your business strategy.
http://p.sf.net/sfu/appsumosfdev2dev
_______________________________________________
sqlobject-discuss mailing list
sqlobject-discuss@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss

Reply via email to