本文共 2734 字，大约阅读时间需要 9 分钟。

model 建立数据库表名

运行示例

# model.py#!/usr/bin/env python3# -*- coding: utf-8 -*-# Python基础-model模块import time, uuidfrom orm import Model, StringField, BooleanField, FloatField, TextField# 主键的缺省值def next_id():    # time.time 设置当前日期和时间    return '%015d%s000' % (int(time.time() * 1000), uuid.uuid4().hex)# 建立数据库表 usersclass 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)# 建立数据库表 blogsclass 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)# 建立数据库表 commentsclass 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.pyINFO:root:found model : User (table: users)INFO:root:Found mapping: id --> 
   
    INFO:root:Found mapping: email --> 
    
     INFO:root:Found mapping: passwd --> 
     
      INFO:root:Found mapping: admin --> 
      
       INFO:root:Found mapping: name --> 
       
        INFO:root:Found mapping: image --> 
        
         INFO:root:Found mapping: created_at --> 
         
          INFO:root:found model : Blog (table: blogs)INFO:root:Found mapping: id --> 
          
           INFO:root:Found mapping: user_id --> 
           
            INFO:root:Found mapping: user_name --> 
            
             INFO:root:Found mapping: user_image --> 
             
              INFO:root:Found mapping: name --> 
              
               INFO:root:Found mapping: summary --> 
               
                INFO:root:Found mapping: content --> 
                
                 INFO:root:Found mapping: created_at --> 
                 
                  INFO:root:found model : Comment (table: comments)INFO:root:Found mapping: id --> 
                  
                   INFO:root:Found mapping: blog_id --> 
                   
                    INFO:root:Found mapping: user_id --> 
                    
                     INFO:root:Found mapping: user_name --> 
                     
                      INFO:root:Found mapping: user_image --> 
                      
                       INFO:root:Found mapping: content --> 
                       
                        INFO:root:Found mapping: created_at --> 
                        
                       
                      
                     
                    
                   
                  
                 
                
               
              
             
            
           
          
         
        
       
      
     
    
   

Python基础-MySQL的安装和运行

提交git

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

转载地址：http://yacti.baihongyu.com/