public bool insertOrUpdate(Kv kv)
{
string sql = $"insert or replace into {tbName_} (k,v,r) values (:k,:v,:r)";
SQLiteCommand command = new SQLiteCommand(sql, conn_);
command.Parameters.Add(new SQLiteParameter(":k", kv.k));
command.Parameters.Add(new SQLiteParameter(":v", kv.v));
command.Parameters.Add(new SQLiteParameter(":r", kv.r));
command.ExecuteNonQuery();
return(true);
}
public List <Kv> fuzzyQuery(string k)
{
string sql = $"select * from {tbName_} where k like :k";
SQLiteCommand cmd = new SQLiteCommand(sql, conn_);
cmd.Parameters.Add(new SQLiteParameter(":k", $"%{k}%"));
SQLiteDataReader dr = cmd.ExecuteReader();
List <Kv> result = new List <Kv>();
if (dr != null && dr.Read())
{
Kv kv = new Kv();
kv.k = dr["k"] as string;
kv.v = dr["v"] as string;
kv.r = dr["r"] as string;
result.Add(kv);
}
return(result);
}
