def insert_topic_img(session):
service = TopicServices(session)
users = [
{'topic_id':1,'user_id':5,'url':'http://img.gongzhuhao.com/album/users/8/exquisite/1047457x379158000d493a9d737bd34385ab3e26.jp@80q_0r.jpg'},
{'topic_id':1,'user_id':5,'url':'http://img.gongzhuhao.com/album/users/8/exquisite/1047457x379158000d493a9d737bd34385ab3e26.jp@80q_0r.jpg'},
{'topic_id':1,'user_id':5,'url':'http://img.gongzhuhao.com/album/users/8/exquisite/1047457x379158000d493a9d737bd34385ab3e26.jp@80q_0r.jpg'},
{'topic_id':2,'user_id':6,'url':'http://img.gongzhuhao.com/album/users/8/exquisite/1047457x379158000d493a9d737bd34385ab3e26.jp@80q_0r.jpg'},
{'topic_id':2,'user_id':6,'url':'http://img.gongzhuhao.com/album/users/8/exquisite/1047457x379158000d493a9d737bd34385ab3e26.jp@80q_0r.jpg'},
{'topic_id':2,'user_id':6,'url':'http://img.gongzhuhao.com/album/users/8/exquisite/1047457x379158000d493a9d737bd34385ab3e26.jp@80q_0r.jpg'},
{'topic_id':1,'user_id':5,'url':'http://img.gongzhuhao.com/album/users/8/exquisite/1047457x379158000d493a9d737bd34385ab3e26.jp@80q_0r.jpg'},
]
for u in users:
service.create_topic_img_2(**u)
def get_user_sns_msg(self, id):
'''
根据用户id获取用户基础信息
:param id : 用户id
:return dict keys: id ,nick ,photo
'''
mcache_key = 'topic_user_' + str(id)
user_sns_topic = mcache.get(mcache_key)
if not user_sns_topic:
topic_db = TopicServices(self.db)
user_sns = topic_db.query_user_sns_topic(user_id=id)
user_sns_topic = {}
for s in user_sns:
key = '%s_%s_%s' % (s.Ftopic_id, s.Fsns_type, s.Ftopic_type)
user_sns_topic[key] = 1
user_sns_topic = ujson.dumps(user_sns_topic)
mcache.set(mcache_key, user_sns_topic, 7200)
return ujson.loads(user_sns_topic)
def insert_topic(session):
service = TopicServices(session)
sns = [
{
'user_id': 5,
'topic_id': 4,
'sns_type': 1,
'topic_type': 2
},
{
'user_id': 5,
'topic_id': 6,
'sns_type': 1,
'topic_type': 2
},
]
for u in sns:
service.create_topic_sns(u.get('topic_id'), u.get('user_id'),
u.get('sns_type'), u.get('topic_type'))
def insert_topic(session):
service = TopicServices(session)
users = [
# {'user_id':8,'topic_id':1,'reply_index':6,'parent_id':1,'content':'两情相悦的最高境界'},
# {'user_id':9,'topic_id':1,'reply_index':7,'parent_id':1,'content':'金屋笙歌偕彩凤洞房花'},
# {'user_id':10,'topic_id':1,'reply_index':8,'parent_id':2,'content':'祝你俩幸福美满'},
# {'user_id':4,'topic_id':1,'reply_index':9,'parent_id':3,'content':'携手共渡美丽人生'},
# {'user_id':9,'topic_id':1,'reply_index':10,'parent_id':4,'content':'恭喜你们步入爱的殿堂'},
# {'user_id':9,'topic_id':1,'reply_index':11,'parent_id':6,'content':'彩凤洞房花烛喜乘龙 '},
# {'user_id':2,'topic_id':1,'reply_index':12,'parent_id':7,'content':'同德同心幸福长'},
# {'user_id':5,'topic_id':1,'reply_index':13,'parent_id':8,'content':'祝福一对新人真心相爱'},
# {'user_id':1,'topic_id':1,'reply_index':14,'parent_id':9,'content':'敬祝百年好合永'},
{
'user_id': 11,
'topic_id': 1,
'parent_id': 9,
'content': '同德同心幸福长'
},
]
for u in users:
service.create_topic_reply(**u)
#encoding:utf-8
__author__ = 'binpo'
from common.base import BaseApiHandler
from common.cache_base import WebCacheHandler
from services.series.series_services import SeriesServices
from services.home.home_service import HomeService
from services.company.company_services import CompanyServices
from services.work.work_services import WorkServices
from services.topics.topic_services import TopicServices
import time
import sys
series_service = SeriesServices()
company_service = CompanyServices()
work_service = WorkServices()
topic_service = TopicServices()
home_service = HomeService()
class UserIndexHandler(BaseApiHandler):
#@login_control()
def get(self, *args, **kwargs):
self.echo('views/account/index.html')
class TopicIndexHandler(BaseApiHandler):
def get(self, *args, **kwargs):
self.redirect('/topic')
#encoding:utf-8
__author__ = 'wangjinkuan'
from common.base import AdminBaseHandler
from services.topics.topic_services import TopicServices
from utils.upload_utile import upload_to_oss, delete_from_oss
from tornado.options import options
# from apps_crm.albums.photos_handler import img_compression
import tornado.web
import ujson
import datetime
topics_service = TopicServices()
class TagsCreateHandler(AdminBaseHandler):
@tornado.web.authenticated
def get(self):
self.echo('ops/topic/create_tag.html')
@tornado.web.authenticated
def post(self):
self.get_paras_dict()
topics_service.set_db(self.db)
try:
topics_service.create_topic_tag(**self.qdict)
except Exception, e:
return self.write(
ujson.dumps({
'stat': '1001',
'info': 'exception occured:' + e.message
def insert_topic(session):
service = TopicServices(session)
users = [
{
'user_id': 6,
'category_id': 1,
'title': '因为在今天，我的内心也跟你一样的欢腾',
'content': '快乐！祝你们，百年好合'
},
{
'user_id': 7,
'category_id': 1,
'title': '让流云奉上真挚的情意',
'content': '空气里都充满了醉人的甜蜜'
},
{
'user_id': 8,
'category_id': 1,
'title': '空气里都充满了醉人的甜蜜',
'content': '白首齐眉鸳鸯比翼'
},
{
'user_id': 9,
'category_id': 1,
'title': '花烛笑迎比翼鸟，洞房',
'content': '正所谓天生一对'
},
{
'user_id': 1,
'category_id': 1,
'title': '青阳启瑞桃李同心',
'content': '人们常说的神仙眷侣就是你们了'
},
{
'user_id': 2,
'category_id': 1,
'title': '白首齐眉鸳鸯比翼',
'content': '青阳启瑞桃李同心'
},
{
'user_id': 3,
'category_id': 1,
'title': '红梅吐芳喜成连理',
'content': '绿柳含笑永结同心'
},
{
'user_id': 4,
'category_id': 1,
'title': '对联是中国的传统文化的精华',
'content': '许订终身贺新婚'
},
{
'user_id': 5,
'category_id': 1,
'title': '前生注定，喜结良缘',
'content': '许订终身贺新婚'
},
{
'user_id': 1,
'category_id': 1,
'title': '新婚大喜！百年好合！',
'content': '新郎新娘的祝福语'
},
]
for u in users:
service.create_topic(**u)