snippets

# models.py
from rest.api import db

statements = db.Table('statements',
                      db.Column('statement_id', db.Integer, db.ForeignKey('statement.id')),
                      db.Column('student_id', db.Integer, db.ForeignKey('student.id'))
                      )


class Statement(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    date = db.Column(db.DateTime)
    students = db.relationship('Student', secondary=statements, backref=db.backref('statements', lazy='dynamic'))
    subject = db.Column(db.String(255), nullable=False)


class Student(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    name = db.Column(db.String(255), nullable=False)
    marks = db.relationship('Student_mark', backref='student', lazy=True)
    group_id = db.Column(db.Integer, db.ForeignKey('group.id'))


class Student_mark(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    subject = db.Column(db.String(255), nullable=False)
    mark = db.Column(db.Integer, nullable=False)
    student_id = db.Column(db.Integer, db.ForeignKey('student.id'))


# api.py
from flask_restful import Api
from .service import Test
from flask import Flask
from settings import Config
from flask_sqlalchemy import SQLAlchemy
from flask_migrate import Migrate

app = Flask(__name__)
app.config.from_object(Config)
db = SQLAlchemy(app)

api = Api(app)
migrate = Migrate(app, db)

api.add_resource(Test, '/test/')

#service.py
from flask_restful import Resource


class Test(Resource):
    def get(self):
        return '{id: 1}'



# settings.py
class Config:
    DEBUG = True
    SQLALCHEMY_DATABASE_URI = 'mysql+mysqlconnector://root:012810@localhost/epam_task'
    SQLALCHEMY_TRACK_MODIFICATIONS = False
    SERVER_NAME = '127.0.0.1:5050'