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