fork download
copy 
  1. import sqlite3
  2.  
  3. db = sqlite3.connect(":memory:")
  4. db.execute("create table shop ( Name)")
  5. db.execute("insert into shop values ( 'george')")
  6. db.execute("insert into shop values ( 'martha')")
  7. cursor = db.cursor()
  8.  
  9. # Your code follows:
  10.  
  11. names = cursor.execute('''select Name from shop''')
  12.  
  13. numList = []
  14. for name in names:
  15.     num = int(input("How many " + name[0] + "s do you want? \n"))
  16.     numList.append(num)
  17.  
  18. print(numList)
  19.  
Success #stdin #stdout 0.01s 11384KB
comments (?)
stdin
copy 
1
3
stdout
copy 
How many georges do you want? 
How many marthas do you want? 
[1, 3]
https://ideone.com/ejtu21
language:
Python 3 (python  3.12)
created:
9 years ago
visibility:
secret

Share or Embed source code

Discover > Sphere Engine API

The brand new service which powers Ideone!

Discover > IDE Widget

Widget for compiling and running the source code in a web browser!