changeset 752:d385e91ad9dd

acc sqltesttable
author ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
date Wed, 08 Jul 2015 18:19:32 +0900
parents 8fa9f9b018de
children 2695514ec79a
files oasis2015/accountcheck.rb
diffstat 1 files changed, 3 insertions(+), 2 deletions(-) [+]
line wrap: on
line diff
--- a/oasis2015/accountcheck.rb	Wed Jul 08 18:15:45 2015 +0900
+++ b/oasis2015/accountcheck.rb	Wed Jul 08 18:19:32 2015 +0900
@@ -12,7 +12,7 @@
 item = "insert into goods values (?, 0, 0, 0, 0, 0, 0)"
 
 name = c["name"]
-#if name == "createman789789789"
+
 cle1 = "CREATE TABLE IF NOT EXISTS test(id, name, cal, age, sex, aria, exp, pt, lv)"
 cle2 = "CREATE TABLE IF NOT EXISTS toi(id, q1, q2, q3, q4, q5, q6, q7, q8, q9, q10)"
 cle3 = "CREATE TABLE IF NOT EXISTS goods(id, g1, g2, g3, g4, g5, g6)"
@@ -50,7 +50,8 @@
   exp = 0
   pt = 0
   lv = 1
-  db.execute(sql, id, name, cal, age, sex, aria, exp, pt, lv)
+#  db.execute(sql, id, name, cal, age, sex, aria, exp, pt, lv)
+  db.execute(sql, id, 0, 0, 0, 0, 0, 0, 0, 0)
   db.execute(toi, id)
   db.execute(item, id)
 end

yatex.org