/// <summary>
/// Creates a new BoundStatement object and bind its variables to the provided
/// values.
/// <para>
/// Specify the parameter values by the position of the markers in the query or by name,
/// using a single instance of an anonymous type, with property names as parameter names.
/// </para>
/// <para>
/// Note that while no more <c>values</c> than bound variables can be provided, it is allowed to
/// provide less <c>values</c> that there is variables.
/// </para>
/// </summary>
/// <param name="values"> the values to bind to the variables of the newly
/// created BoundStatement. </param>
/// <returns>the newly created <c>BoundStatement</c> with its variables
/// bound to <c>values</c>. </returns>
public virtual BoundStatement Bind(params object[] values)
{
var bs = new BoundStatement(this, _serializer);
bs.SetRoutingKey(_routingKey);
if (values == null)
{
return bs;
}
var valuesByPosition = values;
var useNamedParameters = values.Length == 1 && Utils.IsAnonymousType(values[0]);
if (useNamedParameters)
{
//Using named parameters
//Reorder the params according the position in the query
valuesByPosition = Utils.GetValues(Metadata.Columns.Select(c => c.Name), values[0]).ToArray();
}
bs.SetValues(valuesByPosition);
bs.CalculateRoutingKey(useNamedParameters, RoutingIndexes, _routingNames, valuesByPosition, values);
return bs;
}
/// <summary>
/// Creates a new BoundStatement object and bind its variables to the provided
/// values.
/// <para>
/// Specify the parameter values by the position of the markers in the query or by name,
/// using a single instance of an anonymous type, with property names as parameter names.
/// </para>
/// <para>
/// Note that while no more <c>values</c> than bound variables can be provided, it is allowed to
/// provide less <c>values</c> that there is variables.
/// </para>
/// </summary>
/// <param name="values"> the values to bind to the variables of the newly
/// created BoundStatement. </param>
/// <returns>the newly created <c>BoundStatement</c> with its variables
/// bound to <c>values</c>. </returns>
public BoundStatement Bind(params object[] values)
{
var bs = new BoundStatement(this);
if (values != null && values.Length == 1 && Utils.IsAnonymousType(values[0]))
{
//Using named params
//Reorder the params according the position in the query
values = Utils.GetValues(Metadata.Columns.Select(c => c.Name), values[0]).ToArray();
}
bs.SetValues(values);
return bs;
}
public static void SetUpKeySpaces(Cluster c)
{
try
{
Console.WriteLine("====================="); Console.WriteLine("=====================");
Console.WriteLine("STARTING TO SETUP KEY SPACES");
Console.WriteLine("====================="); Console.WriteLine("=====================");
String createkeyspace = "create keyspace if not exists maltmusic WITH replication = {'class':'SimpleStrategy', 'replication_factor':1}";
String createUserProfile = "CREATE TABLE if not exists maltmusic.userprofiles (\n"
+ "User_ID text PRIMARY KEY,\n"
+ "password text,\n"
+ "bio text,\n"
+ "first_name text,\n"
+ "last_name text,\n"
+ "email text,\n"
+ "profpic UUID);";
String createTracks = "create table if not exists maltmusic.tracks (\n"
+ "Track_ID UUID, \n"
+ "track_Name text,\n"
+ "artist text,\n"
+ "album text,\n"
+ "year int, \n"
+ "length int, \n"
+ "genre text,\n"
+ "file_loc text,\n"
+ "PRIMARY KEY (Track_ID, artist, album, year, genre))";
String createPlaylist = " create table if not exists maltmusic.playlist(\n"
+ "Playlist_ID UUID,\n"
+ "Track_ID UUID,\n"
+ "Track_Pos int,\n"
+ "PRIMARY KEY (Playlist_ID, Track_ID))";
String createVotes = "create table if not exists maltmusic.votecount(\n"
+ " track_ID UUID Primary Key, \n"
+ " playcount counter,\n"
+ "upvotes counter,\n"
+ "downvotes counter)";
String createListPlaylist = "create table if not exists maltmusic.list_playlist(\n"
+ "playlist_id UUID,\n"
+ "owner text,\n"
+ "playlist_name text,"
+ "PRIMARY KEY (playlist_ID, owner,playlist_name)\n"
+ ")";
String createUserVotes = "create table if not exists maltmusic.user_votes(\n"
+ " track_ID UUID,\n"
+ " voter text, \n"
+ " howvoted text,\n"
+ " Primary Key (track_id, voter)\n"
+ " ); ";
String trackTags = "create table if not exists maltmusic.weathertags(\n"
+ " track_ID UUID Primary Key,\n"
+ " tags set<text> \n"
+ " ); ";
String CreateImage = "CREATE TABLE if not exists maltmusic.images (" +
" user_id text," +
" timeadded timestamp," +
" image blob," +
" imagelength int," +
" PRIMARY KEY (user_id,timeadded)" +
") WITH CLUSTERING ORDER BY (timeadded DESC);";
//Cluster cluster = Cluster.Builder().AddContactPoint("127.0.0.1").Build();
ISession session = c.Connect();
try {
PreparedStatement statement = session.Prepare(createkeyspace);
BoundStatement bs = new BoundStatement(statement);
RowSet rs = session.Execute(bs);
Console.WriteLine("Created Malt ");
} catch (Exception et) {
Console.WriteLine("Creation of keyspace broke - " + et);
}
try
{
PreparedStatement statement = session.Prepare(CreateImage);
BoundStatement bs = new BoundStatement(statement);
RowSet rs = session.Execute(bs);
Console.WriteLine("Created Image Table ");
}
catch (Exception et)
{
Console.WriteLine("Creation of image table broke - " + et);
}
try
{
PreparedStatement statement = session.Prepare(createUserProfile);
BoundStatement bs = new BoundStatement(statement);
RowSet rs = session.Execute(bs);
Console.WriteLine("Created user profiles ");
}
catch (Exception et)
{
Console.WriteLine("Creation profiles broke - " + et);
}
try
{
PreparedStatement statement = session.Prepare(createPlaylist);
BoundStatement bs = new BoundStatement(statement);
RowSet rs = session.Execute(bs);
Console.WriteLine("Created Playlist ");
}
catch (Exception et)
{
Console.WriteLine("Creating Playlist broke - " + et);
}
try
{
PreparedStatement statement = session.Prepare(createTracks);
BoundStatement bs = new BoundStatement(statement);
RowSet rs = session.Execute(bs);
Console.WriteLine("Created Tracks ");
}
catch (Exception et)
{
Console.WriteLine("Creating Tracks broke - " + et);
}
try
{
PreparedStatement statement = session.Prepare(createVotes);
BoundStatement bs = new BoundStatement(statement);
RowSet rs = session.Execute(bs);
Console.WriteLine("Created Votes ");
}
catch (Exception et)
{
Console.WriteLine("Creating votes broke - " + et);
}
try
{
PreparedStatement statement = session.Prepare(createListPlaylist);
BoundStatement bs = new BoundStatement(statement);
RowSet rs = session.Execute(bs);
Console.WriteLine("Created List Playlist ");
}
catch (Exception et)
{
Console.WriteLine("Creating List Playlist broke - " + et);
}
try
{
PreparedStatement statement = session.Prepare(createUserVotes);
BoundStatement bs = new BoundStatement(statement);
RowSet rs = session.Execute(bs);
Console.WriteLine("Created User Votes ");
}
catch (Exception et)
{
Console.WriteLine("Creating User Votes broke - " + et);
}
try
{
PreparedStatement statement = session.Prepare(trackTags);
BoundStatement bs = new BoundStatement(statement);
RowSet rs = session.Execute(bs);
Console.WriteLine("Created Track Tags ");
}
catch (Exception et)
{
Console.WriteLine("Creating Track Tags broke - " + et);
}
//session.End();
//session.Dispose();
}
catch(Exception e)
{
Console.WriteLine("Something keyspacey broke - " + e);
}
}
public override void LoadData()
{
PreparedStatement statement = Session.Prepare(
"INSERT INTO simplex.songs " +
"(id, title, album, artist, tags) " +
"VALUES (?, ?, ?, ?, ?);");
BoundStatement boundStatement = new BoundStatement(statement);
HashSet<String> tags = new HashSet<String>();
tags.Add("jazz");
tags.Add("2013");
Session.Execute(boundStatement.Bind(
new Guid("756716f7-2e54-4715-9f00-91dcbea6cf50"),
"La Petite Tonkinoise'",
"Bye Bye Blackbird'",
"Joséphine Baker",
tags)
);
tags = new HashSet<String>();
tags.Add("1996");
tags.Add("nirds");
Session.Execute(boundStatement.Bind(
new Guid("f6071e72-48ec-4fcb-bf3e-379c8a696488"),
"Die Mösch",
"In Gold'",
"Willi Ostermann",
tags)
);
tags = new HashSet<String>();
tags.Add("1970");
tags.Add("soundtrack");
Session.Execute(boundStatement.Bind(
new Guid("fbdf82ed-0063-4796-9c7c-a3d4f47b4b25"),
"Memo From Turner",
"Performance",
"Mick Jager",
tags)
);
// playlists table
statement = Session.Prepare(
"INSERT INTO simplex.playlists " +
"(id, song_id, title, album, artist) " +
"VALUES (?, ?, ?, ?, ?);");
boundStatement = new BoundStatement(statement);
Session.Execute(boundStatement.Bind(
new Guid("2cc9ccb7-6221-4ccb-8387-f22b6a1b354d"),
new Guid("756716f7-2e54-4715-9f00-91dcbea6cf50"),
"La Petite Tonkinoise",
"Bye Bye Blackbird",
"Joséphine Baker"));
Session.Execute(boundStatement.Bind(
new Guid("2cc9ccb7-6221-4ccb-8387-f22b6a1b354d"),
new Guid("f6071e72-48ec-4fcb-bf3e-379c8a696488"),
"Die Mösch",
"In Gold",
"Willi Ostermann"));
Session.Execute(boundStatement.Bind(
new Guid("3fd2bedf-a8c8-455a-a462-0cd3a4353c54"),
new Guid("fbdf82ed-0063-4796-9c7c-a3d4f47b4b25"),
"Memo From Turner",
"Performance",
"Mick Jager"));
}
