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 = {}