import sqlite3
from flask import jsonify
from flask import Flask
from flask import request

app = Flask(__name__)

@app.route("/api/<patente>/agregar")
def agregar(patente):
    # pantente = request.args.get["patente"]
    conn = sqlite3.connect('sqlite/deteccion.db')
    c = conn.cursor()
    c.execute("INSERT INTO VEHICULO VALUES (null,'%s', 4567890,1)" %patente)
    conn.commit()
    conn.close()
    return patente

@app.route("/api/<patente>/eliminar")
def eliminar(patente):
    # pantente = request.args.get["patente"]
    conn = sqlite3.connect('sqlite/deteccion.db')
    c = conn.cursor()
    c.execute("UPDATE VEHICULO SET encargo_vehiculo = 0 WHERE patente_vehiculo = '%s'" %patente)
    conn.commit()
    conn.close()
    return patente

app.run(host="127.0.0.1", port=8080, debug=True)