conn = sqlite3.connect('users.db')

@route('/pushdata', method='POST')
def push():
    if request.POST.save:
        conn.execute("CREATE TABLE IF NOT EXISTS users (nick TEXT)")
        new = request.POST.task.strip()
        print(new)
        cursor = conn.cursor()
        cursor.execute("INSERT INTO users (nick) VALUES (?)", (nick))

        conn.commit()
        conn.close()

        return 'done'
    else:
        return 'not done'


@route('/databasecheck')
def databasecheck():
    cursor = conn.cursor()
    cursor.execute("SELECT count(*) FROM users")
    nick = cursor.fetchall()
    return template('databasecheck', nick = nick)