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)); }