def __init__(self, category=1):
super(LessonStudent, self).__init__(category, 'count')
self.filename = 'data/lesson_student.pkl'
self.conn = get_course_connection()
self.schedule_conn = get_schedule_connection()
self.product_conn = get_product_connection()
self.get_course_lesson()
def count_consume(self):
conn = get_schedule_connection()
sql = "select student_id, created_at from student_appointments \
where status = 3 and deleted_at is null and created_at > \
'2016-01-01'"
with conn.cursor() as cur:
cur.execute(sql)
while cur.rownumber < cur.rowcount:
student, date = cur.fetchone()
if student in self._df.index:
a = date - self._df.loc[student, 'first_large_buy_at']
if a.days < 365:
self._df.loc[student, 'count'] += 1
if cur.rownumber % 10000 == 0:
print(date)
self._df.to_csv('user_comsume.csv')
def __init__(self):
self.conn = get_schedule_connection()
self.driver = get_graphdb_deriver()
def __init__(self):
self.conn = get_schedule_connection()
self.driver = get_graphdb_deriver()
self.sql = "select id, room_type_id, room_count, course_id,lesson_id,begin_at, \
def init_relation_room(self):
self.conn = get_schedule_connection()
self.sql = "select id, student_id, room_id, status, created_at from student_appointments \
where created_at > '2018-01-01' and status in (0,1,3,4) and deleted_at is null"
self.get_cypherql = self.get_relation_room_cypherql
def __init__(self):
super(ScheduleDataFrame, self).__init__()
self.conn = get_schedule_connection()
self.product_conn = get_product_connection()