cfg = Common.loadConfig()
#print cfg['db']
db = DbManager()
db.initConn(cfg['db'])
sql = "show databases like 'cms_site_%'"
n,data = db.executeQuery(0,sql)
for row in data:
pid = row[0].replace('cms_site_','')
#创建statistics表
sql = "CREATE TABLE IF NOT EXISTS `cms_template_statistics` (`template_id` int(11) NOT NULL COMMENT '模板id',`document_count` int(11) NOT NULL COMMENT '文档数',UNIQUE KEY `template_id` (`template_id`),KEY `document_count` (`document_count`)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;"
n,createdata = db.execute(pid,sql)
print sql
print '@@@@@@@@'
sql = "show tables like 'cms_tbl_%'"
n ,tbldata = db.executeQuery(pid,sql)
for tbl in tbldata:
tid = tbl[0].replace('cms_tbl_','')
sql = 'select count(document_id) as doc_count from '+tbl[0]
n,statdata = db.executeQuery(pid,sql)
for stat in statdata:
print 'TID:',tid,' Count:',stat[0]
sql = "INSERT INTO `cms_template_statistics` (template_id,document_count) VALUES("+str(tid)+", "+str(stat[0])+") ON DUPLICATE KEY UPDATE `document_count`=`document_count`+1"
n,insertdata = db.execute(pid,sql)
print sql
print '======',pid,'======'
#print data
#db_cfg = Common.collection_find(cfg['db'],lambda s:s['pid']==int(pid))
db.closeConn()
cms_assert(n < 1, 500, 'build template view error!' + sql)
pass
make_page_code = 201 if preview == 'N' else 200
# 更新邮箱
task_mail.append({
'code': make_page_code,
'errmsg': u'生成模板页面成功!',
'progress': 100,
'pid': str(pid),
'url': publish_url
})
redis.setex(task_id, timeout, json.dumps(task_mail, ensure_ascii=False))
logging.info('[Compiler]: document update ok')
# 数据库关闭
db.closeConn([pid])
if preview == 'N':
# rsync到目标站点
logging.info('sh ./shell/test.domain.sh ' + domain + ' ' + str(pid) + ' ' +
publish_url[1:])
child = subprocess.Popen([
'sh ./shell/test.domain.sh ' + domain + ' ' + str(pid) + ' ' +
publish_url[1:]
],
shell=True)
child.wait()
task_mail.append({
'code': 200,
'errmsg': u'发布到目标站点完成!',
'progress': 100,
