Hello,
I currently do this:
# create empty array to which result of dataset will be pushed
results = []
# get the Sequel dataset
DB[:entrees]
.join(:categories, id: :categorie_id)
.select{[ entrees[:id], entrees[:date_de_valeur], entrees[:intitule],
entrees[:montant], entrees[:recurrent], categories[:intitule].as(:categorie)
]}
.where(Sequel.lit('entrees.account_id = ?', accountid))
.where(Sequel.lit('extract(MONTH FROM date_de_valeur) = ?', month))
.where(Sequel.lit('extract(YEAR FROM date_de_valeur) = ?', year))
.order(:date_de_valeur)
.each{ |ligne| results.push(ligne) }
It works, although this is probably not the most concise way to doing this.
Thanks !
--
You received this message because you are subscribed to the Google Groups
"sequel-talk" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to sequel-talk+unsubscr...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/sequel-talk/beb66458-6abb-447c-9179-a4288187fbb1n%40googlegroups.com.
