use of org.pentaho.metadata.model.SqlDataSource in project pentaho-platform by pentaho.
the class MetadataQueryComponentIT method getJdbcDomain.
public Domain getJdbcDomain() {
Domain domain = getBasicDomain();
SqlDataSource dataSource = ((SqlPhysicalModel) domain.getPhysicalModels().get(0)).getDatasource();
dataSource.setType(DataSourceType.NATIVE);
dataSource.setDatabaseName("file:src/test/resources/solution/system/data/sampledata");
dataSource.setUsername("pentaho_user");
dataSource.setPort("-1");
dataSource.setPassword("password");
domain.setId("JDBCDOMAIN");
return domain;
}
use of org.pentaho.metadata.model.SqlDataSource in project data-access by pentaho.
the class DataAccessServiceTestBase method getDomain.
/**
* Provide a mock domain
*
* @return
*/
private Domain getDomain() {
LogicalColumn logicalColumn1;
LogicalColumn logicalColumn2;
String locale = LocaleHelper.getLocale().toString();
SqlPhysicalModel model = new SqlPhysicalModel();
SqlDataSource dataSource = new SqlDataSource();
dataSource.setDatabaseName("SampleData");
model.setDatasource(dataSource);
SqlPhysicalTable table = new SqlPhysicalTable(model);
model.getPhysicalTables().add(table);
table.setTargetTableType(TargetTableType.INLINE_SQL);
table.setTargetTable("select * from customers");
table.setId("customers");
SqlPhysicalColumn column = new SqlPhysicalColumn(table);
column.setTargetColumn("customername");
column.setName(new LocalizedString(locale, "Customer Name"));
column.setDescription(new LocalizedString(locale, "Customer Name Desc"));
column.setDataType(DataType.STRING);
column.setId("cutomer_customername");
table.getPhysicalColumns().add(column);
LogicalModel logicalModel = new LogicalModel();
model.setId("MODEL");
model.setName(new LocalizedString(locale, "My Model"));
model.setDescription(new LocalizedString(locale, "A Description of the Model"));
LogicalTable logicalTable = new LogicalTable();
logicalTable.setId("BT_CUSTOMERS");
logicalTable.setPhysicalTable(table);
logicalModel.getLogicalTables().add(logicalTable);
logicalModel.setName(new LocalizedString(locale, "My Model"));
logicalColumn1 = new LogicalColumn();
logicalColumn1.setId("LC_CUSTOMERNAME");
logicalColumn1.setPhysicalColumn(column);
logicalColumn1.setAggregationType(AggregationType.COUNT);
logicalColumn1.setLogicalTable(logicalTable);
logicalColumn1.setDataType(DataType.STRING);
logicalColumn2 = new LogicalColumn();
logicalColumn2.setId("LC_CUSTOMERNUMBER");
logicalColumn2.setAggregationType(AggregationType.COUNT);
logicalColumn2.setPhysicalColumn(column);
logicalColumn2.setLogicalTable(logicalTable);
logicalColumn2.setDataType(DataType.NUMERIC);
logicalTable.addLogicalColumn(logicalColumn1);
logicalTable.addLogicalColumn(logicalColumn2);
Domain thisDomain = new Domain();
thisDomain.addPhysicalModel(model);
thisDomain.addLogicalModel(logicalModel);
return thisDomain;
}
use of org.pentaho.metadata.model.SqlDataSource in project pentaho-kettle by pentaho.
the class MetadataGenerator method createSqlDataSource.
private SqlDataSource createSqlDataSource(DatabaseMeta databaseMeta) {
SqlDataSource dataSource = new SqlDataSource();
dataSource.setDatabaseName(databaseMeta.getDatabaseName());
dataSource.setHostname(databaseMeta.getHostname());
dataSource.setUsername(databaseMeta.getUsername());
dataSource.setPassword(databaseMeta.getPassword());
dataSource.setPort(databaseMeta.getDatabasePortNumberString());
dataSource.setAttributes(databaseMeta.getExtraOptions());
DataSourceType dataSourceType;
switch(databaseMeta.getAccessType()) {
case DatabaseMeta.TYPE_ACCESS_NATIVE:
dataSourceType = DataSourceType.NATIVE;
break;
case DatabaseMeta.TYPE_ACCESS_ODBC:
dataSourceType = DataSourceType.ODBC;
break;
case DatabaseMeta.TYPE_ACCESS_JNDI:
dataSourceType = DataSourceType.JNDI;
break;
case DatabaseMeta.TYPE_ACCESS_OCI:
dataSourceType = DataSourceType.OCI;
break;
default:
dataSourceType = DataSourceType.CUSTOM;
break;
}
dataSource.setType(dataSourceType);
return dataSource;
}
use of org.pentaho.metadata.model.SqlDataSource in project pentaho-platform by pentaho.
the class MetadataQueryComponentIT method getBasicDomain.
public Domain getBasicDomain() {
SqlPhysicalModel model = new SqlPhysicalModel();
SqlDataSource dataSource = new SqlDataSource();
dataSource.setDatabaseName("SampleData");
dataSource.setDialectType("HYPERSONIC");
dataSource.setType(DataSourceType.JNDI);
model.setDatasource(dataSource);
SqlPhysicalTable table = new SqlPhysicalTable(model);
table.setId("PT1");
model.getPhysicalTables().add(table);
table.setTargetTableType(TargetTableType.INLINE_SQL);
table.setTargetTable("select distinct customername, salesrepemployeenumber from customers");
SqlPhysicalColumn column = new SqlPhysicalColumn(table);
column.setId("PC1");
column.setTargetColumn("CUSTOMERNAME");
column.setName(new LocalizedString("en_US", "Customer Name"));
column.setDescription(new LocalizedString("en_US", "Customer Name Desc"));
column.setDataType(DataType.STRING);
table.getPhysicalColumns().add(column);
SqlPhysicalColumn column2 = new SqlPhysicalColumn(table);
column2.setId("PC2");
column2.setTargetColumn("SALESREPEMPLOYEENUMBER");
column2.setName(new LocalizedString("en_US", "Sales Rep"));
column2.setDescription(new LocalizedString("en_US", "Sales Rep Employee Number"));
column2.setDataType(DataType.NUMERIC);
table.getPhysicalColumns().add(column2);
LogicalModel logicalModel = new LogicalModel();
logicalModel.setPhysicalModel(model);
logicalModel.setId("MODEL");
logicalModel.setName(new LocalizedString("en_US", "My Model"));
logicalModel.setDescription(new LocalizedString("en_US", "A Description of the Model"));
LogicalTable logicalTable = new LogicalTable();
logicalTable.setId("LT");
logicalTable.setPhysicalTable(table);
logicalModel.getLogicalTables().add(logicalTable);
LogicalColumn logicalColumn = new LogicalColumn();
logicalColumn.setId("LC_CUSTOMERNAME");
logicalColumn.setPhysicalColumn(column);
logicalColumn.setLogicalTable(logicalTable);
logicalTable.addLogicalColumn(logicalColumn);
LogicalColumn logicalColumn2 = new LogicalColumn();
logicalColumn2.setId("LC_SALESREP");
logicalColumn2.setPhysicalColumn(column2);
logicalColumn2.setLogicalTable(logicalTable);
logicalTable.addLogicalColumn(logicalColumn2);
Category mainCategory = new Category();
mainCategory.setId("CATEGORY");
mainCategory.setName(new LocalizedString("en_US", "Category"));
mainCategory.addLogicalColumn(logicalColumn);
mainCategory.addLogicalColumn(logicalColumn2);
logicalModel.getCategories().add(mainCategory);
Domain domain = new Domain();
domain.setId("DOMAIN");
domain.addPhysicalModel(model);
domain.addLogicalModel(logicalModel);
return domain;
}
use of org.pentaho.metadata.model.SqlDataSource in project data-access by pentaho.
the class DatasourceModelTest method contructRelationalModel.
private GuiStateModel contructRelationalModel(GuiStateModel guiStateModel) {
IDatabaseConnection connection = new DatabaseConnection();
connection.setAccessType(DatabaseAccessType.NATIVE);
// connection.setDriverClass("org.hsqldb.jdbcDriver");
connection.setName("SampleData");
connection.setPassword("password");
// connection.setUrl("jdbc:hsqldb:file:target/test-classes/solution1/system/data/sampledata");
connection.setUsername("pentaho_user");
List<IDatabaseConnection> connectionList = new ArrayList<IDatabaseConnection>();
connectionList.add(connection);
guiStateModel.setConnections(connectionList);
guiStateModel.setPreviewLimit("10");
guiStateModel.validateRelational();
LogicalColumn logColumn = new LogicalColumn();
logColumn.setDataType(DataType.NUMERIC);
List<AggregationType> aggTypeList = new ArrayList<AggregationType>();
aggTypeList.add(AggregationType.AVERAGE);
logColumn.setAggregationList(aggTypeList);
logColumn.setName(new LocalizedString("En", "Column1"));
BusinessData businessData = new BusinessData();
List<List<String>> dataSample = new ArrayList<List<String>>();
List<String> rowData = new ArrayList<String>();
rowData.add("Data1");
rowData.add("Data2");
rowData.add("Data3");
rowData.add("Data4");
dataSample.add(rowData);
String locale = LocaleHelper.getLocale().toString();
SqlPhysicalModel model = new SqlPhysicalModel();
SqlDataSource dataSource = new SqlDataSource();
dataSource.setDatabaseName("SampleData");
model.setDatasource(dataSource);
SqlPhysicalTable table = new SqlPhysicalTable(model);
model.getPhysicalTables().add(table);
table.setTargetTableType(TargetTableType.INLINE_SQL);
table.setTargetTable("select * from customers");
SqlPhysicalColumn column = new SqlPhysicalColumn(table);
column.setTargetColumn("customername");
column.setName(new LocalizedString(locale, "Customer Name"));
column.setDescription(new LocalizedString(locale, "Customer Name Desc"));
column.setDataType(DataType.STRING);
table.getPhysicalColumns().add(column);
LogicalModel logicalModel = new LogicalModel();
model.setId("MODEL");
model.setName(new LocalizedString(locale, "My Model"));
model.setDescription(new LocalizedString(locale, "A Description of the Model"));
LogicalTable logicalTable = new LogicalTable();
logicalTable.setPhysicalTable(table);
logicalModel.getLogicalTables().add(logicalTable);
LogicalColumn logicalColumn = new LogicalColumn();
logicalColumn.setId("LC_CUSTOMERNAME");
logicalColumn.setPhysicalColumn(column);
logicalTable.addLogicalColumn(logicalColumn);
Category mainCategory = new Category();
mainCategory.setId("CATEGORY");
mainCategory.setName(new LocalizedString(locale, "Category"));
mainCategory.addLogicalColumn(logicalColumn);
logicalModel.getCategories().add(mainCategory);
Domain domain = new Domain();
domain.addPhysicalModel(model);
domain.addLogicalModel(logicalModel);
List<LocaleType> localeTypeList = new ArrayList<LocaleType>();
localeTypeList.add(new LocaleType("Code", "Locale Description"));
domain.setLocales(localeTypeList);
businessData.setData(dataSample);
businessData.setDomain(domain);
guiStateModel.setLocaleCode("en");
guiStateModel.setLogicalModels(domain.getLogicalModels());
guiStateModel.validateRelational();
return guiStateModel;
}
Aggregations