Hello Everyone,
Is there a way know all the contacts added/edited/deleted from the
contacts.db in a certain time interval?
I don't see any timestamp column in the people table and although the
timestamp is being populated into the voice_dialer_timestamp table(the last
TRIGGER does this) for some reason this timestamp is always written into the
row with _id=1..
The following is the output of '.schema people' on
/data/data/com.android.providers.contacts/contacts.db
__________________________________________
CREATE TABLE people (
_id INTEGER PRIMARY KEY AUTOINCREMENT,
_sync_account TEXT,
_sync_id TEXT,
_sync_time TEXT,
_sync_version TEXT,
_sync_local_id INTEGER,
_sync_dirty INTEGER NOT NULL DEFAULT 0,
_sync_mark INTEGER,
name TEXT COLLATE LOCALIZED,
notes TEXT COLLATE LOCALIZED,
times_contacted INTEGER NOT NULL DEFAULT 0,
last_time_contacted INTEGER,
starred INTEGER NOT NULL DEFAULT 0,
primary_phone INTEGER REFERENCES phones(_id),
primary_organization INTEGER REFERENCES organizations(_id),
primary_email INTEGER REFERENCES contact_methods(_id),
photo_version TEXT,
custom_ringtone TEXT,
send_to_voicemail INTEGER);
CREATE INDEX peopleNameIndex ON people (name);
CREATE INDEX peopleSyncDirtyIndex ON people (_sync_dirty);
CREATE INDEX peopleSyncIdIndex ON people (_sync_id);
CREATE TRIGGER contact_cleanup DELETE ON people
BEGIN
DELETE FROM peopleLookup WHERE source = old._id;
DELETE FROM phones WHERE person = old._id;
DELETE FROM contact_methods WHERE person = old._id;
DELETE FROM organizations WHERE person = old._id;
DELETE FROM groupmembership WHERE person = old._id;
DELETE FROM extensions WHERE person = old._id;
END;
CREATE TRIGGER peopleDeleteAndPhotos DELETE ON people
BEGIN
DELETE FROM photos WHERE person=OLD._id;
END;
CREATE TRIGGER peopleLookup_insert AFTER INSERT ON people
BEGIN
SELECT _TOKENIZE('peopleLookup', new._id, new.name, ' ');
END;
CREATE TRIGGER peopleLookup_update UPDATE OF name ON people
BEGIN
DELETE FROM peopleLookup WHERE source = new._id;
SELECT _TOKENIZE('peopleLookup', new._id, new.name, ' ');
END;
CREATE TRIGGER people_timesContacted UPDATE OF last_time_contacted ON people
BEGIN UPDATE people SET times_contacted = (new.times_contacted + 1) WHERE
_id = new._id;END;
CREATE TRIGGER timestamp_trigger2 AFTER UPDATE OF name ON people BEGIN
UPDATE voice_dialer_timestamp SET timestamp=strftime('%s', 'now') WHERE
_id=1;END;
__________________________________________________________
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google
Groups "Android Developers" group.
To post to this group, send email to android-developers@googlegroups.com
To unsubscribe from this group, send email to
android-developers-unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/android-developers?hl=en
-~----------~----~----~----~------~----~------~--~---
