Skip to content

Instantly share code, notes, and snippets.

@parzibyte
Created June 14, 2019 17:54
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/7be1246444322c5b778380c2443aec2a to your computer and use it in GitHub Desktop.
Save parzibyte/7be1246444322c5b778380c2443aec2a to your computer and use it in GitHub Desktop.
"""
Conexión a SQLServer con Python
Ejemplo de CRUD evitando inyecciones SQL
@author parzibyte
Más tutoriales en:
parzibyte.me/blog
"""
from bd import conexion
try:
with conexion.cursor() as cursor:
# En este caso no necesitamos limpiar ningún dato
cursor.execute("SELECT id, titulo, anio FROM peliculas;")
# Con fetchall traemos todas las filas
peliculas = cursor.fetchall()
# Recorrer e imprimir
for pelicula in peliculas:
print(pelicula)
except Exception as e:
print("Ocurrió un error al consultar: ", e)
finally:
conexion.close()
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment