GNU Astronomy Utilities - Tasks: task #16211, Table using ADQL to work with...
You are not allowed to post comments on this tracker with your current authentication level.
task #16211: Table using ADQL to work with input tables
Submitter: | Mohammad Akhlaghi <makhlaghi> | ||
Submitted: | Sat 28 May 2022 05:38:20 PM UTC | ||
Should Start On: | Fri 27 May 2022 11:00:00 PM UTC | Should be Finished on: | Fri 27 May 2022 11:00:00 PM UTC |
Category: | Table | Priority: | 5 - Normal |
Item Group: | Enhancement | Status: | Postponed |
Privacy: | Public | Assigned to: | None |
Percent Complete: | 0% | Open/Closed: | Open |
Effort: | 0.00 |
Fri 14 Jul 2023 08:03:38 PM UTC, comment #1: |
Pedram Ashofteh-Ardakani <pedram> |
Sat 28 May 2022 05:38:20 PM UTC, original submission:
Currently, Gnuastro's Table program has a set of options for manipulating the input table(s), to create a new output table. However, this syntax is needs some time to master (it is designed for ease of usage on the command-line) and is too specific to Gnuastro's Table.
|
Mohammad Akhlaghi <makhlaghi> |
No files currently attached
Depends on the following items: None found
Items that depend on this one: None found
There are 0 votes so far. Votes easily highlight which items people would like to see resolved in priority, independently of the priority of the item set by tracker managers.
Follows 1 latest change.
Date | Changed by | Updated Field | Previous Value | => | Replaced by |
---|---|---|---|---|---|
2022-05-28 | makhlaghi | Carbon-Copy | - | Added -email is unavailable- |
Powered by Savane 3.13-758e.
Corresponding source code
= Minimal working example =
To get a minimal working example, I tried playing around with the SQLite C API first.
I've created this repository. To try it out, you'd only need to clone and execute GNU Make:
This will create the "main" program which takes the database as the first argument, and the query as its second argument. For instance:
It will print out the results with extra debugging information.
= Next Steps =
We need to convert from/to 'gal_data_t' structure. We can use the 'gal_data_t' column data types to create a temporary (or even permanent) database, and execute a SQL query on it. Finally, the output can stay in SQLite3 form, or get converted back to 'gal_data_t', and be saved in the FITS format.