# easyaccess
Refactored version of trivialAccess for accessing the DES DB
Python Command Line Interpreter to access Oracle DES DB
using cx_Oracle
For a short tutorial chek [here](http://deslogin.cosmology.illinois.edu/~mcarras2/data/DESDM.html)
(Using des credentials)
**Current version = 1.0.6**
## Requirements
- Oracle Client > 11g.2 (External library, no python)
Check [here](https://deswiki.cosmology.illinois.edu/confluence/display/CMBT/Instructions+for+installing+Oracle+client+and+easyaccess+without+EUPS) for instructions on how to install these libraries
- cx_Oracle
- pyfits >= 3.3
- pandas >= 0.14
- termcolor
- PyTables (optional, for hdf5 output)
## Some *nice* features
- Smart tab completion for commands, table names, column names and file paths accordingly
- write output results to csv, tab, fits files or HDF5 files
- load tables from csv or fits directly into DB
- intrinsic db commands to describe tables, own schema, quota and more
- It can be imported as module
- Can run command directly from command line
- Load sql query from file and/or from editor
- Many more
## Basic use
### Running SQL commands
Once inside the interpreter run SQL queries by adding a ; at the end::
DESDB ~> select ... from ... where ... ;
To save the results into a table add ">" after the end of the query (after ";") and namefile at the end of line
DESDB ~> select ... from ... where ... ; > test.fits
The files supported so far are (.csv, .tab, .fits, .h5) any other extension is ignored
### Load tables
To load a table it needs to be in a csv format with columns names in the first row
the name of the table is taken from filename
DESDB ~> load_table <filename>
### Load SQL queries
To load sql queries just run:
DESDB ~> loadsql <filename.sql>
or
DESDB ~> @filename.sql
The format is the same as in command line, SQL statement must end with ;
and to write output files it must be followed by > <output file>
### TODO
- There is a bug with some versions of readline
- Other small changes when loading tables
- Self-upgrade
Refactored version of trivialAccess for accessing the DES DB
Python Command Line Interpreter to access Oracle DES DB
using cx_Oracle
For a short tutorial chek [here](http://deslogin.cosmology.illinois.edu/~mcarras2/data/DESDM.html)
(Using des credentials)
**Current version = 1.0.6**
## Requirements
- Oracle Client > 11g.2 (External library, no python)
Check [here](https://deswiki.cosmology.illinois.edu/confluence/display/CMBT/Instructions+for+installing+Oracle+client+and+easyaccess+without+EUPS) for instructions on how to install these libraries
- cx_Oracle
- pyfits >= 3.3
- pandas >= 0.14
- termcolor
- PyTables (optional, for hdf5 output)
## Some *nice* features
- Smart tab completion for commands, table names, column names and file paths accordingly
- write output results to csv, tab, fits files or HDF5 files
- load tables from csv or fits directly into DB
- intrinsic db commands to describe tables, own schema, quota and more
- It can be imported as module
- Can run command directly from command line
- Load sql query from file and/or from editor
- Many more
## Basic use
### Running SQL commands
Once inside the interpreter run SQL queries by adding a ; at the end::
DESDB ~> select ... from ... where ... ;
To save the results into a table add ">" after the end of the query (after ";") and namefile at the end of line
DESDB ~> select ... from ... where ... ; > test.fits
The files supported so far are (.csv, .tab, .fits, .h5) any other extension is ignored
### Load tables
To load a table it needs to be in a csv format with columns names in the first row
the name of the table is taken from filename
DESDB ~> load_table <filename>
### Load SQL queries
To load sql queries just run:
DESDB ~> loadsql <filename.sql>
or
DESDB ~> @filename.sql
The format is the same as in command line, SQL statement must end with ;
and to write output files it must be followed by > <output file>
### TODO
- There is a bug with some versions of readline
- Other small changes when loading tables
- Self-upgrade
3 maintainers
Release files for easyaccess 1.0.6
For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.
Source distribution (sdist)
| File | Size | Uploaded | |
|---|---|---|---|
| easyaccess-1.0.6.tar.gz | 20.5 kB | Details |
Built distribution (wheel)
| File | Interpreter | ABI | Platform | Reset |
|---|---|---|---|---|
| easyaccess-1.0.6.macosx-10.6-x86_64.exe | Details |
Total release size: 123.1 kB
Release files / easyaccess-1.0.6.tar.gz
| Download URL | easyaccess-1.0.6.tar.gz |
|---|---|
| Size | 20.5 kB |
| Tags | Source |
|
SHA-256 checksum How to use checksums |
2a4e3ab05a20026dfb7c7b89d4fc694517291e9cabc5b70d3693e1f72e3e2e81
|
|
BLAKE2b-256 checksum How to use checksums |
00cf87318f2db03fe6882477df5dfa671f5c4d04a27761e51e77d75e99134465
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
Release files / easyaccess-1.0.6.macosx-10.6-x86_64.exe
| Download URL | easyaccess-1.0.6.macosx-10.6-x86_64.exe |
|---|---|
| Size | 102.6 kB |
| Tags | Source |
|
SHA-256 checksum How to use checksums |
c9f4741364e07c207e1844311da8e0d126cc498235a689bd5bda3bcbfe4868d0
|
|
BLAKE2b-256 checksum How to use checksums |
0749f30259c60717d8d54bf32f1ecf03d8d498df983ce15a39632088ebe61130
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
