-
Notifications
You must be signed in to change notification settings - Fork 2
/
sqlCrudTest.py
33 lines (24 loc) · 1.13 KB
/
sqlCrudTest.py
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
from datetime import datetime
from SqlManager.SqlManager import SqlManager
name = 'table1'
fields = [('field1', 'VARCHAR(50)'), ('field2', 'INTEGER'), ('timestamp', 'BIGINT')]
dateTime = int(datetime.strptime('01-01-2010 10:00:00', '%d-%m-%Y %H:%M:%S').strftime('%s'))
insertFields = ['field1', 'field2', 'timestamp']
insertValues = [['"hello"', 15, dateTime], ['"byebye"', 10, dateTime], ['"hi"', 20, dateTime], ['"boo"', 25, dateTime]]
def testSql(databaseHandler):
databaseHandler.CreateDatabase('testDb123')
databaseHandler.SetDatabase('testDb123')
databaseHandler.CreateTable(name, fields)
databaseHandler.InsertRecord(name, insertFields, insertValues[0])
databaseHandler.InsertRecord(name, insertFields, insertValues[1])
databaseHandler.InsertManyRecords(name, insertFields, insertValues)
databaseHandler.SelectAll(name)
databaseHandler.DeleteTable(name)
databaseHandler.DeleteDatabase('testDb123')
databaseHandler.Dispose()
if __name__ == "__main__":
sqlManager = SqlManager('')
# MySql
testSql(sqlManager.GetSqlHandler(SqlManager.MYSQL, True))
# Sqlite
testSql(sqlManager.GetSqlHandler(SqlManager.SQLITE, True))