Database | MyRobotLab

wrapper around jdbc access :

This service will be usefull for connecting to databases.
Tested with script bellow, to connect a mysql database with a simple select

database.executeUpdate : // return int

database.executeQuery : // return ResultSet

database.execute : // return boolean

Example code (from branch develop):

#file : Database.py (github)

#########################################
# Database.py
# description: database - wrapper around jdbc access
# categories: storage
# more info @: http://myrobotlab.org/service/Database
#########################################
 
if ('virtual' in globals() and virtual):virtual=True
else:virtual=False
 
# start the service
database = runtime.start('database','Database')
database.connectionString="jdbc:mysql://HOST/DATABASE"
database.jdbcUser="user"
database.jdbcPassword="password"
 
if not virtual:
  print database.connect()
  resultSet  = database.executeQuery("SELECT * FROM YOUR_TABLE")
  while (resultSet.next()):
    print resultSet.getString("id")

Example configuration (from branch develop):

#file : Database.py (github)

!!org.myrobotlab.service.config.ServiceConfig
listeners: null
peers: null
type: Database