@Override @Transactional public void filter() { List<StubhubEvent> stubhubEventsList = stubhubDAO.getStubhubEvents(); // SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd"); // Get weekends including Friday of the current year // List<Date>weekendList = Utils.findWeekendsWithFriday(); if (stubhubEventsList != null) { List<Events> eventsList = new ArrayList<Events>(); int batch_size = 0; int pageId = 0; int count = 0, count1 = 0; try { logger.debug("stubhubEventsList:: " + stubhubEventsList.size()); for (StubhubEvent stubhubEvent : stubhubEventsList) { count++; logger.debug("Count:: " + count); // Get weekend date for Event date Date eventDate = Utils.getEventWeekendDates(stubhubEvent.getEvent_date_local()); if (eventDate != null) { count1++; logger.debug("Count1:: " + count1); batch_size++; Events events = new Events(); // events.setChannel(stubhubEvent.getChannel()); events.setCity(stubhubEvent.getCity()); events.setCurrency_code(stubhubEvent.getCurrency_code()); events.setDescription(stubhubEvent.getDescription()); events.setEvent_config_template(stubhubEvent.getEvent_config_template()); events.setEvent_config_template_id(stubhubEvent.getEvent_config_template_id()); events.setEvent_date(stubhubEvent.getEvent_date()); events.setEvent_date_local(stubhubEvent.getEvent_date_local()); events.setEvent_time_local(stubhubEvent.getEvent_time_local()); events.setEvent_date_time_local(stubhubEvent.getEvent_date_time_local()); events.setGenreUrlPath(stubhubBaseUrl + stubhubEvent.getGenreUrlPath()); events.setGeography_parent(stubhubEvent.getGeography_parent()); events.setKeywords_en_US(stubhubEvent.getKeywords_en_US()); events.setLatitude(stubhubEvent.getLatitude()); events.setLongitude(stubhubEvent.getLongitude()); events.setZip(stubhubEvent.getZip()); events.setLeaf(stubhubEvent.getLeaf()); events.setMaxPrice(stubhubEvent.getMaxPrice()); events.setMinPrice(stubhubEvent.getMinPrice()); events.setMaxSeatsTogether(stubhubEvent.getMaxSeatsTogether()); events.setMinSeatsTogether(stubhubEvent.getMinSeatsTogether()); // Get State Description for state code Countrylocation countrylocation = countryLocationDAO.getStateNameByStateCode(stubhubEvent.getState()); if (countrylocation != null) events.setState(countrylocation.getState()); else events.setState(stubhubEvent.getState()); events.setStateCode(stubhubEvent.getState()); events.setTimezone(stubhubEvent.getTimezone()); if (stubhubEvent.getTimezone_id() != null) events.setTimezone_id(Long.parseLong(stubhubEvent.getTimezone_id())); if (events.getTitle() != null && events.getTitle().equals("")) events.setTitle(stubhubEvent.getTitle()); else events.setTitle(stubhubEvent.getDescription()); events.setTotalTickets(stubhubEvent.getTotalTickets()); events.setUrlpath(stubhubBaseUrl + stubhubEvent.getUrlpath()); events.setVenue_config_name(stubhubEvent.getVenue_config_name()); events.setVenue_name(stubhubEvent.getVenue_name()); events.setAncestorGenreDescriptions(stubhubEvent.getAncestorGenreDescriptions()); // events.setPage(community); // events.setImage_url(stubhubEvent.getImage_url()); events.setEventSource("Stubhub"); events.setGenre_parent_name(stubhubEvent.getGenre_parent_name()); events.setChannel(stubhubEvent.getChannel()); Page isPageExist = eventsDAO.getPageByAbout(stubhubEvent.getGenre_parent_name()); logger.debug("Is page Exist " + isPageExist); if (isPageExist == null) { Page page = new Page(); page.setAbout(stubhubEvent.getGenre_parent_name()); page.setTag(stubhubEvent.getAncestorGenreDescriptions()); page.setCreatedtime(new Date()); page.setIsCommunity(true); page.setIsEvent(true); page.setIsOrganization(true); Pagetype pagetype = null; if (stubhubEvent.getChannel().toLowerCase().contains("sports")) { // pagetype = eventsDAO.getPageTypeByName("SPORT"); pagetype = new Pagetype(); pagetype.setPageTypeId(8); } else if (stubhubEvent.getChannel().toLowerCase().contains("theater")) { // pagetype = eventsDAO.getPageTypeByName("THEATER"); pagetype = new Pagetype(); pagetype.setPageTypeId(13); } else if (stubhubEvent.getChannel().toLowerCase().contains("concert")) { // pagetype = eventsDAO.getPageTypeByName("CONCERT"); pagetype = new Pagetype(); pagetype.setPageTypeId(14); } else { // pagetype = eventsDAO.getPageTypeByName("NIGHTLIFE"); pagetype = new Pagetype(); pagetype.setPageTypeId(15); } // User user = userDAO.getUserById(1); User user = new User(); user.setUserId(1); page.setUserByCreatorId(user); page.setUserByOwnerId(user); page.setPagetype(pagetype); page.setSource("Stubhub"); page.setPageUrl(stubhubBaseUrl + stubhubEvent.getGenreUrlPath()); page.setProfilePicture( stubhubImageUrl + stubhubEvent.getGeography_parent() + "/" + stubhubEvent.getImage_url()); // eventsDAO.savePage(page,batch_size); // pageId = eventsDAO.getPageByAbout(stubhubEvent.getGenre_parent_name()); // logger.debug("After save page:: "+pageId); // page.setPageId(pageId); events.setPage(page); } else { events.setPage(isPageExist); } // eventsList.add(events); eventsDAO.saveEvents(events, batch_size); } /*if(count1 > 100) break;*/ } // eventsDAO.saveEvents(eventsList, batch_size); } catch (Exception e) { logger.debug("Error in filter::: " + e.getMessage()); e.printStackTrace(); } } }