def query_databases(self): r = [] for l in self.query('\\l'): db = Database() db.name = l.split('|')[0] r.append(db) return r
def query_databases(self): r = [] for l in self.query('SHOW DATABASES;'): db = Database() db.name = l r.append(db) return r
def query_databases(self): r = [] for l in self.query("SHOW DATABASES;"): db = Database() db.name = l r.append(db) return r
def query_databases(self): r = [] with self.connect() as mongo: for x in mongo.client.database_names(): d = Database() d.name = x r.append(d) return r
def query_databases(self): result = [] with self.connect() as rethink: for x in r.db_list().run(rethink.client): d = Database() d.name = x result.append(d) return result
def on_delete(self): db = Database() db.name = self.config['name'] try: self.db.query_drop(db) except Exception, e: # I'm gonna burn in hell for this... if not 'ERROR 1008' in e: raise e
def on_delete_db(self, db_cfg): db = Database() db.name = db_cfg['name'] try: self.db.query_drop(db) except Exception, e: # I'm gonna burn in hell for this... if not 'ERROR 1008' in e: self.context.notify('error', str(e)) return
def on_grant(self): for db_cfg in self.config["databases"]: db = Database() db.name = db_cfg["name"] for user_cfg in self.config["users"]: user = User() user.name = user_cfg["name"] user.password = user_cfg["password"] user.host = "%" self.db.query_grant(user, db) self.context.notify("info", _("Permissions granted."))
def on_grant(self): for db_cfg in self.config['databases']: db = Database() db.name = db_cfg['name'] for user_cfg in self.config['users']: user = User() user.name = user_cfg['name'] user.password = user_cfg['password'] user.host = '%' self.db.query_grant(user, db) self.context.notify('info', _('Permissions granted.'))
user_cfg = { 'name': username, 'password': password, } user = User() user.name = user_cfg['name'] user.password = user_cfg['password'] user.host = '%' try: self.db.query_create_user(user) except Exception, e: self.context.notify('error', str(e)) return self.config['users'].append(user_cfg) # Grant User dbku = Database() dbku.name = dbname self.db.query_grant(user, dbku) self.context.notify('info', _('Database Created !')) self.refresh() self.try_save() def try_save(self): if self.editor_ui is not None: self.editor_ui.save_data()
return self.config['name'] = dbname self.config['username'] = username self.config['password'] = str(uuid.uuid4()) try: self.db.query_create(self.config['name']) except Exception, e: self.context.notify('error', str(e)) return self.config['created'] = True db = Database() db.name = self.config['name'] user = User() user.name = self.config['username'] user.password = self.config['password'] user.host = 'localhost' try: self.db.query_create_user(user) except Exception, e: self.db.query_drop(db) self.context.notify('error', str(e)) return self.db.query_grant(user, db) self.refresh()