1 # SPDX-License-Identifier: GPL-2.0-only
3 # This file is part of Nominatim. (https://nominatim.org)
5 # Copyright (C) 2022 by the Nominatim developer community.
6 # For a full list of authors see the git log.
8 Implementation of the 'admin' subcommand.
14 from nominatim.db.connection import connect
15 from nominatim.clicmd.args import NominatimArgs
16 import nominatim.api as napi
18 # Do not repeat documentation of subcommand classes.
19 # pylint: disable=C0111
20 # Using non-top-level imports to avoid eventually unused imports.
21 # pylint: disable=E0012,C0415
23 LOG = logging.getLogger()
28 Analyse and maintain the database.
31 def add_args(self, parser: argparse.ArgumentParser) -> None:
32 group = parser.add_argument_group('Admin tasks')
33 objs = group.add_mutually_exclusive_group(required=True)
34 objs.add_argument('--warm', action='store_true',
35 help='Warm database caches for search and reverse queries')
36 objs.add_argument('--check-database', action='store_true',
37 help='Check that the database is complete and operational')
38 objs.add_argument('--migrate', action='store_true',
39 help='Migrate the database to a new software version')
40 objs.add_argument('--analyse-indexing', action='store_true',
41 help='Print performance analysis of the indexing process')
42 objs.add_argument('--collect-os-info', action="store_true",
43 help="Generate a report about the host system information")
44 group = parser.add_argument_group('Arguments for cache warming')
45 group.add_argument('--search-only', action='store_const', dest='target',
47 help="Only pre-warm tables for search queries")
48 group.add_argument('--reverse-only', action='store_const', dest='target',
50 help="Only pre-warm tables for reverse queries")
51 group = parser.add_argument_group('Arguments for index anaysis')
52 mgroup = group.add_mutually_exclusive_group()
53 mgroup.add_argument('--osm-id', type=str,
54 help='Analyse indexing of the given OSM object')
55 mgroup.add_argument('--place-id', type=int,
56 help='Analyse indexing of the given Nominatim object')
58 def run(self, args: NominatimArgs) -> int:
60 return self._warm(args)
62 if args.check_database:
63 LOG.warning('Checking database')
64 from ..tools import check_database
65 return check_database.check_database(args.config)
67 if args.analyse_indexing:
68 LOG.warning('Analysing performance of indexing function')
69 from ..tools import admin
70 admin.analyse_indexing(args.config, osm_id=args.osm_id, place_id=args.place_id)
74 LOG.warning('Checking for necessary database migrations')
75 from ..tools import migration
76 return migration.migrate(args.config, args)
78 if args.collect_os_info:
79 LOG.warning("Reporting System Information")
80 from ..tools import collect_os_info
81 collect_os_info.report_system_information(args.config)
87 def _warm(self, args: NominatimArgs) -> int:
88 LOG.warning('Warming database caches')
90 api = napi.NominatimAPI(args.project_dir)
92 if args.target != 'reverse':
94 api.reverse((random.uniform(-90, 90), random.uniform(-180, 180)),
97 if args.target != 'search':
98 from ..tokenizer import factory as tokenizer_factory
100 tokenizer = tokenizer_factory.get_tokenizer_for_db(args.config)
101 with connect(args.config.get_libpq_dsn()) as conn:
102 words = tokenizer.most_frequent_words(conn, 1000)