def post(self):
data = request.get_json(force=True)
try:
c.execute(
"INSERT INTO products (id, sku, name, price, created_at, updated_at) "
"VALUES (?, ?, ?, ?, ?, ?)",
(data['id'], data['sku'], data['name'], data['price'],
data['created_at'], data['updated_at']))
except IntegrityError as e:
return str(e), 403
conn.commit()
return data, 200
def put(self, order_id):
data = request.get_json(force=True)
c.execute('select exists(select 1 from orders where id=(?))', (order_id,))
if True not in c.fetchall()[0]:
conn.close()
return "Order ID not found", 404
try:
c.execute("UPDATE orders SET status=(?), cancelDate=(?) WHERE id=(?)",
(data['status'], str(datetime.now().isoformat()), order_id))
except IntegrityError as e:
return str(e), 403
conn.commit()
return data, 200
def post(self):
data = request.get_json(force=True)
if not validar_cpf(data['cpf']):
return "CPF INVALIDO", 403
try:
c.execute(
"INSERT INTO customers (id, name, cpf, email, created_at, updated_at) "
"VALUES (?, ?, ?, ?, ?, ?)",
(data['id'], data['name'], data['cpf'], data['email'],
data['created_at'], data['updated_at']))
except IntegrityError as e:
return str(e), 403
conn.commit()
return data, 200
def generateToken():
token = ''.join(
random.sample(
string.ascii_letters + string.ascii_uppercase + string.digits, 50))
created_at = datetime.now().isoformat()
expire_date = (datetime.now() + timedelta(minutes=15)).isoformat()
c.execute(
"INSERT INTO tokens (token, created_at, expire_date) VALUES (?, ?, ?)",
(token, created_at, expire_date))
conn.commit()
response = {
"token": token,
"created_at": created_at,
"expire_date": expire_date
}
return jsonify(response), 200
def post(self):
data = request.get_json(force=True)
try:
c.execute('INSERT INTO orders (id, created_at, status, total, customer_id) '
'VALUES (?, ?, ?, ?, ?)', (data['id'], data['created_at'],
data['status'], data['total'],
data['buyer']['id']))
for item in data['items']:
c.execute("INSERT INTO orderItem (amount, price_unit, total, order_id, product_id) "
"VALUES (?, ?, ?, ?, ?)", (item['amount'], item['price_unit'],
item['total'], data['id'],
item['product']['id']))
except IntegrityError as e:
return str(e), 403
conn.commit()
return data, 200
def insert_values(table_name: str, values_string: str):
c = conn.cursor()
query = f"INSERT INTO {table_name} VALUES({values_string})"
c.execute(query)
conn.commit()