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('\\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 = []
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 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_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.'))
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()
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()
self.context.notify('error', _('This username is already used'))
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()
