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