public void Prepared_SelectOne()
{
var tableName = TestUtils.GetUniqueTableName();
try
{
QueryTools.ExecuteSyncNonQuery(Session, string.Format(@"
CREATE TABLE {0}(
tweet_id int PRIMARY KEY,
numb double,
label text);", tableName));
TestUtils.WaitForSchemaAgreement(Session.Cluster);
}
catch (AlreadyExistsException)
{
}
for (int i = 0; i < 10; i++)
{
Session.Execute(string.Format("INSERT INTO {0} (tweet_id, numb, label) VALUES({1}, 0.01,'{2}')", tableName, i, "row" + i));
}
var prepSelect = QueryTools.PrepareQuery(Session, string.Format("SELECT * FROM {0} WHERE tweet_id = ?;", tableName));
var rowId = 5;
var result = QueryTools.ExecutePreparedSelectQuery(Session, prepSelect, new object[] { rowId });
foreach (var row in result)
{
Assert.True((string)row.GetValue(typeof(int), "label") == "row" + rowId);
}
Assert.True(result.Columns != null);
Assert.True(result.Columns.Length == 3);
}
public void PreparedSelectOneTest()
{
string tableName = "table" + Guid.NewGuid().ToString("N");
try
{
Session.WaitForSchemaAgreement(
QueryTools.ExecuteSyncNonQuery(Session, string.Format(@"
CREATE TABLE {0}(
tweet_id int PRIMARY KEY,
numb double,
label text);", tableName))
);
}
catch (AlreadyExistsException)
{
}
for (int i = 0; i < 10; i++)
{
Session.Execute(string.Format("INSERT INTO {0} (tweet_id, numb, label) VALUES({1}, 0.01,'{2}')", tableName, i, "row" + i));
}
PreparedStatement prep_select = QueryTools.PrepareQuery(Session, string.Format("SELECT * FROM {0} WHERE tweet_id = ?;", tableName));
int rowID = 5;
var result = QueryTools.ExecutePreparedSelectQuery(Session, prep_select, new object[1] {
rowID
});
foreach (var row in result)
{
Assert.True((string)row.GetValue(typeof(int), "label") == "row" + rowID);
}
Assert.True(result.Columns != null);
Assert.True(result.Columns.Length == 3);
QueryTools.ExecuteSyncNonQuery(Session, string.Format("DROP TABLE {0};", tableName));
}