forked from lucianonevesln/python_crud_pessoa
-
Notifications
You must be signed in to change notification settings - Fork 0
/
deletar.py
28 lines (23 loc) · 807 Bytes
/
deletar.py
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
from flask import Flask, request, render_template, jsonify
# from db import mysql
from flask import g
def deletar_pessoas2(cpf):
if cpf:
cursor = mysql.get_db().connect()
cursor.execute(
f'delete from python_crud_pessoas.pessoas where cpf = "{cpf}";'
)
conn.commit()
cursor.close()
conn.close()
return render_template('pessoas_deletar.html')
def deletar_contatos2(cpf):
if cpf:
cursor = mysql.get_db().connect()
cursor.execute(
f'delete c from python_crud_pessoas.pessoas as p inner join python_crud_pessoas.contatos as c on c.id_pessoas = p.id where cpf = "{cpf}";'
)
conn.commit()
cursor.close()
conn.close()
return render_template('contatos_deletar.html')