# 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
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
easyaccess-1.0.6.tar.gz
(20.5 kB
view details)
Built Distribution
Filter files by name, interpreter, ABI, and platform.
If you're not sure about the file name format, learn more about wheel file names.
Copy a direct link to the current filters
File details
Details for the file easyaccess-1.0.6.tar.gz.
File metadata
- Download URL: easyaccess-1.0.6.tar.gz
- Upload date:
- Size: 20.5 kB
- Tags: Source
- Uploaded using Trusted Publishing? No
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 |
2a4e3ab05a20026dfb7c7b89d4fc694517291e9cabc5b70d3693e1f72e3e2e81
|
|
| MD5 |
f5721ffc24965331f86fe5a6f9902ef5
|
|
| BLAKE2b-256 |
00cf87318f2db03fe6882477df5dfa671f5c4d04a27761e51e77d75e99134465
|
File details
Details for the file easyaccess-1.0.6.macosx-10.6-x86_64.exe.
File metadata
- Download URL: easyaccess-1.0.6.macosx-10.6-x86_64.exe
- Upload date:
- Size: 102.6 kB
- Tags: Source
- Uploaded using Trusted Publishing? No
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 |
c9f4741364e07c207e1844311da8e0d126cc498235a689bd5bda3bcbfe4868d0
|
|
| MD5 |
2250831e63d944cb07cd456643883464
|
|
| BLAKE2b-256 |
0749f30259c60717d8d54bf32f1ecf03d8d498df983ce15a39632088ebe61130
|
