Python基础-项目-day4 model 建立数据库表名

model 建立数据库表名

运行示例

# model.py
#!/usr/bin/env python3
# -*- coding: utf-8 -*-
# Python基础-model模块

import time, uuid

from orm import Model, StringField, BooleanField, FloatField, TextField

# 主键的缺省值
def next_id():
    # time.time 设置当前日期和时间
    return '%015d%s000' % (int(time.time() * 1000), uuid.uuid4().hex)

# 建立数据库表 users
class User(Model):
    # 表名
    __table__ = "users"

    # 数据库-字段
    id = StringField(primary_key=True, default = next_id, ddl = 'varchar(50)')
    email = StringField(ddl='varchar(50)')
    passwd = StringField(ddl='varchar(50)')
    admin = BooleanField()
    name = StringField(ddl='varchar(50)')
    image = StringField(ddl='varchar(500)')
    created_at = FloatField(default=time.time)

# 建立数据库表 blogs
class Blog(Model):
    # 数据库-表名
    __table__ = 'blogs'

    # 数据库-字段
    id = StringField(primary_key=True, default=next_id, ddl='varchar(50)')
    user_id = StringField(ddl='varchar(50)')
    user_name = StringField(ddl='varchar(50)')
    user_image = StringField(ddl='varchar(500)')
    name = StringField(ddl='varchar(50)')
    summary = StringField(ddl='varchar(200)')
    content = TextField()
    created_at = FloatField(default=time.time)

# 建立数据库表 comments
class Comment(Model):
    # 数据库-表名
    __table__ = 'comments'

    # 数据库-字段
    id = StringField(primary_key=True, default=next_id, ddl='varchar(50)')
    blog_id = StringField(ddl='varchar(50)')
    user_id = StringField(ddl='varchar(50)')
    user_name = StringField(ddl='varchar(50)')
    user_image = StringField(ddl='varchar(500)')
    content = TextField()
    created_at = FloatField(default=time.time)

运行结果

D:\python3-webapp-Su\www>python model.py
INFO:root:found model : User (table: users)
INFO:root:Found mapping: id --> <StringField, varchar(50) : None>
INFO:root:Found mapping: email --> <StringField, varchar(50) : None>
INFO:root:Found mapping: passwd --> <StringField, varchar(50) : None>
INFO:root:Found mapping: admin --> <BooleanField, boolean : None>
INFO:root:Found mapping: name --> <StringField, varchar(50) : None>
INFO:root:Found mapping: image --> <StringField, varchar(500) : None>
INFO:root:Found mapping: created_at --> <FloatField, real : None>
INFO:root:found model : Blog (table: blogs)
INFO:root:Found mapping: id --> <StringField, varchar(50) : None>
INFO:root:Found mapping: user_id --> <StringField, varchar(50) : None>
INFO:root:Found mapping: user_name --> <StringField, varchar(50) : None>
INFO:root:Found mapping: user_image --> <StringField, varchar(500) : None>
INFO:root:Found mapping: name --> <StringField, varchar(50) : None>
INFO:root:Found mapping: summary --> <StringField, varchar(200) : None>
INFO:root:Found mapping: content --> <TextField, text : None>
INFO:root:Found mapping: created_at --> <FloatField, real : None>
INFO:root:found model : Comment (table: comments)
INFO:root:Found mapping: id --> <StringField, varchar(50) : None>
INFO:root:Found mapping: blog_id --> <StringField, varchar(50) : None>
INFO:root:Found mapping: user_id --> <StringField, varchar(50) : None>
INFO:root:Found mapping: user_name --> <StringField, varchar(50) : None>
INFO:root:Found mapping: user_image --> <StringField, varchar(500) : None>
INFO:root:Found mapping: content --> <TextField, text : None>
INFO:root:Found mapping: created_at --> <FloatField, real : None>

Python基础-MySQL的安装和运行

http://blog.csdn.net/su749520/article/details/78888091

提交git

git add .
git commit -m "Python基础-项目-day4 model 建立数据库表名"
git push -u origin master