# 配置
./config/config.py
~~~
import os
import socket
from sqlalchemy import create_engine
from sqlalchemy.orm import sessionmaker
__all__ = ('SYSCONF', 'dBSession')
def get_ip():
"""獲取本機的IP"""
s = socket.socket(socket.AF_INET, socket.SOCK_DGRAM)
try:
s.connect(('8.8.8.8', 80))
ip = s.getsockname()[0]
finally:
s.close()
return ip
SYSCONF = {
'app': {
'root_path': (os.path.dirname(os.path.dirname(os.path.abspath(__file__)))).replace('\\', '/'), # 整個項目的根路徑
'app_path': (os.getcwd()+'/application').replace('\\', '/'), # APPLICATION的根路徑
'app_host': get_ip(), # 后臺接口的IP地址
'app_port': 8082, # 后臺接口訪問的端口
},
'databases': {
'host': '127.0.0.1', # 服務器地址
'port': 3306, # 端口
'db': 'appserver', # 數據庫名稱
'username': 'root', # 用戶名
'password': '123', # 密碼
'prefix': 'yp_', # 表前綴
'charset': 'utf8', # 編碼
}
}
# 創建數據庫及連接
db_url = "mysql+pymysql://{username}:{password}@{host}:{port}/{db}?charset={charset}".\
format(username=SYSCONF.get('databases').get('username'), password=SYSCONF.get('databases').get('password'), host=SYSCONF.get('databases').get('host'), port=SYSCONF.get('databases').get('port'), db=SYSCONF.get('databases').get('db'), charset=SYSCONF.get('databases').get('charset'))
engine = create_engine(db_url)
# 創建DBSession類型:
DBSession = sessionmaker(bind=engine)
dBSession = DBSession()
~~~
./config/route.py
~~~
from config import config
from application.index import route as indexRoute
def reg_routes(app):
# 后臺路由
indexRoute.reg_routes(app)
~~~