时间戳

首页 > 解决方案 > 烧瓶查询日期时间和整数值

python - 烧瓶查询日期时间和整数值

问题描述

我应该如何查询整数值和日期时间对象？我想在提交帖子时插入帖子数据。我试过这个，但它不起作用

if request.method == 'POST':
        data = request.get_json()
        print(data)
        title = data['title']
        content = data['content']
        username = data['username']
        cur = mysql.connection.cursor()
        cur.execute(
            "SELECT id FROM users WHERE username = '{0}' LIMIT 1".format(username))
        authorID = cur.fetchone()['id']
        print(datetime.now())
        cur.execute("INSERT INTO posts(authorID, username, title, content, createdAt) VALUES ({}, {}, {},{},{})".format(
            authorID, username, title, content, datetime.now()))

标签： pythonmysqlflask

解决方案

推荐阅读