public void RemoveRelationship(string id)
{
var comm1 = new NpgsqlCommand("select master from relationship where slave=@id", _connection);
comm1.Parameters.AddWithValue("@id", id);
var reader = comm1.ExecuteReader();
if (reader.Read())
{
var masterId = reader.GetString(0);
DBFactory.DeleteMemcachedRelationship(masterId, id);
}
reader.Close();
var comm2 = new NpgsqlCommand("delete from relationship where slave=@id", _connection);
comm2.Parameters.AddWithValue("@id", id);
comm2.ExecuteNonQuery();
}
public void Remove(string id)
{
var comm1 = new NpgsqlCommand("delete from content where id=@id", _connection);
comm1.Parameters.AddWithValue("@id", id);
comm1.ExecuteNonQuery();
DBFactory.DeleteMemcachedData(id);
//var comm2 = new NpgsqlCommand("delete from relationship where slave=@id", _connection);
//comm2.Parameters.AddWithValue("@id", id);
//comm2.ExecuteNonQuery();
RemoveRelationship(id);
var list = DBFactory.GetMemcachedRelationship(id);
if (list == null)
{
list = new List <string>();
var comm3 = new NpgsqlCommand("select slave from relationship where master=@id", _connection);
comm3.Parameters.AddWithValue("@id", id);
var reader = comm3.ExecuteReader();
while (reader.Read())
{
list.Add(reader.GetString(0));
}
reader.Close();
}
foreach (var kidId in list)
{
Remove(kidId);
}
var comm4 = new NpgsqlCommand("delete from relationship where master=@id", _connection);
comm4.Parameters.AddWithValue("@id", id);
comm4.ExecuteNonQuery();
DBFactory.DeleteMemcachedRelationship(id);
}
