garfield.snacks.db Module

class garfield.snacks.db.Snack(snack_id)

Bases: object

@DynamicAttrs

static build_query(sess, location, text)

Create a query that finds all snacks with in a certain location that match the given text somewhere in the description or in the barcode.

@return: Returns the query.

static cancel(sess, user_trans_log_id)

Cancels the snack sale transaction by generating a new cancelation transaction.

static create(sess, snack_name, snack_barcode, snack_price, tax_id, location_id)
static delete(sess, snack_id)
net_price
static sell(sess, snack_id, user_id)
tax_price
static update(sess, snack_id, snack_name, snack_barcode, snack_price, tax_id)
class garfield.snacks.db.SnackAvailable

Bases: object

@DynamicAttrs

class garfield.snacks.db.SnackCanceller(sess, **_)

Bases: object

is_available(user_trans)
perform_on(user_trans)
class garfield.snacks.db.SnackSaleLog

Bases: object

@DynamicAttrs

net_price
tax_price
class garfield.snacks.db.SnackUserSale

Bases: object

@DynamicAttrs

garfield.snacks.db.create_snack_subtotal(sess, subtotal)
garfield.snacks.db.create_user_trans_log_snack_subtotals(sess, subtotal)
garfield.snacks.db.enhance_description_for_snacks(user_trans)

Returns a detailed description of the user transaction in case it concerns itsself about a snack transaction (and the details are still available.)

garfield.snacks.db.setup_snacks_environment(_config, garfield_sess, garfield_meta, _environment_sess)
garfield.snacks.db.setup_tables(sess, meta)