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