thanks, it does help clarify some of what is bothering me, i think part of my problem is my difficulty to phrase it correctly. My problem is that I have 5 tables that act in cascade. Now I have hundreds of values in each table. the tables look like this...
main_seq_table = Table('main_seq_table', metadata, Column('seq_id', Integer, primary_key=True), Column('seq_length', Integer), Column('seq_name', String(80)), Column('seq_descr', String(200)), Column('seq_path', String), Column('seq_position', String), ) main_seq_table.create() pattern_table = Table('pattern_table', metadata, Column('pattern_id', Integer, primary_key=True), Column('pattern_name', String), Column('word_length', Integer), ############ Column('seq_id', Integer, ForeignKey('main_seq_table.seq_id')) ) pattern_table.create() word_table = Table('word_table', metadata, Column('word_id', Integer, primary_key=True), Column('word_seq', String(80)), Column('word_con_num', String(80)), Column('pattern_id', Integer, ForeignKey('pattern_table.pattern_id')) ) word_table.create() nuc_word_table = Table('nuc_word_table', metadata, Column('nuc_word_id', Integer, primary_key=True), Column('nuc_word_seq_num', String(80)), Column('list_homologues', String(80)), ######### Column('list_overlaps', String(80)), ########## Column('word_id', Integer, ForeignKey('word_table.word_id')) ) nuc_word_table.create() position_table = Table('position_table', metadata, Column('pos_id', Integer, primary_key=True), Column('word_position', Integer), Column('nuc_word_id', Integer, ForeignKey('nuc_word_table.nuc_word_id')) ) position_table.create() With simple mappers like this.... class MainSeqTable(object): def _init_(self,seq_id,seq_length,seq_name,seq_descr,seq_path,seq_position): self.seq_id self.seq_length self.seq_name self.seq_descr self.seq_path self.seq_position def __repr__(self): return "%r|%r|%r|%r|%r" % (self.seq_id, self.seq_length,self.seq_name,self.seq_descr,self.seq_path) main_seq_table_mapper = mapper(MainSeqTable,main_seq_table) class PatternTable(object): def _init_(self,pattern_id,pattern_name,seq_id): self.pattern_id self.pattern_name self.word_length self.seq_id def __repr__(self): return "%r|%r|%r|%r" % (self.pattern_id,self.pattern_name,self.word_length,self.seq_id) pattern_table_mapper = mapper(PatternTable,pattern_table) class WordTable(object): def _init_(self,word_id,word_seq,word_con_num,word_length,pattern_id): self.word_id self.word_seq self.word_con_num self.pattern_id def __repr__(self): return "%r|%r|%r|%r" % (self.word_id, self.word_seq,self.word_con_num,self.pattern_id) word_table_mapper = mapper(WordTable,word_table) class NucWordTable(object): def _init_(self,nuc_word_id,nuc_word_seq_num,word_id): self.nuc_word_id self.nuc_word_seq_num self.list_homologues self.list_overlaps self.word_id def __repr__(self): return "%r|%r|%r|%r|%r" % (self.nuc_word_id,self.nuc_word_seq_num,self.list_homologues,self.list_overlaps,self.word_id) nuc_word_table_mapper = mapper(NucWordTable,nuc_word_table) class PositionTable(object): def _init_(self, pos_id, word_position, nuc_word_id): self.pos_id = pod_id self.word_position = word_position self.nuc_word_id = nuc_word_id def __repr__(self): return "%r|%r|%r" % (self.pos_id,self.word_position,self.nuc_word_id) position_table_mapper = mapper(PositionTable, position_table) Now I want to change the word_id in nuc_word_table for several rows, say I have 10 entires of nuc_word_table.word_id = '2' and i want to change it to '3' say... All I really need is the few lines that do the replace or update or append... Or will i have to add in extra relations to make this possible ? --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---