Subversion Repositories SmartDukaan

Rev

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

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