測驗開發-后端開發do物體類創建-有解無憂

創建user表物體類

新增do目錄下創建user_entity.py和init.py

from sqlalchemy import Integer
from server import db


"""
User表的物體類，與DB欄位一致
"""
class UserEntity(db.Model):

    # 表名, 需要重新命名，默認按類名來創建表名
    __tablename__ = "user"
    # 唯一主鍵ID
    id = db.Column(Integer,primary_key=True)
    # 用戶名，唯一，不可為空
    username = db.Column(db.String(64), nullable=False, unique=True)
    # 密碼，不為空
    password = db.Column(db.String(128), nullable=False)

    def user_entity_dict(self):
        return {"id": self.id, "username": self.username, "password": self.password}

在do的init.py檔案寫入create_all()方法來初始化創建表

from server import db
from do.user_entity import UserEntity   # 倒入要執行的物體類包

"""
    資料庫表創建,運行檔案創建
    注意：創建一次后，就可以注釋掉，避免之后每次啟動專案都創建
"""

if __name__ == "__main__":
    db.create_all()

執行創建表

/usr/local/bin/python3.8 /Applications/Python/TestPlatform/api_test_platform_demo/backend/do/__init__.py
2023-07-04 00:38:57,648 INFO sqlalchemy.engine.Engine SELECT DATABASE()
2023-07-04 00:38:57,648 INFO sqlalchemy.engine.Engine [raw sql] {}
2023-07-04 00:38:57,661 INFO sqlalchemy.engine.Engine SELECT @@sql_mode
2023-07-04 00:38:57,661 INFO sqlalchemy.engine.Engine [raw sql] {}
2023-07-04 00:38:57,667 INFO sqlalchemy.engine.Engine SELECT @@lower_case_table_names
2023-07-04 00:38:57,668 INFO sqlalchemy.engine.Engine [raw sql] {}
2023-07-04 00:38:57,679 INFO sqlalchemy.engine.Engine BEGIN (implicit)
2023-07-04 00:38:57,680 INFO sqlalchemy.engine.Engine SELECT COUNT(*) FROM information_schema.tables WHERE table_schema = %(table_schema)s AND table_name = %(table_name)s
2023-07-04 00:38:57,680 INFO sqlalchemy.engine.Engine [generated in 0.00026s] {'table_schema': 'testplatform', 'table_name': 'user'}
2023-07-04 00:38:57,689 INFO sqlalchemy.engine.Engine 
CREATE TABLE user (
	id INTEGER NOT NULL AUTO_INCREMENT, 
	username VARCHAR(64) NOT NULL, 
	password VARCHAR(128) NOT NULL, 
	PRIMARY KEY (id), 
	UNIQUE (username)
)
2023-07-04 00:38:57,689 INFO sqlalchemy.engine.Engine [no key 0.00021s] {}
2023-07-04 00:38:57,773 INFO sqlalchemy.engine.Engine COMMIT
Process finished with exit code 0

查看資料庫中是否創建成功

user表以及欄位創建成功啦，以此類推所有的物體類一次性寫好一起創建

轉載請註明出處，本文鏈接：https://www.uj5u.com/houduan/556524.html

標籤：其他

上一篇：C++面試八股文：如何實作一個strncpy函式？

下一篇：返回列表