Skip to content

cql

Directory actions

More options

Directory actions

More options

Latest commit

 

History

History
 
 

cql

Folders and files

NameName
Last commit message
Last commit date

parent directory

..
README-zh.md
README-zh.md
 
 
README.md
README.md
 
 
main.go
main.go
 
 
util.go
util.go
 
 

README.md

This doc introduce the usage of CovenantSQL commandline client cql. cql is a command line interface for batch scripting used for creating, querying, updating, and deleting the SQLChain and database adhere to the SQLChain.

Install

Download Latest Release or build from src:

$ go get github.com/CovenantSQL/CovenantSQL/client
$ go get github.com/CovenantSQL/CovenantSQL/cmd/cql

make sure that $GOPATH/bin is in your $PATH

Generating Default Config File

You need to provide a config and a master key for initialization. The master key is used to encrypt/decrypt local key pair. If you generate a config file with cql-utils, you can find the config file in the directory that cql-utils create.

See: cql-utils doc for config generation and get wallet address.

Check balance

Use cql to check your wallet balance:

$ cql -get-balance
INFO[0000] 
### Public Key ###
0388954cf083bb6bb2b9c7248849b57c76326296fcc0d69764fc61eedb5b8d820c
### Public Key ###
  caller="privatekeystore.go:116 crypto/kms.InitLocalKeyPair"
INFO[0000] stable coin balance is: 100                   caller="main.go:246 main.main"
INFO[0000] covenant coin balance is: 0                   caller="main.go:247 main.main"

Here, I got "stable coin balance is: 100".

Initialize a CovenantSQL cql

After you prepare your master key and config file, CovenantSQL cql can be initialized by: You can get a database id when create a new SQL Chain:

# if a non-default password applied on master key, use `-password` to pass it
$ cql -create 1
INFO[0000]
### Public Key ###
039bc931161383c994ab9b81e95ddc1494b0efeb1cb735bb91e1043a1d6b98ebfd
### Public Key ###
  caller="privatekeystore.go:116 crypto/kms.InitLocalKeyPair"
INFO[0000] the newly created database is: covenantsql://0e9103318821b027f35b96c4fd5562683543276b72c488966d616bfe0fe4d213  caller="main.go:297 main.main"

Here, -create 1 refers that there is only one node in SQL Chain.

$ cql -dsn covenantsql://address

address is database id.

Show the complete usage of cql:

$ cql -help

Use the cql

Free to use the cql now:

co:address=> show tables;