Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- #!/usr/bin/env python
- # -*- coding: utf-8 -*-
- #
- import sqlite3
- conn = sqlite3.connect("productos.sqlite")
- cursor = conn.cursor()
- cursor.execute("CREATE TABLE IF NOT EXISTS productos(id NUMERIC, nombre TEXT, precio NUMERIC)")
- conn.commit()
- productos = (
- (1,'Teclado',25),
- (2,"Mouse", 18),
- (3,'Monitor',300),
- (4,'Parlantes',100)
- )
- for cod,nombre,precio in productos:
- cursor.execute(f"INSERT INTO productos VALUES(?,?,?)",(cod,nombre,precio))
- conn.commit()
- cursor.execute("SELECT * FROM productos")
- datos = cursor.fetchall()
- print(datos)
- # cerrar la base
- conn.close()
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement