Subversion Repositories SmartDukaan

Rev

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