Examples of weka.experiment.InstanceQuery

weka.experiment.InstanceQuery

Convert the results of a database query into instances. The jdbc driver and database to be used default to "jdbc.idbDriver" and "jdbc:idb=experiments.prp". These may be changed by creating a java properties file called DatabaseUtils.props in user.home or the current directory. eg:

 jdbcDriver=jdbc.idbDriver jdbcURL=jdbc:idb=experiments.prp

Command line use just outputs the instances to System.out.

Valid options are:

 -Q <query> SQL query to execute.

 -S Return sparse rather than normal instances.

 -U <username> The username to use for connecting.

 -P <password> The password to use for connecting.

 -D Enables debug output.

@author Len Trigg (trigg@cs.waikato.ac.nz) @version $Revision: 7038 $

  public void setInstancesFromDBQ(String url, String user, 
                                  String pw, String query,
                                  boolean sparse) {
    if (m_IOThread == null) {
      try {
  InstanceQuery InstQ = new InstanceQuery();
        InstQ.setDatabaseURL(url);
        InstQ.setUsername(user);
        InstQ.setPassword(pw);
        InstQ.setQuery(query);
        InstQ.setSparseData(sparse);
  
        // we have to disconnect, otherwise we can't change the DB!
        if (InstQ.isConnected())
          InstQ.disconnectFromDatabase();


  InstQ.connectToDatabase();      
  try {
    addUndoPoint();
  } catch (Exception ignored) {}
  setInstancesFromDB(InstQ);
      } catch (Exception ex) {

   
    
    Instances result = null;
    checkEnv();
    try {
      InstanceQuery iq = new InstanceQuery();
      iq.initialize(m_CustomPropsFile);
      String realURL = m_URL;
      try {
        realURL = m_env.substitute(realURL);
      } catch (Exception ex) { }
      iq.setDatabaseURL(realURL);
      String realUser = m_User;
      try {
        realUser = m_env.substitute(realUser);
      } catch (Exception ex) { }
      iq.setUsername(realUser);
      String realPass = m_Password;
      try {
        realPass = m_env.substitute(realPass);
      } catch (Exception ex) { }
      iq.setPassword(realPass);      
      String realQuery = m_query;
      try {
        realQuery = m_env.substitute(realQuery);
      } catch (Exception ex) { }
      iq.setQuery(realQuery);
      iq.setSparseData(m_CreateSparseData);
      
      result = iq.retrieveInstances();
      
      if(m_DataBaseConnection.getUpperCase()) {
        m_idColumn = m_idColumn.toUpperCase();
      }

Examples of weka.experiment.InstanceQuery

Related Classes of weka.experiment.InstanceQuery