func (this *Tweet) Insert() error {
session, err := dao.GetSession()
if err != nil {
return err
}
b := cqlr.Bind(`INSERT INTO tweet (timeline, id, text) VALUES (?, ?, ?)`, this)
return b.Exec(session)
}
//create table example.user(id UUID, login text, passwd text, PRIMARY KEY(id));
//create index on example.user(login);
//insert into example.user(id, login, passwd) values (now(), 'admin', 'f807c2b4caa8ca621298907e5372c975a6e07322');
func main() {
log15.Root().SetHandler(log15.CallerStackHandler("%+v", log15.StdoutHandler))
session, err := dao.GetSession()
if err != nil {
log15.Error(err.Error())
os.Exit(1)
}
defer session.Close()
www.StartWebServer()
os.Exit(0)
}
func GetAllTweetsForTimeLine(timeLine string) ([]Tweet, error) {
session, err := dao.GetSession()
if err != nil {
return nil, err
}
q := session.Query(`SELECT text, id, timeline FROM tweet WHERE timeline = ?`, timeLine)
bind := cqlr.BindQuery(q)
defer bind.Close()
var tweets []Tweet
t := Tweet{}
for bind.Scan(&t) {
tweets = append(tweets, t)
}
return tweets, nil
}