Issue with bottle-pymysql

[nikos]

plugin = bottle_pymysql.Plugin( dbuser='nikos', dbpass='******', dbname='counters', charset = 'utf8', keyword='pymydb' )
app.install(plugin)

# calculate total hits for each and every webpage
pymydb.execute( '''SELECT url from pages ORDER by hits ASC''' )

When i try to run the script i get the error:

Output:
NameError("name 'pymydb' is not defined",)