def get(self):
learn = db.Table('Learn',
db.metadata,
autoload=True,
autoload_with=db.engine)
study_data = db.session.query(learn).all()
data = list()
for content in study_data:
json_data = {
"id": content.Sno,
"grade": content.Grade,
"subject": content.Subject,
"topic": content.Topic
}
data.append(json_data)
# print(type(author.__dict__))
return {"content": data}, 200
from app.database.sqlalchemy_extension import db
application_moderator = db.Table(
'application_moderator',
db.Column('application_id', db.Integer, db.ForeignKey('application.id')),
db.Column('moderator_id', db.Integer, db.ForeignKey('user.id')))
from app.database.sqlalchemy_extension import db
section_video = db.Table(
"section_video",
db.Column("video_id", db.Integer, db.ForeignKey("videos.id")),
db.Column("section_id", db.Integer, db.ForeignKey("section.id")),
)
from app.database.sqlalchemy_extension import db
category_section = db.Table('category_section',
db.Column('category_id', db.Integer, db.ForeignKey('category.id')),
db.Column('section_id', db.Integer, db.ForeignKey('section.id'))
)
from app.database.sqlalchemy_extension import db
section_video = db.Table('section_video',
db.Column('video_id', db.Integer, db.ForeignKey('videos.id')),
db.Column('section_id', db.Integer, db.ForeignKey('section.id'))
)
from app.database.sqlalchemy_extension import db
category_section = db.Table(
"category_section",
db.Column("category_id", db.Integer, db.ForeignKey("category.id")),
db.Column("section_id", db.Integer, db.ForeignKey("section.id")),
)
from app.database.sqlalchemy_extension import db
video_author = db.Table('video_author',
db.Column('author_id', db.Integer, db.ForeignKey('author.id')),
db.Column('video_id', db.Integer, db.ForeignKey('videos.id'))
)
from app.database.sqlalchemy_extension import db
video_author = db.Table(
"video_author",
db.Column("author_id", db.Integer, db.ForeignKey("author.id")),
db.Column("video_id", db.Integer, db.ForeignKey("videos.id")),
)