Test Archive SQLite C++ DLL

Phase 1: Create a tool to archive test results in a database file. Create the DB file and a connection. The DB should be a SQLite standalone file (“[login to view URL]”). When the file does not exist, create it and generate the DB structure. With the DB creation add an entry to the table version SetNo=0, Key = “DB”, Value “1”. When the DB file was preexisting use it. It should be possible to replace the file in the future with a real PostgreSQL DB server connection. Provide a simple GUI to enter, view and update data into the database. Such as HardwareSet, Tester and Testset. You can use the “DB browser for SQLite” as a GUI. ([login to view URL]) Provide a API dll to read and write from the DB. The API dll will be used later in a C++ program. Provide a simple C++ main program to show and test the API functionality. It could be command line without GUI. We need at least the following API functions: Errorcode = Connect(String Server, String User, String Password) Void Disconnect() Int version = GetDLLVersion() SetNo = AddTestSet(String Name, String Description, int HWNo, int TesterNo); TestNo = AddTest(int SetNo, String Name, String Description, String Script, String Version) Void AddVersion(int SetNo, String Key, String Value) String version = GetVersion(int SetNo, String Key, String Value) Int SetNo = GetLastTestSetNo() Void UpdateTest(int TestNo, int Passed, int Failed) Void AddTestResult(int TestNo, String Key, String Value) ListNo = AddResultList(int TestNo, String Name) void AddReslutListValue(int ListNo, String Key, String Value) Void RemoveTestSet(int SetNo) The date field should be set to the current date and time when a new entry was added. With removing a TestSet (RemoveTestSet ) all related entries should be removed. With get version the DLL should return its own version number. Some methods need to return the primary key which was used to create the entry. The program has to run under Windows 7/8/10 32/64bit. You need to provide the source code which is able to compile under Visual Studio 2010/2012. All parts should be usable for commercial purpose. (So check the license of tools and libs you are using) Your source code should follow the current methods of development. You have to test your solution. When your development was done I plan to take ~3 week for testing. The project is Phase1. Your bid and your rating will be based on this task. When Phase1 was completed successfully I want to go ahead with some follow up projects: Phase 2 (Read and parse data from log files. Write data via API into the database. Create a command line tool to use the API via command line.) Phase 3 (Use PostgreSQL DB instead of [login to view URL] file) Phase 4 (Create an exporter to export data from a [login to view URL] file to a PostgreSQL DB) I would be happy to get your comments and a not binding bid for these following projects as well.