Mercurial > hgrepos > hgweb.cgi > skipweb
changeset 2455:7a25f6aa689a
skiprb
| author | ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp> |
|---|---|
| date | Tue, 07 Jul 2015 21:30:57 +0900 |
| parents | 1ec5287ed88f |
| children | 25552be544d5 |
| files | oasis2015/accountcheck.rb oasis2015/sql/.nfsA1cdc4.4 |
| diffstat | 2 files changed, 12 insertions(+), 3 deletions(-) [+] |
line wrap: on
line diff
--- a/oasis2015/accountcheck.rb Tue Jul 07 19:42:11 2015 +0900 +++ b/oasis2015/accountcheck.rb Tue Jul 07 21:30:57 2015 +0900 @@ -10,6 +10,14 @@ sql = "insert into test values (?, ?, ?, ?, ?, ?, ?, ?, ?)" 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)" +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)" +cle4 = "CREATE TABLE IF NOT EXISTS time(cd, now, id)" +db.execute(cle1) +db.execute(cle2) +db.execute(cle3) +db.execute(cle4) name = c["name"] cal = c["cal"] @@ -58,7 +66,8 @@ _EOS_ -if name == "deleteman123123123" -`cp sql/tsback.sq3 sql/main.sq3` -`chmod a+w sql/main.sq3` +if name == "createman987987987" + `rm sql/main.sq3` + `touch sql/main.sq3` + `chmod a+w sql/main.sq3` end
