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()