Java JDBCDataSource.setName方法代码示例

import ca.sqlpower.sql.JDBCDataSource; //导入方法依赖的package包/类
protected void setUp() throws Exception {
    super.setUp();
    session = new TestingMatchMakerSession() {
    	@Override
    	public SQLDatabase getDatabase(JDBCDataSource dataSource) {
    		return this.db;
    	};
    };
    JDBCDataSource dataSource = new JDBCDataSource(
    		((TestingMatchMakerContext)session.getContext()).getDataSources().get(0));
    dataSource.setName("testing datasource");
    ((TestingMatchMakerContext)session.getContext()).setDataSou2rces(
    		Collections.singletonList(dataSource));
    session.setDatabase(new SQLDatabase());
    project = new Project();
    project.setSession(session);
}
 

import ca.sqlpower.sql.JDBCDataSource; //导入方法依赖的package包/类
/**
* Creates a new hsqldb infile database and adds it to the list.
*/
  private JDBCDataSource makeDefaultDataSource() {
      JDBCDataSource ds = new JDBCDataSource(getPlDotIni());
      ds.setName(DEFAULT_REPOSITORY_DATA_SOURCE_NAME);
      ds.setPlSchema("public");
      ds.setUser("sa");
      ds.setPass("");
      ds.setUrl("jdbc:hsqldb:file:"+System.getProperty("user.home")+"/.mm/hsql_repository;shutdown=true");

      // find HSQLDB parent type
      JDBCDataSourceType hsqldbType = null;
      for (JDBCDataSourceType type : getPlDotIni().getDataSourceTypes()) {
          if ("HSQLDB".equals(type.getName())) {
              hsqldbType = type;
              break;
          }
      }
      if (hsqldbType == null) {
          throw new RuntimeException("HSQLDB Database type is missing in pl.ini");
      }
      ds.setParentType(hsqldbType);
      
      getPlDotIni().addDataSource(ds);
  return ds;
  }
 

import ca.sqlpower.sql.JDBCDataSource; //导入方法依赖的package包/类
/**
 * Test a query can be added to and removed from a workspace with the
 * addChild method. Also checks that the index is correct.
 * @throws Exception
 */
public void testAddAndRemoveQuery() throws Exception {
    final JDBCDataSource spds = new JDBCDataSource(new StubDataSourceCollection<SPDataSource>());
    spds.setName("ds");
    WabitDataSource ds = new WabitDataSource(spds);
    workspace.addDataSource(ds);
    
    QueryCache q = new QueryCache(new StubSQLDatabaseMapping());
    q.setName("query");
    
    workspace.addChild(q, 0);
    
    assertTrue(workspace.getChildren().contains(q));
    
    workspace.removeChild(q);
    
    assertFalse(workspace.getChildren().contains(q));
}
 

import ca.sqlpower.sql.JDBCDataSource; //导入方法依赖的package包/类
public void testNoEmptySimulatedTable() throws Exception {

    	session = new TestingMatchMakerSession() {
    		public SQLDatabase getDatabase(JDBCDataSource dataSource) {
    			return this.db;
    		};	
    	};

        JDBCDataSource dataSource = new JDBCDataSource(
        		((TestingMatchMakerContext)session.getContext()).getDataSources().get(0));
        dataSource.setName("testing datasource");
        ((TestingMatchMakerContext)session.getContext()).setDataSou2rces(
        		Collections.singletonList(dataSource));
        session.setDatabase(new SQLDatabase());
        
        project.setSession(session);
    	
        SQLTable sourceTable = new SQLTable(session.getDatabase(), true);
        session.getDatabase().addChild(sourceTable);
        sourceTable.addColumn(new SQLColumn(sourceTable, "pk1", Types.INTEGER, 10, 0));
        sourceTable.addToPK(sourceTable.getColumn(0));
        
        project.setSourceTable(sourceTable);
        project.setSourceTableIndex(sourceTable.getPrimaryKeyIndex());
        
        project.setResultTableCatalog(null);
        project.setResultTableSchema(null);
        project.setResultTableName("new_table_that_doesnt_exist");
    	project.setResultTableSPDatasource("testing datasource");
        
        project.createResultTable();
        
        SQLTable newTable = project.getResultTable();
        assertTrue(newTable.getColumns().size() > 0);
        
        SQLTable newTableInDatabase = session.getDatabase().getChildByName("new_table_that_doesnt_exist", SQLTable.class);
        assertNotNull(newTableInDatabase);
        assertTrue(newTableInDatabase.getColumns().size() > 0);
        assertSame(newTable, newTableInDatabase);
    }
 

import ca.sqlpower.sql.JDBCDataSource; //导入方法依赖的package包/类
/**
 * Returns a new SPDataSource which is configured to create
 * an in-memory (non persistent) HSQLDB instance.  The PL schema is in pl.
 */
public static JDBCDataSource getHSQLDBInMemoryDS() {
    final String hsqlUserName = "sa";
    final String hsqlPassword = "";
    final String hsqlUrl = "jdbc:hsqldb:mem:aname";
    
    JDBCDataSource hsqlDataSource = new JDBCDataSource(new PlDotIni());
    hsqlDataSource.getParentType().setJdbcDriver("org.hsqldb.jdbcDriver");
    hsqlDataSource.getParentType().setDDLGeneratorClass(HSQLDBDDLGenerator.class.getName());
    hsqlDataSource.setName("In-memory HSQLDB");

    hsqlDataSource.setUser(hsqlUserName);
    hsqlDataSource.setPass(hsqlPassword);
    hsqlDataSource.setPlDbType("hsql");
    hsqlDataSource.setPlSchema("pl");
    hsqlDataSource.setUrl(hsqlUrl);
    
    try {
        Connection con = connectToDatabase(hsqlDataSource);
        createHsqlPlSchemaIfNecessary(con);
        // have to leave connection open (see connectToDatabase())
    } catch (Exception ex) {
        throw new RuntimeException(ex);
    }
    
    return hsqlDataSource;
}
 

import ca.sqlpower.sql.JDBCDataSource; //导入方法依赖的package包/类
public TableMergeRuleTest(String name) {
	super(name);
       JDBCDataSource dataSource = new JDBCDataSource(
       		((TestingMatchMakerContext)testingMatchMakerSession.getContext()).getDataSources().get(0));
       dataSource.setName("testing datasource");
       ((TestingMatchMakerContext)session.getContext()).setDataSou2rces(
       		Collections.singletonList(dataSource));
}