Mercurial > hgrepos > hgweb.cgi > skipweb

annotate delete.rb @ 2944:b1cb17ea7605

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
merge
author ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
date Tue, 08 Dec 2015 19:36:05 +0900
parents bd675bc7adcf
children
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
rev   line source
2290
bd675bc7adcf データ消す用見る用プログラム added
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff changeset
1 #!/usr/bin/env ruby
bd675bc7adcf データ消す用見る用プログラム added
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff changeset
2 # -*- coding: utf-8 -*-
bd675bc7adcf データ消す用見る用プログラム added
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff changeset
3
bd675bc7adcf データ消す用見る用プログラム added
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff changeset
4 require 'sqlite3'
bd675bc7adcf データ消す用見る用プログラム added
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff changeset
5 require 'cgi'
bd675bc7adcf データ消す用見る用プログラム added
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff changeset
6
bd675bc7adcf データ消す用見る用プログラム added
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff changeset
7 db = SQLite3::Database.new("/sql/stamp.sq3")
bd675bc7adcf データ消す用見る用プログラム added
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff changeset
8
bd675bc7adcf データ消す用見る用プログラム added
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff changeset
9 c = CGI.new(:accept_charaset => "UTF-8")
bd675bc7adcf データ消す用見る用プログラム added
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff changeset
10 check = c['check']
bd675bc7adcf データ消す用見る用プログラム added
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff changeset
11 if check = "OK"
bd675bc7adcf データ消す用見る用プログラム added
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff changeset
12 begin
bd675bc7adcf データ消す用見る用プログラム added
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff changeset
13 db.execute("drop table main;")
bd675bc7adcf データ消す用見る用プログラム added
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff changeset
14 db.extcute("drop table logs;")
bd675bc7adcf データ消す用見る用プログラム added
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff changeset
15 text = "<p>若帥ゃ障</p>"
bd675bc7adcf データ消す用見る用プログラム added
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff changeset
16 rescue
bd675bc7adcf データ消す用見る用プログラム added
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff changeset
17 text = "<p>若帥障</p>"
bd675bc7adcf データ消す用見る用プログラム added
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff changeset
18 end
bd675bc7adcf データ消す用見る用プログラム added
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff changeset
19 else
bd675bc7adcf データ消す用見る用プログラム added
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff changeset
20 text = "若帥ゃ障"
bd675bc7adcf データ消す用見る用プログラム added
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff changeset
21 end
bd675bc7adcf データ消す用見る用プログラム added
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff changeset
22
bd675bc7adcf データ消す用見る用プログラム added
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff changeset
23 printf("Content-type: text/html; charset=UTF-8\n\n")
bd675bc7adcf データ消す用見る用プログラム added
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff changeset
24
bd675bc7adcf データ消す用見る用プログラム added
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff changeset
25 printf'<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
bd675bc7adcf データ消す用見る用プログラム added
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff changeset
26 <html>
bd675bc7adcf データ消す用見る用プログラム added
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff changeset
27 <head>
bd675bc7adcf データ消す用見る用プログラム added
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff changeset
28 <title>Delete table</title>
bd675bc7adcf データ消す用見る用プログラム added
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff changeset
29 <link rel="stylesheet" type="text/css" href="design.css">
bd675bc7adcf データ消す用見る用プログラム added
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff changeset
30 </head>
bd675bc7adcf データ消す用見る用プログラム added
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff changeset
31 </body>
bd675bc7adcf データ消す用見る用プログラム added
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff changeset
32 %s
bd675bc7adcf データ消す用見る用プログラム added
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff changeset
33 <p><a href="etsuran.rb">若翠画Η若吾</a></p>
bd675bc7adcf データ消す用見る用プログラム added
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff changeset
34 <p></p>
bd675bc7adcf データ消す用見る用プログラム added
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff changeset
35 </body></html>
bd675bc7adcf データ消す用見る用プログラム added
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff changeset
36 ',text

yatex.org