Your problem is with Python, not SQLite. The things you're doing work fine in SQLite. You will get better help asking in a Python forum.
Your problem is with Python, not SQLite. The things you're doing work fine in SQLite. You will get better help asking in a Python forum.