北京提供24小时医疗服务_移动端的优势_seo研究中心qq群_专业网店推广

mysql 9.0:

# encoding: utf-8
# 版权所有 2024 ©涂聚文有限公司
# 许可信息查看：言語成了邀功盡責的功臣，還需要行爲每日來值班嗎
# 描述：
# Author    : geovindu,Geovin Du 涂聚文.
# IDE       : PyCharm 2023.1 python 3.11
# OS        : windows 10
# Datetime  : 2024/11/18 22:41
# User      : geovindu
# Product   : PyCharm
# Project   : pyGenerator
# File      : MySqlGenerator/CreateModel.py
# explain   : 学习import os
import re
import sys
import io
import datetime
from common.fileHelper import FileHelper
from common.strHelper import StrHelper
from bll.tableNameAndKey import TableNameAndKeyBll
from bll.tableForegin import TableForeginBll
from bll.tableModel import TableModelBllclass CreateModel(object):""""""def __init__(self):self.__modelpath = os.path.join(os.getcwd() + "/mytest/model/")self.__file = FileHelper()self.__blltablekey = TableNameAndKeyBll()self.__bllTableModel = TableModelBll()self.__database = "MySQL 9.0"self.__os = "windows 10"self.__product = "PyCharm"self.__project = "IctGame"self.__name = "CreateModel"passdef __del__(self):""":return:"""print(f"{self.__name} ERASE MEMORY")def addpackagefile(self):"""生成包配置文件:return:"""now = datetime.datetime.now()#bll = TableNameAndKeyBll()sb = []sbt = f"""
# encoding: utf-8
# 版权所有 2024 ©涂聚文有限公司
# 许可信息查看：言語成了邀功盡責的功臣，還需要行爲每日來值班嗎
# 描述：
# Author    : geovindu,Geovin Du 涂聚文.
# IDE       : PyCharm 2023.1 python 3.11
# OS        : windows 10
# Datetime  : {now.strftime('%Y-%m-%d %H:%M:%S')}
# database  ：{self.__database}
# User      : geovindu
# Product   : PyCharm
# Project   : IctGame
# File      : model/__init__.py
# explain   : 学习"""sb.append(sbt)for li in self.__blltablekey.selectSql():sbp=f"""
from model.{StrHelper.firstLower(li.TableName)} import {StrHelper.firstUper(li.TableName)}Info
"""sb.append(sbp)if not os.path.exists(self.__modelpath):os.makedirs(self.__modelpath)filepath = self.__modelpath + '__init__.py'content = ''.join(sb)ok = self.__file.createModelFile(filepath, content)def add(self):"""生成实体:return:"""#fileHelper=FileHelper()now = datetime.datetime.now()#bll = TableNameAndKeyBll()for li in self.__blltablekey.selectSql():sb = []sbt=f"""
# encoding: utf-8
# 版权所有 2024 ©涂聚文有限公司
# 许可信息查看：言語成了邀功盡責的功臣，還需要行爲每日來值班嗎
# 描述：
# Author    : geovindu,Geovin Du 涂聚文.
# IDE       : PyCharm 2023.1 python 3.11
# OS        : windows 10
# Datetime  : {now.strftime('%Y-%m-%d %H:%M:%S')}
# database  ：{self.__database}
# User      : geovindu
# Product   : PyCharm
# Project   : IctGame
# File      : model/{li.TableName}.py
# explain   : 学习class {StrHelper.firstUper(li.TableName)}Info(object):\"""{li.TableDescription}                    \""" 
"""sb.append(sbt)#tbll = TableModelBll()sinhead = f"""def __init__(self):\"""構造\"""               """sb.append((sinhead))for tli in self.__bllTableModel.selectSql(li.TableName):sin=f"""self._{tli.FieldName} = None\"""{tli.FieldDescription}\""""""sb.append(sin)for pli in self.__bllTableModel.selectSql(li.TableName):psb=f"""@propertydef {pli.FieldName}(self):\"""{pli.FieldDescription}\"""return self._{pli.FieldName}@{pli.FieldName}.setterdef {pli.FieldName}(self, {StrHelper.firstLower(pli.FieldName)}):\"""{pli.FieldDescription}:param {pli.FieldName}::return:\"""self._{pli.FieldName} = {StrHelper.firstLower(pli.FieldName)}       """sb.append(psb)if not os.path.exists(self.__modelpath):os.makedirs(self.__modelpath)filepath=self.__modelpath+StrHelper.firstLower(li.TableName)+'.py'content=''.join(sb)ok = self.__file.createModelFile(filepath,content)

postgreSQL 17.0:

# encoding: utf-8
# 版权所有 2024 ©涂聚文有限公司
# 许可信息查看：言語成了邀功盡責的功臣，還需要行爲每日來值班嗎
# 描述：
# Author    : geovindu,Geovin Du 涂聚文.
# IDE       : PyCharm 2023.1 python 3.11
# OS        : windows 10
# Datetime  : 2024/11/18 22:41
# User      : geovindu
# Product   : PyCharm
# Project   : pyGenerator
# File      : postgreSqlGenerator/CreateModel.py
# explain   : 学习import os
import re
import sys
import io
import datetime
from common.fileHelper import FileHelper
from common.strHelper import StrHelper
from bll.tableNameAndKey import TableNameAndKeyBll
from bll.tableForegin import TableForeginBll
from bll.tableModel import TableModelBllclass CreateModel(object):""""""def __init__(self):self.__modelpath = os.path.join(os.getcwd() + "/posttest/model/")self.__file = FileHelper()self.__blltablekey = TableNameAndKeyBll()self.__bllTableModel = TableModelBll()self.__database = "postgreSQL 17.0"self.__os = "windows 10"self.__product = "PyCharm"self.__project = "IctGame"self.__name = "CreateModel"passdef __del__(self):""":return:"""print(f"{self.__name} ERASE MEMORY")def addpackagefile(self):"""生成包配置文件:return:"""now = datetime.datetime.now()#bll = TableNameAndKeyBll()sb = []sbt = f"""
# encoding: utf-8
# 版权所有 2024 ©涂聚文有限公司
# 许可信息查看：言語成了邀功盡責的功臣，還需要行爲每日來值班嗎
# 描述：
# Author    : geovindu,Geovin Du 涂聚文.
# IDE       : PyCharm 2023.1 python 3.11
# OS        : windows 10
# Datetime  : {now.strftime('%Y-%m-%d %H:%M:%S')}
# database  ：{self.__database}
# User      : geovindu
# Product   : PyCharm
# Project   : IctGame
# File      : model/__init__.py
# explain   : 学习"""sb.append(sbt)for li in self.__blltablekey.selectSql():sbp=f"""
from model.{StrHelper.firstLower(li.TableName)} import {StrHelper.firstUper(li.TableName)}Info
"""sb.append(sbp)if not os.path.exists(self.__modelpath):os.makedirs(self.__modelpath)filepath = self.__modelpath + '__init__.py'content = ''.join(sb)ok = self.__file.createModelFile(filepath, content)def add(self):"""生成实体:return:"""#fileHelper=FileHelper()now = datetime.datetime.now()#bll = TableNameAndKeyBll()for li in self.__blltablekey.selectSql():sb = []sbt=f"""
# encoding: utf-8
# 版权所有 2024 ©涂聚文有限公司
# 许可信息查看：言語成了邀功盡責的功臣，還需要行爲每日來值班嗎
# 描述：
# Author    : geovindu,Geovin Du 涂聚文.
# IDE       : PyCharm 2023.1 python 3.11
# OS        : windows 10
# Datetime  : {now.strftime('%Y-%m-%d %H:%M:%S')}
# database  ：{self.__database}
# User      : geovindu
# Product   : PyCharm
# Project   : IctGame
# File      : model/{li.TableName}.py
# explain   : 学习class {StrHelper.firstUper(li.TableName)}Info(object):\"""{li.TableDescription}                    \""" 
"""sb.append(sbt)#tbll = TableModelBll()sinhead = f"""def __init__(self):\"""構造\"""               """sb.append((sinhead))for tli in self.__bllTableModel.selectSql(li.TableName):sin=f"""self._{tli.FieldName} = None\"""{tli.FieldDescription}\""""""sb.append(sin)for pli in self.__bllTableModel.selectSql(li.TableName):psb=f"""@propertydef {pli.FieldName}(self):\"""{pli.FieldDescription}\"""return self._{pli.FieldName}@{pli.FieldName}.setterdef {pli.FieldName}(self, {StrHelper.firstLower(pli.FieldName)}):\"""{pli.FieldDescription}:param {pli.FieldName}::return:\"""self._{pli.FieldName} = {StrHelper.firstLower(pli.FieldName)}       """sb.append(psb)if not os.path.exists(self.__modelpath):os.makedirs(self.__modelpath)filepath=self.__modelpath+StrHelper.firstLower(li.TableName)+'.py'content=''.join(sb)ok = self.__file.createModelFile(filepath,content)

mysql:

postgresql:

sql server: