2023-07-18 Meeting 5

⚠️ Push biežāk GIT, lai nav tā, ka pēdējā brīdī neko neredzu

object relational mapping

https://docs.sqlalchemy.org/en/20/orm/quickstart.html

xxxxxxxxxx
24
1
from flask import Flask
2
from flask_sqlalchemy import SQLAlchemy
3

4
app = Flask(__name__)
5
app.config['SQLALCHEMY_DATABASE_URI'] = 'sqlite:///mydatabase.db'
6
db = SQLAlchemy(app)
7

8
class User(db.Model):
9
    id = db.Column(db.Integer, primary_key=True)
10
    username = db.Column(db.String(80), unique=True, nullable=False)
11
    email = db.Column(db.String(120), unique=True, nullable=False)
12

13
    def __repr__(self):
14
        return '<User %r>' % self.username
15

16
if __name__ == '__main__':
17
    # Create the database tables
18
    db.create_all()
19

20
    # Perform database operations
21
    # ...
22

23
    # Run the Flask application
24
    app.run()

Uztaisīt bez flask_login

Pabeigt Flask uzdevumus

Python Flask - HTML - CSS - Tutorial 2

Video: https://youtube.com/live/dp9kGvgHuOQ?feature=share

Jamboard: https://jamboard.google.com/d/1qmOj3J4hwlCL4QlzuFIsCeYiCYhB-PnZQBY0haVnvlo/edit?usp=sharing

Template: http://share.yellowrobot.xyz/1629812987-programming-tutorials/session_2.zip

Python Flask - HTML - CSS - Tutorial 3

Video: https://youtu.be/6LV6df_JWbs

Jamboard: https://jamboard.google.com/d/1ZrLZ2_WvgmvVBRsponJ8BeBckXm3alElUV3IrIC1Vv4/edit?usp=sharing

Template: http://share.yellowrobot.xyz/1629812987-programming-tutorials/session_3.zip

Tasks:

1. Post delete function using HTML form, ControllerPosts and ControllerDatabase

2. Ability to save url_slug and open URL using slug instead of post_id, for example http://localhost:8000/posts/my_post_title

3. Submit whole project as ZIP

Python Flask - HTML - CSS - Tutorial 4

Video: https://youtu.be/OSvtOrJ7bHw

Jamboard: https://jamboard.google.com/d/1S3oYruAJmrakj7fn0xbGQ_xJfI1u_pY289MjDQGCgNs/edit?usp=sharing

Template: http://share.yellowrobot.xyz/1629812987-programming-tutorials/session_4.zip

Tasks:

1. Implement so that after deletion and editing user is redirected to home page and sees message "post deleted" or "post updated"

2. Implement so that in home page you see list of all recorded posts (title and date of editing) and link to open editing form

3. Implement editing form (reuse new post form) when opening existing post fill fields with existing information

4. Submit whole project as ZIP