def get_expenses():
conn = pg.connect(dbname='postgres', user='******', password='******', host='192.168.99.102')
cur = conn.cursor()
cur.execute("SELECT * FROM byte_store")
trs = cur.fetchall()
trs = [pickle.loads(bytes(i[0])) for i in trs]
schema = ExpenseSchema(many=True)
expenses = schema.dump(
filter(lambda t: t.type == TransactionType.EXPENSE, trs)
)
resp = json.dumps(expenses.data, sort_keys = True, indent = 4, separators = (',', ': '))
return current_app.response_class(resp, mimetype="application/json")
def add_expense():
conn = pg.connect(dbname='postgres', user='******', password='******', host='192.168.99.102')
cur = conn.cursor()
expense = ExpenseSchema().load(request.get_json())
sample = pickle.dumps(expense.data)
cur.execute("INSERT INTO byte_store (trans) VALUES (%s);", (pg.Binary(sample),))
conn.commit()
# transactions.append(expense.data)
return '', 204
def add_expense():
expense = ExpenseSchema().load(request.get_json())
def get_expenses():
schema = ExpenseSchema(many=True)
def add_expense(): expense = ExpenseSchema().load(request.get_json()) transactions.append(expense.data) return "", 204
def get_expenses():
schema = ExpenseSchema(many=True)
expenses = schema.dump(
filter(lambda t: t.type == TransactionType.EXPENSE, transactions)
)
return jsonify(expenses.data)
def get_expenses():
#seleciona todas as transacoes com o tipo INCOME
schema = ExpenseSchema(many=True)
expenses = schema.dump(
filter(lambda t: t.type == TransactionType.EXPENSE, transactions))
return jsonify(expenses.data)
def add_expense():
# Add a new item to transaction type expense
expense = ExpenseSchema().load(request.get_json())
transactions.append(expense.data)
return "", 204
def add_expense():
expense = ExpenseSchema().make_expense(request.get_json())
transactions.append(expense)
return "", 204
