def fetch_all_lessons(self, page): sql = '''select d.id, subject_name, username, from_unixtime(createtime) as createtime, date(from_unixtime(start_time)) as start_time, date(from_unixtime(end_time)) as end_time, d.actived from md_diy_subject d left join md_member m on d.member_id = m.id order by createtime desc''' sql = Pagination.add_limit_clause(sql, page) return self.db.query(sql)
def query_salons(self, salon_name, province_id, city_id, domain_id, page): '''查询沙龙''' sql = ''' select * from md_salon ''' sql, params = self.gen_query_str(sql, salon_name, province_id, city_id, domain_id) sql = Pagination.add_limit_clause(sql, page) return self.db.query(sql, *params)
def query_users(self, **args): sql = ''' select m.id, m.username, m.email, m.member_type, m.regtime, m.recommend, m.province_id, m.city_id, m.recommend_talent, m.actived, s.works_count, s.lastlogintime, s.twitter_num, s.emotion_num, from_unixtime(m.regtime) as regtime_str, from_unixtime(s.lastlogintime) as lastlogintime_str from md_member m left outer join md_member_statistics s on m.id = s.member_id ''' query_str, params = self.query_users_where_clause(**args) sql = sql + query_str sql = sql + " order by m.id desc " sql = Pagination.add_limit_clause(sql, args["page"]) return self.db.query(sql, *params)
def query_twitters(self, **args): sql = ''' select m.id, m.share_type, m.createtime, from_unixtime(m.createtime) as createtime_str, m.actived, s.description, s.comment_num, p.id as pic_id, p.pic_url, p.img_path, p.img_type, u.id as uid, u.username, u.member_type from md_twitter m, md_twitter_show s, md_twitter_picture p, md_member u where m.id = s.tid and s.pic_id = p.id and m.member_id = u.id ''' sql, params = self.gen_query_str(sql, **args) sql = sql + " order by m.createtime desc" page = args.get("page", [1])[0] sql = Pagination.add_limit_clause(sql, page) return self.db.query(sql, *params)
def fetch_all_seasons(self, page): sql = '''select *, date(from_unixtime(createtime)) as createtime_str from md_season_period order by createtime desc''' sql = Pagination.add_limit_clause(sql, page) return self.db.query(sql)