[wxPython-users] Slightly OT: PySqlite

[Werner F. Bruhin]

Hi Jorgen,

I don't use Sqlite, I use Firebird and Kinterbasdb but as it is Python 
DB API 2.0 you might find some info here:

http://www.python.org/dev/peps/pep-0249/

And maybe here:
http://sqlite.org/

con = sqlite.connect(DBNAME)
cur = con.cursor()

Below is from kinterbasdb, but I would assume it works the same for sqlite.

# Execute e.g. a SQL SELECT statement - if you don't know SQL you should 
get a book, e.g. SAMS "Teach yourself SQL in 21 days".
cur.execute("select * from languages order by year_released")

# Retrieve all rows as a sequence and print that sequence:
print cur.fetchall()

Werner

 Jorgen Bodde wrote:

> Hi gang,
>
> I found my IDE (Boa) which looks similar to Delphi, and seems to work
> fine.

Hope you are watching the Boa list for news: 
gmane.comp.ide.boa-constructor.user

> I am now playing with PySqlite but I am frustrated of the lack
> of API documentation. I hope some people here already used PySqlite
> and can help me.
>
> For example, I create a connection like;
>
> con = sqlite.connect(DBNAME)
> cur = con.cursor()
>
> What is this cursor object and what methods does it support? Also when
> I do a cur.execute() I get something back, but what is it exactly that
> I am getting back?
>
> For example how do I check if a table exists? I searched the web for
> PySqlite API and all I can find is a one page HTML with a small
> summary of text and some methods, but really a good API is still
> missing.
>
> Can someone help me out with some links that have more tutorials
> besides http://initd.org/tracker/pysqlite ??
>
> Thanks!
> - Jorgen
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: wxPython-users-unsubscribe at lists.wxwidgets.org
> For additional commands, e-mail: wxPython-users-help at lists.wxwidgets.org
>
>
>