微爬(Wepy) v2.0 - Python微框架

for tpl模板源码: ./views/front/blog/mtype.htm

{% extends "root/_incs/lay_root.htm" %}

{% block title %}<title>Sqlite博客 - {{ g.sys['title']}}</title>{% endblock %}

{% block head %}
    <h1>blog-首页</h1>
    <p>
        Sqlite博客 --- 
        {% if g.ses['logged'] %}
        <a href="./blog-lists">管理</a> - 
        <a href="./blog-login?act=out&_r={{g.run.timer}}">登出</a> 
        {% else %}
        <a href="./blog-login">登陆</a> 
        {% endif %}
    </p>
{% endblock %}

{% block main %}

<div class="in">
    <h2><span class="tg1">catalog</span>(栏目)</h2>
    <div class="tc">
        <a href="./blog">[All]</a> 
        {% for itm in d.data.catalog %}
        - <a href="./blog-{{ itm['kid'] }}">{{ itm['title'] }}</a> 
        {% endfor %}
    </div>
</div>

<div class="in">
        <h2><span class="tg1">{{ g.mkvs.key }}</span>{{ d.data.cdic[g.mkvs.key] }}</h2>
        <div>
            {% for itm in d.data.blog %}
            <p>
                <i class="r">{{ itm['id'] }}</i>
                <b><a href="./blog.{{itm['id']}}">{{ itm['title'] }}</a></b> 
                <br> <span class="c999">{{ itm['detail'] }}</span>
            </p>
            {% endfor %}
        </div>
    </div>

<p class="tc cF00">Blog完成基本的增删改操作；简单模拟登陆，分页还没有做！</p>

</div>

{% endblock %}

for Ctrl控制器源码: ./ctrls/front_blogCtrl.py::_mtypeAct

#coding=UTF-8

import copy
from core import argv, dbop
from flask import request, g, flash, session

# main名称固定
class main:

# `__init__`一致格式
    def __init__(self, app):
        self.app = app
        self.data = {}
        cdb = dict(copy.deepcopy(g.cdb), **g.exdb)
        self.db = dbop.dbm(cdb)
        self.data['catalog'] = self.db.get('SELECT * FROM {catalog}')
        cdic = {}
        for itm in self.data['catalog']:
            cdic[itm['kid']] = itm['title']
        self.data['cdic'] = cdic

def indexAct(self):
        data = self.data
        parts = {}
        for itm in data['catalog']:
            sql = 'SELECT * FROM {article} WHERE cid=? ORDER BY id DESC'
            blogs = self.db.get(sql, (itm['kid'],), 5)
            if blogs:
                parts[itm['kid']] = blogs
        data['parts'] = parts
        return data

def _mtypeAct(self):
        data = self.data
        sql = 'SELECT * FROM {article} WHERE cid=? ORDER BY id DESC'
        data['blog'] = self.db.get(sql, (g.mkvs['key'],), 20)
        return data

def loginAct(self): # +<out>
        data = self.data
        act = argv.get('act')
        # logout
        if act=="out":
            #session['logged'] = False
            g.ses['logged'] = ''
            flash('You were logged out!')
            data['d'] = {'tpname':'dir', 'message':'/front/blog'}
            return data
        # login
        msg = 'Please login!' if not g.ses['logged'] else 'Your are logged!'
        if request.method == 'POST':
            if request.form['user'] != g.exdb['user']:
                msg = 'Invalid username'
            elif request.form['pass'] != g.exdb['pass']:
                msg = 'Invalid password'
            else:
                session['logged'] = True
                g.ses['logged'] = 1
                #msg = 'Login OK!'
                flash('You were logged in')
                data['d'] = {'tpname':'dir', 'message':'/front/blog-lists'}
        data['msg'] = msg
        return data

def listsAct(self): # +<del>
        #session['logged'] = True ;g.ses['logged'] = 1
        data = self.data
        act = argv.get('act')
        # check
        if not g.ses['logged']:
            data['d'] = {'tpname':'dir', 'message':'/front/blog'}
            return data
        # logout
        if act=="del": # ?cid=&page=&kw=
            oid = argv.get('id')
            if 'txjia.com' in request.host:
                data['d'] = {'tpname':'dir', 'message':'/front/blog-lists'}
                #data['msg'] = 'Can NOT oprate @DemoSite!'
                return data
            self.db.exe('DELETE FROM {article} WHERE id=?',(oid,))
            data['d'] = {'tpname':'dir', 'message':'/front/blog-lists'}
            return data
        # lists
        cid = argv.get('cid')
        data['cid'] = cid
        where = "cid='"+cid+"'" if cid else '1=1' # 安全???
        sql = 'SELECT * FROM {article} WHERE '+where+' ORDER BY id DESC'
        data['blog'] = self.db.get(sql, (), 20)
        data['host'] = request.host
        return data

# `form`方法
    def formAct(self): # add/edit
        #session['logged'] = True ;g.ses['logged'] = 1
        data = self.data
        # check
        if not g.ses['logged']:
            data['d'] = {'tpname':'dir', 'message':'/front/blog'}
            return data
            #pass
        # post
        data['id'] = oid = argv.get('id')
        if request.method == 'POST':
            if 'txjia.com' in request.host:
                data['d'] = {'tpname':'dir', 'message':'/front/blog-lists'}
                #data['msg'] = 'Can NOT oprate @DemoSite!'
                return data
            title = request.form['title']
            detail = request.form['detail']
            cid = request.form['cid']
            if not title:
                data['d'] = {'tpname':'dir', 'message':'/front/blog-lists'}
                return data
            if oid:
                sql = 'UPDATE {article} SET title=?,cid=?,detail=? WHERE id=?'
                sp = (title, cid, detail, oid)
            else:
                sql = 'INSERT INTO {article} (title,cid,detail) values (?,?,?)'
                sp = (title, cid, detail)
            self.db.exe(sql, sp)
            flash('Article posted ok!')
            data['d'] = {'tpname':'dir', 'message':'/front/blog-lists'}
            return data
        # row
        data['row'] = self.db.get('SELECT * FROM {article} WHERE id=?', (oid,), 1)
        if not data['row']:
            data['id'] = oid = ''
        data['r_cid'] = data['row']['cid'] if data['row'] else ''
        data['msg'] = '修改:id='+str(oid) if oid else '增加'
        data['host'] = request.host
        return data

# `_detail`方法
    def _detailAct(self): # detail
        data = self.data
        data['id'] = oid = g.mkvs['key']
        # row
        data['row'] = self.db.get('SELECT * FROM {article} WHERE id=?', (oid,), 1)
        if not data['row']:
            data['d'] = {'tpname':'dir', 'message':'/front/blog'}
            return data
        data['row']['detail'] = data['row']['detail'].replace('\n', '<br>\n').replace(' ', '&nbsp;')
        return data

'''

微爬(Wepy) 源码查看器

for tpl模板源码: ./views/front/blog/mtype.htm

for Ctrl控制器源码: ./ctrls/front_blogCtrl.py::_mtypeAct