charlenopires · January 6, 2020 03:28 · charlenopires · Jan 6, 2020
diff --git a/app.py b/app.py
 # -*- coding:utf-8 -*-

 from flask import Flask, render_template, url_for, request, redirect
 from flask_sqlalchemy import SQLAlchemy
 from datetime import datetime

 app = Flask(__name__)
 app.config['SQLALCHEMY_DATABASE_URI'] = 'sqlite:///crud.db'

 db = SQLAlchemy(app)

 class Clientes(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    nome = db.Column(db.String(250), nullable=False)
    endereco = db.Column(db.String(250), nullable=False)
    telefone = db.Column(db.String(250), nullable=True)
    data_de_cadastro = db.Column(db.DateTime, default=datetime.utcnow)

    def __repr__(self):
        return '<Cliente %r>' % self.id
    

 @app.route('/', methods=['POST', 'GET'])
 def index():
    if request.method == 'POST':
        nome_do_cliente = request.form['nome']
        endereco_do_cliente = request.form['end']
        telefone_do_cliente = request.form['fone']
        novo_cliente = Clientes(nome = nome_do_cliente, endereco = endereco_do_cliente, telefone = telefone_do_cliente)

        try:
            db.session.add(novo_cliente)
            db.session.commit()
            return redirect('/')
        except:
            return 'Houve um erro ao adicionar cliente no banco de dados!'
    else:
        clientes = Clientes.query.order_by(Clientes.data_de_cadastro).all()
        return render_template('index.html', clientes=clientes)

 if __name__ == "__main__":
    app.run(debug=True)
diff --git a/base.html b/base.html
 <!DOCTYPE html>
 <html>
 <head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <meta http-equiv="X-UA-Compatible" content="ie=edge">
    <link rel="stylesheet" href="{{ url_for('static', filename='css/main.css')}}">
    <title>{% block titulo %}{% endblock %}</title>
 </head>
 <body>
    {% block body %}{% endblock %}
 </body>
 </html>
diff --git a/comandos.txt b/comandos.txt
 from app import db

 db.create_all()
diff --git a/index.html b/index.html
 {% extends 'base.html' %}

 {% block titulo %}
    CRUD -  Home
 {% endblock %}

 {% block body %}
    <div id="conteudo">
        <h3>Clientes:</h3>
        <table>
            <tr>
                <th>Nome:</th>
                <th>Telefone:</th>
                <th>Ações</th>
            </tr>
            {% for cliente in clientes %}
            <tr>
                <td>{{cliente.nome}}</td>
                <td>{{cliente.telefone}}</td>
                <td>
                    <a href="">Apagar</a>
                    <br>
                    <a href="">Editar</a>
                </td>
            </tr>
            {% endfor %}
        </table>

        <form action="/" method="POST">
            <label for="nome">Nome:</label><br>
            <input type="text" name="nome" id="nome"><br>
            <label for="end">Endereço:</label><br>
            <input type="text" name="end" id="end"><br>
            <label for="fone">Telefone:</label><br>
            <input type="text" name="fone" id="fone"><br>
            <input type="submit" value="Adicionar">
        </form>
    </div>
 {% endblock %}
diff --git a/main.css b/main.css
 h1, h3 {color: red}
	# -- coding:utf-8 --

	from flask import Flask, render_template, url_for, request, redirect
	from flask_sqlalchemy import SQLAlchemy
	from datetime import datetime

	app = Flask(__name__)
	app.config['SQLALCHEMY_DATABASE_URI'] = 'sqlite:///crud.db'

	db = SQLAlchemy(app)

	class Clientes(db.Model):
	id = db.Column(db.Integer, primary_key=True)
	nome = db.Column(db.String(250), nullable=False)
	endereco = db.Column(db.String(250), nullable=False)
	telefone = db.Column(db.String(250), nullable=True)
	data_de_cadastro = db.Column(db.DateTime, default=datetime.utcnow)

	def __repr__(self):
	return '<Cliente %r>' % self.id


	@app.route('/', methods=['POST', 'GET'])
	def index():
	if request.method == 'POST':
	nome_do_cliente = request.form['nome']
	endereco_do_cliente = request.form['end']
	telefone_do_cliente = request.form['fone']
	novo_cliente = Clientes(nome = nome_do_cliente, endereco = endereco_do_cliente, telefone = telefone_do_cliente)

	try:
	db.session.add(novo_cliente)
	db.session.commit()
	return redirect('/')
	except:
	return 'Houve um erro ao adicionar cliente no banco de dados!'
	else:
	clientes = Clientes.query.order_by(Clientes.data_de_cadastro).all()
	return render_template('index.html', clientes=clientes)

	if __name__ == "__main__":
	app.run(debug=True)
	<!DOCTYPE html>
	<html>
	<head>
	<meta charset="UTF-8">
	<meta name="viewport" content="width=device-width, initial-scale=1.0">
	<meta http-equiv="X-UA-Compatible" content="ie=edge">
	<link rel="stylesheet" href="{{ url_for('static', filename='css/main.css')}}">
	<title>{% block titulo %}{% endblock %}</title>
	</head>
	<body>
	{% block body %}{% endblock %}
	</body>
	</html>
	{% extends 'base.html' %}

	{% block titulo %}
	CRUD - Home
	{% endblock %}

	{% block body %}
	<div id="conteudo">
	<h3>Clientes:</h3>
	<table>
	<tr>
	<th>Nome:</th>
	<th>Telefone:</th>
	<th>Ações</th>
	</tr>
	{% for cliente in clientes %}
	<tr>
	<td>{{cliente.nome}}</td>
	<td>{{cliente.telefone}}</td>
	<td>
	<a href="">Apagar</a>
	<br>
	<a href="">Editar</a>
	</td>
	</tr>
	{% endfor %}
	</table>

	<form action="/" method="POST">
	<label for="nome">Nome:</label><br>
	<input type="text" name="nome" id="nome"><br>
	<label for="end">Endereço:</label><br>
	<input type="text" name="end" id="end"><br>
	<label for="fone">Telefone:</label><br>
	<input type="text" name="fone" id="fone"><br>
	<input type="submit" value="Adicionar">
	</form>
	</div>
	{% endblock %}