import itertools
import requests
import xml.etree.ElementTree as ET
import sqlite3
import json

dbconn = sqlite3.connect('roster.db', check_same_thread=False)
db = dbconn.cursor()
db.execute('''CREATE TABLE IF NOT EXISTS members(userid int, handle text, joindate text, gender text, roles text)''')

s = requests.Session()
s.post('https://example.com/api/account/signin', data={'username':'username', 'password' : 'password', 'remember' : '1'})

for i in itertools.count(1):
    count = str(i)
    xml = s.get('https://example.com/api/users/get.ext', params={'user' : count})
    userdata = ET.fromstring(xml.content)

    for elem in userdata.iterfind('Profile/UserID'):
        userid = elem.text

    for elem in userdata.iter(tag='Name'):
        handle = elem.text

    for elem in userdata.iter(tag='DateFirstVisit'):
        joindate = elem.text

    for elem in userdata.iterfind('Profile/Gender'):
        gender = elem.text

    roles = [elem.text for elem in userdata.findall('UserRoles/Item')]
    rolelist = json.dumps(roles)
    print(userid, handle, joindate, gender, rolelist)

    userinsert = [userid, handle, joindate, gender, rolelist]

    db.execute("INSERT INTO members VALUES (?,?,?,?,?)", userinsert)
    dbconn.commit()