Subversion Repositories SmartDukaan

Rev

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