def test_create_db(self):
"""Test `crd()` of `create_db()` in `database.py`.
Test 1: Assert warning for `CDW` of `CreationDeletionWarning`.
Test 2: Assert warning for `CDW` of `CreationDeletionWarning`.
Test 3: Assert true for `test_list_1[len(test_list_1) - 1]` is
`r.ast.DbCreate`.
Test 4: Assert not none for valid `crd()` object.
Test 5: Assert none for counterfeit `crd()` object.
Test 6: Assert false for `test_list_1[len(test_list_1) - 4]` is not
`r.ast.DbCreate`.
Test 7: Assert none for counterfeit `crd()` object.
Test 8: Assert none for counterfeit `crd()` object.
"""
function_name = sys._getframe().f_code.co_name
db_name = "{}_{}".format(function_name, "db")
db_name_illegal_by_rdb = "{}_{}".format(db_name, self.ILLEGAL_BY_RDB)
db_name_illegal_by_this_program = "{}_{}".format(
db_name, self.ILLEGAL_BY_THIS_PROGRAM)
test_list_1 = [db_name, False, None, None, False]
test_list_2 = [db_name_illegal_by_rdb, None]
test_list_3 = [db_name_illegal_by_this_program, None]
test_list_1[len(test_list_1) - 1] = isinstance(
crd(self.c, test_list_1[0], True), r.ast.DbCreate)
test_list_1[len(test_list_1) - 2] = crd(self.c, test_list_1[0])
test_list_1[len(test_list_1) - 3] = crd(self.c, test_list_1[0])
test_list_1[len(test_list_1) - 4] = isinstance(
crd(self.c, test_list_1[0], True), r.ast.DbCreate)
dd(self.c, test_list_1[0])
"""Test 1."""
with self.assertWarns(CDW):
test_list_2[len(test_list_2) - 1] = crd(self.c, test_list_2[0])
"""Test 2."""
with self.assertWarns(CDW):
test_list_3[len(test_list_3) - 1] = crd(self.c, test_list_3[0])
self.assertTrue(test_list_1[len(test_list_1) - 1]) # Test 3.
self.assertIsNotNone(test_list_1[len(test_list_1) - 2]) # Test 4.
self.assertIsNone(test_list_1[len(test_list_1) - 3]) # Test 5.
self.assertFalse(test_list_1[len(test_list_1) - 4]) # Test 6.
self.assertIsNone(test_list_2[len(test_list_2) - 1]) # Test 7.
self.assertIsNone(test_list_3[len(test_list_3) - 1]) # Test 8.
def test_check_db(self):
"""Test `cd()` of `check_db()` in `database.py`.
Test 1: Assert warning for `CW` of `ConventionWarning`.
Test 2: Assert true for database exists.
Test 3: Assert false for database does not exists.
Test 4: Assert true for database exist.
"""
function_name = sys._getframe().f_code.co_name
db_name = "{}_{}".format(function_name, "db")
db_name_illegal_by_rdb = "{}_{}".format(
db_name,
self.ILLEGAL_BY_RDB
)
db_name_illegal_by_this_program = "{}_{}".format(
db_name,
self.ILLEGAL_BY_THIS_PROGRAM
)
test_list_1 = [db_name, False]
test_list_2 = [db_name_illegal_by_rdb, False]
test_list_3 = [db_name_illegal_by_this_program, False]
crd(self.c, test_list_1[0])
test_list_1[len(test_list_1) - 1] = cd(self.c, test_list_1[0])
dd(self.c, test_list_1[0])
test_list_2[len(test_list_2) - 1] = cd(self.c, test_list_2[0])
r.db_create(test_list_3[0]).run(self.c)
"""Test 1."""
with self.assertWarns(CW):
test_list_3[len(test_list_3) - 1] = cd(self.c, test_list_3[0])
r.db_drop(test_list_3[0]).run(self.c)
self.assertTrue(test_list_1[len(test_list_1) - 1]) # Test 2.
self.assertFalse(test_list_2[len(test_list_2) - 1]) # Test 3.
self.assertTrue(test_list_3[len(test_list_3) - 1]) # Test 4.
def createdeck():
decklist = database.fetch_deck()
frame = tk.Frame(root, bg=background, bd=4)
frame.place(relheight=0.75, relwidth=0.9, relx=0.5, rely=0.1, anchor='n')
label = tk.Label(frame,
text='Enter Deck Name',
font=20,
bg=bannerblue,
fg='black')
label.place(relwidth=0.2, relheight=0.1, relx=0.1, rely=0.1)
entry = tk.Entry(frame, bd=2, bg=background, fg='white', font=20)
entry.place(relwidth=0.4, relheight=0.1, relx=0.33, rely=0.1)
button = tk.Button(frame,
text='Submit',
font=20,
bg=bannergrey,
fg='black',
command=lambda: deckedit(entry))
button.place(relx=0.35, rely=0.26, relwidth=0.2, relheight=0.1)
button = tk.Button(frame,
text='Delete',
font=20,
bg=bannergrey,
fg='black',
command=lambda: database.dd(entry.get()))
button.place(relx=0.55, rely=0.26, relwidth=0.2, relheight=0.1)
label = tk.Label(frame,
text='Pre Existing decks are:',
font=20,
bg=bannerpurple,
fg='black')
label.place(relwidth=1, relheight=0.1, rely=0.4)
label = tk.Label(frame, text=decklist, font=20)
label.place(relwidth=1, relheight=0.35, rely=0.5)
bt = tk.Button(frame,
text="Back",
font=20,
bg=bannerred,
fg="black",
command=lambda: maindeck())
bt.place(relx=.75, rely=0.89, relwidth=0.16, relheight=0.1)
def test_create_table(self):
"""Test `crt()` of `create_table()` in `database.py`.
Test 1 : Assert warning for `CDW` of `CreationDeletionWarning`.
Test 2 : Assert warning for `CDW` of `CreationDeletionWarning`.
Test 3 : Assert warning for `CDW` of `CreationDeletionWarning`.
Test 4 : Assert warning for `CDW` of `CreationDeletionWarning`.
Test 5 : Assert warning for `CDW` of `CreationDeletionWarning`.
Test 6 : Assert warning for `CDW` of `CreationDeletionWarning`.
Test 7 : Assert warning for `CDW` of `CreationDeletionWarning`.
Test 8 : Assert warning for `CDW` of `CreationDeletionWarning`.
Test 9 : Assert true for `test_list_1[len(test_list_1) - 1]` is
`r.ast.TableCreate`.
Test 10: Assert not none for valid `crt()` object.
Test 11: Assert none for counterfeit `crt()` object.
Test 12: Assert false for `test_list_1[len(test_list_1) - 4]` is not
`r.ast.TableCreate`.
Test 13: Assert none for counterfeit `crt()` object.
Test 14: Assert none for counterfeit `crt()` object.
Test 15: Assert none for counterfeit `crt()` object.
Test 16: Assert none for counterfeit `crt()` object.
Test 17: Assert none for counterfeit `crt()` object.
Test 18: Assert none for counterfeit `crt()` object.
Test 19: Assert none for counterfeit `crt()` object.
Test 20: Assert none for counterfeit `crt()` object.
"""
function_name = sys._getframe().f_code.co_name
db_name = "{}_{}".format(function_name, "db")
db_name_illegal_by_rdb = "{}_{}".format(db_name, self.ILLEGAL_BY_RDB)
db_name_illegal_by_this_program = "{}_{}".format(
db_name, self.ILLEGAL_BY_THIS_PROGRAM)
table_name = "{}_{}".format(function_name, "table")
table_name_illegal_by_rdb = "{}_{}".format(table_name,
self.ILLEGAL_BY_RDB)
table_name_illegal_by_this_program = "{}_{}".format(
table_name, self.ILLEGAL_BY_THIS_PROGRAM)
test_list_1 = [db_name, table_name, None, None, None, None]
test_list_2 = [db_name, table_name_illegal_by_rdb, None]
test_list_3 = [db_name, table_name_illegal_by_this_program, None]
test_list_4 = [db_name_illegal_by_rdb, table_name, None]
test_list_5 = [db_name_illegal_by_rdb, table_name_illegal_by_rdb, None]
test_list_6 = [
db_name_illegal_by_rdb, table_name_illegal_by_this_program, None
]
test_list_7 = [db_name_illegal_by_this_program, table_name, None]
test_list_8 = [
db_name_illegal_by_this_program, table_name_illegal_by_rdb, None
]
test_list_9 = [
db_name_illegal_by_this_program,
table_name_illegal_by_this_program, None
]
crd(self.c, test_list_1[0])
test_list_1[len(test_list_1) - 1] = isinstance(
crt(self.c, test_list_1[1], test_list_1[0], True),
r.ast.TableCreate)
test_list_1[len(test_list_1) - 2] = crt(self.c, test_list_1[1],
test_list_1[0])
test_list_1[len(test_list_1) - 3] = crt(self.c, test_list_1[1],
test_list_1[0])
test_list_1[len(test_list_1) - 4] = isinstance(
crt(self.c, test_list_1[1], test_list_1[0], True),
r.ast.TableCreate)
dd(self.c, test_list_1[0])
crd(self.c, test_list_2[0])
"""Test 1."""
with self.assertWarns(CDW):
test_list_2[len(test_list_2) - 1] = crt(self.c, test_list_2[1],
test_list_2[0])
dd(self.c, test_list_2[0])
crd(self.c, test_list_3[0])
"""Test 2."""
with self.assertWarns(CDW):
test_list_3[len(test_list_3) - 1] = crt(self.c, test_list_3[1],
test_list_3[0])
dd(self.c, test_list_3[0])
"""Test 3."""
with self.assertWarns(CDW):
test_list_4[len(test_list_4) - 1] = crt(self.c, test_list_4[1],
test_list_4[0])
"""Test 4."""
with self.assertWarns(CDW):
test_list_5[len(test_list_5) - 1] = crt(self.c, test_list_5[1],
test_list_5[0])
"""Test 5."""
with self.assertWarns(CDW):
test_list_6[len(test_list_6) - 1] = crt(self.c, test_list_6[1],
test_list_6[0])
r.db_create(test_list_7[0]).run(self.c)
"""Test 6."""
with self.assertWarns(CDW):
test_list_7[len(test_list_7) - 1] = crt(self.c, test_list_7[1],
test_list_7[0])
r.db_drop(test_list_7[0]).run(self.c)
r.db_create(test_list_8[0]).run(self.c)
"""Test 7."""
with self.assertWarns(CDW):
test_list_8[len(test_list_8) - 1] = crt(self.c, test_list_8[1],
test_list_8[0])
r.db_drop(test_list_8[0]).run(self.c)
r.db_create(test_list_9[0]).run(self.c)
"""Test 8."""
with self.assertWarns(CDW):
test_list_9[len(test_list_9) - 1] = crt(self.c, test_list_9[1],
test_list_9[0])
r.db_drop(test_list_9[0]).run(self.c)
self.assertTrue(test_list_1[len(test_list_1) - 1]) # Test 9.
self.assertIsNotNone(test_list_1[len(test_list_1) - 2]) # Test 10.
self.assertIsNone(test_list_1[len(test_list_1) - 3]) # Test 11.
self.assertFalse(test_list_1[len(test_list_1) - 4]) # Test 12.
self.assertIsNone(test_list_2[len(test_list_2) - 1]) # Test 13.
self.assertIsNone(test_list_3[len(test_list_3) - 1]) # Test 14.
self.assertIsNone(test_list_4[len(test_list_4) - 1]) # Test 15.
self.assertIsNone(test_list_5[len(test_list_5) - 1]) # Test 16.
self.assertIsNone(test_list_6[len(test_list_6) - 1]) # Test 17.
self.assertIsNone(test_list_7[len(test_list_7) - 1]) # Test 18.
self.assertIsNone(test_list_8[len(test_list_8) - 1]) # Test 19.
self.assertIsNone(test_list_9[len(test_list_9) - 1]) # Test 20.
def test_create_doc(self):
"""Test `crdoc` of `create_doc` in `database.py`.
Test 1 : Assert warning for `CDW` of `CreationDeletionWarning`.
Test 2 : Assert warning for `CDW` of `CreationDeletionWarning`.
Test 3 : Assert warning for `CDW` of `CreationDeletionWarning`.
Test 4 : Assert warning for `CDW` of `CreationDeletionWarning`.
Test 5 : Assert true for `test_list_1[len(test_list_1) - 1]` is
`r.ast.Insert`.
Test 6 : Assert not none for valid `crdoc()` object.
Test 7 : Assert none for counterfeit `crdoc()` object.
Test 8 : Assert true for `test_list_1[len(test_list_1) - 4]` is not
`r.ast.Insert`.
Test 9 : Assert not none for valid `crdoc()` object.
Test 10: Assert none for counterfeit `crdoc()` object.
Test 11: Assert not none for valid `crdoc()` object.
Test 12: Assert none for counterfeit `crdoc()` object.
Test 13: Assert none for counterfeit `crdoc()` object.
Test 14: Assert none for counterfeit `crdoc()` object.
Test 15: Assert none for counterfeit `crdoc()` object.
DONE: Create assert warning for invalid database and table.
"""
function_name = sys._getframe().f_code.co_name
db_name = "{}_{}".format(function_name, "db")
db_name_illegal_by_rdb = "{}_{}".format(db_name, self.ILLEGAL_BY_RDB)
db_name_illegal_by_this_program = "{}_{}".format(
db_name, self.ILLEGAL_BY_THIS_PROGRAM)
table_name = "{}_{}".format(function_name, "table")
table_name_illegal_by_rdb = "{}_{}".format(table_name,
self.ILLEGAL_BY_RDB)
table_name_illegal_by_this_program = "{}_{}".format(
table_name, self.ILLEGAL_BY_THIS_PROGRAM)
doc_1 = {"name": "alpha", "no": "1"}
doc_2 = {"name": "beta", "no": "2"}
doc_3 = {"name": "charlie", "no": "1"}
doc_4 = {"name": "charlie", "no": "3"}
test_list_1 = [
db_name, table_name, doc_1, ["no"], False, None, None, False
]
test_list_2 = [test_list_1[0], test_list_1[1], doc_2, ["no"], None]
test_list_3 = [test_list_1[0], test_list_1[1], doc_3, ["no"], None]
test_list_4 = [
test_list_1[0], test_list_1[1], doc_4, ["name", "no"], None
]
test_list_5 = [
db_name_illegal_by_rdb, table_name_illegal_by_rdb, doc_1, None
]
test_list_6 = [
db_name_illegal_by_rdb, table_name_illegal_by_this_program, doc_1,
None
]
test_list_7 = [
db_name_illegal_by_this_program, table_name_illegal_by_rdb, doc_1,
None
]
test_list_8 = [
db_name_illegal_by_this_program,
table_name_illegal_by_this_program, doc_1, None
]
crd(self.c, test_list_1[0])
crt(self.c, test_list_1[1], test_list_1[0])
test_list_1[len(test_list_1) - 1] = isinstance(
crdoc(self.c,
test_list_1[2],
test_list_1[1],
test_list_1[0],
_expr=True), r.ast.Insert)
test_list_1[len(test_list_1) - 2] = crdoc(self.c, test_list_1[2],
test_list_1[1],
test_list_1[0])
test_list_1[len(test_list_1) - 3] = crdoc(self.c, test_list_1[2],
test_list_1[1],
test_list_1[0],
test_list_1[3])
test_list_1[len(test_list_1) - 4] = isinstance(
crdoc(self.c, test_list_1[2], test_list_1[1], test_list_1[0],
["name", "no"], True), r.ast.Insert)
test_list_2[len(test_list_2) - 1] = crdoc(self.c, test_list_2[2],
test_list_2[1],
test_list_2[0],
test_list_2[3])
crt(self.c, test_list_3[1], test_list_3[0])
test_list_3[len(test_list_3) - 1] = crdoc(self.c, test_list_3[2],
test_list_3[1],
test_list_3[0],
test_list_3[3])
test_list_4[len(test_list_4) - 1] = crdoc(self.c, test_list_4[2],
test_list_4[1],
test_list_4[0],
test_list_4[3])
dd(self.c, test_list_1[0])
"""Test 1."""
with self.assertWarns(CDW):
test_list_5[len(test_list_5) - 1] = crdoc(self.c, test_list_5[2],
test_list_5[1],
test_list_5[0])
"""Test 2."""
with self.assertWarns(CDW):
test_list_6[len(test_list_6) - 1] = crdoc(self.c, test_list_6[2],
test_list_6[1],
test_list_6[0])
r.db_create(test_list_7[0]).run(self.c)
"""Test 3."""
with self.assertWarns(CDW):
test_list_7[len(test_list_7) - 1] = crdoc(self.c, test_list_7[2],
test_list_7[1],
test_list_7[0])
r.db_drop(test_list_7[0]).run(self.c)
r.db_create(test_list_8[0]).run(self.c)
r.db(test_list_8[0]).table_create(test_list_8[0]).run(self.c)
"""Test 4."""
with self.assertWarns(CDW):
test_list_8[len(test_list_8) - 1] = crdoc(self.c, test_list_8[2],
test_list_8[1],
test_list_8[0])
r.db_drop(test_list_8[0]).run(self.c)
self.assertTrue(test_list_1[len(test_list_1) - 1]) # Test 5.
self.assertIsNotNone(test_list_1[len(test_list_1) - 2]) # Test 6.
self.assertIsNone(test_list_1[len(test_list_1) - 3]) # Test 7.
self.assertFalse(test_list_1[len(test_list_1) - 4]) # Test 8
self.assertIsNotNone(test_list_2[len(test_list_2) - 1]) # Test 9.
self.assertIsNone(test_list_3[len(test_list_3) - 1]) # Test 10.
self.assertIsNotNone(test_list_4[len(test_list_4) - 1]) # Test 11.
self.assertIsNone(test_list_5[len(test_list_5) - 1]) # Test 12.
self.assertIsNone(test_list_6[len(test_list_6) - 1]) # Test 13.
self.assertIsNone(test_list_7[len(test_list_7) - 1]) # Test 14.
self.assertIsNone(test_list_8[len(test_list_8) - 1]) # Test 15.
def test_check_table(self):
"""Test `ct()` of `check_table()` in `database.py`.
Test 1 : Assert warning for `CW` of `ConventionWarning`.
Test 2 : Assert warning for `CW` of `ConventionWarning`.
Test 3 : Assert warning for `CW` of `ConventionWarning`.
Test 4 : Assert warning for `CW` of `ConventionWarning`.
Test 5 : Assert true for table exists.
Test 6 : Assert false for table does not exists.
Test 7 : Assert true for table exists.
Test 8 : Assert false for table does not exists.
Test 9 : Assert false for table does not exists.
Test 10: Assert false for table does not exists.
Test 11: Assert true for table exists.
Test 12: Assert false for table does not exists.
Test 13: Assert true for table exists.
"""
function_name = sys._getframe().f_code.co_name
db_name = "{}_{}".format(function_name, "db")
db_name_illegal_by_rdb = "{}_{}".format(
db_name,
self.ILLEGAL_BY_RDB
)
db_name_illegal_by_this_program = "{}_{}".format(
db_name,
self.ILLEGAL_BY_THIS_PROGRAM
)
table_name = "{}_{}".format(function_name, "table")
table_name_illegal_by_rdb = "{}_{}".format(
table_name,
self.ILLEGAL_BY_RDB
)
table_name_illegal_by_this_program = "{}_{}".format(
table_name,
self.ILLEGAL_BY_THIS_PROGRAM
)
test_list_1 = [
db_name,
table_name,
False
]
test_list_2 = [
db_name,
table_name_illegal_by_rdb,
False
]
test_list_3 = [
db_name,
table_name_illegal_by_this_program,
False
]
test_list_4 = [
db_name_illegal_by_rdb,
table_name,
False
]
test_list_5 = [
db_name_illegal_by_rdb,
table_name_illegal_by_rdb,
False
]
test_list_6 = [
db_name_illegal_by_rdb,
table_name_illegal_by_this_program,
False
]
test_list_7 = [
db_name_illegal_by_this_program,
table_name,
False
]
test_list_8 = [
db_name_illegal_by_this_program,
table_name_illegal_by_rdb,
False
]
test_list_9 = [
db_name_illegal_by_this_program,
table_name_illegal_by_this_program,
False
]
crd(self.c, test_list_1[0])
crt(self.c, test_list_1[1], test_list_1[0])
test_list_1[len(test_list_1) - 1] = ct(
self.c,
test_list_1[1],
test_list_1[0]
)
dd(self.c, test_list_1[0])
test_list_2[len(test_list_2) - 1] = ct(
self.c,
test_list_2[1],
test_list_2[0]
)
r.db_create(test_list_3[0]).run(self.c)
r.db(test_list_3[0]).table_create(test_list_3[1]).run(self.c)
"""Test 1."""
with self.assertWarns(CW):
test_list_3[len(test_list_3) - 1] = ct(
self.c,
test_list_3[1],
test_list_3[0]
)
r.db_drop(test_list_3[0]).run(self.c)
test_list_4[len(test_list_4) - 1] = ct(
self.c,
test_list_4[1],
test_list_4[0]
)
test_list_5[len(test_list_5) - 1] = ct(
self.c,
test_list_5[1],
test_list_5[0]
)
test_list_6[len(test_list_6) - 1] = ct(
self.c,
test_list_6[1],
test_list_6[0]
)
r.db_create(test_list_7[0]).run(self.c)
r.db(test_list_7[0]).table_create(test_list_7[1]).run(self.c)
"""Test 2."""
with self.assertWarns(CW):
test_list_7[len(test_list_7) - 1] = ct(
self.c,
test_list_7[1],
test_list_7[0]
)
r.db_drop(test_list_7[0]).run(self.c)
r.db_create(test_list_8[0]).run(self.c)
"""Test 3."""
with self.assertWarns(CW):
test_list_8[len(test_list_8) - 1] = ct(
self.c,
test_list_8[1],
test_list_8[0]
)
r.db_drop(test_list_8[0]).run(self.c)
r.db_create(test_list_9[0]).run(self.c)
r.db(test_list_9[0]).table_create(test_list_9[1]).run(self.c)
"""Test 4."""
with self.assertWarns(CW):
test_list_9[len(test_list_9) - 1] = ct(
self.c,
test_list_9[1],
test_list_9[0]
)
r.db_drop(test_list_9[0]).run(self.c)
self.assertTrue(test_list_1[len(test_list_1) - 1]) # Test 5.
self.assertFalse(test_list_2[len(test_list_2) - 1]) # Test 6.
self.assertTrue(test_list_3[len(test_list_3) - 1]) # Test 7.
self.assertFalse(test_list_4[len(test_list_4) - 1]) # Test 8.
self.assertFalse(test_list_5[len(test_list_5) - 1]) # Test 9.
self.assertFalse(test_list_6[len(test_list_6) - 1]) # Test 10.
self.assertTrue(test_list_7[len(test_list_7) - 1]) # Test 11.
self.assertFalse(test_list_8[len(test_list_8) - 1]) # Test 12.
self.assertTrue(test_list_9[len(test_list_9) - 1]) # Test 13.