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 [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at http://groups.google.com/group/sqlalchemy
-~----------~----~----~----~------~----~------~--~---
