Skip to main content

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

Project description

FASva MySQL-ORM

pipeline coverage

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)

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Files for fasvaorm, version 0.8.3
Filename, size File type Python version Upload date Hashes
Filename, size fasvaorm-0.8.3-py3-none-any.whl (36.3 kB) File type Wheel Python version py3 Upload date Hashes View

Supported by

Pingdom Pingdom Monitoring Google Google Object Storage and Download Analytics Sentry Sentry Error logging AWS AWS Cloud computing DataDog DataDog Monitoring Fastly Fastly CDN DigiCert DigiCert EV certificate StatusPage StatusPage Status page