app.py

from flask import Flask, render_template, request,redirect
from flask_sqlalchemy import SQLAlchemy
from datetime import datetime
import time
app = Flask(__name__)


app.config['SQLALCHEMY_DATABASE_URI'] = "sqlite:///todo.db"
app.config['SQLALCHEMY_TRACK_MOFIFICATIONS'] = False




db = SQLAlchemy(app)


class Todo(db.Model):
    sno = db.Column(db.Integer(), primary_key= True)
    title = db.Column(db.String(200), nullable= False)
    desc = db.Column(db.String(500), nullable= False)
    date = db.Column(db.DateTime(), default=datetime.utcnow)
    
    def __repr__(self) -> str:
        return f"{self.sno} - {self.title}"



@app.route('/', methods=['GET', 'POST'])
def home():
    if request.method == 'POST':
        title = request.form['title']
        desc = request.form['desc']
        todo = Todo(title= title, desc= desc)
        db.session.add(todo)
        db.session.commit()
    alltodo = Todo.query.all()
    return render_template("index.html", alltodo=alltodo)

@app.route('/delete/<int:sno>')
def delete(sno):
    Todo.query.filter(Todo.sno == sno).delete()
    # db.session.delete(Todo.query.filter(Todo.sno == sno))
    db.session.commit()
    return redirect('/')

# @app.route('/update/<int:sno>', methods=['GET', 'POST'])
# def update(sno):
#     if request.method == 'POST':
#         title = request.form['title']
#         desc = request.form['desc']
#         todo = Todo.query.filter_by(sno=sno).first()
#         todo.title = title  
#         todo.desc = desc
#         db.session.add(todo)
#         db.session.commit()
#         return redirect('/')    
#     todo = Todo.query.filter_by(sno=sno).first()
#     return render_template('update.html', todo=todo)


if __name__ == '__main__':
    app.run(debug=True)