A simple webframe base on web.py

开源地址

https://github.com/gongqingkui/webFrameBaseOnWeb.py

sqlite3数据库如下

PRAGMA foreign_keys=OFF;

BEGIN TRANSACTION;
CREATE TABLE msgs(
            id integer primary key,
            name text,
            date text,
            content text);
INSERT INTO "msgs" VALUES(3,'王五','2016-05-20 15:49:59','我叫王五，是一个路人甲，有天我在街上走着，看到对面来了一个人。这个人膀大腰圆，身上纹着一条龙……');
INSERT INTO "msgs" VALUES(4,'GONG QingKui','2016-05-20 16:09:12','This is a simple webframe base on web.py.
');
COMMIT;

代码如下
# encoding: utf-8
import web,os,sqlite3,time
from web import form
#templete floder
render = web.template.render('templates/')
#url tables
urls = ('/', 'viewPost',
    '/newPost', 'newPost',
    '/new', 'new',
    '/delete','delete',
    '/editPost', 'editPost',
    '/edit', 'edit',
    '/viewPost', 'viewPost')


#get or post -> function
class delete:
    #GET function
    def GET(self):
        # url eg. http://192.168.1.3:1234/delete?id=1
        i = web.input(id=None)
        #db
        sdb = sqldb()
        sdb.cu.execute('delete from msgs where id = ?', i.id)
        sdb.conn.commit()
        #go to /viewPost page
        return web.seeother('/viewPost')




class edit:
    #POST function
    def POST(self):
        #the form is i
        i = web.input()
        date = time.strftime('%Y-%m-%d %H:%M:%S', time.localtime())
        sdb = sqldb()
        i = (i.name, i.content, i.id)
        rec = sdb.cu.execute(
            'update msgs set name = ?,content= ? where id = ?', i)
        sdb.conn.commit()
        return web.seeother('/viewPost')


    def GET(self):
        return web.seeother('/')




class new:
    def POST(self):
        i = web.input()
        date = time.strftime('%Y-%m-%d %H:%M:%S', time.localtime())
        sdb = sqldb()
        rec = sdb.cu.execute('select * from msgs')
        dbre = sdb.cu.fetchall()
        for k in dbre:
            j = k[0] + 1


        t = (j, i.name, date, i.content)
        print t
        sdb.cu.execute('insert into msgs values(?,?,?,?)', t)
        sdb.conn.commit()
        return web.seeother('/viewPost')


    def GET(self):
        return web.seeother('/')




class newPost:
    def GET(self):
        return render.newPost()




class editPost:
    def GET(self):
        i = web.input()
        sdb = sqldb()
        rec = sdb.cu.execute('select * from msgs where id = ?', i.id)
        dbre = sdb.cu.fetchall()
        return render.editPost(dbre)




class viewPost:
    def GET(self):
        sdb = sqldb()
        rec = sdb.cu.execute('select * from msgs')
        dbre = sdb.cu.fetchall()
        return render.viewPost(dbre)




class sqldb:
    def __init__(self):
        if os.path.exists('msg.db'):
            self.conn = sqlite3.connect('msg.db')
            self.cu = self.conn.cursor()
        else:
            self.conn = sqlite3.connect('msg.db')
            self.cu = self.conn.cursor()
            self.cu.execute('create table msgs(id integer primary key,name text,date text,content text)')
            self.cu.execute("insert into msgs values(1,'gong','2016-05-16 16:36:00','hello gong')")
            self.conn.commit()




if __name__ == '__main__':
    app = web.application(urls, globals())
    app.run()