I don't know if it uses engine_impl as this error is the first time
that I am seeing this, but here is the model:
from datetime import datetime
from sqlalchemy import *
from sqlalchemy.ext.activemapper import ActiveMapper, column, \
one_to_many, one_to_one,
many_to_many
from sqlalchemy.ext.assignmapper import assign_mapper
from turbogears import identity
from turbogears.database import metadata, session
vendor_reps = Table("vendor_reps", metadata,
Column("id", Integer, primary_key=True),
Column("vendor_id", ForeignKey("vendor.id"), nullable=False),
Column("name", Unicode(255)),
Column("address", Unicode(255)),
Column("phone", Unicode(255)),
Column("fax", Unicode(255)),
Column("mobile", Unicode(255)))
vendor = Table("vendors", metadata,
Column("id", Integer, primary_key=True),
Column("name", Unicode(255)),
Column("address", Unicode(255)),
Column("phone", Unicode(255)),
Column("fax", Unicode(255)),
Column("website", Unicode(255)))
po_items = Table("purchase_order_items", metadata,
Column("id", Integer, primary_key=True),
Column("poid", ForeignKey("po.id"), nullable=False),
Column("assetid", ForeignKey("asset.id"), nullable=False),
Column("price", Float))
po = Table("purchase_orders", metadata,
Column("id", Integer, primary_key=True),
Column("ponum", Unicode(30)),
Column("vendor", ForeignKey("vendor.id"), nullable=False),
Column("issue_date", Date, default=datetime.now()),
Column("invoice_date", Date, default=datetime.now()))
asset_properties = Table("asset_type_props", metadata,
Column("id", Integer, primary_key=True),
Column("typeid", ForeignKey("asset_types.id"), nullable=False),
Column("propid", ForeignKey("type_properties.id"),
nullable=False),
Column("value", Unicode(255)))
type_props = Table("type_properties", metadata,
Column("id", Integer, primary_key=True),
Column("propname", Unicode(255)),
Column("proptype", String(30)))
asset_assignment = Table("asset_assignments", metadata,
Column("id", Integer, primary_key=True),
Column("userid", ForeignKey("user.id")),
Column("assigned_date", Date, default=datetime.now()),
Column("assetid", ForeignKey("assets.id"), nullable=False),
Column("assigned_by", ForeignKey("user.id"), nullable=False),
Column("return_date", Date, default=datetime.now()))
ops_activity = Table("ops_actions", metadata,
Column("id", Integer, primary_key=True),
Column("operation_id", ForeignKey("asset_operations.id"),
nullable=False),
Column("op_type",ForeignKey("op_types.id"), nullable=False),
Column("cost", Float))
ops_types = Table("op_types", metadata,
Column("id", Integer, primary_key=True),
Column("name", Unicode(255)))
asset_ops = Table("asset_operations", metadata,
Column("id", Integer, primary_key=True),
Column("asset_id", ForeignKey("assets.id"), nullable=False),
Column("ops_date", Date, default=datetime.now()),
Column("user", ForeignKey("user.id")),
Column("remarks", Unicode(255)))
asset_types = Table("asset_types", metadata,
Column("id", Integer, primary_key=True),
Column("type_name", String(255), nullable=False))
locations = Table("locations", metadata,
Column("id", Integer, primary_key=True),
Column("name", Unicode(255)))
asset = Table("assets", metadata,
Column("id", Integer, primary_key=True),
Column("acquiredate", DateTime, default=datetime.now()),
Column("type_id", Integer, ForeignKey("asset_types.id"),
nullable=False),
Column("location", Integer, ForeignKey("locations.id"),
nullable=False),
Column("manufacturer", Unicode(255)),
Column("model", Unicode(255)),
Column("serial_number", Unicode(255)),
Column("driver_link", Unicode(255)))
[ ... the rest is the usual turbo gear classes ... ]
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"TurboGears" 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/turbogears?hl=en
-~----------~----~----~----~------~----~------~--~---
