from todoist.api import TodoistAPI
import pymssql

api = TodoistAPI('17e6e3dd2271c2049b0d25dae87482a7a7938ffa')
api.sync()

db = pymssql.connect(server='dndto.me', port='2433', user='dndapp', password='jungle', database='loyd')
cursor = db.cursor()

for project in api.state['projects']:
    print("inserting " + project['name'])
    cursor.execute("INSERT dbo.Projects (id, name) VALUES (" + str(project['id']) + ", '" + project['name'] + "')")

db.commit()
db.close()