Below is an example of what I'm trying to achieve but I keep getting an error. sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) no such table: object
basically i'm trying to PUT a data that has oid, and size. and then being able to GET it.
from flask import Flask, request
from flask_sqlalchemy import SQLAlchemy
app = Flask(__name__)
app.config['SQLALCHEMY_DATABASE_URI'] = 'sqlite:///db.sqlite'
db = SQLAlchemy(app)
class Object(db.Model):
oid = db.Column(db.Integer, primary_key=True)
size = db.Column(db.Integer)
def __repr__(self):
return '<Object %r, Size: %r>' % self.oid % self.size
@app.route('/')
def index():
return 'DSAP_2022'
@app.route('/data/<repository>/<oid>', methods=['GET'])
def getObject(repository, oid):
obj = Object.query.filter_by(oid=oid).first()
if obj is None:
return 'Object not found', 404
return 'Object %r, Size: %r' % obj.oid % obj.size
@app.route('/data/<repository>', methods=['PUT'])
def putObject():
obj = Object(oid=request.json['oid'], size=request.json['size'])
db.session.add(obj)
db.session.commit()
return 'OK'
if __name__ == '__main__':
app.run(debug=True)
what am I doing wrong here?
