/// <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);
}
