Sorry here is the output with echo=True
Mike Bernson wrote: > I have a case where I am loading a mysql database with insert from table > object. > > When I insert a single row at a time everything works without warnings. > > If I insert 100 rows at a time I get warnings from mysql cursor object > but it does not give me any hints as to what happen. I have verified > that all the row have the same keys. > > The data is array of dict. the dict has the list of columns as keys that > value as the data for the row. There are None in place for values > to keep the number of keys align. > > Has this been seen before? > I will start looking at the sql commands that is being sent to dbiapi. > The sql that is displayed with echo=True on engine is not what is sent > to the dbiapi. I hope look at the sql sent to dbiapi will help. > > Using Tomcat but need to do more? Need to support web services, security? > Get stuff done quickly with pre-integrated technology to make your job easier > Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo > http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 > _______________________________________________ > Sqlalchemy-users mailing list > Sqlalchemy-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users
[2006-07-01 01:44:35,399] [engine]: INSERT INTO wood_memorial.stx_3618 (id, control, sequence, account, create_date, modify_date, freeze_date, sent_date, ack_date, status, active, DLN, ParentDLN, MediaType, form, ReceivedDate, DCN, ssi_unused, dhs_number, RecipSSN, hic, RecipLastName, RecipFirstName, RecipMiddleInit, RecipAddress, RecipCity, RecipState, RecipZip, VendorNumber, ContractNumber, Vendor_name, Vendor_add, Vendor_city, Vendor_state, Vendor_zip, SectionLocation, ServiceGroup, spouse_unused, TransType, TransLocation, TransHospitalDate, TransPrivateDate, TransDate, RelocFrom, RelocTo, AdministatorLastName, AdministatorFirstName, AdministatorLicense, AdministatorDateSigned, AdministatorSigOnFile, Comments) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s) [2006-07-01 01:44:35,399] [engine]: [[None, '0000059', '00', '000977', None, None, None, None, None, None, None, None, None, None, '3618', None, None, None, '000000000', '452207103', '452207103A', 'PLUNK', 'VERNON', None, '215 PR 6254', 'MINEOLA', 'TX', '75773', '4396', None, 'Wood Memorial Nursing Hom', 'P.O. Box 810', 'Mineola', 'Tx', '75773', '3', None, '2', '6', '5', None, None, '20010417', None, None, None, None, '4951', None, None, 'THIS IS A CCORRECTION THAT WAS TRANSMITTED IN ERROR. THE DATAE ON THE ERROR WAS ADMITED TO WOOD MEMORIAL NURSING HOME ON 6/1/2001. THE ACTUAL DATE OF ADMISSION IS 4/17/2001. PLEASE DELETE THE INCORRECT ONE. THANK YOU.'], [None, '0000069', '00', '000977', None, None, None, None, None, None, None, None, None, None, '3618', None, None, None, '000000000', '452207103', '452207103A', 'PLUNK', 'VERNON', None, '215 PR 6254', 'MINEOLA', 'TX', '75773', '4396', None, 'Wood Memorial Nursing Hom', 'P.O. Box 810', 'Mineola', 'Tx', '75773', '3', None, '2', '2', '5', None, None, '20011004', None, None, None, None, '4951', None, None, 'RESIDENT D/C HOME']] /home/mike/src/sqlalchemy/lib/sqlalchemy/engine/default.py:77: Warning: Records: 2 Duplicates: 0 Warnings: 1 cursor.executemany(statement, parameters) [2006-07-01 01:44:35,406] [engine]: INSERT INTO wood_memorial.stx_3618 (id, control, sequence, account, create_date, modify_date, freeze_date, sent_date, ack_date, status, active, DLN, ParentDLN, MediaType, form, ReceivedDate, DCN, ssi_unused, dhs_number, RecipSSN, hic, RecipLastName, RecipFirstName, RecipMiddleInit, RecipAddress, RecipCity, RecipState, RecipZip, VendorNumber, ContractNumber, Vendor_name, Vendor_add, Vendor_city, Vendor_state, Vendor_zip, SectionLocation, ServiceGroup, spouse_unused, TransType, TransLocation, TransHospitalDate, TransPrivateDate, TransDate, RelocFrom, RelocTo, AdministatorLastName, AdministatorFirstName, AdministatorLicense, AdministatorDateSigned, AdministatorSigOnFile, Comments) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s) [2006-07-01 01:44:35,406] [engine]: [[None, '0000071', '00', '001067', None, None, None, None, None, None, None, None, None, None, '3618', None, None, None, '517563507', '454248941', '454248941A', 'POLK', 'OPAL', 'M', '212 LAKE SIDE', 'MINEOLA', 'TX', '75773', '4396', None, 'Wood Memorial Nursing Hom', 'P.O. Box 810', 'Mineola', 'Tx', '75773', '3', None, '2', '1', '9', None, None, '20020126', None, None, None, None, '4951', None, None, 'D/C RESIDENT BACK TO MEDICAID BED ON 1/26/2002.'], [None, '0000074', '00', '001068', None, None, None, None, None, None, None, None, None, None, '3618', None, None, None, '119954301', '453304209', '467202801D', 'MCDOWELL', 'HELEN', None, '6810 SETTLER LOOP', 'ATHEN', 'TX', '75751', '4396', None, 'Wood Memorial Nursing Hom', 'P.O. Box 810', 'Mineola', 'Tx', '75773', '3', None, '2', '1', '9', None, None, '20020131', None, None, None, None, '4951', None, None, 'D/C RESIDENT BACK TO MEDICAID BED ON 1/31/2002']]
Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________ Sqlalchemy-users mailing list Sqlalchemy-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users
