from flask import Flask, render_template, url_for, redirect, flash
from flask_sqlalchemy import SQLAlchemy
from forms import NewsCreator
from datetime import datetime
app = Flask(__name__)
app.config['SECRET_KEY'] = "kbfihlfnfar3r23rff32r2r2"
app.config['SQLALCHEMY_TRACK_MODIFICATIONS'] = False
app.config['SQLALCHEMY_DATABASE_URI'] = 'sqlite:///blog.db'
db = SQLAlchemy(app)
.......
if __name__ == '__main__':
    app.run(debug=True)

 from flask_wtf import FlaskForm
from wtforms import StringField, SubmitField, PasswordField, SelectField, TextAreaField, DateTimeField
from wtforms.validators import DataRequired, Email, Length
class NewsCreator(FlaskForm):
    title = StringField("Title", validators=[DataRequired(), Length(min=1, max=40)])
    intro = TextAreaField("Synopsys", validators=[DataRequired(), Length(min=1, max=150)])
    text = TextAreaField("Post", validators=[DataRequired(), Length(min=1, max=500)])
    date = DateTimeField("Date", validators=[DataRequired()])
    save_post = SubmitField("Save")

 class Article(db.Model):
    __tablename__ = 'article'
    id = db.Column(db.Integer, primary_key=True)
    title = db.Column(db.String(40), nullable=False)
    intro = db.Column(db.String(150), nullable=False)
    text = db.Column(db.Text, nullable=False)
    date = db.Column(db.DateTime, default=datetime.utcnow)
    def __repr__(self):
        return f'{self.title} {self.intro} {self.date}'

 @app.route('/create_article', methods=['GET', 'POST'])
def create_article():
    form = NewsCreator()
    if form.validate_on_submit():
        flash("Post created with success")
        return redirect(url_for('news'))
    return render_template('create_article.html', form=form)

 @app.route('/news')
def news():
    return render_template('news.html')

 {% block content %}
{% with messages = get_flashed_messages() %}
    {% if messages %}
        {% for message in messages %}
            <div>
                {{ message }}
            </div>
        {% endfor %}
    {% endif %}
{% endwith %}
{% endblock %}

 {% extends 'basic.html' %}
{% block title %} Create Article Form {% endblock %}
{% block content %}
<div>
    <h1>Add article</h1>
    <form action="http://127.0.0.1:5000/create_article" method="POST">
        {{ form.hidden_tag() }}
        {{ form.title.label }} {{ form.title() }}
        {{ form.intro.label }} {{ form.intro() }}
        {{ form.text.label }} {{ form.text() }}
        {{ form.date.label }} {{ form.date() }}
        {{ form.save_post() }}
    </form>
</div>
{% endblock %}

#!/bin/bash

# Run local server localhost:5000

export FLASK_APP=app.py
export FLASK_DEBUG=1
flask-3 run

  
from flask import Flask, request, flash, url_for, redirect, render_template
from flask_sqlalchemy import SQLAlchemy
 
app = Flask(__name__)
app.config['SQLALCHEMY_DATABASE_URI'] = 'sqlite:///students.sqlite3'
app.config['SECRET_KEY'] = 'random string'
 
db = SQLAlchemy(app)
 
class students(db.Model):
   id = db.Column('student_id', db.Integer, primary_key=True)
   name = db.Column(db.String(100))
   city = db.Column(db.String(50))
   addr = db.Column(db.String(200)) 
   pin = db.Column(db.String(10))
   def __init__(self, name, city, addr,pin):
       self.name = name
       self.city = city
       self.addr = addr
       self.pin = pin
 
@app.route('/')
def show_all():
   return render_template('show_all.html', students=students.query.all())
 
@app.route('/new', methods=['GET', 'POST'])
def new():
   if request.method == 'POST':
      if (not request.form['name']
          or not request.form['city']
          or not request.form['addr']):
         flash('Please enter all the fields', 'error')
      else:
         student = students(request.form['name'], request.form['city'],
             request.form['addr'], request.form['pin'])
         db.session.add(student)
         db.session.commit()
         flash('Record was successfully added')
         return redirect(url_for('show_all'))
   return render_template('new.html')
 
if __name__ == '__main__':
    db.create_all()
    app.run(debug=True)

 from flask import Flask, redirect, render_template, url_for
from flask_mysqldb import MySQL
from flask_wtf import FlaskForm
from wtforms import StringField, SubmitField
from wtforms.validators import DataRequired
app = Flask(__name__)
app.config['SECRET_KEY'] = '1234567989'
app.config['MYSQL_USER'] = 'root'
app.config['MYSQL_PASSWORD'] = 'password'
app.config['MYSQL_HOST'] = 'localhost'
app.config['MYSQL_DB'] = 'nametest'
app.config['MYSQL_CURSORCLASS'] = 'DictCursor'
mysql = MySQL(app)
class NameForm(FlaskForm):
    name = StringField('Your name', validators=[DataRequired()])
    submit = SubmitField('Say your Name')
@app.route('/')
def index():
    return render_template('index.html')
@app.route('/say_name', methods=['GET', 'POST'])
def say():
    form = NameForm()
    if form.validate_on_submit():
        name = form.name.data()
        curs = mysql.connection.cursor()
        curs.execute(f"INSERT INTO tbl_names VALUES('NULL, {name}')")
        mysql.connection.commit()
        curs.close()
        print("Saved " + name)
        return redirect(url_for('hello'))
    return render_template('say_name.html', form=form)
@app.route('/hello')
def hello():
    curs = mysql.connection.cursor()
    curs.execute(f'SELECT * FROM tbl_names')
    data = curs.fetchone()
    print(data)
    curs.close()
    return render_template('hello.html', data=data)
if __name__ == '__main__':
    app.run(debug=True)

 {% extends 'basic.html' %}
{% block title %} Say Name Form {% endblock %}
{% block content %}
<form action="http://127.0.0.1:5000/say_name" method="POST">
  {{ form.name.label }} {{ form.name() }}
  {{ form.submit() }}
</form>
{% endblock %}

 {% extends 'basic.html' %}
{% block title %} Hello Page {% endblock %}
{% block content %}
    <h1>Hello, {{ data }}</h1>
{% endblock %}