SQLITE3-Handler/table_example.py at master · phenibut645/SQLITE3-Handler · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
# SQLite3 Handler ( Table class ) example

example = {
  "table_name": "users",
  "columns":{
    "first_column":{
      "type":"INTEGER",
      "primary_key":True,
      "foreign_key":{
        "column":None
      },
      "constraint":"NOT NULL"
    },
    "second_column":{
      "type":"TEXT",
      "primary_key":False,
      "foreign_key":{
        "column":None
      },
      "constraint":"NOT NULL",
      "table": table
    },
    "third_column":{
      "type":"INTEGER",
      "primary_key":False,
      "foreign_key":{
        "column": Column,
      },
      "constraint":"NOT NULL"
    },
    "records":{
      "first_column":[],
      "second_column":[],
      "third_column":[]
    }
  }
}

column_records = [
  {
    column_objects:123,
    records:[]
  }
]