Spaces:
Running
on
Zero
Running
on
Zero
File size: 552 Bytes
b2add11 |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 |
from crud.crud import CRUD
def main():
crud = CRUD("sample.db")
crud.create("sample", ["id INTEGER", "name TEXT", "age INTEGER"], [1, "John", 25])
crud.create("sample", ["id INTEGER", "name TEXT", "age INTEGER"], [2, "Jane", 30])
print(crud.read("sample", ["id", "name", "age"]))
crud.update("sample", ["name", "age"], ["Jane", 31], "id = 2")
print(crud.read("sample", ["id", "name", "age"]))
crud.delete("sample", "id = 1")
print(crud.read("sample", ["id", "name", "age"]))
if __name__ == "__main__":
main()
|