public object readEntry(string section, string key)
{
if (!getSections().Contains(section))
{
return(null);
}
SqlQuery query = new SqlQuery();
//query.Password = mPassword;
SqlStringBuilder builder = SqlStringBuilderFactory.createSELECT();
{
var withBlock = builder;
withBlock.addTable(section);
withBlock.addColumn("Json");
withBlock.addCondition("Key", "=", key);
}
string qs = builder.ToString();
Dictionary <string, object> @params = builder.getParameterValues();
List <List <string> > dt = query.execute(qs, mDatabase, @params);
if (dt == null || dt.Count == 0)
{
return(null);
}
return(dt[0][0]);
}
private ArrayList getTables()
{
ArrayList result = new ArrayList();
SqlQuery query = new SqlQuery();
//query.Password = mPassword;
SqlStringBuilder builder = SqlStringBuilderFactory.createSELECT();
{
var withBlock = builder;
withBlock.addTable("sqlite_master");
withBlock.addColumn("name");
withBlock.addCondition("type", "=", "table");
}
string qs = builder.ToString();
Dictionary <string, object> @params = builder.getParameterValues();
List <List <string> > dt = query.execute(qs, mDatabase, @params);
if (dt == null || dt.Count == 0)
{
return(result);
}
foreach (List <string> row in dt)
{
result.Add(row[0]);
}
return(result);
}
public List <List <string> > getKeyValuePairs(string section)
{
if (!getSections().Contains(section))
{
return(null);
}
SqlQuery query = new SqlQuery();
//query.Password = mPassword;
SqlStringBuilder builder = SqlStringBuilderFactory.createSELECT();
{
var table = builder;
table.addTable(section);
table.addColumn("Key");
table.addColumn("Json");
}
string qs = builder.ToString();
Dictionary <string, object> @params = builder.getParameterValues();
List <List <string> > dt = query.execute(qs, mDatabase, @params);
if (dt == null || dt.Count == 0)
{
return(new List <List <string> >());//new List<KeyValuePair<string, string>>();
}
return(dt);
//(from row in dt
// select new KeyValuePair<string, string>(row[0].ToString(), row[1].ToString())).ToList();
}
public bool writeEntry(string section, string key, object value)
{
SqlNonQuery nonquery = new SqlNonQuery();
if (!(getSections().Contains(section)))
{
if (!createTable())
{
return(false);
}
}
bool isUpdate = readEntry(section, key) != null;
SqlStringBuilder builder;
if (value == null)
{
builder = SqlStringBuilderFactory.createDELETE();
{
var withBlock = builder;
withBlock.addTable(section);
withBlock.addCondition("Key", "=", key);
}
}
else
{
builder = isUpdate ? Data.SqlStringBuilderFactory.createUPDATE() : Data.SqlStringBuilderFactory.createINSERT();
{
var table = builder;
table.addTable(section);
table.addValue("Key", key);
table.addValue("Json", value);
if (isUpdate)
{
table.addCondition("Key", "=", key);
//table.addCondition("Json", "=", value);
}
}
}
string qs = builder.ToString();
Dictionary <string, object> @params = builder.getParameterValues();
int result = nonquery.execute(qs, mDatabase, @params);
return(result > 0);
}
private bool createTable()
{
SqlNonQuery nonquery = new SqlNonQuery();
//nonquery.Password = mPassword;
SqlStringBuilder builder = SqlStringBuilderFactory.createCREATE_TABLE();
{
var table = builder;
table.addTable(TABLENAME);
table.addColumn("Key", "VARCHAR", 100, false);
table.addColumn("Json", "VARCHAR", 5000000, false);
table.setPrimaryKey("Key");
}
string qs = builder.ToString();
Dictionary <string, object> @params = builder.getParameterValues();
int result = nonquery.execute(qs, mDatabase, @params);
return(getSections().Contains(TABLENAME));
}
