I currently have a Flask route that reveives file content via POST, and that stores it on the file system, ex:
@app.route('/upload', methods=['POST'])
def upload_file():def allowed_file(f):return Truefile = request.files['file']if file and allowed_file(file.filename):filename = secure_filename(file.filename)file.save(os.path.join(upload_dir(), filename))return "", 200
I would like to store it in a BYTEA column in postgres, I am not sure how to bind the "data" argument to the insert statement
db.session.execute("""INSERT INTO uploaded_file(id, name, type, data) VALUES (:id, :name, :type, %(:data)s)""",{"id": str(id),"name": file.filename,"type": "...","data": ???}