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]
