def create_connection():
return pymysql.connect(host=db_credentials.get("host"),
user=db_credentials.get("username"),
password=db_credentials.get("password"),
db=db_credentials.get("db"),
charset='utf8mb4',
cursorclass=pymysql.cursors.DictCursor)
def load_chains():
chains = {}
index = db.get('index')
for entry in index:
words = db.get(entry)
pair = tuple(entry.split())
chains[pair] = words
return chains
def load_chains():
chains = {}
index = db.get('index')
for entry in index:
words = db.get(entry)
pair = tuple(entry.split())
chains[pair] = words
return chains
def get_connection_string():
if db.get('type') == 'mysql':
settings = db.get('mysql')
host = settings.get('host')
user = settings.get('user')
db_name = settings.get('db_name')
password = settings.get('pass')
return "mysql://%s:%s@%s/%s?charset=utf8" % (user, password, host, db_name)
elif db.get('type') == 'sqlite':
return "sqlite:///memory"
def run(web):
post_id = web.sub_path[1:]
if not post_id: return error(404, "Not Found")
web.post = db.get('post', by_id=post_id)
if web.post:
return render('show_post.html', web)
else:
return error(404, "Not Found")
def run(web):
post_id = web.sub_path[1:]
if not post_id: return error(404, "Not Found")
web.post = db.get('post', by_id=post_id)
if web.post:
return render('show_post.html', web)
else:
return error(404, "Not Found")
def get_user(user_id):
"""根据id获取用户"""
sql = "select * from user where id = %s;"
user = db.get(sql, user_id)
return user
def checkout_login(phone, password):
"""先只支持手机号码登录吧"""
sql = "select id from user where phone = %s and password = %s;"
user_id = db.get(sql, phone, password)
return user_id["id"] if user_id else 0
def getEngr101():
selfUrl = "asbarber.us/engr101"
url = db.get('engr101').get('url')
return flask.render_template("engr101/engr101.html",
url=url,
selfUrl=selfUrl)
from sqlalchemy import *
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy.orm import sessionmaker
from sqlalchemy.pool import NullPool
import datetime
from config import db
DeclarativeBase = declarative_base()
db_url = "mysql+pymysql://%s:%s@%s/%s?charset=UTF8MB4" % (
db.get('username'), db.get('password'), db.get('host'), db.get('db'))
def db_connect():
'''Create connection to database'''
return create_engine(db_url, encoding='utf-8', poolclass=NullPool)
def create_db_session(engine):
'''Create session with database'''
Session = sessionmaker(bind=engine, autoflush=False)
session = Session()
return session
Base = declarative_base()
metadata = Base.metadata
class powerData(Base):
def get_engine():
return create_engine(get_connection_string(), echo=db.get('echo'))
def get_user(user_id):
"""根据id获取用户"""
sql = "select * from user where id = %s;"
user = db.get(sql, user_id)
return user
def checkout_login(phone, password):
"""先只支持手机号码登录吧"""
sql = "select id from user where phone = %s and password = %s;"
user_id = db.get(sql, phone, password)
return user_id["id"] if user_id else 0
