From: SVN by r. <sv...@ca...> - 2008-01-13 11:18:35
|
Author: roy Date: 2008-01-13 12:04:52 +0100 (Sun, 13 Jan 2008) New Revision: 218 Modified: ChangeLog Log: mention changes Modified: ChangeLog =================================================================== --- ChangeLog 2008-01-13 10:42:47 UTC (rev 217) +++ ChangeLog 2008-01-13 11:04:52 UTC (rev 218) @@ -1,4 +1,5 @@ 0.4 + * Improved speed for displaying large( >200<20000 rows) query results * Fix display of time in date column (at least for oracle) * Improve tab comnpletion * Added tabcompletion for: |
From: SVN by r. <sv...@ca...> - 2008-01-14 07:10:48
|
Author: roy Date: 2008-01-14 08:04:24 +0100 (Mon, 14 Jan 2008) New Revision: 219 Modified: pom.xml Log: version 0.4 Modified: pom.xml =================================================================== --- pom.xml 2008-01-13 11:04:52 UTC (rev 218) +++ pom.xml 2008-01-14 07:04:24 UTC (rev 219) @@ -19,7 +19,7 @@ <groupId>nl.improved</groupId> <artifactId>sqlshell</artifactId> <packaging>jar</packaging> - <version>0.4-SNAPSHOT</version> + <version>0.4</version> <name>SQLShell ~ the improved sqlclient</name> <url>http://sqlshell.sourceforge.org</url> <build> |
From: SVN by r. <sv...@ca...> - 2008-01-17 06:44:26
|
Author: roy Date: 2008-01-17 07:39:08 +0100 (Thu, 17 Jan 2008) New Revision: 223 Modified: ChangeLog Log: mention change Modified: ChangeLog =================================================================== --- ChangeLog 2008-01-14 14:21:08 UTC (rev 222) +++ ChangeLog 2008-01-17 06:39:08 UTC (rev 223) @@ -9,6 +9,7 @@ * group by * order by * allow enter in pwd field to 'ok' data + * fix in replace ~/ with users home dir in spool TODO: flush pwd when username manually set and doesn't match default username 0.3 (09-10-2007) * focus fix in login dialog |
From: SVN by r. <sv...@ca...> - 2008-01-24 21:35:28
|
Author: roy Date: 2008-01-24 21:45:55 +0100 (Thu, 24 Jan 2008) New Revision: 224 Modified: README Log: mention Windows Modified: README =================================================================== --- README 2008-01-17 06:39:08 UTC (rev 223) +++ README 2008-01-24 20:45:55 UTC (rev 224) @@ -18,7 +18,9 @@ In the most simple case download the zip or tgz file from the sourceforge website and unzip it to the folder of your liking. Then you can start the programm that is setup to use a simple testdatabase by executing 'sqlshell'. Please note that because of javacurses currently you need to enter the directory in which sqlshell is located before starting it. This is a bug that hopefully we can address really soon. Windows: -TODO +1. Copy or move the dll located in the windows directory to the lib directory (the directory containing jcurses.jar +2. Change the INSTALLATION_DIR variable in sqlshell.bat file +3. Start sqlshell.bat CURRENT FEATURES [See ChangeLog] |
From: SVN by r. <sv...@ca...> - 2008-01-24 21:35:35
|
Author: roy Date: 2008-01-24 21:46:27 +0100 (Thu, 24 Jan 2008) New Revision: 225 Modified: makejars.sh Log: 0.4 added windows stuff Modified: makejars.sh =================================================================== --- makejars.sh 2008-01-24 20:45:55 UTC (rev 224) +++ makejars.sh 2008-01-24 20:46:27 UTC (rev 225) @@ -1,6 +1,6 @@ #!/bin/bash PROJECT=sqlshell -VERSION=0.3 +VERSION=0.4 #cleanup rm -Rf release @@ -14,6 +14,7 @@ cp ../README source cp ../ChangeLog source cp ../${PROJECT} source +cp ../${PROJECT}.bat source cd source rm -Rf src/www find . -name "*.svn" | xargs rm -Rf @@ -28,12 +29,14 @@ cd release mkdir bin cp ../${PROJECT} bin +cp ../${PROJECT}.bat bin cp ../README bin cp ../ChangeLog bin cp ../src/main/resources/db.properties bin cp ../target/*.jar bin/${PROJECT}.jar cp -Rf ../lib bin -cp -Rf ${HOME}/.m2/repository/hsqldb/hsqldb/1.8.0/hsqldb-1.8.0.jar bin/lib +cp -Rf ../windows bin +#cp -Rf ${HOME}/.m2/repository/hsqldb/hsqldb/1.8.0/hsqldb-1.8.0.jar bin/lib mkdir bin/db cp -Rf ../db/*.script bin/db cp -Rf ../db/*.properties bin/db @@ -43,6 +46,7 @@ cat _sqlshell | awk '{ gsub("SQLSHELL=target/classes","#SQLSHELL=target/classes"); gsub("#SQLSHELL=\${WORKINGDIR}/sqlshell.jar","SQLSHELL=${WORKINGDIR}/sqlshell.jar"); print }' > sqlshell chmod +x sqlshell rm _sqlshell +cp -Rf ../../windows . tar zcf ../${PROJECT}-bin-${VERSION}.tgz . zip -r ../${PROJECT}-bin-${VERSION}.zip . cd .. |
From: SVN by r. <sv...@ca...> - 2008-01-24 21:49:33
|
Author: roy Date: 2008-01-24 22:00:21 +0100 (Thu, 24 Jan 2008) New Revision: 226 Modified: pom.xml Log: 0.5 snapshot Modified: pom.xml =================================================================== --- pom.xml 2008-01-24 20:46:27 UTC (rev 225) +++ pom.xml 2008-01-24 21:00:21 UTC (rev 226) @@ -19,7 +19,7 @@ <groupId>nl.improved</groupId> <artifactId>sqlshell</artifactId> <packaging>jar</packaging> - <version>0.4</version> + <version>0.5-SNAPSHOT</version> <name>SQLShell ~ the improved sqlclient</name> <url>http://sqlshell.sourceforge.org</url> <build> |
From: SVN by r. <sv...@ca...> - 2008-01-24 21:51:06
|
Author: roy Date: 2008-01-24 22:01:47 +0100 (Thu, 24 Jan 2008) New Revision: 227 Modified: README Log: added new ideas Modified: README =================================================================== --- README 2008-01-24 21:00:21 UTC (rev 226) +++ README 2008-01-24 21:01:47 UTC (rev 227) @@ -26,6 +26,10 @@ [See ChangeLog] FUTURE +- dump history to file +- show status (query executing, waiting for input... etc) +- sort commands in help +- add key bindings in help - add 'show tables like' support - login schreen improvements (select all text on focus) - Improve desc table (to show references, etc) @@ -41,4 +45,4 @@ - Large query results don't show (> 300.000 rows?) - 'where x' doesn't autocomplete table names - make ctrl+j (for example) auto insert join -- make ctrl+c abort query +- make ctrl+a abort query (ctr c quits application... don't know how to catch that) |
From: SVN by r. <sv...@ca...> - 2008-01-24 21:51:26
|
Author: roy Date: 2008-01-24 22:02:26 +0100 (Thu, 24 Jan 2008) New Revision: 228 Modified: ChangeLog Log: 0.4 released Modified: ChangeLog =================================================================== --- ChangeLog 2008-01-24 21:01:47 UTC (rev 227) +++ ChangeLog 2008-01-24 21:02:26 UTC (rev 228) @@ -1,4 +1,6 @@ -0.4 +-.5 + +0.4 (2008-01-24) * Improved speed for displaying large( >200<20000 rows) query results * Fix display of time in date column (at least for oracle) * Improve tab comnpletion |
From: SVN by r. <sv...@ca...> - 2008-03-02 14:10:00
|
Author: roy Date: 2008-03-02 15:09:51 +0100 (Sun, 02 Mar 2008) New Revision: 247 Modified: ChangeLog Log: mention changes Modified: ChangeLog =================================================================== --- ChangeLog 2008-03-02 14:08:49 UTC (rev 246) +++ ChangeLog 2008-03-02 14:09:51 UTC (rev 247) @@ -1,4 +1,16 @@ --.5 +0.5 + * Allow for commands to start in the background, this will allow to continue + reading keyboard input (currently used to abort commands) + * Added help to keyboard mappings (pageup/down/end/home, etc) + * BUGFIX: Added fixes for mysql, mysql uses lowercase tablenames where oracle uses + uppercase. Currenlty SQLShell tries to figure out which one to use + automatically + * timestamp display fixes + * Tabcompletion improvements (fixed deadlock caused by an error in regular + expressions api from java) + * Improved navigation in edit mode (home/end). It should be more intuitive + and usefull now + * Removed border of one character to maximize the usage of the screen 0.4 (2008-01-24) * Improved speed for displaying large( >200<20000 rows) query results |
From: SVN by r. <sv...@ca...> - 2008-03-05 07:29:37
|
Author: roy Date: 2008-03-05 08:29:22 +0100 (Wed, 05 Mar 2008) New Revision: 251 Modified: pom.xml Log: version 0.5 Modified: pom.xml =================================================================== --- pom.xml 2008-03-04 10:52:42 UTC (rev 250) +++ pom.xml 2008-03-05 07:29:22 UTC (rev 251) @@ -19,7 +19,7 @@ <groupId>nl.improved</groupId> <artifactId>sqlshell</artifactId> <packaging>jar</packaging> - <version>0.5-SNAPSHOT</version> + <version>0.5</version> <name>SQLShell ~ the improved sqlclient</name> <url>http://sqlshell.sourceforge.org</url> <build> |
From: SVN by r. <sv...@ca...> - 2008-03-14 12:40:07
|
Author: roy Date: 2008-03-14 13:39:55 +0100 (Fri, 14 Mar 2008) New Revision: 252 Modified: pom.xml Log: work on 0.6 started Modified: pom.xml =================================================================== --- pom.xml 2008-03-05 07:29:22 UTC (rev 251) +++ pom.xml 2008-03-14 12:39:55 UTC (rev 252) @@ -19,7 +19,7 @@ <groupId>nl.improved</groupId> <artifactId>sqlshell</artifactId> <packaging>jar</packaging> - <version>0.5</version> + <version>0.6-SNAPSHOT</version> <name>SQLShell ~ the improved sqlclient</name> <url>http://sqlshell.sourceforge.org</url> <build> |
From: SVN by r. <sv...@ca...> - 2008-03-18 21:19:21
|
Author: roy Date: 2008-03-18 22:19:11 +0100 (Tue, 18 Mar 2008) New Revision: 256 Modified: ChangeLog Log: mention changes Modified: ChangeLog =================================================================== --- ChangeLog 2008-03-18 21:18:43 UTC (rev 255) +++ ChangeLog 2008-03-18 21:19:11 UTC (rev 256) @@ -1,4 +1,8 @@ -0.5 +0.6 + * Fix desc table for columns containing numbers + * Added tab completion for connect @ + +0.5 (2008-03-14) * Allow for commands to start in the background, this will allow to continue reading keyboard input (currently used to abort commands) * Added help to keyboard mappings (pageup/down/end/home, etc) |
From: SVN by r. <sv...@ca...> - 2008-04-04 18:43:48
|
Author: roy Date: 2008-04-04 20:43:39 +0200 (Fri, 04 Apr 2008) New Revision: 260 Modified: ChangeLog Log: mention changes Modified: ChangeLog =================================================================== --- ChangeLog 2008-04-04 18:33:05 UTC (rev 259) +++ ChangeLog 2008-04-04 18:43:39 UTC (rev 260) @@ -1,6 +1,7 @@ 0.6 * Fix desc table for columns containing numbers * Added tab completion for connect @ + * Fix tabcompletion when using LIKE comparisons 0.5 (2008-03-14) * Allow for commands to start in the background, this will allow to continue |
From: SVN by r. <sv...@ca...> - 2008-05-19 20:55:22
|
Author: roy Date: 2008-05-19 22:55:11 +0200 (Mon, 19 May 2008) New Revision: 262 Modified: ChangeLog Log: some changes for mysql Modified: ChangeLog =================================================================== --- ChangeLog 2008-05-19 20:28:44 UTC (rev 261) +++ ChangeLog 2008-05-19 20:55:11 UTC (rev 262) @@ -1,4 +1,5 @@ 0.6 + * Mysql case sensitivity fixes * Fix desc table for columns containing numbers * Added tab completion for connect @ * Fix tabcompletion when using LIKE comparisons |
From: SVN by r. <sv...@ca...> - 2008-07-23 10:25:20
|
Author: roy Date: 2008-07-23 12:25:10 +0200 (Wed, 23 Jul 2008) New Revision: 267 Modified: ChangeLog Log: mention changes Modified: ChangeLog =================================================================== --- ChangeLog 2008-07-23 09:50:14 UTC (rev 266) +++ ChangeLog 2008-07-23 10:25:10 UTC (rev 267) @@ -4,6 +4,8 @@ * Added tab completion for connect @ * Fix tabcompletion when using LIKE comparisons * Fix for index out of bounds for strings without spaces + * Fix for quit on some systems (hardy heron for example) + * Added dump/read command to dump (a part of) a table 0.5 (2008-03-14) * Allow for commands to start in the background, this will allow to continue |
From: SVN by r. <sv...@ca...> - 2008-07-31 08:00:03
|
Author: roy Date: 2008-07-31 09:59:52 +0200 (Thu, 31 Jul 2008) New Revision: 276 Modified: ChangeLog Log: mention changes Modified: ChangeLog =================================================================== --- ChangeLog 2008-07-31 07:59:08 UTC (rev 275) +++ ChangeLog 2008-07-31 07:59:52 UTC (rev 276) @@ -6,6 +6,7 @@ * Fix for index out of bounds for strings without spaces * Fix for quit on some systems (hardy heron for example) * Added dump/read command to dump (a part of) a table + * Tab completion case sensitive fix (For example jo<tab> -> Job) 0.5 (2008-03-14) * Allow for commands to start in the background, this will allow to continue |
From: SVN by r. <sv...@ca...> - 2008-08-19 11:05:50
|
Author: roy Date: 2008-08-19 13:05:39 +0200 (Tue, 19 Aug 2008) New Revision: 288 Modified: ChangeLog Log: mention changes Modified: ChangeLog =================================================================== --- ChangeLog 2008-08-19 11:00:11 UTC (rev 287) +++ ChangeLog 2008-08-19 11:05:39 UTC (rev 288) @@ -7,6 +7,7 @@ * Fix for quit on some systems (hardy heron for example) * Added dump/read command to dump (a part of) a table * Tab completion case sensitive fix (For example jo<tab> -> Job) + * Add tab completion to spool command 0.5 (2008-03-14) * Allow for commands to start in the background, this will allow to continue |
From: SVN by r. <sv...@ca...> - 2008-08-23 12:33:07
|
Author: roy Date: 2008-08-23 14:32:57 +0200 (Sat, 23 Aug 2008) New Revision: 296 Modified: pom.xml Log: java 6-5 fixes Modified: pom.xml =================================================================== --- pom.xml 2008-08-23 12:32:42 UTC (rev 295) +++ pom.xml 2008-08-23 12:32:57 UTC (rev 296) @@ -28,8 +28,8 @@ <plugin> <artifactId>maven-compiler-plugin</artifactId> <configuration> - <source>1.6</source> - <target>1.6</target> + <source>1.5</source> + <target>1.5</target> </configuration> </plugin> </plugins> |
From: SVN by r. <sv...@ca...> - 2008-08-24 20:18:38
|
Author: roy Date: 2008-08-24 22:18:29 +0200 (Sun, 24 Aug 2008) New Revision: 299 Modified: ChangeLog Log: mention changes Modified: ChangeLog =================================================================== --- ChangeLog 2008-08-24 20:18:18 UTC (rev 298) +++ ChangeLog 2008-08-24 20:18:29 UTC (rev 299) @@ -8,6 +8,7 @@ * Added dump/read command to dump (a part of) a table * Tab completion case sensitive fix (For example jo<tab> -> Job) * Add tab completion to spool command + * Fix error message in @ command when file could not be read 0.5 (2008-03-14) * Allow for commands to start in the background, this will allow to continue |
From: SVN by r. <sv...@ca...> - 2008-10-12 12:15:21
|
Author: roy Date: 2008-10-12 14:15:13 +0200 (Sun, 12 Oct 2008) New Revision: 313 Added: sqlshell.bat Log: windows batch file Added: sqlshell.bat =================================================================== --- sqlshell.bat 2008-10-12 11:57:48 UTC (rev 312) +++ sqlshell.bat 2008-10-12 12:15:13 UTC (rev 313) @@ -0,0 +1,32 @@ +REM Copyright 2007 Roy van der Kuil (ro...@va...) and Stefan Rotman (st...@ro...) +REM +REM Licensed under the Apache License, Version 2.0 (the "License"); +REM you may not use this file except in compliance with the License. +REM You may obtain a copy of the License at +REM +REM http://www.apache.org/licenses/LICENSE-2.0 +REM +REM Unless required by applicable law or agreed to in writing, software +REM distributed under the License is distributed on an "AS IS" BASIS, +REM WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. +REM See the License for the specific language governing permissions and +REM limitations under the License. + +REM Dir to use as base for relative locations +set WORKINGDIR=c:\sqlshell\ + +REM The directory where the JCurses jar and library are located. +REM Please note that JCurses requires tje jcurses.jar and libjcurses.so to +REM be located in the same directory. +set JCURSES=%WORKINGDIR%\lib + +REM Where to find the SQLShell classes +set SQLSHELL=%WORKINGDIR%\sqlshell.jar + +# REM providing drivers for the databases to support. +set DRIVERS="%WORKINGDIR%\lib\hsqldb-1.8.0.jar" + +REM The classpath to use when running +set CP=%WORKINGDIR%;%SQLSHELL%;%JCURSES%\jcurses.jar;%WORKINGDIR%\lib\charva\charva.jar;%WORKINGDIR%\lib\commons-logging.jar + +java -Djava.library.path=%WORKINGDIR%\lib\charva -classpath %CP%;%DRIVERS% nl.improved.sqlclient.charva.SQLShellComponent Property changes on: sqlshell.bat ___________________________________________________________________ Name: svn:executable + * |
From: SVN by r. <sv...@ca...> - 2008-10-12 12:15:39
|
Author: roy Date: 2008-10-12 14:15:32 +0200 (Sun, 12 Oct 2008) New Revision: 314 Modified: pom.xml Log: 0.6 version Modified: pom.xml =================================================================== --- pom.xml 2008-10-12 12:15:13 UTC (rev 313) +++ pom.xml 2008-10-12 12:15:32 UTC (rev 314) @@ -19,7 +19,7 @@ <groupId>nl.improved</groupId> <artifactId>sqlshell</artifactId> <packaging>jar</packaging> - <version>0.6-SNAPSHOT</version> + <version>0.6</version> <name>SQLShell ~ the improved sqlclient</name> <url>http://sqlshell.sourceforge.org</url> <build> |
From: SVN by r. <sv...@ca...> - 2008-10-12 13:09:25
|
Author: roy Date: 2008-10-12 15:09:16 +0200 (Sun, 12 Oct 2008) New Revision: 316 Modified: ChangeLog Log: mention changes Modified: ChangeLog =================================================================== --- ChangeLog 2008-10-12 12:30:37 UTC (rev 315) +++ ChangeLog 2008-10-12 13:09:16 UTC (rev 316) @@ -1,4 +1,4 @@ -0.6 +0.6 (2008-10-12) * Mysql case sensitivity fixes * Fix desc table for columns containing numbers * Added tab completion for connect @ @@ -9,6 +9,8 @@ * Tab completion case sensitive fix (For example jo<tab> -> Job) * Add tab completion to spool command * Fix error message in @ command when file could not be read + * Add persistent history + * Improved multithreading support by changing (default) toolkit used (charva) 0.5 (2008-03-14) * Allow for commands to start in the background, this will allow to continue |
From: SVN by r. <sv...@ca...> - 2008-10-13 18:40:32
|
Author: roy Date: 2008-10-13 20:40:23 +0200 (Mon, 13 Oct 2008) New Revision: 318 Modified: makejars.sh Log: new version Modified: makejars.sh =================================================================== --- makejars.sh 2008-10-13 13:30:59 UTC (rev 317) +++ makejars.sh 2008-10-13 18:40:23 UTC (rev 318) @@ -1,6 +1,6 @@ #!/bin/bash PROJECT=sqlshell -VERSION=0.4 +VERSION=0.6 #cleanup rm -Rf release @@ -13,12 +13,13 @@ cp ../pom.xml source cp ../README source cp ../ChangeLog source +cp ../docs/release-${VERSION}.txt source cp ../${PROJECT} source cp ../${PROJECT}.bat source cd source rm -Rf src/www find . -name "*.svn" | xargs rm -Rf -tar zcf ../${PROJECT}-src-${VERSION}.tgz . +#tar zcf ../${PROJECT}-src-${VERSION}.tgz . zip -r ../${PROJECT}-src-${VERSION}.zip . cd .. rm -Rf source @@ -32,6 +33,7 @@ cp ../${PROJECT}.bat bin cp ../README bin cp ../ChangeLog bin +cp ../docs/release-${VERSION}.txt bin cp ../src/main/resources/db.properties bin cp ../target/*.jar bin/${PROJECT}.jar cp -Rf ../lib bin @@ -47,7 +49,7 @@ chmod +x sqlshell rm _sqlshell cp -Rf ../../windows . -tar zcf ../${PROJECT}-bin-${VERSION}.tgz . +#tar zcf ../${PROJECT}-bin-${VERSION}.tgz . zip -r ../${PROJECT}-bin-${VERSION}.zip . cd .. rm -Rf bin |
From: SVN by r. <sv...@ca...> - 2008-10-13 18:42:36
|
Author: roy Date: 2008-10-13 20:42:25 +0200 (Mon, 13 Oct 2008) New Revision: 319 Modified: sqlshell Log: new startup script Modified: sqlshell =================================================================== --- sqlshell 2008-10-13 18:40:23 UTC (rev 318) +++ sqlshell 2008-10-13 18:42:25 UTC (rev 319) @@ -22,21 +22,28 @@ WORKINGDIR=$(pwd) # The directory where the JCurses jar and library are located. -# Please note that JCurses requires tje jcurses.jar and libjcurses.so to +# Please note that JCurses requires the jcurses.jar and libjcurses.so to # be located in the same directory. -JCURSES=${WORKINGDIR}/lib +JCURSES=${WORKINGDIR}/lib/jcurses +# The directory where the charva jar and library (dll/so file) are located. +CHARVA=${WORKINGDIR}/lib/charva # Where to find the SQLShell classes -#SQLSHELL=${WORKINGDIR}/sqlshell.jar -SQLSHELL=target/classes +SQLSHELL=${WORKINGDIR}/sqlshell.jar +##SQLSHELL=target/classes # Jars providing drivers for the databases to support. DRIVERS="${WORKINGDIR}/lib/hsqldb-1.8.0.jar" # The classpath to use when running -CP=${WORKINGDIR}:${SQLSHELL}:${JCURSES}/jcurses.jar +#CP=${WORKINGDIR}:${SQLSHELL}:${JCURSES}/jcurses.jar +#CP=${WORKINGDIR}:${SQLSHELL}:${JCURSES}/jcurses.jar +CP=${WORKINGDIR}:${SQLSHELL}:${CHARVA}/charva.jar:${WORKINGDIR}/lib/commons-logging.jar for DRIVER in ${DRIVERS} ; do CP=${CP}:${DRIVER} done -${JAVA} -cp ${CP} nl.improved.sqlclient.SQLShell $@ +#Enable the file below to use the jcurses version +#${JAVA} -cp ${CP} nl.improved.sqlclient.jcurses.SQLShell $@ +#Charva version +${JAVA} -Djava.library.path=${CHARVA} -cp ${CP} nl.improved.sqlclient.charva.SQLShellComponent $@ |
From: SVN by r. <sv...@ca...> - 2008-12-22 12:54:34
|
Author: roy Date: 2008-12-22 13:54:27 +0100 (Mon, 22 Dec 2008) New Revision: 332 Modified: ChangeLog Log: mention changes Modified: ChangeLog =================================================================== --- ChangeLog 2008-12-22 12:53:46 UTC (rev 331) +++ ChangeLog 2008-12-22 12:54:27 UTC (rev 332) @@ -11,6 +11,10 @@ * Fix error message in @ command when file could not be read * Add persistent history * Improved multithreading support by changing (default) toolkit used (charva) + * Add description of column in 'show tables having <column>' command + * Fix line splitting cursor issues + * Added error log file (temporary) which will write a file to your temporary + directory 0.5 (2008-03-14) * Allow for commands to start in the background, this will allow to continue |