Mercurial > hgrepos > hgweb.cgi > skipweb
changeset 2598:e1e651b656a6
hoge
author | ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp> |
---|---|
date | Thu, 22 Oct 2015 21:43:39 +0900 |
parents | fb460649240b |
children | 518898bed878 |
files | opencampus2015/accountcheck.rb |
diffstat | 1 files changed, 3 insertions(+), 2 deletions(-) [+] |
line wrap: on
line diff
--- a/opencampus2015/accountcheck.rb Thu Oct 22 20:55:45 2015 +0900 +++ b/opencampus2015/accountcheck.rb Thu Oct 22 21:43:39 2015 +0900 @@ -24,8 +24,8 @@ cle6 = "CREATE TABLE IF NOT EXISTS pass(id, pass, name)" cle7 = "CREATE TABLE IF NOT EXISTS zukan(no, name, tah, lv2, lv3, lv4, lv5)" -cle8 = "CREATE TABLE IF NOT EXISTS box(id, i1 ,e1 ,t1 , tm2, i2 ,e2 ,t2 , tm2, i3 ,e3 ,t3 ,tm3)" -ins8 = ".import list.csv zukan" +cle8 = "CREATE TABLE IF NOT EXISTS box(id, i1, e1, t1,tm1, i2, e2, t2, tm2, i3, e3, t3, tm3)" +#ins8 = ".import list.csv zukan" ins4 = 'insert into time values(?, 61, "n")' ins5 = 'insert into num values("aa",0)' @@ -53,6 +53,7 @@ db.execute(ins4, "i") db.execute(ins4, "j") db.execute(ins5) +system `sqlite3 -separator , /sql/main.sq3 ".import list.csv"` end name = c["name"]