protected override void CreateKeyspace(ICluster cluster)
{
const string createKeyspaceFoo = "CREATE KEYSPACE Foo WITH replication = {'class': 'SimpleStrategy', 'replication_factor' : 1}";
cluster.ExecuteNonQuery(createKeyspaceFoo).Wait();
const string createBar = "CREATE TABLE Foo.Bar (id int, Baz blob, PRIMARY KEY (id))";
cluster.ExecuteNonQuery(createBar).Wait();
}
protected override void CreateKeyspace(ICluster cluster)
{
const string createKeyspace = "CREATE KEYSPACE videos WITH replication = {'class': 'SimpleStrategy', 'replication_factor' : 1}";
cluster.ExecuteNonQuery(createKeyspace).Wait();
const string createNerdMovies = "CREATE TABLE videos.NerdMovies (movie text, " +
"director text, " +
"main_actor text, " +
"year int, " +
"PRIMARY KEY (movie, director))";
cluster.ExecuteNonQuery(createNerdMovies).Wait();
}
protected override void InternalRun(ICluster cluster)
{
const string insertNerdMovie = "INSERT INTO videos.NerdMovies (movie, director, main_actor, year)" +
"VALUES ('Serenity', 'Joss Whedon', 'Nathan Fillion', 2005) " +
"USING TTL 86400";
Console.WriteLine(insertNerdMovie);
cluster.ExecuteNonQuery(insertNerdMovie).Wait();
Console.WriteLine();
const string selectNerdMovies = "select * from videos.NerdMovies";
Console.WriteLine(selectNerdMovies);
var taskSelectStartMovies = cluster.Execute<NerdMovie>(selectNerdMovies).ContinueWith(res => DisplayMovies(res.Result));
taskSelectStartMovies.Wait();
Console.WriteLine();
const string selectAllFrom = "select * from videos.NerdMovies where director=? ALLOW FILTERING";
Console.WriteLine(selectAllFrom);
var preparedAllFrom = cluster.Prepare(selectAllFrom);
var ds = new {Director = "Joss Whedon"};
var taskSelectWhere =
preparedAllFrom.Execute<NerdMovie>(ds).ContinueWith(res => DisplayMovies(res.Result));
taskSelectWhere.Wait();
Console.WriteLine();
}
protected override void DropKeyspace(ICluster cluster)
{
const string dropExcelsor = "drop keyspace videos";
cluster.ExecuteNonQuery(dropExcelsor).Wait();
}
protected override void DropKeyspace(ICluster cluster)
{
cluster.ExecuteNonQuery("drop keyspace Foo").Wait();
}
