/[SQLSession]/trunk/lib/SQLSession
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/lib/SQLSession

View Directory Listing Directory Listing


Sticky Revision:

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

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

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

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

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

Revision 102 - Directory Listing
Modified Fri Feb 16 23:40:21 2007 UTC (17 years, 1 month ago) by dpavlin
added concept of "parent" query if you started by editing existing one

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

Revision 92 - Directory Listing
Modified Mon Feb 5 21:31:02 2007 UTC (17 years, 1 month ago) by dpavlin
minor cleanp

Revision 91 - Directory Listing
Modified Mon Feb 5 21:29:48 2007 UTC (17 years, 1 month ago) by dpavlin
fix typo to make /database/42 work again

Revision 88 - Directory Listing
Modified Mon Feb 5 18:46:13 2007 UTC (17 years, 1 month 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, 1 month ago) by dpavlin
added REST date filter: /list/date/yyyy-mm-dd

Revision 84 - Directory Listing
Modified Tue Jan 30 14:08:47 2007 UTC (17 years, 2 months ago) by dpavlin
use on_database parameter for database id throughout all code,
implement save query using tangents and continuations

Revision 82 - Directory Listing
Modified Mon Jan 29 21:43:06 2007 UTC (17 years, 2 months ago) by dpavlin
don't use SQL::ReservedWords in canonicalization. Instead, use small subset
of SQL and do pretty printing also.

Revision 79 - Directory Listing
Modified Mon Jan 29 20:46:20 2007 UTC (17 years, 2 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, 2 months ago) by dpavlin
re-organize SQL query page into fragments

Revision 75 - Directory Listing
Modified Sun Jan 28 11:36:37 2007 UTC (17 years, 2 months ago) by dpavlin
hush

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

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


Revision 69 - Directory Listing
Modified Thu Jan 25 20:42:11 2007 UTC (17 years, 2 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 66 - Directory Listing
Modified Thu Jan 25 20:28:42 2007 UTC (17 years, 2 months ago) by dpavlin
display time in seconds with two decimals


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


Revision 62 - Directory Listing
Modified Thu Jan 25 19:16:18 2007 UTC (17 years, 2 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, 2 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, 2 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, 2 months ago) by dpavlin
return true

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

Revision 49 - Directory Listing
Modified Sun Jan 21 13:01:38 2007 UTC (17 years, 2 months ago) by dpavlin
set active on link which is active and color it

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

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

Revision 40 - Directory Listing
Modified Thu Jan 18 18:16:32 2007 UTC (17 years, 2 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, 2 months ago) by dpavlin
REST to select database: /list/database/4

Revision 35 - Directory Listing
Modified Wed Jan 17 17:24:32 2007 UTC (17 years, 2 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 33 - Directory Listing
Modified Sat Dec 9 01:15:02 2006 UTC (17 years, 3 months ago) by dpavlin
added navigation to new and list...

Revision 31 - Directory Listing
Modified Thu Dec 7 23:22:41 2006 UTC (17 years, 3 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, 3 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, 3 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, 3 months ago) by dpavlin
dodana bilješka uz SQL query, malo CSS-a

Revision 24 - Directory Listing
Modified Mon Dec 4 19:22:48 2006 UTC (17 years, 3 months ago) by dpavlin
jifty is UTF-8, so...

Revision 22 - Directory Listing
Modified Sun Dec 3 19:55:52 2006 UTC (17 years, 3 months ago) by dpavlin
re-org of template names

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

Revision 20 - Directory Listing
Modified Sun Dec 3 18:03:30 2006 UTC (17 years, 3 months ago) by dpavlin
loading of records from Model::Query now works

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

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

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

Revision 13 - Directory Listing
Modified Sun Dec 3 13:28:48 2006 UTC (17 years, 3 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 11 - Directory Listing
Modified Sun Dec 3 00:10:31 2006 UTC (17 years, 3 months ago) by dpavlin
better error reporting

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

Revision 7 - Directory Listing
Modified Sat Dec 2 22:30:43 2006 UTC (17 years, 3 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, 3 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, 3 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, 3 months ago) by dpavlin
bootstrap page data

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


  ViewVC Help
Powered by ViewVC 1.1.26