/*
* Copyright 2012 the original author or authors.
*
* 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.
*/
package com.springsource.greenhouse.events;
import static org.junit.Assert.*;
import java.util.List;
import org.joda.time.LocalDate;
import org.junit.After;
import org.junit.Before;
import org.junit.Test;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.jdbc.datasource.embedded.EmbeddedDatabase;
import com.springsource.greenhouse.database.GreenhouseTestDatabaseBuilder;
import com.springsource.greenhouse.utils.Location;
public class JdbcEventRepositoryTest {
private EmbeddedDatabase db;
private JdbcTemplate jdbcTemplate;
private EventRepository eventRepository;
@Before
public void setup() {
db = new GreenhouseTestDatabaseBuilder().member().group().activity().invite().venue().event().testData(getClass()).getDatabase();
jdbcTemplate = new JdbcTemplate(db);
eventRepository = new JdbcEventRepository(jdbcTemplate);
}
@After
public void destroy() {
if (db != null) {
db.shutdown();
}
}
@Test
public void findEventBySlug() {
Event event = eventRepository.findEventBySlug("s2gx", 2010, 10, "chicago");
assertNotNull(event);
assertEquals("SpringOne2gx", event.getTitle());
assertEquals("SpringOne 2GX is a one-of-a-kind conference for application developers, solution architects, web operations and IT teams who develop, deploy and manage business applications.", event.getDescription());
// assertEquals(new DateTime(2010, 10, 19, 15, 0, 0, 0, event.getTimeZone()), event.getStartTime().withZone(event.getTimeZone()));
// assertEquals(new DateTime(2010, 10, 22, 15, 0, 0, 0, event.getTimeZone()), event.getEndTime().withZone(event.getTimeZone()));
assertEquals("s2gx", event.getGroup().getId());
assertEquals("SpringOne2gx", event.getGroup().getLabel());
assertEquals("Westin Lombard Yorktown Center", event.getVenues().iterator().next().getName());
assertEquals("70 Yorktown Center Lombard, IL 60148", event.getVenues().iterator().next().getPostalAddress());
assertEquals(new Location(41.8751108905486, -88.0184300761646), event.getVenues().iterator().next().getLocation());
assertEquals("adjacent to Shopping Center", event.getVenues().iterator().next().getLocationHint());
}
@Test
public void findEventSearchString() {
assertEquals("#s2gx", eventRepository.findEventSearchString(1L));
}
@Test
public void findEventSessionSearchString() {
assertEquals("#s2gx #mvc", eventRepository.findSessionSearchString(1L, 1));
}
@Test
public void findSessionsOnDay() {
List<EventSession> sessions = eventRepository.findSessionsOnDay(1L, new LocalDate(2010, 10, 21), 1L);
assertEquals(2, sessions.size());
assertSocial(sessions.get(0), true);
assertMobile(sessions.get(1), true);
}
@Test
public void findSessionsOnDayEdge() {
List<EventSession> sessions = eventRepository.findSessionsOnDay(1L, new LocalDate(2010, 10, 19), 1L);
assertEquals(1, sessions.size());
}
@Test
public void findEventFavorites() {
List<EventSession> favorites = eventRepository.findEventFavorites(1L, 2L);
assertEquals(2, favorites.size());
assertSocial(favorites.get(0), false);
assertMobile(favorites.get(1), false);
}
@Test
public void findAttendeeFavorites() {
List<EventSession> favorites = eventRepository.findAttendeeFavorites(1L, 1L);
assertEquals(2, favorites.size());
assertSocial(favorites.get(0), true);
assertMobile(favorites.get(1), true);
}
@Test
public void toggleFavorite() {
assertFalse(eventRepository.toggleFavorite(1L, 3, 1L));
assertTrue(eventRepository.toggleFavorite(1L, 3, 1L));
}
@Test
public void rate() throws RatingPeriodClosedException {
eventRepository.rate(2L, 6, 1L, new Rating((short)5, "Rocked"));
eventRepository.rate(2L, 6, 2L, new Rating((short)4, "Rocked"));
Float rating = eventRepository.rate(2L, 6, 3L, new Rating((short)2, "Rocked"));
assertEquals(new Float(3.5), rating);
}
// internal helpers
private void assertMobile(EventSession session, boolean favorite) {
assertEquals("Choices in Mobile Application Development", session.getTitle());
// assertEquals(new DateTime(2010, 10, 21, 16, 45, 0, 0, DateTimeZone.UTC), session.getStartTime());
// assertEquals(new DateTime(2010, 10, 21, 18, 15, 0, 0, DateTimeZone.UTC), session.getEndTime());
assertEquals(2, session.getLeaders().size());
assertEquals("Roy Clarkson", session.getLeaders().get(0).getName());
assertEquals("Keith Donald", session.getLeaders().get(1).getName());
assertEquals(new Float(0), session.getRating());
assertEquals(favorite, session.isFavorite());
assertEquals("Junior Ballroom B", session.getRoom().getLabel());
}
private void assertSocial(EventSession session, boolean favorite) {
assertEquals("Developing Social-Ready Web Applications", session.getTitle());
// assertEquals(new DateTime(2010, 10, 21, 14, 45, 0, 0, DateTimeZone.UTC), session.getStartTime());
// assertEquals(new DateTime(2010, 10, 21, 16, 15, 0, 0, DateTimeZone.UTC), session.getEndTime());
assertEquals(1, session.getLeaders().size());
assertEquals("Craig Walls", session.getLeaders().get(0).getName());
assertEquals(favorite, session.isFavorite());
assertEquals(new Float(0), session.getRating());
assertEquals(favorite, session.isFavorite());
assertEquals("Junior Ballroom B", session.getRoom().getLabel());
}
}