public void AddComment(ISession session)
{
TimeUuid comment_id = TimeUuid.NewId(DateTimeOffset.Now);
Guid userId = Guid.NewGuid();
Console.Write("Enter post_id : ");
string strPostId = Console.ReadLine();
Guid postId = new Guid(strPostId);
Console.Write("Enter post : ");
string comment = Console.ReadLine();
var addComment = session.Prepare(
"INSERT INTO comments (post_id, comment_id , comment, user_id) VALUES(?,?,?, ?)");
session.Execute(addComment.Bind(postId, comment_id, comment, userId));
var updatedPost = session.Prepare(
"Update posts set updated_at=? where post_id = ?");
session.Execute(updatedPost.Bind(comment_id, postId));
TimeUuid updatedAtPrev = new TimeUuid();
var getLastUpdate = session.Prepare("Select updated_at from posts where post_id = ? ");
var ex = session.Execute(getLastUpdate.Bind(postId));
foreach (var lastUpdateAt in ex)
{
updatedAtPrev = lastUpdateAt.GetValue <TimeUuid>("updated_at");
}
_userStream.SyncUserStream(session, postId, updatedAtPrev);
}
public void CreatePost(ISession session)
{
Guid postId = Guid.NewGuid();
Guid authorId = Guid.NewGuid();
TimeUuid updatedAt = TimeUuid.NewId(DateTimeOffset.Now);
Console.Write("Enter post : ");
string content = Console.ReadLine();
var insertPost = session.Prepare(
"INSERT INTO posts (post_id, author_id,content, updated_at) VALUES(?,?,?, ?)");
session.Execute(insertPost.Bind(postId, authorId, content, updatedAt));
var insertPostFollowers = session.Prepare(
"INSERT INTO post_followers (post_id, followers) VALUES(?,?)");
_userStream.SyncUserStream(session, postId, updatedAt);
}