Python InstanceQuery.user Examples

Example #1

File: wekaWrapper.py Project: dtalbert3/nemo

	def retrieveData(self, id, dataset):
		query = self.api.getDataQuery(id, dataset)
		iquery = InstanceQuery()
		iquery.db_url = "jdbc:mysql://" + self.config.HOST + ":" + str(self.config.PORT) + "/" + self.config.DB
		iquery.user = self.config.USER
		iquery.password = self.config.PASS
		iquery.query = query
		data = iquery.retrieve_instances()
		data.class_is_last()
		return data

Example #2

File: source.py Project: shrurastogi/python-weka-wrapper

 def do_execute(self):
     """
     The actual execution of the actor.
     :return: None if successful, otherwise error message
     :rtype: str
     """
     iquery = InstanceQuery()
     iquery.db_url = str(self.resolve_option("db_url"))
     iquery.user = str(self.resolve_option("user"))
     iquery.password = str(self.resolve_option("password"))
     props = str(self.resolve_option("custom_props"))
     if (len(props) > 0) and os.path.isfile(props):
         iquery.custom_properties = props
     iquery.query = str(self.resolve_option("query"))
     data = iquery.retrieve_instances()
     self._output.append(Token(data))
     return None

Example #3

File: source.py Project: eulersantana/python-weka-wrapper

 def do_execute(self):
     """
     The actual execution of the actor.
     :return: None if successful, otherwise error message
     :rtype: str
     """
     iquery = InstanceQuery()
     iquery.db_url = str(self.resolve_option("db_url"))
     iquery.user = str(self.resolve_option("user"))
     iquery.password = str(self.resolve_option("password"))
     props = str(self.resolve_option("custom_props"))
     if (len(props) > 0) and os.path.isfile(props):
         iquery.custom_properties = props
     iquery.query = str(self.resolve_option("query"))
     data = iquery.retrieve_instances()
     self._output.append(Token(data))
     return None

Example #4

File: database.py Project: xiangyu-sun-789/python-weka-wrapper3-examples

def main():
    """
    Just runs some example code.
    NB: You have to fill in the following parameters to make it work with MySQL:
    - HOSTNAME: the database server IP or hostname (or just 'localhost')
    - DBNAME: the name of the database to connect to
    - DBUSER: the user for connecting to the database
    - DBPW: the password for the database user
    - TABLE: the table to retrieve the data from
    And also supply the correct path to the MySQL jar in the "main" method below.
    """

    # retrieve some data
    helper.print_title("Loading data from a database")
    iquery = InstanceQuery()
    iquery.db_url = "jdbc:mysql://HOSTNAME:3306/DBNAME"
    iquery.user = "******"
    iquery.password = "******"
    iquery.query = "select * from TABLE"
    data = iquery.retrieve_instances()
    print(data)

Example #5

File: database.py Project: fracpete/python-weka-wrapper-examples

def main():
    """
    Just runs some example code.
    NB: You have to fill in the following parameters to make it work with MySQL:
    - HOSTNAME: the database server IP or hostname (or just 'localhost')
    - DBNAME: the name of the database to connect to
    - DBUSER: the user for connecting to the database
    - DBPW: the password for the database user
    - TABLE: the table to retrieve the data from
    And also supply the correct path to the MySQL jar in the "main" method below.
    """

    # retrieve some data
    helper.print_title("Loading data from a database")
    iquery = InstanceQuery()
    iquery.db_url = "jdbc:mysql://HOSTNAME:3306/DBNAME"
    iquery.user = "******"
    iquery.password = "******"
    iquery.query = "select * from TABLE"
    data = iquery.retrieve_instances()
    print(data)