Skip to content

mgualdron/SQL-Shell

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

26 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

SQL::Shell v1.17

SQL-Shell:  Interactive shell for DBI Databases
Copyright (C) 2006  BBC
Copyright (C) 2019  Miguel Gualdron

This program is free software; you can redistribute it and/or modify
it under the terms of the GNU General Public License as published by
the Free Software Foundation; either version 2 of the License, or
(at your option) any later version.

This program is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
GNU General Public License for more details.

You should have received a copy of the GNU General Public License
along with this program; if not, write to the Free Software
Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA

See the file COPYING in this distribution, or https://www.gnu.org/licenses/gpl-2.0.html


QUICK START:

Install SQL::Shell by unpacking the tarball and running the following
commands in the source directory:

    perl Makefile.PL
    make
    make test
    make install
    Then delete the source directory tree since it's no longer needed.

The optional database unit tests have been optimized for SQLite.  If you want 
to run these, please install

    DBD::SQLite

and set the following environment variables as follows before running
"make test":

   UNIT_TEST_DSN="DBI:SQLite:dbname=test.db"
   UNIT_TEST_USER=anything
   UNIT_TEST_PASS=

The unit test script will create a file called t/data/test.db, and will 
remove it at the end of the testing.

Run 'perldoc SQL::Shell' to read the full documentation.


RECENT CHANGES

v1.17

Added below missing dependencies to the installation prerequisites:

    CGI
    Locale::Recode


v1.16

Corrected the copyright notices throughout the code to properly match the 
COPYING file already distributed with the module.

Added new commands 'send' and 'recv' to give users better control of how 
their commands are interpreted when they don't match predefined patterns.

Simplified the functionality of the 'show tables' command to improve 
performance on platforms with large numbers of tables. (The old functionality 
is still present in the new 'show tablecounts' command.)

Added a new command 'show settings' to list some of the shell's internal 
parameters.  More of the settings will be added to this listing in the future.

Modified the DB tests to work best with SQLite, as it was nearly impossible 
to maintain compatibility with all DB platforms.


v1.15

Fixed several long-standing issues.  All of them were minor.

About

Command interpreter for DBI shells

Resources

License

Stars

Watchers

Forks

Packages

No packages published

Languages