[sqlalchemy] Fwd: sql soup not persisting insert

[Lilian David]

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 sqlalchemy@googlegroups.com
To unsubscribe from this group, send email to 
sqlalchemy+unsubscr...@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---

04_sql_soup.py
Description: Binary data