annotate src/luan/modules/lucene/Web_search.luan @ 1407:1979cff9aad2

add sql/Web_query
author Franklin Schmidt <fschmidt@gmail.com>
date Fri, 20 Sep 2019 17:00:30 -0600
parents 9dfff82dfc59
children 4ba0377afa3e
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
rev   line source
1088
bae2d0c2576c change module naming convention
Franklin Schmidt <fschmidt@gmail.com>
parents: 775
diff changeset
1 local Luan = require "luan:Luan.luan"
548
f4dfe9c64c25 shorten some String function names
Franklin Schmidt <fschmidt@gmail.com>
parents: 545
diff changeset
2 local error = Luan.error
f4dfe9c64c25 shorten some String function names
Franklin Schmidt <fschmidt@gmail.com>
parents: 545
diff changeset
3 local pairs = Luan.pairs or error()
f4dfe9c64c25 shorten some String function names
Franklin Schmidt <fschmidt@gmail.com>
parents: 545
diff changeset
4 local ipairs = Luan.ipairs or error()
f4dfe9c64c25 shorten some String function names
Franklin Schmidt <fschmidt@gmail.com>
parents: 545
diff changeset
5 local range = Luan.range or error()
1189
73d754b1889f add stringify
Franklin Schmidt <fschmidt@gmail.com>
parents: 1152
diff changeset
6 local stringify = Luan.stringify or error()
1395
9dfff82dfc59 finish postgres work
Franklin Schmidt <fschmidt@gmail.com>
parents: 1355
diff changeset
7 local eval = Luan.eval or error()
693
ca169567ce07 module URIs must now include ".luan"
Franklin Schmidt <fschmidt@gmail.com>
parents: 561
diff changeset
8 local Io = require "luan:Io.luan"
ca169567ce07 module URIs must now include ".luan"
Franklin Schmidt <fschmidt@gmail.com>
parents: 561
diff changeset
9 local Http = require "luan:http/Http.luan"
ca169567ce07 module URIs must now include ".luan"
Franklin Schmidt <fschmidt@gmail.com>
parents: 561
diff changeset
10 local String = require "luan:String.luan"
548
f4dfe9c64c25 shorten some String function names
Franklin Schmidt <fschmidt@gmail.com>
parents: 545
diff changeset
11 local string_to_number = String.to_number or error()
693
ca169567ce07 module URIs must now include ".luan"
Franklin Schmidt <fschmidt@gmail.com>
parents: 561
diff changeset
12 local Html = require "luan:Html.luan"
1395
9dfff82dfc59 finish postgres work
Franklin Schmidt <fschmidt@gmail.com>
parents: 1355
diff changeset
13 local html_encode = Html.encode or error()
9dfff82dfc59 finish postgres work
Franklin Schmidt <fschmidt@gmail.com>
parents: 1355
diff changeset
14 local Number = require "luan:Number.luan"
285
582e8db4cdb6 add lucene Web_search
fschmidt@gmail.com <fschmidt@gmail.com@21e917c8-12df-6dd8-5cb6-c86387c605b9>
parents:
diff changeset
15
561
363d07e26549 remove SimplyHTML from lucene/Web_search
Franklin Schmidt <fschmidt@gmail.com>
parents: 550
diff changeset
16
1088
bae2d0c2576c change module naming convention
Franklin Schmidt <fschmidt@gmail.com>
parents: 775
diff changeset
17 local Web_search = {}
285
582e8db4cdb6 add lucene Web_search
fschmidt@gmail.com <fschmidt@gmail.com@21e917c8-12df-6dd8-5cb6-c86387c605b9>
parents:
diff changeset
18
1395
9dfff82dfc59 finish postgres work
Franklin Schmidt <fschmidt@gmail.com>
parents: 1355
diff changeset
19 local function style()
9dfff82dfc59 finish postgres work
Franklin Schmidt <fschmidt@gmail.com>
parents: 1355
diff changeset
20 %>
561
363d07e26549 remove SimplyHTML from lucene/Web_search
Franklin Schmidt <fschmidt@gmail.com>
parents: 550
diff changeset
21 body {
1395
9dfff82dfc59 finish postgres work
Franklin Schmidt <fschmidt@gmail.com>
parents: 1355
diff changeset
22 font-family: sans-serif;
561
363d07e26549 remove SimplyHTML from lucene/Web_search
Franklin Schmidt <fschmidt@gmail.com>
parents: 550
diff changeset
23 margin: 2em 5%;
363d07e26549 remove SimplyHTML from lucene/Web_search
Franklin Schmidt <fschmidt@gmail.com>
parents: 550
diff changeset
24 }
363d07e26549 remove SimplyHTML from lucene/Web_search
Franklin Schmidt <fschmidt@gmail.com>
parents: 550
diff changeset
25 h2 {
363d07e26549 remove SimplyHTML from lucene/Web_search
Franklin Schmidt <fschmidt@gmail.com>
parents: 550
diff changeset
26 margin-bottom: .5em;
363d07e26549 remove SimplyHTML from lucene/Web_search
Franklin Schmidt <fschmidt@gmail.com>
parents: 550
diff changeset
27 }
363d07e26549 remove SimplyHTML from lucene/Web_search
Franklin Schmidt <fschmidt@gmail.com>
parents: 550
diff changeset
28 label {
363d07e26549 remove SimplyHTML from lucene/Web_search
Franklin Schmidt <fschmidt@gmail.com>
parents: 550
diff changeset
29 text-align: right;
363d07e26549 remove SimplyHTML from lucene/Web_search
Franklin Schmidt <fschmidt@gmail.com>
parents: 550
diff changeset
30 min-width: 6em;
363d07e26549 remove SimplyHTML from lucene/Web_search
Franklin Schmidt <fschmidt@gmail.com>
parents: 550
diff changeset
31 display: inline-block;
363d07e26549 remove SimplyHTML from lucene/Web_search
Franklin Schmidt <fschmidt@gmail.com>
parents: 550
diff changeset
32 margin-right: .5em;
363d07e26549 remove SimplyHTML from lucene/Web_search
Franklin Schmidt <fschmidt@gmail.com>
parents: 550
diff changeset
33 }
1395
9dfff82dfc59 finish postgres work
Franklin Schmidt <fschmidt@gmail.com>
parents: 1355
diff changeset
34 input, textarea {
561
363d07e26549 remove SimplyHTML from lucene/Web_search
Franklin Schmidt <fschmidt@gmail.com>
parents: 550
diff changeset
35 margin-top: 1em;
363d07e26549 remove SimplyHTML from lucene/Web_search
Franklin Schmidt <fschmidt@gmail.com>
parents: 550
diff changeset
36 font: inherit;
363d07e26549 remove SimplyHTML from lucene/Web_search
Franklin Schmidt <fschmidt@gmail.com>
parents: 550
diff changeset
37 }
363d07e26549 remove SimplyHTML from lucene/Web_search
Franklin Schmidt <fschmidt@gmail.com>
parents: 550
diff changeset
38 span[tip] {
363d07e26549 remove SimplyHTML from lucene/Web_search
Franklin Schmidt <fschmidt@gmail.com>
parents: 550
diff changeset
39 color: #888;
363d07e26549 remove SimplyHTML from lucene/Web_search
Franklin Schmidt <fschmidt@gmail.com>
parents: 550
diff changeset
40 font-size: smaller;
363d07e26549 remove SimplyHTML from lucene/Web_search
Franklin Schmidt <fschmidt@gmail.com>
parents: 550
diff changeset
41 }
363d07e26549 remove SimplyHTML from lucene/Web_search
Franklin Schmidt <fschmidt@gmail.com>
parents: 550
diff changeset
42 input[type="submit"] {
1395
9dfff82dfc59 finish postgres work
Franklin Schmidt <fschmidt@gmail.com>
parents: 1355
diff changeset
43 cursor: pointer;
561
363d07e26549 remove SimplyHTML from lucene/Web_search
Franklin Schmidt <fschmidt@gmail.com>
parents: 550
diff changeset
44 padding: .5em;
363d07e26549 remove SimplyHTML from lucene/Web_search
Franklin Schmidt <fschmidt@gmail.com>
parents: 550
diff changeset
45 border-radius: 4px;
363d07e26549 remove SimplyHTML from lucene/Web_search
Franklin Schmidt <fschmidt@gmail.com>
parents: 550
diff changeset
46 }
1395
9dfff82dfc59 finish postgres work
Franklin Schmidt <fschmidt@gmail.com>
parents: 1355
diff changeset
47 <%
9dfff82dfc59 finish postgres work
Franklin Schmidt <fschmidt@gmail.com>
parents: 1355
diff changeset
48 end
9dfff82dfc59 finish postgres work
Franklin Schmidt <fschmidt@gmail.com>
parents: 1355
diff changeset
49
9dfff82dfc59 finish postgres work
Franklin Schmidt <fschmidt@gmail.com>
parents: 1355
diff changeset
50 local function form()
9dfff82dfc59 finish postgres work
Franklin Schmidt <fschmidt@gmail.com>
parents: 1355
diff changeset
51 %>
9dfff82dfc59 finish postgres work
Franklin Schmidt <fschmidt@gmail.com>
parents: 1355
diff changeset
52 <!doctype html>
9dfff82dfc59 finish postgres work
Franklin Schmidt <fschmidt@gmail.com>
parents: 1355
diff changeset
53 <html>
9dfff82dfc59 finish postgres work
Franklin Schmidt <fschmidt@gmail.com>
parents: 1355
diff changeset
54 <head>
9dfff82dfc59 finish postgres work
Franklin Schmidt <fschmidt@gmail.com>
parents: 1355
diff changeset
55 <title>Lucene</title>
9dfff82dfc59 finish postgres work
Franklin Schmidt <fschmidt@gmail.com>
parents: 1355
diff changeset
56 <style>
9dfff82dfc59 finish postgres work
Franklin Schmidt <fschmidt@gmail.com>
parents: 1355
diff changeset
57 <% style() %>
561
363d07e26549 remove SimplyHTML from lucene/Web_search
Franklin Schmidt <fschmidt@gmail.com>
parents: 550
diff changeset
58 </style>
391
2f5cc9c2cbf0 replace Html.simply_html_page with simply_html_head and simply_html_body_bottom
Franklin Schmidt <fschmidt@gmail.com>
parents: 340
diff changeset
59 </head>
2f5cc9c2cbf0 replace Html.simply_html_page with simply_html_head and simply_html_body_bottom
Franklin Schmidt <fschmidt@gmail.com>
parents: 340
diff changeset
60 <body>
561
363d07e26549 remove SimplyHTML from lucene/Web_search
Franklin Schmidt <fschmidt@gmail.com>
parents: 550
diff changeset
61 <h2>Lucene Query</h2>
1395
9dfff82dfc59 finish postgres work
Franklin Schmidt <fschmidt@gmail.com>
parents: 1355
diff changeset
62 <form>
561
363d07e26549 remove SimplyHTML from lucene/Web_search
Franklin Schmidt <fschmidt@gmail.com>
parents: 550
diff changeset
63 <div>
363d07e26549 remove SimplyHTML from lucene/Web_search
Franklin Schmidt <fschmidt@gmail.com>
parents: 550
diff changeset
64 <label>Query:</label>
1395
9dfff82dfc59 finish postgres work
Franklin Schmidt <fschmidt@gmail.com>
parents: 1355
diff changeset
65 <input type=text name="query" size="80" autofocus>
561
363d07e26549 remove SimplyHTML from lucene/Web_search
Franklin Schmidt <fschmidt@gmail.com>
parents: 550
diff changeset
66 </div>
363d07e26549 remove SimplyHTML from lucene/Web_search
Franklin Schmidt <fschmidt@gmail.com>
parents: 550
diff changeset
67 <div>
363d07e26549 remove SimplyHTML from lucene/Web_search
Franklin Schmidt <fschmidt@gmail.com>
parents: 550
diff changeset
68 <label></label>
363d07e26549 remove SimplyHTML from lucene/Web_search
Franklin Schmidt <fschmidt@gmail.com>
parents: 550
diff changeset
69 <span tip>Query examples: <i>type:user</i> or <i>+type:user +name:Joe"</i></span>
363d07e26549 remove SimplyHTML from lucene/Web_search
Franklin Schmidt <fschmidt@gmail.com>
parents: 550
diff changeset
70 </div>
363d07e26549 remove SimplyHTML from lucene/Web_search
Franklin Schmidt <fschmidt@gmail.com>
parents: 550
diff changeset
71 <div>
363d07e26549 remove SimplyHTML from lucene/Web_search
Franklin Schmidt <fschmidt@gmail.com>
parents: 550
diff changeset
72 <label>Max Rows:</label>
1395
9dfff82dfc59 finish postgres work
Franklin Schmidt <fschmidt@gmail.com>
parents: 1355
diff changeset
73 <input type=text name="rows" value="100" size="3" maxlength="5">
561
363d07e26549 remove SimplyHTML from lucene/Web_search
Franklin Schmidt <fschmidt@gmail.com>
parents: 550
diff changeset
74 </div>
363d07e26549 remove SimplyHTML from lucene/Web_search
Franklin Schmidt <fschmidt@gmail.com>
parents: 550
diff changeset
75 <div>
363d07e26549 remove SimplyHTML from lucene/Web_search
Franklin Schmidt <fschmidt@gmail.com>
parents: 550
diff changeset
76 <label>Sort:</label>
1395
9dfff82dfc59 finish postgres work
Franklin Schmidt <fschmidt@gmail.com>
parents: 1355
diff changeset
77 <input type=text name="sort" size="60">
561
363d07e26549 remove SimplyHTML from lucene/Web_search
Franklin Schmidt <fschmidt@gmail.com>
parents: 550
diff changeset
78 </div>
363d07e26549 remove SimplyHTML from lucene/Web_search
Franklin Schmidt <fschmidt@gmail.com>
parents: 550
diff changeset
79 <div>
363d07e26549 remove SimplyHTML from lucene/Web_search
Franklin Schmidt <fschmidt@gmail.com>
parents: 550
diff changeset
80 <label></label>
363d07e26549 remove SimplyHTML from lucene/Web_search
Franklin Schmidt <fschmidt@gmail.com>
parents: 550
diff changeset
81 <span tip>Sort examples: <i>name, id</i></span>
363d07e26549 remove SimplyHTML from lucene/Web_search
Franklin Schmidt <fschmidt@gmail.com>
parents: 550
diff changeset
82 </div>
363d07e26549 remove SimplyHTML from lucene/Web_search
Franklin Schmidt <fschmidt@gmail.com>
parents: 550
diff changeset
83 <div>
363d07e26549 remove SimplyHTML from lucene/Web_search
Franklin Schmidt <fschmidt@gmail.com>
parents: 550
diff changeset
84 <label></label>
1395
9dfff82dfc59 finish postgres work
Franklin Schmidt <fschmidt@gmail.com>
parents: 1355
diff changeset
85 <input type="submit">
561
363d07e26549 remove SimplyHTML from lucene/Web_search
Franklin Schmidt <fschmidt@gmail.com>
parents: 550
diff changeset
86 </div>
363d07e26549 remove SimplyHTML from lucene/Web_search
Franklin Schmidt <fschmidt@gmail.com>
parents: 550
diff changeset
87 </form>
391
2f5cc9c2cbf0 replace Html.simply_html_page with simply_html_head and simply_html_body_bottom
Franklin Schmidt <fschmidt@gmail.com>
parents: 340
diff changeset
88 </body>
2f5cc9c2cbf0 replace Html.simply_html_page with simply_html_head and simply_html_body_bottom
Franklin Schmidt <fschmidt@gmail.com>
parents: 340
diff changeset
89 </html>
1395
9dfff82dfc59 finish postgres work
Franklin Schmidt <fschmidt@gmail.com>
parents: 1355
diff changeset
90 <%
9dfff82dfc59 finish postgres work
Franklin Schmidt <fschmidt@gmail.com>
parents: 1355
diff changeset
91 end
391
2f5cc9c2cbf0 replace Html.simply_html_page with simply_html_head and simply_html_body_bottom
Franklin Schmidt <fschmidt@gmail.com>
parents: 340
diff changeset
92
2f5cc9c2cbf0 replace Html.simply_html_page with simply_html_head and simply_html_body_bottom
Franklin Schmidt <fschmidt@gmail.com>
parents: 340
diff changeset
93
1395
9dfff82dfc59 finish postgres work
Franklin Schmidt <fschmidt@gmail.com>
parents: 1355
diff changeset
94 local function index_of(tbl,val)
9dfff82dfc59 finish postgres work
Franklin Schmidt <fschmidt@gmail.com>
parents: 1355
diff changeset
95 for i, v in ipairs(tbl) do
9dfff82dfc59 finish postgres work
Franklin Schmidt <fschmidt@gmail.com>
parents: 1355
diff changeset
96 if v == val then
9dfff82dfc59 finish postgres work
Franklin Schmidt <fschmidt@gmail.com>
parents: 1355
diff changeset
97 return i
9dfff82dfc59 finish postgres work
Franklin Schmidt <fschmidt@gmail.com>
parents: 1355
diff changeset
98 end
9dfff82dfc59 finish postgres work
Franklin Schmidt <fschmidt@gmail.com>
parents: 1355
diff changeset
99 end
9dfff82dfc59 finish postgres work
Franklin Schmidt <fschmidt@gmail.com>
parents: 1355
diff changeset
100 local n = #tbl + 1
9dfff82dfc59 finish postgres work
Franklin Schmidt <fschmidt@gmail.com>
parents: 1355
diff changeset
101 tbl[n] = val
9dfff82dfc59 finish postgres work
Franklin Schmidt <fschmidt@gmail.com>
parents: 1355
diff changeset
102 return n
9dfff82dfc59 finish postgres work
Franklin Schmidt <fschmidt@gmail.com>
parents: 1355
diff changeset
103 end
9dfff82dfc59 finish postgres work
Franklin Schmidt <fschmidt@gmail.com>
parents: 1355
diff changeset
104
9dfff82dfc59 finish postgres work
Franklin Schmidt <fschmidt@gmail.com>
parents: 1355
diff changeset
105 local function result(index)
9dfff82dfc59 finish postgres work
Franklin Schmidt <fschmidt@gmail.com>
parents: 1355
diff changeset
106 local query = Http.request.parameters.query
9dfff82dfc59 finish postgres work
Franklin Schmidt <fschmidt@gmail.com>
parents: 1355
diff changeset
107 local rows = string_to_number(Http.request.parameters.rows)
9dfff82dfc59 finish postgres work
Franklin Schmidt <fschmidt@gmail.com>
parents: 1355
diff changeset
108 local sort = Http.request.parameters.sort
9dfff82dfc59 finish postgres work
Franklin Schmidt <fschmidt@gmail.com>
parents: 1355
diff changeset
109 local results = index.search(query,1,rows,{sort=sort})
9dfff82dfc59 finish postgres work
Franklin Schmidt <fschmidt@gmail.com>
parents: 1355
diff changeset
110 local headers = {}
9dfff82dfc59 finish postgres work
Franklin Schmidt <fschmidt@gmail.com>
parents: 1355
diff changeset
111 local table = {}
9dfff82dfc59 finish postgres work
Franklin Schmidt <fschmidt@gmail.com>
parents: 1355
diff changeset
112 for _, doc in ipairs(results) do
9dfff82dfc59 finish postgres work
Franklin Schmidt <fschmidt@gmail.com>
parents: 1355
diff changeset
113 local row = {}
9dfff82dfc59 finish postgres work
Franklin Schmidt <fschmidt@gmail.com>
parents: 1355
diff changeset
114 for field, value in pairs(doc) do
9dfff82dfc59 finish postgres work
Franklin Schmidt <fschmidt@gmail.com>
parents: 1355
diff changeset
115 row[index_of(headers,field)] = value
9dfff82dfc59 finish postgres work
Franklin Schmidt <fschmidt@gmail.com>
parents: 1355
diff changeset
116 end
9dfff82dfc59 finish postgres work
Franklin Schmidt <fschmidt@gmail.com>
parents: 1355
diff changeset
117 row.doc = doc
9dfff82dfc59 finish postgres work
Franklin Schmidt <fschmidt@gmail.com>
parents: 1355
diff changeset
118 table[#table+1] = row
9dfff82dfc59 finish postgres work
Franklin Schmidt <fschmidt@gmail.com>
parents: 1355
diff changeset
119 end
9dfff82dfc59 finish postgres work
Franklin Schmidt <fschmidt@gmail.com>
parents: 1355
diff changeset
120 local can_edit = index.completer ~= nil
9dfff82dfc59 finish postgres work
Franklin Schmidt <fschmidt@gmail.com>
parents: 1355
diff changeset
121 %>
1216
5dbb552075ff doctype
Franklin Schmidt <fschmidt@gmail.com>
parents: 1189
diff changeset
122 <!doctype html>
391
2f5cc9c2cbf0 replace Html.simply_html_page with simply_html_head and simply_html_body_bottom
Franklin Schmidt <fschmidt@gmail.com>
parents: 340
diff changeset
123 <html>
2f5cc9c2cbf0 replace Html.simply_html_page with simply_html_head and simply_html_body_bottom
Franklin Schmidt <fschmidt@gmail.com>
parents: 340
diff changeset
124 <head>
1395
9dfff82dfc59 finish postgres work
Franklin Schmidt <fschmidt@gmail.com>
parents: 1355
diff changeset
125 <title>Lucene</title>
561
363d07e26549 remove SimplyHTML from lucene/Web_search
Franklin Schmidt <fschmidt@gmail.com>
parents: 550
diff changeset
126 <style>
1395
9dfff82dfc59 finish postgres work
Franklin Schmidt <fschmidt@gmail.com>
parents: 1355
diff changeset
127 <% style() %>
561
363d07e26549 remove SimplyHTML from lucene/Web_search
Franklin Schmidt <fschmidt@gmail.com>
parents: 550
diff changeset
128 table {
363d07e26549 remove SimplyHTML from lucene/Web_search
Franklin Schmidt <fschmidt@gmail.com>
parents: 550
diff changeset
129 border-collapse: collapse;
363d07e26549 remove SimplyHTML from lucene/Web_search
Franklin Schmidt <fschmidt@gmail.com>
parents: 550
diff changeset
130 width: 100%;
363d07e26549 remove SimplyHTML from lucene/Web_search
Franklin Schmidt <fschmidt@gmail.com>
parents: 550
diff changeset
131 font-size: smaller;
363d07e26549 remove SimplyHTML from lucene/Web_search
Franklin Schmidt <fschmidt@gmail.com>
parents: 550
diff changeset
132 }
363d07e26549 remove SimplyHTML from lucene/Web_search
Franklin Schmidt <fschmidt@gmail.com>
parents: 550
diff changeset
133 th, td {
363d07e26549 remove SimplyHTML from lucene/Web_search
Franklin Schmidt <fschmidt@gmail.com>
parents: 550
diff changeset
134 text-align: left;
363d07e26549 remove SimplyHTML from lucene/Web_search
Franklin Schmidt <fschmidt@gmail.com>
parents: 550
diff changeset
135 padding: .5em;
363d07e26549 remove SimplyHTML from lucene/Web_search
Franklin Schmidt <fschmidt@gmail.com>
parents: 550
diff changeset
136 border: solid 1px #ddd;
363d07e26549 remove SimplyHTML from lucene/Web_search
Franklin Schmidt <fschmidt@gmail.com>
parents: 550
diff changeset
137 }
363d07e26549 remove SimplyHTML from lucene/Web_search
Franklin Schmidt <fschmidt@gmail.com>
parents: 550
diff changeset
138 </style>
391
2f5cc9c2cbf0 replace Html.simply_html_page with simply_html_head and simply_html_body_bottom
Franklin Schmidt <fschmidt@gmail.com>
parents: 340
diff changeset
139 </head>
2f5cc9c2cbf0 replace Html.simply_html_page with simply_html_head and simply_html_body_bottom
Franklin Schmidt <fschmidt@gmail.com>
parents: 340
diff changeset
140 <body>
1395
9dfff82dfc59 finish postgres work
Franklin Schmidt <fschmidt@gmail.com>
parents: 1355
diff changeset
141 <h2>Lucene Results</h2>
1407
1979cff9aad2 add sql/Web_query
Franklin Schmidt <fschmidt@gmail.com>
parents: 1395
diff changeset
142 <p><label>Query:</label> <b><%=html_encode(query)%></b></p>
1979cff9aad2 add sql/Web_query
Franklin Schmidt <fschmidt@gmail.com>
parents: 1395
diff changeset
143 <p><label>Sort:</label> <b><%=html_encode(sort)%></b></p>
561
363d07e26549 remove SimplyHTML from lucene/Web_search
Franklin Schmidt <fschmidt@gmail.com>
parents: 550
diff changeset
144 <table>
363d07e26549 remove SimplyHTML from lucene/Web_search
Franklin Schmidt <fschmidt@gmail.com>
parents: 550
diff changeset
145 <tr>
363d07e26549 remove SimplyHTML from lucene/Web_search
Franklin Schmidt <fschmidt@gmail.com>
parents: 550
diff changeset
146 <th></th>
1395
9dfff82dfc59 finish postgres work
Franklin Schmidt <fschmidt@gmail.com>
parents: 1355
diff changeset
147 <% for _, header in ipairs(headers) do %>
561
363d07e26549 remove SimplyHTML from lucene/Web_search
Franklin Schmidt <fschmidt@gmail.com>
parents: 550
diff changeset
148 <th><%=header%></th>
1395
9dfff82dfc59 finish postgres work
Franklin Schmidt <fschmidt@gmail.com>
parents: 1355
diff changeset
149 <% end %>
561
363d07e26549 remove SimplyHTML from lucene/Web_search
Franklin Schmidt <fschmidt@gmail.com>
parents: 550
diff changeset
150 </tr>
1395
9dfff82dfc59 finish postgres work
Franklin Schmidt <fschmidt@gmail.com>
parents: 1355
diff changeset
151 <%
9dfff82dfc59 finish postgres work
Franklin Schmidt <fschmidt@gmail.com>
parents: 1355
diff changeset
152 for i, row in ipairs(table) do
9dfff82dfc59 finish postgres work
Franklin Schmidt <fschmidt@gmail.com>
parents: 1355
diff changeset
153 local id = row.doc.id
9dfff82dfc59 finish postgres work
Franklin Schmidt <fschmidt@gmail.com>
parents: 1355
diff changeset
154 %>
391
2f5cc9c2cbf0 replace Html.simply_html_page with simply_html_head and simply_html_body_bottom
Franklin Schmidt <fschmidt@gmail.com>
parents: 340
diff changeset
155 <tr>
1395
9dfff82dfc59 finish postgres work
Franklin Schmidt <fschmidt@gmail.com>
parents: 1355
diff changeset
156 <td>
9dfff82dfc59 finish postgres work
Franklin Schmidt <fschmidt@gmail.com>
parents: 1355
diff changeset
157 <% if can_edit and id~=nil then %>
9dfff82dfc59 finish postgres work
Franklin Schmidt <fschmidt@gmail.com>
parents: 1355
diff changeset
158 <a href="?id=<%=id%>"><%=i%></a>
9dfff82dfc59 finish postgres work
Franklin Schmidt <fschmidt@gmail.com>
parents: 1355
diff changeset
159 <% else %>
9dfff82dfc59 finish postgres work
Franklin Schmidt <fschmidt@gmail.com>
parents: 1355
diff changeset
160 <%=i%>
9dfff82dfc59 finish postgres work
Franklin Schmidt <fschmidt@gmail.com>
parents: 1355
diff changeset
161 <% end %>
9dfff82dfc59 finish postgres work
Franklin Schmidt <fschmidt@gmail.com>
parents: 1355
diff changeset
162 </td>
9dfff82dfc59 finish postgres work
Franklin Schmidt <fschmidt@gmail.com>
parents: 1355
diff changeset
163 <%
561
363d07e26549 remove SimplyHTML from lucene/Web_search
Franklin Schmidt <fschmidt@gmail.com>
parents: 550
diff changeset
164 for col in range(1, #headers) do
363d07e26549 remove SimplyHTML from lucene/Web_search
Franklin Schmidt <fschmidt@gmail.com>
parents: 550
diff changeset
165 local val = row[col]
1189
73d754b1889f add stringify
Franklin Schmidt <fschmidt@gmail.com>
parents: 1152
diff changeset
166 %><td><%= val and stringify(val) or "" %></td><%
561
363d07e26549 remove SimplyHTML from lucene/Web_search
Franklin Schmidt <fschmidt@gmail.com>
parents: 550
diff changeset
167 end
1395
9dfff82dfc59 finish postgres work
Franklin Schmidt <fschmidt@gmail.com>
parents: 1355
diff changeset
168 %>
391
2f5cc9c2cbf0 replace Html.simply_html_page with simply_html_head and simply_html_body_bottom
Franklin Schmidt <fschmidt@gmail.com>
parents: 340
diff changeset
169 </tr>
1395
9dfff82dfc59 finish postgres work
Franklin Schmidt <fschmidt@gmail.com>
parents: 1355
diff changeset
170 <% end %>
561
363d07e26549 remove SimplyHTML from lucene/Web_search
Franklin Schmidt <fschmidt@gmail.com>
parents: 550
diff changeset
171 </table>
391
2f5cc9c2cbf0 replace Html.simply_html_page with simply_html_head and simply_html_body_bottom
Franklin Schmidt <fschmidt@gmail.com>
parents: 340
diff changeset
172 </body>
2f5cc9c2cbf0 replace Html.simply_html_page with simply_html_head and simply_html_body_bottom
Franklin Schmidt <fschmidt@gmail.com>
parents: 340
diff changeset
173 </html>
1395
9dfff82dfc59 finish postgres work
Franklin Schmidt <fschmidt@gmail.com>
parents: 1355
diff changeset
174 <%
9dfff82dfc59 finish postgres work
Franklin Schmidt <fschmidt@gmail.com>
parents: 1355
diff changeset
175 end
285
582e8db4cdb6 add lucene Web_search
fschmidt@gmail.com <fschmidt@gmail.com@21e917c8-12df-6dd8-5cb6-c86387c605b9>
parents:
diff changeset
176
582e8db4cdb6 add lucene Web_search
fschmidt@gmail.com <fschmidt@gmail.com@21e917c8-12df-6dd8-5cb6-c86387c605b9>
parents:
diff changeset
177
1395
9dfff82dfc59 finish postgres work
Franklin Schmidt <fschmidt@gmail.com>
parents: 1355
diff changeset
178 local function edit(index)
9dfff82dfc59 finish postgres work
Franklin Schmidt <fschmidt@gmail.com>
parents: 1355
diff changeset
179 local id = string_to_number(Http.request.parameters.id)
9dfff82dfc59 finish postgres work
Franklin Schmidt <fschmidt@gmail.com>
parents: 1355
diff changeset
180 local doc = index.get_document("id:"..id)
9dfff82dfc59 finish postgres work
Franklin Schmidt <fschmidt@gmail.com>
parents: 1355
diff changeset
181 doc = stringify(doc,{strict=true,number_types=true})
9dfff82dfc59 finish postgres work
Franklin Schmidt <fschmidt@gmail.com>
parents: 1355
diff changeset
182 %>
9dfff82dfc59 finish postgres work
Franklin Schmidt <fschmidt@gmail.com>
parents: 1355
diff changeset
183 <!doctype html>
9dfff82dfc59 finish postgres work
Franklin Schmidt <fschmidt@gmail.com>
parents: 1355
diff changeset
184 <html>
9dfff82dfc59 finish postgres work
Franklin Schmidt <fschmidt@gmail.com>
parents: 1355
diff changeset
185 <head>
9dfff82dfc59 finish postgres work
Franklin Schmidt <fschmidt@gmail.com>
parents: 1355
diff changeset
186 <title>Lucene</title>
9dfff82dfc59 finish postgres work
Franklin Schmidt <fschmidt@gmail.com>
parents: 1355
diff changeset
187 <style>
9dfff82dfc59 finish postgres work
Franklin Schmidt <fschmidt@gmail.com>
parents: 1355
diff changeset
188 <% style() %>
9dfff82dfc59 finish postgres work
Franklin Schmidt <fschmidt@gmail.com>
parents: 1355
diff changeset
189 </style>
9dfff82dfc59 finish postgres work
Franklin Schmidt <fschmidt@gmail.com>
parents: 1355
diff changeset
190 </head>
9dfff82dfc59 finish postgres work
Franklin Schmidt <fschmidt@gmail.com>
parents: 1355
diff changeset
191 <body>
9dfff82dfc59 finish postgres work
Franklin Schmidt <fschmidt@gmail.com>
parents: 1355
diff changeset
192 <h2>Lucene Edit</h2>
9dfff82dfc59 finish postgres work
Franklin Schmidt <fschmidt@gmail.com>
parents: 1355
diff changeset
193 <form action="?" method=post>
9dfff82dfc59 finish postgres work
Franklin Schmidt <fschmidt@gmail.com>
parents: 1355
diff changeset
194 <div><textarea name="doc" rows="20" cols="90" autofocus><%=html_encode(doc)%></textarea></div>
9dfff82dfc59 finish postgres work
Franklin Schmidt <fschmidt@gmail.com>
parents: 1355
diff changeset
195 <div><input type="submit" value="Update"></div>
9dfff82dfc59 finish postgres work
Franklin Schmidt <fschmidt@gmail.com>
parents: 1355
diff changeset
196 </form>
9dfff82dfc59 finish postgres work
Franklin Schmidt <fschmidt@gmail.com>
parents: 1355
diff changeset
197 </body>
9dfff82dfc59 finish postgres work
Franklin Schmidt <fschmidt@gmail.com>
parents: 1355
diff changeset
198 </html>
9dfff82dfc59 finish postgres work
Franklin Schmidt <fschmidt@gmail.com>
parents: 1355
diff changeset
199 <%
9dfff82dfc59 finish postgres work
Franklin Schmidt <fschmidt@gmail.com>
parents: 1355
diff changeset
200 end
9dfff82dfc59 finish postgres work
Franklin Schmidt <fschmidt@gmail.com>
parents: 1355
diff changeset
201
9dfff82dfc59 finish postgres work
Franklin Schmidt <fschmidt@gmail.com>
parents: 1355
diff changeset
202
9dfff82dfc59 finish postgres work
Franklin Schmidt <fschmidt@gmail.com>
parents: 1355
diff changeset
203 local function update(index)
9dfff82dfc59 finish postgres work
Franklin Schmidt <fschmidt@gmail.com>
parents: 1355
diff changeset
204 local doc = Http.request.parameters.doc
9dfff82dfc59 finish postgres work
Franklin Schmidt <fschmidt@gmail.com>
parents: 1355
diff changeset
205 local completer = index.completer or error()
9dfff82dfc59 finish postgres work
Franklin Schmidt <fschmidt@gmail.com>
parents: 1355
diff changeset
206 doc = eval( doc, "lucene", Number )
9dfff82dfc59 finish postgres work
Franklin Schmidt <fschmidt@gmail.com>
parents: 1355
diff changeset
207 doc = completer(doc)
9dfff82dfc59 finish postgres work
Franklin Schmidt <fschmidt@gmail.com>
parents: 1355
diff changeset
208 index.save(doc)
9dfff82dfc59 finish postgres work
Franklin Schmidt <fschmidt@gmail.com>
parents: 1355
diff changeset
209 %>
9dfff82dfc59 finish postgres work
Franklin Schmidt <fschmidt@gmail.com>
parents: 1355
diff changeset
210 <!doctype html>
9dfff82dfc59 finish postgres work
Franklin Schmidt <fschmidt@gmail.com>
parents: 1355
diff changeset
211 <html>
9dfff82dfc59 finish postgres work
Franklin Schmidt <fschmidt@gmail.com>
parents: 1355
diff changeset
212 <head>
9dfff82dfc59 finish postgres work
Franklin Schmidt <fschmidt@gmail.com>
parents: 1355
diff changeset
213 <title>Lucene</title>
9dfff82dfc59 finish postgres work
Franklin Schmidt <fschmidt@gmail.com>
parents: 1355
diff changeset
214 <style>
9dfff82dfc59 finish postgres work
Franklin Schmidt <fschmidt@gmail.com>
parents: 1355
diff changeset
215 <% style() %>
9dfff82dfc59 finish postgres work
Franklin Schmidt <fschmidt@gmail.com>
parents: 1355
diff changeset
216 </style>
9dfff82dfc59 finish postgres work
Franklin Schmidt <fschmidt@gmail.com>
parents: 1355
diff changeset
217 </head>
9dfff82dfc59 finish postgres work
Franklin Schmidt <fschmidt@gmail.com>
parents: 1355
diff changeset
218 <body>
9dfff82dfc59 finish postgres work
Franklin Schmidt <fschmidt@gmail.com>
parents: 1355
diff changeset
219 <h2>Lucene Updated</h2>
9dfff82dfc59 finish postgres work
Franklin Schmidt <fschmidt@gmail.com>
parents: 1355
diff changeset
220 </body>
9dfff82dfc59 finish postgres work
Franklin Schmidt <fschmidt@gmail.com>
parents: 1355
diff changeset
221 </html>
9dfff82dfc59 finish postgres work
Franklin Schmidt <fschmidt@gmail.com>
parents: 1355
diff changeset
222 <%
285
582e8db4cdb6 add lucene Web_search
fschmidt@gmail.com <fschmidt@gmail.com@21e917c8-12df-6dd8-5cb6-c86387c605b9>
parents:
diff changeset
223 end
582e8db4cdb6 add lucene Web_search
fschmidt@gmail.com <fschmidt@gmail.com@21e917c8-12df-6dd8-5cb6-c86387c605b9>
parents:
diff changeset
224
582e8db4cdb6 add lucene Web_search
fschmidt@gmail.com <fschmidt@gmail.com@21e917c8-12df-6dd8-5cb6-c86387c605b9>
parents:
diff changeset
225
1088
bae2d0c2576c change module naming convention
Franklin Schmidt <fschmidt@gmail.com>
parents: 775
diff changeset
226 function Web_search.of(index)
549
Franklin Schmidt <fschmidt@gmail.com>
parents: 548
diff changeset
227 index or error "index is nil"
285
582e8db4cdb6 add lucene Web_search
fschmidt@gmail.com <fschmidt@gmail.com@21e917c8-12df-6dd8-5cb6-c86387c605b9>
parents:
diff changeset
228
505
7bc63886d4f2 web page modules now return a function
Franklin Schmidt <fschmidt@gmail.com>
parents: 503
diff changeset
229 return function()
285
582e8db4cdb6 add lucene Web_search
fschmidt@gmail.com <fschmidt@gmail.com@21e917c8-12df-6dd8-5cb6-c86387c605b9>
parents:
diff changeset
230 Io.stdout = Http.response.text_writer()
1152
21d157b153fe change http parameters interface
Franklin Schmidt <fschmidt@gmail.com>
parents: 1088
diff changeset
231 local query = Http.request.parameters.query
1395
9dfff82dfc59 finish postgres work
Franklin Schmidt <fschmidt@gmail.com>
parents: 1355
diff changeset
232 if Http.request.parameters.query ~= nil then
9dfff82dfc59 finish postgres work
Franklin Schmidt <fschmidt@gmail.com>
parents: 1355
diff changeset
233 result(index)
9dfff82dfc59 finish postgres work
Franklin Schmidt <fschmidt@gmail.com>
parents: 1355
diff changeset
234 elseif Http.request.parameters.id ~= nil then
9dfff82dfc59 finish postgres work
Franklin Schmidt <fschmidt@gmail.com>
parents: 1355
diff changeset
235 edit(index)
9dfff82dfc59 finish postgres work
Franklin Schmidt <fschmidt@gmail.com>
parents: 1355
diff changeset
236 elseif Http.request.parameters.doc ~= nil then
9dfff82dfc59 finish postgres work
Franklin Schmidt <fschmidt@gmail.com>
parents: 1355
diff changeset
237 update(index)
9dfff82dfc59 finish postgres work
Franklin Schmidt <fschmidt@gmail.com>
parents: 1355
diff changeset
238 else
285
582e8db4cdb6 add lucene Web_search
fschmidt@gmail.com <fschmidt@gmail.com@21e917c8-12df-6dd8-5cb6-c86387c605b9>
parents:
diff changeset
239 form()
582e8db4cdb6 add lucene Web_search
fschmidt@gmail.com <fschmidt@gmail.com@21e917c8-12df-6dd8-5cb6-c86387c605b9>
parents:
diff changeset
240 end
505
7bc63886d4f2 web page modules now return a function
Franklin Schmidt <fschmidt@gmail.com>
parents: 503
diff changeset
241 end
285
582e8db4cdb6 add lucene Web_search
fschmidt@gmail.com <fschmidt@gmail.com@21e917c8-12df-6dd8-5cb6-c86387c605b9>
parents:
diff changeset
242
582e8db4cdb6 add lucene Web_search
fschmidt@gmail.com <fschmidt@gmail.com@21e917c8-12df-6dd8-5cb6-c86387c605b9>
parents:
diff changeset
243 end
503
92c3d22745b8 make _ENV optional
Franklin Schmidt <fschmidt@gmail.com>
parents: 497
diff changeset
244
1088
bae2d0c2576c change module naming convention
Franklin Schmidt <fschmidt@gmail.com>
parents: 775
diff changeset
245 return Web_search