-
-
Save parzibyte/cf3be29f9544d052393b229e9a02dfe1 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
def agregar_palabra(palabra, significado): | |
conexion = obtener_conexion() | |
cursor = conexion.cursor() | |
sentencia = "INSERT INTO diccionario(palabra, significado) VALUES (?, ?)" | |
cursor.execute(sentencia, [palabra, significado]) | |
conexion.commit() | |
def editar_palabra(palabra, nuevo_significado): | |
conexion = obtener_conexion() | |
cursor = conexion.cursor() | |
sentencia = "UPDATE diccionario SET significado = ? WHERE palabra = ?" | |
cursor.execute(sentencia, [nuevo_significado, palabra]) | |
conexion.commit() | |
def eliminar_palabra(palabra): | |
conexion = obtener_conexion() | |
cursor = conexion.cursor() | |
sentencia = "DELETE FROM diccionario WHERE palabra = ?" | |
cursor.execute(sentencia, [palabra]) | |
conexion.commit() | |
def obtener_palabras(): | |
conexion = obtener_conexion() | |
cursor = conexion.cursor() | |
consulta = "SELECT palabra FROM diccionario" | |
cursor.execute(consulta) | |
return cursor.fetchall() | |
def buscar_significado_palabra(palabra): | |
conexion = obtener_conexion() | |
cursor = conexion.cursor() | |
consulta = "SELECT significado FROM diccionario WHERE palabra = ?" | |
cursor.execute(consulta, [palabra]) | |
return cursor.fetchone() |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment