Skip to content

Instantly share code, notes, and snippets.

@gun007
Created November 13, 2018 18:27
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
Star You must be signed in to star a gist
Save gun007/f641f9d96e94f91184d32060733b4c87 to your computer and use it in GitHub Desktop.
# .*. coding: latin1 .*.
# importa wxPythton
import sqlite3
con = sqlite3.connect('aula3228524.db')
cur = con.cursor()
sql = 'create table imc (id integer primary key, peso float, altura float, imc float)'
cur.execute(sql)
print("banco criado com sucesso")
peso = float(input ("insira o seu peso: "));
altura = float(input("insira sua altura em cm: "));
imc = peso / (altura**2)
print ("seu imc é: {:.1f}".format(imc) )
insert = 'insert into imc values (null, '+ str(peso) +', '+str(altura)+', '+str(imc)+')'
cur.execute(insert)
con.commit()
cur.execute('select * from imc')
recset = cur.fetchall()
print ('exibindo dados gravados no banco: ')
print (recset)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment