Lines Matching defs:thread_id
59 " AND " + Sms.THREAD_ID + " = threads._id)" +
63 " WHERE threads._id = new." + Sms.THREAD_ID + "; ";
68 " ON threads._id = " + Sms.THREAD_ID +
69 " WHERE " + Sms.THREAD_ID + " = new.thread_id" +
72 " ON threads._id = " + Mms.THREAD_ID +
73 " WHERE " + Mms.THREAD_ID + " = new.thread_id" +
76 " WHERE threads._id = new.thread_id; ";
81 " ON threads._id = " + Sms.THREAD_ID +
82 " WHERE " + Sms.THREAD_ID + " = old.thread_id" +
85 " ON threads._id = " + Mms.THREAD_ID +
86 " WHERE " + Mms.THREAD_ID + " = old.thread_id" +
89 " WHERE threads._id = old.thread_id; ";
97 " WHERE threads._id = new." + Sms.THREAD_ID + "; " +
122 " AND " + Mms.THREAD_ID + " = threads._id " +
127 " WHERE threads._id = new." + Mms.THREAD_ID + "; ";
135 " WHERE threads._id = new." + Mms.THREAD_ID + "; " +
143 " (SELECT date * 1000 AS date, sub AS snippet, thread_id FROM pdu" +
144 " UNION SELECT date, body AS snippet, thread_id FROM sms)" +
145 " WHERE thread_id = OLD.thread_id ORDER BY date DESC LIMIT 1) " +
146 " WHERE threads._id = OLD.thread_id; " +
149 " (SELECT date * 1000 AS date, sub_cs AS snippet_cs, thread_id FROM pdu" +
150 " UNION SELECT date, 0 AS snippet_cs, thread_id FROM sms)" +
151 " WHERE thread_id = OLD.thread_id ORDER BY date DESC LIMIT 1) " +
152 " WHERE threads._id = OLD.thread_id; ";
164 " (SELECT pdu.thread_id FROM part JOIN pdu ON pdu._id=part.mid " +
176 " (SELECT pdu.thread_id FROM part JOIN pdu ON pdu._id=part.mid " +
194 " WHERE pdu.thread_id = threads._id " +
202 // When the 'thread_id' column in the pdu table is updated, we need to run the trigger to update
206 " AFTER UPDATE of thread_id ON pdu " +
209 " (SELECT pdu.thread_id FROM part JOIN pdu " +
286 public static void updateThread(SQLiteDatabase db, long thread_id) {
287 if (thread_id < 0) {
299 " (SELECT thread_id FROM sms " +
300 " UNION SELECT thread_id FROM pdu)",
301 new String[] { String.valueOf(thread_id) });
311 " ON threads._id = " + Sms.THREAD_ID +
312 " WHERE " + Sms.THREAD_ID + " = " + thread_id +
315 " ON threads._id = " + Mms.THREAD_ID +
316 " WHERE " + Mms.THREAD_ID + " = " + thread_id +
319 " WHERE threads._id = " + thread_id + ";");
329 " (SELECT date * 1000 AS date, thread_id FROM pdu" +
330 " UNION SELECT date, thread_id FROM sms)" +
331 " WHERE thread_id = " + thread_id + " ORDER BY date DESC LIMIT 1)," +
334 " (SELECT date * 1000 AS date, sub AS snippet, thread_id FROM pdu" +
335 " UNION SELECT date, body AS snippet, thread_id FROM sms)" +
336 " WHERE thread_id = " + thread_id + " ORDER BY date DESC LIMIT 1)," +
339 " (SELECT date * 1000 AS date, sub_cs AS snippet_cs, thread_id FROM pdu" +
340 " UNION SELECT date, 0 AS snippet_cs, thread_id FROM sms)" +
341 " WHERE thread_id = " + thread_id + " ORDER BY date DESC LIMIT 1)" +
342 " WHERE threads._id = " + thread_id + ";");
347 String query = "SELECT thread_id FROM sms WHERE type=" +
349 " AND thread_id = " + thread_id +
361 String errorQuery = "SELECT error FROM threads WHERE _id = " + thread_id;
370 " WHERE _id = " + thread_id);
395 "(SELECT DISTINCT thread_id FROM sms " + where + ")";
410 "_id NOT IN (SELECT DISTINCT thread_id FROM sms where thread_id NOT NULL " +
411 "UNION SELECT DISTINCT thread_id FROM pdu where thread_id NOT NULL)", null);
425 int thread_id = -1;
427 Cursor c = db.query("sms", new String[] { "thread_id" },
431 thread_id = c.getInt(0);
438 if (thread_id > 0) {
440 updateThread(db, thread_id);
555 " (type, thread_id);");
566 Mms.THREAD_ID + " INTEGER," +
771 " WHERE threads._id = old." + Mms.THREAD_ID + "; " +
802 " WHERE _id = OLD.thread_id; " +
816 " WHERE _id = OLD.thread_id; " +
825 "thread_id INTEGER," +
967 // " _id = old.thread_id " +
969 // " (SELECT thread_id FROM sms " +
970 // " UNION SELECT thread_id from pdu); " +
974 // "AFTER UPDATE OF " + Mms.THREAD_ID + " ON pdu " +
975 // "WHEN old." + Mms.THREAD_ID + " != new." + Mms.THREAD_ID + " " +
979 // " _id = old.thread_id " +
981 // " (SELECT thread_id FROM sms " +
982 // " UNION SELECT thread_id from pdu); " +
1000 " (SELECT DISTINCT thread_id" +
1017 " WHERE _id = NEW.thread_id; " +
1371 " WHERE _id = OLD.thread_id; " +
1532 db.execSQL("DELETE FROM " + MmsProvider.TABLE_PDU + " WHERE " + Mms.THREAD_ID + " IS NULL");
1809 Mms.THREAD_ID + " INTEGER," +
1873 " (SELECT DISTINCT pdu.thread_id FROM part " +
