Example #1
0
gboolean
journal_store_scan(JournalStore *js,
                   JournalStoreScanCallback scan_cb,
                   const gpointer scan_data,
                   JournalStoreSummaryCallback cb_func,
                   const gpointer cb_data) {
	int ret;
	sqlite3_stmt *stmt = NULL;
	int matchcount = 0;

	SQLCHECK(sqlite3_prepare(js->db,
		"SELECT itemid, timestamp, subject, event, security "
		"FROM entry ORDER BY itemid ASC",
		-1, &stmt, NULL));

	ret = sqlite3_step(stmt);
	while (ret == SQLITE_ROW) {
		int itemid = sqlite3_column_int(stmt, 0);
		time_t timestamp = sqlite3_column_int(stmt, 1);
		const char *subject = (char*)sqlite3_column_text(stmt, 2);
		const char *event = (char*)sqlite3_column_text(stmt, 3);
		LJSecurity sec = {0};
		if (sqlite3_column_type(stmt, 4) != SQLITE_NULL)
			security_from_int(&sec, sqlite3_column_int(stmt, 4));

		if (scan_cb(subject, scan_data) || scan_cb(event, scan_data)) {
			const char *summary = lj_get_summary(subject, event);
			cb_func(itemid, timestamp, summary, &sec, cb_data);
			if (++matchcount == MAX_MATCHES)
				break;
		}
		ret = sqlite3_step(stmt);
	}

	if (ret != SQLITE_ROW && ret != SQLITE_DONE) {
		SQLCHECK(ret);
		SQLCHECK(sqlite3_finalize(stmt));
		return FALSE;
	}

	SQLCHECK(sqlite3_finalize(stmt));

	return TRUE;
}
Example #2
0
gboolean
journal_store_get_day_entries(JournalStore *js,
                              int year, int mon, int day,
                              JournalStoreSummaryCallback cb_func,
                              gpointer cb_data) {
	int ret;
	sqlite3_stmt *stmt = NULL;
	const char *subject;
	const char *event;
	LJSecurity sec = {0};

	SQLCHECK(sqlite3_prepare(js->db,
		"SELECT itemid, timestamp, subject, event "
		"FROM entry WHERE year=?1 AND month=?2 AND day=?3",
		-1, &stmt, NULL));
	SQLCHECK(sqlite3_bind_int(stmt, 1, year));
	SQLCHECK(sqlite3_bind_int(stmt, 2, mon));
	SQLCHECK(sqlite3_bind_int(stmt, 3, day));

	ret = sqlite3_step(stmt);
	while (ret == SQLITE_ROW) {
		int itemid = sqlite3_column_int(stmt, 0);
		time_t timestamp = sqlite3_column_int(stmt, 1);
		subject = (char*)sqlite3_column_text(stmt, 2);
		event = (char*)sqlite3_column_text(stmt, 3);
		cb_func(itemid, timestamp,
				lj_get_summary(subject, event), &sec /* XXX */,
				cb_data);
		ret = sqlite3_step(stmt);
	}
	if (ret != SQLITE_DONE) {
		SQLCHECK(ret);
		SQLCHECK(sqlite3_finalize(stmt));
		return FALSE;
	}

	SQLCHECK(sqlite3_finalize(stmt));

	return TRUE;
}
Example #3
0
const char*
lj_entry_make_summary(LJEntry *entry) {
	return lj_get_summary(entry->subject, entry->event);
}