1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
|
# web/lib/ui/test.rb
class Taginfo < Sinatra::Base
get! '/test' do
@title = 'Test'
erb :'test/index'
end
get! '/test/tags' do
section :test
@title = ['Tags', 'Test']
limit = 300;
(@min, @max) = @db.select('SELECT min(count) AS min, max(count) AS max FROM popular_keys').get_columns(:min, :max)
@tags = @db.select("SELECT key, count, (count - ?) / (? - ?) AS scale, in_wiki, in_josm FROM popular_keys ORDER BY count DESC LIMIT #{limit}", @min.to_f, @max, @min).
execute().
each_with_index{ |tag, idx| tag['pos'] = (limit - idx) / limit.to_f }.
sort_by{ |row| row['key'] }
erb :'test/tags'
end
get '/test/wiki_import' do
section :test
@title = ['Wiki Import', 'Test']
@invalid_page_titles = @db.select('SELECT * FROM invalid_page_titles').execute()
@invalid_image_titles = @db.select('SELECT * FROM invalid_image_titles').execute()
erb :'test/wiki_import'
end
get! '/test/potlatch' do
@title = 'Potlatch'
erb :'test/potlatch/index'
end
get '/test/potlatch/categories' do
@title = 'Potlatch Features'
@categories = @db.execute('SELECT * FROM potlatch.categories ORDER BY name')
erb :'test/potlatch/categories'
end
get '/test/potlatch/categories/:category' do
@category = params[:category]
@features = @db.execute('SELECT * FROM potlatch.features WHERE category_id=? ORDER BY name', @category)
erb :'test/potlatch/category', :layout => false
end
get '/test/potlatch/features/:feature' do
@feature_name = params[:feature]
@feature = @db.execute('SELECT * FROM potlatch.features WHERE name=?', @feature_name)[0]
@tags = @db.execute('SELECT * FROM potlatch.tags WHERE feature_name=? ORDER BY key, value', @feature_name)
erb :'test/potlatch/feature', :layout => false
end
get %r{/test/potlatch/icon/(.*)} do |icon|
content_type :png
send_file('../../var/sources/potlatch/resources/' + icon)
end
end
|