Example #1
0
    def get(self, *args, **kwargs):
        current_page = get_cleaned_query_data(self, [
            'page',
        ], blank=True)['page']
        current_page = get_page_number(current_page)
        posts, page_number_limit = BlogPost.list_recently(
            page_number=current_page)
        for post in posts:
            post.labels = BlogPostLabel.get_post_label(post)
        pages = get_page_nav(current_page, page_number_limit,
                             config.default_page_limit)

        # 使用到联合、分组等查询, 得到每个分类下文章个数, 得到每个标签下文章个数
        # select category_id, blogpostcategory.name, count(blogpost.id) from blogpost inner join blogpostcategory on blogpost.category_id=blogpostcategory.id group by category_id;
        categorys = BlogPost.select(BlogPostCategory.name, fn.COUNT(BlogPost.id).alias('count'))\
            .join(BlogPostCategory, on=(BlogPostCategory.id == BlogPost.category))\
            .group_by(BlogPost.category)
        for category in categorys:
            category.name = category.category.name

        labels = BlogPostLabel.select(
            BlogPostLabel.name,
            fn.COUNT(BlogPostLabel.post).alias('count')).where(
                BlogPostLabel.is_del == False).group_by(BlogPostLabel.name)

        self.render('blog/index.html',
                    posts=posts,
                    labels=labels,
                    categorys=categorys,
                    pages=pages,
                    pages_prefix_url='/blog?page=')
Example #2
0
    def get(self, category_name, *args, **kwargs):
        try:
            category = BlogPostCategory.get(BlogPostCategory.name == category_name)
        except BlogPostCategory.DoesNotExist:
            self.redirect("/static/404.html")
            return
        current_page = get_cleaned_query_data(self, ['page',], blank=True)['page']
        current_page = get_page_number(current_page)
        posts, page_number_limit = BlogPost.list_by_category(category, page_number=current_page)
        for post in posts:
            post.labels = BlogPostLabel.get_post_label(post)
        pages = get_page_nav(current_page, page_number_limit, config.default_page_limit)

        # 使用到联合、分组等查询, 得到每个分类下文章个数, 得到每个标签下文章个数
        # select category_id, blogpostcategory.name, count(blogpost.id) from blogpost inner join blogpostcategory on blogpost.category_id=blogpostcategory.id group by category_id;
        categorys = BlogPost.select(BlogPostCategory.name, fn.COUNT(BlogPost.id).alias('count'))\
            .join(BlogPostCategory, on=(BlogPostCategory.id == BlogPost.category))\
            .group_by(BlogPost.category)
        for category in categorys:
            category.name = category.category.name

        labels = BlogPostLabel.select(BlogPostLabel.name, fn.COUNT(BlogPostLabel.post).alias('count')).where(BlogPostLabel.is_del == False).group_by(BlogPostLabel.name)

        self.render('blog/index.html',
                    posts=posts,
                    labels=labels,
                    categorys=categorys,
                    pages=pages,
                    pages_prefix_url='/blog/category/'+category_name+'?page=')
Example #3
0
def convert_md_2_post(md_info):
    category = md_info.get('category')
    if not category:
        category = '未分类'
    cate = BlogPostCategory.get_by_name(category)
    post = BlogPost.create(title=md_info['title'],
                           category=cate,
                           content=md_info['content'])

    BlogPostLabel.add_post_label(md_info['tags'], post)
Example #4
0
 def post(self, *args, **kwargs):
     json_data = get_cleaned_json_data(self, ['opt', 'data'])
     data = json_data['data']
     opt = json_data['opt']
     # 获取文章详情
     if opt == 'get-post':
         try:
             post = BlogPost.get(BlogPost.id == int(data['post']),
                                 BlogPost.is_del == False)
         except:
             self.write(json_result(1, '不存在该post'))
             return
         else:
             self.write(
                 json_result(
                     0, {
                         'title': post.title,
                         'content': post.content,
                         'labels': BlogPostLabel.get_post_label(post),
                         'category': post.category.name
                     }))
             return
     # 更新文章
     elif opt == 'update-post':
         try:
             post = BlogPost.get(BlogPost.id == int(data['post']),
                                 BlogPost.is_del == False)
         except:
             self.write(json_result(1, '不存在该post'))
             return
         else:
             cate = BlogPostCategory.get_by_name(data['category'])
             post.category = cate
             post.title = data['title']
             post.content = data['content']
             post.save()
             BlogPostLabel.update_post_label(data['labels'], post)
             self.write(json_result(0, 'success'))
             return
     # 创建文章
     elif opt == 'create-post':
         cate = BlogPostCategory.get_by_name(data['category'])
         post = BlogPost.create(title=data['title'],
                                category=cate,
                                content=data['content'])
         BlogPostLabel.add_post_label(data['labels'], post)
         self.write(json_result(0, 'success'))
         return
     else:
         self.write(json_result(1, 'opt不支持'))
Example #5
0
 def get(self, *args, **kwargs):
     posts = BlogPost.select()
     for post in posts:
         post.labels = BlogPostLabel.get_post_label(post)
         post.category_name = post.category.name
     self.render('blog/post-opt.html',
                 posts=posts)
Example #6
0
 def post(self, *args, **kwargs):
     json_data = get_cleaned_json_data(self, ['opt', 'data'])
     data = json_data['data']
     opt = json_data['opt']
     # 获取文章详情
     if opt == 'get-post':
         try:
             post = BlogPost.get(BlogPost.id == int(data['post']), BlogPost.is_del == False)
         except:
             self.write(json_result(1, '不存在该post'))
             return
         else:
             self.write(json_result(0, {'title': post.title,
                            'content': post.content,
                            'labels': BlogPostLabel.get_post_label(post),
                            'category': post.category.name}))
             return
     # 更新文章
     elif opt == 'update-post':
         try:
             post = BlogPost.get(BlogPost.id == int(data['post']), BlogPost.is_del == False)
         except:
             self.write(json_result(1, '不存在该post'))
             return
         else:
             cate = BlogPostCategory.get_by_name(data['category'])
             post.category = cate
             post.title = data['title']
             post.content = data['content']
             post.save()
             BlogPostLabel.update_post_label(data['labels'], post)
             self.write(json_result(0, 'success'))
             return
     # 创建文章
     elif opt == 'create-post':
         cate = BlogPostCategory.get_by_name(data['category'])
         post = BlogPost.create(title=data['title'],
                                category=cate,
                                content=data['content'])
         BlogPostLabel.add_post_label(data['labels'], post)
         self.write(json_result(0, 'success'))
         return
     else:
         self.write(json_result(1, 'opt不支持'))
Example #7
0
 def get(self, post_id, *args, **kwargs):
     post = BlogPost.get(BlogPost.id == post_id)
     # post.content_html = markdowner.convert(post.content)
     post.content_html = markdown.markdown(
         post.content, extensions=[
             'markdown.extensions.fenced_code',
         ])
     post.category_name = post.category.name
     post.labels = BlogPostLabel.get_post_label(post)
     self.render('blog/post-detail.html', post=post)
Example #8
0
 def get(self, slug, *args, **kwargs):
     post = BlogPost.get_by_slug(slug)
     if not post:
         self.redirect404()
         return
     # post.content_html = markdowner.convert(post.content)
     post.content_html = markdown.markdown(post.content, extensions=['markdown.extensions.fenced_code', ])
     post.category_name = post.category.name
     post.labels  = BlogPostLabel.get_post_label(post)
     self.render('blog/post-detail.html',
                 post=post)
Example #9
0
 def get(self, slug, *args, **kwargs):
     post = BlogPost.get_by_slug(slug)
     if not post:
         self.redirect404()
         return
     # post.content_html = markdowner.convert(post.content)
     post.content_html = markdown.markdown(
         post.content, extensions=[
             'markdown.extensions.fenced_code',
         ])
     post.category_name = post.category.name
     post.labels = BlogPostLabel.get_post_label(post)
     self.render('blog/post-detail.html', post=post)
Example #10
0
 def get(self, *args, **kwargs):
     posts = BlogPost.select()
     for post in posts:
         post.labels = BlogPostLabel.get_post_label(post)
         post.category_name = post.category.name
     self.render('blog/post-opt.html', posts=posts)
Example #11
0
def create_test_data(db_mysql):
    from db.mysql_model.user import User, Profile, Follower
    from db.mysql_model.post import Post, PostReply, PostCategory, PostTopic, CollectPost
    from db.mysql_model.common import Notification
    from db.mysql_model.blog import BlogPost, BlogPostLabel, BlogPostCategory
    logger.debug("DataBase is not exist, so create test data.")

    # -------------------- 建表 ---------------
    db_mysql.create_tables([User, PostCategory, PostTopic, Post, PostReply, CollectPost, Profile, Follower, Notification, BlogPostCategory, BlogPost, BlogPostLabel], safe=True)

    logger.debug('add user: [admin:admin], [test:test]')
    user_admin = User.new(username='******', email='*****@*****.**', password='******')
    user_test = User.new(username='******', email='*****@*****.**', password='******')

    # -------------------- 测试关注功能 ---------------
    logger.debug('add follower: [test]->[admin]')
    Follower.create(user=user_admin, follower=user_test)

    # -------------------- 测试分类功能 --------------
    logger.debug('add postcategory and posttopic:')
    logger.debug('''
    版块分类
    专业:
        计算机
    学习:
        学习资料、考研资料、家教、竞赛

    生活:
        共享账号、电影资源、常用软件、电脑故障

    爱好:
        摄影、健身

    未分类:
        校园通知、讨论
    ''')

    postcategory0 = PostCategory.create(name='学习', str='study')
    postcategory1 = PostCategory.create(name='专业', str='major')
    postcategory2 = PostCategory.create(name='生活', str='live')
    postcategory3 = PostCategory.create(name='爱好', str='hobby')

    posttopic0 = PostTopic.create(category=postcategory0, name='学习资料', str='study-material')
    posttopic1 = PostTopic.create(category=postcategory0, name='考研资料', str='study-advance-material')
    posttopic2 = PostTopic.create(category=postcategory0, name='竞赛', str='study-competition')
    posttopic3 = PostTopic.create(category=postcategory0, name='请教', str='study-advice')

    posttopic4 = PostTopic.create(category=postcategory1, name='计算机', str='major-computer')

    posttopic5 = PostTopic.create(category=postcategory2, name='电影资源', str='live-movie')
    posttopic6 = PostTopic.create(category=postcategory2, name='共享账号', str='live-account')
    posttopic7 = PostTopic.create(category=postcategory2, name='电脑故障', str='live-computer-repair')

    posttopic8 = PostTopic.create(category=postcategory3, name='摄影', str='hobby-photography')
    posttopic9 = PostTopic.create(category=postcategory3, name='健身', str='hobby-fitness')

    posttopic10 = PostTopic.create(name='通知', str='notice')
    posttopic11 = PostTopic.create(name='讨论', str='discussion')


    # ---------------- 测试新文章 --------------
    logger.debug('add post: [SICP换零钱(递归转尾递归)]')
    post = Post.create(
        topic=posttopic0,
        title='SICP换零钱(递归转尾递归)',
        content=tmp_post,
        user=user_admin
    )

    # ---------------- 测试通知 --------------
    logger.debug('add notice: [admin]->[admin\'s followers]')
    Notification.new_post(post)

    # ------------测试新回复--------------
    logger.debug('add postreply: [test]->[admin]')
    postreply = PostReply.create(
            post=post,
            user=user_test,
            content='迭代需要重复利用递归产生的冗余数据'
    )
    post.update_latest_reply(postreply)


    # ---------------- 测试Blog --------------
    logger.debug('add blogpost: [tornado]')
    bpc0 = BlogPostCategory.create(name='Tornado', str='Tornado')
    bp0 = BlogPost.create(title='Tornado', category=bpc0, content='Tornado content')
    BlogPostLabel.add_post_label('python,tornado', bp0)
Example #12
0
def create_test_data(db_mysql):
    from db.mysql_model.user import User, Profile, Follower, ChatMessage
    from db.mysql_model.post import Post, PostReply, PostCategory, PostTopic, CollectPost
    from db.mysql_model.common import Notification
    from db.mysql_model.blog import BlogPost, BlogPostLabel, BlogPostCategory

    logger.debug("DataBase is not exist, so create test data.")


    # -------------------- 测试用户功能 ---------------
    user_admin = User.new(username='******', email='*****@*****.**', password='******')
    user_test = User.new(username='******', email='*****@*****.**', password='******')

    # -------------------- 测试关注功能 ---------------
    Follower.create(user=user_admin, follower=user_test)

    # -------------------- 测试分类功能 --------------
    logger.debug("""
    版块分类
    专业:
        计算机
    学习:
        学习资料、考研资料、家教、竞赛

    生活:
        共享账号、电影资源、常用软件、电脑故障

    爱好:
        摄影、健身

    未分类:
        校园通知、讨论
    """)

    postcategory0 = PostCategory.create(name='学习', str='study')
    postcategory1 = PostCategory.create(name='专业', str='major')
    postcategory2 = PostCategory.create(name='生活', str='live')
    postcategory3 = PostCategory.create(name='爱好', str='hobby')

    posttopic0 = PostTopic.create(category=postcategory0, name='学习资料', str='study-material')
    posttopic1 = PostTopic.create(category=postcategory0, name='考研资料', str='study-advance-material')
    posttopic2 = PostTopic.create(category=postcategory0, name='竞赛', str='study-competition')
    posttopic3 = PostTopic.create(category=postcategory0, name='请教', str='study-advice')

    posttopic4 = PostTopic.create(category=postcategory1, name='计算机', str='major-computer')

    posttopic5 = PostTopic.create(category=postcategory2, name='电影资源', str='live-movie')
    posttopic6 = PostTopic.create(category=postcategory2, name='共享账号', str='live-account')
    posttopic7 = PostTopic.create(category=postcategory2, name='电脑故障', str='live-computer-repair')

    posttopic8 = PostTopic.create(category=postcategory3, name='摄影', str='hobby-photography')
    posttopic9 = PostTopic.create(category=postcategory3, name='健身', str='hobby-fitness')

    posttopic10 = PostTopic.create(name='通知', str='notice')
    posttopic11 = PostTopic.create(name='讨论', str='discussion')


    # ---------------- 测试新文章 --------------
    post = Post.create(
        topic=posttopic0,
        title='test',
        content=tmp_post,
        user=user_admin
    )

    # ---------------- 测试通知 --------------
    Notification.new_post(post)

    # ------------测试新回复--------------
    postreply = PostReply.create(
            post=post,
            user=user_test,
            content='test'
    )
    post.update_latest_reply(postreply)


    # ---------------- 测试Blog --------------
    bpc0 = BlogPostCategory.create(name='Tornado', str='Tornado')
    bp0 = BlogPost.create(title='Tornado', category=bpc0, content='Tornado content')
    BlogPostLabel.add_post_label('python,tornado', bp0)

    # ---------------- 测试chat --------------
    chat_log_0 = ChatMessage.create(sender=user_admin, receiver=user_test, content='self>other')
    chat_log_0 = ChatMessage.create(sender=user_test, receiver=user_admin, content='other>self')
Example #13
0
def create_test_data(db_mysql):
    from db.mysql_model.user import User, Profile, Follower, ChatLog
    from db.mysql_model.post import Post, PostReply, PostCategory, PostTopic, CollectPost
    from db.mysql_model.common import Notification
    from db.mysql_model.blog import BlogPost, BlogPostLabel, BlogPostCategory

    logger.debug("DataBase is not exist, so create test data.")

    # -------------------- 建表 ---------------
    db_mysql.create_tables([User, ChatLog, PostCategory, PostTopic, Post, PostReply, CollectPost, Profile, Follower, Notification, BlogPostCategory, BlogPost, BlogPostLabel], safe=True)
    user_admin = User.new(username='******', email='*****@*****.**', password='******')
    user_test = User.new(username='******', email='*****@*****.**', password='******')

    # -------------------- 测试关注功能 ---------------
    Follower.create(user=user_admin, follower=user_test)

    # -------------------- 测试分类功能 --------------
    logger.debug("""
    版块分类
    docker:
        docker文章
    registry:
        registry文章、私有hub、images分享, dockerfile分享

    docker集群:
        docker集群文章
    """)

    postcategory0 = PostCategory.create(name='docker', str='docker')
    postcategory1 = PostCategory.create(name='registry', str='registry')
    postcategory2 = PostCategory.create(name='docker集群', str='docker-cluster')

    posttopic0 = PostTopic.create(category=postcategory0, name='docker文章', str='docker-article')

    posttopic1 = PostTopic.create(category=postcategory1, name='registry文章', str='registry-article')
    posttopic2 = PostTopic.create(category=postcategory1, name='私有hub', str='private-hub')
    posttopic3 = PostTopic.create(category=postcategory1, name='image分享', str='image-share')
    posttopic4 = PostTopic.create(category=postcategory1, name='dockerfile分享', str='dockerfile-share')

    posttopic5 = PostTopic.create(category=postcategory2, name='docker集群文章', str='docker-cluster-article')

    posttopic10 = PostTopic.create(name='通知', str='notice')
    posttopic11 = PostTopic.create(name='讨论', str='discussion')


    # ---------------- 测试新文章 --------------
    post = Post.create(
        topic=posttopic0,
        title='test',
        content=tmp_post,
        user=user_admin
    )

    # ---------------- 测试通知 --------------
    Notification.new_post(post)

    # ------------测试新回复--------------
    postreply = PostReply.create(
            post=post,
            user=user_test,
            content='test'
    )
    post.update_latest_reply(postreply)


    # ---------------- 测试Blog --------------
    bpc0 = BlogPostCategory.create(name='Tornado', str='Tornado')
    bp0 = BlogPost.create(title='Tornado', category=bpc0, content='Tornado content')
    BlogPostLabel.add_post_label('python,tornado', bp0)

    # ---------------- 测试chat --------------
    chat_log_0 = ChatLog.create(me=user_admin, other=user_test, content='self>other')
    chat_log_0 = ChatLog.create(me=user_test, other=user_admin, content='other>self')
Example #14
0
def create_test_data(db_mysql):
    from db.mysql_model.user import User, Profile, Follower, ChatLog
    from db.mysql_model.post import Post, PostReply, PostCategory, PostTopic, CollectPost
    from db.mysql_model.common import Notification
    from db.mysql_model.blog import BlogPost, BlogPostLabel, BlogPostCategory

    logger.debug("DataBase is not exist, so create test data.")

    # -------------------- 建表 ---------------
    db_mysql.create_tables([User, ChatLog, PostCategory, PostTopic, Post, PostReply, CollectPost, Profile, Follower, Notification, BlogPostCategory, BlogPost, BlogPostLabel], safe=True)
    user_admin = User.new(username='******', email='*****@*****.**', password='******')
    user_test = User.new(username='******', email='*****@*****.**', password='******')

    # -------------------- 测试关注功能 ---------------
    Follower.create(user=user_admin, follower=user_test)

    # -------------------- 测试分类功能 --------------
    logger.debug('''
    版块分类
    docker:
        docker文章
    registry:
        registry文章、私有hub、images分享, dockerfile分享

    docker集群:
        docker集群文章
    ''')

    postcategory0 = PostCategory.create(name='docker', str='docker')
    postcategory1 = PostCategory.create(name='registry', str='registry')
    postcategory2 = PostCategory.create(name='docker集群', str='docker-cluster')

    posttopic0 = PostTopic.create(category=postcategory0, name='docker文章', str='docker-article')

    posttopic1 = PostTopic.create(category=postcategory1, name='registry文章', str='registry-article')
    posttopic2 = PostTopic.create(category=postcategory1, name='私有hub', str='private-hub')
    posttopic3 = PostTopic.create(category=postcategory1, name='image分享', str='image-share')
    posttopic4 = PostTopic.create(category=postcategory1, name='dockerfile分享', str='dockerfile-share')

    posttopic5 = PostTopic.create(category=postcategory2, name='docker集群文章', str='docker-cluster-article')

    posttopic10 = PostTopic.create(name='通知', str='notice')
    posttopic11 = PostTopic.create(name='讨论', str='discussion')


    # ---------------- 测试新文章 --------------
    post = Post.create(
        topic=posttopic0,
        title='test',
        content=tmp_post,
        user=user_admin
    )

    # ---------------- 测试通知 --------------
    Notification.new_post(post)

    # ------------测试新回复--------------
    postreply = PostReply.create(
            post=post,
            user=user_test,
            content='test'
    )
    post.update_latest_reply(postreply)


    # ---------------- 测试Blog --------------
    bpc0 = BlogPostCategory.create(name='Tornado', str='Tornado')
    bp0 = BlogPost.create(title='Tornado', category=bpc0, content='Tornado content')
    BlogPostLabel.add_post_label('python,tornado', bp0)

    # ---------------- 测试chat --------------
    chat_log_0 = ChatLog.create(me=user_admin, other=user_test, content='self>other')
    chat_log_0 = ChatLog.create(me=user_test, other=user_admin, content='other>self')
Example #15
0
def create_test_data(db_mysql):
    from db.mysql_model.user import User, Profile, Follower, ChatMessage
    from db.mysql_model.post import Post, PostReply, PostCategory, PostTopic, CollectPost
    from db.mysql_model.common import Notification
    from db.mysql_model.blog import BlogPost, BlogPostLabel, BlogPostCategory

    logger.debug("DataBase is not exist, so create test data.")

    # -------------------- 测试用户功能 ---------------
    user_admin = User.new(username='******',
                          email='*****@*****.**',
                          password='******')
    user_test = User.new(username='******',
                         email='*****@*****.**',
                         password='******')

    # -------------------- 测试关注功能 ---------------
    Follower.create(user=user_admin, follower=user_test)

    # -------------------- 测试分类功能 --------------
    logger.debug("""
    版块分类
    专业:
        计算机
    学习:
        学习资料、考研资料、家教、竞赛

    生活:
        共享账号、电影资源、常用软件、电脑故障

    爱好:
        摄影、健身

    未分类:
        校园通知、讨论
    """)

    postcategory0 = PostCategory.create(name='学习', str='study')
    postcategory1 = PostCategory.create(name='专业', str='major')
    postcategory2 = PostCategory.create(name='生活', str='live')
    postcategory3 = PostCategory.create(name='爱好', str='hobby')

    posttopic0 = PostTopic.create(category=postcategory0,
                                  name='学习资料',
                                  str='study-material')
    posttopic1 = PostTopic.create(category=postcategory0,
                                  name='考研资料',
                                  str='study-advance-material')
    posttopic2 = PostTopic.create(category=postcategory0,
                                  name='竞赛',
                                  str='study-competition')
    posttopic3 = PostTopic.create(category=postcategory0,
                                  name='请教',
                                  str='study-advice')

    posttopic4 = PostTopic.create(category=postcategory1,
                                  name='计算机',
                                  str='major-computer')

    posttopic5 = PostTopic.create(category=postcategory2,
                                  name='电影资源',
                                  str='live-movie')
    posttopic6 = PostTopic.create(category=postcategory2,
                                  name='共享账号',
                                  str='live-account')
    posttopic7 = PostTopic.create(category=postcategory2,
                                  name='电脑故障',
                                  str='live-computer-repair')

    posttopic8 = PostTopic.create(category=postcategory3,
                                  name='摄影',
                                  str='hobby-photography')
    posttopic9 = PostTopic.create(category=postcategory3,
                                  name='健身',
                                  str='hobby-fitness')

    posttopic10 = PostTopic.create(name='通知', str='notice')
    posttopic11 = PostTopic.create(name='讨论', str='discussion')

    # ---------------- 测试新文章 --------------
    post = Post.create(topic=posttopic0,
                       title='test',
                       content=tmp_post,
                       user=user_admin)

    # ---------------- 测试通知 --------------
    Notification.new_post(post)

    # ------------测试新回复--------------
    postreply = PostReply.create(post=post, user=user_test, content='test')
    post.update_latest_reply(postreply)

    # ---------------- 测试Blog --------------
    bpc0 = BlogPostCategory.create(name='Tornado', str='Tornado')
    bp0 = BlogPost.create(title='Tornado',
                          category=bpc0,
                          content='Tornado content')
    BlogPostLabel.add_post_label('python,tornado', bp0)

    # ---------------- 测试chat --------------
    chat_log_0 = ChatMessage.create(sender=user_admin,
                                    receiver=user_test,
                                    content='self>other')
    chat_log_0 = ChatMessage.create(sender=user_test,
                                    receiver=user_admin,
                                    content='other>self')
Example #16
0
    post = BlogPost.create(title=md_info['title'],
                           category=cate,
                           slug=md_info['slug'],
                           content=md_info['content'])

    BlogPostLabel.add_post_label(md_info['tags'], post)


def get_files(root_path):
    files = os.listdir(root_path)
    print(files)
    for file_name in files:
        _, suffix = os.path.splitext(file_name)
        if suffix == '.md':
            md_file_path = os.path.join(root_path, file_name)
            md_info = check_md_format(md_file_path)
            if md_info:
                print(md_info['title'])
                convert_md_2_post(md_info)

if __name__ == '__main__':
    mysqldb.create_tables([BlogPostLabel, BlogPost, BlogPostCategory], safe=True)
    t = BlogPostLabel.delete()
    t.execute()
    t = BlogPost.delete()
    t.execute()
    t = BlogPostCategory.delete()
    t.execute()

    get_files(md_path)
def create_test_data(db_mysql):
    from db.mysql_model.user import User, Profile, Follower, ChatMessage
    from db.mysql_model.post import Post, PostReply, PostCategory, PostTopic, CollectPost
    from db.mysql_model.common import Notification
    from db.mysql_model.blog import BlogPost, BlogPostLabel, BlogPostCategory

    logger.debug("DataBase is not exist, so create test data.")


    # -------------------- 测试用户功能 ---------------
    user_admin = User.new(username='******', email='*****@*****.**', password='******')
    user_test = User.new(username='******', email='*****@*****.**', password='******')

    # -------------------- 测试关注功能 ---------------
    Follower.create(user=user_admin, follower=user_test)

    # -------------------- 测试分类功能 --------------
    logger.debug('''
    版块分类
    专业:
        计算机
    学习:
        学习资料、考研资料、家教、竞赛

    生活:
        共享账号、电影资源、常用软件、电脑故障

    爱好:
        摄影、健身

    未分类:
        校园通知、讨论
    ''')

    postcategory0 = PostCategory.create(name='分类', str='live')
    posttopic0 = PostTopic.create(category=postcategory0, name='爱学习', str='live-study')
    posttopic1 = PostTopic.create(category=postcategory0, name='爱生活', str='live-life')
    posttopic2 = PostTopic.create(category=postcategory0, name='爱管“闲事”', str='live-thing')

    posttopic10 = PostTopic.create(name='通知', str='notice')
    posttopic11 = PostTopic.create(name='讨论', str='discussion')

    # ---------------- 测试新文章 --------------
    post = Post.create(
        topic=posttopic0,
        title='test',
        content=tmp_post,
        user=user_admin
    )

    # ---------------- 测试通知 --------------
    Notification.new_post(post)

    # ------------测试新回复--------------
    postreply = PostReply.create(
            post=post,
            user=user_test,
            content='test'
    )
    post.update_latest_reply(postreply)


    # ---------------- 测试Blog --------------
    bpc0 = BlogPostCategory.create(name='Tornado', str='Tornado')
    bp0 = BlogPost.create(title='Tornado', category=bpc0, content='Tornado content')
    BlogPostLabel.add_post_label('python,tornado', bp0)

    # ---------------- 测试chat --------------
    chat_log_0 = ChatMessage.create(sender=user_admin, receiver=user_test, content='self>other')
    chat_log_0 = ChatMessage.create(sender=user_test, receiver=user_admin, content='other>self')