Add SQL Export Format to `lino pull` Command - Githubissues

CGI-FR / LINO

Large Input Narrow Output - LINO is a simple ETL tool to manage tests data.

https://cgi-fr.github.io/lino-doc/

GNU General Public License v3.0

20 stars 3 forks source link

Add SQL Export Format to `lino pull` Command #311

Open youen opened 2 months ago

youen commented 2 months ago

As part of the effort to support multiple export formats in the lino pull command, this sub-task focuses on implementing SQL format support (#309).

Tasks:

Implement SQL generation logic that converts the pulled data into SQL INSERT statements.
Add a --format sql option to the lino pull command.
Ensure that the SQL export can handle all existing lino pull flags and options (e.g., --limit, --filter, --where).
Add unit and integration tests to verify SQL generation accuracy.
Update the documentation with examples of how to use the SQL export format.

Acceptance Criteria:

The lino pull command generates valid SQL scripts that can be executed to initialize a test database.
All relevant lino pull flags and options are compatible with the SQL export format.
Documentation is updated with SQL format usage examples.