biweeklybudget.models.projects module

class biweeklybudget.models.projects.BoMItem(**kwargs)[source]

Bases: sqlalchemy.ext.declarative.api.Base, biweeklybudget.models.base.ModelAsDict

_sa_class_manager = {'id': <sqlalchemy.orm.attributes.InstrumentedAttribute object at 0x7f8004a031d0>, 'is_active': <sqlalchemy.orm.attributes.InstrumentedAttribute object at 0x7f8004a03710>, 'name': <sqlalchemy.orm.attributes.InstrumentedAttribute object at 0x7f8004a03350>, 'notes': <sqlalchemy.orm.attributes.InstrumentedAttribute object at 0x7f8004a03410>, 'project': <sqlalchemy.orm.attributes.InstrumentedAttribute object at 0x7f8004a03050>, 'project_id': <sqlalchemy.orm.attributes.InstrumentedAttribute object at 0x7f8004a03290>, 'quantity': <sqlalchemy.orm.attributes.InstrumentedAttribute object at 0x7f8004a034d0>, 'unit_cost': <sqlalchemy.orm.attributes.InstrumentedAttribute object at 0x7f8004a03590>, 'url': <sqlalchemy.orm.attributes.InstrumentedAttribute object at 0x7f8004a03650>}
id

Primary Key

is_active

whether active or historical

line_cost

The total cost for this BoM Item, unit_cost times quantity

Returns:total line cost
Return type:decimal.Decimal
name

Name of item

notes

Notes / Description

project

Relationship to the Project this item is for

project_id

Project ID

quantity

Quantity Required

unit_cost

Unit Cost / Cost Each

url

URL

class biweeklybudget.models.projects.Project(**kwargs)[source]

Bases: sqlalchemy.ext.declarative.api.Base, biweeklybudget.models.base.ModelAsDict

_sa_class_manager = {'id': <sqlalchemy.orm.attributes.InstrumentedAttribute object at 0x7f80049e3d10>, 'is_active': <sqlalchemy.orm.attributes.InstrumentedAttribute object at 0x7f80049e3ef0>, 'name': <sqlalchemy.orm.attributes.InstrumentedAttribute object at 0x7f80049e3d70>, 'notes': <sqlalchemy.orm.attributes.InstrumentedAttribute object at 0x7f80049e3e30>}
id

Primary Key

is_active

whether active or historical

name

Name of project

notes

Notes / Description

remaining_cost

Return the remaining cost of all line items (BoMItem) for this project which are still active

Returns:remianing cost of this project
Return type:float
total_cost

Return the total cost of all line items (BoMItem) for this project.

Returns:total cost of this project
Return type:float