Skip to main content

('tessdb command line tool to manage tessdb database',)

Project description

tessdb command line (overview)

Linux command line utility. TESS stands for Cristobal Garcia's Telescope Encoder and Sky Sensor It is being used as part of the STARS4ALL Project.


tess is a Linux command line utility to perform some common operations on the TESS database without having to write SQL statements. As this utility modifies the database, it is necessary to invoke it within using sudo. Also, you should ensure that the database is not being written by tessdb systemd service to avoid database is locked exceptions, either by using it at daytime or by pausing the tessdb systemd service with /usr/local/bin/tessdb_pause and then resume it with /usr/local/bin/tessdb_resume.



The following components are needed and should be installed first:

  • python 2.7.x (tested on Ubuntu Python 2.7.6) or python 3.6+


Installation is done from GitHub:

git clone
cd tess-cmdline
sudo python install

Note: Installation from PyPi is now obsolete. Do not use the package uploaded in PyPi.

  • All executables are copied to /usr/local/bin
  • The database is located at /var/dbase/tess.db by default, although a diffferent path may be specified.


Dimensional Modelling

The data model follows the [dimensional modelling] ( approach by Ralph Kimball. More references can also be found in Star Schemas.

The data model

The latest version of the data model can be found in tessdb-server repository.

TESS Database Model


The tess command line tool is self-explanatory and has several subcommands. You can find the all by typing tess --help

pi@rb-tess:~ $ tess --help
usage: /usr/local/bin/tess [-h] {instrument,location,readings} ...

positional arguments:
    instrument          instrument commands
    location            location commands
    readings            readings commands

optional arguments:
  -h, --help            show this help message and exit

Each subcommand has its own help that you may display by issuing tess <subcommand> --help


pi@rb-tess:~ $ tess location list --help
usage: /usr/local/bin/tess location list [-h] [-p PAGE_SIZE] [-d DBASE]

optional arguments:
  -h, --help            show this help message and exit
  -p PAGE_SIZE, --page-size PAGE_SIZE
                        list page size
  -d DBASE, --dbase DBASE
                        SQLite database full file path

Project details

Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

tessdb-cmdline-1.1.2.tar.gz (32.2 kB view hashes)

Uploaded source

Supported by

AWS AWS Cloud computing Datadog Datadog Monitoring Facebook / Instagram Facebook / Instagram PSF Sponsor Fastly Fastly CDN Google Google Object Storage and Download Analytics Huawei Huawei PSF Sponsor Microsoft Microsoft PSF Sponsor NVIDIA NVIDIA PSF Sponsor Pingdom Pingdom Monitoring Salesforce Salesforce PSF Sponsor Sentry Sentry Error logging StatusPage StatusPage Status page