On Mar 30, 2009, at 9:51 AM, Marcin Krol wrote:
>
> Michael Bayer wrote:
>
>>> 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
>>
>>
>> there seems to be rows inserted there.
>
> Except when I browse the database (using external tool, phpPGAdmin),
> those tables, incl. 'os_version', are empty.
>
>> this email doesn't seem to
>> describe anything actually going wrong except "doesn't work". can
>> you
>> be more specific please ?
>
> OK I'll try though I'm not sure how, because some tables are just
> empty,
> anyway here's more detailed version:
>
> tables empty: architecture, hosts, os_kind, os_version, reservation
> (although that can be empty, the converter utility I've been running
> here does not add any data to that table), reservation_hosts (the
> same,
> it should be empty), table locks(empty as well), virtualization
> (empty,
> while it should be filled by converter)
>
> tables with some data: email, hwrep, project, project_hwreps
>
>
> Entire sqla programming:
> Session=sessionmaker(bind=eng)
> session=Session()
>
> logging.basicConfig(filename=globalpath + os.sep + 'sql.log')
> logging.getLogger('sqlalchemy.engine').setLevel(logging.DEBUG)
> logging.getLogger('sqlalchemy.orm.unitofwork').setLevel(logging.DEBUG)
>
> #####################################################
>
> The log shows this:
uh wait, how are you adding your objects to the Session ? are you
calling commit()? I notice there's no commit in the logs which is
likely the source of your issue.
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
