How can I use Flask-RESTful with SQLAlchemy?

How can I use Flask-RESTful with SQLAlchemy?

You can integrate Flask-RESTful with SQLAlchemy by creating a Flask app, defining your models, and setting up resources.

Can you show me a simple example?

Sure! First, install Flask-RESTful and SQLAlchemy. Then, define a model like this:

from flask_sqlalchemy import SQLAlchemy

db = SQLAlchemy()

class User(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    name = db.Column(db.String(80), nullable=False)

How do I create a resource for this model?

You can create a resource by subclassing Resource from Flask-RESTful. Here's an example:

from flask_restful import Resource

class UserResource(Resource):
    def get(self, user_id):
        user = User.query.get(user_id)
        return {'name': user.name}

What about handling POST requests?

For POST requests, you can add a post method to your resource to create a new user. Here's how:

def post(self):
    new_user = User(name=request.json['name'])
    db.session.add(new_user)
    db.session.commit()
    return {'id': new_user.id}, 201