Python DbHelper Examples

Example #1

File: plugin_users.py Project: goibibo/newrelic_sms_alert

class PluginUsers:
    def __init__(self):
        self.db = DbHelper()
        self.table = "plugin_users"

    def get_plugins(self):
        return self.db.select(self.table, "plugin")

    def get_plugin_of_type(self, type):
        return self.db.select(self.table, "plugin", "type", type)

    def users_subscribed_to_a(self, plugin):
        return self.db.select(self.table, "users", "plugin", plugin)

    def update_users_for(self, users, plugin):
        return self.db.update(self.table, "users", users, "plugin", plugin)

Example #2

class PluginUsers:
    def __init__(self):
        self.db = DbHelper()
        self.table = "plugin_users"

    def get_plugins(self):
        return self.db.select(self.table, "plugin")

    def get_plugin_of_type(self, type):
        return self.db.select(self.table, "plugin", "type", type)

    def users_subscribed_to_a(self, plugin):
        return self.db.select(self.table, "users", "plugin", plugin)

    def update_users_for(self, users, plugin):
        return self.db.update(self.table, "users", users, "plugin", plugin)

Example #3

File: user_plugins.py Project: SriRavindranath/alert_devops_in_dataplatform

class UserPlugins:
    def __init__(self):
        self.db = DbHelper()
        self.table = "user_plugins"

    def get_user_and_ph_num(self):
        return self.db.select(self.table, "user,ph_num")

    def plugins_subscribed_by(self, user):
        return self.db.select(self.table, "plugins", "user", user)

    def get_users(self):
        return self.db.select(self.table, "user")

    def update_plugins_for(self, plugins, user):
        return self.db.update(self.table, "plugins", plugins, "user", user)

    def update_ph_num_for(self, ph_num, user):
        return self.db.update(self.table, "ph_num", ph_num, "user", user,
                              "false")

    def create_new_user(self, user, ph_num):
        query = 'insert into user_plugins values(?,?,?,?)'
        params = (user, json.dumps([]), ph_num, None)
        return self.db.insert(query, params)

Example #4

File: user_plugins.py Project: goibibo/newrelic_sms_alert

class UserPlugins:
    def __init__(self):
        self.db = DbHelper()
        self.table = "user_plugins"

    def get_user_and_ph_num(self):
        return self.db.select(self.table, "user,ph_num")

    def plugins_subscribed_by(self, user):
        return self.db.select(self.table, "plugins", "user", user)

    def get_users(self):
        return self.db.select(self.table, "user")

    def update_plugins_for(self, plugins, user):
        return self.db.update(self.table, "plugins", plugins,"user",user)

    def update_ph_num_for(self, ph_num, user):
        return self.db.update(self.table, "ph_num", ph_num, "user", user, "false")

    def create_new_user(self, user, ph_num):
        query = 'insert into user_plugins values(?,?,?,?)'
        params = (user, json.dumps([]), ph_num, None)
        return self.db.insert(query, params)

Example #5

File: user_plugins.py Project: goibibo/newrelic_sms_alert

 def __init__(self):
     self.db = DbHelper()
     self.table = "user_plugins"

Example #6

File: plugin_users.py Project: goibibo/newrelic_sms_alert

 def __init__(self):
     self.db = DbHelper()
     self.table = "plugin_users"

Example #7

File: user_plugins.py Project: SriRavindranath/alert_devops_in_dataplatform

 def __init__(self):
     self.db = DbHelper()
     self.table = "user_plugins"

Example #8

 def __init__(self):
     self.db = DbHelper()
     self.table = "plugin_users"