deltatime calculation

[D_frucht]

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)

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

[j.crater]

Can you be more specific about what the problem is?
Do you get an error? In that case post the full error traceback message, in error tags.
Is the result not as expected? In that case present your actual result vs. desired outcome.

[D_frucht]

@J.crater, im sorry you are right. as you can see in the error below, the user input regarding order date was:2018-01-01. the user obligated to the client to deliver in 2 weeks. i want the outcome to show 2018-01-15
please see below the error:

Error:
Please enter client name: dd
Please enter model name: dd
Please enter quantity: 2
Please enter order date YYYY-MM-DD: 2018-01-01
Please enter number of weeks fot delivery date: 2
Traceback (most recent call last):
  File "/Users/davidfrucht/PycharmProjects/dfsl_db/DFSL.py", line 35, in <module>
    dynamic_data_entry()
  File "/Users/davidfrucht/PycharmProjects/dfsl_db/DFSL.py", line 19, in dynamic_data_entry
    delivery_date_c = datetime.date(order_date) + datetime.timedelta(weeks=delivery_date) # str(datetime.timedelta(weeks=delivery_date))
TypeError: an integer is required (got type str)

[D_frucht]

can someone help me please

[snippsat]

You most first parse the date input with strptime() then add 5 weeks.

>>> from datetime import datetime
>>> 
>>> order_date = '2018-10-11'
>>> delivery_date = 5
>>> dt = datetime.strptime(order_date, '%Y-%m-%d')
>>> dt
datetime.datetime(2018, 10, 11, 0, 0)
>>> # Now can add weeks
>>> dt + timedelta(weeks=delivery_date)
datetime.datetime(2018, 11, 15, 0, 0)

[D_frucht]

thanks !!!!

just one little mistake, there should be another .datetime before the .strptime

datetime.datetime.strptime(order_date, '%Y-%m-%d')

[buran]

just one little mistake, there should be another .datetime before the .strptime

well, it's not a mistake. Note the difference between snipssat code from datetime import datetime and yours import datetime. Both are correct, but latter on, there is difference how you reference