fleetmanager.data_access package
Submodules
fleetmanager.data_access.db_engine module
- fleetmanager.data_access.db_engine.create_defaults(engine_)[source]
Function to load in the defaults defined in dbschema
- fleetmanager.data_access.db_engine.engine_creator(db_name=None, db_password=None, db_user=None, db_url=None, db_server=None) Engine[source]
Generic db engine creator. Loads env variables, e.g. in .env otherwise could be passed with click. Ensures that tables according to dbschema is created before returning
db_name db_password db_user db_url
sqlalchemy.engine
fleetmanager.data_access.dbschema module
- class fleetmanager.data_access.dbschema.AllowedStarts(**kwargs)[source]
Bases:
Base- address
- cars
- id
- latitude
- longitude
- class fleetmanager.data_access.dbschema.Cars(**kwargs)[source]
Bases:
Base- capacity_decrease
- co2_pr_km
- end_leasing
- fuel
- id
- km_aar
- leasing_type
- location
- make
- model
- omkostning_aar
- plate
- range
- sleep
- start_leasing
- type
- wltp_el
- wltp_fossil
- class fleetmanager.data_access.dbschema.FuelTypes(**kwargs)[source]
Bases:
Base- cars
- id
- name
- refers_to
- class fleetmanager.data_access.dbschema.RoundTrips(**kwargs)[source]
Bases:
Base- car_id
- distance
- driver_name
- end_latitude
- end_longitude
- end_time
- id
- start_latitude
- start_location_id
- start_longitude
- start_time