Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- from datetime import datetime, timedelta
- import mysql.connector
- mydb = mysql.connector.connect(
- host="localhost",
- user="**USER**",
- passwd="**PASSWORT**",
- database="**DATABASE"**
- )
- # Table already created like this:
- # mycursor.execute("CREATE TABLE events2 (id INT AUTO_INCREMENT PRIMARYKEY, name VARCHAR(255), startdate DATETIME, enddate DATETIME, deadline INT, position INT, reminder INT)")
- name = "Testevent"
- startdate = datetime.now().strftime('%Y-%m-%d %H:%M:%S')
- enddate = datetime.now() + timedelta(days=14)
- deadline = 24
- position = 25
- reminder = 1
- sql = "INSERT INTO events2 (name, startdate, enddate, deadline, position, reminder) VALUES (%s, %s, %s, %s, %s, %s)"
- val = (name, startdate, enddate, deadline, position, reminder)
- mycursor.execute(sql, val)
- mydb.commit()
- mycursor = mydb.cursor()
- mycursor.execute("SELECT startdate FROM events2 WHERE id = '7'")
- myresult = mycursor.fetchone()
- print(myresult)
- y = myresult + timedelta(days=14)
- (datetime.datetime(2018, 8, 20, 18, 31, 42),)
- Traceback (most recent call last):
- File ".../Create_event.py", line 54, in <module>
- y = myresult + timedelta(days=14)
- TypeError: can only concatenate tuple (not "datetime.timedelta") to tuple
- y = myresult[0] + timedelta(days=14)
Add Comment
Please, Sign In to add comment