import psycopg2
import datetime


db = psycopg2.connect("dbname=qdwstage user=qdwadmin host=172.17.97.57 password=Olap123$")
cursor = db.cursor()
db.commit()

sprint = 55
startdate = datetime.datetime(2016, 5, 30)
startdayid = 1172

while sprint < 70:
    end = startdate + datetime.timedelta(days=11)
    start = startdate.strftime("(%Y %b %d - ")
    end = end.strftime("%b %d)")

    name = 's' + str(sprint) + ' ' + start+end
    print(name)

    cursor.execute("INSERT INTO public.sprints VALUES (%s,%s,%s,%s,%s,%s,%s)", (sprint, name, startdayid, startdayid + 13, startdayid +2, startdayid + 15, False))
    startdate += datetime.timedelta(days=14)
    startdayid += 14
    sprint += 1

db.commit()