def test_insert_encoded_by_file(self): 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("True") + "\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, runtime_path=self.runtime_path) database = Database( self.runtime_path + "\\" + self.database_name + ".sqlite", True) with database: _, result, _ = tbl_rows_get(database, self.table_name) self.assertEqual(DatabaseBase._decode_2darray(result), self.row)
def test_(self): append_text_to_file( self.filename, "columns:" + "$$".join([b64encode(field) for field in self.columns]) + "\n") rows = get_2darray_from_file(path.join(TESTDIR, "testdata.csv")) put_2darray_in_file(self.filename, rows, suffix="rows:", encoding="base64") DatabaseInsertRows.insert_by_file(self.filename) database = Database(self.database_name, True) with database: columns, rows, _ = tbl_query( database, "select Description from foobar where LastName = \"" + b64encode("Osborn") + "\"") expected_results = [ b64encode( "dictum mi, ac mattis velit justo nec ante. Maecenas mi felis, adipiscing fringilla, porttitor vulputate, posuere vulputate, lacus. Cras interdum. Nunc sollicitudin commodo ipsum. Suspendisse non leo. Vivamus nibh dolor, nonummy ac, feugiat non, lobortis quis, pede. Suspendisse dui. Fusce diam nunc, ullamcorper eu, euismod ac, fermentum vel, mauris. Integer sem elit, pharetra ut, pharetra sed, hendrerit a, arcu. Sed et" ) ] self.assertListEqual(rows[0], expected_results)
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 setUp(self): super(Test_GitCommit,self).setUp() self.filename = "uupyshell.txt" self.encoding = "uu" self.user = GitBase._get_user(self.github) self.repo = GitRepoHelper._create_repo(self.user,self.reponame,auto_init=True) self.runtime_path = "C:\\Users\\burtnolej" append_text_to_file(self.filename,"token:"+encode(self.token,self.encoding) + "\n") append_text_to_file(self.filename,"reponame:"+encode(self.reponame,self.encoding) + "\n") append_text_to_file(self.filename,"gitrootpath:"+encode(self.gitrootpath,self.encoding) + "\n") append_text_to_file(self.filename,"commit_message:"+encode(self.commit_message,self.encoding) + "\n") append_text_to_file(self.filename,"commit_files:"+"$$".join([encode(_file,self.encoding) for _file in self.commit_files]) + "\n")
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_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 setUp(self): self.database_name = 'foobar' self.table_name = 'foobar' self.column_defn = [('FirstName', 'text'), ('LastName', 'text'), ('Country', 'text'), ('Description', 'text'), ('Age', 'integer')] self.columns = [ 'FirstName', 'LastName', 'Country', 'Description', 'Age' ] 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)
def test_(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("student_schedule", self.encoding) + "\n") append_text_to_file( self.filename, "delete_flag:" + encode("False", self.encoding) + "\n") append_text_to_file( self.filename, "header_flag:" + encode("True", self.encoding) + "\n") append_text_to_file( self.filename, "sp_args:" + encode( "<root><students>70</students><days>M</days><periods>1</periods></root>", self.encoding) + "\n") result = DataStoredProc.stored_proc_by_file( self.filename, result_file=self.result_filename) self.assertEqual(result, [[ 'sSubjectLongDesc', 'sCourseNm', 'sClassFocusArea', 'sFacultyFirstNm', 'cdDay', 'idTimePeriod', 'idLocation', 'idSection', 'cdClassType', 'iFreq', 'idClassLecture' ], [ u'Homeroom', u'Homeroom', None, u'Isaac', u'M', 1, 9, 165, u'Seminar', 5, 993 ]]) self.assertTrue(os_file_exists(self.result_filename)) self.assertEqual( "sSubjectLongDesc^sCourseNm^sClassFocusArea^sFacultyFirstNm^cdDay^idTimePeriod^idLocation^idSection^cdClassType^iFreq^idClassLecture$$Homeroom^Homeroom^None^Isaac^M^1^9^165^Seminar^5^993", os_file_to_string(self.result_filename))
def setUp(self): super(Test_GitMultiUpdateRefs, self).setUp() self.filename = environ["MYHOME"] + "\\testpygithub\\git_test.txt" write_text_to_file(self.filename, "this is a test") self.parents = [GitCommitHelper._get_last_commit(self.repo)] self.base_tree = self.parents[0]._tree.value self.tree = GitCommitHelper._create_input_tree( self.filename, self.repo, base_tree=self.base_tree) self.git_commit = GitCommitHelper._create_commit( self.repo, "commit via pyyhon api", self.tree, self.parents) self.headref = GitCommitHelper._get_ref(self.repo) self.headref.edit(self.git_commit.sha) append_text_to_file(self.filename, "amendment") self.parents = [GitCommitHelper._get_last_commit(self.repo)] self.base_tree = self.parents[0]._tree.value self.tree = GitCommitHelper._create_input_tree( self.filename, self.repo, base_tree=self.base_tree) self.git_commit = GitCommitHelper._create_commit( self.repo, "commit via pyyhon api", self.tree, self.parents) self.headref = GitCommitHelper._get_ref(self.repo)
def setUp(self): self.filename = "uupyshell.txt" self.result_filename = environ["MYHOME"] + "\\pyshell_result.txt" self.datasp = DataStoredProc(path.join(TESTDIR, TESTDBNAME)) self.encoding = "uu" self.columns = [ "idStudent", "sStudentFirstNm", "sStudentLastNm", "idPrep", "iGradeLevel" ] self.column_defn = [('col1', 'text'), ('col2', 'text'), ('col3', 'integer')] self.rows = [[666, 'foo', 'bar', 2, 6], [667, 'blah', 'blah', 3, 6]] self.row = ['idPrep', 3, 'idStudent', 666] 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("insert_student", self.encoding) + "\n") append_text_to_file( self.filename, "delete_flag:" + encode("False", self.encoding) + "\n") append_text_to_file( self.filename, "columns:" + "$$".join([field for field in self.columns]) + "\n") put_2darray_in_file(self.filename, self.rows, suffix="rows:") result = DataStoredProc.stored_proc_by_file( self.filename, result_file=self.result_filename) DataStoredProc.sp_args = {}
def test_(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("student_schedule", 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>70</students><days>M</days><periods>1</periods></root>", self.encoding) + "\n") result = DataStoredProc.stored_proc_by_file( self.filename, result_file=self.result_filename) self.assertEqual(result, [[ u'Homeroom', u'Homeroom', None, u'Isaac', u'M', 1, 9, 165, u'Seminar', 5, 993 ]]) self.assertTrue(os_file_exists(self.result_filename)) self.assertEqual( "Homeroom^Homeroom^None^Isaac^M^1^9^165^Seminar^5^993", os_file_to_string(self.result_filename))
def test_(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("student_schedule", 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>70</students><students>69</students><days>M</days><days>T</days><periods>1</periods><periods>2</periods></root>", self.encoding) + "\n") result = DataStoredProc.stored_proc_by_file( self.filename, result_file=self.result_filename) expected_results = [[ u'Homeroom', u'Homeroom', None, u'Samantha', u'M', 1, 10, 163, u'Seminar', 5, 983 ], [ u'Homeroom', u'Homeroom', None, u'Isaac', u'M', 1, 9, 165, u'Seminar', 5, 993 ], [ u'Movement', u'Movement', None, u'Michael', u'M', 2, 37, 432, u'Seminar', 1, 1196 ], [ u'Science', u'Science', None, u'John', u'M', 2, 4, 162, u'1on1', 1, 143 ], [ u'Homeroom', u'Homeroom', None, u'Samantha', u'T', 1, 10, 163, u'Seminar', 5, 984 ], [ u'Homeroom', u'Homeroom', None, u'Isaac', u'T', 1, 9, 165, u'Seminar', 5, 994 ], [ u'Foreign Language', u'Spanish 1', None, u'Jamie', u'T', 2, 6, 451, u'Seminar', 2, 1218 ], [ u'Work Period', u'Work Period', None, u'Alyssa', u'T', 2, 37, 564, u'Seminar', 1, 713 ]] self.assertEqual(result, expected_results) self.assertTrue(os_file_exists(self.result_filename)) self.assertEqual( os_file_to_string(self.result_filename), "Homeroom^Homeroom^None^Samantha^M^1^10^163^Seminar^5^983$$Homeroom^Homeroom^None^Isaac^M^1^9^165^Seminar^5^993$$Movement^Movement^None^Michael^M^2^37^432^Seminar^1^1196$$Science^Science^None^John^M^2^4^162^1on1^1^143$$Homeroom^Homeroom^None^Samantha^T^1^10^163^Seminar^5^984$$Homeroom^Homeroom^None^Isaac^T^1^9^165^Seminar^5^994$$Foreign Language^Spanish 1^None^Jamie^T^2^6^451^Seminar^2^1218$$Work Period^Work Period^None^Alyssa^T^2^37^564^Seminar^1^713" )
def setUp(self): super(Test_GitCreateRepo,self).setUp() self.filename = "uupyshell.txt" self.encoding = "uu" write_text_to_file(self.filename,"token:"+encode(self.token,self.encoding) + "\n") append_text_to_file(self.filename,"reponame:"+encode(self.reponame,self.encoding) + "\n") append_text_to_file(self.filename,"username:"******"\n") append_text_to_file(self.filename,"gitrootpath:"+encode(self.gitrootpath,self.encoding) + "\n")
def test_(self): # commit 1 gitcommit = GitCommitHelper.commit(self.token, self.reponame, self.filenames, self.message) # commit 2 append_text_to_file(environ["MYHOME"] + "\\testpygithub\\git_test.txt", "foo") append_text_to_file( environ["MYHOME"] + "\\testpygithub\\git_test2.txt", "bar") gitcommit = GitCommitHelper.commit(self.token, self.reponame, self.filenames, self.message) # commit 3 self.filenames = [environ["MYHOME"] + "\\testpygithub\\git_test4.txt"] gitcommit = GitCommitHelper.commit(self.token, self.reponame, self.filenames, self.message) files = GitRepoHelper._get_files(self.repo) self.assertEqual(files, [ environ["MYHOME"] + '\\testpygithub\\git_test.txt', environ["MYHOME"] + '\\testpygithub\\git_test2.txt', environ["MYHOME"] + '\\testpygithub\\git_test3.txt', environ["MYHOME"] + '\\testpygithub\\git_test4.txt', u'README.md' ]) gitrepo = GitRepoHelper.history(self.token, self.reponame) self.assertEquals(gitrepo.commit_history[0][0]['content'], 'this is a testfoo') self.assertEquals(gitrepo.commit_history[0][1]['content'], 'this is a test2bar') self.assertEquals(gitrepo.commit_history[0][2]['content'], 'this is a test2') self.assertEquals(gitrepo.commit_history[0][3]['content'], 'this is a test4')
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 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_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_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_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_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_query_encoded_by_file(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, result_file=self.result_filename) self.assertEqual( "eA==^eQ==^Ng==", os_file_to_string(self.result_filename).split("\n")[0])
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): 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_(self): append_text_to_file(self.filename, "delete_flag:" + b64encode("True") + "\n") result = DatabaseQueryTable.query_by_file( self.filename, runtime_path=self.runtime_path) self.assertEqual(DatabaseBase._decode_2darray(result), self.row)
def test_set_runtimepath(self): rows = get_2darray_from_file(path.join(TESTDIR, "testdata_2rows.csv")) 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("True") + "\n") append_text_to_file( self.filename, "columns:" + "$$".join([b64encode(field) for field in self.columns]) + "\n") append_text_to_file( self.filename, "column_defns:" + "$$".join([ b64encode(_name) + "^" + b64encode(_type) for _name, _type in self.column_defn ]) + "\n") put_2darray_in_file(self.filename, rows, suffix="rows:", encoding="base64") clsobj = DatabaseBase._parse_input_file( self.filename, mandatory_fields=[ 'database_name', 'table_name', 'delete_flag', 'decode_flag', 'columns', 'column_defns' ], encoding="base64", runtime_path="C:\Users\burtnolej") self.assertEqual(clsobj.runtime_path, "C:\Users\burtnolej") self.assertEqual(clsobj.database_name, self.database_name)
def test_(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("update_student", self.encoding) + "\n") append_text_to_file( self.filename, "delete_flag:" + encode("False", self.encoding) + "\n") append_text_to_file( self.filename, "row:" + "$$".join([str(field) for field in self.row]) + "\n") result = DataStoredProc.stored_proc_by_file( self.filename, result_file=self.result_filename) DataStoredProc.sp_args = {} 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("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></root>", self.encoding) + "\n") result = DataStoredProc.stored_proc_by_file( self.filename, result_file=self.result_filename) self.assertEqual(result, [[u'foo', u'bar', 666, 3, u'Aurora']])
def test_(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("insert_student", self.encoding) + "\n") append_text_to_file( self.filename, "delete_flag:" + encode("False", self.encoding) + "\n") append_text_to_file( self.filename, "header_flag:" + encode("False", self.encoding) + "\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:") result = DataStoredProc.stored_proc_by_file( self.filename, result_file=self.result_filename) DataStoredProc.sp_args = {} 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("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>667</students></root>", self.encoding) + "\n") result = DataStoredProc.stored_proc_by_file( self.filename, result_file=self.result_filename) self.assertEqual(result, [[u'blah', u'blah', 667, 3, u'Aurora']])
def setUp(self): self.database_name = 'foobar' self.table_name = 'foobar' self.columns = ['col1', 'col2', 'col3'] self.column_defn = [('col1', 'text'), ('col2', 'text'), ('col3', 'integer')] self.row = [['x', 'y', 6]] self.qrow = _quotestrs(self.row) self.filename = "b64pyshell.txt" self.b64row = DatabaseBase._encode_2darray(self.row) self.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, "columns:" + "$$".join([b64encode(field) for field in self.columns]) + "\n") append_text_to_file( self.filename, "column_defns:" + "$$".join([ b64encode(_name) + "^" + b64encode(_type) for _name, _type in self.column_defn ]) + "\n") append_text_to_file( self.filename, "qry_str:" + b64encode("select col1,col2,col3 from " + self.table_name) + "\n") put_2darray_in_file(self.filename, self.b64row, suffix="rows:") DatabaseCreateTable.create_by_file(self.filename, runtime_path=self.runtime_path) DatabaseInsertRows.insert_by_file(self.filename, runtime_path=self.runtime_path)