class concatenations(db.Model):
__tablename__ = 'concatenations'
__table_args__ = {'extend_existing': True}
bassin_concatene = db.Column('bassin_concatene', UUID(as_uuid=True), primary_key=True)
bassin_inclus = db.Column('bassin_inclus', UUID(as_uuid=True), primary_key=True)
def __repr__(self):
return '<concat {}>'.format(self.bassin_concatene)
class reservoir(db.Model):
__tablename__ = 'reservoir'
__table_args__ = {'extend_existing': True}
id_reservoir = db.Column('id_reservoir', db.Integer, primary_key=True)
nom_amenagement = db.Column('nom_amenagement', db.String)
uid = db.Column('uid', UUID(as_uuid=True))
def __repr__(self):
return '<reservoirs {}>'.format(self.id_reservoir)
class region(db.Model):
__tablename__ = 'region'
__table_args__ = {'extend_existing': True}
id_region = db.Column('id_region', db.Integer, primary_key=True)
nom_region = db.Column('nom_region', db.String)
value = db.Column('value', db.REAL)
def __repr__(self):
return '<date {}>'.format(self.value)
class don_series(db.Model):
__tablename__ = 'don_series'
__table_args__ = {'extend_existing': True}
id = db.Column('id', db.Integer, db.ForeignKey(meta_series.id), primary_key=True)
date = db.Column('date', db.DateTime(timezone=True), primary_key=True)
value = db.Column('value', db.REAL)
def __repr__(self):
return '<date {}>'.format(self.value)
class centrale(db.Model):
__tablename__ = 'centrale'
__table_args__ = {'extend_existing': True}
id_centrale = db.Column('id_centrale', db.Integer, primary_key=True)
nom_centrale = db.Column('nom_centrale', db.String)
uid = db.Column('uid', UUID(as_uuid=True))
def __repr__(self):
return '<centrale {}>'.format(self.id_centrale)
class closure_table(db.Model):
__tablename__ = 'closure_table'
__table_args__ = {'extend_existing': True}
predecessor = db.Column('predecessor', UUID(as_uuid=True), primary_key=True)
successor = db.Column('successor', UUID(as_uuid=True), primary_key=True)
depth = db.Column('depth', db.Integer)
def __repr__(self):
return '<predecessor {}, successor {}>'.format(self.predecessor,
self.successor)
class meta_series(db.Model):
__tablename__ = 'meta_series'
__table_args__ = {'extend_existing': True}
id = db.Column('id', db.Integer, primary_key=True, unique=True)
uid = db.Column('uid', UUID(as_uuid=True))
type_serie = db.Column('type_serie', db.String)
pas_de_temps = db.Column('pas_de_temps', db.String)
aggregation = db.Column('aggregation', db.String)
unites = db.Column('unites', db.String)
date_debut = db.Column('date_debut', db.DateTime(timezone=True))
date_fin = db.Column('date_fin', db.DateTime(timezone=True))
source = db.Column('source', db.String)
def __repr__(self):
return '<meta_ts {}>'.format(self.id)
class station(db.Model):
__tablename__ = 'station'
__table_args__ = {'extend_existing': True}
id_station = db.Column('id_station', db.Integer, primary_key=True)
numero_station = db.Column('numero_station', db.String)
province = db.Column('province', db.String)
latitude = db.Column('latitude', db.REAL)
longitude = db.Column('longitude', db.REAL)
uid = db.Column('uid', UUID(as_uuid=True))
def __repr__(self):
return '<amenagement {}>'.format(self.nom_amenagement)
class bassin(db.Model):
__tablename__ = 'bassin'
__table_args__ = {'extend_existing': True}
# id_bassin = db.Column('id_bassin', db.Integer, primary_key=True, unique=True)
uid = db.Column('uid', UUID(as_uuid=True), primary_key=True,
default=sqlalchemy.text("uuid_generate_v4()"))
numero_station = db.Column('numero_station', db.String, unique=True)
nom_station = db.Column('nom_station', db.String)
nom_equiv = db.Column('nom_equivalent', db.String)
province = db.Column('province', db.String)
regime = db.Column('regularisation', db.String)
superficie = db.Column('superficie', db.Integer)
latitude = db.Column('latitude', db.REAL)
longitude = db.Column('longitude', db.REAL)
geometry = db.Column('geometry', Geometry(geometry_type='POLYGON', srid=4326))
point = db.Column('latlon', Geometry(geometry_type='POINT', srid=4326))
def __repr__(self):
return '<basins {}>'.format(self.uid)