Subversion Repositories SmartDukaan

Rev

Rev 10703 | Rev 11151 | Go to most recent revision | Details | Compare with Previous | Last modification | View Log | RSS feed

Rev Author Line No. Line
457 rajveer 1 
package in.shop2020.util;
2 
 
1226 rajveer 3 
import in.shop2020.metamodel.core.Bullet;
8909 amit.gupta 4 
import in.shop2020.metamodel.core.BulletDataObject;
479 rajveer 5 
import in.shop2020.metamodel.core.Entity;
1226 rajveer 6 
import in.shop2020.metamodel.core.EntityState;
7129 amit.gupta 7 
import in.shop2020.metamodel.core.EntityStatus;
3873 mandeep.dh 8 
import in.shop2020.metamodel.core.EnumDataObject;
7590 amit.gupta 9 
import in.shop2020.metamodel.core.ExpertReview;
10692 amit.gupta 10 
import in.shop2020.metamodel.core.ExpertReviewStatus;
1226 rajveer 11 
import in.shop2020.metamodel.core.Feature;
479 rajveer 12 
import in.shop2020.metamodel.core.FreeformContent;
5370 amit.gupta 13 
import in.shop2020.metamodel.core.Media;
14 
import in.shop2020.metamodel.core.Media.Type;
1226 rajveer 15 
import in.shop2020.metamodel.core.PrimitiveDataObject;
479 rajveer 16 
import in.shop2020.metamodel.core.Slide;
580 rajveer 17 
import in.shop2020.metamodel.definitions.BulletDefinition;
457 rajveer 18 
import in.shop2020.metamodel.definitions.Catalog;
580 rajveer 19 
import in.shop2020.metamodel.definitions.Category;
20 
import in.shop2020.metamodel.definitions.CategorySlideDefinition;
457 rajveer 21 
import in.shop2020.metamodel.definitions.DefinitionsContainer;
580 rajveer 22 
import in.shop2020.metamodel.definitions.FeatureDefinition;
23 
import in.shop2020.metamodel.definitions.SlideDefinition;
24 
import in.shop2020.metamodel.definitions.SlideFeatureDefinition;
479 rajveer 25 
import in.shop2020.metamodel.util.CreationUtils;
8749 amit.gupta 26 
import in.shop2020.metamodel.util.CreationUtils1;
2720 mandeep.dh 27 
import in.shop2020.metamodel.util.ExpandedBullet;
1739 rajveer 28 
import in.shop2020.metamodel.util.ExpandedEntity;
5945 mandeep.dh 29 
import in.shop2020.model.v1.catalog.CatalogService.Client;
2287 rajveer 30 
import in.shop2020.model.v1.catalog.Item;
31 
import in.shop2020.model.v1.catalog.status;
3127 rajveer 32 
import in.shop2020.thrift.clients.CatalogClient;
4706 amit.gupta 33 
import in.shop2020.utils.Logger;
457 rajveer 34 
 
2720 mandeep.dh 35 
import java.io.BufferedReader;
5370 amit.gupta 36 
import java.io.ByteArrayInputStream;
37 
import java.io.ByteArrayOutputStream;
2720 mandeep.dh 38 
import java.io.DataInputStream;
39 
import java.io.File;
40 
import java.io.FileInputStream;
8014 amit.gupta 41 
import java.io.FileNotFoundException;
5370 amit.gupta 42 
import java.io.FileOutputStream;
8014 amit.gupta 43 
import java.io.FileReader;
5370 amit.gupta 44 
import java.io.InputStream;
2720 mandeep.dh 45 
import java.io.InputStreamReader;
5370 amit.gupta 46 
import java.io.ObjectInputStream;
47 
import java.io.ObjectOutputStream;
48 
import java.io.OutputStream;
8014 amit.gupta 49 
import java.io.Reader;
5760 amit.gupta 50 
import java.text.MessageFormat;
2720 mandeep.dh 51 
import java.util.ArrayList;
7037 amit.gupta 52 
import java.util.Arrays;
8749 amit.gupta 53 
import java.util.Calendar;
5370 amit.gupta 54 
import java.util.Collection;
3873 mandeep.dh 55 
import java.util.Collections;
7129 amit.gupta 56 
import java.util.Date;
4706 amit.gupta 57 
import java.util.HashMap;
8909 amit.gupta 58 
import java.util.HashSet;
5671 amit.gupta 59 
import java.util.Iterator;
7123 amit.gupta 60 
import java.util.LinkedHashMap;
9171 amit.gupta 61 
import java.util.LinkedHashSet;
2720 mandeep.dh 62 
import java.util.List;
63 
import java.util.Map;
7111 amit.gupta 64 
import java.util.Set;
2720 mandeep.dh 65 
import java.util.TreeMap;
580 rajveer 66 
 
7932 amit.gupta 67 
import org.apache.commons.collections.CollectionUtils;
5370 amit.gupta 68 
import org.apache.commons.io.IOUtils;
4818 amit.gupta 69 
import org.apache.commons.lang.StringUtils;
70 
 
8014 amit.gupta 71 
import com.google.gson.Gson;
72 
import com.google.gson.reflect.TypeToken;
73 
 
457 rajveer 74 
/*
7997 amit.gupta 75 
 * @author rajveer
457 rajveer 76 
 *
77 
 *
78 
 */
79 
 
80 
public class ContentMigrator {
81 
	private String sourceDbPath;
82 
	private String destinationDbPath;
4964 amit.gupta 83 
 
457 rajveer 84 
	public static void main(String[] args) throws Exception {
85 
		String usage = "Usage: ContentMigrator {source db path}{destination db path}";
8749 amit.gupta 86 
 
4964 amit.gupta 87 
		String sourceDbPath = null, destinationDbPath = null;
88 
		String dryRun = null;
89 
		// if(args.length < 2) {
90 
		// System.out.println(usage);
91 
		// System.exit(-1);
92 
		// }else{
93 
		// sourceDbPath = args[0];
94 
		// destinationDbPath = args[1];
95 
		// dryRun = args[2];
96 
		// }
97 
		//
7186 amit.gupta 98 
		ContentMigrator contentmigrator = new ContentMigrator(sourceDbPath,destinationDbPath);
8841 amit.gupta 99 
 
100 
 
7590 amit.gupta 101 
		/*List<Long> entityId = Arrays.asList(1001674l,1002575l,1005331l,1005165l,1005164l,1005111l,1005109l,1004952l,1004940l,1004871l,1004701l,1004429l,1004197l,1006174l,1006077l,1005901l,1005757l,1005754l,1005724l,1005704l,1005598l,1005576l,1005558l,1007394l,1007230l,1007226l,1007218l,1007089l,1006925l,1006822l,1006814l,1006175l);
7507 amit.gupta 102 
		for (Long eId : entityId){
7590 amit.gupta 103 
		}*/
8262 amit.gupta 104 
		//contentmigrator.reorderPhones();
8014 amit.gupta 105 
		//System.out.println(contentmigrator.getItems().size());
8268 amit.gupta 106 
		/*contentmigrator.touchEntityState(1008423l);
8262 amit.gupta 107 
		contentmigrator.touchEntityState(1008424l);
108 
		contentmigrator.touchEntityState(1008427l);
8268 amit.gupta 109 
		contentmigrator.touchEntityState(1008428l);*/
4964 amit.gupta 110 
 
8869 amit.gupta 111 
		//contentmigrator.migrateToMongo();
8865 amit.gupta 112 
		//contentmigrator.getEditedEntities();
113 
		/*contentmigrator.touchEntityState(1008706l);
114 
		contentmigrator.touchEntityState(1008707l);
115 
		contentmigrator.touchEntityState(1008708l);
116 
		contentmigrator.touchEntityState(1008709l);
117 
		contentmigrator.touchEntityState(1008710l);
118 
		contentmigrator.touchEntityState(1008711l);
119 
		contentmigrator.touchEntityState(1008714l);
120 
		contentmigrator.touchEntityState(1008715l);
121 
		contentmigrator.touchEntityState(1005505l);
122 
		contentmigrator.touchEntityState(1006864l);*/
8913 amit.gupta 123 
		//contentmigrator.clearEmptyPrimitiveBullets();
9171 amit.gupta 124 
		//contentmigrator.migrateSoftCategories();
9051 amit.gupta 125 
		//contentmigrator.updateSummaryMediaLabel();
10692 amit.gupta 126 
		//contentmigrator.migrateReviews();
127 
		contentmigrator.test();
128 
 
4964 amit.gupta 129 
	}
7398 amit.gupta 130 
 
10692 amit.gupta 131 
	private void test() throws Exception{
10699 amit.gupta 132 
		/*PojoCreator pc = new PojoCreator();
133 
		List<ExpertReview> expertReviews = getExpertReviews(1007379);*/
134 
		Map<Long, Entity> ee = CreationUtils.getEntities();
135 
		Map<Long, EntityState> bb = CreationUtils.getEntitiesState();
136 
		for(Map.Entry<Long, EntityState> ent : bb.entrySet()){
137 
			EntityState es = ent.getValue();
138 
			if(es.getStatus().equals(EntityStatus.READY)) {
139 
				Entity e = ee.get(ent.getKey());
140 
				Slide summarySlide = e.getSlide(130054l);
141 
				if(summarySlide==null){
142 
					System.out.println("Does not have summary slide for entity: " + ent.getKey());
143 
					continue;
144 
				}
145 
				FreeformContent ffc = summarySlide.getFreeformContent();
146 
				if(ffc == null){
147 
					ffc = new FreeformContent();
148 
					summarySlide.setFreeformContent(ffc);
149 
				}
150 
				Map<String, Media> mediamap = ffc.getMedias();
10703 amit.gupta 151 
				if(mediamap==null || mediamap.size()==0 || mediamap.get("default")==null){
10699 amit.gupta 152 
					String mediaDirPath = Utils.CONTENT_DB_PATH + "media" + File.separator + ent.getKey();
153 
					String mediaFileName = mediaDirPath + File.separator + "default.jpg";
154 
					File f = new File(mediaFileName);
155 
					if(f.exists()) {
156 
						Media media = new Media("default", Media.Type.IMAGE, mediaFileName);
157 
						media.setTitle("default");
158 
		    			media.setFileName("default.jpg");
159 
						ffc.addMedia(media);
160 
						System.out.println("Added default media successfully for entity: " + ent.getKey());
10707 amit.gupta 161 
						CreationUtils.updateEntity(e);
10699 amit.gupta 162 
					} else {
163 
						System.out.println("Could not get default.jpg for entity: " + ent.getKey());
164 
					}
165 
				}
166 
			}
167 
		}
10692 amit.gupta 168 
	}
169 
 
8841 amit.gupta 170 
	private void changeKeys() throws Exception {
171 
		Map<Long, Entity>  e = CreationUtils.getEntities();
172 
		for (Map.Entry<Long, Entity> entry : e.entrySet()) {
173 
			CreationUtils.updateEntity(entry.getValue());
174 
			System.out.println("updated " + entry.getValue().getID());
175 
		}
176 
		//CreationUtils.updateEntity(e);
177 
		//CreationUtils.
178 
	}
179 
 
180 
	public void getEditedEntities() throws Exception {
181 
		Collection<EntityState> es = CreationUtils1.getEntitiesState().values();
182 
		for (EntityState es1 : es) {
8843 amit.gupta 183 
			if(es1.getStatus().equals(EntityStatus.READY)){
184 
				long mongotime = CreationUtils.getEntityState(es1.getID()).getMerkedReadyOn().getTime()/1000;
185 
				long bdbtime = es1.getMerkedReadyOn().getTime()/1000;
186 
				if(bdbtime!=mongotime){
187 
					System.out.println(es1.getID());
188 
				}
8841 amit.gupta 189 
			}
190 
		}
191 
	}
192 
 
8749 amit.gupta 193 
	private void migrateToMongo() throws Exception{
8841 amit.gupta 194 
		long counter = 0;
195 
		Collection<EntityState> es = CreationUtils1.getEntitiesState().values();
196 
		boolean updated = false;
8865 amit.gupta 197 
		StringBuffer buffer = new StringBuffer();
8841 amit.gupta 198 
		for (EntityState es1 : es) {
199 
			if(es1.getStatus().equals(EntityStatus.READY)){
8865 amit.gupta 200 
				long mongotime = CreationUtils.getEntityState(es1.getID()).getMerkedReadyOn().getTime()/1000;
201 
				long bdbtime = es1.getMerkedReadyOn().getTime()/1000;
202 
				if(bdbtime==mongotime){
203 
					updated = false;
204 
					Entity e = CreationUtils1.getEntity(es1.getID());
205 
					List<Slide> slides = e.getSlides();
206 
					for(Slide slide:slides) {
207 
						FreeformContent ffc = slide.getFreeformContent();
208 
						if (ffc !=null){
209 
							Map<String,Media> m1 = ffc.getMedias();
210 
							if (m1!=null){
211 
								Map<String,Media> m = new LinkedHashMap<String, Media>(m1);
212 
								for (Map.Entry<String, Media> m2 : m.entrySet()){
213 
									m1.put(Long.toString(++counter), m1.remove(m2.getKey()));
214 
									updated = true;
215 
								}
8841 amit.gupta 216 
							}
217 
						}
218 
					}
8865 amit.gupta 219 
					if(updated){
220 
						CreationUtils.updateEntity(e);
221 
						System.out.println(e.getID());
222 
					}
223 
				} else {
224 
					buffer.append(es1.getID() + "\n");
8841 amit.gupta 225 
				}
8749 amit.gupta 226 
			}
227 
		}
8865 amit.gupta 228 
		System.out.println("Entities counldnt be updated are :\n" + buffer.toString());
8749 amit.gupta 229 
	}
230 
 
231 
	private void migrateContentStore() throws Exception {
232 
		for (Map.Entry<Long, Entity> entry :CreationUtils.getEntities().entrySet()){
233 
			Entity e = entry.getValue();
234 
			Iterator<Slide> it = e.getSlides().iterator();
235 
			while(it.hasNext()){
236 
				Slide sl = it.next();
237 
				//sl.getFreeformContent().me
238 
			}
239 
		}
240 
 
241 
	}
242 
 
7590 amit.gupta 243 
	private void updateSources() throws Exception{
244 
		Map<Long,List<ExpertReview>> erMap = CreationUtils.getExpertReviews();
245 
		for(Map.Entry<Long, List<ExpertReview>> erEntry : erMap.entrySet()){
246 
			List<ExpertReview> erList = erEntry.getValue();
247 
			Iterator<ExpertReview> iter = erList.iterator();
248 
			while (iter.hasNext()){
249 
				ExpertReview er = iter.next();
250 
				if (er.getSource().equals("iGyan")){
251 
					er.setSource("iGyaan");
252 
					System.out.println("changed to iGyaan in entity : " + erEntry.getKey());
253 
				}else if(er.getSource().equals("TheMobileIndian")){
254 
					er.setSource("The Mobile Indian");
255 
					System.out.println("changed to The Mobile Indian in entity : " + erEntry.getKey());
256 
				}
257 
			}
258 
			CreationUtils.storeExpertReview(erEntry.getKey(), erList);
259 
		}
260 
	}
7507 amit.gupta 261 
	private void touchEntityState(Long eId) throws Exception {
262 
		EntityState es = CreationUtils.getEntityState(eId);
263 
		es.setMerkedReadyOn(new Date());
264 
		CreationUtils.updateEntityState(es);
9051 amit.gupta 265 
		System.out.println("Entity touched:" + eId);
7507 amit.gupta 266 
	}
8798 amit.gupta 267 
 
268 
	private void touchEntityStates() throws Exception {
269 
		Map<Long, EntityState> ess = CreationUtils.getEntitiesState();
270 
		Calendar calReady = Calendar.getInstance();
271 
		Calendar cal5daysBack = Calendar.getInstance();
272 
		Date today = new Date();
273 
		cal5daysBack.add(Calendar.DATE, -5);
274 
		for (Map.Entry<Long, EntityState> es : ess.entrySet()) {
275 
			EntityState est = es.getValue();
276 
			if(est.getMerkedReadyOn()!=null){
277 
				calReady.setTime(est.getMerkedReadyOn());
278 
				if(calReady.compareTo(cal5daysBack) > 0){
279 
					est.setMerkedReadyOn(today);
280 
					CreationUtils.updateEntityState(est);
281 
					System.out.println("Entity touched:" + est.getID());
282 
				}
283 
			}
284 
		}
285 
	}
7398 amit.gupta 286 
	private void updateModelForBBQ10() throws Exception{
287 
		Long entityId = 1007315l;
288 
		EntityState e1 = CreationUtils.getEntityState(entityId);
289 
		Entity e2 = CreationUtils.getEntity(entityId);
7403 amit.gupta 290 
		e1.setModelName("Blackkberry Q10");
291 
		e2.setModelName("Blackberry Q10");
7398 amit.gupta 292 
		CreationUtils.updateEntity(e2);
293 
		CreationUtils.updateEntityState(e1);
294 
	}
4964 amit.gupta 295 
 
5671 amit.gupta 296 
	private void migrateWarrantyForCategory(Long catgoryId) throws Exception {
297 
		Collection<Entity> entities = CreationUtils.getEntities(catgoryId);
298 
		int count = 0;
299 
		for (Entity entity : entities) {
300 
			Slide slide = entity.getSlide(130054l);
301 
			if(slide!=null){
302 
				List<Slide> childrenSlide = slide.getChildrenSlides();
5672 amit.gupta 303 
				if(childrenSlide != null){
304 
					Iterator<Slide> it = childrenSlide.iterator();
305 
					while (it.hasNext()){
306 
						Slide sl = it.next();
307 
						if (130105l == sl.getSlideDefinitionID()){
308 
							it.remove();
309 
							System.out.println("Removed warranty slide from entity:" + entity.getID());
310 
							break;
311 
						}
5671 amit.gupta 312 
					}
5672 amit.gupta 313 
					CreationUtils.updateEntity(entity);
5671 amit.gupta 314 
				}
315 
			}
316 
		}
317 
	}
318 
 
319 
	private void checkYouTube() throws Exception {
320 
		// TODO Auto-generated method stub
321 
		Collection<Entity> entities = CreationUtils.getEntities().values();
322 
		//entities = (List<Entity>)this.clone(entities);
323 
		for (Entity entity : entities) {
324 
			long entityId = entity.getID();
325 
			try {
326 
				List<Slide> entitySlides = entity.getSlides();
327 
				if (entity == null || entitySlides == null) {
328 
					continue;
329 
				}
330 
				Slide summarySlide = null;
331 
				FreeformContent ffc = null;
332 
 
333 
				List<Slide> newEntitySlides = new ArrayList<Slide>();
334 
				Slide connectivitySlide = new Slide(130129);
335 
				Slide looknfeelSlide = new Slide(130128);
336 
				for (Slide slide : entitySlides) {
337 
						ffc = slide.getFreeformContent();
338 
						if(ffc != null){
339 
							Map<String, Media> mediaMap = ffc.getMedias();
340 
							if(mediaMap!=null){
341 
								for(Media media : mediaMap.values()){
342 
									if(media.getType().equals(Type.VIDEO_WITHOUT_SKIN) || media.getType().equals(Type.VIDEO_WITH_SKIN)){
343 
										if(media.getYoutubeId().contains("&"))
344 
										System.out.println(entityId + " : " + media.getLabel() + ":" + media.getYoutubeId());
345 
									}
346 
								}
347 
							}
348 
						}
349 
				}
350 
 
351 
			}catch(Exception e){
352 
				System.out.println("Could not migrate " + entityId);
353 
			}
354 
		}
355 
 
356 
 
357 
	}
358 
 
4964 amit.gupta 359 
	private void renameTitles() throws Exception {
360 
		Map<Long, Entity> map = CreationUtils.getEntities();
361 
		for (Long entityId : map.keySet()) {
362 
			Entity entity = map.get(entityId);
363 
			if (entity == null || entity.getSlides() == null) {
364 
				continue;
1314 rajveer 365 
			}
4964 amit.gupta 366 
			Slide summarySlide = entity.getSlide(130054);
367 
			if(summarySlide != null){
5760 amit.gupta 368 
				boolean isupdated = false;
4964 amit.gupta 369 
				for(Feature f : summarySlide.getFeatures()){
5760 amit.gupta 370 
					if(f.getFeatureDefinitionID()==120132l){
371 
						if(f.getBullets() == null){
372 
							f.setBullets(new ArrayList<Bullet>());
373 
						}else {
374 
							f.getBullets().clear();
4964 amit.gupta 375 
						}
5760 amit.gupta 376 
						Bullet titleBullet = new Bullet(new PrimitiveDataObject(getTitle(entity)));
377 
						f.getBullets().add(titleBullet);
378 
						isupdated = true;
4964 amit.gupta 379 
						continue;
380 
					}
5760 amit.gupta 381 
					if(f.getFeatureDefinitionID()==120133l){
382 
						if(f.getBullets() == null){
383 
							f.setBullets(new ArrayList<Bullet>());
384 
						}else {
385 
							f.getBullets().clear();
386 
						}
387 
						Bullet metaDescBullet = new Bullet(new PrimitiveDataObject(getMetaDescription(new ExpandedEntity(entity))));
388 
						f.getBullets().add(metaDescBullet);
389 
						isupdated = true;
390 
						continue;
391 
					}
4964 amit.gupta 392 
				}
5760 amit.gupta 393 
				if(isupdated){
394 
					CreationUtils.updateEntity(entity);
395 
					System.out.println("Updated entity : " + entity.getID());
396 
				}
4964 amit.gupta 397 
			}
1314 rajveer 398 
		}
457 rajveer 399 
	}
400 
 
4818 amit.gupta 401 
	private void migrateNetwork() throws Exception {
402 
		Map<Long, Entity> map = CreationUtils.getEntities();
4964 amit.gupta 403 
		for (Long entityId : map.keySet()) {
404 
			Entity entity = map.get(entityId);
405 
			if (entity == null || entity.getSlides() == null) {
406 
				continue;
407 
			}
4818 amit.gupta 408 
 
4964 amit.gupta 409 
			for (Slide slide : entity.getSlides()) {
5281 amit.gupta 410 
				if (slide.getSlideDefinitionID() == 130095) {
411 
					List<Slide> slides = slide.getChildrenSlides();
412 
					for(Slide slide1  : slides){
413 
						if(slide1.getSlideDefinitionID() == 130096){
414 
							List<Feature> features = slide1.getFeatures();
415 
							for (Feature f : features) {
416 
								if (f.getFeatureDefinitionID() == 120175) {
417 
									List<Bullet> bs = f.getBullets();
418 
									for (Bullet b : bs) {
419 
										Long enumValueId = ((EnumDataObject) b
420 
												.getDataObject()).getEnumValueID();
421 
										String value = Catalog.getInstance().getDefinitionsContainer().getEnumValue(enumValueId).getValue();
422 
										if (value.trim().equals("")) {
423 
											continue;
424 
										}
425 
										System.out.println(value);
426 
 
427 
									}
4964 amit.gupta 428 
								}
429 
							}
430 
						}
431 
					}
432 
				}
433 
 
434 
			}
435 
 
436 
			CreationUtils.updateEntity(entity);
437 
		}
4818 amit.gupta 438 
	}
5370 amit.gupta 439 
	private void migrateHeadSet() throws Exception {
440 
 
441 
		//Starting entity id for new Category with 10000
442 
		long newCounter = 77777000;
443 
		Collection<Entity> entities = CreationUtils.getEntities(10015);
444 
 
445 
		//entities = (List<Entity>)this.clone(entities);
446 
		for (Entity entity : entities) {
447 
			long entityId = entity.getID();
448 
			try {
449 
				List<Slide> entitySlides = entity.getSlides();
450 
				if (entity == null || entitySlides == null) {
451 
					continue;
452 
				}
453 
				Slide summarySlide = null;
454 
				FreeformContent ffc = null;
455 
 
456 
				List<Slide> newEntitySlides = new ArrayList<Slide>();
457 
				Slide connectivitySlide = new Slide(130129);
458 
				Slide looknfeelSlide = new Slide(130128);
459 
				for (Slide slide : entitySlides) {
460 
					slide=(Slide)this.clone(slide);
461 
					if (slide.getSlideDefinitionID() == 130068) {
462 
						List<Feature> connectivityFeatures = new ArrayList<Feature>();
463 
						List<Feature> looknfeelFeatures = new ArrayList<Feature>();
464 
						List<Feature> features = slide.getFeatures();
465 
						for (Feature f : features) {
466 
							if (f.getFeatureDefinitionID() == 120105) {
467 
								connectivityFeatures.add(f);
468 
							}
469 
							if (f.getFeatureDefinitionID() == 120106) {
470 
								looknfeelFeatures.add(f);
471 
							}
472 
						}
473 
						ffc = slide.getFreeformContent();
474 
						if(ffc != null){
475 
							Map<String, Media> mediaMap = ffc.getMedias();
476 
							if(mediaMap!=null){
477 
								for(Media media : mediaMap.values()){
478 
									if(media.getType().equals(Type.IMAGE) || media.getType().equals(Type.DOCUMENT)){
479 
										copyMedia(String.valueOf(newCounter), String.valueOf(entityId),media);
480 
									}
481 
								}
482 
							}
483 
						}
484 
						connectivitySlide.setFeatures(connectivityFeatures);
485 
						looknfeelSlide.setFeatures(looknfeelFeatures);
486 
						looknfeelSlide.setFreeformContent(ffc);
487 
					}
488 
					//Summary slide
489 
					if(slide.getSlideDefinitionID() == 130054) {
490 
						summarySlide = slide;
491 
						FreeformContent ffc1 = slide.getFreeformContent();
492 
						if(ffc1 != null){
493 
							Map<String, Media> mediaMap = ffc1.getMedias();
494 
							if(mediaMap==null){
495 
								continue;
496 
							}
497 
							for(Media media : mediaMap.values()){
498 
								if(media.getType().equals(Type.IMAGE) || media.getType().equals(Type.DOCUMENT)){
499 
									copyMedia(String.valueOf(newCounter), String.valueOf(entityId),media);
500 
								}
501 
							}
502 
						}
503 
					}
504 
 
505 
				}
506 
 
507 
				Entity newEntity = new Entity(newCounter, 10099);
5374 amit.gupta 508 
				List<Long> newSlideSequence = new ArrayList<Long>();
509 
				newSlideSequence.add(130128L);
510 
				newSlideSequence.add(130129L);
511 
				newSlideSequence.add(130054L);
512 
				newEntity.setSlideSequence(newSlideSequence);
5370 amit.gupta 513 
				newEntity.setBrand(entity.getBrand());
514 
				newEntity.setModelName(entity.getModelName());
515 
				newEntity.setModelNumber(entity.getModelNumber());
516 
				//entitySlides.remove(featureSlide);
517 
				newEntitySlides.add(connectivitySlide);
518 
				newEntitySlides.add(looknfeelSlide);
519 
				newEntitySlides.add(summarySlide);
520 
				newEntity.setSlides(newEntitySlides);
521 
				EntityState es = new EntityState(newCounter, 10099, "admin");
522 
				es.setBrand(entity.getBrand());
523 
				es.setModelName(entity.getModelName());
524 
				es.setModelNumber(entity.getModelNumber());
525 
				CreationUtils.createEntity(newEntity, es);
526 
				System.out.println("New entity : " + newCounter + " created using : " + entityId);
527 
				System.out.println(CreationUtils.getEntity(newCounter));
528 
				newCounter++;
529 
			}catch(Exception e){
530 
				System.out.println("Could not migrate " + entityId);
531 
			}
532 
		}
533 
 
534 
	}
4818 amit.gupta 535 
 
536 
	private long getEnumValueForNetwork(String value, Long entityLong) {
537 
		value = value.toLowerCase().replaceAll(" ", "");
538 
		Map<String, Long> map = new HashMap<String, Long>();
4964 amit.gupta 539 
		map.put("quadband(gsm850/900/1800/1900)", 110382L);
4818 amit.gupta 540 
		map.put("quadband(gsm850/900/1800/1900)-sim1", 110383l);
541 
		map.put("quadband(gsm850/900/1800/1900)-sim2", 110384l);
542 
		map.put("triband(gsm900/1800/1900)", 110385l);
543 
		map.put("triband(gsm900/1800/1900)-sim1", 110386l);
544 
		map.put("triband(gsm900/1800/1900)-sim2", 110387l);
545 
		map.put("dualband(gsm900/1800)", 110388l);
546 
		map.put("dualband(gsm900/1800)-sim1", 110389l);
547 
		map.put("dualband(gsm900/1800)-sim2", 110390l);
4964 amit.gupta 548 
		map.put("cdma800", 110391l); // CDMA 800
549 
		map.put("cdma800-sim2", 110392l); // CDMA 800-SIM 2
550 
		map.put("cdma800-sim3", 110393l); // CDMA 800-SIM 3
551 
 
552 
		if (!StringUtils.contains(value, "sim")
553 
				&& StringUtils.contains(value, "850/900/1800/1900")) {
4818 amit.gupta 554 
			return map.get("quadband(gsm850/900/1800/1900)");
555 
		}
4964 amit.gupta 556 
		if (StringUtils.contains(value, "sim1")
557 
				&& StringUtils.contains(value, "850/900/1800/1900")) {
4818 amit.gupta 558 
			return map.get("quadband(gsm850/900/1800/1900)-sim1");
559 
		}
4964 amit.gupta 560 
		if (StringUtils.contains(value, "sim2")
561 
				&& StringUtils.contains(value, "850/900/1800/1900")) {
4818 amit.gupta 562 
			return map.get("quadband(gsm850/900/1800/1900)-sim2");
563 
		}
4964 amit.gupta 564 
		if (!StringUtils.contains(value, "sim")
565 
				&& StringUtils.contains(value, "900/1800/1900")) {
4818 amit.gupta 566 
			return map.get("triband(gsm900/1800/1900)");
567 
		}
4964 amit.gupta 568 
		if (StringUtils.contains(value, "sim1")
569 
				&& StringUtils.contains(value, "900/1800/1900")) {
4818 amit.gupta 570 
			return map.get("triband(gsm900/1800/1900)-sim1");
571 
		}
4964 amit.gupta 572 
		if (StringUtils.contains(value, "sim2")
573 
				&& StringUtils.contains(value, "900/1800/1900")) {
4818 amit.gupta 574 
			return map.get("triband(gsm900/1800/1900)-sim2");
575 
		}
4964 amit.gupta 576 
		if (!StringUtils.contains(value, "sim")
577 
				&& StringUtils.contains(value, "900/1800")) {
4818 amit.gupta 578 
			return map.get("dualband(gsm900/1800)");
579 
		}
4964 amit.gupta 580 
		if (StringUtils.contains(value, "sim1")
581 
				&& StringUtils.contains(value, "900/1800")) {
4818 amit.gupta 582 
			return map.get("dualband(gsm900/1800)-sim1");
583 
		}
4964 amit.gupta 584 
		if (StringUtils.contains(value, "sim2")
585 
				&& StringUtils.contains(value, "900/1800")) {
4818 amit.gupta 586 
			return map.get("dualband(gsm900/1800)-sim2");
587 
		}
4964 amit.gupta 588 
		if (StringUtils.contains(value, "cdma")) {
589 
			if (StringUtils.contains(value, "sim2")) {
4818 amit.gupta 590 
				return map.get("cdma800-sim2");
591 
			}
4964 amit.gupta 592 
			if (StringUtils.contains(value, "sim3")) {
4818 amit.gupta 593 
				return map.get("cdma800-sim3");
594 
			}
595 
			return map.get("cdma800");
4964 amit.gupta 596 
		} else {
597 
			System.out.println("Unknown networks: " + value + " : "
598 
					+ entityLong);
4818 amit.gupta 599 
			return 0;
600 
		}
601 
	}
602 
 
457 rajveer 603 
	public ContentMigrator(String sourceDbPath, String destinationDbPath) {
4964 amit.gupta 604 
		this.sourceDbPath = sourceDbPath;
457 rajveer 605 
		this.destinationDbPath = destinationDbPath;
606 
	}
2720 mandeep.dh 607 
 
3873 mandeep.dh 608 
	public void migrateWarrantyType() throws Exception {
4964 amit.gupta 609 
		Map<Long, Entity> map = CreationUtils.getEntities();
610 
		for (Long entityId : map.keySet()) {
611 
			Entity entity = map.get(entityId);
612 
			if (entity == null || entity.getSlides() == null) {
613 
				continue;
614 
			}
615 
			for (Slide slide : entity.getSlides()) {
616 
				if (slide.getSlideDefinitionID() == 130054) {
617 
					Slide warrantySlide = new Slide(130105);
618 
					warrantySlide.setFeatures(new ArrayList<Feature>());
3873 mandeep.dh 619 
 
4964 amit.gupta 620 
					Feature feature = new Feature(120219);
621 
					feature.setBullets(Collections.singletonList(new Bullet(
622 
							new EnumDataObject(110299))));
623 
					warrantySlide.getFeatures().add(feature);
3873 mandeep.dh 624 
 
4964 amit.gupta 625 
					Feature existingWarrantyFeature = null;
626 
					for (Feature summaryFeature : slide.getFeatures()) {
627 
						if (summaryFeature.getFeatureDefinitionID() == 120125) {
628 
							existingWarrantyFeature = summaryFeature;
629 
							warrantySlide.getFeatures().add(summaryFeature);
630 
							break;
631 
						}
632 
					}
3873 mandeep.dh 633 
 
4964 amit.gupta 634 
					slide.getFeatures().remove(existingWarrantyFeature);
635 
					slide.addChild(warrantySlide);
636 
					break;
637 
				}
638 
 
639 
			}
640 
 
641 
			CreationUtils.updateEntity(entity);
642 
		}
3873 mandeep.dh 643 
	}
644 
 
2720 mandeep.dh 645 
	public void migrateMedia() throws Exception {
4964 amit.gupta 646 
		Map<Long, Entity> map = CreationUtils.getEntities();
647 
		for (Long entityId : map.keySet()) {
648 
			Entity entity = map.get(entityId);
649 
			if (entity == null || entity.getSlides() == null) {
650 
				continue;
651 
			}
652 
			for (Slide slide : entity.getSlides()) {
653 
				FreeformContent ffc = slide.getFreeformContent();
2720 mandeep.dh 654 
 
4964 amit.gupta 655 
				// if (ffc == null || ffc.getMediasNew() == null) {
656 
				// continue;
657 
				// }
658 
				//
659 
				// Map<String, Media> newMap = new LinkedHashMap<String,
660 
				// Media>();
661 
				// Media media = null;
662 
				// for (String label : ffc.getMediasNew().keySet()) {
663 
				// MediaNew m = ffc.getMediasNew().get(label);
664 
				// media = new Media(m.getLabel(), Media.Type.valueOf(m
665 
				// .getType().name()), m.getLocation());
666 
				// media.setTitle(m.getTitle());
667 
				// media.setFileName(m.getFileName());
668 
				// newMap.put(label, media);
669 
				// }
670 
				// ffc.setMedias(newMap);
671 
				// ffc.setMediasNew(null);
2720 mandeep.dh 672 
 
4964 amit.gupta 673 
				// if (ffc == null || ffc.getMedias() == null) {
674 
				// continue;
675 
				// }
676 
				// Map<String, MediaNew> newMap = new LinkedHashMap<String,
677 
				// MediaNew>();
678 
				// MediaNew mediaNew = null;
679 
				// for (String label : ffc.getMedias().keySet()) {
680 
				// Media m = ffc.getMedias().get(label);
681 
				// if (m.getType().equalsIgnoreCase("image")) {
682 
				// mediaNew = new MediaNew(m.getLabel(),
683 
				// MediaNew.Type.IMAGE, m.getLocation());
684 
				// mediaNew.setFileName(m.getFileName());
685 
				// } else if (m.getType().equalsIgnoreCase("youtube")) {
686 
				// if (m.getVideoType().equalsIgnoreCase("withskin")) {
687 
				// mediaNew = new MediaNew(m.getLabel(),
688 
				// MediaNew.Type.VIDEO_WITH_SKIN,
689 
				// m.getLocation());
690 
				// } else {
691 
				// mediaNew = new MediaNew(m.getLabel(),
692 
				// MediaNew.Type.VIDEO_WITHOUT_SKIN,
693 
				// m.getLocation());
694 
				// }
695 
				// }
696 
				//
697 
				// if (mediaNew != null) {
698 
				// mediaNew.setTitle(m.getTitle());
699 
				// newMap.put(label, mediaNew);
700 
				// }
701 
				// }
702 
				// ffc.setMediasNew(newMap);
703 
				// ffc.setMedias(null);
704 
			}
705 
		}
2720 mandeep.dh 706 
	}
707 
 
4964 amit.gupta 708 
	public boolean populateHelpdocEntityIds() throws Exception {
709 
		for (Entity entity : CreationUtils.getEntities().values()) {
2471 rajveer 710 
			CreationUtils.updateEntity(entity);
711 
		}
712 
		return true;
713 
	}
2720 mandeep.dh 714 
 
4964 amit.gupta 715 
	public boolean migrateBrandModel(String dryRun) throws Exception {
3127 rajveer 716 
		CatalogClient catalogServiceClient = new CatalogClient();
2287 rajveer 717 
		Client client = catalogServiceClient.getClient();
718 
		List<Item> items = client.getAllItemsByStatus(status.ACTIVE);
719 
		items.addAll(client.getAllItemsByStatus(status.PAUSED));
720 
		items.addAll(client.getAllItemsByStatus(status.CONTENT_COMPLETE));
721 
		Map<Long, Entity> entities = CreationUtils.getEntities();
722 
		long count = 0;
723 
		StringBuffer sb = new StringBuffer();
4964 amit.gupta 724 
		for (Item item : items) {
2287 rajveer 725 
			long entityId = item.getCatalogItemId();
726 
			Entity entity = entities.get(entityId);
4964 amit.gupta 727 
			if (entity == null) {
2292 rajveer 728 
				continue;
729 
			}
2294 rajveer 730 
			String itemBrand = item.getBrand().trim();
2287 rajveer 731 
			String itemModelName = item.getModelName();
4964 amit.gupta 732 
			if (itemModelName != null) {
2294 rajveer 733 
				itemModelName = itemModelName.trim();
734 
			}
735 
			String itemModelNumber = item.getModelNumber().trim();
736 
			String entityBrand = entity.getBrand().trim();
737 
			String entityModelName = entity.getModelName().trim();
4964 amit.gupta 738 
			if (entityModelName != null) {
2294 rajveer 739 
				entityModelName = entityModelName.trim();
740 
			}
741 
			String entityModelNumber = entity.getModelNumber().trim();
4964 amit.gupta 742 
 
743 
			if (itemBrand.equals(entityBrand)
744 
					&& itemModelNumber.equals(entityModelNumber)) {
745 
				if (itemModelName != null && entityModelName != null
746 
						&& itemModelName.equals(entityModelName)) {
2292 rajveer 747 
					continue;
4964 amit.gupta 748 
				} else if (itemModelName == null && entityModelName == null) {
749 
					continue;
2292 rajveer 750 
				}
4964 amit.gupta 751 
 
2287 rajveer 752 
			}
753 
			count++;
4964 amit.gupta 754 
			sb.append(count + ") Item:   " + itemBrand + "\t" + itemModelName
755 
					+ "\t" + itemModelNumber + "\t" + item.getId() + "\n");
756 
			sb.append(count + ") Entity: " + entityBrand + "\t"
757 
					+ entityModelName + "\t" + entityModelNumber + "\t"
758 
					+ entity.getID() + "\n");
759 
 
760 
			if (dryRun.equals("false")) {
2294 rajveer 761 
				item.setBrand(entityBrand);
762 
				item.setModelName(entityModelName);
763 
				item.setModelNumber(entityModelNumber);
4964 amit.gupta 764 
				client.updateItem(item);
2287 rajveer 765 
			}
766 
		}
767 
		System.out.println(sb.toString());
768 
		return true;
769 
	}
2720 mandeep.dh 770 
 
473 rajveer 771 
	/**
4964 amit.gupta 772 
	 * this function will read source definition and source entities, and will
773 
	 * convert source entities to destination entities according to destination
774 
	 * definitions.
473 rajveer 775 
	 *
776 
	 * @return boolean
4964 amit.gupta 777 
	 * @throws Exception
473 rajveer 778 
	 */
1226 rajveer 779 
 
4964 amit.gupta 780 
	public void printSlides() throws Exception {
781 
		DefinitionsContainer defc = Catalog.getInstance()
782 
				.getDefinitionsContainer();
783 
		for (Category category : defc.getCategories().values()) {
784 
			if (category.getChildrenCategory() != null)
785 
				continue;
786 
			System.out.println(category.getID() + "\t" + category.getLabel());
787 
			for (CategorySlideDefinition defs : defc
788 
					.getCategorySlideDefinitions(category.getID())) {
789 
				System.out.println(defs.getSlideDefintionID()
790 
						+ "\t"
791 
						+ defs.getEditorialImportance()
792 
						+ "\t"
793 
						+ defc.getSlideDefinition(defs.getSlideDefintionID())
794 
								.getLabel()
795 
						+ "\t"
796 
						+ defc.getSlideDefinition(defs.getSlideDefintionID())
797 
								.getChildrenSlideDefinitionIDs());
1226 rajveer 798 
			}
799 
		}
800 
	}
4964 amit.gupta 801 
 
802 
	public void removeBrowserBullets() throws Exception {
803 
		Map<Long, List<ExpandedBullet>> learnedBullets = CreationUtils
804 
				.getLearnedBullets();
1226 rajveer 805 
		learnedBullets.get(new Long(120076));
806 
		learnedBullets.remove(new Long(120076));
807 
		CreationUtils.storeLearnedBullets(learnedBullets);
4964 amit.gupta 808 
 
1226 rajveer 809 
	}
4964 amit.gupta 810 
 
811 
	public boolean changeEntityState() throws Exception {
1226 rajveer 812 
		Map<Long, EntityState> entitiesState = CreationUtils.getEntitiesState();
8548 amit.gupta 813 
		Entity entity;
4964 amit.gupta 814 
		for (Long entityId : entitiesState.keySet()) {
1226 rajveer 815 
			EntityState state = entitiesState.get(entityId);
8548 amit.gupta 816 
			entity = CreationUtils.getEntity(entityId);
817 
			if (state.getCategoryID() == 10006) {
818 
				//state.setCategoryID(10006);
819 
				entity.setCategoryID(10006);
820 
				//CreationUtils.updateEntityState(state);
821 
				CreationUtils.updateEntity(entity);
8510 amit.gupta 822 
				touchEntityState(entityId);
1226 rajveer 823 
			}
824 
		}
825 
		return true;
826 
	}
1739 rajveer 827 
 
4964 amit.gupta 828 
	public boolean migrateDataBack() throws Exception {
1226 rajveer 829 
		Map<Long, Entity> entities = CreationUtils.getEntities();
4964 amit.gupta 830 
		for (Entity entity : entities.values()) {
831 
			if (entity == null) {
832 
				continue;
833 
			}
1226 rajveer 834 
			List<Slide> slides = entity.getSlides();
4964 amit.gupta 835 
			if (slides != null) {
836 
				for (Slide slide : slides) {
837 
					if (slide.getSlideDefinitionID() == 130054) {
838 
						List<Feature> features = slide.getFeatures();
839 
						int length = features.size();
840 
						features.remove(length - 1);
841 
						features.remove(length - 2);
842 
						features.remove(length - 3);
843 
						/*
844 
						 * boolean a = false,b=false,c=false; for(Feature
845 
						 * feature: features){ switch
846 
						 * ((int)feature.getFeatureDefinitionID()) { case
847 
						 * 120132: if(a){
848 
						 *
849 
						 * }else{ a=true; } break; case 120133: break; case
850 
						 * 120134: break; default: break; } }
851 
						 */
852 
						CreationUtils.updateEntity(entity);
1226 rajveer 853 
					}
854 
				}
855 
			}
856 
		}
4964 amit.gupta 857 
		return true;
1226 rajveer 858 
	}
4964 amit.gupta 859 
 
860 
	public boolean migrateData() throws Exception {
1226 rajveer 861 
		Map<Long, Entity> entities = CreationUtils.getEntities();
4964 amit.gupta 862 
		for (Entity entity : entities.values()) {
863 
			ExpandedEntity expEntity = new ExpandedEntity(entity);
1226 rajveer 864 
			List<Slide> slides = entity.getSlides();
4964 amit.gupta 865 
			if (slides != null) {
866 
				for (Slide slide : slides) {
867 
					if (slide.getSlideDefinitionID() == 130054) {
868 
						List<Feature> features = slide.getFeatures();
869 
						String title = expEntity.getBrand() + " "
870 
								+ expEntity.getModelName() + " "
871 
								+ expEntity.getModelNumber();
872 
						if (expEntity.getCategory().getParentCategory().getID() == 10001) {
873 
							title += " | " + expEntity.getBrand()
874 
									+ " Mobile Phones";
1226 rajveer 875 
						}
4964 amit.gupta 876 
						if (expEntity.getCategory().getParentCategory().getID() == 10011) {
877 
							title += " " + expEntity.getCategory().getLabel()
878 
									+ " | " + expEntity.getBrand()
879 
									+ " Mobile Phone Accessories";
1226 rajveer 880 
						}
4964 amit.gupta 881 
						title += " | Saholic.com";
882 
 
883 
						// Add page title
884 
						Feature feature1 = new Feature(120132);
885 
						PrimitiveDataObject pdo1 = new PrimitiveDataObject(
886 
								title);
887 
						List<Bullet> bullets1 = new ArrayList<Bullet>();
888 
						Bullet bullet1 = new Bullet(pdo1);
889 
						bullets1.add(bullet1);
890 
						feature1.setBullets(bullets1);
891 
						features.add(feature1);
892 
 
893 
						String description = "Best Price "
894 
								+ expEntity.getBrand() + " "
895 
								+ expEntity.getModelName() + " "
896 
								+ expEntity.getModelNumber() + " ";
897 
 
898 
						if (expEntity.getCategory().getParentCategory().getID() == 10011) {
899 
							description += expEntity.getCategory().getLabel()
900 
									+ " in India.";
901 
						} else {
902 
							description += ".";
1226 rajveer 903 
						}
4964 amit.gupta 904 
						description += " Experience n' buy online. FREE Next Day delivery."
905 
								+ " Original product - Full manufacturer warranty. Comprehensive reviews.";
1226 rajveer 906 
 
4964 amit.gupta 907 
						description = description.replaceAll("--", "-");
908 
 
909 
						// Add meta description
910 
						Feature feature2 = new Feature(120133);
911 
						PrimitiveDataObject pdo2 = new PrimitiveDataObject(
912 
								description);
913 
						List<Bullet> bullets2 = new ArrayList<Bullet>();
914 
						Bullet bullet2 = new Bullet(pdo2);
915 
						bullets2.add(bullet2);
916 
						feature2.setBullets(bullets2);
917 
 
918 
						features.add(feature2);
919 
 
920 
						String keywords = expEntity.getBrand() + " "
921 
								+ expEntity.getModelName() + " "
922 
								+ expEntity.getModelNumber() + ", ";
923 
						if (expEntity.getCategory().getParentCategory().getID() == 10001) {
924 
							keywords += expEntity.getBrand()
925 
									+ " mobile phones, ";
1226 rajveer 926 
						}
4964 amit.gupta 927 
						if (expEntity.getCategory().getParentCategory().getID() == 10011) {
928 
							keywords += "phone accessories, ";
1226 rajveer 929 
						}
4964 amit.gupta 930 
						keywords += expEntity.getBrand() + " "
931 
								+ expEntity.getModelName() + " "
932 
								+ expEntity.getModelNumber() + " Price, ";
933 
						keywords += expEntity.getBrand() + " "
934 
								+ expEntity.getModelName() + " "
935 
								+ expEntity.getModelNumber() + " India, ";
936 
						if (expEntity.getCategory().getParentCategory().getID() == 10001) {
937 
							keywords += expEntity.getBrand() + " "
938 
									+ expEntity.getModelName() + " "
939 
									+ expEntity.getModelNumber() + " Review, ";
1226 rajveer 940 
						}
4964 amit.gupta 941 
						// Add meta keyborad
942 
						Feature feature3 = new Feature(120134);
943 
						PrimitiveDataObject pdo3 = new PrimitiveDataObject(
944 
								keywords);
945 
						List<Bullet> bullets3 = new ArrayList<Bullet>();
946 
						Bullet bullet3 = new Bullet(pdo3);
947 
						bullets3.add(bullet3);
948 
						feature3.setBullets(bullets3);
949 
 
950 
						features.add(feature3);
951 
 
952 
						CreationUtils.updateEntity(entity);
953 
					}
954 
				}
955 
			}
956 
		}
957 
		return true;
958 
	}
959 
 
960 
	public boolean migrateModel2() throws Exception {
961 
		Map<Long, Entity> entities = CreationUtils.getEntities();
962 
		for (Entity entity : entities.values()) {
963 
			List<Slide> slides = entity.getSlides();
964 
			if (slides != null) {
965 
				for (Slide slide : slides) {
966 
					if (slide.getSlideDefinitionID() == 130011) {
967 
						for (Feature feature : slide.getFeatures()) {
968 
							if (feature.getFeatureDefinitionID() == 120054) {
969 
								// feature.setFeatureDefinitionID(120030);
970 
								System.out.println("* " + entity.getID() + ":"
971 
										+ entity.getCategoryID());
1226 rajveer 972 
							}
973 
						}
4964 amit.gupta 974 
					}
1226 rajveer 975 
 
4964 amit.gupta 976 
					if (slide.getSlideDefinitionID() == 130029) {
977 
						// System.out.println("** " + entity.getID() + ":" +
978 
						// entity.getCategoryID());
979 
						if (entity.getCategoryID() == 10002) {
980 
							Feature feature = new Feature(120051);
981 
							slide.getFeatures().add(feature);
982 
							System.out.println("** " + entity.getID() + ":"
983 
									+ entity.getCategoryID());
1226 rajveer 984 
						}
985 
					}
986 
 
987 
				}
988 
			}
4964 amit.gupta 989 
			CreationUtils.updateEntity(entity);
1226 rajveer 990 
		}
991 
		return true;
992 
	}
4964 amit.gupta 993 
 
994 
	/*
995 
	 * public boolean migrateModel1() throws Exception{ //DefinitionsContainer
996 
	 * oldDfc = new DefinitionsContainer(Utils.CONTENT_DB_PATH +
997 
	 * "olddefinitions" + File.separator); //DefinitionsContainer newDfc = new
998 
	 * DefinitionsContainer(Utils.CONTENT_DB_PATH + "olddefinitions" +
999 
	 * File.separator);
1000 
	 *
1001 
	 * Map<Long, Entity> entities = CreationUtils.getEntities(); for(Entity
1002 
	 * entity: entities.values()){ List<Long> slideSequence =
1003 
	 * entity.getSlideSequence(); Map<Long,Long> removeMap = new HashMap<Long,
1004 
	 * Long>(); List<Slide> slides = entity.getSlides(); if(slides!=null){
1005 
	 * for(Slide slide: slides){ List<Feature> features; Slide childSlide;
1006 
	 * switch ((int)slide.getSlideDefinitionID()) {
1007 
	 *
1008 
	 * //Keyboard case 130004: case 130026: case 130027: case 130057:
1009 
	 * removeMap.put(slide.getSlideDefinitionID(), (long)130026);
1010 
	 * slide.setSlideDefinitionID(130026); break;
1011 
	 *
1012 
	 * //Voice Calling case 130005: removeMap.put(slide.getSlideDefinitionID(),
1013 
	 * (long)130005); slide.setSlideDefinitionID(130005); features = new
1014 
	 * ArrayList<Feature>(); features.addAll(slide.getFeatures()); childSlide =
1015 
	 * slide.getChildrenSlides().get(0);
1016 
	 * features.addAll(childSlide.getFeatures());
1017 
	 * if(childSlide.getFreeformContent()!=null){
1018 
	 * System.out.println("Voice Calling : HAS FFC : " +
1019 
	 * childSlide.getFreeformContent().getFreeformText() +
1020 
	 * childSlide.getFreeformContent().getMedias()); }
1021 
	 * slide.setChildrenSlides(null); slide.setFeatures(features); break; case
1022 
	 * 130035: removeMap.put(slide.getSlideDefinitionID(), (long)130005);
1023 
	 * slide.setSlideDefinitionID(130005); for(Feature feata:
1024 
	 * slide.getFeatures()){ if(feata.getFeatureDefinitionID()==120055){
1025 
	 * feata.setFeatureDefinitionID(120012); } } break;
1026 
	 *
1027 
	 * //Data Connectivity case 130007: case 130028:
1028 
	 * removeMap.put(slide.getSlideDefinitionID(), (long)130007);
1029 
	 * slide.setSlideDefinitionID(130007); break;
1030 
	 *
1031 
	 * //Music case 130029: case 130030: case 130008:
1032 
	 * removeMap.put(slide.getSlideDefinitionID(), (long)130029);
1033 
	 * slide.setSlideDefinitionID(130029); break;
1034 
	 *
1035 
	 * //Video case 130031: case 130009:
1036 
	 * removeMap.put(slide.getSlideDefinitionID(), (long)130031);
1037 
	 * slide.setSlideDefinitionID(130031); break;
1038 
	 *
1039 
	 * //Camera case 130010: case 130036: case 130037:
1040 
	 * removeMap.put(slide.getSlideDefinitionID(), (long)130010);
1041 
	 * slide.setSlideDefinitionID(130010); break; case 130060:
1042 
	 * removeMap.put(slide.getSlideDefinitionID(), (long)130010);
1043 
	 * slide.setSlideDefinitionID(130010);
1044 
	 *
1045 
	 * features = slide.getFeatures(); // Just to add camera feature in basic
1046 
	 * phones Feature feature = new Feature(120056); List<Bullet> bullets = new
1047 
	 * ArrayList<Bullet>(); PrimitiveDataObject pdo = new
1048 
	 * PrimitiveDataObject("1"); Bullet bullet = new Bullet(pdo);
1049 
	 * bullets.add(bullet); feature.setBullets(bullets); features.add(feature);
1050 
	 * //Created new feature break;
1051 
	 *
1052 
	 * //Memory case 130011: removeMap.put(slide.getSlideDefinitionID(),
1053 
	 * (long)130011); slide.setSlideDefinitionID(130011); break; case 130032:
1054 
	 * case 130061: removeMap.put(slide.getSlideDefinitionID(), (long)130011);
1055 
	 * slide.setSlideDefinitionID(130011); features = slide.getFeatures();
1056 
	 * for(Feature feat: features){ if(feat.getFeatureDefinitionID() == 120054){
1057 
	 * feat.setFeatureDefinitionID(120030); } } break;
1058 
	 *
1059 
	 * //Battery case 130044: removeMap.put(slide.getSlideDefinitionID(),
1060 
	 * (long)130043); slide.setSlideDefinitionID(130043);
1061 
	 * if(slide.getChildrenSlides().get(0).getSlideDefinitionID() == 130047){
1062 
	 * slide.getChildrenSlides().get(0).setSlideDefinitionID(130046); } break;
1063 
	 *
1064 
	 * case 130042: removeMap.put(slide.getSlideDefinitionID(), (long)130043);
1065 
	 * slide.setSlideDefinitionID(130043); childSlide =
1066 
	 * slide.getChildrenSlides().get(0); if(childSlide.getSlideDefinitionID() ==
1067 
	 * 130045){ childSlide.setSlideDefinitionID(130046); }
1068 
	 *
1069 
	 * List<Feature> childFeatures1 = new ArrayList<Feature>(); List<Feature>
1070 
	 * childFeatures2 = new ArrayList<Feature>(); Slide childChildSlide1 = new
1071 
	 * Slide(130048); Slide childChildSlide2 = new Slide(130049);
1072 
	 *
1073 
	 * childChildSlide1.setFeatures(childFeatures1);
1074 
	 * childChildSlide2.setFeatures(childFeatures2);
1075 
	 *
1076 
	 * childSlide.addChild(childChildSlide1);
1077 
	 * childSlide.addChild(childChildSlide2);
1078 
	 *
1079 
	 *
1080 
	 * for(Feature f: childSlide.getFeatures()){ if(f.getFeatureDefinitionID()
1081 
	 * == 120063){ f.setFeatureDefinitionID(120068); childFeatures1.add(f); }
1082 
	 * if(f.getFeatureDefinitionID() == 120064){
1083 
	 * f.setFeatureDefinitionID(120069); childFeatures2.add(f); } }
1084 
	 *
1085 
	 * childSlide.setFeatures(null);
1086 
	 *
1087 
	 * break;
1088 
	 *
1089 
	 * case 130062: removeMap.put(slide.getSlideDefinitionID(), (long)130043);
1090 
	 * slide.setSlideDefinitionID(130043);
1091 
	 *
1092 
	 * childSlide = new Slide(130046); features = new ArrayList<Feature>();
1093 
	 *
1094 
	 * slide.addChild(childSlide);
1095 
	 *
1096 
	 * List<Feature> childFeatures11 = new ArrayList<Feature>(); List<Feature>
1097 
	 * childFeatures21 = new ArrayList<Feature>(); Slide childChildSlide11 = new
1098 
	 * Slide(130048); Slide childChildSlide21 = new Slide(130049);
1099 
	 *
1100 
	 * childChildSlide11.setFeatures(childFeatures11);
1101 
	 * childChildSlide21.setFeatures(childFeatures21);
1102 
	 *
1103 
	 * childSlide.addChild(childChildSlide11);
1104 
	 * childSlide.addChild(childChildSlide21); for(Feature f:
1105 
	 * slide.getFeatures()){ if(f.getFeatureDefinitionID() == 120072){
1106 
	 * features.add(f); } if(f.getFeatureDefinitionID() == 120073){
1107 
	 * features.add(f); } if(f.getFeatureDefinitionID() == 120063){
1108 
	 * f.setFeatureDefinitionID(120068); childFeatures11.add(f); }
1109 
	 * if(f.getFeatureDefinitionID() == 120064){
1110 
	 * f.setFeatureDefinitionID(120069); childFeatures21.add(f); } }
1111 
	 * slide.setFeatures(features); break;
1112 
	 *
1113 
	 *
1114 
	 * //Mail n Msg case 130041: case 130063:
1115 
	 * removeMap.put(slide.getSlideDefinitionID(), (long)130039);
1116 
	 * slide.setSlideDefinitionID(130039); break; case 130039:
1117 
	 * removeMap.put(slide.getSlideDefinitionID(), (long)130039);
1118 
	 * slide.setSlideDefinitionID(130039);
1119 
	 *
1120 
	 * childSlide = slide.getChildrenSlides().get(0);
1121 
	 * slide.setFeatures(childSlide.getFeatures());
1122 
	 * if(childSlide.getFreeformContent()!=null){
1123 
	 * System.out.println("Mail n Msg : HAS FFC : " +
1124 
	 * childSlide.getFreeformContent().getFreeformText() +
1125 
	 * childSlide.getFreeformContent().getMedias()); }
1126 
	 * slide.setChildrenSlides(null); break;
1127 
	 *
1128 
	 * //Software case 130020: case 130034:
1129 
	 * removeMap.put(slide.getSlideDefinitionID(), (long)130020);
1130 
	 * slide.setSlideDefinitionID(130020); break;
1131 
	 *
1132 
	 *
1133 
	 * //Internet case 130050: removeMap.put(slide.getSlideDefinitionID(),
1134 
	 * (long)130050); slide.setSlideDefinitionID(130050);
1135 
	 * slide.setFeatures(slide.getChildrenSlides().get(0).getFeatures());
1136 
	 *
1137 
	 * if(slide.getChildrenSlides().get(0).getFreeformContent()!=null){ String
1138 
	 * ffc = slide.getFreeformContent().getFreeformText();
1139 
	 * if(slide.getChildrenSlides
1140 
	 * ().get(0).getFreeformContent().getFreeformText()!=null){
1141 
	 * if(slide.getChildrenSlides
1142 
	 * ().get(0).getFreeformContent().getFreeformText().trim()!=""){ ffc = ffc +
1143 
	 * "\n *********    " +
1144 
	 * slide.getChildrenSlides().get(0).getFreeformContent().getFreeformText();
1145 
	 * System.out.println("**************" +
1146 
	 * slide.getChildrenSlides().get(0).getFreeformContent().getFreeformText());
1147 
	 * } }
1148 
	 *
1149 
	 * List<String> ffcs = new ArrayList<String>(); ffcs.add(ffc);
1150 
	 * slide.getFreeformContent().setFreeformTexts(ffcs); }
1151 
	 *
1152 
	 * slide.setChildrenSlides(null); //System.out.println("Slide: 130050");
1153 
	 * //printSlideContent(slide); break;
1154 
	 *
1155 
	 * case 130052: removeMap.put(slide.getSlideDefinitionID(), (long)130050);
1156 
	 * slide.setSlideDefinitionID(130050);
1157 
	 *
1158 
	 * for(Feature f2: slide.getFeatures()){ if(f2.getFeatureDefinitionID() ==
1159 
	 * 120077){ f2.setFeatureDefinitionID(120074); // List<Bullet> newBullets =
1160 
	 * new ArrayList<Bullet>(); // for(Bullet bul: f2.getBullets()){ //
1161 
	 * CompositeDataObject cdo = (CompositeDataObject) bul.getDataObject(); //
1162 
	 * for(PrimitiveDataObject pdo1: cdo.getPrimitiveDataObjects()){ //
1163 
	 * pdo1.getValue(); // BulletDataObject bdo2 = new
1164 
	 * EnumDataObject(enumValueID); // Bullet newbul = new Bullet(bdo2); //
1165 
	 * newBullets.add(newbul); // } // // } // f2.setBullets(newBullets); }
1166 
	 * if(f2.getFeatureDefinitionID() == 120078){
1167 
	 * f2.setFeatureDefinitionID(120075); } } //
1168 
	 * slide.setFeatures(slide.getChildrenSlides().get(0).getFeatures()); //
1169 
	 * slide.setChildrenSlides(null); //System.out.println("Slide: 130052");
1170 
	 *
1171 
	 * //printSlideContent(slide); break;
1172 
	 *
1173 
	 * case 130051: removeMap.put(slide.getSlideDefinitionID(), (long)130050);
1174 
	 * slide.setSlideDefinitionID(130050); // System.out.println(slide);
1175 
	 * //System.out.println("Slide 130051:"); // printSlideContent(slide);
1176 
	 * break;
1177 
	 *
1178 
	 * default: break; }
1179 
	 *
1180 
	 * } List<Long> newSequence = new ArrayList<Long>(); for(Long id:
1181 
	 * slideSequence){ if(removeMap.containsKey(id)){
1182 
	 * newSequence.add(removeMap.get(id)); }else{ newSequence.add(id); } }
1183 
	 * entity.setSlideSequence(newSequence); CreationUtils.updateEntity(entity);
1184 
	 * } }
1185 
	 *
1186 
	 * return true; }
1187 
	 */
1188 
 
1189 
	public void printSlideContent(Slide slide) {
1190 
 
1191 
		System.out.println("Slide: "
1192 
				+ slide.getFreeformContent().getFreeformText());
1193 
		if (slide.getFeatures() != null) {
1194 
			for (Feature feature : slide.getFeatures()) {
1195 
				if (feature.getBullets() != null) {
1196 
					for (Bullet bullet : feature.getBullets()) {
1197 
						// System.out.println(bullet.getDataObject().toString());
1198 
						// System.out.println(bullet.getFreeformContent());
1226 rajveer 1199 
					}
1200 
				}
4964 amit.gupta 1201 
				if (feature.getFreeformContent() != null) {
1202 
					System.out.println("Feature: "
1203 
							+ feature.getFreeformContent().getFreeformText());
1226 rajveer 1204 
				}
1205 
			}
1206 
		}
4964 amit.gupta 1207 
		if (slide.getChildrenSlides() != null) {
1208 
			for (Slide sl : slide.getChildrenSlides()) {
1226 rajveer 1209 
				System.out.println("Child1: ");
1210 
				printSlideContent(sl);
1211 
				System.out.println("Child2: ");
1212 
			}
1213 
		}
4964 amit.gupta 1214 
 
1226 rajveer 1215 
	}
4964 amit.gupta 1216 
 
1230 rajveer 1217 
	/*
4964 amit.gupta 1218 
	 * public boolean migrateModel() throws Exception{ //DefinitionsContainer
1219 
	 * oldDfc = new DefinitionsContainer(Utils.CONTENT_DB_PATH +
1220 
	 * "olddefinitions" + File.separator); //DefinitionsContainer newDfc = new
1221 
	 * DefinitionsContainer(Utils.CONTENT_DB_PATH + "olddefinitions" +
1222 
	 * File.separator);
1223 
	 *
1224 
	 * Map<Long, Entity> entities = CreationUtils.getEntities(); for(Entity
1225 
	 * entity: entities.values()){ List<Slide> slides = entity.getSlides();
1226 
	 * if(slides!=null){ List<Slide> newSlides = new ArrayList<Slide>();
1227 
	 * for(Slide slide: slides){ Slide newSlide; List<Feature> features; Slide
1228 
	 * childSlide; switch ((int)slide.getSlideDefinitionID()) {
1229 
	 *
1230 
	 * //Keyboard case 130004: case 130026: case 130027: case 130057: newSlide =
1231 
	 * new Slide(130026); newSlide.setChildrenSlides(slide.getChildrenSlides());
1232 
	 * newSlide.setFeatures(slide.getFeatures());
1233 
	 * newSlide.setFreeformContent(slide.getFreeformContent());
1234 
	 * newSlides.add(newSlide); break;
1235 
	 *
1236 
	 * //Voice Calling case 130005: newSlide = new Slide(130005);
1237 
	 * newSlide.setChildrenSlides(null); features = new ArrayList<Feature>();
1238 
	 * features.addAll(slide.getFeatures()); childSlide =
1239 
	 * slide.getChildrenSlides().get(0);
1240 
	 * features.addAll(childSlide.getFeatures());
1241 
	 * if(childSlide.getFreeformContent()!=null){
1242 
	 * System.out.println("Voice Calling : HAS FFC : " +
1243 
	 * childSlide.getFreeformContent().getFreeformText() +
1244 
	 * childSlide.getFreeformContent().getMedias()); }
1245 
	 * newSlide.setFeatures(features);
1246 
	 * newSlide.setFreeformContent(slide.getFreeformContent());
1247 
	 * newSlides.add(newSlide); break; case 130035: newSlide = new
1248 
	 * Slide(130035); newSlide.setChildrenSlides(slide.getChildrenSlides());
1249 
	 * for(Feature feata: slide.getFeatures()){
1250 
	 * if(feata.getFeatureDefinitionID()==120055){
1251 
	 * feata.setFeatureDefinitionID(120012); } }
1252 
	 * newSlide.setFeatures(slide.getFeatures());
1253 
	 * newSlide.setFreeformContent(slide.getFreeformContent());
1254 
	 * newSlides.add(newSlide); break;
1255 
	 *
1256 
	 * //Data Connectivity case 130007: case 130028: newSlide = new
1257 
	 * Slide(130007); newSlide.setChildrenSlides(slide.getChildrenSlides());
1258 
	 * newSlide.setFeatures(slide.getFeatures());
1259 
	 * newSlide.setFreeformContent(slide.getFreeformContent());
1260 
	 * newSlides.add(newSlide); break;
1261 
	 *
1262 
	 * //Music case 130029: case 130030: case 130008: newSlide = new
1263 
	 * Slide(130029); newSlide.setChildrenSlides(slide.getChildrenSlides());
1264 
	 * newSlide.setFeatures(slide.getFeatures());
1265 
	 * newSlide.setFreeformContent(slide.getFreeformContent());
1266 
	 * newSlides.add(newSlide); break;
1267 
	 *
1268 
	 * //Video case 130031: case 130009: newSlide = new Slide(130031);
1269 
	 * newSlide.setChildrenSlides(slide.getChildrenSlides());
1270 
	 * newSlide.setFeatures(slide.getFeatures());
1271 
	 * newSlide.setFreeformContent(slide.getFreeformContent());
1272 
	 * newSlides.add(newSlide); break;
1273 
	 *
1274 
	 * //Camera case 130010: case 130036: case 130037: newSlide = new
1275 
	 * Slide(130010); newSlide.setChildrenSlides(slide.getChildrenSlides());
1276 
	 * newSlide.setFeatures(slide.getFeatures());
1277 
	 * newSlide.setFreeformContent(slide.getFreeformContent());
1278 
	 * newSlides.add(newSlide); break; case 130060: newSlide = new
1279 
	 * Slide(130010); newSlide.setChildrenSlides(slide.getChildrenSlides());
1280 
	 * features = slide.getFeatures(); // Just to add camera feature in basic
1281 
	 * phones Feature feature = new Feature(120056); List<Bullet> bullets = new
1282 
	 * ArrayList<Bullet>(); PrimitiveDataObject pdo = new
1283 
	 * PrimitiveDataObject("1"); Bullet bullet = new Bullet(pdo);
1284 
	 * bullets.add(bullet); feature.setBullets(bullets); features.add(feature);
1285 
	 * //Created new feature newSlide.setFeatures(features);
1286 
	 * newSlide.setFreeformContent(slide.getFreeformContent());
1287 
	 * newSlides.add(newSlide); break;
1288 
	 *
1289 
	 * //Memory case 130011: newSlide = new Slide(130011);
1290 
	 * newSlide.setChildrenSlides(slide.getChildrenSlides());
1291 
	 * newSlide.setFeatures(slide.getFeatures());
1292 
	 * newSlide.setFreeformContent(slide.getFreeformContent());
1293 
	 * newSlides.add(newSlide); break; case 130032: case 130061: newSlide = new
1294 
	 * Slide(130011); newSlide.setChildrenSlides(slide.getChildrenSlides());
1295 
	 * features = slide.getFeatures(); for(Feature feat: features){
1296 
	 * if(feat.getFeatureDefinitionID() == 130054){
1297 
	 * feat.setFeatureDefinitionID(120030); } }
1298 
	 * newSlide.setFeatures(slide.getFeatures());
1299 
	 * newSlide.setFreeformContent(slide.getFreeformContent());
1300 
	 * newSlides.add(newSlide); break;
1301 
	 *
1302 
	 * //Battery case 130044: newSlide = new Slide(130043);
1303 
	 * if(slide.getChildrenSlides().get(0).getSlideDefinitionID() == 130047){
1304 
	 * slide.getChildrenSlides().get(0).setSlideDefinitionID(130046); }
1305 
	 * newSlide.setChildrenSlides(slide.getChildrenSlides());
1306 
	 * newSlide.setFeatures(slide.getFeatures());
1307 
	 * newSlide.setFreeformContent(slide.getFreeformContent());
1308 
	 * newSlides.add(newSlide); break;
1309 
	 *
1310 
	 * case 130042: newSlide = new Slide(130043); childSlide =
1311 
	 * slide.getChildrenSlides().get(0); if(childSlide.getSlideDefinitionID() ==
1312 
	 * 130045){ childSlide.setSlideDefinitionID(130046); }
1313 
	 * newSlide.setChildrenSlides(slide.getChildrenSlides());
1314 
	 *
1315 
	 * List<Feature> childFeatures1 = new ArrayList<Feature>(); List<Feature>
1316 
	 * childFeatures2 = new ArrayList<Feature>(); Slide childChildSlide1 = new
1317 
	 * Slide(130048); Slide childChildSlide2 = new Slide(130049);
1318 
	 *
1319 
	 * childChildSlide1.setFeatures(childFeatures1);
1320 
	 * childChildSlide2.setFeatures(childFeatures2);
1321 
	 *
1322 
	 * childSlide.addChild(childChildSlide1);
1323 
	 * childSlide.addChild(childChildSlide2);
1324 
	 *
1325 
	 *
1326 
	 * for(Feature f: childSlide.getFeatures()){ if(f.getFeatureDefinitionID()
1327 
	 * == 120063){ f.setFeatureDefinitionID(120068); childFeatures1.add(f); }
1328 
	 * if(f.getFeatureDefinitionID() == 120064){
1329 
	 * f.setFeatureDefinitionID(120069); childFeatures2.add(f); } }
1330 
	 *
1331 
	 * childSlide.setFeatures(null);
1332 
	 *
1333 
	 * newSlide.setFeatures(slide.getFeatures());
1334 
	 * newSlide.setFreeformContent(slide.getFreeformContent());
1335 
	 * newSlides.add(newSlide); break;
1336 
	 *
1337 
	 * case 130062: newSlide = new Slide(130043);
1338 
	 * newSlide.setChildrenSlides(slide.getChildrenSlides()); childSlide = new
1339 
	 * Slide(130046); features = new ArrayList<Feature>();
1340 
	 * newSlide.setFeatures(features); newSlide.addChild(childSlide);
1341 
	 *
1342 
	 * List<Feature> childFeatures11 = new ArrayList<Feature>(); List<Feature>
1343 
	 * childFeatures21 = new ArrayList<Feature>(); Slide childChildSlide11 = new
1344 
	 * Slide(130048); Slide childChildSlide21 = new Slide(130049);
1345 
	 *
1346 
	 * childChildSlide11.setFeatures(childFeatures11);
1347 
	 * childChildSlide21.setFeatures(childFeatures21);
1348 
	 *
1349 
	 * childSlide.addChild(childChildSlide11);
1350 
	 * childSlide.addChild(childChildSlide21); for(Feature f:
1351 
	 * slide.getFeatures()){ if(f.getFeatureDefinitionID() == 120072){
1352 
	 * features.add(f); } if(f.getFeatureDefinitionID() == 120073){
1353 
	 * features.add(f); } if(f.getFeatureDefinitionID() == 120063){
1354 
	 * f.setFeatureDefinitionID(120068); childFeatures11.add(f); }
1355 
	 * if(f.getFeatureDefinitionID() == 120064){
1356 
	 * f.setFeatureDefinitionID(120069); childFeatures21.add(f); } }
1357 
	 *
1358 
	 * newSlide.setFeatures(slide.getFeatures());
1359 
	 * newSlide.setFreeformContent(slide.getFreeformContent());
1360 
	 * newSlides.add(newSlide); break;
1361 
	 *
1362 
	 *
1363 
	 * //Mail n Msg case 130041: case 130063: newSlide = new Slide(130039);
1364 
	 * newSlide.setChildrenSlides(slide.getChildrenSlides());
1365 
	 * newSlide.setFeatures(slide.getFeatures());
1366 
	 * newSlide.setFreeformContent(slide.getFreeformContent());
1367 
	 * newSlides.add(newSlide); break; case 130039: newSlide = new
1368 
	 * Slide(130039); //newSlide.setChildrenSlides(slide.getChildrenSlides());
1369 
	 * childSlide = slide.getChildrenSlides().get(0);
1370 
	 * newSlide.setFeatures(childSlide.getFeatures());
1371 
	 * if(childSlide.getFreeformContent()!=null){
1372 
	 * System.out.println("Mail n Msg : HAS FFC : " +
1373 
	 * childSlide.getFreeformContent().getFreeformText() +
1374 
	 * childSlide.getFreeformContent().getMedias()); }
1375 
	 * newSlide.setFreeformContent(slide.getFreeformContent());
1376 
	 * newSlides.add(newSlide); break;
1377 
	 *
1378 
	 * //Software case 130020: case 130034: newSlide = new Slide(130034);
1379 
	 * newSlide.setChildrenSlides(slide.getChildrenSlides()); features =
1380 
	 * slide.getFeatures(); newSlide.setFeatures(slide.getFeatures());
1381 
	 * newSlide.setFreeformContent(slide.getFreeformContent());
1382 
	 * newSlides.add(newSlide); break;
1383 
	 *
1384 
	 *
1385 
	 * default: newSlides.add(slide); break; } } entity.setSlides(newSlides);
1386 
	 * CreationUtils.updateEntity(entity); } }
1387 
	 *
1388 
	 * return true; }
1389 
	 */
1390 
	public boolean migrateRemoveBorrowedCategoryIdFromSlide() throws Exception {
1226 rajveer 1391 
		Map<Long, Entity> entities = CreationUtils.getEntities();
4964 amit.gupta 1392 
		for (Entity entity : entities.values()) {
1393 
			if (entity.getID() == 0) {
1226 rajveer 1394 
				CreationUtils.deleteEntity(entity.getID());
1395 
			}
1396 
			List<Slide> slides = entity.getSlides();
4964 amit.gupta 1397 
			if (slides != null) {
1226 rajveer 1398 
				List<Slide> newSlides = new ArrayList<Slide>();
4964 amit.gupta 1399 
				for (Slide slide : slides) {
1226 rajveer 1400 
					Slide newSlide = new Slide(slide.getSlideDefinitionID());
1401 
					newSlide.setChildrenSlides(slide.getChildrenSlides());
1402 
					newSlide.setFeatures(slide.getFeatures());
1403 
					newSlide.setFreeformContent(slide.getFreeformContent());
1404 
					newSlides.add(newSlide);
1405 
				}
1406 
				entity.setSlides(newSlides);
1407 
				CreationUtils.updateEntity(entity);
1408 
			}
1409 
		}
1410 
		return true;
1411 
	}
479 rajveer 1412 
 
4964 amit.gupta 1413 
	public boolean migrate() throws Exception {
580 rajveer 1414 
		/*
4964 amit.gupta 1415 
		 * DefinitionsContainer sourceDefs = new
1416 
		 * DefinitionsContainer(sourceDbPath); DefinitionsContainer
1417 
		 * destinationDefs = new DefinitionsContainer(destinationDbPath);
1418 
		 * EntityContainer sourceEnts = new EntityContainer(sourceDbPath);
1419 
		 * EntityContainer destinationEnts = new
1420 
		 * EntityContainer(destinationDbPath);
1421 
		 *
1422 
		 * Map<Long, Entity> entities = sourceEnts.getEntities();
1423 
		 *
1424 
		 * File f = new File("/home/rajveer/Desktop/info.txt"); FileWriter
1425 
		 * fstream = new FileWriter(f); BufferedWriter out = new
1426 
		 * BufferedWriter(fstream); StringBuilder sb = new StringBuilder();
1427 
		 *
1428 
		 *
1429 
		 * for(Entity entity: entities.values()){ List<Slide> slides =
1430 
		 * entity.getSlides();
1431 
		 *
1432 
		 * //List<String> vidLabels =
1433 
		 * CreationUtils.getMediaLabels(entity.getID(),"youtube");
1434 
		 * //List<String> imgLabels =
1435 
		 * CreationUtils.getMediaLabels(entity.getID(),"image");
1436 
		 *
1437 
		 * //Map<String, Media> rawMedia =
1438 
		 * CreationUtils.getRawMedia(entity.getID());
1439 
		 *
1440 
		 *
1441 
		 * // List<String> vidLabels =
1442 
		 * OldCreationUtils.getMediaLabels(entity.getID(),"youtube"); //
1443 
		 * List<String> imgLabels =
1444 
		 * OldCreationUtils.getMediaLabels(entity.getID(),"image");
1445 
		 *
1446 
		 * Entity newEntity = new Entity(entity.getID(),
1447 
		 * entity.getCategoryID()); newEntity.setBrand(entity.getBrand());
1448 
		 * newEntity.setModelName(entity.getModelName());
1449 
		 * newEntity.setModelNumber(entity.getModelNumber());
1450 
		 *
1451 
		 *
1452 
		 * Map<String, in.shop2020.creation.util.Media> rawMedia =
1453 
		 * OldCreationUtils.getRawMedia(entity.getID());
1454 
		 *
1455 
		 * Map<String, Media> newrawMedia = new HashMap<String, Media>();
1456 
		 *
1457 
		 *
1458 
		 * int totalRawVideos = 0; int totalRawImages = 0;
1459 
		 *
1460 
		 * if(rawMedia!=null){ for(String label: rawMedia.keySet()){
1461 
		 * in.shop2020.creation.util.Media media = rawMedia.get(label);
1462 
		 *
1463 
		 * label = media.getLabel(); String type = media.getType(); String
1464 
		 * location = media.getLocation();
1465 
		 *
1466 
		 * Media newMedia = new Media(label, type, location);
1467 
		 *
1468 
		 * newMedia.setTitle("Title"); if(type.equals("image")){
1469 
		 * totalRawImages++; newMedia.setFileName(media.getFileName());
1470 
		 * newMedia.setVideoType(""); }else{ totalRawVideos++;
1471 
		 * newMedia.setVideoType("withoutskin"); newMedia.setFileName(""); }
1472 
		 *
1473 
		 * newrawMedia.put(label, newMedia); System.out.println("old " +
1474 
		 * media.toString()); // System.out.println("new " +
1475 
		 * newMedia.toString()); // OldCreationUtils.removeMedia(entity.getID(),
1476 
		 * label); // CreationUtils.addMedia(entity.getID(), newMedia); } }
1477 
		 *
1478 
		 * int totalVideos = 0; int totalImages = 0; if(rawMedia==null){
1479 
		 * for(Slide slide: slides ){
1480 
		 */
1481 
		/*
1482 
		 * FreeformContent ffc = slide.getFreeformContent(); List<String>
1483 
		 * vidList = new ArrayList<String>(); List<String> imgList = new
1484 
		 * ArrayList<String>();
1485 
		 *
1486 
		 * if(ffc!=null){ List<String> vidFfcLabels = ffc.getYoutubeRefs();
1487 
		 * if(vidFfcLabels!=null){ for(String vidFfcLabel: vidFfcLabels){
1488 
		 * StringTokenizer strTkn = new StringTokenizer(vidFfcLabel,"~!~");
1489 
		 * String vidLabel = null; if(strTkn.hasMoreTokens()){ vidLabel =
1490 
		 * strTkn.nextToken(); vidList.add(vidFfcLabel);
1491 
		 *
1492 
		 * // ffc.removeMedia("youtube", vidFfcLabel); //
1493 
		 * ffc.addMedia("youtube", vidLabel); } if(vidLabel == null){
1494 
		 * System.out.println("Something is really breaking .. bu ha ha !!!"); }
1495 
		 * totalVideos++; } } List<String> imgFfcLabels = ffc.getImageRefs();
1496 
		 * if(imgFfcLabels!=null){ for(String imgFfcLabel: imgFfcLabels){
1497 
		 * StringTokenizer strTkn = new StringTokenizer(imgFfcLabel,"~!~");
1498 
		 * String imgLabel = null; if(strTkn.hasMoreTokens()){ imgLabel =
1499 
		 * strTkn.nextToken(); imgList.add(imgFfcLabel);
1500 
		 *
1501 
		 * // ffc.removeMedia("image", imgFfcLabel); // ffc.addMedia("image",
1502 
		 * imgLabel); } if(imgLabel == null){
1503 
		 * System.out.println("Something is really breaking .. bu ha ha !!!"); }
1504 
		 * totalImages++; } }
1505 
		 *
1506 
		 * for(String vidlab : vidList){ ffc.removeMedia("youtube", vidlab);
1507 
		 * ffc.addMedia("youtube", (new StringTokenizer(vidlab,
1508 
		 * "~!~")).nextToken()); } for(String imglab : imgList){
1509 
		 * ffc.removeMedia("image",imglab); ffc.addMedia("image", (new
1510 
		 * StringTokenizer(imglab, "~!~")).nextToken()); }
1511 
		 * slide.setFreeformContent(ffc); System.out.println("Slide id is " +
1512 
		 * slide.getSlideDefinitionID() + "   vid labels:  " + vidFfcLabels +
1513 
		 * "   img labels" + imgFfcLabels); }
1514 
		 */
1515 
		/*
1516 
		 * newEntity.addSlide(slide); }
1517 
		 *
1518 
		 * // System.out.println("entity:"+ entity.getID() + ":trv:" +
1519 
		 * totalRawVideos + ":tri:" + totalRawImages +":tv:" + totalVideos
1520 
		 * +":ti:" + totalImages); // sb.append("entity:"+ entity.getID() +
1521 
		 * ":trv:" + totalRawVideos + ":tri:" + totalRawImages +":tv:" +
1522 
		 * totalVideos +":ti:" + totalImages+ ":tr:"
1523 
		 * +(totalRawVideos+totalRawImages) + ":t:" +(totalVideos+totalImages) +
1524 
		 * ":vd:" +(totalRawVideos-totalVideos) + ":id:"
1525 
		 * +(totalRawImages-totalImages) + "\n"); sb.append(entity.getID() +
1526 
		 * "\n");
1527 
		 *
1528 
		 *
1529 
		 * destinationEnts.updateEntity(newEntity);
1530 
		 * CreationUtils.storeEntity(newEntity);
1531 
		 *
1532 
		 * Map<Long, List<Entity>> entitiesByCategory =
1533 
		 * sourceEnts.getEntitiesbyCategory();
1534 
		 *
1535 
		 * Map<Long, Entity> xentities = destinationEnts.getEntities();
1536 
		 *
1537 
		 * CreationUtils.rewriteRepository(xentities, entitiesByCategory); }
1538 
		 * else{ sb.append("				" + entity.getID() + "\n"); } }
1539 
		 *
1540 
		 *
1541 
		 * out.write(sb.toString()); out.close();
1542 
		 */
457 rajveer 1543 
		return true;
1544 
	}
4964 amit.gupta 1545 
 
1546 
	private boolean makeEntitiesObject() throws Exception {
1547 
		// DefinitionsContainer sourceDefs = new
1548 
		// DefinitionsContainer(sourceDbPath);
1549 
		// DefinitionsContainer destinationDefs = new
1550 
		// DefinitionsContainer(destinationDbPath);
1551 
		// EntityContainer sourceEnts = new EntityContainer(sourceDbPath);
1552 
		// EntityContainer destinationEnts = new
1553 
		// EntityContainer(destinationDbPath);
1554 
 
1555 
		/*
1556 
		 * Map<Long, List<Entity>> catEntities =
1557 
		 * sourceEnts.getEntitiesbyCategory();
1558 
		 *
1559 
		 * Map<Long, Entity> entities = sourceEnts.getEntities(); for(Long
1560 
		 * catId: catEntities.keySet()){ List<Entity> ents =
1561 
		 * catEntities.get(catId); for(Entity entity: ents){
1562 
		 * entities.put(entity.getID(), entity);
1563 
		 * System.out.println(entity.getID() + ":" + entity.getCategoryID() +
1564 
		 * ":"+ entity.getBrand() + " "+ entity.getModelName() + " " +
1565 
		 * entity.getModelNumber()); } }
1566 
		 */
1567 
 
791 rajveer 1568 
		Map<Long, List<Entity>> catEntities = new TreeMap<Long, List<Entity>>();
1569 
		Map<Long, Entity> entities = new TreeMap<Long, Entity>();
2720 mandeep.dh 1570 
 
4964 amit.gupta 1571 
		FileInputStream fstream = new FileInputStream("/home/rajveer/Desktop/1");
1572 
		DataInputStream in = new DataInputStream(fstream);
1573 
		BufferedReader br = new BufferedReader(new InputStreamReader(in));
1574 
		String strLine;
2720 mandeep.dh 1575 
 
4964 amit.gupta 1576 
		while ((strLine = br.readLine()) != null) {
1577 
			long entityID = Long.parseLong(strLine);
1578 
			String entityDBFile = sourceDbPath + "entities" + File.separator
1579 
					+ entityID + "/entity.ser";
1580 
			System.out.println(entityDBFile);
1581 
			Entity entity = (Entity) DBUtils.read(entityDBFile);
1582 
			entities.put(entityID, entity);
2720 mandeep.dh 1583 
 
4964 amit.gupta 1584 
			List<Entity> catent = catEntities.get(entity.getCategoryID());
1585 
			if (catent == null) {
1586 
				catent = new ArrayList<Entity>();
1587 
			}
1588 
			catent.add(entity);
1589 
			catEntities.put(entity.getCategoryID(), catent);
1590 
		}
1591 
		in.close();
1592 
 
1593 
		String entitiesDBFile = sourceDbPath + "entities" + File.separator
1594 
				+ "entities.ser";
1595 
		String entitiesbycategoryDBFile = sourceDbPath + "entities"
1596 
				+ File.separator + "entitiesbycategory.ser";
1597 
 
791 rajveer 1598 
		DBUtils.delete(entitiesDBFile);
1599 
		DBUtils.store(entities, entitiesDBFile);
2720 mandeep.dh 1600 
 
4964 amit.gupta 1601 
		// Remove existing
791 rajveer 1602 
		DBUtils.delete(entitiesbycategoryDBFile);
1603 
		DBUtils.store(catEntities, entitiesbycategoryDBFile);
2720 mandeep.dh 1604 
 
4964 amit.gupta 1605 
		return false;
791 rajveer 1606 
	}
2720 mandeep.dh 1607 
 
4964 amit.gupta 1608 
	private boolean printDataModel() throws Exception {
1609 
		DefinitionsContainer dfc = Catalog.getInstance()
1610 
				.getDefinitionsContainer();
1226 rajveer 1611 
		StringBuilder sb = new StringBuilder();
2720 mandeep.dh 1612 
 
1226 rajveer 1613 
		Map<Long, SlideDefinition> allSlideDefs = dfc.getSlideDefinitions();
4964 amit.gupta 1614 
		for (Long slideDefId : allSlideDefs.keySet()) {
1226 rajveer 1615 
			SlideDefinition slideDef = allSlideDefs.get(slideDefId);
1616 
			sb.append(slideDefId + " - " + slideDef.getLabel() + "\n");
4964 amit.gupta 1617 
			if (!slideDef.getChildrenSlideDefinitionIDs().isEmpty()) {
1618 
				sb.append("Child Slides are: \t"
1619 
						+ slideDef.getChildrenSlideDefinitionIDs() + "\n");
1226 rajveer 1620 
			}
4964 amit.gupta 1621 
			List<SlideFeatureDefinition> featureDefs = slideDef
1622 
					.getSlideFeatureDefinitions();
1623 
			for (SlideFeatureDefinition featureDef : featureDefs) {
1624 
				sb.append("\t"
1625 
						+ featureDef.getFeatureDefintionID()
1626 
						+ "\t"
1627 
						+ dfc.getFeatureDefinition(
1628 
								featureDef.getFeatureDefintionID()).getLabel()
1629 
						+ "\t" + featureDef.getEditorialImportance() + "\n");
1226 rajveer 1630 
			}
1631 
		}
1632 
		System.out.println(sb.toString());
580 rajveer 1633 
		Map<Long, Category> categories = dfc.getCategories();
4964 amit.gupta 1634 
		if (categories != null) {
1226 rajveer 1635 
			return true;
1636 
		}
4964 amit.gupta 1637 
		for (Category category : categories.values()) {
1638 
			if (category.getChildrenCategory() != null) {
580 rajveer 1639 
				continue;
1640 
			}
1226 rajveer 1641 
			sb.append(category.getLabel() + "\n");
4964 amit.gupta 1642 
			List<CategorySlideDefinition> slideDefs = dfc
1643 
					.getCategorySlideDefinitions(category.getID());
1644 
			List<Long> slideSequence = dfc.getCategorySlideSequence(category
1645 
					.getID());
1646 
			for (CategorySlideDefinition slideDef : slideDefs) {
1647 
				sb.append("\t"
1648 
						+ dfc.getSlideDefinition(slideDef.getSlideDefintionID())
1649 
								.getLabel() + "\t"
1650 
						+ slideDef.getEditorialImportance() + "\n");
1651 
				// List<FeatureDefinition> featureDefs =
1652 
				// dfc.getFeatureDefinitions(slideDef.getSlideDefintionID());
1653 
 
1654 
				List<SlideFeatureDefinition> slideFeatureDefs = dfc
1655 
						.getSlideDefinition(slideDef.getSlideDefintionID())
1656 
						.getSlideFeatureDefinitions();
1657 
 
1658 
				for (SlideFeatureDefinition slideFeatureDef : slideFeatureDefs) {
1659 
					FeatureDefinition featureDef = dfc
1660 
							.getFeatureDefinition(slideFeatureDef
1661 
									.getFeatureDefintionID());
1662 
					BulletDefinition bulletDef = featureDef
1663 
							.getBulletDefinition();
1664 
					sb.append("\t\t\t" + featureDef.getLabel() + "\t"
1665 
							+ slideFeatureDef.getEditorialImportance() + "\t"
1666 
							+ featureDef.allowsBlank() + "\t"
1667 
							+ bulletDef.isLearned() + "\t"
1668 
							+ bulletDef.isMultivalue());
580 rajveer 1669 
					List<Long> units = bulletDef.getUnitIDs();
4964 amit.gupta 1670 
					if (bulletDef.getDatatypeDefinitionID() != null) {
1671 
						sb.append("\t"
1672 
								+ dfc.getDatatypeDefinition(
1673 
										bulletDef.getDatatypeDefinitionID())
1674 
										.getName());
1675 
 
1226 rajveer 1676 
					}
4964 amit.gupta 1677 
					if (units != null) {
1678 
						for (Long unit : units) {
1679 
							sb.append("\t" + dfc.getUnit(unit).getFullForm()
1680 
									+ "\t" + dfc.getUnit(unit).getShortForm());
580 rajveer 1681 
						}
1682 
					}
1226 rajveer 1683 
					sb.append("\n");
580 rajveer 1684 
				}
4964 amit.gupta 1685 
 
580 rajveer 1686 
				/*
4964 amit.gupta 1687 
				 * for(FeatureDefinition featureDef: featureDefs){
1688 
				 * BulletDefinition bulletDef =
1689 
				 * featureDef.getBulletDefinition(); System.out.println("			" +
1690 
				 * featureDef.getLabel() + " 	" + featureDef.allowsBlank() + "	"
1691 
				 * + bulletDef.isLearned() + "	" + bulletDef.isMultivalue());
1692 
				 * List<Long> units = bulletDef.getUnitIDs(); if(units!=null){
1693 
				 * for(Long unit: units){ System.out.println("								"+
1694 
				 * dfc.getUnit(unit).getFullForm() + "	"+
1695 
				 * dfc.getUnit(unit).getShortForm()); } }
1696 
				 * if(bulletDef.getDatatypeDefinitionID()!=null){
1697 
				 * System.out.println("										" +
1698 
				 * dfc.getDatatypeDefinition(bulletDef
1699 
				 * .getDatatypeDefinitionID()).getName());
1700 
				 *
1701 
				 * } }
1702 
				 */
580 rajveer 1703 
			}
1704 
		}
1226 rajveer 1705 
		System.out.println(sb.toString());
580 rajveer 1706 
		return true;
1707 
	}
4964 amit.gupta 1708 
 
1709 
	public boolean migrateOS() throws Exception {
4706 amit.gupta 1710 
		Map<Long, Entity> map = CreationUtils.getEntities();
4964 amit.gupta 1711 
		for (Long entityId : map.keySet()) {
1712 
			Entity entity = map.get(entityId);
1713 
			if (entity == null || entity.getSlides() == null) {
1714 
				continue;
1715 
			}
1716 
 
1717 
			for (Slide slide : entity.getSlides()) {
1718 
				if (slide.getSlideDefinitionID() == 130020) {
1719 
					List<Feature> features = slide.getFeatures();
1720 
					for (Feature f : features) {
1721 
						if (f.getFeatureDefinitionID() == 120043) {
1722 
							Bullet b = f.getBullets().get(0);
1723 
							String value = ((PrimitiveDataObject) b
1724 
									.getDataObject()).getValue();
1725 
							long enumValueID = getEnumValueForOS(value);
1726 
							if (enumValueID == 110371L) {
1727 
								Logger.log("Set entity:" + entityId
1728 
										+ " as proprietary software", entity);
1729 
							}
4706 amit.gupta 1730 
							b.setDataObject(new EnumDataObject(enumValueID));
4964 amit.gupta 1731 
						}
1732 
					}
1733 
				}
4706 amit.gupta 1734 
 
4964 amit.gupta 1735 
			}
1736 
 
1737 
			CreationUtils.updateEntity(entity);
1738 
		}
1739 
		return true;
4706 amit.gupta 1740 
	}
1741 
 
1742 
	private long getEnumValueForOS(String value) {
1743 
		value = value.toLowerCase();
1744 
		Map<String, Long> map = getOSEnumMap();
4964 amit.gupta 1745 
		String os = "Proprietary software";
1746 
		if (value.contains("android")) {
1747 
			if (value.contains("1.5")) {
1748 
				os = "Android v1.5 (Cupcake)";
1749 
			}
1750 
			if (value.contains("1.6")) {
1751 
				os = "Android v1.6 (Donut)";
1752 
			}
1753 
			if (value.contains("2.1")) {
1754 
				os = "Android v2.1 (Eclair)";
1755 
			}
1756 
			if (value.contains("2.2")) {
1757 
				os = "Android v2.2 (Froyo)";
1758 
			}
1759 
			if (value.contains("2.3")) {
1760 
				os = "Android v2.3 (Gingerbread)";
1761 
			}
1762 
			if (value.contains("3.0")) {
1763 
				os = "Android v3.0 (Honeycomb)";
1764 
			}
1765 
			if (value.contains("3.1")) {
1766 
				os = "Android v3.1 (Honeycomb)";
1767 
			}
1768 
			if (value.contains("3.2")) {
1769 
				os = "Android v3.2 (Honeycomb)";
1770 
			}
4706 amit.gupta 1771 
		}
4964 amit.gupta 1772 
		if (value.contains("blackberry")) {
1773 
			if (value.contains("os")) {
4706 amit.gupta 1774 
				os = "BlackBerry OS";
1775 
			}
4964 amit.gupta 1776 
			if (value.contains("5.0")) {
4706 amit.gupta 1777 
				os = "BlackBerry OS 5.0";
1778 
			}
4964 amit.gupta 1779 
			if (value.contains("6.0")) {
4706 amit.gupta 1780 
				os = "BlackBerry OS 6.0";
1781 
			}
4964 amit.gupta 1782 
			if (value.contains("7.0")) {
4706 amit.gupta 1783 
				os = "BlackBerry OS 7.0";
1784 
			}
4964 amit.gupta 1785 
			if (value.contains("tablet os")) {
4706 amit.gupta 1786 
				os = "BlackBerry Tablet OS";
1787 
			}
1788 
		}
4964 amit.gupta 1789 
		if (value.contains("brew mobile platform")) {
4706 amit.gupta 1790 
			os = "Brew Mobile Platform";
1791 
		}
4964 amit.gupta 1792 
		if (value.contains("maemo 5")) {
4706 amit.gupta 1793 
			os = "Maemo 5";
1794 
		}
4964 amit.gupta 1795 
		if (value.contains("windows phone 7")) {
4706 amit.gupta 1796 
			os = "Windows Phone 7";
1797 
		}
4964 amit.gupta 1798 
		if (value.contains("windows phone 7.5 mango")) {
4706 amit.gupta 1799 
			os = "Windows Phone 7.5 Mango";
1800 
		}
4964 amit.gupta 1801 
		if (value.contains("proprietary")) {
1802 
			if (value.contains("lg"))
4706 amit.gupta 1803 
				os = "Proprietary LG software";
4964 amit.gupta 1804 
			else if (value.contains("micromax")) {
4706 amit.gupta 1805 
				os = "Proprietary Micromax software";
4964 amit.gupta 1806 
			} else if (value.contains("samsung")) {
4706 amit.gupta 1807 
				os = "Proprietary Samsung software";
4964 amit.gupta 1808 
			} else if (value.contains("sony ericsson")) {
4706 amit.gupta 1809 
				os = "Proprietary Sony Ericsson software";
4964 amit.gupta 1810 
			} else if (value.contains("spice")) {
4706 amit.gupta 1811 
				os = "Proprietary Spice software";
4964 amit.gupta 1812 
			} else if (value.contains("lava")) {
4706 amit.gupta 1813 
				os = "Proprietary Lava software";
4964 amit.gupta 1814 
			} else if (value.contains("alcatel")) {
4706 amit.gupta 1815 
				os = "Proprietary Alcatel software";
4964 amit.gupta 1816 
			} else if (value.contains("motorola")) {
4706 amit.gupta 1817 
				os = "Proprietary Motorola software";
4964 amit.gupta 1818 
			} else if (value.contains("karbonn")) {
4706 amit.gupta 1819 
				os = "Proprietary Karbonn software";
4964 amit.gupta 1820 
			} else {
4706 amit.gupta 1821 
				os = "Proprietary software";
1822 
			}
1823 
		}
4964 amit.gupta 1824 
		if (value.contains("mmp")) {
4706 amit.gupta 1825 
			os = "Proprietary Samsung software";
1826 
		}
4964 amit.gupta 1827 
		if (value.contains("samsung")) {
1828 
			if (value.contains("bada")) {
1829 
				os = "Samsung bada";
1830 
			}
1831 
			if (value.contains("bada 1.2")) {
1832 
				os = "Samsung bada 1.2";
1833 
			}
4706 amit.gupta 1834 
		}
4964 amit.gupta 1835 
		if (value.contains("sony ericsson java platform 8")) {
4706 amit.gupta 1836 
			os = "Proprietary Sony Ericsson software";
1837 
		}
4964 amit.gupta 1838 
		if (value.contains("s60")) {
4706 amit.gupta 1839 
			os = "Symbian 60";
1840 
		}
4964 amit.gupta 1841 
		if (value.contains("symbian")) {
1842 
			if (value.contains("40")) {
4706 amit.gupta 1843 
				os = "Symbian 40";
1844 
			}
4964 amit.gupta 1845 
			if (value.contains("60")) {
4706 amit.gupta 1846 
				os = "Symbian 60";
1847 
			}
4964 amit.gupta 1848 
			if (value.contains("^3")) {
4706 amit.gupta 1849 
				os = "Symbian^3";
1850 
			}
4964 amit.gupta 1851 
			if (value.contains("anna")) {
4706 amit.gupta 1852 
				os = "Symbian Anna";
1853 
			}
4964 amit.gupta 1854 
			if (value.contains("belle")) {
4706 amit.gupta 1855 
				os = "Symbian Belle";
1856 
			}
1857 
		}
4964 amit.gupta 1858 
		if (value.contains("ios 4")) {
4706 amit.gupta 1859 
			os = "iOS 4";
1860 
		}
4964 amit.gupta 1861 
		if (value.contains("ios 5")) {
4706 amit.gupta 1862 
			os = "iOS 5";
1863 
		}
1864 
		return map.get(os);
1865 
	}
4964 amit.gupta 1866 
 
1867 
	private Map<String, Long> getOSEnumMap() {
4706 amit.gupta 1868 
		Map<String, Long> map = new HashMap<String, Long>();
1869 
		map.put("Android v1.5 (Cupcake)", 110335L);
1870 
		map.put("Android v1.6 (Donut)", 110336L);
1871 
		map.put("Android v2.1 (Eclair)", 110337L);
1872 
		map.put("Android v2.2 (Froyo)", 110338L);
1873 
		map.put("Android v2.3 (Gingerbread)", 110339L);
1874 
		map.put("Android v3.0 (Honeycomb)", 110340L);
1875 
		map.put("Android v3.1 (Honeycomb)", 110341L);
4964 amit.gupta 1876 
		map.put("Android v3.2 (Honeycomb)", 110342L);
4706 amit.gupta 1877 
		map.put("BlackBerry OS", 110343L);
1878 
		map.put("BlackBerry OS 5.0", 110344L);
1879 
		map.put("BlackBerry OS 6.0", 110345L);
1880 
		map.put("BlackBerry OS 7.0", 110346L);
1881 
		map.put("BlackBerry Tablet OS", 110347L);
1882 
		map.put("Brew Mobile Platform", 110348L);
1883 
		map.put("Maemo 5", 110349L);
1884 
		map.put("Windows Phone 7", 110350L);
1885 
		map.put("Windows Phone 7.5 Mango", 110351L);
1886 
		map.put("Proprietary LG software", 110352L);
1887 
		map.put("Proprietary Micromax software", 110353L);
1888 
		map.put("Proprietary Samsung software", 110354L);
1889 
		map.put("Proprietary Sony Ericsson software", 110355L);
1890 
		map.put("Proprietary Spice software", 110356L);
1891 
		map.put("Proprietary Lava software", 110367L);
1892 
		map.put("Proprietary Karbonn software", 110368L);
1893 
		map.put("Proprietary Motorola software", 110369L);
1894 
		map.put("Proprietary Alcatel software", 110370L);
4964 amit.gupta 1895 
		map.put("Proprietary software", 110371L);
4706 amit.gupta 1896 
		map.put("Samsung bada", 110357L);
1897 
		map.put("Samsung bada 1.2", 110358L);
1898 
		map.put("Symbian 40", 110360L);
1899 
		map.put("Symbian 60", 110361L);
1900 
		map.put("Symbian^3", 110362L);
1901 
		map.put("Symbian Anna", 110363L);
1902 
		map.put("Symbian Belle", 110364L);
1903 
		map.put("iOS 4", 110365L);
1904 
		map.put("iOS 5", 110366L);
4964 amit.gupta 1905 
 
4706 amit.gupta 1906 
		return map;
4964 amit.gupta 1907 
 
4706 amit.gupta 1908 
	}
5370 amit.gupta 1909 
 
1910 
	private Object clone(Object object) throws Exception{
1911 
		// Serializing and deserializing to clone the slide
1912 
		// serialize
1913 
		ByteArrayOutputStream bos = new ByteArrayOutputStream();
1914 
		ObjectOutputStream out = new ObjectOutputStream(bos);
1915 
		out.writeObject(object);
4964 amit.gupta 1916 
 
5370 amit.gupta 1917 
		// De-serialization
1918 
		ByteArrayInputStream bis = new ByteArrayInputStream(
1919 
				bos.toByteArray());
1920 
		ObjectInputStream in = new ObjectInputStream(bis);
1921 
		return in.readObject();
1922 
 
1923 
	}
1924 
 
1925 
	/**
1926 
	 *
1927 
	 * @throws Exception
1928 
	 */
1929 
	private void copyMedia(String newEntityId, String oldEntityId, Media media) throws Exception {
1930 
		String mediaDirPath = Utils.CONTENT_DB_PATH + "media" + File.separator + newEntityId;
1931 
		File mediaDir = new File(mediaDirPath);
1932 
		if(!mediaDir.exists()) {
1933 
			mediaDir.mkdir();
1934 
		}
1935 
 
1936 
		String mediaFilePath = mediaDirPath + File.separator + media.getFileName();
1937 
		String oldMediaFilePath = media.getLocation();
1938 
 
1939 
		File mediaFile = new File(mediaFilePath);
1940 
		mediaFile.createNewFile();
1941 
 
1942 
		File oldMediaFile = new File(oldMediaFilePath);
1943 
 
1944 
		InputStream in = new FileInputStream(oldMediaFile);
1945 
 
1946 
		// appending output stream
1947 
		// @rajveer : replacing the existing file
1948 
		OutputStream out = new FileOutputStream(mediaFile);
1949 
 
1950 
		try {
1951 
			IOUtils.copy(in, out);
1952 
		}
1953 
		finally {
1954 
			IOUtils.closeQuietly(in);
1955 
			IOUtils.closeQuietly(out);
1956 
		}
1957 
		media.setLocation(mediaFilePath);
1958 
	}
5396 amit.gupta 1959 
 
1960 
	private void migrateHeadSetBack() throws Exception {
1961 
		Map<Long, Long>migratorMap = new HashMap<Long, Long>();
1962 
		migratorMap.put(77777000L,1000291L);
1963 
		migratorMap.put(77777001L,1000292L);
1964 
		migratorMap.put(77777002L,1000293L);
1965 
		migratorMap.put(77777003L,1000294L);
1966 
		migratorMap.put(77777004L,1000295L);
1967 
		migratorMap.put(77777005L,1000296L);
1968 
		migratorMap.put(77777006L,1000297L);
1969 
		migratorMap.put(77777007L,1000298L);
1970 
		migratorMap.put(77777008L,1000299L);
1971 
		migratorMap.put(77777009L,1000300L);
1972 
		migratorMap.put(77777010L,1000301L);
1973 
		migratorMap.put(77777011L,1000302L);
1974 
		migratorMap.put(77777012L,1000303L);
1975 
		migratorMap.put(77777013L,1000304L);
1976 
		migratorMap.put(77777014L,1000305L);
1977 
		migratorMap.put(77777015L,1000306L);
1978 
		migratorMap.put(77777016L,1000351L);
1979 
		migratorMap.put(77777017L,1000352L);
1980 
		migratorMap.put(77777018L,1000353L);
1981 
		migratorMap.put(77777019L,1000363L);
1982 
		migratorMap.put(77777020L,1000364L);
1983 
		migratorMap.put(77777021L,1000365L);
1984 
		migratorMap.put(77777022L,1000425L);
1985 
		migratorMap.put(77777023L,1000426L);
1986 
		migratorMap.put(77777024L,1000430L);
1987 
		migratorMap.put(77777025L,1000434L);
1988 
		migratorMap.put(77777026L,1000435L);
1989 
		migratorMap.put(77777027L,1000436L);
1990 
		migratorMap.put(77777028L,1000437L);
1991 
		migratorMap.put(77777029L,1000438L);
1992 
		migratorMap.put(77777030L,1000439L);
1993 
		migratorMap.put(77777031L,1000440L);
1994 
		migratorMap.put(77777032L,1000441L);
1995 
		migratorMap.put(77777033L,1000442L);
1996 
		migratorMap.put(77777034L,1000443L);
1997 
		migratorMap.put(77777035L,1000444L);
1998 
		migratorMap.put(77777036L,1000445L);
1999 
		migratorMap.put(77777037L,1000446L);
2000 
		migratorMap.put(77777038L,1000447L);
2001 
		migratorMap.put(77777039L,1000449L);
2002 
		migratorMap.put(77777040L,1000450L);
2003 
		migratorMap.put(77777041L,1000451L);
2004 
		migratorMap.put(77777042L,1000452L);
2005 
		migratorMap.put(77777043L,1000453L);
2006 
		migratorMap.put(77777044L,1000454L);
2007 
		migratorMap.put(77777045L,1000455L);
2008 
		migratorMap.put(77777046L,1000518L);
2009 
		migratorMap.put(77777047L,1000521L);
2010 
		migratorMap.put(77777048L,1000572L);
2011 
		migratorMap.put(77777049L,1000575L);
2012 
		migratorMap.put(77777050L,1000623L);
2013 
		migratorMap.put(77777051L,1000625L);
2014 
		migratorMap.put(77777052L,1000626L);
2015 
		migratorMap.put(77777053L,1000627L);
2016 
		migratorMap.put(77777054L,1000628L);
2017 
		migratorMap.put(77777055L,1000874L);
2018 
		migratorMap.put(77777056L,1001200L);
2019 
		migratorMap.put(77777057L,1001375L);
2020 
		migratorMap.put(77777058L,1001376L);
2021 
		migratorMap.put(77777059L,1001378L);
2022 
		migratorMap.put(77777060L,1001382L);
2023 
		migratorMap.put(77777061L,1001808L);
2024 
		migratorMap.put(77777062L,1001809L);
2025 
		migratorMap.put(77777063L,1001810L);
2026 
		migratorMap.put(77777064L,1001811L);
2027 
		migratorMap.put(77777065L,1001812L);
2028 
		migratorMap.put(77777066L,1001814L);
2029 
		migratorMap.put(77777067L,1001815L);
2030 
		migratorMap.put(77777068L,1001816L);
2031 
		migratorMap.put(77777069L,1001817L);
2032 
		migratorMap.put(77777070L,1001818L);
2033 
		migratorMap.put(77777071L,1001819L);
2034 
		migratorMap.put(77777072L,1001820L);
2035 
		migratorMap.put(77777073L,1001821L);
2036 
		migratorMap.put(77777074L,1001822L);
2037 
		migratorMap.put(77777075L,1001823L);
2038 
		migratorMap.put(77777076L,1001824L);
2039 
		migratorMap.put(77777077L,1001825L);
2040 
		migratorMap.put(77777078L,1002318L);
2041 
		migratorMap.put(77777079L,1002320L);
2042 
		migratorMap.put(77777080L,1003852L);
2043 
		migratorMap.put(77777081L,1003853L);
2044 
		migratorMap.put(77777082L,1003854L);
2045 
		migratorMap.put(77777083L,1003855L);
2046 
		migratorMap.put(77777084L,1003856L);
2047 
		migratorMap.put(77777085L,1003857L);
2048 
		migratorMap.put(77777086L,1003916L);
2049 
		migratorMap.put(77777087L,1003917L);
2050 
		migratorMap.put(77777088L,1003918L);
2051 
		migratorMap.put(77777089L,1003919L);
2052 
		migratorMap.put(77777090L,1003920L);
2053 
		migratorMap.put(77777091L,1003921L);
2054 
		migratorMap.put(77777092L,1003922L);
2055 
		migratorMap.put(77777093L,1003923L);
2056 
		migratorMap.put(77777094L,1003924L);
2057 
		migratorMap.put(77777095L,1003925L);
2058 
		migratorMap.put(77777096L,1003926L);
2059 
		migratorMap.put(77777097L,1003927L);
2060 
		migratorMap.put(77777098L,1004087L);
2061 
		migratorMap.put(77777099L,1004088L);
2062 
		migratorMap.put(77777100L,1004089L);
2063 
		migratorMap.put(77777101L,1004134L);
2064 
		migratorMap.put(77777102L,1004135L);
2065 
		migratorMap.put(77777103L,1004139L);
2066 
 
2067 
		for(Map.Entry<Long, Long> entry : migratorMap.entrySet()) {
2068 
			Long newId  = entry.getKey();
2069 
			Long validId  = entry.getValue();
2070 
			Entity entity  = CreationUtils.getEntity(newId);
2071 
			EntityState es = CreationUtils.getEntityState(newId);
2072 
			Slide sl = entity.getSlide(130130);
5397 amit.gupta 2073 
			/*entity.setID(validId);
2074 
			es.setID(validId);*/
5396 amit.gupta 2075 
 
7129 amit.gupta 2076 
 
5370 amit.gupta 2077 
 
5396 amit.gupta 2078 
			CreationUtils.updateEntity(entity);
2079 
			CreationUtils.updateEntityState(es);
2080 
			CreationUtils.deleteEntity(newId);
2081 
			System.out.println(validId + " : " + es.getCategoryID() + ", removed entity id:" + newId);
2082 
 
2083 
		}
2084 
 
2085 
	}
7129 amit.gupta 2086 
 
2087 
	private void migrateTabletsBack() throws Exception {
7131 amit.gupta 2088 
		//This entity is created after migration have to be deleted. Vrinda have to rmk it
2089 
		CreationUtils.deleteEntity(1006812);
7129 amit.gupta 2090 
		Date now = new Date();
2091 
		Collection<Entity> entities = CreationUtils.getEntities(20010);
2092 
		//entities = (List<Entity>)this.clone(entities);
2093 
		for (Entity entity : entities) {
2094 
			long entityId = entity.getID();
2095 
			if(entityId>9999999){
2096 
				long oldEntityId = entityId%10000000;
2097 
				System.out.println(oldEntityId);
2098 
				EntityState es = CreationUtils.getEntityState(entityId);
2099 
				if(es != null) {
2100 
					if (es.getStatus().equals(EntityStatus.READY) || es.getStatus().equals(EntityStatus.COMPLETE)){
2101 
						es.setStatus(EntityStatus.READY);
2102 
						es.setMerkedReadyOn(now);
2103 
					}
2104 
					es.setID(oldEntityId);
2105 
					entity.setID(oldEntityId);
2106 
					entity.setCategoryID(10010);
2107 
					es.setCategoryID(10010);
2108 
					CreationUtils.updateEntity(entity);
2109 
					CreationUtils.updateEntityState(es);
2110 
					CreationUtils.deleteEntity(entityId);
2111 
					System.out.println(entityId + " moved back");
2112 
 
2113 
				} else {
2114 
					CreationUtils.deleteEntity(entityId);
2115 
					System.out.println("Deleted " + entityId + " due to incomplete tablets");
2116 
				}
2117 
			}else {
2118 
				entity.setCategoryID(10010);
2119 
				EntityState es = CreationUtils.getEntityState(entityId);
2120 
				es.setCategoryID(10010);
2121 
				CreationUtils.updateEntity(entity);
2122 
				CreationUtils.updateEntityState(es);
2123 
			}
2124 
 
2125 
 
2126 
		}
2127 
 
2128 
	}
5760 amit.gupta 2129 
 
2130 
    public String getTitle(Entity entity){
2131 
    	String brand = entity.getBrand();
2132 
    	String modelName = entity.getModelName();
2133 
    	String modelNumber = entity.getModelNumber();
2134 
    	String titleString = "";
2135 
    	if(StringUtils.isEmpty(modelName)){
2136 
    		titleString = brand + " " + modelNumber + " Price in India | Specifications, Features and Reviews";
2137 
    	}else {
2138 
    		titleString = brand + " " + modelName + " Price in India | " + modelNumber + " Specifications, Features and Reviews";
2139 
    	}
2140 
    	return titleString;
2141 
    }
2142 
 
2143 
    public String getMetaDescription(ExpandedEntity expEntity){
2144 
    	Category parentCategory= expEntity.getCategory().getParentCategory();
2145 
    	String categoryName = parentCategory.getLabel();
2146 
    	if (parentCategory.getID()== Utils.MOBILE_ACCESSORIES_CATEGORY){
2147 
    		categoryName = expEntity.getCategory().getLabel();
2148 
    	}
2149 
    	String template = "Buy {0} {1} {2} at $minPriceItem.getSellingPrice(). All {3} are 100% Original and carry full Manufacturers Warranty since we procure directly from the Brand. Free Next Day Delivery.";
2150 
    	return MessageFormat.format(template, expEntity.getBrand(), expEntity.getModelName(), expEntity.getModelNumber(), categoryName.toLowerCase());
2151 
    }
7037 amit.gupta 2152 
 
2153 
public void migrateTablets() throws Exception {
2154 
 
2155 
		//Starting entity id for new Category with 10000
2156 
		Collection<Entity> entities = CreationUtils.getEntities(10010);
2157 
		long newCounter;
2158 
		//entities = (List<Entity>)this.clone(entities);
2159 
		for (Entity entity : entities) {
2160 
			long entityId = entity.getID();
2161 
			newCounter = Long.parseLong("1" + String.valueOf(entityId));
2162 
			Entity newEntity = new Entity(newCounter, 20010);
2163 
			try {
2164 
				List<Slide> entitySlides = entity.getSlides();
2165 
				if (entity == null || entitySlides == null) {
2166 
					continue;
2167 
				}
2168 
				List<Slide> newEntitySlides = new ArrayList<Slide>();
2169 
				/*Slide introSlide = entity.getSlide(130001);
2170 
				Slide summarySlide = entity.getSlide(130054);
2171 
				Slide packageContents = entity.getSlide(130025);*/
2172 
				for (Slide slide : entitySlides) {
2173 
					if (Arrays.asList(130054L, 130025L, 130001L).contains(slide.getSlideDefinitionID())) {
2174 
						slide=(Slide)this.clone(slide);
2175 
						newEntitySlides.add(slide);
2176 
					}
2177 
					FreeformContent ffc1 = slide.getFreeformContent();
2178 
					if(ffc1 != null){
2179 
						Map<String, Media> mediaMap = ffc1.getMedias();
2180 
						if(mediaMap==null){
2181 
							continue;
2182 
						}
2183 
						for(Media media : mediaMap.values()){
2184 
							if(media.getType().equals(Type.IMAGE) || media.getType().equals(Type.DOCUMENT)){
2185 
								copyMedia(String.valueOf(newCounter), String.valueOf(entityId),media);
2186 
							}
2187 
						}
2188 
					}
2189 
				}
2190 
 
2191 
				List<Long> newSlideSequence = new ArrayList<Long>();
2192 
				newSlideSequence.add(130001L);
2193 
				newSlideSequence.add(130054L);
2194 
				newSlideSequence.add(130172L);
2195 
				newSlideSequence.add(130173L);
2196 
				newSlideSequence.add(130174L);
2197 
				newSlideSequence.add(130175L);
2198 
				newSlideSequence.add(130176L);
2199 
				newSlideSequence.add(130177L);
2200 
				newSlideSequence.add(130178L);
2201 
				newSlideSequence.add(130180L);
2202 
				newSlideSequence.add(130183L);
2203 
				newSlideSequence.add(130025L);
2204 
 
2205 
				newEntity.setSlideSequence(newSlideSequence);
2206 
				newEntity.setBrand(entity.getBrand());
2207 
				newEntity.setModelName(entity.getModelName());
2208 
				newEntity.setModelNumber(entity.getModelNumber());
2209 
				//entitySlides.remove(featureSlide);
2210 
				newEntity.setSlides(newEntitySlides);
2211 
				EntityState es = new EntityState(newCounter, 20010, "admin");
2212 
				es.setBrand(entity.getBrand());
2213 
				es.setModelName(entity.getModelName());
2214 
				es.setModelNumber(entity.getModelNumber());
2215 
				CreationUtils.createEntity(newEntity, es);
2216 
				System.out.println("New entity : " + newCounter + " created using : " + entityId);
2217 
				System.out.println(CreationUtils.getEntity(newCounter));
2218 
				newCounter++;
2219 
			}catch(Exception e){
2220 
				System.out.println("Could not migrate " + entityId);
2221 
			}
2222 
		}
2223 
 
2224 
	}
5396 amit.gupta 2225 
 
7111 amit.gupta 2226 
public void migrateImagesInTablets() throws Exception {
2227 
 
2228 
	//Starting entity id for new Category with 10000
2229 
	Collection<Entity> entities = CreationUtils.getEntities(10010);
2230 
	long newCounter;
2231 
	//entities = (List<Entity>)this.clone(entities);
2232 
	for (Entity entity : entities) {
2233 
		long entityId = entity.getID();
2234 
		newCounter = Long.parseLong("1" + String.valueOf(entityId));
2235 
		Entity newEntity = CreationUtils.getEntity(newCounter);
2236 
		try {
2237 
			if (newEntity == null) {
2238 
				continue;
2239 
			}
2240 
			Slide introSlide = newEntity.getSlide(130001L);
2241 
			Slide looknfeelSlide = entity.getSlide(130002L);
2242 
			/*
2243 
			 * Slide introSlide = entity.getSlide(130001); Slide
2244 
			 * summarySlide = entity.getSlide(130054); Slide packageContents
2245 
			 * = entity.getSlide(130025);
2246 
			 */
7037 amit.gupta 2247 
 
7111 amit.gupta 2248 
			if (looknfeelSlide != null) {
2249 
				FreeformContent ffc1 = looknfeelSlide.getFreeformContent();
2250 
				if (ffc1 != null) {
2251 
					Map<String, Media> mediaMap = ffc1.getMedias();
2252 
					if (mediaMap == null) {
2253 
						continue;
2254 
					}
2255 
					FreeformContent introFfc = introSlide
2256 
							.getFreeformContent();
7123 amit.gupta 2257 
					Map<String, Media> introMediaMap = new LinkedHashMap<String, Media>();
2258 
					introFfc.setMedias(introMediaMap);
7111 amit.gupta 2259 
					Set<String> introMediaMapKeys = introMediaMap.keySet();
7123 amit.gupta 2260 
					for (Map.Entry<String, Media> entry : mediaMap.entrySet()) {
7111 amit.gupta 2261 
						Media entryValue = entry.getValue();
2262 
						String entryKey = entry.getKey();
2263 
						if (!introMediaMapKeys.contains(entryKey)) {
2264 
							introMediaMap.put(entryKey,
2265 
									(Media) clone(entryValue));
2266 
							if (entryValue.getType().equals(Type.IMAGE)
2267 
									|| entryValue.equals(Type.DOCUMENT)) {
2268 
								try {
2269 
									copyMedia(String.valueOf(newCounter),
2270 
											String.valueOf(entityId),
2271 
											entryValue);
2272 
								} catch (Exception e) {
2273 
									System.out
2274 
											.println("could not copy file "
2275 
													+ entityId);
2276 
								}
2277 
							}
2278 
						}
2279 
					}
2280 
				}
2281 
			}
2282 
 
2283 
			CreationUtils.updateEntity(newEntity);
2284 
			System.out.println("New entity : " + newCounter
2285 
					+ " created using : " + entityId);
2286 
		} catch (Exception e) {
2287 
			e.printStackTrace();
2288 
			System.out.println("Could not migrate " + entityId);
2289 
		}
2290 
	}
2291 
 
7917 amit.gupta 2292 
 
457 rajveer 2293 
}
7917 amit.gupta 2294 
private void miscilleniousPopulate() throws Exception{
2295 
 
2296 
	DefinitionsContainer defContainer = Catalog.getInstance().getDefinitionsContainer();
2297 
 
2298 
	//Get All Enum Values of Communication facilities 70114;
2299 
	Map <Long, Entity> allEntities = CreationUtils.getEntities();
2300 
	/*Map <Long, Entity> allEntities =new HashMap<Long, Entity>();
2301 
	allEntities.put(1000069l, CreationUtils.getEntity(1000069l));*/
2302 
	for (Map.Entry<Long, Entity> entry:allEntities.entrySet()){
2303 
		Entity entity = entry.getValue();
2304 
		Long categoryId = entity.getCategoryID();
2305 
		EntityState es = CreationUtils.getEntityState(entity.getID());
2306 
		if ((categoryId == 10002 || categoryId == 10003 || categoryId == 10004 || categoryId == 10005)
2307 
				&& (es != null && es.getStatus().equals(EntityStatus.READY))) {
2308 
			ExpandedEntity expEntity = new ExpandedEntity(entity);
2309 
			Slide miscSlide = expEntity.getSlide(130024l);
7932 amit.gupta 2310 
			if(miscSlide != null) {
2311 
				List<Feature> miscFeatures = miscSlide.getFeatures();
2312 
				if(CollectionUtils.isNotEmpty(miscFeatures)){
7933 amit.gupta 2313 
					Iterator<Feature> iter = miscFeatures.iterator();
2314 
					while(iter.hasNext()) {
2315 
						Feature f =iter.next();
2316 
						if (f.getFeatureDefinitionID() == 120484l || f.getFeatureDefinitionID() == 120483l || f.getFeatureDefinitionID() == 1204821 || f.getFeatureDefinitionID() == 120481l){
7932 amit.gupta 2317 
							List<Bullet> bulletList  = f.getBullets();
2318 
							PrimitiveDataObject b = (PrimitiveDataObject)bulletList.get(0).getDataObject();
2319 
							String bulletValue = b.getValue();
2320 
							String newString = bulletValue;
7933 amit.gupta 2321 
							if(bulletValue.startsWith(", ") || bulletValue.contains(",,") || bulletValue.contains("<li>")){
7932 amit.gupta 2322 
								System.out.println(entity.getID());
2323 
								bulletList = new ArrayList<Bullet>();
7933 amit.gupta 2324 
								newString = bulletValue.replaceAll("<li>|</li>|<ul>|</ul>", ",").replaceAll(",,", ",").replaceAll(", ,", ", ").replaceAll(", $", "");
2325 
 
2326 
								System.out.println(newString);
7932 amit.gupta 2327 
								if(newString.startsWith(", ") ){
2328 
									newString = newString.replaceFirst(", ", "");
7917 amit.gupta 2329 
								}
7932 amit.gupta 2330 
								bulletList.add(new Bullet(new PrimitiveDataObject(newString)));
2331 
								f.setBullets(bulletList);
2332 
								System.out.println(newString);
7917 amit.gupta 2333 
							}
7932 amit.gupta 2334 
							if ( newString.equals(" ") || newString.equals("") || newString.equals("  ") || newString.equals("   ")){
7933 amit.gupta 2335 
								iter.remove();
7917 amit.gupta 2336 
							}
2337 
						}
7932 amit.gupta 2338 
					}
7933 amit.gupta 2339 
					CreationUtils.updateEntity(entity);
2340 
					touchEntityState(entity.getID());
7917 amit.gupta 2341 
				}
2342 
			}
7932 amit.gupta 2343 
			//touchEntityState(entity.getID());
2344 
			}
7917 amit.gupta 2345 
		}
2346 
	}
7973 amit.gupta 2347 
 
2348 
	private void step2() throws Exception {
2349 
		//Get All Enum Values of Communication facilities 70114;
7975 amit.gupta 2350 
		//Map <Long, Entity> allEntities = CreationUtils.getEntities();
2351 
		Map <Long, Entity> allEntities =new HashMap<Long, Entity>();
2352 
		allEntities.put(1007937l, CreationUtils.getEntity(1007937l));
2353 
		allEntities.put(1007932l, CreationUtils.getEntity(1007932l));
2354 
		allEntities.put(1007930l, CreationUtils.getEntity(1007930l));
2355 
		allEntities.put(1007934l, CreationUtils.getEntity(1007934l));
2356 
		allEntities.put(1007936l, CreationUtils.getEntity(1007936l));
2357 
		allEntities.put(1007935l, CreationUtils.getEntity(1007935l));
7973 amit.gupta 2358 
		for (Map.Entry<Long, Entity> entry:allEntities.entrySet()){
2359 
			Entity entity = entry.getValue();
2360 
			Long categoryId = entity.getCategoryID();
2361 
			EntityState es = CreationUtils.getEntityState(entity.getID());
7975 amit.gupta 2362 
			if ((categoryId == 10002 || categoryId == 10003 || categoryId == 10004 || categoryId == 10005) && es != null ) {
7973 amit.gupta 2363 
				List<Slide> allSlides = entity.getSlides();
2364 
				Slide slMaps = entity.getSlide(130022l);
2365 
				Slide slConnectivity = (categoryId == 10005 ? entity.getSlide(130058l) : entity.getSlide(130007l));
2366 
				if(slConnectivity != null){
2367 
					if(slConnectivity.getSlideDefinitionID() ==130058l){
2368 
						Slide newSlide = new Slide(130007l);
2369 
						newSlide.setFeatures(slConnectivity.getFeatures());
2370 
						allSlides.remove(slConnectivity);
2371 
						allSlides.add(newSlide);
2372 
						slConnectivity = newSlide;
2373 
 
2374 
						List<Long> slideSequence = entity.getSlideSequence();
2375 
						int index =slideSequence.indexOf(130058l);
2376 
						slideSequence.remove(index);;
2377 
						slideSequence.add(index, 130007l);
2378 
					}
2379 
					if(slMaps != null) {
2380 
						List<Feature> mapsFeatures = slMaps.getFeatures();
2381 
						allSlides.remove(slMaps);
2382 
						if(mapsFeatures != null){
2383 
							for (Feature mapsFeature : mapsFeatures){
2384 
								if(mapsFeature.getFeatureDefinitionID() == 120046l){
2385 
									slConnectivity.getFeatures().add(mapsFeature);
2386 
									break;
2387 
								}
2388 
							}
2389 
 
2390 
						}
2391 
					}
2392 
 
2393 
				}
2394 
 
2395 
				Slide slKeyBoard = entity.getSlide(130026l);
2396 
				Slide slDisplay = entity.getSlide(130003l);
2397 
				Slide slSummary = entity.getSlide(130054l);
2398 
				Slide slLookNFeel = entity.getSlide(130002l);
2399 
				Feature hardkeysFeature = null;
2400 
				if (slKeyBoard != null) {
2401 
					List<Feature> keyBoardFeatures = slKeyBoard.getFeatures();
2402 
					Iterator<Feature> iter = keyBoardFeatures.iterator();
2403 
					while(iter.hasNext()){
2404 
						Feature feature = iter.next();
2405 
						if(feature.getFeatureDefinitionID() == 120010l){
7975 amit.gupta 2406 
							if(slSummary!=null){
7984 amit.gupta 2407 
							slSummary.getFeatures().add(feature);
7975 amit.gupta 2408 
							}
7973 amit.gupta 2409 
							iter.remove();
2410 
						}
2411 
						if(feature.getFeatureDefinitionID() == 120082l){
2412 
							slDisplay.getFeatures().add(feature);
2413 
							iter.remove();
2414 
						}
2415 
						if(feature.getFeatureDefinitionID() == 120009l){
2416 
							slLookNFeel.getFeatures().add(feature);
2417 
							iter.remove();
2418 
						}
2419 
						if(feature.getFeatureDefinitionID() == 120048l ){
2420 
							if(hardkeysFeature == null) {
2421 
								hardkeysFeature = feature;
2422 
							}else {
2423 
								if(feature.getBullets() != null){
2424 
									hardkeysFeature.getBullets().addAll(feature.getBullets());
2425 
									slLookNFeel.getFeatures().add(hardkeysFeature);
2426 
								}
2427 
							}
2428 
							iter.remove();
2429 
						}
2430 
						if(feature.getFeatureDefinitionID() == 120049l ){
2431 
							if(hardkeysFeature == null){
2432 
								hardkeysFeature = new Feature(120048l);
2433 
								hardkeysFeature.setBullets(feature.getBullets());
2434 
							} else {
2435 
								if(feature.getBullets() != null){
2436 
									hardkeysFeature.getBullets().addAll(feature.getBullets());
2437 
									slLookNFeel.getFeatures().add(hardkeysFeature);
2438 
								}
2439 
							}
2440 
							iter.remove();
2441 
						}
2442 
					}
2443 
 
2444 
					allSlides.remove(slKeyBoard);
2445 
				}
2446 
				CreationUtils.updateEntity(entity);
7975 amit.gupta 2447 
				//touchEntityState(entity.getID());
7973 amit.gupta 2448 
			}
2449 
		}
2450 
 
2451 
	}
7984 amit.gupta 2452 
 
2453 
	private void step4() throws Exception {
2454 
		//Get All Enum Values of Communication facilities 70114;
2455 
		Map <Long, Entity> allEntities = CreationUtils.getEntities();
2456 
		/*Map <Long, Entity> allEntities = new HashMap<Long, Entity>();
2457 
		allEntities.put(1002529l, CreationUtils.getEntity(1002529l));
2458 
		allEntities.put(1007932l, CreationUtils.getEntity(1007932l));
2459 
		allEntities.put(1007930l, CreationUtils.getEntity(1007930l));
2460 
		allEntities.put(1007934l, CreationUtils.getEntity(1007934l));
2461 
		allEntities.put(1007936l, CreationUtils.getEntity(1007936l));
2462 
		allEntities.put(1007935l, CreationUtils.getEntity(1007935l));*/
2463 
		for (Map.Entry<Long, Entity> entry:allEntities.entrySet()){
2464 
			Entity entity = entry.getValue();
2465 
			Long categoryId = entity.getCategoryID();
2466 
			EntityState es = CreationUtils.getEntityState(entity.getID());
2467 
			if ((categoryId == 10002 || categoryId == 10003 || categoryId == 10004 || categoryId == 10005) && es != null && !es.getStatus().equals(EntityStatus.UNASSIGNED)) {
2468 
				List<Slide> allSlides = entity.getSlides();
2469 
				if(allSlides != null){
2470 
					for(Slide slide:allSlides) {
2471 
						if(slide!=null){
2472 
							List <Feature> features = slide.getFeatures();
2473 
							Iterator<Feature> fIterator = features.iterator();
2474 
							while (fIterator.hasNext()){
2475 
								Feature f = fIterator.next();
2476 
								long fId = f.getFeatureDefinitionID();
2477 
								if(fId == 120011 || fId == 120020 || fId == 120051 || fId == 120025 || fId == 120056 || fId == 120216 || fId == 120045 || fId == 120010){
2478 
									fIterator.remove();
2479 
								}
2480 
								if(fId==120144){
2481 
									String  value = "Adobe flash player";
2482 
									List<Bullet> flashb = f.getBullets();
2483 
									if(flashb !=null && flashb.size() > 0){
2484 
										value = ((PrimitiveDataObject)flashb.get(0).getDataObject()).getValue();
2485 
									}
2486 
									Slide miscSlide1 = entity.getSlide(130024l);
2487 
									if(miscSlide1 != null){
2488 
										List <Feature> mfeatures = miscSlide1.getFeatures();
2489 
										Iterator<Feature> mIterator = mfeatures.iterator();
2490 
										while (mIterator.hasNext()){
2491 
											Feature mf = mIterator.next();
2492 
											if(mf != null){
2493 
												if(mf.getFeatureDefinitionID() == 120484l){
2494 
													Bullet b = mf.getBullets().get(0);
2495 
													String finalValue = ((PrimitiveDataObject)b.getDataObject()).getValue() + ", " + value;
2496 
													b.setDataObject(new PrimitiveDataObject(finalValue));
2497 
												}
2498 
											}
2499 
										}
2500 
									} else {
2501 
										System.out.println("no misc for entity : " + entity.getID());
2502 
									}
2503 
									fIterator.remove();
2504 
								}
2505 
							}
2506 
						}
2507 
					}
2508 
					try{
2509 
						CreationUtils.updateEntity(entity);
2510 
					}catch (Exception e){
2511 
						System.out.println("Could not update entity : " + entity.getID());
2512 
					}
2513 
					touchEntityState(entity.getID());
2514 
				}
2515 
			}
2516 
		}
2517 
	}
7997 amit.gupta 2518 
	private void step6() throws Exception {
2519 
		//Get All Enum Values of Communication facilities 70114;
8014 amit.gupta 2520 
		DefinitionsContainer defc = Catalog.getInstance().getDefinitionsContainer();
2521 
		Map <Long, Long> allEntities = getValues();
2522 
		for (Map.Entry<Long, Long> entry:allEntities.entrySet()){
2523 
			Long entityId = entry.getKey();
2524 
			Entity entity = CreationUtils.getEntity(entityId);
7997 amit.gupta 2525 
			Long categoryId = entity.getCategoryID();
8014 amit.gupta 2526 
			boolean found = false;
7997 amit.gupta 2527 
			//System.out.println("entity : " + entity.getID());
2528 
			EntityState es = CreationUtils.getEntityState(entity.getID());
2529 
			if(!es.getStatus().equals(EntityStatus.UNASSIGNED)) {
2530 
				if ((categoryId == 10002 || categoryId == 10003 || categoryId == 10004 || categoryId == 10005)
2531 
						&& es != null) {
8009 amit.gupta 2532 
 
7997 amit.gupta 2533 
					Slide videoSlide = entity.getSlide(130031l);
2534 
					if(videoSlide != null){
8014 amit.gupta 2535 
						List<Feature> features = videoSlide.getFeatures();
2536 
						if(features != null) {
2537 
							Iterator<Feature> iter = features.iterator();
2538 
							while(iter.hasNext()){
2539 
								Feature f = iter.next();
2540 
								if(f.getFeatureDefinitionID() == 120475l){
2541 
									found = true;
2542 
									if(!entry.getValue().equals(((EnumDataObject)f.getBullets().get(0).getDataObject()).getEnumValueID())){
2543 
										f.getBullets().get(0).setDataObject(new EnumDataObject(entry.getValue()));
2544 
										try{
2545 
											System.out.println("Recording feature updated:" + entityId);
2546 
											CreationUtils.updateEntity(entity);
2547 
											touchEntityState(entityId);
2548 
										}catch (Exception e){
2549 
											System.out.println("Could not update entity : " + entity.getID());
2550 
										}
2551 
									}
2552 
									break;
2553 
								}
8009 amit.gupta 2554 
							}
8014 amit.gupta 2555 
 
2556 
							if(!found){
2557 
								Feature f = new Feature(120475l);
2558 
								f.setBullets(Arrays.asList(new Bullet(new EnumDataObject(entry.getValue()))));
2559 
								features.add(f);
2560 
								try{
2561 
									System.out.println("Recording feature created:" + entityId);
2562 
									CreationUtils.updateEntity(entity);
2563 
									touchEntityState(entityId);
2564 
								}catch (Exception e){
2565 
									System.out.println("Could not update entity : " + entity.getID());
2566 
								}
2567 
							}
7997 amit.gupta 2568 
						}
2569 
					}
2570 
				}
2571 
 
2572 
			}
2573 
		}
2574 
	}
8014 amit.gupta 2575 
 
2576 
	private Map<Long,Long> getValues() {
2577 
		try {
2578 
			Reader reader = new FileReader("/root/sample.json");
2579 
			return new Gson().fromJson(reader, new TypeToken<Map<Long,Long>>() {}.getType());
2580 
		} catch (FileNotFoundException e) {
2581 
			e.printStackTrace();
2582 
			return new HashMap<Long, Long>();
2583 
		}
2584 
	}
8077 amit.gupta 2585 
 
2586 
	private void reorderPhones() throws Exception {
2587 
		DefinitionsContainer defc = Catalog.getInstance().getDefinitionsContainer();
2588 
		List<Long> slideSequence = defc.getCategorySlideSequence().get(10003l);
2589 
		Map <Long, Entity> allEntities = CreationUtils.getEntities();
2590 
		for (Map.Entry<Long, Entity> entry:allEntities.entrySet()){
2591 
			Long entityId = entry.getKey();
2592 
			Entity entity = entry.getValue();
2593 
			Long categoryId = entity.getCategoryID();
2594 
			//System.out.println("entity : " + entity.getID());
2595 
			EntityState es = CreationUtils.getEntityState(entity.getID());
2596 
			if(!es.getStatus().equals(EntityStatus.UNASSIGNED)) {
2597 
				if ((categoryId == 10002 || categoryId == 10003 || categoryId == 10004 || categoryId == 10005)
2598 
						&& es != null) {
2599 
					entity.setSlideSequence(slideSequence);
2600 
					CreationUtils.updateEntity(entity);
2601 
					touchEntityState(entityId);
2602 
				}
2603 
			}
2604 
		}
2605 
	}
8798 amit.gupta 2606 
 
8869 amit.gupta 2607 
	private void getTablets() throws Exception {
2608 
		StringBuffer sb = new StringBuffer();
2609 
		DefinitionsContainer defs = Catalog.getInstance().getDefinitionsContainer();
2610 
		Map<Long,FeatureDefinition> allFeatureDefs  = defs.getFeatureDefinitions();
2611 
		List<Long> tabletFds = defs.getFeatureDefinitionIDs(10010l);
2612 
 
2613 
		Collection<Entity> es = CreationUtils.getEntities(10010l);
2614 
		String header[] = new String[tabletFds.size()];
2615 
		int index = 0;
2616 
		for(Long fd : tabletFds) {
2617 
			header[index++] = allFeatureDefs.get(fd).getLabel();
2618 
		}
2619 
		sb.append(StringUtils.join(header, "\t")).append("\n");
2620 
		for (Entity entity:es){
2621 
			String as[] = new String[tabletFds.size()];
2622 
			Map<Long, String> m = AmazonSCDataGenerator.extractFeatureValuesForEntity(entity);
2623 
			for(Map.Entry<Long, String> entry : m.entrySet()) {
2624 
				if(tabletFds.indexOf(entry.getKey())==-1){
2625 
					continue;
2626 
				}
2627 
				as[tabletFds.indexOf(entry.getKey())] = entry.getValue();
2628 
			}
8873 amit.gupta 2629 
			sb.append(entity.getID() + "\t").append(StringUtils.join(as, "\t")).append("\n");
8869 amit.gupta 2630 
		}
2631 
		System.out.println(sb);
2632 
	}
2633 
 
8909 amit.gupta 2634 
	private void migrateSoftCategories() throws Exception{
2635 
		Long ANDROID = 110614l;
2636 
		Long WINDOWS = 110615l;
2637 
		Long DUALSIM = 110616l;
2638 
		Long TRISIM = 110617l;
2639 
		Long CDMA = 110618l;
2640 
		Long BASIC = 110619l;
2641 
		Long TOUCH = 110620l;
2642 
		Long PHABLET = 110621l;
2643 
		Long IOS = 110622l;
2644 
		Set<Long> softSet = new HashSet<Long>();
2645 
		DefinitionsContainer defc = Catalog.getInstance().getDefinitionsContainer();
2646 
		Collection<Entity> entities = CreationUtils.getEntities(10006l);
2647 
		for(Entity entity : entities){
2648 
			EntityState es = CreationUtils.getEntityState(entity.getID());
2649 
			if (es.getStatus().equals(EntityStatus.READY)) {
2650 
				softSet.clear();
2651 
				System.out.println("Entity ID : " + es.getID());
2652 
				List <Slide> slides = entity.getSlides();
2653 
				if(slides != null) {
2654 
					for(Slide slide : slides){
2655 
						if(slide.getSlideDefinitionID() == 130020l)  {
2656 
							List<Feature> fs = slide.getFeatures();
2657 
							if (fs!=null){
2658 
								for (Feature f1 : fs){
2659 
									if(f1.getFeatureDefinitionID()==120043l){
2660 
										List <Bullet> bullets = f1.getBullets();
2661 
										if(bullets != null) {
2662 
											for(Bullet b : bullets){
2663 
												String bulletString = defc.getEnumValue(((EnumDataObject)b.getDataObject()).getEnumValueID()).getValue();
2664 
												if (bulletString.contains("Android")){
2665 
													softSet.add(ANDROID);
2666 
													System.out.println("Added android");
2667 
													break;
2668 
												}
2669 
												else if (bulletString.contains("Windows")){
2670 
													softSet.add(WINDOWS);
2671 
													System.out.println("Added Windows");
2672 
													break;
2673 
												}
2674 
												else if (bulletString.contains("iOS")){
2675 
													softSet.add(IOS);
2676 
													System.out.println("Added Apple");
2677 
													break;
2678 
												}
2679 
											}
2680 
										}
2681 
									}
2682 
								}
2683 
							}
2684 
						}
2685 
 
2686 
						if(slide.getSlideDefinitionID() == 130005l)  {
2687 
							List<Feature> fs = slide.getFeatures();
2688 
							if (fs!=null){
2689 
								for (Feature f1 : fs){
2690 
									if(f1.getFeatureDefinitionID()==120127l){
2691 
										List <Bullet> bullets = f1.getBullets();
2692 
										if(bullets != null) {
2693 
											for(Bullet b : bullets){
2694 
												String bulletString = defc.getEnumValue(((EnumDataObject)b.getDataObject()).getEnumValueID()).getValue();
2695 
												if (bulletString.equals("Dual-SIM")){
2696 
													softSet.add(DUALSIM);
2697 
													System.out.println("Added Dual-SIM");
2698 
													break;
2699 
												}
2700 
												else if (bulletString.equals("Tri-SIM")){
2701 
													softSet.add(TRISIM);
2702 
													System.out.println("Added Tri-SIM");
2703 
													break;
2704 
												}
2705 
											}
2706 
										}
2707 
									}
2708 
									else if(f1.getFeatureDefinitionID()==120012l){
2709 
										List <Bullet> bullets = f1.getBullets();
2710 
										if(bullets != null) {
2711 
											for(Bullet b : bullets){
2712 
												String bulletString = "";
2713 
												try{
2714 
													bulletString = defc.getEnumValue(((EnumDataObject)b.getDataObject()).getEnumValueID()).getValue();
2715 
												}catch (Exception e){
2716 
													//b.
2717 
												}
2718 
												if (bulletString.contains("CDMA")){
9051 amit.gupta 2719 
													if(bulletString.contains("WCDMA")){
2720 
														touchEntityState(entity.getID());
2721 
													} else {
2722 
														softSet.add(CDMA);
2723 
														System.out.println("Added CDMA for 2G");
2724 
														break;
2725 
													}
8909 amit.gupta 2726 
												}
2727 
											}
2728 
										}
2729 
									}
2730 
									else if(f1.getFeatureDefinitionID()==120013l){
2731 
										List <Bullet> bullets = f1.getBullets();
2732 
										if(bullets != null) {
2733 
											for(Bullet b : bullets){
2734 
												String bulletString = ((PrimitiveDataObject)b.getDataObject()).getValue();
2735 
												if (bulletString.contains("CDMA")){
9051 amit.gupta 2736 
													if(bulletString.contains("WCDMA")){
2737 
														touchEntityState(entity.getID());
2738 
													} else {
2739 
														softSet.add(CDMA);
2740 
														System.out.println("Added CDMA for 3G");
2741 
														break;
2742 
													}
8909 amit.gupta 2743 
												}
2744 
											}
2745 
										}
2746 
									}
2747 
								}
2748 
							}
2749 
						}
2750 
 
2751 
						if(slide.getSlideDefinitionID() == 130002l)  {
2752 
							List<Feature> fs = slide.getFeatures();
2753 
							if (fs!=null){
2754 
								for (Feature f1 : fs){
2755 
									if(f1.getFeatureDefinitionID()==120009l){
2756 
										List <Bullet> bullets = f1.getBullets();
2757 
										if(bullets != null) {
2758 
											for(Bullet b : bullets){
2759 
												String bulletString = defc.getEnumValue(((EnumDataObject)b.getDataObject()).getEnumValueID()).getValue();
2760 
												if(bulletString.equals("T9 keyboard")){
2761 
													softSet.add(BASIC);
2762 
													System.out.println("Added Basic phone");
2763 
													break;
2764 
												}
2765 
											}
2766 
										}
2767 
									}
2768 
								}
2769 
							}
2770 
						}
2771 
 
2772 
						if(slide.getSlideDefinitionID() == 130003l)  {
2773 
							List<Feature> fs = slide.getFeatures();
2774 
							if (fs!=null){
2775 
								for (Feature f1 : fs){
2776 
									if(f1.getFeatureDefinitionID()==120005l){
2777 
										List <Bullet> bullets = f1.getBullets();
2778 
										if(bullets != null) {
2779 
											for(Bullet b : bullets){
2780 
												String bulletString = ((PrimitiveDataObject)b.getDataObject()).getValue();
2781 
												float f = Float.valueOf(bulletString);
2782 
												if(f >= 5f ){
2783 
													softSet.add(PHABLET);
2784 
													System.out.println("Added Basic phone");
2785 
													break;
2786 
												}
2787 
											}
2788 
										}
2789 
									}
2790 
									else if(f1.getFeatureDefinitionID() == 120082l){
2791 
										softSet.add(TOUCH);
2792 
										System.out.println("Added Touch phone");
2793 
									}
2794 
								}
2795 
							}
2796 
						}
2797 
					}
2798 
				}
2799 
				if(softSet.size()>0){
2800 
					Slide summarySlide = entity.getSlide(130054l);
2801 
					Feature f = new Feature(120513l);
2802 
					List<Feature> features = summarySlide.getFeatures();
2803 
					List<Bullet> softBullets = new ArrayList<Bullet>();
9051 amit.gupta 2804 
					for(Feature f1 : features){
2805 
						if(f.getFeatureDefinitionID()==120513l){
2806 
							features.remove(f1);
2807 
							break;
2808 
						}
2809 
					}
8909 amit.gupta 2810 
					features.add(f);
2811 
					for(Long enumId : softSet){
2812 
						softBullets.add(new Bullet(new EnumDataObject(enumId)));
2813 
					}
2814 
					f.setBullets(softBullets);
2815 
					CreationUtils.updateEntity(entity);
2816 
				}
2817 
			}
2818 
		}
2819 
	}
2820 
 
2821 
	private void clearEmptyPrimitiveBullets() throws Exception{
2822 
		Map<Long, Entity> es = CreationUtils.getEntities();
2823 
		for( Map.Entry<Long, Entity> entry : es.entrySet()){
2824 
			Entity e = entry.getValue();
2825 
			List<Slide> slides = e.getSlides();
2826 
			if(slides != null){
2827 
				for (Slide slide : slides){
2828 
					List<Feature> features = slide.getFeatures();
2829 
					if (features != null){
2830 
						for(Feature feature : features){
2831 
							List<Bullet> bullets = feature.getBullets();
2832 
							if(bullets != null){
2833 
								Iterator<Bullet> bIterator = bullets.iterator();
2834 
								while (bIterator.hasNext()){
2835 
									BulletDataObject b = bIterator.next().getDataObject();
2836 
									if(b.getClass().equals(PrimitiveDataObject.class)){
2837 
										PrimitiveDataObject pdo = (PrimitiveDataObject)b;
2838 
										if(pdo.getValue().equals("")){
2839 
											bIterator.remove();
2840 
											System.out.println("Removed empty Primitive from slide :" + slide.getSlideDefinitionID() + " and entity: " + e.getID());
2841 
										}
2842 
									}
2843 
								}
2844 
							}
2845 
						}
2846 
					}
2847 
				}
2848 
				CreationUtils.updateEntity(e);
2849 
			}
2850 
		}
2851 
	}
2852 
 
8913 amit.gupta 2853 
	private void updateSummaryMediaLabel() throws Exception{
2854 
		Map<Long, Entity> es = CreationUtils.getEntities();
2855 
		for( Map.Entry<Long, Entity> entry : es.entrySet()){
2856 
			Entity e = entry.getValue();
2857 
			Slide summarySlide = e.getSlide(130054l);
2858 
			if(summarySlide!=null){
2859 
			FreeformContent ffc = summarySlide.getFreeformContent();
2860 
				if (ffc !=null){
2861 
					Map<String, Media> mediaMap = ffc.getMedias();
2862 
					if(mediaMap != null){
2863 
						for(Map.Entry<String, Media> mediaEntry : mediaMap.entrySet()) {
2864 
							if(mediaEntry.getValue().getLabel().equals("default") && !mediaEntry.getKey().equals("default")){
2865 
								mediaMap.put("default", mediaMap.remove(mediaEntry.getKey()));
2866 
								CreationUtils.updateEntity(e);
2867 
								System.out.println("Upated summary media for:" + e.getID());
9171 amit.gupta 2868 
								break;
8913 amit.gupta 2869 
							}
2870 
						}
2871 
					}
2872 
				}
2873 
			}
2874 
		}
2875 
	}
9171 amit.gupta 2876 
 
2877 
	private void updateCommunication() throws Exception{
2878 
		Map<Long,Entity> es = CreationUtils.getEntities();
2879 
		for( Map.Entry<Long, Entity> entry: es.entrySet()){
2880 
			Entity e = entry.getValue();
2881 
			//Slide commSlide = e.getSlide(130005l);
2882 
			List<Slide> slides = e.getSlides();
2883 
			if(slides != null){
2884 
				for(Slide slide : slides){
2885 
					List<Feature> features = slide.getFeatures();
2886 
					if (features  != null){
2887 
						slide.setFeatures(new ArrayList<Feature>(new LinkedHashSet<Feature>(features)));
2888 
						if(slide.getFeatures().size() != features.size()){
2889 
							System.out.println(e.getCategoryID() + ":" + e.getID() + ":" + slide.getFeatures() + "," + features);
2890 
							CreationUtils.updateEntity(e);
2891 
						}
2892 
					}
2893 
				}
2894 
			}
2895 
		}
2896 
	}
8913 amit.gupta 2897 
 
9900 amit.gupta 2898 
	private void migrateReviews() throws Exception{
2899 
		Map<Long, List<ExpertReview>> a =  CreationUtils.getExpertReviews();
2900 
		for(Map.Entry<Long, List<ExpertReview>> entry : a.entrySet()) {
2901 
			List<ExpertReview> ers = entry.getValue();
2902 
			Iterator<ExpertReview> ersIterator = ers.iterator();
2903 
			while (ersIterator.hasNext()){
2904 
				ExpertReview er = ersIterator.next();
2905 
				String review = er.getReviewContent();
2906 
				String review1 = review.replaceAll("<[^>]+>", "");
2907 
				if(review.equals("")){
2908 
					ersIterator.remove();
2909 
				} else if(!review.equals(review1)) {
2910 
					er.setReviewContent(review1);
2911 
				}
2912 
			}
2913 
			CreationUtils.storeExpertReview(entry.getKey(), ers);
2914 
		}
2915 
	}
2916 
 
10692 amit.gupta 2917 
    private List<ExpertReview> getExpertReviews(long catalogId) throws Exception {
2918 
		List<ExpertReview> expertReviews = CreationUtils.getExpertReviewByEntity(catalogId);
2919 
		if(expertReviews != null) {
2920 
			Iterator<ExpertReview> iter = expertReviews.iterator();
2921 
			while (iter.hasNext()){
2922 
				ExpertReview er = iter.next();
2923 
				if(!er.getStatus().equals(ExpertReviewStatus.PUBLISHED)){
2924 
					iter.remove();
2925 
				}
2926 
			}
2927 
			if(expertReviews.size()==0){
2928 
				expertReviews = null;
2929 
			}
2930 
 
2931 
		}
2932 
		return expertReviews;
2933 
	}
2934 
 
7111 amit.gupta 2935 
}
2936