can you create a test case which reproduces ?
On May 18, 2009, at 11:56 AM, scrapbooker wrote:
>
> Hello,
> My code seems to operating fine, loading some values into a Postgres
> 8.1 database using sqlalchemy 0.4.7 in Debian Lenny. The first 2
> tables load fine into Postgres, but on the third looking at the logs
> (see below), something strange happens. sqlalchemy passes in the
> column values correctly, but after the second column in the third
> table, Postgres commits the values as 'None'. All tables after this
> one also fail to load values, but the tables/columns are set up
> properly as far as structure. Just no data. It almost seems like
> Postgres ran out of buffer memory or something after a certain point.
> Log lines of interest with comments inserted:
>
> #Table set up correctly, converting to Postgres types
> 2009-05-18 11:19:11,751 INFO sqlalchemy.engine.base.Engine.0x..ac
> CREATE TABLE person (
> id SERIAL NOT NULL,
> person_id VARCHAR(50),
> person_id_date_collected TIMESTAMP WITH TIME ZONE,
> date_of_birth DATE,
> date_of_birth_date_collected TIMESTAMP WITH TIME ZONE,
> ethnicity INTEGER,
> ethnicity_date_collected TIMESTAMP WITH TIME ZONE,
> gender INTEGER,
> gender_date_collected TIMESTAMP WITH TIME ZONE,
> legal_first_name VARCHAR(50),
> legal_first_name_date_collected TIMESTAMP WITH TIME ZONE,
> legal_last_name VARCHAR(50),
> legal_last_name_date_collected TIMESTAMP WITH TIME ZONE,
> legal_middle_name VARCHAR(50),
> legal_middle_name_date_collected TIMESTAMP WITH TIME ZONE,
> legal_suffix VARCHAR(50),
> legal_suffix_date_collected TIMESTAMP WITH TIME ZONE,
> social_security_number VARCHAR(9),
> social_security_number_date_collected TIMESTAMP WITH TIME ZONE,
> social_security_number_quality_code VARCHAR(2),
> social_security_number_quality_code_date_collected TIMESTAMP WITH
> TIME ZONE,
> PRIMARY KEY (id)
> )
>
> #all the data values passed in correctly by sqlalchemy:
> 2009-05-18 11:19:12,315 INFO sqlalchemy.engine.base.Engine.0x..ac
> COMMIT
> {'person_date_of_birth': '1999-01-22', 'person_legal_last_name':
> 'Washington', 'person_id_date_collected': datetime.datetime(2004, 8,
> 1, 0, 0), 'person_legal_middle_name_date_collected': datetime.datetime
> (2004, 8, 1, 0, 0), 'person_legal_suffix_date_collected':
> datetime.datetime(2004, 8, 1, 0, 0), 'person_legal_suffix': 'Jr.',
> 'person_legal_middle_name': 'Michael', 'person_gender_date_collected':
> datetime.datetime(2004, 8, 1, 0, 0),
> 'person_date_of_birth_date_collected': datetime.datetime(2004, 8, 1,
> 0, 0), 'person_legal_first_name': 'George', 'person_id': 'DCF017Y0',
> 'person_legal_first_name_date_collected': datetime.datetime(2004, 8,
> 1, 0, 0), 'person_legal_last_name_date_collected': datetime.datetime
> (2004, 8, 1, 0, 0), 'person_ethnicity_date_collected':
> datetime.datetime(2004, 8, 1, 0, 0), 'person_ethnicity': '0',
> 'person_gender': '1'}
> 2009-05-18 11:19:12,356 DEBUG
> sqlalchemy.orm.unitofwork.UOWTransaction.
> 0x..2c register object for flush: per...@0x874364c isdelete=False
> listonly=False postupdate=False
> 2009-05-18 11:19:12,369 DEBUG
> sqlalchemy.orm.unitofwork.UOWTransaction.
> 0x..2c Dependent tuples:
>
> 2009-05-18 11:19:12,371 DEBUG
> sqlalchemy.orm.unitofwork.UOWTransaction.
> 0x..2c Dependency sort:
> [UOWTask(0x87434ec) Mapper: 'Person/person']
> 2009-05-18 11:19:12,373 INFO sqlalchemy.orm.unitofwork.UOWTransaction.
> 0x..2c Task dump:
> UOWTask(0x87434ec, Person/person/None) (save/update phase)
> +-Save per...@0x874364c
> UOWTask(0x87434ec, Person/person/None) (delete phase)
>
> 2009-05-18 11:19:12,375 INFO sqlalchemy.engine.base.Engine.0x..ac
> BEGIN
> 2009-05-18 11:19:12,383 INFO sqlalchemy.engine.base.Engine.0x..ac
> select nextval('"person_id_seq"')
> 2009-05-18 11:19:12,387 INFO sqlalchemy.engine.base.Engine.0x..ac None
> 2009-05-18 11:19:12,389 INFO sqlalchemy.engine.base.Engine.0x..ac
> INSERT INTO person (id, person_id, person_id_date_collected,
> date_of_birth, date_of_birth_date_collected, ethnicity,
> ethnicity_date_collected, gender, gender_date_collected,
> legal_first_name, legal_first_name_date_collected, legal_last_name,
> legal_last_name_date_collected, legal_middle_name,
> legal_middle_name_date_collected, legal_suffix,
> legal_suffix_date_collected, social_security_number,
> social_security_number_date_collected,
> social_security_number_quality_code,
> social_security_number_quality_code_date_collected) VALUES (%(id)s, %
> (person_id)s, %(person_id_date_collected)s, %(date_of_birth)s, %
> (date_of_birth_date_collected)s, %(ethnicity)s, %
> (ethnicity_date_collected)s, %(gender)s, %(gender_date_collected)s, %
> (legal_first_name)s, %(legal_first_name_date_collected)s, %
> (legal_last_name)s, %(legal_last_name_date_collected)s, %
> (legal_middle_name)s, %(legal_middle_name_date_collected)s, %
> (legal_suffix)s, %(legal_suffix_date_collected)s, %
> (social_security_number)s, %
> (social_security_number_date_collected)s, %
> (social_security_number_quality_code)s, %
> (social_security_number_quality_code_date_collected)s)
>
> #And here is where most of the data is changed to "None", which is my
> problem. The first three columns (id, person_id, and
> person_id_date_collected are committed fine and show up in the db.
> The rest are 'None':
>
> 2009-05-18 11:19:12,389 INFO
> sqlalchemy.engine.base.Engine.0x..ac {'legal_middle_name': None,
> 'gender': None, 'legal_first_name_date_collected': None,
> 'legal_last_name': None, 'person_id_date_collected': datetime.datetime
> (2004, 8, 1, 0, 0),
> 'social_security_number_quality_code_date_collected': None,
> 'legal_suffix_date_collected': None, 'id': 1L,
> 'legal_middle_name_date_collected': None, 'date_of_birth': None,
> 'gender_date_collected': None,
> 'social_security_number_date_collected': None,
> 'social_security_number_quality_code': None,
> 'ethnicity_date_collected': None, 'date_of_birth_date_collected':
> None, 'person_id': 'DCF017Y0', 'social_security_number': None,
> 'legal_last_name_date_collected': None, 'legal_suffix': None,
> 'legal_first_name': None, 'ethnicity': None}
> 2009-05-18 11:19:12,416 INFO sqlalchemy.orm.unitofwork.UOWTransaction.
> 0x..2c Execute Complete
>
>
> Any ideas on how to fix this?
>
> >
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
