private void SerializeDeserializeTest(bool prepared)
{
PreparedStatement insertPs = null;
PreparedStatement selectPs = null;
var prefix = "simple-";
if (prepared)
{
insertPs = Session.Prepare(InsertGeoQuery);
selectPs = Session.Prepare(SelectGeoQuery);
prefix = "prepared-";
}
foreach (var value in Values)
{
var id = prefix + value;
var statement = prepared ?
(IStatement)insertPs.Bind(id, value) :
new SimpleStatement(InsertGeoQuery, id, value);
Session.Execute(statement);
statement = prepared ?
(IStatement)selectPs.Bind(id) :
new SimpleStatement(SelectGeoQuery, id);
var row = Session.Execute(statement).FirstOrDefault();
Assert.NotNull(row, "Row with id '{0}' not found", id);
Assert.AreEqual(value, row.GetValue <object>("value"));
}
}
public RowSet InvokeDeleteOrder(object[] parameters)
{
BatchStatement batch = new BatchStatement();
List <Order> orderProducts = EntityMapper.ToOrders(session.Execute(preparedStatements[Statements.SELECT_ORDER_FROM_ORDER].Bind(parameters)));
Product dbProduct;
foreach (Order cancelledOrder in orderProducts)
{
dbProduct = EntityMapper.ToProducts(session.Execute(session.Prepare("SELECT * FROM products WHERE category=? AND productname=?").Bind(cancelledOrder.Category, cancelledOrder.ProductName))).FirstOrDefault();
batch.Add(preparedStatements[Statements.UPDATE_PRODUCT_AMOUNT].Bind(dbProduct.Amount + cancelledOrder.Amount, cancelledOrder.Category, cancelledOrder.ProductName));
}
batch.Add(preparedStatements[Statements.DELETE_ORDER_FROM_ORDERS].Bind(parameters));
return(session.Execute(batch));
}
public Guid Post([FromBody] User user)
{
IDseCluster cluster = DseCluster.Builder()
.AddContactPoint("127.0.0.1")
.Build();
IDseSession session = cluster.Connect();
Guid user_id = Guid.NewGuid();
var insert_user = session.Prepare(
"INSERT INTO driver_test.user (id, first_name, last_name) VALUES(?,?,?)"
);
RowSet results = session.Execute(insert_user.Bind(user_id, user.first_name, user.last_name));
return(user_id);
}
public string Get(Guid id)
{
IDseCluster cluster = DseCluster.Builder()
.AddContactPoint("127.0.0.1")
.Build();
IDseSession session = cluster.Connect();
var get_user = session.Prepare("SELECT * FROM driver_test.user where id = ?");
RowSet results = session.Execute(get_user.Bind(id));
if (results.Any())
{
session.Dispose();
Row user = results.First();
return(user.GetValue <String>("first_name") + user.GetValue <String>("last_name"));
}
else
{
session.Dispose();
return("User not found");
}
}
public IEnumerable <string> Get()
{
IDseCluster cluster = DseCluster.Builder()
.AddContactPoint("127.0.0.1")
.Build();
IDseSession session = cluster.Connect();
var get_users = session.Prepare("SELECT * FROM driver_test.user");
RowSet results = session.Execute(get_users.Bind());
List <string> final_results = new List <string>();
foreach (Row row in results.AsEnumerable())
{
final_results.Add(row.GetValue <Guid>("id").ToString() + " " +
row.GetValue <String>("first_name") + " " +
row.GetValue <String>("last_name") + "\n");
}
return(final_results);
}
