您好,登錄后才能下訂單哦!
這篇文章將為大家詳細(xì)講解有關(guān)怎么在Python中使用Flask動(dòng)態(tài)創(chuàng)建表,文章內(nèi)容質(zhì)量較高,因此小編分享給大家做個(gè)參考,希望大家閱讀完這篇文章后對(duì)相關(guān)知識(shí)有一定的了解。
代碼如下:
from app_factory import app from sqlalchemy import Column, String, Integer class ProjectModel(app.db.model, app.db.Mixin): tablename = 'Project_' ID = Column(String(50), name='ID', doc='id') PROJECTNUMBER = Column(String(100), name='PROJECTNUMBER', doc='項(xiàng)目編號(hào)') ...... @staticmethod def create_table(project_number) table_name = ProjectModel.tablename + projectnumber structs = [ {'fieldname': 'id', 'type': 'varchar2(50)', 'primary': True, 'default': ''}, {'fieldname': 'PROJECTNUMBER', 'type': 'varchar2(50)', 'default': 0, 'isnull': True}, ....... ] app.db.create_table(table_name, structs)
那么,內(nèi)層函數(shù)是如何創(chuàng)建的呢?其實(shí)就是拼接sql語(yǔ)句create table ....
代碼如下:
class SQLAlchemyDB(SQLAlchemy): def __init__(self, app) super(SQLAlchemyDB, self).__init__(app) self.__app = app self.engine.echo = False self.conn = self.engine.connect() self.Model.to_dict() = lambda self:{c.name:getattr(self, c.name, None) for c in self.__table__.columns} self.Session = sessionmaker(bind=self.engine) self.ScopedSession = lambda: scoped_session(self.Session) # 釋放碎片空間 def free_idle_space(self): return self.execute('purge recyclebin') def connstatus(self): return self.engine.pool.status() def close(self): self.conn.close() self.engine.dispose() # 非返回?cái)?shù)據(jù)的記錄語(yǔ)句 def execute(self, sqlexpr) try: ret = self.conn.execute(sqlalchemy.text(sqlexpr)) except Exception as err: return False, str(err) except sqlalchemy.exc.InvalidRequestError as err: return False, str(err) return True, '' # 動(dòng)態(tài)拼接sql語(yǔ)句, 創(chuàng)建表 def create_table(self, tablename, structs): fieldinfos = [] for struct in structs: defaultvalue = struct.get('default') if defaultvalue : defaultvalue = "'{0}'".format(defaultvalue) if type(defaultvalue) == 'str' else str(defaultvalue) fieldinfos.append('{0} {1} {2} {3} {4}'.format(struct['fieldname'], struct['type'], 'primary key' if struct.get('primary') else '', ('default' + defaultvalue) if defaultvalue else '', '' if struct.get('isnull') else 'not null')) sql = 'create table {0} ({1})'.format(tablename, ','.join(fieldinfos)) ret, err = self.execute(sql) if ret: self.__app.sync_record(tablename, 'sql_createtable', {}, sql) return ret, err # 動(dòng)態(tài)判斷表是否存在 def existtable(self, tablename): ret, err = self.GetRecordCount("user_all_table", "TABLE_NAME='" + tablename +"'") return ret>0, err def GetRecordCount(self, tablename, where= None): sql = 'select count(*) as num from {0} {1}'.format(tablename,('where' + where)) if where != None else '') recs, err = self.query(sql) if recs: for rec in recs: return rec['num'], '' return -1 , err # 查詢(xún)數(shù)據(jù)記錄 def query(self, sqlexpr): try: recs = self.conn.execute(sqlalchemy.text(sqlexpr) return recs, '' expect Exception as err: return None, str(err) expect sqlalchemy.exc.InvalidRequestError as err: return None, str(err)
關(guān)于怎么在Python中使用Flask動(dòng)態(tài)創(chuàng)建表就分享到這里了,希望以上內(nèi)容可以對(duì)大家有一定的幫助,可以學(xué)到更多知識(shí)。如果覺(jué)得文章不錯(cuò),可以把它分享出去讓更多的人看到。
免責(zé)聲明:本站發(fā)布的內(nèi)容(圖片、視頻和文字)以原創(chuàng)、轉(zhuǎn)載和分享為主,文章觀(guān)點(diǎn)不代表本網(wǎng)站立場(chǎng),如果涉及侵權(quán)請(qǐng)聯(lián)系站長(zhǎng)郵箱:is@yisu.com進(jìn)行舉報(bào),并提供相關(guān)證據(jù),一經(jīng)查實(shí),將立刻刪除涉嫌侵權(quán)內(nèi)容。