def get_all_prep(database): assert isinstance(database, Database), database sql = _qry_prep() with database: columns, results, _ = tbl_query(database, sql) return columns, results
def get_studentlevel(database, studentlevels, allstudentlevels=False): assert isinstance(database, Database), database sql = _qry_studentlevel(studentlevels, allstudentlevels) with database: columns, results, _ = tbl_query(database, sql) return columns, results
def get_all_timeperiod_v2(database): assert isinstance(database, Database), database sql = _qry_timeperiod_v2() with database: columns, results, _ = tbl_query(database, sql) return columns, results
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 get_sections_to_explode(database): sql = ('select idSection,idCourse,idSubject,idClassType, ' 'idLeadTeacher,lStudentEnroll,lFacultyEnroll, ' 'iFreq,iMaxCapacity ' 'from Section where idAcadPeriod = 2') with database: columns, results, _ = tbl_query(database, sql) return columns, results
def get_section_v2(database, sections=[700], allsections=False): assert isinstance(sections, ListType), sections assert is_valid_section(sections), sections assert isinstance(database, Database), database sql = _qry_section_v2(sections, allsections) with database: columns, results, _ = tbl_query(database, sql) return columns, results
def get_subject(database, subjects=[1], allsubjects=False): assert isinstance(subjects, ListType), subjects assert is_valid_course(subjects), subjects assert isinstance(database, Database), subjects sql = _qry_subject(subjects, allsubjects) with database: columns, results, _ = tbl_query(database, sql) return columns, results
def get_location(database, locations=[1], alllocations=False): assert isinstance(locations, ListType), locations assert is_valid_course(locations), locations assert isinstance(database, Database), database sql = _qry_location(locations, alllocations) with database: columns, results, _ = tbl_query(database, sql) return columns, results
def get_classtypecode(database, courses=[1], allclasstypecode=False): assert isinstance(courses, ListType), courses assert is_valid_course(courses), courses assert isinstance(database, Database), database sql = _qry_classtypecode(courses, allclasstypecode) with database: columns, results, _ = tbl_query(database, sql) return columns, results
def get_teacher_v2(database, teachers=[30], allteachers=False): assert isinstance(teachers, ListType), teachers assert is_valid_teacher(teachers), teachers assert isinstance(database, Database), database sql = _qry_teacher_v2(teachers, allteachers) with database: columns, results, _ = tbl_query(database, sql) return columns, results
def get_student_v2(database, students=[70], allstudents=False): assert isinstance(students, ListType), students assert is_valid_student(students), students assert isinstance(database, Database), database sql = _qry_student_v2(students, allstudents) with database: columns, results, _ = tbl_query(database, sql) return columns, results
def _query_table(self, query_str, encoding="unicode", **kwargs): with self.database: _, tbl_rows, _ = tbl_query(self.database, query_str) _result_file = self._get_parse_result_file(**kwargs) if _result_file != -1: self._create_output_file(_result_file, tbl_rows) return (tbl_rows)
def get_students_per_class_by_teacher(database, teacher_id=3, class_ids='22,320'): assert isinstance(teacher_id, IntType), teacher_id assert is_valid_teacher(teacher_id), teacher_id assert isinstance(database, Database), database sql = _qry_students_per_class_by_teacher(teacher_id, class_ids) with database: columns, results, _ = tbl_query(database, sql) return columns, results
def get_student_schedule_v2(database, students=[70], days=['"M"', '"T"', '"W"', '"R"', '"F"'], periods=[1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11]): assert isinstance(students, ListType), students assert is_valid_student(students), students assert isinstance(database, Database), database sql = _qry_student_schedule_v2(students, days, periods) with database: columns, results, _ = tbl_query(database, sql) return columns, results
def get_teacher_schedule(database, teachers=[3], days=['"M"', '"T"', '"W"', '"R"', '"F"'], periods=[1, 2, 3, 4, 5, 6, 7, 8, 9, 11]): assert isinstance(teachers, ListType), teachers assert is_valid_teacher(teachers), teachers assert isinstance(database, Database), database sql = _qry_teacher_schedule(teachers, days, periods) with database: columns, results, _ = tbl_query(database, sql) return columns, results
def get_schedule_school(database, students=[70]): assert isinstance(students, ListType), students assert is_valid_student(students), students assert isinstance(database, Database), database allschedulelessons = False if students == [0]: alllessons = True sql = _qry_schedule_school(students, alllessons) with database: columns, results, _ = tbl_query(database, sql) return columns, results
def get_schedule_lesson_v2(database, students=[70], days=[1, 2, 3, 4, 5], periods=[1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11]): assert isinstance(students, ListType), students assert is_valid_student(students), students assert isinstance(database, Database), database allschedulelessons = False if students == [0]: allschedulelessons = True sql = _qry_schedule_lesson_v2(students, days, periods, allschedulelessons) with database: columns, results, _ = tbl_query(database, sql) return columns, results
def get_max_section_schedule(database): sql = ('select max(idSectionSched) ' 'from SectionSchedule ') with database: columns, results, _ = tbl_query(database, sql) return results[0][0]