def GetProperties(self):
if not self.properties:
self.version=3
if self.user:
user=self.user
else:
user=xlt("anonymous")
self.properties= [
( xlt("Name"),self.name),
( xlt("Version"), self.version),
( xlt("Address"), self.address),
( xlt("Ldap Base"), self.dn),
( xlt("Security"), self.settings['security']),
( xlt("Port"), self.settings["port"]),
( xlt("User"), user),
( xlt("Connected"), YesNo(self.IsConnected())),
( xlt("Autoconnect"), YesNo(self.settings.get('autoconnect'))),
]
if self.connection.base:
for name, val in self.connection.base.items():
self.AddChildrenProperty(val, name, -1)
if self.adminLdapDn:
self.properties.append( (xlt("Admin Config DN"), self.adminLdapDn))
else:
self.properties.append( (xlt("Instrumentation"), xlt("not instrumented")) )
if self.registrationChanged:
self.properties.append( (xlt("Registration"), xlt("Registration changed"), adm.images['attention']) )
return self.properties
def GetProperties(self):
if not self.properties:
sec = self.settings['security']
if sec.startswith('SSL'):
pass
elif sec.startswith('TLS'):
if self.connection.tls: sec = "TLS"
else: sec = xlt("unsecured connection")
self.annotations = self.connection.GetAnnotations('')
self.properties = [
(xlt("Name"), self.name),
(xlt("Protocol"), self.connection.PROTOCOL_VERSION),
(xlt("Address"), self.address),
(xlt("Security"), sec),
(xlt("Port"), self.settings["port"]),
(xlt("User"), self.user),
(xlt("Connected"), YesNo(self.IsConnected())),
(xlt("Autoconnect"), YesNo(self.settings.get('autoconnect'))),
]
self.AddProperty("Server", self.connection.id.get('name'))
self.AddProperty("Version", self.connection.id.get('version'))
fs = self.annotations.Get('/freespace')
if fs != None:
self.AddSizeProperty(xlt("Free space"), float(fs) * 1024)
# if self.IsConnected():
# self.AddChildrenProperty(list(self.connection.capabilities), xlt("Capabilities"), -1)
return self.properties
def GetProperties(self):
if not self.properties:
missing = self.NeedsInstrumentation()
if missing:
instr = xlt("incomplete: %s missing" % ",".join(missing))
else:
instr = xlt("fully instrumented")
self.properties = [
(xlt("Name"), self.name),
(xlt("Version"), self.info['version']),
(xlt("Address"), self.address),
(xlt("Maintenance DB"), self.maintDb),
(xlt("Security"), self.settings['security']),
(xlt("Port"), self.settings["port"]),
(xlt("User"), self.user),
(xlt("Connected"), YesNo(self.IsConnected())),
(xlt("Autoconnect"), YesNo(self.settings.get('autoconnect'))),
(xlt("Autovacuum"), YesNo(self.info['autovacuum'])),
(xlt("Instrumentation"), instr),
]
return self.properties
def GetProperties(self):
if not len(self.properties):
self.properties = [
(xlt("Name"), self.name, self.GetImageId('Role')),
("OID", self.info['oid']),
(xlt("Can Login"), YesNo(self.info['rolcanlogin'])),
(xlt("Superuser"), YesNo(self.info['rolsuper'])),
(xlt("Catalog Update"), YesNo(self.info['rolcatupdate'])),
(xlt("Create DB"), YesNo(self.info['rolcreatedb'])),
(xlt("Create Role"), YesNo(self.info['rolcreaterole'])),
(xlt("Inherits rights"), YesNo(self.info['rolinherit'])),
]
until = self.info['rolvaliduntil']
if not until or until.year == 9999:
until = xlt("never")
else:
until = prettyDate(until)
self.properties.append((xlt("Expires"), until))
self.AddChildrenProperty(self.info['memberof'], xlt("Member of"),
self.GetImageId("Group"))
self.AddChildrenProperty(self.info['members'], xlt("Members"),
self.GetImageId("User"))
self.AddChildrenProperty(self.info['rolconfig'], xlt("Variables"),
-1)
return self.properties
def GetProperties(self):
if not len(self.properties):
dict=self.GetCursor().ExecuteDict("""
SELECT 'languages', array_agg(lanname) as lannames
FROM (SELECT lanname FROM pg_language ORDER BY lanispl desc, lanname) AS langlist""")
self.info.update(dict)
if self.GetServer().version >= 9.1:
dict=self.GetCursor().ExecuteDict("""
SELECT 'extensions', array_agg(name) as extnames
FROM (SELECT extname || ' V' || extversion AS name FROM pg_extension ORDER BY extname) AS extlist
UNION
SELECT 'available_extensions', array_agg(name) as extnames
FROM (SELECT name || ' V' || default_version AS name FROM pg_available_extensions WHERE installed_version is null ORDER BY name) AS avextlist
""")
self.info.update(dict)
self.properties = [
(xlt("Name"), self.name),
( "OID" , self.info['oid']),
(xlt("Owner"), self.info['dbowner']),
(xlt("Tablespace"), self.info['spcname']),
(xlt("Encoding"), self.info['pgencoding']),
(xlt("Connected"), YesNo(self.IsConnected())),
]
self.AddProperty(xlt("Backend PID"), self.GetCursor().GetPid())
if self.info['datistemplate']:
self.AddYesNoProperty(xlt("Template"), True)
if 'datctype' in self.info:
self.AddProperty(xlt("Collate"), self.info['datcollate'])
self.AddProperty(xlt("CType"), self.info['datctype'])
self.AddProperty(xlt("Languages"), ", ".join(self.info['languages']))
ext=self.info.get('extensions')
if ext != None:
if ext:
ext=", ".join(ext)
self.AddProperty(xlt("Installed Extensions"), ext)
avext=self.info.get('available_extensions')
if avext:
avext=", ".join(avext)
self.AddProperty(xlt("Available Extensions"), avext)
self.AddProperty(xlt("Description"), self.info['description'])
return self.properties
def GetProperties(self):
if not self.properties:
self.properties = [
(xlt("Name"), self.name),
# ( xlt("Version"), self.info['version']),
(xlt("Address"), self.address),
(xlt("Port"), self.settings["port"]),
(xlt("Stats Port"), self.settings.get("statsport")),
(xlt("Key name"), self.settings.get("keyname")),
(xlt("Autoconnect"), YesNo(self.settings.get('autoconnect'))),
]
self.AddProperty(xlt("BIND Version"), self.bindVersion)
self.AddProperty(xlt("Server Boot"), self.serverBoot)
zimg = self.GetImageId("Zone")
for viewname, zones in self.viewzones.items():
self.AddChildrenProperty(
sorted(zones),
xlt("Zones in view \"%s\"") % viewname, zimg)
return self.properties
def GetProperties(self):
if not len(self.properties):
args = self.info.get('arguments')
if args == None:
logger.error("PGSQL < 8.4; no function args/returns")
args = ""
self.info['arguments'] = ""
self.info['result'] = ""
self.info['definition'] = None
result = self.info.get('result', "")
self.properties = [
(xlt("Name"), "%s(%s)" % (self.info['name'], args)),
(xlt("Namespace"), self.info['nspname']),
(xlt("Language"), self.info['lanname']),
(xlt("Strict"), YesNo(self.info['proisstrict'])),
("OID", self.info['oid']), (xlt("Returns"), result),
(xlt("Owner"), self.info['owner']),
(xlt("ACL"), self.info['acl'])
]
self.AddProperty(xlt("Description"), self.info['description'])
return self.properties