Build precise queries to find exactly what you need
Press ESC to close
@mkoco
Member Since: June 28, 2011
Favorites0
Views
Projects0
Very nice job. TODO: Replace occurrences of tr (of being usually /usr/bin/tr) with TR="/usr/xpg4/bin/tr" and all should work fine...
Reviewed 10 years ago
Excellent !!! I just have to adjust it to make it run faster... Here is how: {code} #ORIG: log_message = log_message.rstrip(" ") #MKOCO addon to message log_message = log_message.split(":")[1] self.vprint(2, "extracted log message body from log") self.vprint(2, "log message is '%s'" % log_message) # security is maintained by a combinarion of `` and restrictive # regex validation the validate functions. MySQLdb must take care of # the log value but this is not an input variable anyway. #ORIGsql#query = "select count(*) from `%s` where `%s` LIKE %%s" # % (self.mysql_table, self.mysql_column) #MKOCO query = "select count(*) from ( SELECT * FROM ( select * from `%s` ORDER BY seq DESC LIMIT 10000 ) sub ORDER BY seq ASC ) as xxx1 where xxx1.`%s` LIKE %%s" % (self.mysql_table, self.mysql_column) {code} If you update your release, you can freely add it...
Reviewed 11 years ago
Best plugin for checking HP hardware.