Subversion Repositories SmartDukaan

Rev

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