easyaccess
easyaccess copied to clipboard
mgckind
SQL command line interpreter for astronomical surveys
Bumps [numpy](https://github.com/numpy/numpy) from 1.19.2 to 1.22.0. Release notes Sourced from numpy's releases. v1.22.0 NumPy 1.22.0 Release Notes NumPy 1.22.0 is a big release featuring the work of 153 contributors spread...
![dependabot[bot] avatar](https://avatars.githubusercontent.com/in/29110?v=4 "dependabot[bot] avatar"){kind=avatar}
Numpy/FITS has a boolean data type but Oracle does not. We should still be able to upload boolean data, maybe casting it to `NUMBER(1)`. What is the "correct" thing to...
I'm running easyaccess v1.4.7 on Scientific Linux. This is as user `delve_reader` from the DECADE database ``` DECADE ~> whoami Traceback (most recent call last): File "/cvmfs/des.opensciencegrid.org/fnal/anaconda2/envs/des20a/bin/easyaccess", line 3, in...
There appear to be new python 3 related forking warnings on osx. I can post a copy if you all are interested in fixing.
When querying interactively, SQL CASE statements that yield string values work just fine. However, if you write the results of the query to a text file (either .csv or .tab),...
@djbrout noticed that long integers were being corrupted on upload to the DESDM DB (specifically the `SOURCE_ID` column of `kadrlica.GAIA_DR2_X_DES_DR1`). I think that NUMBER(20,0) is long enough to hold these...
It would be good to add an automated cross check that the number of rows upload is the same as the number of rows in the input file. I think...
A certain query executes fine from within easyaccess but results in an error when redirected to a csv file. Example: ``` DESSCI ~> select * from Y3A1_COADD_OBJECT_SUMMARY A INNER JOIN...
