eventdb.py

#!/usr/bin/env python3

"""
ORM classes to access the data in the database
"""

from sqlalchemy import Column, Float, Integer, String
from sqlalchemy.ext.declarative import declarative_base

Base = declarative_base()


class DeaggregationData(Base):
    """Class for accessing the data for the mean disaggregation"""

    __tablename__ = "mean_disagg"
    id = Column("index", Integer, primary_key=True)
    sid = Column("sid", Integer)
    poe50y = Column("poe50y", Float)
    lon = Column("Lon", Float)
    lat = Column("Lat", Float)
    mag = Column("Mag", Float)
    poe = Column("poe", Float)

    def __repr__(self):
        return (
            "<DisaggData(sid=%d, poe50y=%f, lon=%f, lat=%f, mag=%f, poe=%f)>"
            % (self.sid, self.poe50y, self.lon, self.lat, self.mag, self.poe)
        )


class Site(Base):
    """Class to access the data of the sites"""

    __tablename__ = "sites"
    id = Column("index", Integer, primary_key=True)
    sid = Column("sid", Integer)
    lon = Column("lon", Float)
    lat = Column("lat", Float)

    def __repr__(self):
        return "<Site(sid=%d, lon=%f, lat=%f)>" % (
            self.sid,
            self.lon,
            self.lat,
        )


class Event(Base):
    """Class to access to data of the earth quake events"""

    __tablename__ = "events"
    id = Column("index", Integer, primary_key=True)
    eventID = Column("eventID", String)
    identifier = Column("Identifier", String)
    year = Column("year", Integer)
    month = Column("month", Float)
    day = Column("day", Float)
    hour = Column("hour", Float)
    minute = Column("minute", Float)
    second = Column("second", Float)
    timeUncertainty = Column("timeUncertainty", Float)
    longitude = Column("longitude", Float)
    longitudeUncertainty = Column("longitudeUncertainty", Float)
    latitude = Column("latitude", Float)
    latitudeUncertainty = Column("latitudeUncertainty", Float)
    horizontalUncertainty = Column("horizontalUncertainty", Float)
    minHorizontalUncertainty = Column("minHorizontalUncertainty", Float)
    maxHorizontalUncertainty = Column("maxHorizontalUncertainty", Float)
    azimuthMaxHorizontalUncertainty = Column(
        "azimuthMaxHorizontalUncertainty", Float
    )
    depth = Column("depth", Float)
    depthUncertainty = Column("depthUncertainty", Float)
    magnitude = Column("magnitude", Float)
    magnitudeUncertainty = Column("magnitudeUncertainty", Float)
    rake = Column("rake", Float)
    rakeUncertainty = Column("rakeUncertainty", Float)
    dip = Column("dip", Float)
    dipUncertainty = Column("dipUncertainty", Float)
    strike = Column("strike", Float)
    strikeUncertainty = Column("strikeUncertainty", Float)
    type_ = Column("type", String)
    probability = Column("probability", Float)