I am looking for a quote on creating a Maintenance Objective C class that applies SQL maintenance scripts to a targeted sqlite database.
Overview. Maintenance is an objective C wrapper uses mainly in iPhone applications to allow remote modification of an existing sqlite database file.
The Maintenance class is given a path to an another sqlite database, checks the version of the database to be modified determine which set of scripts to run. Each script may contain many sql statements. The sql statements are delimited by ;.
The Maintenance class should run each sql statements within each sql script, and allow failures.
That is, if a SQL statement within a script fails to run, do not execute the rest of that script, but do continue to run the sql statements in the next script.
The deliverable is open source code XCode Project that works as expected.