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.

Source Distributions

No source distribution files available for this release.See tutorial on generating distribution archives.

Built Distribution

fasvaorm-0.6.1-py3-none-any.whl (34.4 kB view hashes)

Uploaded Python 3

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page