def __init__(self, config):
self.config = config
self.salesOrderSQL = sqlutil.crudSQLFactory(SalesOrder.__table__, SalesOrder._attrs[0:1], SalesOrder._attrs[1:])
self.salesOrderItemSQL = sqlutil.crudSQLFactory(SalesOrderItem.__table__, SalesOrderItem._attrs[0:1], SalesOrderItem._attrs[1:])
salesOrderColumns = ['so.%s'%attr for attr in SalesOrder._attrs]
salesOrderItemColumns = ['soi.%s'%attr for attr in SalesOrderItem._attrs]
self.combinedColumns = salesOrderColumns + salesOrderItemColumns
self.combinedSelect = """select %(cols)s
from %(sales_order_table)s so
join %(sales_order_item_table)s soi on soi.sales_order_id = so.sales_order_id"""% {
'sales_order_table': SalesOrder.__table__,
'sales_order_item_table': SalesOrderItem.__table__,
'cols': ', '.join( self.combinedColumns )}
def __init__(self, voucherType):
self.voucherType = voucherType
self.voucherDefinitionSQL = sqlutil.crudSQLFactory(
self.voucherType.getType().__table__,
self.voucherType.getType()._attrs[0:1],
self.voucherType.getType()._attrs[1:])
self.voucherSQL = sqlutil.crudSQLFactory(
base.Voucher.__table__,
base.Voucher._attrs[0:1],
base.Voucher._attrs[1:])
voucherDefinitionColumns = ['d.%s'%attr for attr in self.voucherType.getType()._attrs]
voucherColumns = ['v.%s'%attr for attr in base.Voucher._attrs]
self.combinedColumns = voucherDefinitionColumns + voucherColumns
self.combinedSelect = """select %(cols)s
from %(voucher_definition_table)s d
join %(voucher_table)s v on d.voucher_definition_id = v.voucher_definition_id"""% {
'voucher_definition_table': self.voucherType.getType().__table__,
'voucher_table': base.Voucher.__table__,
'cols': ', '.join( self.combinedColumns )}
