fasvaorm 0.8.3

fasvaorm is a ORM to access the database used within FASva.

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)