require "sqlite3"

db = SQLite3::Database.new("database201.db")
db.foreign_keys = true
db.results_as_hash = true

db.execute("
    CREATE TABLE IF NOT EXISTS menu (
      menu_id INTEGER PRIMARY KEY,
      name  TEXT NOT NULL,
      price INTEGER DEFAULT(9999999)
    )")

# db.execute_batch(<<~EOF)
#     DROP TABLE IF EXISTS menu
#     CREATE TABLE IF NOT EXISTS menu (
#       menu_id INTEGER PRIMARY KEY,
#       name  TEXT NOT NULL,
#       price INTEGER DEFAULT(9999999)
#       BEGIN;
#   EOF

    # db.execute("
    #     INSERT INTO menu(name, price) 
    #     VALUES(:name,:price)",
    #     name: "プレミアム牛飯",
    #     price: 380
    #     )

    db.execute("
        INSERT INTO menu(name, price) 
        VALUES('うな重',500);")
    
    # db.execute_batch(<<~SQL)
    #     INSERT INTO menu(name, price) VALUES('オリジナルサンドウィッチ', 500);
    #     INSERT INTO menu(name, price) VALUES('たまごサンド', 800);
    #     INSERT INTO menu(name, price) VALUES('パンなしメガ盛りサンド', 1000);
    #     INSERT INTO menu(name, price) VALUES('こぼれたサンド', 100);
    # SQL
    
db.execute("SELECT * FROM menu;").each do |row|
    pp(row)
    end