/[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 61 - Directory Listing
Modified Thu Jan 25 19:05:04 2007 UTC (17 years, 3 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, 3 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, 3 months ago) by dpavlin
return true

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

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

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

Revision 53 - Directory Listing
Modified Sun Jan 21 14:00:28 2007 UTC (17 years, 3 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, 3 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, 3 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, 3 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, 3 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, 3 months ago) by dpavlin
be less chatty

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

Revision 45 - Directory Listing
Modified Sun Jan 21 12:19:58 2007 UTC (17 years, 3 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, 3 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, 3 months ago) by dpavlin
remove confusing external links

Revision 42 - Directory Listing
Modified Thu Jan 18 18:56:11 2007 UTC (17 years, 3 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, 3 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, 3 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, 3 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, 3 months ago) by dpavlin
slightly better design

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


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


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

Revision 33 - Directory Listing
Modified Sat Dec 9 01:15:02 2006 UTC (17 years, 5 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, 5 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, 5 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, 5 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, 5 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, 5 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, 5 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, 5 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, 5 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, 5 months ago) by dpavlin
jifty is UTF-8, so...

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

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

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

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

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

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

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

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

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

Revision 10 - Directory Listing
Modified Sun Dec 3 00:04:57 2006 UTC (17 years, 5 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, 5 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, 5 months ago) by dpavlin
fix validate

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

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


  ViewVC Help
Powered by ViewVC 1.1.26