Simple Android App (sqlite database & cellphone contacts) -- 2

Job ID: 31064550

Budget: $30 – $250 USD

I’m connected to a body area network which creates problems for me. I cannot keep contacts in my cellphone contact list for long periods of time. The name of the android app is "Phone Sitter"

I need a simple android app to modify the contact list in my cellphone. It involves keeping my contacts in a SQLite database & using a script to copy contacts to cellphone contact list, wait specified time, delete all contacts in cellphone phone and repeat with a specified time. Both specified times found in the settings table in the SQLite file. I’d like the script to run on startup without user intervention. The app can be disabled if settings table has 0 for disable. Program exits when disable equals 1. I would get this script going myself but have too many hurdles with being slowed down by nanomaterials. I plan on using Sqlite Master from the android store to add contacts to the contacts table and adjust settings within the settings table to save time creating a graphical interface. Multiple tables are created for 4 different lists of contacts within the Sqlite database. The table name for which table of contacts to load is specified within the settings table.

A new sqlite database is created if one does not already exist named: phone_sitter.sqlite with a settings table and 4 contact tables named away, work, home1, home2 defined below.

SQLite database contains:

Settings table with three columns named id, setting, parameter with the following rows added by default:
id, contacts_table, away
id, disable, 0
id, time_in, 30
id, time_out, 3600

Note:
It's easier to edit settings displayed in rows rather than columns with Sqlite Master
away is the contact table set to load
0 is boolean or int
30 and 3600 are defined in seconds

Contacts table with columns for:
Id, name, number, email, url/website

I’m expecting well documented source code & compiled app to run on Android 9.0 Pie operating system included with Samsung J2 (S260DL).

Please ask questions if any clarification is needed.
Related categories: Android App Development