werkzeug实现简单Python web框架（4）：添加orm支持

本文链接：https://blog.csdn.net/yz764127031/article/details/77835820

完整代码：
https://github.com/yangzhezjgs/Light/tree/master/webapp

orm代码：
参考前文 Python实现简单orm
将代码复制粘贴到orm.py文件即可。

下面我们用一个例子来说明这个简单orm的使用。
(1)新建 scheme.sql

drop database if exists my_user;

create database my_user;

use my_user;

create table users (
    `id` varchar(50) not null,
    `passwd` varchar(50) not null,
    `name` varchar(50) not null,
    primary key (`id`)
) engine=innodb default charset=utf8;

(2)执行mysql -uroot -p <scheme.sql 并输入密码。

(3)使用orm插入数据
新建demo.py

from webapp import WebApp,View,render_template
from orm import Model,StringField

class User(Model):
    __table__ = 'users'
    __database__='my_user'
    id = StringField(primary_key=True, ddl='varchar(50)')
    passwd = StringField(ddl='varchar(50)')
    name = StringField(ddl='varchar(50)')


class Index(View):
    def GET(self,request):
        user1 = User.filter()[0]
        name = user1.get('name')
        return render_template("index.html",name=name)

class Test(View):
    def GET(self,request,my_id):
        return "test",my_id

urls = [
{
    'url':'/',
    'view':Index
},
{
   'url':'/test/<my_id>',
   'view':Test
}
] 
if __name__ == '__main__':

    app = WebApp()

    app.add_url_rule(urls)

    app.run()

插入数据

master@ubuntu:~/webapp$ python3
Python 3.6.0 |Anaconda 4.3.1 (64-bit)| (default, Dec 23 2016, 12:22:00) 
[GCC 4.4.7 20120313 (Red Hat 4.4.7-1)] on linux
Type "help", "copyright", "credits" or "license" for more information.
>>> from demo import User
>>> u = User(id=0,passwd='123456',name='xiaoming')
>>> u.save()
insert into `users` (`passwd`, `name`, `id`) values (?, ?, ?) ['123456', 'xiaoming', 0]
insert into `users` (`passwd`, `name`, `id`) values ('123456', 'xiaoming', '0')
()