|
1
|
|
|
# Copyright 2017 Starbot Discord Project |
|
2
|
|
|
# |
|
3
|
|
|
# Licensed under the Apache License, Version 2.0 (the "License"); |
|
4
|
|
|
# you may not use this file except in compliance with the License. |
|
5
|
|
|
# You may obtain a copy of the License at |
|
6
|
|
|
# |
|
7
|
|
|
# http://www.apache.org/licenses/LICENSE-2.0 |
|
8
|
|
|
# |
|
9
|
|
|
# Unless required by applicable law or agreed to in writing, software |
|
10
|
|
|
# distributed under the License is distributed on an "AS IS" BASIS, |
|
11
|
|
|
# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. |
|
12
|
|
|
# See the License for the specific language governing permissions and |
|
13
|
|
|
# limitations under the License. |
|
14
|
|
|
|
|
15
|
|
|
from api.database import DAL |
|
16
|
|
|
from api.database.db import DB |
|
17
|
|
|
from api.database.DAL import SQLite |
|
18
|
|
|
|
|
19
|
|
|
class Table: |
|
20
|
|
|
name = None |
|
21
|
|
|
table_type = None |
|
22
|
|
|
|
|
23
|
|
|
def __init__(self, name_in, type_in): |
|
24
|
|
|
self.name = name_in |
|
25
|
|
|
self.table_type = type_in |
|
26
|
|
|
|
|
27
|
|
|
DAL.db_create_table(DB, self.name) |
|
28
|
|
|
|
|
29
|
|
|
def insert(self, dataDict): |
|
30
|
|
|
return DAL.db_insert(DB, self, dataDict) |
|
31
|
|
|
|
|
32
|
|
|
def search(self, searchTerm, searchFor): |
|
33
|
|
|
return SQLite.db_search(DB, self, searchTerm, searchFor) |
|
34
|
|
|
|
|
35
|
|
|
def getContents(self, rows): |
|
36
|
|
|
return DAL.db_get_contents_of_table(DB, self, rows) |
|
37
|
|
|
|
|
38
|
|
|
def getLatestID(self): |
|
39
|
|
|
return DAL.db_get_latest_id(DB, self) |
|
40
|
|
|
|
|
41
|
|
|
class TableTypes: |
|
42
|
|
|
pServer = 1 |
|
43
|
|
|
pGlobal = 2 |
StarbotDiscord /
Starbot
