biweeklybudget.models.projects module

class biweeklybudget.models.projects.BoMItem(**kwargs)

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

_sa_class_manager = {'id': <sqlalchemy.orm.attributes.InstrumentedAttribute object at 0x7f8f706c6410>, 'is_active': <sqlalchemy.orm.attributes.InstrumentedAttribute object at 0x7f8f706c6950>, 'name': <sqlalchemy.orm.attributes.InstrumentedAttribute object at 0x7f8f706c6590>, 'notes': <sqlalchemy.orm.attributes.InstrumentedAttribute object at 0x7f8f706c6650>, 'project': <sqlalchemy.orm.attributes.InstrumentedAttribute object at 0x7f8f706c6290>, 'project_id': <sqlalchemy.orm.attributes.InstrumentedAttribute object at 0x7f8f706c64d0>, 'quantity': <sqlalchemy.orm.attributes.InstrumentedAttribute object at 0x7f8f706c6710>, 'unit_cost': <sqlalchemy.orm.attributes.InstrumentedAttribute object at 0x7f8f706c67d0>, 'url': <sqlalchemy.orm.attributes.InstrumentedAttribute object at 0x7f8f706c6890>}

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)

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

_sa_class_manager = {'id': <sqlalchemy.orm.attributes.InstrumentedAttribute object at 0x7f8f70736e90>, 'is_active': <sqlalchemy.orm.attributes.InstrumentedAttribute object at 0x7f8f706c6170>, 'name': <sqlalchemy.orm.attributes.InstrumentedAttribute object at 0x7f8f70736fb0>, 'notes': <sqlalchemy.orm.attributes.InstrumentedAttribute object at 0x7f8f706c60b0>}

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