MCPcopy Index your code
hub / github.com/pgadmin-org/pgadmin4 / dump_database_servers

Function dump_database_servers

web/pgadmin/utils/__init__.py:481–586  ·  view source on GitHub ↗

Dump the server groups and servers.

(output_file, selected_servers,
                          dump_user=current_user, from_setup=False,
                          auth_source=INTERNAL)

Source from the content-addressed store, hash-verified

479
480
481def dump_database_servers(output_file, selected_servers,
482 dump_user=current_user, from_setup=False,
483 auth_source=INTERNAL):
484 """Dump the server groups and servers.
485 """
486 user = _does_user_exist(dump_user, from_setup, auth_source)
487 if user is None:
488 return False, USER_NOT_FOUND % dump_user
489
490 user_id = user.id
491 # Dict to collect the output
492 object_dict = {}
493 # Counters
494 servers_dumped = 0
495
496 # Dump servers
497 servers = Server.query.filter_by(user_id=user_id, is_adhoc=0).all()
498 server_dict = {}
499 for server in servers:
500 if selected_servers is None or (
501 isinstance(selected_servers, list) and len(selected_servers) == 0)\
502 or str(server.id) in selected_servers\
503 or server.id in selected_servers:
504 # Get the group name
505 group_name = ServerGroup.query.filter_by(
506 user_id=user_id, id=server.servergroup_id).first().name
507
508 attr_dict = {}
509 add_value(attr_dict, "Name", server.name)
510 add_value(attr_dict, "Group", group_name)
511 add_value(attr_dict, "Host", server.host)
512 add_value(attr_dict, "Port", server.port)
513 add_value(attr_dict, "MaintenanceDB", server.maintenance_db)
514 add_value(attr_dict, "Username", server.username)
515 add_value(attr_dict, "Role", server.role)
516 add_value(attr_dict, "Comment", server.comment)
517 add_value(attr_dict, "Shared", server.shared)
518 add_value(attr_dict, "SharedUsername", server.shared_username)
519 add_value(attr_dict, "DBRestriction", server.db_res)
520 add_value(attr_dict, "DBRestrictionType", server.db_res_type)
521 add_value(attr_dict, "BGColor", server.bgcolor)
522 add_value(attr_dict, "FGColor", server.fgcolor)
523 add_value(attr_dict, "Service", server.service)
524 add_value(attr_dict, "UseSSHTunnel", server.use_ssh_tunnel)
525 add_value(attr_dict, "TunnelHost", server.tunnel_host)
526 add_value(attr_dict, "TunnelPort", server.tunnel_port)
527 add_value(attr_dict, "TunnelUsername", server.tunnel_username)
528 add_value(attr_dict, "TunnelAuthentication",
529 server.tunnel_authentication)
530 add_value(attr_dict, "TunnelIdentityFile",
531 server.tunnel_identity_file)
532 add_value(attr_dict, "TunnelPromptPassword",
533 server.tunnel_prompt_password)
534 add_value(attr_dict, "TunnelKeepAlive",
535 server.tunnel_keep_alive)
536 add_value(attr_dict, "KerberosAuthentication",
537 server.kerberos_conn),
538 add_value(attr_dict, "ConnectionParameters",

Callers 2

dump_serversMethod · 0.90
saveFunction · 0.90

Calls 7

_does_user_existFunction · 0.85
add_valueFunction · 0.85
_handle_errorFunction · 0.85
gettextFunction · 0.85
firstMethod · 0.65
writeMethod · 0.45

Tested by

no test coverage detected