#! /usr/bin/ruby # # maria_update.rb # # Feb/23/2023 # require 'mysql2' require 'date' # # ------------------------------------------------------------ def update_proc (client,id,population) date_mod=Date.today sql_str="UPDATE cities SET population='#{population}', DATE_MOD='#{date_mod}' where ID = '#{id}'" client.query(sql_str) end # ------------------------------------------------------------ STDERR.puts "*** 開始 ***" # id_in = ARGV[0] population_in = ARGV[1].to_i # puts id_in,population_in # host = "localhost" user = "scott" password = "tiger123" data_base = 'city' client = Mysql2::Client.new(host: host, username: user, password: password, database: data_base) # update_proc(client,id_in,population_in) # client.close # STDERR.puts "*** 終了 ***" # ------------------------------------------------------------