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.

Description

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.

INSTALLATION

Requirements

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

Installation is done from GitHub:

git clone https://github.com/astrorafael/tessdb-cmdline.git
cd tess-cmdline
sudo python setup.py 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.

DATA MODEL

Dimensional Modelling

The data model follows the [dimensional modelling] (https://en.wikipedia.org/wiki/Dimensional_modeling) 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

COMMANDS

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,location,readings}
    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

Example:

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.

Files for tessdb-cmdline, version 1.0.3
Filename, size File type Python version Upload date Hashes
Filename, size tessdb-cmdline-1.0.3.tar.gz (30.1 kB) File type Source Python version None Upload date Hashes View hashes

Supported by

Elastic Elastic Search Pingdom Pingdom Monitoring Google Google BigQuery Sentry Sentry Error logging AWS AWS Cloud computing DataDog DataDog Monitoring Fastly Fastly CDN DigiCert DigiCert EV certificate StatusPage StatusPage Status page