public void Cleanup()
{
var execPg = new ExecPg();
string query = "delete from vendors where id ='587d6b11-1491-456a-8e5c-d28d99ffdded'";
execPg.ExecQuery(query);
query = "delete from categories where id::text in " +
"('1ef43957-05a1-4900-819e-a4d8646188d5','58bd2c46-6f8f-4474-9ba4-1038730e01d4')";
execPg.ExecQuery(query);
}
public string Get(string id)
{
var execPg = new ExecPg();
object queryResult;
queryResult = execPg.ExecQuery(id);
return(JsonConvert.SerializeObject(queryResult));
}
public void Startup()
{
var execPg = new ExecPg();
string query = "INSERT INTO categories(id, name) VALUES " +
"('1ef43957-05a1-4900-819e-a4d8646188d5', 'System utilities')," +
"('58bd2c46-6f8f-4474-9ba4-1038730e01d4','Testing software');";
execPg.ExecQuery(query);
query = "INSERT INTO vendors(id, name, raiting, categories) VALUES " +
"('587d6b11-1491-456a-8e5c-d28d99ffdded', 'Testing corp', '5', '{1ef43957-05a1-4900-819e-a4d8646188d5,58bd2c46-6f8f-4474-9ba4-1038730e01d4}');";
execPg.ExecQuery(query);
}
