sequel で where

gistfile1.rb

DB = Sequel.sqlite('photo/photo.db')
photo = DB[:photo].all
for year in 2000..Date.today.year do
	puts " -- " + year.to_s + " -- "
	start = year.to_s + '-01-01'
	end = (year + 1).to_s + '-01-01'
	photo = DB[:photo].where('date_time >= ? and date_time < ?', start, end).all
	puts photo
end