Skip to content

Instantly share code, notes, and snippets.

@parzibyte

parzibyte/insertar-datos-usuario.py Secret

Created July 2, 2019 23:31
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save parzibyte/ab78cd2d6d1287f6ab22559c5745c321 to your computer and use it in GitHub Desktop.
Save parzibyte/ab78cd2d6d1287f6ab22559c5745c321 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
insertar-datos-usuario.py
import sqlite3
try:
bd = sqlite3.connect("libros.db")
cursor = bd.cursor()
autor = input("\nAutor: ")
genero = input("\nGénero: ")
precio = float(input("\nPrecio: "))
titulo = input("\nTítulo: ")
sentencia = "INSERT INTO libros(autor, genero, precio, titulo) VALUES (?,?,?,?)"
cursor.execute(sentencia, [autor, genero, precio, titulo])
bd.commit()
print("Guardado correctamente")
except sqlite3.OperationalError as error:
print("Error al abrir:", error)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment