The common code used by all sqlectron clients.
Do you wanna support for another SQL database? Is expected that in the pull request the new database is included in the db.spec.js.
Install via npm:
$ npm install sqlectron-core
SQLECTRON keeps a hidden configuration file called .sqlectron.json
at the user's home directory (~/
osx and linux; %userprofile%
windows ).
Although you can change this file manually, most of time you should not worry about it because SQLECTRON will manage the configuration for you.
Example
{
"resultItemsPerPage": 50,
"limitQueryDefaultSelectTop": 100,
"servers": [
{
"id": "c48890d8-5d87-4085-8b22-94981f8d522c",
"name": "pg-vm-ssh",
"client": "postgresql",
"host": "localhost",
"port": 5432,
"user": "user",
"password": "password",
"database": "company",
"ssh": {
"host": "10.10.10.10",
"port": 22,
"privateKey": "~/.vagrant.d/insecure_private_key",
"user": "core"
}
},
{
"id": "0f6536a1-c232-4515-942a-c0fb56d362b2",
"name": "vm-ssh",
"client": "mysql",
"host": "localhost",
"port": 3306,
"user": "root",
"password": "password",
"database": "authentication"
}
]
}
The limit of items per page (default on sqlectron-gui: 100)
The paging is not done in SQL query. Instead its is done during the results rendering.
The limit used in the default query (default: 1000)
Array with all servers connection.
id
: in case including a new server manually there is no need setting an id field because SQLECTRON will do it for youname
client
:postgresql
,mysql
orsqlserver
host
port
user
password
database
ssh
host
user
port
privateKey
It is required to use editorconfig and please write and run specs before pushing any changes.
It will bring up a MySQL and PostgreSQL database and run all the tests:
docker-compose run --rm test
You will need to bring up all the databases then run the tests through:
npm test
Copyright (c) 2015 The SQLECTRON Team. This software is licensed under the MIT License.