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