时间戳

首页 > 解决方案 > 如何在 Flask Python 中创建票证 ID（组合字符串并递增整数）

python - 如何在 Flask Python 中创建票证 ID（组合字符串并递增整数）

问题描述

我想使用 Python 烧瓶创建票务系统并存储在 SQlite 中，但是在存储票证 ID 时遇到了麻烦。我希望票证 ID 是（日期时间+“增量号”）。图片如下 预期视图

随同views.py文件

#define ticketid

now = datetime.now()
formatted_date = str(now.strftime('%Y%m%d'))
dated = formatted_date 
tiket = [dated+str(i) for i in range(5)]

# To submit and create the ticket

@main.route('/submit', methods=["GET", "POST"])
def ticket():
    if request.method == 'POST':
        customer = request.form['customer']
        pic = request.form['pic']
        date = request.form['date']
        time = request.form['time']
        category = request.form['category']
        description = request.form['description']
        ticketid = tiket
        Connection = sqlite3.connect('D:\\my_app\\db\\customer.db')
        cursor = Connection.cursor()
        query1 = "INSERT INTO customer (customer, pic, date, time, category, description, ticketid) VALUES ('{customer}','{pic}','{date}','{time}','{category}','{description}','{ticketid}')".format(customer = customer, 
        pic = pic, date = date, time = time, category = category, description = description , ticketid = ticketid)
        cursor.execute(query1)
        Connection.commit()
        return redirect('/')
    else:
        return render_template('createTicket.html')

当我在 html 中输入字段时，我收到一条错误消息

sqlite3.OperationalError：“202103100”附近：语法错误

非常感谢任何帮助！

标签： pythonhtmlsqliteflaskticket-system

解决方案

也许你应该试试这个。

 query1 = (f'INSERT INTO customer (customer, pic, date, time, category, description, ticketid) VALUES ("{customer}","{pic}","{date}","{time}","{category}","{description}","{ticketid}")')

推荐阅读