maddes8cht / sqlite-demo Goto Github PK

Add a simple gtk interface as a seperate program.
This will allow the user to select a file and then the program will read the file and display the data.

Assignees: @maddes8cht
Labels: enhancement
Milestone:

Doxygen generation should work:

• generating full html output
• full LaTeX output
• generating PDF output from the LaTeX output
• generating rtf output (neglectible, but nice)
• generating graphs and uml using GraphViz, Dot and PlantUML
• integrating these graphs in the different output formats

Assignees: @maddes8cht
Labels: documentation enhancement
Milestone:

I managed to get the first test example to compile and run, but it does not feel like a test nor does it execute in the supposed tsting environment.
So this needs to be fixed first.

Assignees: @maddes8cht
Labels:
Milestone:

ExecuteSelect should use and return a result object.
Result object will have

• result.result
• result.header
• result.rows
• result.columns
• result.print() will print the result

currently, the executeSqlStatement function already prints the results.
printSqlResults is not needed right now.
But i also need a function to execute an SQl statement and get the results back without printing them.
There is a problem when trying to print a result as it is returned by executeSelectStatement, because it does not contain the header information.
My ide is to have the sqlHelper class have a currentResult and a currentHeader.
The executeSqlStatement function will execute the sql statement and set the currentResult and the currentHeader.
The printSqlResult function will print the currentResult and the currentHeader.
I think it is cleaner to have the sqlHelper class have the currentResult and the currentHeader.
I can still always copy the header and the result into a new variable.

Assignees: @maddes8cht
Labels: enhancement
Milestone:

Create a Demo Project for SQLite to demonstrate how to use SQLite in a c++ aplication

create a simple c++ program to use the SQLite libraries

• import the libraries in msys2 to make them available
• document how to do that
• include all the necessary files
• create a proper makefile to build the sample project