// ============================================================================
//
// Copyright (C) 2006-2016 Talend Inc. - www.talend.com
//
// This source code is available under agreement available at
// %InstallDIR%\features\org.talend.rcp.branding.%PRODUCTNAME%\%PRODUCTNAME%license.txt
//
// You should have received a copy of the agreement
// along with this program; if not, write to Talend SA
// 9 rue Pages 92150 Suresnes, France
//
// ============================================================================
package org.talend.dataprofiler.core.ui.editor.analysis;
import org.eclipse.jface.viewers.Viewer;
import org.eclipse.jface.viewers.ViewerSorter;
import org.talend.dataprofiler.core.model.OverviewIndUIElement;
import org.talend.dataquality.indicators.schema.CatalogIndicator;
/**
* DOC xqliu class global comment. Detailled comment
*/
public class CatalogWithSchemaSorter extends ViewerSorter {
public static final int CATALOG = 1;
public static final int ROWS = 2;
public static final int SCHEMAS = 3;
public static final int ROWS_SCHEMAS = 4;
public static final int TABLES = 5;
public static final int ROWS_TABLES = 6;
public static final int VIEWS = 7;
public static final int ROWS_VIEWS = 8;
public static final int KEYS = 9;
public static final int INDEXES = 10;
private int sortType;
public CatalogWithSchemaSorter(int sortType) {
this.sortType = sortType;
}
public int compare(Viewer viewer, Object o1, Object o2) {
CatalogIndicator indicator1 = (CatalogIndicator) ((OverviewIndUIElement) o1).getOverviewIndicator();
CatalogIndicator indicator2 = (CatalogIndicator) ((OverviewIndUIElement) o2).getOverviewIndicator();
String value1;
String value2;
long number1;
long number2;
switch (sortType) {
case CATALOG:
value1 = indicator1.getAnalyzedElement().getName();
value2 = indicator2.getAnalyzedElement().getName();
return value1.compareTo(value2);
case -CATALOG:
value1 = indicator1.getAnalyzedElement().getName();
value2 = indicator2.getAnalyzedElement().getName();
return value2.compareTo(value1);
case ROWS:
number1 = indicator1.getTableRowCount();
number2 = indicator2.getTableRowCount();
return new Long(number1).compareTo(new Long(number2));
case -ROWS:
number1 = indicator1.getTableRowCount();
number2 = indicator2.getTableRowCount();
return new Long(number2).compareTo(new Long(number1));
case SCHEMAS:
number1 = indicator1.getSchemaCount();
number2 = indicator2.getSchemaCount();
return new Long(number1).compareTo(new Long(number2));
case -SCHEMAS:
number1 = indicator1.getSchemaCount();
number2 = indicator2.getSchemaCount();
return new Long(number2).compareTo(new Long(number1));
case ROWS_SCHEMAS:
number1 = indicator1.getSchemaCount() == 0 ? 0 : indicator1.getTableRowCount() / indicator1.getSchemaCount();
number2 = indicator2.getSchemaCount() == 0 ? 0 : indicator2.getTableRowCount() / indicator2.getSchemaCount();
return new Long(number1).compareTo(new Long(number2));
case -ROWS_SCHEMAS:
number1 = indicator1.getSchemaCount() == 0 ? 0 : indicator1.getTableRowCount() / indicator1.getSchemaCount();
number2 = indicator2.getSchemaCount() == 0 ? 0 : indicator2.getTableRowCount() / indicator2.getSchemaCount();
return new Long(number2).compareTo(new Long(number1));
case TABLES:
number1 = indicator1.getTableCount();
number2 = indicator2.getTableCount();
return new Long(number1).compareTo(new Long(number2));
case -TABLES:
number1 = indicator1.getTableCount();
number2 = indicator2.getTableCount();
return new Long(number2).compareTo(new Long(number1));
case ROWS_TABLES:
number1 = indicator1.getTableCount() == 0 ? 0 : indicator1.getTableRowCount() / indicator1.getTableCount();
number2 = indicator2.getTableCount() == 0 ? 0 : indicator2.getTableRowCount() / indicator2.getTableCount();
return new Long(number1).compareTo(new Long(number2));
case -ROWS_TABLES:
number1 = indicator1.getTableCount() == 0 ? 0 : indicator1.getTableRowCount() / indicator1.getTableCount();
number2 = indicator2.getTableCount() == 0 ? 0 : indicator2.getTableRowCount() / indicator2.getTableCount();
return new Long(number2).compareTo(new Long(number1));
case VIEWS:
number1 = indicator1.getViewCount();
number2 = indicator2.getViewCount();
return new Long(number1).compareTo(new Long(number2));
case -VIEWS:
number1 = indicator1.getViewCount();
number2 = indicator2.getViewCount();
return new Long(number2).compareTo(new Long(number1));
case ROWS_VIEWS:
number1 = indicator1.getViewCount() == 0 ? 0 : indicator1.getTableRowCount() / indicator1.getViewCount();
number2 = indicator2.getViewCount() == 0 ? 0 : indicator2.getTableRowCount() / indicator2.getViewCount();
return new Long(number1).compareTo(new Long(number2));
case -ROWS_VIEWS:
number1 = indicator1.getViewCount() == 0 ? 0 : indicator1.getTableRowCount() / indicator1.getViewCount();
number2 = indicator2.getViewCount() == 0 ? 0 : indicator2.getTableRowCount() / indicator2.getViewCount();
return new Long(number2).compareTo(new Long(number1));
case KEYS:
number1 = indicator1.getKeyCount();
number2 = indicator2.getKeyCount();
return new Long(number1).compareTo(new Long(number2));
case -KEYS:
number1 = indicator1.getKeyCount();
number2 = indicator2.getKeyCount();
return new Long(number2).compareTo(new Long(number1));
case INDEXES:
number1 = indicator1.getIndexCount();
number2 = indicator2.getIndexCount();
return new Long(number1).compareTo(new Long(number2));
case -INDEXES:
number1 = indicator1.getIndexCount();
number2 = indicator2.getIndexCount();
return new Long(number2).compareTo(new Long(number1));
default:
return 0;
}
}
}