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