Davide Alberani wrote:
> In the attachment there's a little example.
> It doesn't use IMDbPY, but as far as I can tell the code is totally
> equivalent.
Thanks for the code. :-)
Well, actually good news is bad news here: The example works as it
should (up to the last step of printing the result; I commented out the
corresponding two lines):
2008-11-15 15:59:05,818 INFO sqlalchemy.engine.base.Engine.0x..50
CREATE TABLE kind_type (
id INTEGER NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 1),
kind VARCHAR(15),
PRIMARY KEY (id)
)
INFO:sqlalchemy.engine.base.Engine.0x..50:
CREATE TABLE kind_type (
id INTEGER NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 1),
kind VARCHAR(15),
PRIMARY KEY (id)
)
2008-11-15 15:59:05,818 INFO sqlalchemy.engine.base.Engine.0x..50 {}
INFO:sqlalchemy.engine.base.Engine.0x..50:{}
2008-11-15 15:59:06,082 INFO sqlalchemy.engine.base.Engine.0x..50 COMMIT
INFO:sqlalchemy.engine.base.Engine.0x..50:COMMIT
2008-11-15 15:59:06,151 INFO sqlalchemy.engine.base.Engine.0x..50 CREATE
INDEX kind_idx ON kind_type (kind)
INFO:sqlalchemy.engine.base.Engine.0x..50:CREATE INDEX kind_idx ON
kind_type (kind)
2008-11-15 15:59:06,152 INFO sqlalchemy.engine.base.Engine.0x..50 {}
INFO:sqlalchemy.engine.base.Engine.0x..50:{}
2008-11-15 15:59:06,613 INFO sqlalchemy.engine.base.Engine.0x..50 COMMIT
INFO:sqlalchemy.engine.base.Engine.0x..50:COMMIT
2008-11-15 15:59:06,740 INFO sqlalchemy.engine.base.Engine.0x..50 INSERT
INTO kind_type (kind) VALUES (?)
INFO:sqlalchemy.engine.base.Engine.0x..50:INSERT INTO kind_type (kind)
VALUES (?)
2008-11-15 15:59:06,740 INFO sqlalchemy.engine.base.Engine.0x..50 ['movie']
INFO:sqlalchemy.engine.base.Engine.0x..50:['movie']
2008-11-15 15:59:07,055 INFO sqlalchemy.engine.base.Engine.0x..50 COMMIT
INFO:sqlalchemy.engine.base.Engine.0x..50:COMMIT
2008-11-15 15:59:07,175 INFO sqlalchemy.engine.base.Engine.0x..50 INSERT
INTO kind_type (kind) VALUES (?)
INFO:sqlalchemy.engine.base.Engine.0x..50:INSERT INTO kind_type (kind)
VALUES (?)
2008-11-15 15:59:07,175 INFO sqlalchemy.engine.base.Engine.0x..50 ['tv
series']
INFO:sqlalchemy.engine.base.Engine.0x..50:['tv series']
2008-11-15 15:59:07,653 INFO sqlalchemy.engine.base.Engine.0x..50 COMMIT
INFO:sqlalchemy.engine.base.Engine.0x..50:COMMIT
2008-11-15 15:59:07,858 INFO sqlalchemy.engine.base.Engine.0x..50 INSERT
INTO kind_type (kind) VALUES (?)
INFO:sqlalchemy.engine.base.Engine.0x..50:INSERT INTO kind_type (kind)
VALUES (?)
2008-11-15 15:59:07,859 INFO sqlalchemy.engine.base.Engine.0x..50 ['tv
movie']
INFO:sqlalchemy.engine.base.Engine.0x..50:['tv movie']
2008-11-15 15:59:08,182 INFO sqlalchemy.engine.base.Engine.0x..50 COMMIT
INFO:sqlalchemy.engine.base.Engine.0x..50:COMMIT
2008-11-15 15:59:08,495 INFO sqlalchemy.engine.base.Engine.0x..50 INSERT
INTO kind_type (kind) VALUES (?)
INFO:sqlalchemy.engine.base.Engine.0x..50:INSERT INTO kind_type (kind)
VALUES (?)
2008-11-15 15:59:08,495 INFO sqlalchemy.engine.base.Engine.0x..50
['video movie']
INFO:sqlalchemy.engine.base.Engine.0x..50:['video movie']
2008-11-15 15:59:08,806 INFO sqlalchemy.engine.base.Engine.0x..50 COMMIT
INFO:sqlalchemy.engine.base.Engine.0x..50:COMMIT
2008-11-15 15:59:08,927 INFO sqlalchemy.engine.base.Engine.0x..50 INSERT
INTO kind_type (kind) VALUES (?)
INFO:sqlalchemy.engine.base.Engine.0x..50:INSERT INTO kind_type (kind)
VALUES (?)
2008-11-15 15:59:08,927 INFO sqlalchemy.engine.base.Engine.0x..50 ['tv
mini series']
INFO:sqlalchemy.engine.base.Engine.0x..50:['tv mini series']
2008-11-15 15:59:09,250 INFO sqlalchemy.engine.base.Engine.0x..50 COMMIT
INFO:sqlalchemy.engine.base.Engine.0x..50:COMMIT
2008-11-15 15:59:09,575 INFO sqlalchemy.engine.base.Engine.0x..50 INSERT
INTO kind_type (kind) VALUES (?)
INFO:sqlalchemy.engine.base.Engine.0x..50:INSERT INTO kind_type (kind)
VALUES (?)
2008-11-15 15:59:09,575 INFO sqlalchemy.engine.base.Engine.0x..50
['video game']
INFO:sqlalchemy.engine.base.Engine.0x..50:['video game']
2008-11-15 15:59:09,882 INFO sqlalchemy.engine.base.Engine.0x..50 COMMIT
INFO:sqlalchemy.engine.base.Engine.0x..50:COMMIT
2008-11-15 15:59:09,999 INFO sqlalchemy.engine.base.Engine.0x..50 INSERT
INTO kind_type (kind) VALUES (?)
INFO:sqlalchemy.engine.base.Engine.0x..50:INSERT INTO kind_type (kind)
VALUES (?)
2008-11-15 15:59:09,999 INFO sqlalchemy.engine.base.Engine.0x..50
['episode']
INFO:sqlalchemy.engine.base.Engine.0x..50:['episode']
2008-11-15 15:59:10,562 INFO sqlalchemy.engine.base.Engine.0x..50 COMMIT
INFO:sqlalchemy.engine.base.Engine.0x..50:COMMIT
The table got created and populated with tuples. Even the index has been
generated.
> It creates the columns, the 'kind_type' table; it connects to the
> database and writes some data, first with SQLAlchemy and at the
> end calling the cursor. After that, it prints what's in the
> db (reading it with the SQLAlchemy ORM).
When doing the last step of printing, the program seems to freeze.
Before that happens, I get this output (ignore the timestamps, this
output is from a different run of the program than the one given above;
in both cases, I dropped all tables in the database before running the
program):
2008-11-15 16:03:35,839 INFO sqlalchemy.engine.base.Engine.0x..50 SELECT
kind_type.id, kind_type.kind
FROM kind_type
INFO:sqlalchemy.engine.base.Engine.0x..50:SELECT kind_type.id,
kind_type.kind
FROM kind_type
2008-11-15 16:03:35,840 INFO sqlalchemy.engine.base.Engine.0x..50 []
INFO:sqlalchemy.engine.base.Engine.0x..50:[]
Then, I cannot even abort the program by Ctrl-c.
Any ideas? :-)
Joachim
--
M. Sc. Joachim Selke
Technische Universität Braunschweig, Institut für Informationssysteme
Mühlenpfordtstraße 23, 38106 Braunschweig, Germany
<http://www.l3s.uni-hannover.de/~selke>
-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Imdbpy-devel mailing list
Imdbpy-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/imdbpy-devel
