changeset 759:016bb33e7624

acc nameup
author ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
date Wed, 08 Jul 2015 18:58:54 +0900
parents 999f46bf091e
children 9a5b38747cbf
files oasis2015/accountcheck.rb
diffstat 1 files changed, 4 insertions(+), 0 deletions(-) [+]
line wrap: on
line diff
--- a/oasis2015/accountcheck.rb	Wed Jul 08 18:54:00 2015 +0900
+++ b/oasis2015/accountcheck.rb	Wed Jul 08 18:58:54 2015 +0900
@@ -9,6 +9,8 @@
 db = SQLite3::Database.new("sql/main.sq3")
 #sql = "insert into test values(?, ?, ?, ?, ?, ?, ?, ?, ?)"
 sql = "insert into test values (?, 0, 0, 0, 0, 0, 0, 0, 0)"
+squp = "update test set name = ? where id = ?"
+#, cal=?, age=?, sex=?, aria=?, exp=?, pt=?, lv=? where id = ?"
 
 toi = "insert into toi values (?, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0)"
 item = "insert into goods values (?, 0, 0, 0, 0, 0, 0)"
@@ -54,6 +56,8 @@
   lv = 1
 #  db.execute(sql, id, name, cal, age, sex, aria, exp, pt, lv)
   db.execute(sql, id)
+  db.execute(squp, name, id)
+
   db.execute(toi, id)
   db.execute(item, id)
 end

yatex.org