May-18-2018, 06:14 PM
hello.
i have problems with delta time calc. there are 2 relevant var, that a user input: date of order and number of weeks to deliver the order.
another var is the calculated date (order date + weeks to deliver)
i have problems with delta time calc. there are 2 relevant var, that a user input: date of order and number of weeks to deliver the order.
another var is the calculated date (order date + weeks to deliver)
import sqlite3 import datetime conn = sqlite3.connect('dfsl.db') c = conn.cursor() def create_table(): c.execute("CREATE TABLE IF NOT EXISTS orders (Client TEXT, Model TEXT, Quantity TEXT, Order_date DATE, Delivery_date INTEGER, Delivery_date_c DATE)") conn.commit() def dynamic_data_entry(): client = input('Please enter client name: ') model = input('Please enter model name: ') quantity = input('Please enter quantity: ') order_date = input('Please enter order date YYYY-MM-DD: ') delivery_date = int(input('Please enter number of weeks fot delivery date: ')) delivery_date_c = datetime.date(order_date) + datetime.timedelta(weeks=delivery_date) # str(datetime.timedelta(weeks=delivery_date)) c.execute("INSERT INTO orders (Client, Model, Quantity, Order_date, Delivery_date, Delivery_date_c) VALUES (?, ?, ?, ?, ?, ?)", (client, model, quantity, order_date, delivery_date, delivery_date_c)) conn.commit() def read_from_db(): c.execute('SELECT client, model, quantity, delivery_date_c FROM orders') for row in c.fetchall(): print(row) create_table() dynamic_data_entry() read_from_db() conn.close()