Building a CRUD application with Flask and SQLAlchemy
Please execute the following commands:
sudo apt-get install sqlitebrowser git clone https://github.com/macagua/flask-crud-app.git virtualenv --python=/usr/bin/python3 venv source ./venv/bin/activate pip3 install -r requirements.txt
Please execute the following command:
python3 bookmanager.py
db.session.commit():
INSERT INTO book (title) VALUES ('The Hobbie');
INSERT INTO book (title) VALUES ('The Lord of Rings');
INSERT INTO book (title) VALUES ('The Silmarillion');
INSERT INTO book (title) VALUES ('The Children of Húrin');
COMMIT;
UPDATE book
SET title='The Lord of the Rings'
WHERE title = 'The Lord of Rings';
COMMIT;
Book.query.all():
SELECT * FROM book;
Book.query.filter_by(title=oldtitle).first():
SELECT book.title FROM book WHERE book.title = 'The Hobbie' LIMIT 1 OFFSET 0;
db.session.delete(book):
DELETE FROM book WHERE book.title = 'The Children of Húrin';