public static void RemoveStoredJson(String key)
{
using (PostgresDatabase postgresDatabase = new PostgresDatabase())
{
postgresDatabase.CreateCommand();
postgresDatabase.AddDbParameter("Id", PostgresDatabase.DBTYPE_STRING, 255, false, key);
postgresDatabase.ExecuteCommand(string.Format("DELETE FROM StoredJson WHERE Id = {0}Id", postgresDatabase.ParameterPrefix));
postgresDatabase.Commit();
}
}
public static void SetStoredJson(String key, String json)
{
using (PostgresDatabase postgresDatabase = new PostgresDatabase())
{
postgresDatabase.CreateCommand();
postgresDatabase.AddDbParameter("Id", PostgresDatabase.DBTYPE_STRING, 255, false, key);
postgresDatabase.AddDbParameter("Json", PostgresDatabase.DBTYPE_JSON, -1, true, json);
if (string.IsNullOrWhiteSpace(GetStoredJson(key)) == true)
{
postgresDatabase.ExecuteCommand(string.Format("INSERT INTO StoredJson (Id, Json) VALUES ({0}Id, {0}Json)", postgresDatabase.ParameterPrefix));
}
else
{
postgresDatabase.ExecuteCommand(string.Format("UPDATE StoredJson SET Json = {0}Json WHERE Id = {0}Id", postgresDatabase.ParameterPrefix));
}
postgresDatabase.Commit();
}
}