Hello everyone,
I switched from sqlite to postgres and the problem is that many tables
are not filled with data when my util adds them (while there was no such
problem with sqlite):
INFO:sqlalchemy.engine.base.Engine.0x...dbd4:INSERT INTO os_version (id,
"OS_version") VALUES (%(id)
s, %(OS_version)s)
INFO:sqlalchemy.engine.base.Engine.0x...dbd4:{'OS_version': u'SLES 10',
'id': 7L}
INFO:sqlalchemy.engine.base.Engine.0x...dbd4:select
nextval('"os_version_id_seq"')
INFO:sqlalchemy.engine.base.Engine.0x...dbd4:None
INFO:sqlalchemy.engine.base.Engine.0x...dbd4:INSERT INTO os_version (id,
"OS_version") VALUES (%(id)
s, %(OS_version)s)
INFO:sqlalchemy.engine.base.Engine.0x...dbd4:{'OS_version': u'RHEL 5 64
ZSERIES', 'id': 8L}
INFO:sqlalchemy.engine.base.Engine.0x...dbd4:select
nextval('"os_version_id_seq"')
INFO:sqlalchemy.engine.base.Engine.0x...dbd4:None
os: rh 5
postgresql: 8.1.4-1.1
python: 2.4.3
data def:
virtualization_table = Table('virtualization',md,
Column('id',Integer,primary_key=True),
Column('Virtualization',String),
Column('color',String))
mapper(Virtualization, virtualization_table)
sql log shows:
CREATE TABLE os_version (
id SERIAL NOT NULL,
"OS_version" VARCHAR,
PRIMARY KEY (id)
)
Regards,
mk
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
