flask-application

Database

How to create db.sqlite file

sqlite3 db.sqlite < schema.sql

REST API

Select example

• movies - Get all movies
• users - Get all users
• seans - Get all seans
• groups - Get all groups
• participants - Get all participants

Insert example

• Add new group

curl -X POST -H "Content-Type: application/json" -d '{ "seansId": "2" }' http://localhost:5000/groups

• Add new person to group

curl -X POST -H "Content-Type: application/json" -d '{ "groupsId": "1", "usersId": "3" }' http://localhost:5000/participants

Update example

curl -X POST -H "Content-Type: application/json" -d '{ "groupsId": "1", "usersId": "1", "active": "0" }' http://localhost:5000/deleteParticipant