Hi, The attached script doesn't persist a sqlsoup insert. Would anyone happen to know what must be changed in the script to allow the insert to be persisted ?
Thanks,
Lysander
This is the output:
741 lda...@macintosh:~/explore/python/sqlalchemy/04_sql_soup $ ls
04_sql_soup.py 04_sql_soup.py~ NOTES NOTES~
742 lda...@macintosh:~/explore/python/sqlalchemy/04_sql_soup $ python
04_sql_soup.py
url: "sqlite:///simple.db"
2009-08-12 00:15:24,078 INFO sqlalchemy.engine.base.Engine.0x...a810
CREATE TABLE file_routes (
id INTEGER NOT NULL,
src_path VARCHAR,
dest_path VARCHAR,
PRIMARY KEY (id)
)
CREATE TABLE file_routes (
id INTEGER NOT NULL,
src_path VARCHAR,
dest_path VARCHAR,
PRIMARY KEY (id)
)
2009-08-12 00:15:24,078 INFO sqlalchemy.engine.base.Engine.0x...a810 ()
()
2009-08-12 00:15:24,090 INFO sqlalchemy.engine.base.Engine.0x...a810 COMMIT
COMMIT
inserting
before flush
2009-08-12 00:15:24,093 INFO sqlalchemy.engine.base.Engine.0x...a810 BEGIN
BEGIN
2009-08-12 00:15:24,093 INFO sqlalchemy.engine.base.Engine.0x...a810 INSERT
INTO file_routes (src_path, dest_path) VALUES (?, ?)
INSERT INTO file_routes (src_path, dest_path) VALUES (?, ?)
2009-08-12 00:15:24,094 INFO sqlalchemy.engine.base.Engine.0x...a810
['build_dir/htmldocs/index.html', 'htmldocs/index.html']
['build_dir/htmldocs/index.html', 'htmldocs/index.html']
done
743 lda...@macintosh:~/explore/python/sqlalchemy/04_sql_soup $ ls
04_sql_soup.py NOTES simple.db
04_sql_soup.py~ NOTES~ simple.db-journal
744 lda...@macintosh:~/explore/python/sqlalchemy/04_sql_soup $
744 lda...@macintosh:~/explore/python/sqlalchemy/04_sql_soup $ sqlite3
simple.db
SQLite version 3.6.7
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> .schema
CREATE TABLE file_routes (
id INTEGER NOT NULL,
src_path VARCHAR,
dest_path VARCHAR,
PRIMARY KEY (id)
);
sqlite> select count(*) file_routes;
1
sqlite> select * file_routes;
SQL error: near "file_routes": syntax error
sqlite> select * from file_routes;
sqlite>
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---
04_sql_soup.py
Description: Binary data
