SQLite migration project iphone

Mobile application v1 is using a sqlite db '[url removed, login to view]'. v1 app has been released for 6 months in the app store market. All users have been feeding db with personal data.

A new app v2 is implementing new features, need to be release to the market, and all the v1 application users need to keep all their personal data inside v2 upgraded application.

To accomplish this, '[url removed, login to view]' need to be an extension of '[url removed, login to view]' with new column fields

## Deliverables

**SQLite migrator project**

**Context**

Mobile application v1 is using a sqlite db '[url removed, login to view]'. v1 app has been released for 6 months in the app store market. All users have been feeding db with personal data.

A new app v2 is implementing new features, need to be release to the market, and all the v1 application users need to keep all their personal data inside v2 upgraded application.

To accomplish this, '[url removed, login to view]' need to be an extension of '[url removed, login to view]' with new column fields

**Steps to execute at application launch**

All steps need to be logout to console

**0/ Is db has been already migrated?**

Load application user's specific data and look for 2 specific variables 'SQLITE_MIGRATION_PROCESS 'and 'SQLITE_FILENAME.

If SQLITE_MIGRATION_PROCESS =DONE, use SQLITE_FILENAME all along application, and break migration process

If SQLITE_MIGRATION_PROCESS not defined (or =ERROR) we need to run the migration process

Display: variables and values

**0/ Check if v2 is empty?**

Check if '[url removed, login to view]' is empty or not. If not empty, we skip the migration process

Display: migration done/not done yet

Process=ERROR

If empty we start migration process

**1/ Check that v2 can contain all data from v1**

Checking that all columns from v1 do exist in '[url removed, login to view]'

Display: verification success/failure

Alert message is migration not possible

**2/ Copy all data from v1 to v2**

All tables, all columns copy to new '[url removed, login to view]'

Display status: how many tables/columns have been copied

**3/ Remove '[url removed, login to view]' from application**

In order to reduce overall application footprint size on the phone

**4/ Use '[url removed, login to view]' all along application**

Save the information inside application user data that migration process have been done, to make sure the process will be skipped at next app startup

SQLITE_MIGRATION_PROCESS=DONE

SQLITE_FILENAME ='[url removed, login to view]'

**Interesting URL**

<[url removed, login to view]>

<[url removed, login to view]>

移动应用开发 Objective C

项目ID： #2769734

关于项目