def save(self):
"""Save class to db if no entries or update"""
query.insert('portfolios',
name=self.name,
broker=self.broker,
margin=self.margin,
holder_id=self.holder_id)
def movie_add():
if request.method == "POST":
record = (str(uuid.uuid4()), request.form['title'],
request.form['rating'], request.form['director'])
query.insert('movies', record)
return redirect(url_for('movie_list'))
return render_template("addmovie.html")
def user_add():
if request.method == "POST":
record = (request.form['id'], request.form['name'],
datetime.datetime.now().strftime("%Y-%m-%d %H:%M"),
request.form['pass'])
query.insert('users', record)
return redirect(url_for('user_list'))
return render_template("addusers.html")
def add_habit(user_id: int, habit: str):
table = 'habits'
try:
query.insert(table, ['user_id', 'habit'], [user_id, habit])
return True
except Error as e:
print(e, f'Ошибка добавления в базу')
return False
def add_user(user_id: int):
table = 'users'
try:
query.insert(table, ['id'], [user_id])
return True
except Error as e:
print(f'Пользователь {user_id} уже зарегистрирован')
return False
def sign_up():
logout()
if request.method == "POST":
signup = (request.form['uname'], request.form['nameuser'], datetime.datetime.now().strftime("%Y-%m-%d %H:%M"), request.form['pass'])
query.insert("users", signup)
return redirect(url_for("home"))
if request.method == "GET":
redirect(url_for("home"))
return render_template("signup.html")
def add_transaction(self, amount, price, commission):
query.insert('transactions',
ticker=self.ticker,
amount=amount,
price=price,
commission=commission,
holder_id=self.holder_id,
portfolio_id=self.portfolio_id,
share_id=self.id,
date=datetime.datetime.utcnow())
def save(self):
"""Save class to db if no entries or update"""
query.insert('shares',
ticker=self.ticker,
amount=self.amount,
price=self.price,
stock=self.stock,
currency=self.currency,
holder_id=self.holder_id,
portfolio_id=self.portfolio_id,
commission=self.commission)
def easy():
param = request.get_json()
print(param)
print(type(param))
print(type(param['input']))
result = {'status': '', 'data': []}
if param['type'] == 1:
easy_pattern_A = re.compile(r'^[a-zA-Z]+$')
easy_pattern_B = re.compile(r'^\*[a-zA-Z]+$')
easy_pattern_C = re.compile(r'^[a-zA-Z]+\*[a-zA-Z]+$')
easy_pattern_D = re.compile(r'^[a-zA-Z]+\*$')
if param == '' or param is None:
result['status'] = "输入格式有误，请重新输入"
elif re.match(easy_pattern_A, param['input']) or re.match(
easy_pattern_B, param['input']) or re.match(
easy_pattern_C, param['input']) or re.match(
easy_pattern_D, param['input']):
result = insert(p=param, r=result)
else:
result['status'] = "输入格式有误，请重新输入"
elif param['type'] == 2:
pattern = param['input']
# unsup_pattern_A = re.compile(r'\*\?')
# unsup_pattern_B = re.compile(r'\+\?')
#
# if re.match(pattern, unsup_pattern_A) or re.match(pattern, unsup_pattern_B):
# pattern = pattern.replace('*?','{0,}').replace('+?','+')
try:
obj = db.db_session.query(db.Words).filter(
db.Words.word.op('regexp')(pattern)).all()
if len(obj) == 0:
result['status'] = '未查询到匹配该正则词汇'
else:
result['status'] = 'Succeed'
for x in obj:
word = {
'word': x.word,
'unit': x.unit,
'translation': x.translation.split(" && ")[:-1]
}
result['data'].append(word)
except Exception as e:
print(e)
result['status'] = '查询失败'
else:
result['status'] = "输入格式有误，请重新输入"
return json.dumps(result)
def addUser(self, fn, ln, lg, r, tel):
pw = "1234"
query = q.insert(fn, ln, lg, pw, r, tel)
self.cur.execute(query)
def start_bot(user):
"""Creates new entry in holders table."""
try:
query.insert('holders', id=user.id, name=user.username)
except sqlite3.IntegrityError:
pass