This is repository of my old source code which isn't updated any more. Go to git.rot13.org for current projects!
Log of /trunk
Directory Listing
Revision
110 -
Directory Listing
Modified
Mon Apr 9 21:54:06 2007 UTC
(17 years, 2 months ago)
by
dpavlin
create spy directory if needed
Revision
109 -
Directory Listing
Modified
Mon Apr 9 21:53:50 2007 UTC
(17 years, 2 months ago)
by
dpavlin
added union
Revision
108 -
Directory Listing
Modified
Sun Apr 1 12:52:28 2007 UTC
(17 years, 2 months ago)
by
dpavlin
added password reminder
Revision
107 -
Directory Listing
Modified
Thu Mar 15 18:58:27 2007 UTC
(17 years, 3 months ago)
by
dpavlin
create new query in correct database
Revision
106 -
Directory Listing
Modified
Thu Mar 15 12:43:55 2007 UTC
(17 years, 3 months ago)
by
dpavlin
fix schema to work with latest Jifty
Revision
105 -
Directory Listing
Modified
Sat Feb 17 00:24:08 2007 UTC
(17 years, 4 months ago)
by
dpavlin
always reformat SQL before sending it in feeds
Revision
104 -
Directory Listing
Modified
Sat Feb 17 00:09:35 2007 UTC
(17 years, 4 months ago)
by
dpavlin
additional databases
Revision
103 -
Directory Listing
Modified
Sat Feb 17 00:09:21 2007 UTC
(17 years, 4 months ago)
by
dpavlin
make tests pass
Revision
102 -
Directory Listing
Modified
Fri Feb 16 23:40:21 2007 UTC
(17 years, 4 months ago)
by
dpavlin
added concept of "parent" query if you started by editing existing one
Revision
101 -
Directory Listing
Modified
Fri Feb 16 22:50:55 2007 UTC
(17 years, 4 months ago)
by
dpavlin
added pretty print option, some comments and cleaned up some cargo cult cruft
Revision
100 -
Directory Listing
Modified
Fri Feb 16 22:21:07 2007 UTC
(17 years, 4 months ago)
by
dpavlin
and in template
Revision
99 -
Directory Listing
Modified
Fri Feb 16 22:20:41 2007 UTC
(17 years, 4 months ago)
by
dpavlin
extract reformat_sql into SQLSession::Utils and use then in canonicalizer
Revision
98 -
Directory Listing
Modified
Fri Feb 16 22:19:53 2007 UTC
(17 years, 4 months ago)
by
dpavlin
additional debug point (commented)
Revision
97 -
Directory Listing
Modified
Fri Feb 16 21:06:34 2007 UTC
(17 years, 4 months ago)
by
dpavlin
anonymous users can't execute action anyway, so my showing them a buttom?
Revision
96 -
Directory Listing
Modified
Mon Feb 5 22:13:07 2007 UTC
(17 years, 4 months ago)
by
dpavlin
respect currently selected database when displaying date filter
Revision
95 -
Directory Listing
Modified
Mon Feb 5 22:06:13 2007 UTC
(17 years, 4 months ago)
by
dpavlin
mark active sub-menus (doesn't seem to work in IE7)
Revision
94 -
Directory Listing
Modified
Mon Feb 5 22:04:59 2007 UTC
(17 years, 4 months ago)
by
dpavlin
mark active entries in sort menu, force results_are_readable for my group by
query so that anonymous users will also see it's results
Revision
93 -
Directory Listing
Modified
Mon Feb 5 21:32:40 2007 UTC
(17 years, 4 months ago)
by
dpavlin
hide date filter if no dates are selectable (for anonymous users) and
document that we have to count rows instead of calling collection->count
Revision
92 -
Directory Listing
Modified
Mon Feb 5 21:31:02 2007 UTC
(17 years, 4 months ago)
by
dpavlin
minor cleanp
Revision
91 -
Directory Listing
Modified
Mon Feb 5 21:29:48 2007 UTC
(17 years, 4 months ago)
by
dpavlin
fix typo to make /database/42 work again
Revision
90 -
Directory Listing
Modified
Mon Feb 5 20:48:15 2007 UTC
(17 years, 4 months ago)
by
dpavlin
converted sorting and date filter into Jifty::Web::Menu
Revision
89 -
Directory Listing
Modified
Mon Feb 5 19:03:28 2007 UTC
(17 years, 4 months ago)
by
dpavlin
custom Log4perl config file
Revision
88 -
Directory Listing
Modified
Mon Feb 5 18:46:13 2007 UTC
(17 years, 4 months ago)
by
dpavlin
hush warns, move some to debug log
Revision
87 -
Directory Listing
Modified
Mon Feb 5 18:27:46 2007 UTC
(17 years, 4 months ago)
by
dpavlin
added REST date filter: /list/date/yyyy-mm-dd
Revision
86 -
Directory Listing
Modified
Tue Jan 30 23:51:09 2007 UTC
(17 years, 4 months ago)
by
dpavlin
fix sort without selected database
Revision
85 -
Directory Listing
Modified
Tue Jan 30 14:14:19 2007 UTC
(17 years, 4 months ago)
by
dpavlin
hide schema link if unknown
Revision
84 -
Directory Listing
Modified
Tue Jan 30 14:08:47 2007 UTC
(17 years, 4 months ago)
by
dpavlin
use on_database parameter for database id throughout all code,
implement save query using tangents and continuations
Revision
83 -
Directory Listing
Modified
Tue Jan 30 12:04:18 2007 UTC
(17 years, 4 months ago)
by
dpavlin
fix feed entry links
Revision
82 -
Directory Listing
Modified
Mon Jan 29 21:43:06 2007 UTC
(17 years, 4 months ago)
by
dpavlin
don't use SQL::ReservedWords in canonicalization. Instead, use small subset
of SQL and do pretty printing also.
Revision
81 -
Directory Listing
Modified
Mon Jan 29 21:37:38 2007 UTC
(17 years, 4 months ago)
by
dpavlin
layout sql_query as pre
Revision
80 -
Directory Listing
Modified
Mon Jan 29 21:09:51 2007 UTC
(17 years, 4 months ago)
by
dpavlin
hush debug output
Revision
79 -
Directory Listing
Modified
Mon Jan 29 20:46:20 2007 UTC
(17 years, 4 months ago)
by
dpavlin
added RSS feeds, enable Jifty::Plugin::EditInPlace
Revision
78 -
Directory Listing
Modified
Mon Jan 29 20:11:20 2007 UTC
(17 years, 4 months ago)
by
dpavlin
re-organize SQL query page into fragments
Revision
77 -
Directory Listing
Modified
Sun Jan 28 15:24:42 2007 UTC
(17 years, 4 months ago)
by
dpavlin
converted list to region, added order links
Revision
76 -
Directory Listing
Modified
Sun Jan 28 14:10:52 2007 UTC
(17 years, 4 months ago)
by
dpavlin
don't re-edit query and database when saving...
Revision
75 -
Directory Listing
Modified
Sun Jan 28 11:36:37 2007 UTC
(17 years, 4 months ago)
by
dpavlin
hush
Revision
74 -
Directory Listing
Modified
Sun Jan 28 00:59:43 2007 UTC
(17 years, 5 months ago)
by
dpavlin
fixed permission model for create
Revision
73 -
Directory Listing
Modified
Sun Jan 28 00:46:48 2007 UTC
(17 years, 5 months ago)
by
dpavlin
added ?order=name, colors
Revision
72 -
Directory Listing
Modified
Sun Jan 28 00:36:27 2007 UTC
(17 years, 5 months ago)
by
dpavlin
display query owner and creation date
Revision
71 -
Directory Listing
Modified
Thu Jan 25 21:16:49 2007 UTC
(17 years, 5 months ago)
by
dpavlin
users with edit role should have right only on visible queries, but superusers on all
Revision
70 -
Directory Listing
Modified
Thu Jan 25 21:16:06 2007 UTC
(17 years, 5 months ago)
by
dpavlin
more strict uppercasing
Revision
69 -
Directory Listing
Modified
Thu Jan 25 20:42:11 2007 UTC
(17 years, 5 months ago)
by
dpavlin
allow all users with confirmed e-mail address to edit and create new queries, thus turning
this application into wiki SQL editor :-)
Revision
68 -
Directory Listing
Modified
Thu Jan 25 20:30:20 2007 UTC
(17 years, 5 months ago)
by
dpavlin
added dellstore2
Revision
67 -
Directory Listing
Modified
Thu Jan 25 20:29:21 2007 UTC
(17 years, 5 months ago)
by
dpavlin
create new query in current database
Revision
66 -
Directory Listing
Modified
Thu Jan 25 20:28:42 2007 UTC
(17 years, 5 months ago)
by
dpavlin
display time in seconds with two decimals
Revision
65 -
Directory Listing
Modified
Thu Jan 25 19:55:30 2007 UTC
(17 years, 5 months ago)
by
dpavlin
top margin on SQL results table
Revision
64 -
Directory Listing
Modified
Thu Jan 25 19:25:10 2007 UTC
(17 years, 5 months ago)
by
dpavlin
use Model::User sigh!
Revision
63 -
Directory Listing
Modified
Thu Jan 25 19:16:45 2007 UTC
(17 years, 5 months ago)
by
dpavlin
move queries limit to current_user_can which is sane
Revision
62 -
Directory Listing
Modified
Thu Jan 25 19:16:18 2007 UTC
(17 years, 5 months ago)
by
dpavlin
if user has role edit it can do anything to this object
Revision
61 -
Directory Listing
Modified
Thu Jan 25 19:05:04 2007 UTC
(17 years, 5 months ago)
by
dpavlin
added columns owner and create_on for Query, some Upgrade code to create admin@example.com
user with admin and edit roles.
Added real current_user_can which is a bit more complicated whan minimal.
Revision
60 -
Directory Listing
Modified
Thu Jan 25 18:19:02 2007 UTC
(17 years, 5 months ago)
by
dpavlin
use internal Jifty's is_superuser to honor AdminMode and make code cleaner
Revision
59 -
Directory Listing
Modified
Thu Jan 25 15:43:02 2007 UTC
(17 years, 5 months ago)
by
dpavlin
return true
Revision
58 -
Directory Listing
Modified
Thu Jan 25 13:08:06 2007 UTC
(17 years, 5 months ago)
by
dpavlin
make current user superuser and create docs+admin navigation for it if (s)he has
admin role. Interesting example of overriding Jifty templates
Revision
57 -
Directory Listing
Modified
Thu Jan 25 12:33:38 2007 UTC
(17 years, 5 months ago)
by
dpavlin
be less chatty
Revision
56 -
Directory Listing
Modified
Sun Jan 21 22:05:33 2007 UTC
(17 years, 5 months ago)
by
dpavlin
Example for Email::Send::IO
Revision
55 -
Directory Listing
Modified
Sun Jan 21 19:26:22 2007 UTC
(17 years, 5 months ago)
by
dpavlin
anonymous users can now only execute SQL queries, and not edit them.
Revision
54 -
Directory Listing
Modified
Sun Jan 21 14:29:39 2007 UTC
(17 years, 5 months ago)
by
dpavlin
require login plugin
Revision
53 -
Directory Listing
Modified
Sun Jan 21 14:00:28 2007 UTC
(17 years, 5 months ago)
by
dpavlin
schema links now open in new window, added schema link to sql edit form
Revision
52 -
Directory Listing
Modified
Sun Jan 21 13:37:17 2007 UTC
(17 years, 5 months ago)
by
dpavlin
display database name even when not in edit mode
Revision
51 -
Directory Listing
Modified
Sun Jan 21 13:32:45 2007 UTC
(17 years, 5 months ago)
by
dpavlin
added vacuum after deleteing _jifty_sessions
Revision
50 -
Directory Listing
Modified
Sun Jan 21 13:31:50 2007 UTC
(17 years, 5 months ago)
by
dpavlin
helper script to erase all sessions
Revision
49 -
Directory Listing
Modified
Sun Jan 21 13:01:38 2007 UTC
(17 years, 5 months ago)
by
dpavlin
set active on link which is active and color it
Revision
48 -
Directory Listing
Modified
Sun Jan 21 13:01:08 2007 UTC
(17 years, 5 months ago)
by
dpavlin
be less chatty
Revision
47 -
Directory Listing
Modified
Sun Jan 21 12:41:35 2007 UTC
(17 years, 5 months ago)
by
dpavlin
added role model and implement checking of roles
Revision
46 -
Directory Listing
Modified
Sun Jan 21 12:40:13 2007 UTC
(17 years, 5 months ago)
by
dpavlin
login/signup/logout options
Revision
45 -
Directory Listing
Modified
Sun Jan 21 12:19:58 2007 UTC
(17 years, 5 months ago)
by
dpavlin
remove edit mode from configuration and create role method within
currentuser for verification (hard-coded for now)
Revision
44 -
Directory Listing
Modified
Sun Jan 21 09:51:52 2007 UTC
(17 years, 5 months ago)
by
dpavlin
added Login plugin and User model
Revision
43 -
Directory Listing
Modified
Thu Jan 18 22:04:46 2007 UTC
(17 years, 5 months ago)
by
dpavlin
remove confusing external links
Revision
42 -
Directory Listing
Modified
Thu Jan 18 18:56:11 2007 UTC
(17 years, 5 months ago)
by
dpavlin
import schemaSpy 3.1.1 and some config scripts
Revision
41 -
Directory Listing
Modified
Thu Jan 18 18:55:17 2007 UTC
(17 years, 5 months ago)
by
dpavlin
integrate schemaSpy using linking method (old pun on one consultant)
Revision
40 -
Directory Listing
Modified
Thu Jan 18 18:16:32 2007 UTC
(17 years, 5 months ago)
by
dpavlin
sub-menu with databases under list
Revision
39 -
Directory Listing
Modified
Thu Jan 18 17:53:58 2007 UTC
(17 years, 5 months ago)
by
dpavlin
REST to select database: /list/database/4
Revision
38 -
Directory Listing
Modified
Thu Jan 18 17:02:24 2007 UTC
(17 years, 5 months ago)
by
dpavlin
slightly better design
Revision
37 -
Directory Listing
Modified
Thu Jan 18 13:45:34 2007 UTC
(17 years, 5 months ago)
by
dpavlin
added auto_install
Revision
36 -
Directory Listing
Modified
Thu Jan 18 13:44:58 2007 UTC
(17 years, 5 months ago)
by
dpavlin
cleanup
Revision
35 -
Directory Listing
Modified
Wed Jan 17 17:24:32 2007 UTC
(17 years, 5 months ago)
by
dpavlin
after simple patch to HTTP::Server::Simple ajax validate and canonicalize
work, added limit and offset as upprecased keywords.
--- HTTP-Server-Simple-0.26/lib/HTTP/Server/Simple.pm 2006-11-26 01:15:39.000000000 +0100
+++ Simple.pm 2007-01-17 18:22:46.000000000 +0100
@@ -305,7 +305,7 @@
$proto ||= "HTTP/0.9";
my ( $file, $query_string )
- = ( $request_uri =~ /([^?]*)(?:\?(.*))?/ ); # split at ?
+ = ( $request_uri =~ /([^?]*)(?:\?(.*))?/s ); # split at ?
$self->setup(
method => $method,
Revision
34 -
Directory Listing
Modified
Wed Jan 17 17:20:32 2007 UTC
(17 years, 5 months ago)
by
dpavlin
bigger edit form
Revision
33 -
Directory Listing
Modified
Sat Dec 9 01:15:02 2006 UTC
(17 years, 6 months ago)
by
dpavlin
added navigation to new and list...
Revision
32 -
Directory Listing
Modified
Thu Dec 7 23:45:11 2006 UTC
(17 years, 6 months ago)
by
dpavlin
show new query and *all* queries in edit mode
Revision
31 -
Directory Listing
Modified
Thu Dec 7 23:22:41 2006 UTC
(17 years, 6 months ago)
by
dpavlin
added visible filed to Query model, so we can hide queries
Revision
30 -
Directory Listing
Modified
Thu Dec 7 23:14:57 2006 UTC
(17 years, 6 months ago)
by
dpavlin
use SET client_encoding = UTF8 only if dsn indicates Pg (PostgreSQL)
Revision
29 -
Directory Listing
Modified
Thu Dec 7 22:13:56 2006 UTC
(17 years, 6 months ago)
by
dpavlin
various tweaks:
- added edit mode to configuration
- turned off ajax (buggy in current Jifty)
- fake current_user_can in models
- order queries by name
Revision
28 -
Directory Listing
Modified
Thu Dec 7 19:56:41 2006 UTC
(17 years, 6 months ago)
by
dpavlin
dodana bilješka uz SQL query, malo CSS-a
Revision
27 -
Directory Listing
Modified
Thu Dec 7 19:51:05 2006 UTC
(17 years, 6 months ago)
by
dpavlin
rename action to be consistent with moniker
Revision
26 -
Directory Listing
Modified
Mon Dec 4 19:24:25 2006 UTC
(17 years, 6 months ago)
by
dpavlin
display maximum of 100 rows, and show note how to get other results
Revision
25 -
Directory Listing
Modified
Mon Dec 4 19:23:30 2006 UTC
(17 years, 6 months ago)
by
dpavlin
custom port 65432 (with kudos to PostgreSQL developers :-)
Revision
24 -
Directory Listing
Modified
Mon Dec 4 19:22:48 2006 UTC
(17 years, 6 months ago)
by
dpavlin
jifty is UTF-8, so...
Revision
23 -
Directory Listing
Modified
Mon Dec 4 15:15:54 2006 UTC
(17 years, 6 months ago)
by
dpavlin
some design (buttons should be buttons), and fixes for save
Revision
22 -
Directory Listing
Modified
Sun Dec 3 19:55:52 2006 UTC
(17 years, 6 months ago)
by
dpavlin
re-org of template names
Revision
21 -
Directory Listing
Modified
Sun Dec 3 19:47:39 2006 UTC
(17 years, 6 months ago)
by
dpavlin
saving of queries now work
Revision
20 -
Directory Listing
Modified
Sun Dec 3 18:03:30 2006 UTC
(17 years, 6 months ago)
by
dpavlin
loading of records from Model::Query now works
Revision
19 -
Directory Listing
Modified
Sun Dec 3 18:02:49 2006 UTC
(17 years, 6 months ago)
by
dpavlin
show debug log
Revision
18 -
Directory Listing
Modified
Sun Dec 3 14:50:23 2006 UTC
(17 years, 6 months ago)
by
dpavlin
list of all queries
Revision
17 -
Directory Listing
Modified
Sun Dec 3 14:46:08 2006 UTC
(17 years, 6 months ago)
by
dpavlin
tweak model
Revision
16 -
Directory Listing
Modified
Sun Dec 3 14:25:40 2006 UTC
(17 years, 6 months ago)
by
dpavlin
fix bootstrap data generation
Revision
15 -
Directory Listing
Modified
Sun Dec 3 14:01:53 2006 UTC
(17 years, 6 months ago)
by
dpavlin
great rename: Model::Page is now Model::Query (which is more sane), tests pass,
bootstrap fills two records for each model
Revision
14 -
Directory Listing
Modified
Sun Dec 3 13:45:00 2006 UTC
(17 years, 6 months ago)
by
dpavlin
added save query
Revision
13 -
Directory Listing
Modified
Sun Dec 3 13:28:48 2006 UTC
(17 years, 6 months ago)
by
dpavlin
canonicize all SQL reserved words to uppercase (has problems with multi-line SQL
queries which is wird -- I suspect Jifty bug, but can't be sure)
Revision
12 -
Directory Listing
Modified
Sun Dec 3 00:12:25 2006 UTC
(17 years, 6 months ago)
by
dpavlin
display NULL values
Revision
11 -
Directory Listing
Modified
Sun Dec 3 00:10:31 2006 UTC
(17 years, 6 months ago)
by
dpavlin
better error reporting
Revision
10 -
Directory Listing
Modified
Sun Dec 3 00:04:57 2006 UTC
(17 years, 6 months ago)
by
dpavlin
don't display results table without results
Revision
9 -
Directory Listing
Modified
Sat Dec 2 23:53:00 2006 UTC
(17 years, 6 months ago)
by
dpavlin
added template which produce SQL results in table from entered SQL query
Revision
8 -
Directory Listing
Modified
Sat Dec 2 22:54:15 2006 UTC
(17 years, 6 months ago)
by
dpavlin
fix validate
Revision
7 -
Directory Listing
Modified
Sat Dec 2 22:30:43 2006 UTC
(17 years, 6 months ago)
by
dpavlin
trivial implementation of action which use DBI to execute SQL query on database
Revision
6 -
Directory Listing
Modified
Sat Dec 2 21:17:46 2006 UTC
(17 years, 6 months ago)
by
dpavlin
cleanup, this was a Jifty bug
Revision
5 -
Directory Listing
Modified
Sat Dec 2 14:00:51 2006 UTC
(17 years, 6 months ago)
by
dpavlin
try to add DoSQL action, but it doesn't show available databases yet
Revision
4 -
Directory Listing
Modified
Sat Dec 2 13:10:08 2006 UTC
(17 years, 6 months ago)
by
dpavlin
bootstrap page data
Revision
3 -
Directory Listing
Modified
Sat Dec 2 00:10:37 2006 UTC
(17 years, 6 months ago)
by
dpavlin
svn:ignore all over the place
Revision
2 -
Directory Listing
Modified
Sat Dec 2 00:08:50 2006 UTC
(17 years, 6 months ago)
by
dpavlin
column dns in M:Database and bootstrap data
Revision
1 -
Directory Listing
Added
Fri Dec 1 23:48:06 2006 UTC
(17 years, 6 months ago)
by
dpavlin
initial import of toy Jifty application