-
Notifications
You must be signed in to change notification settings - Fork 0
/
CONSULTA_HISTORIAL.py
38 lines (33 loc) · 1.2 KB
/
CONSULTA_HISTORIAL.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
29
30
31
32
33
34
35
36
37
38
from Connexion_DB import *
import sqlite3
class Consulta_Historial:
def __init__(self):
self.db = Base_Datos().conexion
self.miCursor = self.db.cursor()
def Cargar_Historial(self):
try:
self.miCursor.execute("SELECT * FROM Historial")
datos = self.miCursor.fetchall()
self.db.close()
return datos
except sqlite3.Error as e:
print(f"Error en mostrar proveedor: {e}")
return []
def Registro_Historial(self,fecha_hora_actual,accion,usuario):
try:
self.miCursor.execute("INSERT INTO Historial (fecha_hora, accion, usuario) VALUES (?, ?, ?)",
(fecha_hora_actual, accion, usuario))
self.db.commit()
print("Registro ejecutado exitosamente")
return True
except sqlite3.Error as e:
print("problemas {} ".format(e))
def borrar_tabla(self):
try:
self.miCursor.execute("DELETE FROM Historial")
self.db.commit()
self.db.close()
return True
except sqlite3.Error as e:
print(f"Error al borrar la tabla Historial: {e}")
return []