On 8/26/10 7:51 PM, Jim Byrnes wrote:
> Before I do, one more question. What tool do you guys use to create
> your sqlite db's? I have been using sqliteman on ubuntu and I just
> discovered that I cannot save changes to any sqlite db I created when I
> use Dabo.
I make sql script files, like:
{{{
create table customers (id char(40), name char(64), ...)
create table blah (id char(40)...)
...
}}}
and then I execute them in Python like:
{{{
import sqlite3.dbapi2 as sqlite
con = sqlite.connect("path_to_new_db")
cur = con.cursor()
cur.executescript(open("myscript.sql").read())
con.commit()
}}}
Paul
_______________________________________________
Post Messages to: Dabo-users@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users
Searchable Archives: http://leafe.com/archives/search/dabo-users
This message: http://leafe.com/archives/byMID/4c77479c.1030...@ulmcnett.com
