-
Notifications
You must be signed in to change notification settings - Fork 0
/
db.py
24 lines (22 loc) · 838 Bytes
/
db.py
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
#bibliotecas:
import sqlite3
#conexao com o banco de dados:
def create_connection():
conn = sqlite3.connect('missoes.db')
return conn
#criaçao da tabela:
def create_table(conn):
cursor = conn.cursor()
cursor.execute('''CREATE TABLE IF NOT EXISTS missao (
missao_id INTEGER PRIMARY KEY AUTOINCREMENT,
nome TEXT NOT NULL,
data_lancamento DATE NOT NULL,
destino TEXT NOT NULL,
estado TEXT NOT NULL,
tripulacao TEXT NOT NULL,
carga_util TEXT NOT NULL,
duracao TEXT NOT NULL,
custo REAL NOT NULL,
status TEXT NOT NULL
)''')
conn.commit()