annotate opencampus2015/accountcheck.rb @ 1494:f24c79f2f755

map link fixed
author ITO Shiho <c115022@g.koeki-u.ac.jp>
date Fri, 22 Jan 2016 14:39:06 +0900
parents 6dec477b8e06
children
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
rev   line source
1084
97fb16fc96cd who is d
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
1 #!/usr/bin/env ruby22
97fb16fc96cd who is d
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
2 # -*- coding: utf-8 -*-
97fb16fc96cd who is d
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
3
97fb16fc96cd who is d
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
4 require 'sqlite3'
97fb16fc96cd who is d
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
5 require 'kconv'
97fb16fc96cd who is d
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
6 require 'cgi'
97fb16fc96cd who is d
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
7 require 'csv'
97fb16fc96cd who is d
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
8
97fb16fc96cd who is d
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
9 c = CGI.new(:tag_maker => "html5", :accept_charest => "UTF-8")
97fb16fc96cd who is d
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
10 db = SQLite3::Database.new("sql/main.sq3")
97fb16fc96cd who is d
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
11 csv = "list.csv"
97fb16fc96cd who is d
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
12
97fb16fc96cd who is d
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
13 sql = "insert into test values(?, ?, ?, ?, ?, ?, ?, ?, ?)"
97fb16fc96cd who is d
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
14
97fb16fc96cd who is d
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
15 toi = "insert into toi values (?, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0)"
97fb16fc96cd who is d
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
16 item = "insert into goods values (?, 0, 0, 0, 0, 0, 0)"
97fb16fc96cd who is d
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
17
97fb16fc96cd who is d
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
18 name = c["name"]
97fb16fc96cd who is d
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
19 pswd = c["pswd"]
97fb16fc96cd who is d
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
20 cle1 = "CREATE TABLE IF NOT EXISTS test(id, name, cal, age, sex, pswd, exp, pt, lv)"
97fb16fc96cd who is d
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
21 cle2 = "CREATE TABLE IF NOT EXISTS toi(id, q1, q2, q3, q4, q5, q6, q7, q8, q9, q10)"
97fb16fc96cd who is d
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
22 cle3 = "CREATE TABLE IF NOT EXISTS goods(id, g1, g2, g3, g4, g5, g6)"
97fb16fc96cd who is d
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
23 cle4 = "CREATE TABLE IF NOT EXISTS time(cd, now, id)"
97fb16fc96cd who is d
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
24 cle5 = "CREATE TABLE IF NOT EXISTS num(cd, id)"
97fb16fc96cd who is d
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
25 cle6 = "CREATE TABLE IF NOT EXISTS pass(id, pass, name)"
97fb16fc96cd who is d
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
26
97fb16fc96cd who is d
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
27 cle7 = "CREATE TABLE IF NOT EXISTS zukan(no, name, tah, lv2, lv3, lv4, lv5)"
97fb16fc96cd who is d
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
28 cle8 = "CREATE TABLE IF NOT EXISTS box(id, no1, e1, t1, tm1, no2, e2, t2, tm2, no3, e3, t3, tm3)"
97fb16fc96cd who is d
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
29 ins8 = "insert into box values(?,?,0,?,?,0,0,0,0,0,0,0,0)"
97fb16fc96cd who is d
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
30
97fb16fc96cd who is d
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
31 ins4 = 'insert into time values(?, 61, "n")'
97fb16fc96cd who is d
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
32 ins5 = 'insert into num values("aa",0)'
97fb16fc96cd who is d
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
33 ins6 = 'insert into pass values(?, ?, ?)'
97fb16fc96cd who is d
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
34 num = "select id from num where cd = ?"
97fb16fc96cd who is d
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
35 numup = "update num set id = ? where cd = ?"
97fb16fc96cd who is d
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
36
97fb16fc96cd who is d
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
37 db.execute(cle1)
97fb16fc96cd who is d
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
38 db.execute(cle2)
97fb16fc96cd who is d
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
39 #db.execute(cle3)
97fb16fc96cd who is d
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
40 db.execute(cle4)
97fb16fc96cd who is d
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
41 db.execute(cle5)
97fb16fc96cd who is d
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
42 db.execute(cle6)
97fb16fc96cd who is d
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
43 db.execute(cle7)
97fb16fc96cd who is d
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
44 db.execute(cle8)
97fb16fc96cd who is d
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
45 if name == "createman789789789"
97fb16fc96cd who is d
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
46 ("a".."j").each{|x|db.execute(ins4,x)}
97fb16fc96cd who is d
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
47 db.execute(ins5)
97fb16fc96cd who is d
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
48 #system `sqlite3 -separator , /sql/main.sq3 ".import list.csv zukan"` #(ins7)
97fb16fc96cd who is d
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
49 CSV.foreach(csv) do |row|
97fb16fc96cd who is d
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
50 db.execute("INSERT INTO zukan VALUES(?,?,?,?,?,?,?)",*row)
97fb16fc96cd who is d
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
51 end
97fb16fc96cd who is d
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
52 end
97fb16fc96cd who is d
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
53
97fb16fc96cd who is d
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
54 name = c["name"]
97fb16fc96cd who is d
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
55 namae = "#{name}"
97fb16fc96cd who is d
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
56 cal = c["cal"]
97fb16fc96cd who is d
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
57 age = c["age"]
97fb16fc96cd who is d
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
58 sex = c["sex"]
97fb16fc96cd who is d
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
59 aria = c["aria"]
97fb16fc96cd who is d
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
60
97fb16fc96cd who is d
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
61
97fb16fc96cd who is d
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
62 id = c.cookies["id"][0]
97fb16fc96cd who is d
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
63 pass = c.cookies["pass"][0]
97fb16fc96cd who is d
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
64 no1 = db.execute("select no from zukan where name = ?",cal)[0][0]
97fb16fc96cd who is d
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
65 t1 = db.execute("select tah from zukan where name = ?",cal)[0][0]
97fb16fc96cd who is d
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
66
97fb16fc96cd who is d
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
67
97fb16fc96cd who is d
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
68 if id == nil
97fb16fc96cd who is d
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
69 number = db.execute(num, "aa")
97fb16fc96cd who is d
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
70 begin
97fb16fc96cd who is d
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
71 id = number[0][0].to_i + 1
97fb16fc96cd who is d
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
72 rescue
97fb16fc96cd who is d
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
73 ("a".."j").each{|x| db.execute(ins4,x)}
97fb16fc96cd who is d
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
74 # db.execute(ins4, "b")
97fb16fc96cd who is d
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
75 # db.execute(ins4, "c")
97fb16fc96cd who is d
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
76 # db.execute(ins4, "d")
97fb16fc96cd who is d
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
77 # db.execute(ins4, "e")
97fb16fc96cd who is d
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
78 # db.execute(ins4, "f")
97fb16fc96cd who is d
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
79 # db.execute(ins4, "g")
97fb16fc96cd who is d
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
80 # db.execute(ins4, "h")
97fb16fc96cd who is d
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
81 # db.execute(ins4, "i")
97fb16fc96cd who is d
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
82 # db.execute(ins4, "j")
97fb16fc96cd who is d
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
83 db.execute(ins5)
97fb16fc96cd who is d
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
84 id = number[0][0].to_i + 1
97fb16fc96cd who is d
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
85 end
97fb16fc96cd who is d
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
86 exp = 0
97fb16fc96cd who is d
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
87 pt = 0
97fb16fc96cd who is d
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
88 lv = 1
97fb16fc96cd who is d
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
89 cd = "aa"
97fb16fc96cd who is d
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
90 if pass == nil
97fb16fc96cd who is d
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
91 pass = id
97fb16fc96cd who is d
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
92 end
97fb16fc96cd who is d
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
93 db.execute(ins6, id, pass, name)
97fb16fc96cd who is d
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
94 db.execute(sql, id, name, cal, age, sex, aria, exp, pt, lv)
97fb16fc96cd who is d
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
95 db.execute(toi, id)
97fb16fc96cd who is d
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
96 # db.execute(item, id)
97fb16fc96cd who is d
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
97 db.execute(numup, id, cd)
97fb16fc96cd who is d
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
98 db.execute(ins8,id,no1,t1.to_i/5,t1.to_i/5)
97fb16fc96cd who is d
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
99 end
97fb16fc96cd who is d
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
100 # srand(id.to_i)
97fb16fc96cd who is d
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
101 # id2 = rand(1000000)
97fb16fc96cd who is d
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
102 id2 = pass
97fb16fc96cd who is d
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
103
97fb16fc96cd who is d
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
104
97fb16fc96cd who is d
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
105
97fb16fc96cd who is d
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
106 expires = "SUN, 5, MAR 2017 00:00:00 GMT"
97fb16fc96cd who is d
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
107
97fb16fc96cd who is d
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
108 printf("Content-type: text/html; charset=UTF-8
97fb16fc96cd who is d
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
109 Set-Cookie:id=%s ;expires=%s
97fb16fc96cd who is d
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
110 Set-Cookie:pass=%s ;expires=%s\n\n", id, expires, id2, expires)
97fb16fc96cd who is d
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
111
97fb16fc96cd who is d
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
112 printf(<<_EOS_, name, id.to_i)
97fb16fc96cd who is d
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
113 <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
97fb16fc96cd who is d
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
114 <html>
97fb16fc96cd who is d
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
115 <head>
97fb16fc96cd who is d
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
116
97fb16fc96cd who is d
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
117 <meta name="viewport" content="width=device-width,initial-scale=1,maximum-scale=1,user-scalable=no">
97fb16fc96cd who is d
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
118 <meta name="format-detection" content="telephone=no">
97fb16fc96cd who is d
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
119 <link media="only screen and (max-device-width:480px)" href="smart.css" type="text/css" rel="stylesheet" />
97fb16fc96cd who is d
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
120 <link media="screen and (min-device-width:481px)" href="profeel.css" type="text/css" rel="stylesheet" />
97fb16fc96cd who is d
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
121
97fb16fc96cd who is d
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
122
97fb16fc96cd who is d
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
123
97fb16fc96cd who is d
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
124
97fb16fc96cd who is d
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
125 <link rel="shortcut icon" href="./img/cabage.png"/>
97fb16fc96cd who is d
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
126 <title>Registering Account</title>
97fb16fc96cd who is d
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
127
97fb16fc96cd who is d
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
128 </head>
97fb16fc96cd who is d
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
129 <body>
97fb16fc96cd who is d
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
130 <h1>Miyazac Quest</h1>
97fb16fc96cd who is d
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
131 <h2>登録完了!</h2>
97fb16fc96cd who is d
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
132 <p>よくきた_ %s _よ!</p>
97fb16fc96cd who is d
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
133 <p>おまえのIDは%04dだ!</p>
97fb16fc96cd who is d
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
134 <div class="f1"><a href="prof.rb"><div class="lets"><span>始めよう!</span></div></a></div>
97fb16fc96cd who is d
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
135 <form method="POST" type="text">
97fb16fc96cd who is d
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
136 </form>
97fb16fc96cd who is d
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
137 </body></html>
97fb16fc96cd who is d
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
138 _EOS_
97fb16fc96cd who is d
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
139 if name == "createman987987987"
97fb16fc96cd who is d
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
140 filename ='sql/main.sq3'
97fb16fc96cd who is d
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
141 File.delete filename
97fb16fc96cd who is d
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
142 end

yatex.org