public void DeleteEngineItem(EngineItem item)
{
try
{
session = cluster.Connect(KEYSPACE);
session.Execute(string.Format("delete from engineitems where id = '{0}';", item.id.ToString()));
}
catch (Exception ex)
{
ErrorHandler.Publish(LogLevel.Error, "CassandraProvider Error:" + ex.Message, ex);
}
}
public void UpdateEngineItem(EngineItem item)
{
try
{
session = cluster.Connect(KEYSPACE);
session.Execute(string.Format("update engineitems set name = '{1}', engineid = '{2}', locationurl = '{3}', type = '{4}', collectionname = '{5}', indexpath = '{6}' where id = '{0}';",
item.id.ToString(), item.name, item.engineid.ToString(), item.locationurl, item.type, item.collectionname, item.indexpath));
}
catch (Exception ex)
{
ErrorHandler.Publish(LogLevel.Error, "CassandraProvider Error:" + ex.Message, ex);
}
}
public Guid AddNewEngineItem(EngineItem item)
{
try
{
var newId = Guid.NewGuid();
session = cluster.Connect(KEYSPACE);
session.Execute(string.Format("insert into engineitems (id, name, engineid, locationurl, type, collectionname, indexpath) values ('{0}','{1}', '{2}', '{3}', '{4}', '{5}', '{6}');",
newId.ToString(), item.name, item.engineid.ToString(), item.locationurl, item.type, item.collectionname, item.indexpath));
return(newId);
}
catch (Exception ex)
{
ErrorHandler.Publish(LogLevel.Error, "CassandraProvider Error:" + ex.Message, ex);
}
return(Guid.Empty);
}
public EngineItem GetEngineItem(Guid engineItemId)
{
EngineItem engine = new EngineItem();
try
{
session = cluster.Connect(KEYSPACE);
RowSet rows = session.Execute("select * from engineitems where id = '" + engineItemId.ToString() + "';");
foreach (Row item in rows)
{
return(new EngineItem()
{
id = Guid.Parse(item["id"].ToString()), name = item["name"].ToString(), engineid = Guid.Parse(item["engineid"].ToString()), collectionname = item["collectionname"].ToString(), indexpath = item["indexpath"].ToString(), locationurl = item["locationurl"].ToString(), type = item["type"].ToString()
});
}
}
catch (Exception ex)
{
ErrorHandler.Publish(LogLevel.Error, "CassandraProvider Error:" + ex.Message, ex);
}
return(null);
}