rattail.isv.cam32.db

rattail.isv.cam32.db – Database Connectivity

rattail.isv.cam32.db.get_default_engine(**kwargs)

Returns a sqlalchemy.Engine instance with default values for server, database, etc. The actual URL used is:

sqlbase7://odbc:readonly@server1/cam32

Any kwargs provided will be passed directly to sqlalchemy.create_engine().

class rattail.isv.cam32.db.Session(*args, **kwargs)

A sqlalchemy.Session class for connecting to the CAM32 database engine.

Customer(customer_number)

Convenience function to retrieve a rattail.isv.cam32.Customer by its number.

Department(department_number)

Convenience function to retrieve a rattail.isv.cam32.Department by its number.

DepartmentClass(department_number, class_number)

Convenience function to retrieve a rattail.isv.cam32.DepartmentClass by its number and that of its department.

DepartmentSubclass(department_number, class_number, subclass_number)

Convenience function to retrieve a rattail.isv.cam32.DepartmentSubclass by its number and those of its department and class.

InventoryItem(item_number)

Convenience function to retrieve a rattail.isv.cam32.InventoryItem by its number.

Invoice(store_number, invoice_number)

Convenience function to retrieve a rattail.isv.cam32.SalesLogHeader by its number and that of its store.

PurchaseOrder(store_number, order_number)

Convenience function to retrieve a rattail.isv.cam32.PurchaseOrder by its number and that of its store.

Store(store_number)

Convenience function to retrieve a rattail.isv.cam32.Store by its number.

Vendor(vendor_number)

Convenience function to retrieve a rattail.isv.cam32.Vendor by its number.

flush(*args, **kwargs)

The default Session.flush() method is overridden here, specifically to nullify it. We wish to prevent any “accidental” attempts to write to the database, since SQLBase security will raise an exception in this case.