public User Get(Guid id) { using (var db = new CassandraContextFactory().Get()) { var users = db.ExecuteQuery("select * from users where key='" + id + "'"); dynamic user = users.First(); return new User { Username = user.Username, Id = user.Key }; } }
public IEnumerable<User> GetAll() { using (var db = new CassandraContextFactory().Get()) { var users = db.ExecuteQuery("select * from users"); foreach (dynamic user in users) { yield return new User { Username = user.username }; } } }
public IEnumerable<Tweet> GetAll(string username = null) { using (var db = new CassandraContextFactory().Get()) { string query = string.Empty; if (username != null) { var user = new UserRepository().Get(username); query = "select * from tweets where userid='" + user.Id + "'"; } else { query = "select * from tweets"; } var tweets = db.ExecuteQuery(query); var repo = new UserRepository(); List<Tweet> tw = new List<Tweet>(); foreach (dynamic tweet in tweets) { int x = 4; var id = tweet.UserId; tw.Add( new Tweet { Date = tweet.date, Text = tweet.text, UserId = tweet.userid, // UserName = repo.Get().Username }); } return tw; } }