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)