Tutorial Flask - Construindo API REST com Arquitetura SOA e SQLite

Prof Dr Rodrigo Plotze Construindo uma API Rest com Flask ARQUITETURA ORIENTADA A SERVIÇO SOA 2 Arquitetura Python Linguagem de programação de alto nível interpretada de script imperativa orientada a objetos funcional de tipagem dinâmica e forte download Visual Studio Code 1 File Open Folder criar uma pasta clientesapi para armazenar o projeto 2 Abrir o Terminal e instalar o pipenv 1 Criar um novo ambiente virtual para armazenar os pacotes do projeto pip install pipenv pipenv install ou python m pipenv install Arquitetura Flask Flask é um pequeno framework web escrito em Python e baseado na biblioteca WSGI Werkzeug e na biblioteca de Jinja2 Pacotes Básicos flask base do framework flaskcors extensão para implementar o suporte a CORS CORS é um mecanismo que permite que recursos restritos em uma página da web sejam recuperados por outro domínio fora do domínio ao qual pertence o recurso que será recuperado Arquitetura Pipfile Especificar as dependências do projeto Executar os comandos source url httpspypiorgsimple verifyssl true name pypi packages flask flaskcors dbsqlite3 gunicorn devpackages requires pythonversion 39 pipenv shell pipenv install SERVICE Service A arquitetura da API será implementada utilizando Blueprints Service FLASKAPI api clienteservicepy database criartabelapy datadb gitattributes apppy Pipfile Pipfilelock Procfile Service Banco de Dados SQLite import sqlite3 try conn sqlite3connectdatabasedatadb connexecuteDROP TABLE IF EXISTS tbcliente connexecute CREATE TABLE tbcliente id INTEGER PRIMARY KEY NOT NULL nome TEXT NOT NULL email TEXT NOT NULL telefone TEXT NOT NULL connexecute INSERT INTO tbcliente idnomeemailtelefone VALUES 1Jessamine Mccormickaeneanmassahotmailcom17174238711 2Whoopi Morrowmaurisicloudcom12839837455 3Jackson Warnerdisaolcouk486 5700422 4Lev Whitleyfermentumveloutlooknet17637540116 5Bryar Jamesdoloroutlookcouk12233486102 6Jescie Cruzutdolordapibusicloudedu13732232728 7Lacey Maddenpretiumaliquetyahooca13773597657 8Bethany Bonneracturpisgooglecom14133224874 9Sawyer Garciaodiovelesthotmailcom551 4954664 10Regina Gilmoreantevivamusnonoutlookorg590 2624619 conncommit printOperacao realizada com sucesso except printERRO finally connclose Service apiclienteservicepy from flask import Flask Blueprint request jsonify import sqlite3 cliente Blueprintcliente name def conectar return sqlite3connectdatabasedatadb Service apiclienteservicepy clienteroute methodsGET def getall clientes try conn conectar connrowfactory sqlite3Row cur conncursor curexecuteSELECT FROM tbcliente for i in curfetchall cliente clienteid iid clientenome inome clienteemail iemail clientetelefone itelefone clientesappendcliente except Exception as e printe clientes return jsonifyclientes Service apiclienteservicepy clienterouteid methodsGET def getbyidid cliente try conn conectar connrowfactory sqlite3Row cur conncursor curexecuteSELECT FROM tbcliente where idid row curfetchone clienteid rowid clientenome rownome clienteemail rowemail clientetelefone rowtelefone except Exception as e printstre cliente return jsonifycliente Service apiclienteservicepy clienteroute methods POST def add cliente requestgetjson try conn conectar cur conncursor curexecuteINSERT INTO tbcliente nome email telefone VALUES clientenome clienteemail clientetelefone conncommit resposta jsonify mensagemOperacao realizada com sucesso id curlastrowid except Exception as e connrollback resposta jsonifyerro stre finally connclose return resposta Service apiclienteservicepy clienteroute methods PUT def update cliente requestgetjson try conn conectar cur conncursor curexecuteUPDATE tbcliente SET nome email telefone WHERE id clientenome clienteemail clientetelefone clienteid conncommit resposta jsonifymensagemOperacao realizada com sucesso except Exception as e connrollback resposta jsonifyerro stre finally connclose return resposta Service apiclienteservicepy clienterouteid methods DELETE def deleteid printid try conn conectar cur conncursor curexecuteDELETE FROM tbcliente WHERE idid conncommit resposta jsonifymensagemRegistro apagado com sucesso except Exception as e connrollback resposta jsonifyerro stre finally connclose return resposta Service apppy from flask import Flask from flaskcors import CORS from apiclienteservice import cliente app Flaskname CORSapp resourcesr origins appregisterblueprintcliente urlprefixapicliente approute def hello return API Controle de Clientes if name main apprunhost0000 port5000 DEPLOY NO HEROKU Seleccionar CWindowsSystem32cmdexe EDEVclientesapigit init Initialized empty Git repository in EDEVclientesapigit EDEVclientesapigit init Heroku httpsdevcenterherokucomarticlesherokucli Heroku python m pipenv shell pipenv install echo web gunicorn appapp Procfile CWindowsSystem32cmdexe python m pipenv shell clientesapiZKrufQIK EDEVclientesapigit add clientesapiZKrufQIK EDEVclientesapigit commit m primeiro commit master rootcommit 14e64f0 primeiro commit 7 files changed 378 insertions create mode 100644 Pipfile create mode 100644 Pipfilelock create mode 100644 Procfile create mode 100644 apiclienteservicepy create mode 100644 apppy create mode 100644 databasecriartabelapy create mode 100644 databasedatadb clientesapiZKrufQIK EDEVclientesapi Seleccionar CWindowsSystem32cmdexe python m pipenv shell clientesapiZKrufQIK EDEVclientesapiheroku appscreate apiclientesresttest Warning heroku update available from 7530 to 7592 Creating apiclientesresttest done httpsapiclientesresttestherokuappcom httpsgitherokucomapiclientesresttestgit git push heroku master clientesapiZKrufQIK EDEVclientesapigit push heroku master Enumerating objects 11 done Counting objects 100 1111 done Delta compression using up to 4 threads Compressing objects 100 99 done Writing objects 100 1111 776 KiB 194 MiBs done Total 11 delta 0 reused 0 delta 0 packreused 0 remote Compressing source files done remote Building source remote remote Building on the Heroku20 stack remote Determining which buildpack to use for this app remote Python app detected remote Using Python version specified in Pipfilelock remote cp cannot stat tmpbuild246f5d0frequirementstxt No such file or directory remote Installing python399 remote Installing pip 2131 setuptools 5750 and wheel 0370 remote Installing dependencies with Pipenv 20201115 remote Installing dependencies from Pipfilelock b3ba81 remote Ignoring colorama markers platformsystem Windows dont match your environment remote Installing SQLite3 remote Discovering process types remote Procfile declares types web remote remote Compressing remote Done 696M remote Launching remote Released v3 remote httpsapiclientesresttestherokuappcom deployed to Heroku remote remote Verifying deploy done To httpsgitherokucomapiclientesresttestgit API Controle de Clientes emailjoaogmailcomid1nomeJoao da Silvatelefone16 912345678emaildisaolcoukid3nomeJackson Warnertelefone486 5700422emailfermentumveloutlooknetid4nomeLev Whitleytelefone17637540116emaildoloroutlookcoukid5nomeBryar Jamestelefone12233486102emailutdolordapibusicloudeduid6nomeJescie Cruztelefone13732232728emailpretiumaliquetyahoocaid7nomeLacey Maddentelefone13773597657emailacturpisgooglecomid8nomeBethany Bonnertelefone14133224874emailodiovelesthotmailcomid9nomeSawyer Garciatelefone551 4954664emailantevivamusnonoutlookorgid10nomeRegina Gilmoretelefone590 2624619emailnullamutnisigooglenetid11nomeKasimir Blaketelefone734 8462869emailacprotonmailcaid12nomeDara Keytelefone437 7943715emailutpharetragoogleorgid13nomeBrynne Whitneytelefone264 4792965emailantegooglecoukid14nomeCarson Hayestelefone611 7463783emailnisiaeneanyahoocoukid15nomeGarrison Caintelefone480 8870859emailvivamusrhoncusaolorgid16nomeElton Pratttelefone752 5768294