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) {

View Full Code Here

    
    Instances result = null;
    
    // TODO perhaps add option for sparse data
    try {
      InstanceQuery iq = new InstanceQuery();
      iq.setUsername(m_User);
      iq.setPassword(m_Password);
      iq.setQuery(m_query);
      
      result = iq.retrieveInstances();
      
      if(m_DataBaseConnection.getUpperCase()) {
        m_idColumn = m_idColumn.toUpperCase();
      }

View Full Code Here

   */
  public void setInstancesFromDBQ(String url, String user, 
                                  String pw, String query) {
    if (m_IOThread == null) {
      try {
  InstanceQuery InstQ = new InstanceQuery();
        InstQ.setDatabaseURL(url);
        InstQ.setUsername(user);
        InstQ.setPassword(pw);
        InstQ.setQuery(query);
  
        // 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) {

View Full Code Here

   */
  protected void setInstancesFromDBaseQuery() {


    try {
      if (m_InstanceQuery == null) {
  m_InstanceQuery = new InstanceQuery();
      }
      String dbaseURL = m_InstanceQuery.getDatabaseURL();
      String username = m_InstanceQuery.getUsername();
      String passwd = m_InstanceQuery.getPassword();
      /*dbaseURL = (String) JOptionPane.showInputDialog(this,

View Full Code Here

    } else if (exp.getResultListener() instanceof DatabaseResultListener) {
      String dbaseURL = ((DatabaseResultListener) exp.getResultListener())
  .getDatabaseURL();
      try {
  if (m_InstanceQuery == null) {
    m_InstanceQuery = new InstanceQuery();
  }
  m_InstanceQuery.setDatabaseURL(dbaseURL);
  m_InstanceQuery.connectToDatabase();
  String tableName = m_InstanceQuery
    .getResultsTableName(exp.getResultProducer());

View Full Code Here

   */
  protected void setInstancesFromDBaseQuery() {


    try {
      if (m_InstanceQuery == null) {
  m_InstanceQuery = new InstanceQuery();
      }
      String dbaseURL = m_InstanceQuery.getDatabaseURL();
      String username = m_InstanceQuery.getUsername();
      String passwd = m_InstanceQuery.getPassword();
      /*dbaseURL = (String) JOptionPane.showInputDialog(this,

View Full Code Here

    } else if (exp.getResultListener() instanceof DatabaseResultListener) {
      String dbaseURL = ((DatabaseResultListener) exp.getResultListener())
  .getDatabaseURL();
      try {
  if (m_InstanceQuery == null) {
    m_InstanceQuery = new InstanceQuery();
  }
  m_InstanceQuery.setDatabaseURL(dbaseURL);
  m_InstanceQuery.connectToDatabase();
  String tableName = m_InstanceQuery
    .getResultsTableName(exp.getResultProducer());

View Full Code Here

   */
  public void setInstancesFromDBQ(String url, String user, 
                                  String pw, String query) {
    if (m_IOThread == null) {
      try {
  InstanceQuery InstQ = new InstanceQuery();
        InstQ.setDatabaseURL(url);
        InstQ.setUsername(user);
        InstQ.setPassword(pw);
        InstQ.setQuery(query);
  
        // 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) {

View Full Code Here

   */
  protected void setInstancesFromDBaseQuery() {


    try {
      if (m_InstanceQuery == null) {
  m_InstanceQuery = new InstanceQuery();
      }
      String dbaseURL = m_InstanceQuery.getDatabaseURL();
      String username = m_InstanceQuery.getUsername();
      String passwd = m_InstanceQuery.getPassword();
      /*dbaseURL = (String) JOptionPane.showInputDialog(this,

View Full Code Here

    } else if (exp.getResultListener() instanceof DatabaseResultListener) {
      String dbaseURL = ((DatabaseResultListener) exp.getResultListener())
  .getDatabaseURL();
      try {
  if (m_InstanceQuery == null) {
    m_InstanceQuery = new InstanceQuery();
  }
  m_InstanceQuery.setDatabaseURL(dbaseURL);
  m_InstanceQuery.connectToDatabase();
  String tableName = m_InstanceQuery
    .getResultsTableName(exp.getResultProducer());

View Full Code Here

0 1

TOP

Related Classes of weka.experiment.InstanceQuery

weka.core.Attribute

weka.core.converters.DatabaseLoader

weka.core.DenseInstance

weka.core.SparseInstance

weka.gui.experiment.ResultsPanel

weka.gui.explorer.PreprocessPanel

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.