def test_del_DB_no_transac(self):
expected_db = SimpleDB()
self.test_db.delete('test_get_key')
self.assertEqual(self.test_db.getDB(), expected_db.getDB())
with self.assertRaises(Exception):
self.test_db.delete('test_bad_key')
with self.assertRaises(Exception):
self.test_db.delete(123)
def test_put_DB_no_transac(self):
expected_db = SimpleDB({
'test_get_key': 'test_val_1',
'test_key': 'test_value'
})
self.test_db.put('test_key', 'test_value')
self.assertEqual(self.test_db.getDB(), expected_db.getDB())
with self.assertRaises(Exception):
self.test_db.put('test_bad_key')
# Test bad input
with self.assertRaises(Exception):
self.test_db.put('test_bad_key', {'key': 123})
# Test bad key
with self.assertRaises(Exception):
self.test_db.put(123, '123')
import PySimpleGUI as sg
from service import PersionServiceImpl as psi
from service import DocFileServiceImpl as dsi
from create_doc_ui import CreateDocUI
from create_file_ui import CreateFileUI
from create_person_ui import CreatePersonUI
from person_detail_ui import PersonDetailUI
from doc_detail_ui import DocDetailUI
from db import SimpleDB
# read all person data from database
simple_db = SimpleDB()
simple_db.open(r"doc_management_sqlite3.db")
person_service = psi(simple_db)
doc_file_service = dsi(simple_db)
people = person_service.get_all_by_page(1, 40)
header = ["序号", "姓名", "性别", "身份证", "创建时间", "更新时间"]
col_widths = [8, 25, 6, 18, 25, 25]
skip_len = 0
for col_width in col_widths:
skip_len = skip_len + col_width
skip_len = skip_len - 45
data = []
for person in people:
elem = [
person.id, person.name, person.sex, person.id_card, person.update_time,
person.create_time
]
data.append(elem)
def setUp(self):
self.test_db = SimpleDB({
'test_get_key': 'test_val_1',
})
def setUp(self):
self.test_db = SimpleDB()