Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- def export_data():
- infos = [
- 'Conta Corrente Itau',
- 'Cartao Itau Master',
- 'Cartao Itau VISA',
- 'Carteira'
- ]
- chart_of_accounts = list(infos)
- for account in chart_of_accounts:
- cnx = mariadb.connect(user='root', password='', database='base_completa')
- cursor = cnx.cursor()
- params = (account, account)
- query = """
- SELECT Y, M,(@total := @total + Fluxo) AS ValorTotal
- FROM (
- SELECT year(data) AS Y, month(data) AS M,
- (
- SUM(IF(Credito="%s", valor, 0))-
- SUM(IF(Debito="%s", valor, 0))
- ) AS Fluxo
- FROM ledger
- GROUP BY YEAR(DATA), MONTH(DATA)
- ) AS T,
- (SELECT @total:=0) AS n;
- """ % (params)
- cursor.execute(query)
- rows = cursor.fetchall()
- desc = cursor.description
- lista = [dict(itertools.izip([col[0] for col in desc], row))
- for row in rows]
- cnx.commit()
- print account
- print json.dumps(lista)
- return lista
- results = export_data()
- cursor.execute(query, (chart_of_accounts[account] for account in chart_of_accounts))
- SUM(IF(Credito=""Conta Corrente Itau"", valor, 0))
- SUM(IF(Credito="%s", valor, 0))
- params = (account, account)
- with open(file_location+'\' + 'file_name' +'.sql','r') as inserts:
- sqlScript = inserts.read()
- for statement in sqlScript.split(';'):
- with cnx.cursor() as cur:
- cur.execute(statement)
- query="Select * from output_table"
- df=pd.read_sql_query(query, cnx)
- Select * from output_table
Add Comment
Please, Sign In to add comment