fyCursor
fyCursor is a tool to manage sqlite3 databases via special cursor that don’t have usual sqlite3 text query.
SIMPLE USAGE
1from fyCursor import connect
2
3cursor = connect("database.db")
4
5# you can execute basic sqlite3 script if fyCursor does not have its functionality yet.
6cursor.execute("""
7 CREATE TABLE myTable(
8 id INTEGER PRIMARY KEY
9 name STRING
10 money INTEGER
11""") #creating a table
12
13# get money of user with name "felix"
14felixMoney = cursor.select("money", from_="myTable").where(name="felix").one()
15
16# change money of user with id 5
17cursor.update("myTable").set(money=349).where(id=5).commit()
18
19# add 5 to money to all users
20cursor.update("myTable").add(money=5).commit()
21