Python Blog.findNumber方法代码示例

# 需要导入模块: from models import Blog [as 别名]
# 或者: from models.Blog import findNumber [as 别名]
def index(*, page="1"):
    page_index = get_page_index(page)
    num = yield from Blog.findNumber("count(id)")
    p = Page(num, page_index, page_size=5)
    blogs = yield from Blog.findAll(orderBy="created_at desc", limit=(p.offset, p.limit))
    for blog in blogs:
        blog.html_summary = markdown2.markdown(blog.summary)
    return {"__template__": "blogs.html", "page_index": get_page_index(page), "blogs": blogs}

# 需要导入模块: from models import Blog [as 别名]
# 或者: from models.Blog import findNumber [as 别名]
def api_blogs(*, page='1'):
    page_index = get_page_index(page)
    num = yield from Blog.findNumber('count(id)')
    p = Page(num, page_index)
    if num == 0:
        return dict(page=p, blogs=())
    blogs = yield from Blog.findAll(orderBy='created_at desc', limit=(p.offset, p.limit))
    return dict(page=p, blogs=blogs)

# 需要导入模块: from models import Blog [as 别名]
# 或者: from models.Blog import findNumber [as 别名]
def api_index(*, page="1"):
    page_index = get_page_index(page)
    num = yield from Blog.findNumber("count(id)")
    p = Page(num, page_index, page_size=5)
    if num == 0:
        return dict(page=p, blogs=())
    blogs = yield from Blog.findAll(orderBy="created_at desc", limit=(p.offset, p.limit))
    return dict(page=p, blogs=blogs)

# 需要导入模块: from models import Blog [as 别名]
# 或者: from models.Blog import findNumber [as 别名]
def index(*, page="1"):
    page_index = get_page_index(page)
    num = yield from Blog.findNumber("count(id)")
    page = Page(num, page_index)
    if num == 0:
        blogs = []
    else:
        blogs = yield from Blog.findAll(orderBy="created_at desc", limit=(page.offset, page.limit))
    return {"__template__": "blogs.html", "page": page, "blogs": blogs}

# 需要导入模块: from models import Blog [as 别名]
# 或者: from models.Blog import findNumber [as 别名]
def get_blogs(*, p_index=1):
    int_index = get_page_index(p_index)
    num = yield from Blog.findNumber('count(id)')
    p = Page(num, int_index, page_size=5)

    if num == 0:
        return dict(page=p, blogs=())
    blogs = yield from Blog.findAll(orderBy='created_at desc', limit=(p.offset, p.limit))
    return dict(page=p, blogs=blogs)

# 需要导入模块: from models import Blog [as 别名]
# 或者: from models.Blog import findNumber [as 别名]
def myapi_blogs(request,*, page='1'):
    where_user='user_name='+'\''+request.__user__.name+'\''
    page_index = get_page_index(page)
    num = yield from Blog.findNumber('count(id)',where=where_user)
    p = Page(num, page_index)
    if num == 0:
        return dict(page=p, blogs=())
    blogs = yield from Blog.findAll(where=where_user,orderBy='created_at desc', limit=(p.offset, p.limit))
    return dict(page=p, blogs=blogs)

# 需要导入模块: from models import Blog [as 别名]
# 或者: from models.Blog import findNumber [as 别名]
def api_blogs(*, page='1'):
    page_index = get_page_index(page)
    num = yield from Blog.findNumber('count(id)') # num为博客总数
    p =Page(num, page_index) # 创建page对象
    if num ==0:
        return dict(page=p, blogs=())
    # 博客书不为0就从数据库中抓取博客
    # limit强制select返回指定的记录数
    blogs = yield from Blog.findAll(orderBy='created_at desc', limit=(p.offset, p.limit))
    return dict(page=p, blogs=blogs) # 返回dict，以供response的中间件处理

# 需要导入模块: from models import Blog [as 别名]
# 或者: from models.Blog import findNumber [as 别名]
def api_blogs(*, page='1'):
    page_index = get_page_index(page)
    num = yield from Blog.findNumber('count(id)')  # num为博客总数
    p = Page(num, page_index) # 创建page对象
    if num == 0:
        return dict(page=p, blogs=())  # 若博客数为0,返回字典,将被app.py的response中间件再处理
    # 博客总数不为0,则从数据库中抓取博客
    # limit强制select语句返回指定的记录数,前一个参数为偏移量,后一个参数为记录的最大数目
    blogs = yield from Blog.findAll(orderBy="created_at desc", limit=(p.offset, p.limit))
    return dict(page=p, blogs=blogs)  # 返回字典,以供response中间件处理

# 需要导入模块: from models import Blog [as 别名]
# 或者: from models.Blog import findNumber [as 别名]
def api_private_blogs(*, page='1'):
    page_index = get_page_index(page)
    num = yield from Blog.findNumber('count(id)')
    p = Page(num, page_index, page_size=20)
    if num == 0:
        return dict(page=p, blogs=())
    blogs = yield from Blog.findAll(orderBy='created_at desc', limit=(p.offset, p.limit))
    for blog in blogs:
        blog.content = ''
    return dict(page=p, blogs=blogs)

# 需要导入模块: from models import Blog [as 别名]
# 或者: from models.Blog import findNumber [as 别名]
def api_blogs(*, page = '1'):
	# 获取博客信息,调用位置：manage_blogs.html 40行
	'''
	请参考29行的api_get_users函数的注释
	'''
	page_index = get_page_index(page)
	blog_count = yield from Blog.findNumber('count(id)')
	p = Page(blog_count, page_index)
	if blog_count == 0:
		return dict(page = p, blogs = [])
	blogs = yield from Blog.findAll(orderBy = 'created_at desc', limit = (p.offset, p.limit))
	return dict(page = p, blogs = blogs)

# 需要导入模块: from models import Blog [as 别名]
# 或者: from models.Blog import findNumber [as 别名]
def index(*, page='1'):
    page_index = get_page_index(page)
    num = yield from Blog.findNumber('count(id)')
    page = Page(num)
    if num == 0:
        blogs = []
    else:
        blogs = yield from Blog.findAll(orderBy='created_at desc', limit=(page.offset, page.limit))
    return {
        '__template__': 'blogs.html',
        'page': page,
        'blogs': blogs
    }

# 需要导入模块: from models import Blog [as 别名]
# 或者: from models.Blog import findNumber [as 别名]
def search_word(*, type='name', word='1', page='1'):
    page_index = get_page_index(page)
    num = yield from Blog.findNumber('count(id)')
    #select count(id) _num_ from `blogs`    根据id计数，找到blog中所有信息个数
    page = Page(num, page_index)                        #根据页码的信息去找到要传回去的信息个数，起始和终止
    #blogs = yield from Blog.findAll('`name`', like='\'%%C%%\'', orderBy='created_at desc')
    blogs = yield from Blog.findAll('`%s`' % type, like='%s' % word, orderBy='created_at desc', limit=(page.offset, page.limit))
    url = word + '?page='          #值得注意，只需要最后一个变量，多了会出错
    return {
        '__template__': 'search_blogs.html',
        'page': page,
        'blogs': blogs,
        'url': url,
    }

# 需要导入模块: from models import Blog [as 别名]
# 或者: from models.Blog import findNumber [as 别名]
def user_blogs(id,*, page='1'):
    where_user='user_name='+'\''+id+'\''
    page_index = get_page_index(page)
    num = yield from Blog.findNumber('count(id)',where=where_user)
    page = Page(num,page_index=page_index)
    if num == 0:
        blogs = []
    else:
        blogs = yield from Blog.findAll(where=where_user,orderBy='created_at desc', limit=(page.offset, page.limit))
    return {
        '__template__': 'user_blogs.html',
        'page': page,
        'blogs': blogs,
        'id': id
    }

# 需要导入模块: from models import Blog [as 别名]
# 或者: from models.Blog import findNumber [as 别名]
def index(*, page="1"):
    page_index = get_page_index(page)
    num = yield from Blog.findNumber("count(id)")
    page = Page(num)
    if num == 0:
        blogs = []
    else:
        blogs = yield from Blog.findAll(orderBy="created_at desc", limit=(page.offset, page.limit))
    # 返回一个字典, 其指示了使用何种模板,模板的内容
    # app.py的response_factory将会对handler的返回值进行分类处理
    return{
        "__template__": "blogs.html",
        "page": page,
        "blogs": blogs  # 参数blogs将在jinja2模板中被解析
    }

# 需要导入模块: from models import Blog [as 别名]
# 或者: from models.Blog import findNumber [as 别名]
def index(*, page='1'):
    #获取页面索引，默认为1；因为首页默认索引页为1，其实这里没用上：
    page_index = get_page_index(page)
    #获取数据库中的文章总数：
    num = yield from Blog.findNumber('count(id)')
    page = Page(num, page_index)
    if num == 0:
        blogs = []
    else:
        #查询数据库中Blog表中对应分页的文章结果；(limit为mysql的分页查询条件)
        blogs = yield from Blog.findAll(orderBy='created_at desc', limit=(page.offset, page.limit))
    return {
        '__template__': 'blogs.html',
        'page': page,
        'blogs': blogs
    }