/// <summary> /// Helper method for queries fetching an event. /// </summary> private AnpMsg GetEventFromQuery(String s) { Object res = m_db.GetCmd(s).ExecuteScalar(); if (res == null) { return(null); } AnpMsg m = new AnpMsg(); m.FromByteArray((byte[])res, true); return(m); }
/// <summary> /// Fetch at most 'limit' EAnp events from the database, starting at /// evtID. /// </summary> public List <AnpMsg> FetchEAnpEvents(UInt64 kwsID, UInt64 evtID, UInt32 limit) { String s = "SELECT evt_data FROM eanp_events WHERE kws_id = " + kwsID + " AND evt_id > " + evtID + " ORDER BY evt_id LIMIT " + limit + ";"; List <AnpMsg> res = new List <AnpMsg>(); DbDataReader reader = m_db.GetCmd(s).ExecuteReader(); while (reader.Read()) { AnpMsg m = new AnpMsg(); m.FromByteArray((byte[])reader.GetValue(0), true); res.Add(m); } return(res); }