def test_insert_by_file_encoded(self):
# encoding of input / output files
# encoding of database content
append_text_to_file(
self.filename,
"database_name:" + b64encode(self.database_name) + "\n")
append_text_to_file(self.filename,
"table_name:" + b64encode(self.table_name) + "\n")
append_text_to_file(self.filename,
"delete_flag:" + b64encode("False") + "\n")
#append_text_to_file(self.filename,"decode_flag:"+b64encode("False") + "\n")
append_text_to_file(
self.filename, "columns:" +
"$$".join([b64encode(field) for field in self.columns]) + "\n")
put_2darray_in_file(self.filename,
self.row,
suffix="rows:",
encoding="base64")
DatabaseInsertRows.insert_by_file(self.filename)
database = Database(self.database_name, True)
with database:
_, result, _ = tbl_rows_get(database, self.table_name)
self.assertEqual(DatabaseBase._decode_2darray(result), self.row)
os_file_delete(self.filename)
def test_create_by_file_encoded_an_set_runtime_path(self):
self.filename = "b64pyshell.txt"
runtime_path = "C:\\Users\\burtnolej"
append_text_to_file(
self.filename,
"database_name:" + b64encode(self.database_name) + "\n")
append_text_to_file(self.filename,
"table_name:" + b64encode(self.table_name) + "\n")
append_text_to_file(self.filename,
"delete_flag:" + b64encode("False") + "\n")
append_text_to_file(
self.filename, "column_defns:" + "$$".join([
b64encode(_name) + "^" + b64encode(_type)
for _name, _type in self.column_defn
]) + "\n")
DatabaseCreateTable.create_by_file(self.filename,
runtime_path=runtime_path)
database = Database(
runtime_path + "\\" + self.database_name + ".sqlite", True)
with database:
self.assertTrue(tbl_exists(database, self.table_name))
os_file_delete(self.filename)
def test_get_table_list(self):
os_file_delete(self.filename)
append_text_to_file(
self.filename,
"database_name:" + b64encode(self.database_name) + "\n")
append_text_to_file(self.filename,
"delete_flag:" + b64encode("True") + "\n")
self.assertEquals(DatabaseMisc.get_table_list_by_file(self.filename),
[u'foobar'])
def test_fail_database(self):
os_file_delete(self.filename)
append_text_to_file(self.filename,
"database_name:" + b64encode("foofoo") + "\n")
append_text_to_file(self.filename,
"table_name:" + b64encode(self.table_name) + "\n")
append_text_to_file(self.filename,
"delete_flag:" + b64encode("True") + "\n")
self.assertFalse(DatabaseMisc.database_exists_by_file(self.filename))
os_file_delete(self.database_name + ".sqlite")
def test_(self):
os_file_delete(self.filename)
append_text_to_file(
self.filename,
"database_name:" + b64encode(self.database_name) + "\n")
append_text_to_file(self.filename,
"table_name:" + b64encode(self.table_name) + "\n")
append_text_to_file(self.filename,
"delete_flag:" + b64encode("True") + "\n")
self.assertTrue(DatabaseMisc.table_exists_by_file(self.filename))
def test_query_by_file(self):
self.filename = "unipyshell.txt"
append_text_to_file(self.filename,
"database_name:" + self.database_name + "\n")
append_text_to_file(
self.filename, "qry_str:" + "select col1,col2,col3 from " +
self.table_name + "\n")
append_text_to_file(self.filename, "delete_flag:True" + "\n")
result = DatabaseQueryTable.query_by_file(self.filename)
self.assertEquals(result, self.row)
os_file_delete(self.filename)
def test_query_by_file_encoded(self):
append_text_to_file(
self.filename,
"database_name:" + b64encode(self.database_name) + "\n")
append_text_to_file(
self.filename, "qry_str:" +
b64encode("select col1,col2,col3 from " + self.table_name) + "\n")
append_text_to_file(self.filename,
"delete_flag:" + b64encode("True") + "\n")
result = DatabaseQueryTable.query_by_file(self.filename)
self.assertEquals(self.row, DatabaseBase._decode_2darray(result))
os_file_delete(self.filename)
def test_get_columns(self):
os_file_delete(self.filename)
append_text_to_file(
self.filename,
"database_name:" + b64encode(self.database_name) + "\n")
append_text_to_file(self.filename,
"table_name:" + b64encode(self.table_name) + "\n")
append_text_to_file(self.filename,
"delete_flag:" + b64encode("True") + "\n")
self.assertEquals(DatabaseMisc.get_table_info_by_file(self.filename),
[(u'FirstName', u'text'), (u'LastName', u'text'),
(u'Country', u'text'), (u'Description', u'text'),
(u'Age', u'integer')])
def test_create_by_file(self):
append_text_to_file(self.filename,
"database_name:" + self.database_name + "\n")
append_text_to_file(self.filename,
"table_name:" + self.table_name + "\n")
append_text_to_file(self.filename, "delete_flag:False" + "\n")
append_text_to_file(
self.filename, "column_defns:" + "$$".join(
[_name + "^" + _type
for _name, _type in self.column_defn]) + "\n")
DatabaseCreateTable.create_by_file(self.filename)
database = Database(self.database_name, True)
with database:
self.assertTrue(tbl_exists(database, self.table_name))
os_file_delete(self.filename)
def tearDown(self):
write_text_to_file(
self.filename, "database_name:" +
encode(path.join(TESTDIR, TESTDBNAME), self.encoding) + "\n")
append_text_to_file(
self.filename,
"sp_name:" + encode("delete_student", self.encoding) + "\n")
append_text_to_file(
self.filename,
"delete_flag:" + encode("False", self.encoding) + "\n")
append_text_to_file(
self.filename, "sp_args:" + encode(
"<root><students>666</students><students>667</students></root>",
self.encoding) + "\n")
result = DataStoredProc.stored_proc_by_file(
self.filename, result_file=self.result_filename)
os_file_delete(self.filename)
def test_create_by_file_encoded(self):
self.filename = "b64pyshell.txt"
append_text_to_file(
self.filename,
"database_name:" + b64encode(self.database_name) + "\n")
append_text_to_file(self.filename,
"table_name:" + b64encode(self.table_name) + "\n")
append_text_to_file(self.filename,
"delete_flag:" + b64encode("False") + "\n")
append_text_to_file(
self.filename, "column_defns:" + "$$".join([
b64encode(_name) + "^" + b64encode(_type)
for _name, _type in self.column_defn
]) + "\n")
DatabaseCreateTable.create_by_file(self.filename)
database = Database(self.database_name, True)
with database:
self.assertTrue(tbl_exists(database, self.table_name))
os_file_delete(self.filename)
def test_insert_by_file(self):
# no encoding of input / output files
# no encoding of database content
self.filename = "unipyshell.txt"
append_text_to_file(self.filename,
"database_name:" + self.database_name + "\n")
append_text_to_file(self.filename,
"table_name:" + self.table_name + "\n")
append_text_to_file(self.filename, "delete_flag:False" + "\n")
append_text_to_file(
self.filename,
"columns:" + "$$".join([field for field in self.columns]) + "\n")
put_2darray_in_file(self.filename, self.row, suffix="rows:")
DatabaseInsertRows.insert_by_file(self.filename)
database = Database(self.database_name, True)
with database:
_, result, _ = tbl_rows_get(database, self.table_name)
self.assertEqual(result, self.row)
os_file_delete(self.filename)
def tearDown(self):
os_file_delete(self.filename)
pass
def tearDown(self):
os_file_delete(self.filename)
os_file_delete(self.runtime_path + "\\" + self.database_name +
".sqlite")
def tearDown(self):
GitRepoHelper._delete_repo(self.repo)
del self.github
chdir(self.cwd)
os_file_delete(path.join(ROOTDIR,self.filename))
def tearDown(self):
os_file_delete(self.filename)
os_file_delete(self.result_filename)
DataStoredProc.sp_args = {}
