Hi, I am currently using SQLAlchemy in the creation of a mysql database. I use alchemy to create the tables and to access them but I use a python script to collect the information from the necessary sources prepare them and shove them into tab delimited 'out' files which i then load into the tables using the mysql 'LOAD IN FILE' function.
These are my tables AccessionsTable = Table('AccessionsTable',metadata, Column('accession_number', String(20), primary_key=True), Column('description',String(300)), Column('seq_length',Integer), Column('accessions_id',Integer) ) AccessionsTable.create() InstancesTable = Table('InstancesTable',metadata, Column('inst_id',Integer,primary_key=True,autoincrement=True), Column('oligomer',String(40)), Column('instances', String), Column('frequency',Integer), Column('fisher_coef', Float), Column('expectation_per_100kb', String), Column('accession_number',String(20),ForeignKey('AccessionsTable.accession_number')) ) InstancesTable.create() OligosTable = Table('OligosTable', metadata, Column('oligomer',String(40),ForeignKey('InstancesTable.oligomer'), primary_key=True), Column('word', String), Column('word_length', Integer), Column('descriptor', Integer), Column('gc_cont', Float), Column('melt_temp_wall', Float), Column('melt_temp_nn', Float) ) OligosTable.create() This is what the command looks like LOAD DATA INFILE '/db/test/01.ins' INTO TABLE InstancesTable FIELDS TERMINATED BY '\t' LINES TERMINATED BY '\n'; My problem is that this specific table - InstancesTable has an autoincremented primary key which was intended to be generated automatically however the first value in each line in the file is being shoved into it which breaks the operation. I am just curious if theres an attribute i can specify for this column when i create the table so that this doesnt happen. Thanks --~--~---------~--~----~------------~-------~--~----~ 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 [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---