[SCIDB-80] Implement SQL sub-module Created: 27/Feb/19  Updated: 30/Jun/20  Resolved: 05/Apr/19

Status: Done
Project: Science Database
Component/s: None
Affects Version/s: None
Fix Version/s: None

Type: Task Priority: Normal
Reporter: michitaro Assignee: michitaro
Resolution: Done Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Epic Link: Implement hscdata module

 Description   
  • SQL sub-module
    This module is for throwing SQL and retrieving resultant records from the Postgres database.
    The usage of it will be something like:
    object_id, mag = hscdata.sql.asNumpy('select object_id, imag_kron  from s18a_wide.forced limit 10' )
    object_id._class_ => numpy.ndarray
    mag._class_ => numpy.ndarra

 Comments   
Comment by michitaro [ 05/Apr/19 ]

done.

Comment by michitaro [ 30/Jun/20 ]

I should rewrite the code using pandas.read_sql_query to clean up it.

 

Generated at Sat Feb 10 16:46:20 JST 2024 using Jira 8.3.4#803005-sha1:1f96e09b3c60279a408a2ae47be3c745f571388b.