Mercurial > hgrepos > hgweb.cgi > skipweb

annotate delete.rb @ 1811:a5e15feba3de

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Good bye coupon/ webs
author HIROSE Yuuji <yuuji@koeki-u.ac.jp>
date Fri, 29 Sep 2017 14:21:17 +0859
parents 05303d4b8344
children
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
rev   line source
557
05303d4b8344 データ消す用見る用プログラム added
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff changeset
1 #!/usr/bin/env ruby
05303d4b8344 データ消す用見る用プログラム added
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff changeset
2 # -*- coding: utf-8 -*-
05303d4b8344 データ消す用見る用プログラム added
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff changeset
3
05303d4b8344 データ消す用見る用プログラム added
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff changeset
4 require 'sqlite3'
05303d4b8344 データ消す用見る用プログラム added
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff changeset
5 require 'cgi'
05303d4b8344 データ消す用見る用プログラム added
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff changeset
6
05303d4b8344 データ消す用見る用プログラム added
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff changeset
7 db = SQLite3::Database.new("/sql/stamp.sq3")
05303d4b8344 データ消す用見る用プログラム added
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff changeset
8
05303d4b8344 データ消す用見る用プログラム added
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff changeset
9 c = CGI.new(:accept_charaset => "UTF-8")
05303d4b8344 データ消す用見る用プログラム added
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff changeset
10 check = c['check']
05303d4b8344 データ消す用見る用プログラム added
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff changeset
11 if check = "OK"
05303d4b8344 データ消す用見る用プログラム added
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff changeset
12 begin
05303d4b8344 データ消す用見る用プログラム added
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff changeset
13 db.execute("drop table main;")
05303d4b8344 データ消す用見る用プログラム added
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff changeset
14 db.extcute("drop table logs;")
05303d4b8344 データ消す用見る用プログラム added
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff changeset
15 text = "<p>若帥ゃ障</p>"
05303d4b8344 データ消す用見る用プログラム added
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff changeset
16 rescue
05303d4b8344 データ消す用見る用プログラム added
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff changeset
17 text = "<p>若帥障</p>"
05303d4b8344 データ消す用見る用プログラム added
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff changeset
18 end
05303d4b8344 データ消す用見る用プログラム added
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff changeset
19 else
05303d4b8344 データ消す用見る用プログラム added
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff changeset
20 text = "若帥ゃ障"
05303d4b8344 データ消す用見る用プログラム added
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff changeset
21 end
05303d4b8344 データ消す用見る用プログラム added
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff changeset
22
05303d4b8344 データ消す用見る用プログラム added
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff changeset
23 printf("Content-type: text/html; charset=UTF-8\n\n")
05303d4b8344 データ消す用見る用プログラム added
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff changeset
24
05303d4b8344 データ消す用見る用プログラム 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">
05303d4b8344 データ消す用見る用プログラム added
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff changeset
26 <html>
05303d4b8344 データ消す用見る用プログラム added
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff changeset
27 <head>
05303d4b8344 データ消す用見る用プログラム added
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff changeset
28 <title>Delete table</title>
05303d4b8344 データ消す用見る用プログラム added
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff changeset
29 <link rel="stylesheet" type="text/css" href="design.css">
05303d4b8344 データ消す用見る用プログラム added
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff changeset
30 </head>
05303d4b8344 データ消す用見る用プログラム added
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff changeset
31 </body>
05303d4b8344 データ消す用見る用プログラム added
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff changeset
32 %s
05303d4b8344 データ消す用見る用プログラム added
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff changeset
33 <p><a href="etsuran.rb">若翠画Η若吾</a></p>
05303d4b8344 データ消す用見る用プログラム added
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff changeset
34 <p></p>
05303d4b8344 データ消す用見る用プログラム added
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff changeset
35 </body></html>
05303d4b8344 データ消す用見る用プログラム added
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff changeset
36 ',text

yatex.org