/[SQLSession]/trunk
This is repository of my old source code which isn't updated any more. Go to git.rot13.org for current projects!
ViewVC logotype

Log of /trunk

View Directory Listing Directory Listing


Sticky Revision:

Revision 118 - Directory Listing
Modified Sun Jun 1 00:34:09 2008 UTC (14 years, 4 months ago) by dpavlin
use more modern Jifty User plugin

Revision 117 - Directory Listing
Modified Thu Mar 27 00:20:44 2008 UTC (14 years, 6 months ago) by dpavlin
make it somewhat work on latest jifty

Revision 116 - Directory Listing
Modified Sat Sep 8 11:58:41 2007 UTC (15 years ago) by dpavlin
tweak

Revision 115 - Directory Listing
Modified Fri Apr 27 23:49:22 2007 UTC (15 years, 5 months ago) by dpavlin
make invisible queries darker

Revision 114 - Directory Listing
Modified Fri Apr 13 10:22:23 2007 UTC (15 years, 5 months ago) by dpavlin
move export CVS in between buttons

Revision 113 - Directory Listing
Modified Wed Apr 11 21:09:52 2007 UTC (15 years, 5 months ago) by dpavlin
added CSV export of results

Revision 112 - Directory Listing
Modified Wed Apr 11 20:07:55 2007 UTC (15 years, 5 months ago) by dpavlin
cleanup

Revision 111 - Directory Listing
Modified Wed Apr 11 19:18:22 2007 UTC (15 years, 5 months ago) by dpavlin
added moodle

Revision 110 - Directory Listing
Modified Mon Apr 9 21:54:06 2007 UTC (15 years, 5 months ago) by dpavlin
create spy directory if needed

Revision 109 - Directory Listing
Modified Mon Apr 9 21:53:50 2007 UTC (15 years, 5 months ago) by dpavlin
added union

Revision 108 - Directory Listing
Modified Sun Apr 1 12:52:28 2007 UTC (15 years, 6 months ago) by dpavlin
added password reminder

Revision 107 - Directory Listing
Modified Thu Mar 15 18:58:27 2007 UTC (15 years, 6 months ago) by dpavlin
create new query in correct database

Revision 106 - Directory Listing
Modified Thu Mar 15 12:43:55 2007 UTC (15 years, 6 months ago) by dpavlin
fix schema to work with latest Jifty

Revision 105 - Directory Listing
Modified Sat Feb 17 00:24:08 2007 UTC (15 years, 7 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 (15 years, 7 months ago) by dpavlin
additional databases

Revision 103 - Directory Listing
Modified Sat Feb 17 00:09:21 2007 UTC (15 years, 7 months ago) by dpavlin
make tests pass

Revision 102 - Directory Listing
Modified Fri Feb 16 23:40:21 2007 UTC (15 years, 7 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 (15 years, 7 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 (15 years, 7 months ago) by dpavlin
and in template

Revision 99 - Directory Listing
Modified Fri Feb 16 22:20:41 2007 UTC (15 years, 7 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 (15 years, 7 months ago) by dpavlin
additional debug point (commented)

Revision 97 - Directory Listing
Modified Fri Feb 16 21:06:34 2007 UTC (15 years, 7 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 (15 years, 7 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 (15 years, 7 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 (15 years, 7 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 (15 years, 7 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 (15 years, 7 months ago) by dpavlin
minor cleanp

Revision 91 - Directory Listing
Modified Mon Feb 5 21:29:48 2007 UTC (15 years, 7 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 (15 years, 7 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 (15 years, 7 months ago) by dpavlin
custom Log4perl config file

Revision 88 - Directory Listing
Modified Mon Feb 5 18:46:13 2007 UTC (15 years, 7 months ago) by dpavlin
hush warns, move some to debug log

Revision 87 - Directory Listing
Modified Mon Feb 5 18:27:46 2007 UTC (15 years, 7 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 (15 years, 8 months ago) by dpavlin
fix sort without selected database

Revision 85 - Directory Listing
Modified Tue Jan 30 14:14:19 2007 UTC (15 years, 8 months ago) by dpavlin
hide schema link if unknown

Revision 84 - Directory Listing
Modified Tue Jan 30 14:08:47 2007 UTC (15 years, 8 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 (15 years, 8 months ago) by dpavlin
fix feed entry links

Revision 82 - Directory Listing
Modified Mon Jan 29 21:43:06 2007 UTC (15 years, 8 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 (15 years, 8 months ago) by dpavlin
layout sql_query as pre

Revision 80 - Directory Listing
Modified Mon Jan 29 21:09:51 2007 UTC (15 years, 8 months ago) by dpavlin
hush debug output

Revision 79 - Directory Listing
Modified Mon Jan 29 20:46:20 2007 UTC (15 years, 8 months ago) by dpavlin
added RSS feeds, enable Jifty::Plugin::EditInPlace

Revision 78 - Directory Listing
Modified Mon Jan 29 20:11:20 2007 UTC (15 years, 8 months ago) by dpavlin
re-organize SQL query page into fragments

Revision 77 - Directory Listing
Modified Sun Jan 28 15:24:42 2007 UTC (15 years, 8 months ago) by dpavlin
converted list to region, added order links

Revision 76 - Directory Listing
Modified Sun Jan 28 14:10:52 2007 UTC (15 years, 8 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 (15 years, 8 months ago) by dpavlin
hush

Revision 74 - Directory Listing
Modified Sun Jan 28 00:59:43 2007 UTC (15 years, 8 months ago) by dpavlin
fixed permission model for create

Revision 73 - Directory Listing
Modified Sun Jan 28 00:46:48 2007 UTC (15 years, 8 months ago) by dpavlin
added ?order=name, colors

Revision 72 - Directory Listing
Modified Sun Jan 28 00:36:27 2007 UTC (15 years, 8 months ago) by dpavlin
display query owner and creation date

Revision 71 - Directory Listing
Modified Thu Jan 25 21:16:49 2007 UTC (15 years, 8 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 (15 years, 8 months ago) by dpavlin
more strict uppercasing


Revision 69 - Directory Listing
Modified Thu Jan 25 20:42:11 2007 UTC (15 years, 8 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 (15 years, 8 months ago) by dpavlin
added dellstore2


Revision 67 - Directory Listing
Modified Thu Jan 25 20:29:21 2007 UTC (15 years, 8 months ago) by dpavlin
create new query in current database


Revision 66 - Directory Listing
Modified Thu Jan 25 20:28:42 2007 UTC (15 years, 8 months ago) by dpavlin
display time in seconds with two decimals


Revision 65 - Directory Listing
Modified Thu Jan 25 19:55:30 2007 UTC (15 years, 8 months ago) by dpavlin
top margin on SQL results table


Revision 64 - Directory Listing
Modified Thu Jan 25 19:25:10 2007 UTC (15 years, 8 months ago) by dpavlin
use Model::User sigh!


Revision 63 - Directory Listing
Modified Thu Jan 25 19:16:45 2007 UTC (15 years, 8 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 (15 years, 8 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 (15 years, 8 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 (15 years, 8 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 (15 years, 8 months ago) by dpavlin
return true

Revision 58 - Directory Listing
Modified Thu Jan 25 13:08:06 2007 UTC (15 years, 8 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 (15 years, 8 months ago) by dpavlin
be less chatty

Revision 56 - Directory Listing
Modified Sun Jan 21 22:05:33 2007 UTC (15 years, 8 months ago) by dpavlin
Example for Email::Send::IO

Revision 55 - Directory Listing
Modified Sun Jan 21 19:26:22 2007 UTC (15 years, 8 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 (15 years, 8 months ago) by dpavlin
require login plugin

Revision 53 - Directory Listing
Modified Sun Jan 21 14:00:28 2007 UTC (15 years, 8 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 (15 years, 8 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 (15 years, 8 months ago) by dpavlin
added vacuum after deleteing _jifty_sessions

Revision 50 - Directory Listing
Modified Sun Jan 21 13:31:50 2007 UTC (15 years, 8 months ago) by dpavlin
helper script to erase all sessions

Revision 49 - Directory Listing
Modified Sun Jan 21 13:01:38 2007 UTC (15 years, 8 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 (15 years, 8 months ago) by dpavlin
be less chatty

Revision 47 - Directory Listing
Modified Sun Jan 21 12:41:35 2007 UTC (15 years, 8 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 (15 years, 8 months ago) by dpavlin
login/signup/logout options

Revision 45 - Directory Listing
Modified Sun Jan 21 12:19:58 2007 UTC (15 years, 8 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 (15 years, 8 months ago) by dpavlin
added Login plugin and User model

Revision 43 - Directory Listing
Modified Thu Jan 18 22:04:46 2007 UTC (15 years, 8 months ago) by dpavlin
remove confusing external links

Revision 42 - Directory Listing
Modified Thu Jan 18 18:56:11 2007 UTC (15 years, 8 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 (15 years, 8 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 (15 years, 8 months ago) by dpavlin
sub-menu with databases under list

Revision 39 - Directory Listing
Modified Thu Jan 18 17:53:58 2007 UTC (15 years, 8 months ago) by dpavlin
REST to select database: /list/database/4

Revision 38 - Directory Listing
Modified Thu Jan 18 17:02:24 2007 UTC (15 years, 8 months ago) by dpavlin
slightly better design

Revision 37 - Directory Listing
Modified Thu Jan 18 13:45:34 2007 UTC (15 years, 8 months ago) by dpavlin
added auto_install


Revision 36 - Directory Listing
Modified Thu Jan 18 13:44:58 2007 UTC (15 years, 8 months ago) by dpavlin
cleanup


Revision 35 - Directory Listing
Modified Wed Jan 17 17:24:32 2007 UTC (15 years, 8 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 (15 years, 8 months ago) by dpavlin
bigger edit form

Revision 33 - Directory Listing
Modified Sat Dec 9 01:15:02 2006 UTC (15 years, 9 months ago) by dpavlin
added navigation to new and list...

Revision 32 - Directory Listing
Modified Thu Dec 7 23:45:11 2006 UTC (15 years, 9 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 (15 years, 9 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 (15 years, 9 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 (15 years, 9 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 (15 years, 9 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 (15 years, 9 months ago) by dpavlin
rename action to be consistent with moniker

Revision 26 - Directory Listing
Modified Mon Dec 4 19:24:25 2006 UTC (15 years, 9 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 (15 years, 9 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 (15 years, 9 months ago) by dpavlin
jifty is UTF-8, so...

Revision 23 - Directory Listing
Modified Mon Dec 4 15:15:54 2006 UTC (15 years, 9 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 (15 years, 9 months ago) by dpavlin
re-org of template names

Revision 21 - Directory Listing
Modified Sun Dec 3 19:47:39 2006 UTC (15 years, 9 months ago) by dpavlin
saving of queries now work

Revision 20 - Directory Listing
Modified Sun Dec 3 18:03:30 2006 UTC (15 years, 9 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 (15 years, 9 months ago) by dpavlin
show debug log

Revision 18 - Directory Listing
Modified Sun Dec 3 14:50:23 2006 UTC (15 years, 9 months ago) by dpavlin
list of all queries

Revision 17 - Directory Listing
Modified Sun Dec 3 14:46:08 2006 UTC (15 years, 9 months ago) by dpavlin
tweak model

Revision 16 - Directory Listing
Modified Sun Dec 3 14:25:40 2006 UTC (15 years, 9 months ago) by dpavlin
fix bootstrap data generation

Revision 15 - Directory Listing
Modified Sun Dec 3 14:01:53 2006 UTC (15 years, 9 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 (15 years, 9 months ago) by dpavlin
added save query

Revision 13 - Directory Listing
Modified Sun Dec 3 13:28:48 2006 UTC (15 years, 9 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 (15 years, 9 months ago) by dpavlin
display NULL values

Revision 11 - Directory Listing
Modified Sun Dec 3 00:10:31 2006 UTC (15 years, 9 months ago) by dpavlin
better error reporting

Revision 10 - Directory Listing
Modified Sun Dec 3 00:04:57 2006 UTC (15 years, 9 months ago) by dpavlin
don't display results table without results

Revision 9 - Directory Listing
Modified Sat Dec 2 23:53:00 2006 UTC (15 years, 9 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 (15 years, 9 months ago) by dpavlin
fix validate

Revision 7 - Directory Listing
Modified Sat Dec 2 22:30:43 2006 UTC (15 years, 9 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 (15 years, 9 months ago) by dpavlin
cleanup, this was a Jifty bug

Revision 5 - Directory Listing
Modified Sat Dec 2 14:00:51 2006 UTC (15 years, 9 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 (15 years, 9 months ago) by dpavlin
bootstrap page data

Revision 3 - Directory Listing
Modified Sat Dec 2 00:10:37 2006 UTC (15 years, 10 months ago) by dpavlin
svn:ignore all over the place

Revision 2 - Directory Listing
Modified Sat Dec 2 00:08:50 2006 UTC (15 years, 10 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 (15 years, 10 months ago) by dpavlin
initial import of toy Jifty application


  ViewVC Help
Powered by ViewVC 1.1.26