-
-
Save parzibyte/39c5a0eb9e80481f7ad62c3c458a3cc8 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
import sqlite3 | |
try: | |
bd = sqlite3.connect("libros.db") | |
cursor = bd.cursor() | |
libros = [ | |
""" | |
INSERT INTO libros | |
(autor, genero, precio, titulo) | |
VALUES | |
('Stephen King', 'Terror', 115,'Cementerio de animales'), | |
('Alfred Bester', 'Ciencia ficción', 200,'Las estrellas, mi destino'), | |
('Margaret Atwood', 'Ciencia ficción', 150,'El cuento de la criada'); | |
""" | |
] | |
for sentencia in libros: | |
cursor.execute(sentencia); | |
bd.commit() #Guardamos los cambios al terminar el ciclo | |
print("Libros insertados 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