Untitled
unknown
python
a year ago
1.1 kB
2
Indexable
Never
from flask import Flask from flask_sqlalchemy import SQLAlchemy db = SQLAlchemy() app = Flask(__name__) app.config['SQLALCHEMY_DATABASE_URI'] = 'sqlite:///database.db' db.init_app(app) class Author(db.Model): id = db.Column(db.Integer, primary_key=True) name = db.Column(db.String(50)) books = db.relationship('Book', backref='author', lazy=True) def __init__(self, name): self.name = name class Book(db.Model): id = db.Column(db.Integer, primary_key=True) title = db.Column(db.String(50)) author_id = db.Column(db.Integer, db.ForeignKey('author.id'), nullable=False) def __init__(self, title, author): self.title = title self.author = author with app.app_context(): db.create_all() # a1 = Author('Лев Николаевич Толстой') # a2 = Author(u'Александр Сергеевич Пушкин') a1 = Author.query.filter_by(name='Лев Николаевич Толстой').first() for book in a1.books: print(book.title) app.run()