GitLocker: The Coding Marketplace

Description:

fasvaorm 0.8.3

FASva MySQL-ORM

This project contains a Object-relational mapping (ORM) that is used to access the MySQL/MariaDB
used within the research project FASva using SQLAlchemy.

Installation
You can find the latest version on PyPi.
$ pip install fasvaorm

Usage
Utilizing fasvaorm for accessing the database is quite straightforward. Each available table is represented as a
class in the fasvaorm.models module. Here is an example on how to initialize and query the database.
from fasvaorm import init_engine, get_session
from fasvaorm.models import Drive

# initialize the engine. Will also try to create the database if it does not exist.
engine = init_engine("mysql+pymysql://{user}@{host}:{port}/{database}".format(**dict(user='root', host='localhost',
port=3306,
database='database')))

# now get a session
session = get_session()

# and use that session to query all available drives
for d in session.query(Drive).all():
print(d.name)

# use can also access all records of that drive
for r in d.records:
print(r.filepath)

# or the vehicle
print(d.vehicle.serial_number)

# or also all scenes of that drive
for a in d.aggregations:
print(a.timestamp)
For further examples on how to use fasvaorm see the tests package.

Authors
Lars Klitzke (HSEL, GitHub, XING, LinkedIn, PyPi, Docker Hub)