#!/usr/bin/env ruby

#
#  Copyright 2017 Amazon.com
#
#  Licensed under the Apache License, Version 2.0 (the "License");
#  you may not use this file except in compliance with the License.
#  You may obtain a copy of the License at
#
#    http://www.apache.org/licenses/LICENSE-2.0
#
#  Unless required by applicable law or agreed to in writing, software
#  distributed under the License is distributed on an "AS IS" BASIS,
#  WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
#  See the License for the specific language governing permissions and
#  limitations under the License.



require 'rubygems'  # not necessary for Ruby 1.9
require 'mongo'

# Connect to db. Located here to make it easy to change port etc...
db = Mongo::Client.new([ '127.0.0.1:27017' ], :database => 'dms_sample')

sporting_events = db[:sporting_event]
sporting_events.find.sort({sport: 1,home_team_name: 1, event_date: 1, away_team_name: 1}).each do |ev|
  puts  ev[:sport] + " " + ev[:home_team_name] + " " + ev[:away_team_name] + " " + ev[:event_date].to_s
end