Subversion Repositories SmartDukaan

Rev

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