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