#########################################
# 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")

#########################################
# Mail.py
# more info @: http://myrobotlab.org/service/Mail
#########################################
 
# start the service
mail = runtime.start("mail","Mail")
 
mail.username="who@domain.com"
mail.password="yourpassword"
mail.from=mail.username
mail.to="who@domain.com"
mail.smtpServer="smtp.gmail.com"
mail.smtpServerPort=465
 
mail.subjet="test"
mail.body="body test"
 
mail.sendMailSSL()

################################################
# HttpClient service is a service wrapper of the Apache HttpClient
# So, you can download webpages, images, and a all sorts of
# goodies from the internet
 
http = runtime.start("http","HttpClient")
 
# blocking methods
# GETs
print(http.get("https://www.google.com"))
print(http.get("https://www.cs.tut.fi/~jkorpela/forms/testing.html"))
 
# POSTs
http.addFormField("Comments", "This is a different comment")
http.addFormField("Box", "yes")
http.addFormField("Unexpected", "this is an unexpected field")
http.addFormField("hidden field", "something else")
 
print(http.post("http://www.cs.tut.fi/cgi-bin/run/~jkorpela/echo.cgi"))
 
http.clearForm()
http.addFormField("NewField", "Value")
http.addFormField("name", "value")
 
# call-back methods
# step one add a listener
# you could also 'subscribe' to the appropriate methods
# e.g. python.subscribe('http','publishHttpData') &
# python subscript('http','publishHttpResponse') - the addListeners
# do the same thing
 
http.addHttpDataListener(python)
http.addHttpResponseListener(python)
 
# define the callback endpoints
def onHttpData(httpData):
  print(httpData.uri)
  print(httpData.contentType)
  print(httpData.data)
  print(httpData.responseCode)
 
def onHttpResponse(response):
  print(response)
 
# make the request and the callbacks will be called when
# the method completes
http.post("http://www.cs.tut.fi/cgi-bin/run/~jkorpela/echo.cgi")

#########################################
# WikiDataFetcher.py
# description: used as a general template
# more info @: http://myrobotlab.org/service/WikiDataFetcher
#########################################
# start the service
wiki = Runtime.start("wikiDataFetcher", "WikiDataFetcher")
wiki.setWebSite("enwiki")
wiki.setLanguage("en")
 
print(wiki.getDescription("halloween"))
print(wiki.getDescription("empire state building"))
print(wiki.getDescription("the pyramids"))
print(wiki.getDescription("dog"))
 
# french crawl
wiki.setWebSite("frwiki")
wiki.setLanguage("fr") 
print (u"c est quoi un éléphant  : " + wiki.getDescription(u"éléphant"))