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 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 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><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 setUp(self): super(Test_GitHistory,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) 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,"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") GitCommitHelper.commit(self.token,self.reponame,self.commit_files,self.commit_message)
def setUp(self): super(Test_GitCommit2Levels,self).setUp() self.commit_files = self.commit_files + ["C:\\Users\\burtnolej\\testpygithub\\test\\git_test5.txt", "C:\\Users\\burtnolej\\testpygithub\\test\\git_test6.txt"] 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) 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,"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 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): 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 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 _encode_2darray(array, encoding="base64"): result = [] for _row in array: result.append([encode(str(_field), encoding) for _field in _row]) return result