/// <exception cref="System.Exception"></exception> public virtual void DumpTableMaps() { Cursor cursor = database.GetDatabase().RawQuery("SELECT * FROM maps", null); while (cursor.MoveToNext()) { int viewId = cursor.GetInt(0); int sequence = cursor.GetInt(1); byte[] key = cursor.GetBlob(2); string keyStr = null; if (key != null) { keyStr = Sharpen.Runtime.GetStringForBytes(key); } byte[] value = cursor.GetBlob(3); string valueStr = null; if (value != null) { valueStr = Sharpen.Runtime.GetStringForBytes(value); } Log.D(Tag, string.Format("Maps row viewId: %s seq: %s, key: %s, val: %s", viewId, sequence, keyStr, valueStr)); } }
public long GetLastSequenceIndexed() { string sql = "SELECT lastSequence FROM views WHERE name=?"; string[] args = new string[] { name }; Cursor cursor = null; long result = -1; try { cursor = database.GetDatabase().RawQuery(sql, args); if (cursor.MoveToNext()) { result = cursor.GetLong(0); } } catch (Exception e) { Log.E(Log.TagView, "Error getting last sequence indexed", e); } finally { if (cursor != null) { cursor.Close(); } } return(result); }
public long GetLastSequenceIndexed() { string sql = "SELECT lastSequence FROM views WHERE name=?"; string[] args = new string[] { name }; Cursor cursor = null; long result = -1; try { Log.D(Database.TagSql, Sharpen.Thread.CurrentThread().GetName() + " start running query: " + sql); cursor = database.GetDatabase().RawQuery(sql, args); Log.D(Database.TagSql, Sharpen.Thread.CurrentThread().GetName() + " finish running query: " + sql); if (cursor.MoveToNext()) { result = cursor.GetLong(0); } } catch (Exception e) { Log.E(Database.Tag, "Error getting last sequence indexed", e); } finally { if (cursor != null) { cursor.Close(); } } return(result); }