def update_member_count(self):
sql = '''update {} set member_count=(
select count(*) from `mini_belong` where group_id=%s)
where id = %s
'''.format(self.__table__)
params = (self.id, self.id)
store.execute(sql, params)
store.commit()
def update_member_count(self):
sql = '''update {} set member_count=(
select count(*) from `mini_belong` where group_id=%s)
where id = %s
'''.format(self.__table__)
params = (self.id, self.id)
store.execute(sql, params)
store.commit()
def create(cls, name, intro, creator):
sql = 'insert into {} (name,intro,creator_id) values(%s, %s, %s)'.format(cls.__table__)
params = (name, intro, creator)
id = store.execute(sql,params)
store.commit()
# add default belong
if not id:
return None
sql = 'insert into `mini_belong` (user_id, group_id) values (%s, %s)'
params = (creator, id)
store.execute(sql, params)
store.commit()
return id
def create(cls, name, intro, creator):
sql = 'insert into {} (name,intro,creator_id) values(%s, %s, %s)'.format(
cls.__table__)
params = (name, intro, creator)
id = store.execute(sql, params)
store.commit()
# add default belong
if not id:
return None
sql = 'insert into `mini_belong` (user_id, group_id) values (%s, %s)'
params = (creator, id)
store.execute(sql, params)
store.commit()
return id
def get_user_groups(cls, user_id):
sql = '''select A.id, A.name, A.intro, A.member_count, A.create_time, A.creator_id
from {} A where exists(
select * from `mini_belong` B
where B.user_id=%s and A.id=B.group_id)
'''.format(cls.__table__)
rs = store.execute(sql, user_id)
return [cls(*r) for r in rs] if rs else None
def get_user_groups(cls, user_id):
sql = '''select A.id, A.name, A.intro, A.member_count, A.create_time, A.creator_id
from {} A where exists(
select * from `mini_belong` B
where B.user_id=%s and A.id=B.group_id)
'''.format(cls.__table__)
rs = store.execute(sql, user_id)
return [cls(*r) for r in rs] if rs else None
def create(cls, blog_id, content, creator_id):
sql = 'insert into {} (blog_id,content,creator_id) values(%s, %s, %s)'.format(cls.__table__)
params = (blog_id, content, creator_id)
id = store.execute(sql,params)
store.commit()
if id:
blog = Blog.get(blog_id)
blog.add_comment_count(1)
return id
def create(cls, blog_id, content, creator_id):
sql = 'insert into {} (blog_id,content,creator_id) values(%s, %s, %s)'.format(
cls.__table__)
params = (blog_id, content, creator_id)
id = store.execute(sql, params)
store.commit()
if id:
blog = Blog.get(blog_id)
blog.add_comment_count(1)
return id
def get_focus_blogs(cls, user_id, limit_count):
sql ='''
SELECT B.id, B.title, B.content, B.comment_count, B.create_time, B.creator_id, B.group_id
FROM `mini_blog` B
WHERE EXISTS (
SELECT *
FROM `mini_belong` C
WHERE C.user_id =%s
AND C.group_id = B.group_id
)
ORDER BY B.create_time DESC
LIMIT %s
'''
params = (user_id, limit_count)
rs = store.execute(sql, params)
return [cls(*r) for r in rs] if rs else None
def get_hot_groups(cls):
sql = 'select {} from {} order by member_count desc limit 20'.format(
cls.__all__, cls.__table__)
rs = store.execute(sql)
return [cls(*r) for r in rs] if rs else None
def delete_member(self, user_id):
sql = 'delete from `mini_belong` where user_id=%s and group_id=%s'
params = (user_id, self.id)
store.execute(sql, params)
store.commit()
def get_all_by_group(cls, group_id):
sql = 'select {all} from {table} where group_id=%s\
order by create_time desc limit 50'.format(
all = cls.__all__, table = cls.__table__)
rs = store.execute(sql, group_id)
return [cls(*r) for r in rs] if rs else None
def create(cls, title, content, creator_id, group_id):
sql = 'insert into {} (title,content,creator_id,group_id) values(%s, %s, %s, %s)'.format(cls.__table__)
params = (title, content, creator_id, group_id)
id = store.execute(sql,params)
store.commit()
return id
def get(cls, id):
sql = 'select {all} from {table} where id=%s'.format(
all = cls.__all__, table = cls.__table__)
rs = store.execute(sql, id)
return cls(*rs[0]) if rs and rs[0] else None
def get_comments(cls, blog_id):
sql = 'select {} from {} where blog_id=%s'.format(cls.__all__, cls.__table__)
rs = store.execute(sql, blog_id)
return [cls(*r) for r in rs] if rs else None
def delete(self):
sql = 'delete from {} where id=%s'.format(self.__table__)
store.execute(sql, self.id)
store.commit()
blog = Blog.get(self.blog_id)
blog.add_comment_count(-1)
def get_comments(cls, blog_id):
sql = 'select {} from {} where blog_id=%s'.format(
cls.__all__, cls.__table__)
rs = store.execute(sql, blog_id)
return [cls(*r) for r in rs] if rs else None
def delete(self):
sql = 'delete from {} where id=%s'.format(self.__table__)
store.execute(sql, self.id)
store.commit()
blog = Blog.get(self.blog_id)
blog.add_comment_count(-1)
def get_hot_groups(cls):
sql = 'select {} from {} order by member_count desc limit 20'.format(cls.__all__, cls.__table__)
rs = store.execute(sql)
return [cls(*r) for r in rs] if rs else None
def get_is_join(self, user_id):
sql = 'select * from `mini_belong` where user_id=%s and group_id=%s'
params = (user_id, self.group_id)
rs = store.execute(sql, params)
return True if rs and rs[0] else False
def add_comment_count(self, val):
sql = 'update {} set comment_count=%s where id=%s'.format(self.__table__)
params = (int(self.comment_count) + val, self.id)
id = store.execute(sql,params)
store.commit()
def get_members(self):
sql = 'select user_id from `mini_belong` where group_id=%s'
rs = store.execute(sql, self.id)
return [doubanusers.User(r[0]) for r in rs] if rs else None
def get_all(cls):
sql = 'select {all} from {table}'.format(
all = cls.__all__, table = cls.__table__)
rs = store.execute(sql)
return [cls(*r) for r in rs] if rs else None
def get_hot_blogs(cls, limit):
sql = 'select {all} from {table} order by comment_count desc limit %s'.format(
all = cls.__all__, table = cls.__table__)
rs = store.execute(sql, limit)
return [cls(*r) for r in rs] if rs else None
def delete(self):
sql = 'delete from {} where id=%s'.format(self.__table__)
store.execute(sql, self.id)
store.commit()
def add_member(self, user_id):
sql = 'insert into `mini_belong` (user_id, group_id) values (%s, %s)'
params = (user_id, self.id)
store.execute(sql, params)
store.commit()
def get_members(self):
sql = 'select user_id from `mini_belong` where group_id=%s'
rs = store.execute(sql, self.id)
return [doubanusers.User(r[0]) for r in rs] if rs else None
def delete_member(self, user_id):
sql = 'delete from `mini_belong` where user_id=%s and group_id=%s'
params = (user_id, self.id)
store.execute(sql, params)
store.commit()
def get_user_post(cls, user_id):
sql = 'select {all} from {table} where creator_id=%s order by create_time desc'.format(
all = cls.__all__, table = cls.__table__)
rs = store.execute(sql, user_id)
return [cls(*r) for r in rs] if rs else None
def add_member(self, user_id):
sql = 'insert into `mini_belong` (user_id, group_id) values (%s, %s)'
params = (user_id, self.id)
store.execute(sql, params)
store.commit()
