def save_post(req, data, uid, uname):
print data
id = data.get('id', 0)
views = data.get('views', 0)
if not views:
views = 0
featured_image = data.get('featured_image', '')
if not featured_image.strip():
featured_image = '/static/zhiyuw/cy_images/images/infor.jpg'
desc = data.get('description', '')
if not desc:
result, number = re.subn(r'<.*?>|</.*?>', '', data.get('editorValue'))
desc = len(result) > 20 and result[:20] or result
if id: ##update
sql = '''update blog_blogpost set title='%s', content='%s', cate2='%s', featured_image='%s',
description='%s',created='%s', views='%s', cate3='%s'
where id=%s''' % (data.get('title'), data.get('editorValue'),
data.get('cate2'), featured_image, desc,
fun.now(), views, data.get('cate3', ''), id)
# print sql
r = unio().execute(sql)
if r:
sql = '''update blog_blogpost_categories set blogcategory_id=%s
where blogpost_id=%s''' % (data.get('cate'), id)
unio().execute(sql)
return r
else:
short_url = '/zhiyuw/%s/show-%s.html' % ('xxx', 0)
sql = '''insert into blog_blogpost (comments_count, site_id, title, slug, created, status, publish_date,
short_url, content, user_id, user_name, allow_comments, views, cate2, cate3, featured_image, description)
values (%s, '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s')''' % \
(0, fun.get_site_id(req), data.get('title', 'no title'), data.get('title','no title'), fun.now(), 1,
fun.now(), short_url, data.get('editorValue'), uid, uname, 1, views, data.get('cate2'),data.get('cate3', ''),
featured_image, desc)
# print sql
lastid = unio().executeInsert(sql)
if lastid:
sql = '''insert blog_blogpost_categories (blogcategory_id, blogpost_id) values
('%s', '%s')''' % (data.get('cate'), lastid)
print sql
r = unio().executeInsert(sql)
if r:
sql = '''update ww_member set credits=credits+10 where id=%s''' % uid
unio().execute(sql)
sql = '''select slug from blog_blogcategory where id=%s''' % data.get(
'cate')
r = unio().fetchOne(sql)
slug = r.get('slug')
short_url = '/zhiyuw/%s/show-%s.html' % (slug, lastid)
mobile_url = '/mobile/%s/show-%s.html' % (slug, lastid)
sql = '''update blog_blogpost set short_url='%s', mobile_url='%s' where id=%s''' % (
short_url, mobile_url, lastid)
return unio().execute(sql)
def save_content(data):
short_url = '/xx/xx'
sql = '''insert into blog_blogpost (featured_image, description, comments_count, site_id, title, slug, created, status, publish_date,
short_url, content, user_id, user_name, allow_comments, views, cate2, reference)
values ('%s', '%s', %s, '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s')''' % \
(data.get('featured_image', '/static/zhiyuw/cy_images/images/infor.jpg'), data.get('description'),
0, 1, data.get('title'), data.get('title'), fun.now(), 2,
fun.now(), short_url, data.get('content', '').replace("'", "\\'"), 0, 'auto', 1, 0, '', data.get('reference', ''))
# print sql
try:
lastid = unio().executeInsert(sql)
except Exception, e:
print e.message
return
def save_content(data):
short_url = '/xx/xx'
sql = '''insert into blog_blogpost (featured_image, description, comments_count, site_id, title, slug, created, status, publish_date,
short_url, content, user_id, user_name, allow_comments, views, cate2, reference)
values ('%s', '%s', %s, '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s')''' % \
(data.get('featured_image', '/static/zhiyuw/cy_images/images/infor.jpg'), data.get('description'),
0, 1, data.get('title'), data.get('title'), fun.now(), 2,
fun.now(), short_url, data.get('content', '').replace("'", "\\'"), 0, 'auto', 1, 0, '', data.get('reference', ''))
# print sql
try:
lastid = unio().executeInsert(sql)
except Exception, e:
print e, e.message
return
def save_post(req, data, uid, uname):
id = data.get('id', 0)
views = data.get('views')
if not views:
views = 0
featured_image = data.get('featured_image', '')
if not featured_image.strip():
featured_image = '/static/zhiyuw/cy_images/images/infor.jpg'
if id: ##update
sql = '''update blog_blogpost set title='%s', content='%s', cate2='%s', featured_image='%s',
description='%s',created='%s', views='%s'
where id=%s''' % (data.get('title'), data.get('editorValue'), data.get('cate2'),
featured_image, data.get('description', ''), fun.now(), views, id)
# print sql
r = unio().execute(sql)
if r:
sql = '''update blog_blogpost_categories set blogcategory_id=%s
where blogpost_id=%s''' % (data.get('cate'), id)
unio().execute(sql)
return r
else:
short_url = '/zhiyuw/%s/show-%s.html' % ('xxx',0)
sql = '''insert into blog_blogpost (comments_count, site_id, title, slug, created, status, publish_date,
short_url, content, user_id, user_name, allow_comments, views, cate2, featured_image, description)
values (%s, '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s')''' % \
(0, fun.get_site_id(req), data.get('title', 'no title'), data.get('title','no title'), fun.now(), 1,
fun.now(), short_url, data.get('editorValue'), uid, uname, 1, views, data.get('cate2'),
featured_image, data.get('description'))
# print sql
lastid = unio().executeInsert(sql)
if lastid:
sql = '''insert blog_blogpost_categories (blogcategory_id, blogpost_id) values
('%s', '%s')''' % (data.get('cate'), lastid)
# print sql
r =unio().executeInsert(sql)
if r:
sql = '''update ww_member set credits=credits+10 where id=%s''' % uid
unio().execute(sql)
sql = '''select slug from blog_blogcategory where id=%s''' % data.get('cate')
r = unio().fetchOne(sql)
slug = r.get('slug')
short_url = '/zhiyuw/%s/show-%s.html' % (slug, lastid)
mobile_url = '/mobile/%s/show-%s.html' % (slug, lastid)
sql = '''update blog_blogpost set short_url='%s', mobile_url='%s' where id=%s''' %(short_url, mobile_url, lastid)
return unio().execute(sql)
