Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- #!/usr/bin/env python
- # -*- coding: utf-8 -*-
- #
- # Script para creae la base de datos del restaurante
- import sqlite3
- # creo la base de datos 'restaurante.db'
- conn = sqlite3.connect("restaurante.db")
- # creo el cursor
- cursor = conn.cursor()
- # creo la tabla 'categorias'
- query = 'CREATE TABLE categorias(\
- id INTEGER PRIMARY KEY AUTOINCREMENT,\
- nombre TEXT UNIQUE NOT NULL\
- )'
- cursor.execute(query)
- # creo la tabla 'platos'
- query = 'CREATE TABLE platos(\
- id INTEGER PRIMARY KEY AUTOINCREMENT,\
- nombre TEXT UNIQUE NOT NULL,\
- id_categoria INTEGER NOT NULL,\
- FOREIGN KEY(id_categoria) REFERENCES categorias(id)\
- )'
- cursor.execute(query)
- conn.commit()
- conn.close()
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement