Hi All,
I am using SA within TurboGears. When saving data from form fields, I
often have a dict of key/value pairs (where values is always a string
and must by correctly typed) where each key is set up to correspond to
a column within the SA Table:
(Data from fields for a ProductLineItem Type)
kw = {'bol': u'', 'gross_qty': u'', 'id': u'-1', 'item': u'4',
'net_qty': u'', 'order_id': u'2', 'ordered_qty': u'8800', 'supplier':
u'2', 'terminal': u'8'}
I have been manually using setter methods to type-define and save each
dict value with the correct variable within my LineItem class, but
this is getting fairly tedious. I wanted a way to just save my entire
dict using a method within LineItems like:
======================
class LineItem(DeclarativeBase):
__tablename__ = 'line_item'
__table_args__ = {'mysql_engine':mysql_engine_type}
id = Column(Integer, primary_key=True)
order_id = Column(Integer, ForeignKey('order.id'))
ordered_qty = Column(Integer)
net_qty = Column(Integer)
item_id = Column(Integer, ForeignKey('item.id'))
class_type = Column('class_type', String(50))
__mapper_args__ = {'polymorphic_on':class_type}
....
def saveTG(self, kw):
# Load current classes DB table.
table = metadata.tables[self.__tablename__]
for k,v in kw.iteritems():
if k in dir(self):
# Get the type of the SA column since
the value in the class may be a None or
# undefined.
field_type = type(table.c[k])
setattr(self, k, field_type(v))
...
======================
class ProductLineItem(LineItem):
TYPE = 'product'
GROSS = 'gross_qty'
BOL = 'bol'
TERMINAL = 'terminal_id'
SUPPLIER = 'supplier_account_id'
__tablename__ = 'product_line_item'
__table_args__ = {'mysql_engine':mysql_engine_type}
id = Column(Integer, ForeignKey('line_item.id'), primary_key = True)
gross_qty = Column(Integer)
bol = Column(Unicode(20), nullable=True)
terminal_id = Column(Integer, ForeignKey('terminal.id'), nullable =
True)
supplier_account_id = Column(Integer, ForeignKey
('terminal_supplier_account.id'), nullable = True)
__mapper_args__ = {'polymorphic_identity': 'product'}
Ex:
line = LineItem()
line.saveTG(kw)
This works since I am working on the base class, but if I use a
ProductLineItem
line=ProductLineItem()
line.saveTG(kw)
If fails since my table contains only the columns for
ProductLineItem. So how can I get all the columns that a
ProductLineItem works with? I think i am making this too hard and
that it is something that should be easy to do.
I appreciate any suggestions!
- Shane
--~--~---------~--~----~------------~-------~--~----~
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?hl=en
-~----------~----~----~----~------~----~------~--~---
