# !/usr/bin/env python
# *- coding: utf-8 -*-
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy.orm import relationship
from sqlalchemy import create_engine, ForeignKey, Column, Integer, Float, VARCHAR, Date
from SantaClaraPack.Config.Config import Config
config = Config().config_banco
Base = declarative_base()
class Posto(Base):
__tablename__ = 'tbl_posto'
num_usina = Column(Integer)
num_posto = Column(Integer, primary_key=True)
nom_usina = Column(VARCHAR(255))
nom_posto = Column(VARCHAR(255))
num_ordem = Column(Integer)
num_jusante = Column(Integer)
num_lat = Column(Float)
num_lon = Column(Float)
# Relações
vazoes = relationship('Vazao', back_populates='posto')
class Vazao(Base):
__tablename__ = 'tbl_vazao'
id = Column(Integer, primary_key=True)
num_posto = Column(Integer, ForeignKey('tbl_posto.num_posto'))
import pandas as pd
import numpy as np
import glob
import os
import netCDF4
import datetime
from SantaClaraPack.Config.Config import Config
from SantaClaraPack.Banco.Dados import Dados
config = Config().config
paths = glob.glob('../Data/temperature/*.nc')
batches = [[i, i + 100] for i in np.arange(0, 3650, 100)]
for batch in batches:
df_final = pd.DataFrame()
dfs = list()
print(batch)
# Itera sobre os todos os arquivos:
for arqv in paths:
df_aux = pd.DataFrame()
file = netCDF4.Dataset(filename=arqv)
var_name = os.path.basename(arqv)[9:13].lower()
#print(os.path.basename(arqv))
if var_name == 'tavg':
var_name = 'val_temp_med'
elif var_name == 'tmin':
def __init__(self):
self.config = Config().config
pass