def get_db_details(request, hostname, database_name, resource_name): server_info = read_server_info(hostname) if server_info: found_db = None for database in server_info["databases"]: if database["name"] == database_name: found_db = database break size = "" if found_db and "size" in found_db: size = found_db["size"] return render_to_response('platforms/postgresql/database.html', { "base_url": settings.BASE_URL, "static_url": settings.STATIC_URL, "db_size": size, "db_name": database_name, "hostname": hostname }, context_instance=RequestContext(request)) else: return render_to_response('platforms/postgresql/database.html', { "base_url": settings.BASE_URL, "static_url": settings.STATIC_URL, "hostname": hostname }, context_instance=RequestContext(request))
def get_details(request, hostname, database_name, resource_name): server_info = read_server_info(hostname) if server_info: version = "" if "version" in server_info: version = server_info["version"] datadir = "" if "data_dir" in server_info: datadir = server_info["data_dir"] return render_to_response('platforms/postgresql/server.html', {"base_url": settings.BASE_URL, "static_url":settings.STATIC_URL, "pg_version": version, "pg_datadir": datadir, "hostname": hostname}, context_instance=RequestContext(request)) else: return render_to_response('platforms/postgresql/server.html', {"base_url": settings.BASE_URL, "static_url":settings.STATIC_URL, "hostname": hostname}, context_instance=RequestContext(request))
def get_db_details(request, hostname, database_name, resource_name): server_info = read_server_info(hostname) if server_info: found_db = None for database in server_info["databases"]: if database["name"] == database_name: found_db = database break size = "" if found_db and "size" in found_db: size = found_db["size"] return render_to_response('platforms/postgresql/database.html', {"base_url": settings.BASE_URL, "static_url":settings.STATIC_URL, "db_size":size, "db_name":database_name, "hostname": hostname}, context_instance=RequestContext(request)) else: return render_to_response('platforms/postgresql/database.html', {"base_url": settings.BASE_URL, "static_url":settings.STATIC_URL, "hostname": hostname}, context_instance=RequestContext(request))
def get_details(request, hostname, database_name, resource_name): server_info = read_server_info(hostname) if server_info: version = "" if "version" in server_info: version = server_info["version"] datadir = "" if "data_dir" in server_info: datadir = server_info["data_dir"] return render_to_response('platforms/postgresql/server.html', { "base_url": settings.BASE_URL, "static_url": settings.STATIC_URL, "pg_version": version, "pg_datadir": datadir, "hostname": hostname }, context_instance=RequestContext(request)) else: return render_to_response('platforms/postgresql/server.html', { "base_url": settings.BASE_URL, "static_url": settings.STATIC_URL, "hostname": hostname }, context_instance=RequestContext(request))
def getDetailsTree(self, hostname): server_info = read_server_info(hostname) content = {} #Configuring Instances if server_info: content = {"isFolder": True, "title": 'PostgreSQL', "key":'PostgreSQL', "icon":"postgresql.png", "detailsEnabled":"true", 'url': reverse('postgres_details', kwargs={'hostname':hostname, 'database_name':hostname, 'resource_name':hostname})} logger.debug('Configuring Databases') db_instances = {'title': 'Databases', 'isFolder':True, "key":"databases", "icon":"folder_database.png", "type":"databases"} dbs = [] for database in server_info["databases"]: db = {'title':database['name'], "key":database['name'], "icon":"database.png", "type":"database", "instance":database['name'], "detailsEnabled":"true", 'url': reverse('postgres_db_details', kwargs={'hostname':hostname, 'database_name':database['name'], 'resource_name':database['name']})} #Configuring Applications logger.debug('Configuring Tables') tables = {'title': 'Tables', 'isFolder':True, "key":"tables", "icon":"folder_documents.png", "type":"tables"} tabs = [] for table in database['tables']: tab = {'title':table, "key":table, "icon":"datasource.png", "type":"table", "database":database['name']} tabs.append(tab) tables['children'] = tabs db['children'] = [tables] dbs.append(db) db_instances['children'] = dbs users_tree = {'title': 'Users', 'isFolder':True, "key":"users", "icon":"users.png", "type":"users"} users = [] for user in server_info["users"]: user_tree = {'title':user['username'], "key":user['username'], "icon":"user.png", "type":"user"} users.append(user_tree) users_tree['children'] = users children = [] children.append(db_instances) children.append(users_tree) content['children'] = children return content
def getDetailsTree(self, hostname): server_info = read_server_info(hostname) content = {} #Configuring Instances if server_info: content = { "isFolder": True, "title": 'PostgreSQL', "key": 'PostgreSQL', "icon": "postgresql.png", "detailsEnabled": "true", 'url': reverse('postgres_details', kwargs={ 'hostname': hostname, 'database_name': hostname, 'resource_name': hostname }) } logger.debug('Configuring Databases') db_instances = { 'title': 'Databases', 'isFolder': True, "key": "databases", "icon": "folder_database.png", "type": "databases" } dbs = [] for database in server_info["databases"]: db = { 'title': database['name'], "key": database['name'], "icon": "database.png", "type": "database", "instance": database['name'], "detailsEnabled": "true", 'url': reverse('postgres_db_details', kwargs={ 'hostname': hostname, 'database_name': database['name'], 'resource_name': database['name'] }) } #Configuring Applications logger.debug('Configuring Tables') tables = { 'title': 'Tables', 'isFolder': True, "key": "tables", "icon": "folder_documents.png", "type": "tables" } tabs = [] for table in database['tables']: tab = { 'title': table, "key": table, "icon": "datasource.png", "type": "table", "database": database['name'] } tabs.append(tab) tables['children'] = tabs db['children'] = [tables] dbs.append(db) db_instances['children'] = dbs users_tree = { 'title': 'Users', 'isFolder': True, "key": "users", "icon": "users.png", "type": "users" } users = [] for user in server_info["users"]: user_tree = { 'title': user['username'], "key": user['username'], "icon": "user.png", "type": "user" } users.append(user_tree) users_tree['children'] = users children = [] children.append(db_instances) children.append(users_tree) content['children'] = children return content