Menu
▾
▴
[Sqlshell-svn] /devel/src/www: content design include
|
From: SVN by r. <sv...@ca...> - 2009-02-18 23:56:33
|
Author: ronald Date: 2009-02-18 23:09:42 +0100 (Wed, 18 Feb 2009) New Revision: 372 Added: src/www/content/contact.txt src/www/content/download.txt src/www/content/home.txt src/www/content/screenshots.txt src/www/include/loadContent.php Removed: src/www/include/faq.php Modified: src/www/content/faq.txt src/www/content/news.txt src/www/design/style.css src/www/include/javascript.js Log: website update Added: src/www/content/contact.txt =================================================================== --- src/www/content/contact.txt 2009-01-26 08:44:29 UTC (rev 371) +++ src/www/content/contact.txt 2009-02-18 22:09:42 UTC (rev 372) @@ -0,0 +1,3 @@ +<p>hglteam at users.sourceforge.net </p> +<p>vdkuil at users.sourceforge.net </p> +<p>srotman at users.sourceforge.net </p> \ No newline at end of file Added: src/www/content/download.txt =================================================================== --- src/www/content/download.txt 2009-01-26 08:44:29 UTC (rev 371) +++ src/www/content/download.txt 2009-02-18 22:09:42 UTC (rev 372) @@ -0,0 +1,6 @@ +<p>download <a href="http://sourceforge.net/project/showfiles.php?group_id=204538&package_id=244099&release_id=649412" target="_blank">here</a> the last version</p> +<h2>Installation</h2> +Minimum (tested) requirements: SUN Java 6 and a working operating system for +javacurses (http://sf.net/projects/javacurses) +<h2>Source </h2> +<p>Download <a href="http://sourceforge.net/project/showfiles.php?group_id=204538" target="_blank">releases from Sourceforge </a> </p> \ No newline at end of file Modified: src/www/content/faq.txt =================================================================== --- src/www/content/faq.txt 2009-01-26 08:44:29 UTC (rev 371) +++ src/www/content/faq.txt 2009-02-18 22:09:42 UTC (rev 372) @@ -1,10 +1,39 @@ -Q:Which features has SQLShell? -The goal of SQLShell is to be as usefull as possible in a shell environment. Currently it supports many features like: tabcompletion on tables and columns, command history, spooling of files, executing a sql script -Q:How to run SQLShell -Unzip the tgz or zip file and start sql shell using: -windows: sqlshell.bat<br>unix/linux: ./sqlshell -Per default is uses a simple database, you can configure your own database settings by editing the db.properties file -Q:How to connect to database -With the command connect. The command 'help connect' provides a list of configured identities -Q:Why develop something like SQLShell -Since it is not always possible to use a graphical client for performing sql queries on a server it is really usefull to use a sqlclient that works in a non graphic environment. Most sqlclients I have used have different plus points. But the negative parts are usually too big to be usefull. On a side note when you use different database engines it would nice if it is possible to use one client for all. Hopefully SQLShell will solve these problems for you as well as it did (and does) for me. +Q:Which features has SQLShell? +The goal of SQLShell is to be as usefull as possible in a shell environment. +Currently it supports many features like: tabcompletion on tables and columns, command history, spooling of files, executing a sql script + +Q:What are the requirements +Minimum (tested) requirements: SUN Java 6 and a working operating system for: +javacurses (http://sf.net/projects/javacurses) +or charva (http://www.pitman.co.za/projects/charva/index.html). + +Q:How to run SQLShell +Unzip the tgz or zip file and start sql shell using: +windows: sqlshell.bat<br>unix/linux: ./sqlshell +Per default is uses a simple database, you can configure your own database settings by editing the db.properties file + +With Charva +In order to run sqlshell using charva you need to have the charva libraries in the lib folder. +Currently charva is compiled for windows (32 bits) and linux intel 32 bits and amd 64 bits. If you don't +own an intel 32 bits, you need to modify the contents of the lib/charva directory. + +With JCurses +Please note that in order to be able to run the improved sqlclient +with the 'sqlshell' script, the $project/lib dir is required to +contain the jcurses.jar and libjcurses.so files. +Also note that jcurses.jar need NOT be a symlink. + +Windows: +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 + +Q:How to connect to my database +With the command connect. The command 'help connect' provides a list of configured identities + +Q:Why develop something like SQLShell +The intention of writing this sqlclient/sqlshell is to provide a common interface to different databases we use in our company. But most important is that the interface to a commercial client we use is really not very usefull. Our goal is to add as many features as we can think of to this small utility class so that our daily work is made a lot easier. The initial functionality should contain: +- sql command history (key up/down) +- tab completion (at least for select queries) +- execute a sql file (@mystatements.sql) +- spool output to a file (spool output.txt) Added: src/www/content/home.txt =================================================================== --- src/www/content/home.txt 2009-01-26 08:44:29 UTC (rev 371) +++ src/www/content/home.txt 2009-02-18 22:09:42 UTC (rev 372) @@ -0,0 +1,10 @@ + +A fully functional smart textual database frontend with features like tabcompletion and command history. +All the missing unix tool features in sqlplus or server commandline are include in sqlshell and many many more. +SQLShell is trying to be as much self-explanatory as possible. To accomplish this SQLShell has: +* an embedded help function that allows you to show help about a specific command or search for a keyword in help (help -k keyword). +* tab completion assist for most commands (including file browsing for spool or executing a command from file (@) + +SQLShell is getting new features with every new release and it's tab completion support for sql queries has improved a lot since it's first release. <br> +A fully functional smart textual database frontend with features like tabcompletion and command history.<br> +All the missing unix tool features in sqlplus or servercommandline are include in sqlshell. Modified: src/www/content/news.txt =================================================================== --- src/www/content/news.txt 2009-01-26 08:44:29 UTC (rev 371) +++ src/www/content/news.txt 2009-02-18 22:09:42 UTC (rev 372) @@ -1,5 +1,7 @@ -2007-10-09 <a href="http://sourceforge.net/forum/forum.php?forum_id=743419" target="_blank">release 0.3</a> -2007-09-16 <a href="http://sourceforge.net/forum/forum.php?forum_id=736699" target="_blank">release 0.2</a> -2007-09-15 release of website -2007-09-07 start design website -2007-08-01 <a href="http://sourceforge.net/forum/forum.php?forum_id=731541" target="_blank">release 0.1</a> +2008-12-24 release 0.6.1 +2008-12-23 release 0.6 +2008-03-14 release 0.5 +2008-01-24 release 0.4 +2007-10-09 release 0.3 +2007-09-16 release 0.2 +2007-08-01 release 0.1 Added: src/www/content/screenshots.txt =================================================================== --- src/www/content/screenshots.txt 2009-01-26 08:44:29 UTC (rev 371) +++ src/www/content/screenshots.txt 2009-02-18 22:09:42 UTC (rev 372) @@ -0,0 +1,10 @@ +<img src="content/screenshots/help.jpg" name="screenshot_large" width="514" height="406" align="left"> +<div class="screenshot"> +<img src="content/screenshots/help.jpg" onClick="showScreenshot(this)" width="140" height="110">overview of commands available shown in help +</div> +<div class="screenshot"> +<img src="content/screenshots/choose_columnname.jpg" onClick="showScreenshot(this)" width="140" height="110">a popup dialog for choosing column names +</div> +<div class="screenshot"> +<img src="content/screenshots/multiple_values_possible.jpg" onClick="showScreenshot(this)" width="140" height="110">a popup dialog shows up when no single value is possible +</div> \ No newline at end of file Modified: src/www/design/style.css =================================================================== --- src/www/design/style.css 2009-01-26 08:44:29 UTC (rev 371) +++ src/www/design/style.css 2009-02-18 22:09:42 UTC (rev 372) @@ -38,6 +38,7 @@ div.content { position:absolute; left: 150px; + right: 150px; top : 100px; } Deleted: src/www/include/faq.php =================================================================== --- src/www/include/faq.php 2009-01-26 08:44:29 UTC (rev 371) +++ src/www/include/faq.php 2009-02-18 22:09:42 UTC (rev 372) @@ -1,12 +0,0 @@ -<?php -$faqRows = file("content/faq.txt"); -foreach ($faqRows as $faqRow) { - echo "<p>"; - if (substr($faqRow, 0, 1)=="Q") { - echo "<b>".$faqRow."</b>"; - } else { - echo $faqRow; - } - echo "<p>"; -} -?> \ No newline at end of file Modified: src/www/include/javascript.js =================================================================== --- src/www/include/javascript.js 2009-01-26 08:44:29 UTC (rev 371) +++ src/www/include/javascript.js 2009-02-18 22:09:42 UTC (rev 372) @@ -1,5 +1,5 @@ function showTab(boxid) { - hideTabs(); + hideTabs(); var tab = document.getElementById(boxid); tab.style.visibility="visible"; tab.style.display="block"; Copied: src/www/include/loadContent.php (from rev 371, src/www/include/faq.php) =================================================================== --- src/www/include/faq.php 2009-01-26 08:44:29 UTC (rev 371) +++ src/www/include/loadContent.php 2009-02-18 22:09:42 UTC (rev 372) @@ -0,0 +1,16 @@ +<?php +$faqRows = file("content/$page.txt"); +foreach ($faqRows as $faqRow) { + if (substr($faqRow, 0, 1)=="Q") { + echo "<br><b>".$faqRow."</b>"; + } else if (trim($faqRow)=="") { + echo "</p><p>"; + } else { + echo $faqRow; + } + if ($page!=="screenshots") { + //quick workaround + echo "<br>"; + } +} +?> \ No newline at end of file Property changes on: src/www/include/loadContent.php ___________________________________________________________________ Name: svn:mergeinfo + |
