/[SQLSession]/trunk/lib/SQLSession/Action/DoSQL.pm
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/Action/DoSQL.pm

Parent Directory Parent Directory | Revision Log Revision Log


Links to HEAD: (view) (annotate)
Sticky Revision:

Revision 99 - (view) (annotate) - [select for diffs]
Modified Fri Feb 16 22:20:41 2007 UTC (17 years, 2 months ago) by dpavlin
File length: 2465 byte(s)
Diff to previous 84
extract reformat_sql into SQLSession::Utils and use then in canonicalizer

Revision 84 - (view) (annotate) - [select for diffs]
Modified Tue Jan 30 14:08:47 2007 UTC (17 years, 3 months ago) by dpavlin
File length: 2672 byte(s)
Diff to previous 82
use on_database parameter for database id throughout all code,
implement save query using tangents and continuations

Revision 82 - (view) (annotate) - [select for diffs]
Modified Mon Jan 29 21:43:06 2007 UTC (17 years, 3 months ago) by dpavlin
File length: 2648 byte(s)
Diff to previous 70
don't use SQL::ReservedWords in canonicalization. Instead, use small subset
of SQL and do pretty printing also.

Revision 70 - (view) (annotate) - [select for diffs]
Modified Thu Jan 25 21:16:06 2007 UTC (17 years, 3 months ago) by dpavlin
File length: 2545 byte(s)
Diff to previous 66
more strict uppercasing


Revision 66 - (view) (annotate) - [select for diffs]
Modified Thu Jan 25 20:28:42 2007 UTC (17 years, 3 months ago) by dpavlin
File length: 2539 byte(s)
Diff to previous 35
display time in seconds with two decimals


Revision 35 - (view) (annotate) - [select for diffs]
Modified Wed Jan 17 17:24:32 2007 UTC (17 years, 3 months ago) by dpavlin
File length: 2471 byte(s)
Diff to previous 30
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 30 - (view) (annotate) - [select for diffs]
Modified Thu Dec 7 23:14:57 2006 UTC (17 years, 4 months ago) by dpavlin
File length: 2440 byte(s)
Diff to previous 29
use SET client_encoding = UTF8 only if dsn indicates Pg (PostgreSQL)

Revision 29 - (view) (annotate) - [select for diffs]
Modified Thu Dec 7 22:13:56 2006 UTC (17 years, 4 months ago) by dpavlin
File length: 2418 byte(s)
Diff to previous 28
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 - (view) (annotate) - [select for diffs]
Modified Thu Dec 7 19:56:41 2006 UTC (17 years, 4 months ago) by dpavlin
File length: 2383 byte(s)
Diff to previous 24
dodana bilješka uz SQL query, malo CSS-a

Revision 24 - (view) (annotate) - [select for diffs]
Modified Mon Dec 4 19:22:48 2006 UTC (17 years, 4 months ago) by dpavlin
File length: 2352 byte(s)
Diff to previous 20
jifty is UTF-8, so...

Revision 20 - (view) (annotate) - [select for diffs]
Modified Sun Dec 3 18:03:30 2006 UTC (17 years, 4 months ago) by dpavlin
File length: 2310 byte(s)
Diff to previous 13
loading of records from Model::Query now works

Revision 13 - (view) (annotate) - [select for diffs]
Modified Sun Dec 3 13:28:48 2006 UTC (17 years, 4 months ago) by dpavlin
File length: 2359 byte(s)
Diff to previous 11
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 - (view) (annotate) - [select for diffs]
Modified Sun Dec 3 00:10:31 2006 UTC (17 years, 4 months ago) by dpavlin
File length: 2091 byte(s)
Diff to previous 9
better error reporting

Revision 9 - (view) (annotate) - [select for diffs]
Modified Sat Dec 2 23:53:00 2006 UTC (17 years, 4 months ago) by dpavlin
File length: 2046 byte(s)
Diff to previous 8
added template which produce SQL results in table from entered SQL query

Revision 8 - (view) (annotate) - [select for diffs]
Modified Sat Dec 2 22:54:15 2006 UTC (17 years, 4 months ago) by dpavlin
File length: 2005 byte(s)
Diff to previous 7
fix validate

Revision 7 - (view) (annotate) - [select for diffs]
Modified Sat Dec 2 22:30:43 2006 UTC (17 years, 4 months ago) by dpavlin
File length: 1954 byte(s)
Diff to previous 6
trivial implementation of action which use DBI to execute SQL query on database

Revision 6 - (view) (annotate) - [select for diffs]
Modified Sat Dec 2 21:17:46 2006 UTC (17 years, 4 months ago) by dpavlin
File length: 966 byte(s)
Diff to previous 5
cleanup, this was a Jifty bug

Revision 5 - (view) (annotate) - [select for diffs]
Added Sat Dec 2 14:00:51 2006 UTC (17 years, 4 months ago) by dpavlin
File length: 1019 byte(s)
try to add DoSQL action, but it doesn't show available databases yet

This form allows you to request diffs between any two revisions of this file. For each of the two "sides" of the diff, enter a numeric revision.

  Diffs between and
  Type of Diff should be a

  ViewVC Help
Powered by ViewVC 1.1.26