rychard / sqlconverter Goto Github PK

For instance, there should be at least one queue item per table, and the completion of that task depends on creating the table within the SQLite database, as well as copying the data over. The data could display progression based on how many records have been inserted into the SQLite database out of the number of records that existed in the source table.

Calculate the time taken for the conversion process. If possible, do not include any elapsed time while user prompts are open.

After a SQLite database is generated, the file remains locked until the application is closed.

As there is no code that executes when the program is exiting, I am led to believe that the operating system is cleaning up file handles that are erroneously left open by the code.

After the generation of SQLite files, I have to rename them prior to using them in my project, as it requires SQLite databases to follow a specific naming convention. It would be ideal if I could specify a template string in the XML configuration file that would construct the name of the file dynamically based on the presence of supported tokens. It's important that it supports multiple tokens in the template string.

Examples of replacements:
%h = 2-digit hour in 24-hour format
%H = 2-digit hour in 12-hour format
%a = AM or PM
%i = 2-digit minute
%s = 2-digit second
%d = 2-digit day of the month
%m = 2-digit month of the year
%Y = 4-digit year (e.g., 2005)
%y = 2-digit year (e.g., 05)
%f = Windows file time
%u = unix time
%g = random GUID
%t = prompt for user text

Currently, there's no way to determine the time it takes any individual process to complete. Simply prefixing the status messages with a timestamp would allow this to be done at a glance.