File: ContainerRegistry.py

package info (click to toggle)
uranium 5.0.0-9
  • links: PTS, VCS
  • area: main
  • in suites: forky, sid
  • size: 5,328 kB
  • sloc: python: 31,765; sh: 132; makefile: 12
file content (892 lines) | stat: -rw-r--r-- 43,887 bytes parent folder | download | duplicates (2)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703
704
705
706
707
708
709
710
711
712
713
714
715
716
717
718
719
720
721
722
723
724
725
726
727
728
729
730
731
732
733
734
735
736
737
738
739
740
741
742
743
744
745
746
747
748
749
750
751
752
753
754
755
756
757
758
759
760
761
762
763
764
765
766
767
768
769
770
771
772
773
774
775
776
777
778
779
780
781
782
783
784
785
786
787
788
789
790
791
792
793
794
795
796
797
798
799
800
801
802
803
804
805
806
807
808
809
810
811
812
813
814
815
816
817
818
819
820
821
822
823
824
825
826
827
828
829
830
831
832
833
834
835
836
837
838
839
840
841
842
843
844
845
846
847
848
849
850
851
852
853
854
855
856
857
858
859
860
861
862
863
864
865
866
867
868
869
870
871
872
873
874
875
876
877
878
879
880
881
882
883
884
885
886
887
888
889
890
891
892
# Copyright (c) 2022 Ultimaker B.V.
# Uranium is released under the terms of the LGPLv3 or higher.

import gc
import re  # For finding containers with asterisks in the constraints and for detecting backup files.
import time
import sqlite3 as db
from typing import Any, cast, Dict, List, Optional, Set, Type, TYPE_CHECKING
import os
import UM.Dictionary
import UM.FlameProfiler
from UM.LockFile import LockFile
from UM.Logger import Logger
from UM.MimeTypeDatabase import MimeType, MimeTypeDatabase
from UM.PluginRegistry import PluginRegistry  # To register the container type plug-ins and container provider plug-ins.
from UM.Resources import Resources
from UM.Settings.EmptyInstanceContainer import EmptyInstanceContainer
from UM.Settings.ContainerFormatError import ContainerFormatError
from UM.Settings.ContainerProvider import ContainerProvider
from UM.Settings.constant_instance_containers import empty_container
from . import ContainerQuery
from UM.Settings.ContainerStack import ContainerStack
from UM.Settings.DefinitionContainer import DefinitionContainer
from UM.Settings.InstanceContainer import InstanceContainer
from UM.Settings.Interfaces import ContainerInterface, ContainerRegistryInterface, DefinitionContainerInterface
from UM.Signal import Signal, signalemitter
from .DatabaseContainerMetadataController import DatabaseMetadataContainerController

if TYPE_CHECKING:
    from UM.PluginObject import PluginObject
    from UM.Qt.QtApplication import QtApplication


metadata_type = Dict[str, Any]


@signalemitter
class ContainerRegistry(ContainerRegistryInterface):
    """Central class to manage all setting providers.

    This class aggregates all data from all container providers. If only the
    metadata is used, it requests the metadata lazily from the providers. If
    more than that is needed, the entire container is requested from the
    appropriate providers.
    """

    def __init__(self, application: "QtApplication") -> None:
        if ContainerRegistry.__instance is not None:
            raise RuntimeError("Try to create singleton '%s' more than once" % self.__class__.__name__)

        super().__init__()
        ContainerRegistry.__instance = self

        self._application = application  # type: QtApplication

        self._emptyInstanceContainer = empty_container  # type: InstanceContainer

        # Sorted list of container providers (keep it sorted by sorting each time you add one!).
        self._providers = []  # type: List[ContainerProvider]
        PluginRegistry.addType("container_provider", self.addProvider)

        self.metadata = {}  # type: Dict[str, metadata_type]
        self._containers = {}  # type: Dict[str, ContainerInterface]
        self._wrong_container_ids = set() # type: Set[str]  # Set of already known wrong containers that must be skipped
        self.source_provider = {}  # type: Dict[str, Optional[ContainerProvider]]  # Where each container comes from.
        # Ensure that the empty container is added to the ID cache.
        self.metadata["empty"] = self._emptyInstanceContainer.getMetaData()
        self._containers["empty"] = self._emptyInstanceContainer
        self.source_provider["empty"] = None
        self._resource_types = {"definition": Resources.DefinitionContainers}  # type: Dict[str, int]

        # Since queries are based on metadata, we need to make sure to clear the cache when a container's metadata
        # changes.
        self.containerMetaDataChanged.connect(self._clearQueryCache)

        # We use a database to store the metadata so that we don't have to extract them from the files every time
        # the application starts. Reading the data from a lot of files is especially slow on Windows; about 30x as slow.
        self._db_connection: Optional[db.Connection] = None

        # Since each container that we can store in the database has different metadata (and thus needs different logic
        # to extract it from the database again), we use database controllers to do that. These are set by type; Each
        # type of container needs to have their own controller.
        self._database_handlers: Dict[str, DatabaseMetadataContainerController] = {}

        self._explicit_read_only_container_ids = set()  # type: Set[str]

    containerAdded = Signal()
    containerRemoved = Signal()
    containerMetaDataChanged = Signal()
    containerLoadComplete = Signal()
    allMetadataLoaded = Signal()

    def addResourceType(self, resource_type: int, container_type: str) -> None:
        self._resource_types[container_type] = resource_type

    def getResourceTypes(self) -> Dict[str, int]:
        """Returns all resource types."""

        return self._resource_types

    def getDefaultSaveProvider(self) -> "ContainerProvider":
        if len(self._providers) == 1:
            return self._providers[0]
        raise NotImplementedError("Not implemented default save provider for multiple providers")

    def addWrongContainerId(self, wrong_container_id: str) -> None:
        """This method adds the current id to the list of wrong containers that are skipped when looking for a container"""

        self._wrong_container_ids.add(wrong_container_id)

    def addProvider(self, provider: ContainerProvider) -> None:
        """Adds a container provider to search through containers in."""

        self._providers.append(provider)
        # Re-sort every time. It's quadratic, but there shouldn't be that many providers anyway...
        self._providers.sort(key = lambda provider: PluginRegistry.getInstance().getMetaData(provider.getPluginId())["container_provider"].get("priority", 0))

    def findDefinitionContainers(self, **kwargs: Any) -> List[DefinitionContainerInterface]:
        """Find all DefinitionContainer objects matching certain criteria.

        :param dict kwargs: A dictionary of keyword arguments containing
        keys and values that need to match the metadata of the
        DefinitionContainer. An asterisk in the values can be used to denote a
        wildcard.
        """

        return cast(List[DefinitionContainerInterface], self.findContainers(container_type = DefinitionContainer, **kwargs))

    def findDefinitionContainersMetadata(self, **kwargs: Any) -> List[Dict[str, Any]]:
        """Get the metadata of all definition containers matching certain criteria.

        :param kwargs: A dictionary of keyword arguments containing keys and
        values that need to match the metadata. An asterisk in the values can be
        used to denote a wildcard.
        :return: A list of metadata dictionaries matching the search criteria, or
        an empty list if nothing was found.
        """

        return self.findContainersMetadata(container_type = DefinitionContainer, **kwargs)

    def findInstanceContainers(self, **kwargs: Any) -> List[InstanceContainer]:
        """Find all InstanceContainer objects matching certain criteria.

        :param kwargs: A dictionary of keyword arguments containing
        keys and values that need to match the metadata of the
        InstanceContainer. An asterisk in the values can be used to denote a
        wildcard.
        """

        return cast(List[InstanceContainer], self.findContainers(container_type = InstanceContainer, **kwargs))

    def findInstanceContainersMetadata(self, **kwargs: Any) -> List[metadata_type]:
        """Find the metadata of all instance containers matching certain criteria.

        :param kwargs: A dictionary of keyword arguments containing keys and
        values that need to match the metadata. An asterisk in the values can be
        used to denote a wildcard.
        :return: A list of metadata dictionaries matching the search criteria, or
        an empty list if nothing was found.
        """

        return self.findContainersMetadata(container_type = InstanceContainer, **kwargs)

    def findContainerStacks(self, **kwargs: Any) -> List[ContainerStack]:
        """Find all ContainerStack objects matching certain criteria.

        :param kwargs: A dictionary of keyword arguments containing
        keys and values that need to match the metadata of the ContainerStack.
        An asterisk in the values can be used to denote a wildcard.
        """

        return cast(List[ContainerStack], self.findContainers(container_type = ContainerStack, **kwargs))

    def findContainerStacksMetadata(self, **kwargs: Any) -> List[metadata_type]:
        """Find the metadata of all container stacks matching certain criteria.

        :param kwargs: A dictionary of keyword arguments containing keys and
        values that need to match the metadata. An asterisk in the values can be
        used to denote a wildcard.
        :return: A list of metadata dictionaries matching the search criteria, or
        an empty list if nothing was found.
        """

        return self.findContainersMetadata(container_type = ContainerStack, **kwargs)

    @UM.FlameProfiler.profile
    def findContainers(self, *, ignore_case: bool = False, **kwargs: Any) -> List[ContainerInterface]:
        """Find all container objects matching certain criteria.

        :param container_type: If provided, return only objects that are
        instances or subclasses of container_type.
        :param kwargs: A dictionary of keyword arguments containing
        keys and values that need to match the metadata of the container. An
        asterisk can be used to denote a wildcard.

        :return: A list of containers matching the search criteria, or an empty
        list if nothing was found.
        """

        # Find the metadata of the containers and grab the actual containers from there.
        results_metadata = self.findContainersMetadata(ignore_case = ignore_case, **kwargs)
        result = []
        for metadata in results_metadata:
            if metadata["id"] in self._containers:  # Already loaded, so just return that.
                result.append(self._containers[metadata["id"]])
            else:  # Metadata is loaded, but not the actual data.
                if metadata["id"] in self._wrong_container_ids:
                    Logger.logException("e", "Error when loading container {container_id}: This is a weird container, probably some file is missing".format(container_id = metadata["id"]))
                    continue
                provider = self.source_provider[metadata["id"]]
                if not provider:
                    Logger.log("w", "The metadata of container {container_id} was added during runtime, but no accompanying container was added.".format(container_id = metadata["id"]))
                    continue
                try:
                    new_container = provider.loadContainer(metadata["id"])
                except ContainerFormatError as e:
                    Logger.logException("e", "Error in the format of container {container_id}: {error_msg}".format(container_id = metadata["id"], error_msg = str(e)))
                    continue
                except Exception as e:
                    Logger.logException("e", "Error when loading container {container_id}: {error_msg}".format(container_id = metadata["id"], error_msg = str(e)))
                    continue
                self.addContainer(new_container)
                self.containerLoadComplete.emit(new_container.getId())
                result.append(new_container)
        return result

    def findContainersMetadata(self, *, ignore_case: bool = False, **kwargs: Any) -> List[metadata_type]:
        """Find the metadata of all container objects matching certain criteria.

        :param container_type: If provided, return only objects that are
        instances or subclasses of ``container_type``.
        :param kwargs: A dictionary of keyword arguments containing keys and
        values that need to match the metadata. An asterisk can be used to
        denote a wildcard.
        :return: A list of metadata dictionaries matching the search criteria, or
        an empty list if nothing was found.
        """

        candidates = None
        if "id" in kwargs and kwargs["id"] is not None and "*" not in kwargs["id"] and not ignore_case:
            if kwargs["id"] not in self.metadata:  # If we're looking for an unknown ID, try to lazy-load that one.
                if kwargs["id"] not in self.source_provider:
                    for candidate in self._providers:
                        if kwargs["id"] in candidate.getAllIds():
                            self.source_provider[kwargs["id"]] = candidate
                            break
                    else:
                        return []
                provider = self.source_provider[kwargs["id"]]
                if not provider:
                    Logger.log("w", "Metadata of container {container_id} is missing even though the container is added during run-time.")
                    return []
                metadata = provider.loadMetadata(kwargs["id"])
                if metadata is None or metadata.get("id", "") in self._wrong_container_ids or "id" not in metadata:
                    return []
                self.metadata[metadata["id"]] = metadata
                self.source_provider[metadata["id"]] = provider

            # Since IDs are the primary key and unique we can now simply request the candidate and check if it matches all requirements.
            if kwargs["id"] not in self.metadata:
                return []  # Still no result, so return an empty list.
            if len(kwargs) == 1:
                return [self.metadata[kwargs["id"]]]
            candidates = [self.metadata[kwargs["id"]]]
            del kwargs["id"]  # No need to check for the ID again.

        query = ContainerQuery.ContainerQuery(self, ignore_case = ignore_case, **kwargs)
        query.execute(candidates = candidates)

        return cast(List[metadata_type], query.getResult())  # As the execute of the query is done, result won't be none.

    def findDirtyContainers(self, *, ignore_case: bool = False, **kwargs: Any) -> List[ContainerInterface]:
        """Specialized find function to find only the modified container objects
        that also match certain criteria.

        This is faster than the normal find methods since it won't ever load all
        containers, but only the modified ones. Since containers must be fully
        loaded before they are modified, you are guaranteed that any operations
        on the resulting containers will not trigger additional containers to
        load lazily.

        :param kwargs: A dictionary of keyword arguments containing
        keys and values that need to match the metadata of the container. An
        asterisk can be used to denote a wildcard.
        :param ignore_case: Whether casing should be ignored when matching string
        values of metadata.
        :return: A list of containers matching the search criteria, or an empty
        list if nothing was found.
        """

        # Find the metadata of the containers and grab the actual containers from there.
        #
        # We could apply the "is in self._containers" filter and the "isDirty" filter
        # to this metadata find function as well to filter earlier, but since the
        # filters in findContainersMetadata are applied in arbitrary order anyway
        # this will have very little effect except to prevent a list copy.
        results_metadata = self.findContainersMetadata(ignore_case = ignore_case, **kwargs)

        result = []
        for metadata in results_metadata:
            if metadata["id"] not in self._containers:  # Not yet loaded, so it can't be dirty.
                continue
            candidate = self._containers[metadata["id"]]
            if candidate.isDirty():
                result.append(self._containers[metadata["id"]])
        return result

    def getEmptyInstanceContainer(self) -> InstanceContainer:
        """This is a small convenience to make it easier to support complex structures in ContainerStacks."""

        return self._emptyInstanceContainer

    def setExplicitReadOnly(self, container_id: str) -> None:
        self._explicit_read_only_container_ids.add(container_id)

    def isExplicitReadOnly(self, container_id: str) -> bool:
        return container_id in self._explicit_read_only_container_ids

    def isReadOnly(self, container_id: str) -> bool:
        """Returns whether a profile is read-only or not.

        Whether it is read-only depends on the source where the container is
        obtained from.
        :return: True if the container is read-only, or False if it can be
        modified.
        """

        if self.isExplicitReadOnly(container_id):
            return True
        provider = self.source_provider.get(container_id)
        if not provider:
            return False  # If no provider had the container, that means that the container was only in memory. Then it's always modifiable.
        return provider.isReadOnly(container_id)

    # Gets the container file path with for the container with the given ID. Returns None if the container/file doesn't
    # exist.
    def getContainerFilePathById(self, container_id: str) -> Optional[str]:
        provider = self.source_provider.get(container_id)
        if not provider:
            return None
        return provider.getContainerFilePathById(container_id)

    def isLoaded(self, container_id: str) -> bool:
        """Returns whether a container is completely loaded or not.

        If only its metadata is known, it is not yet completely loaded.
        :return: True if all data about this container is known, False if only
        metadata is known or the container is completely unknown.
        """

        return container_id in self._containers

    def _createDatabaseFile(self, db_path: str) -> db.Connection:
        connection = db.Connection(db_path)
        cursor = connection.cursor()
        cursor.executescript("""
            CREATE TABLE containers(
                id text,
                name text,
                last_modified integer,
                container_type text
            );
            CREATE UNIQUE INDEX idx_containers_id on containers (id);
        """)

        for handler in self._database_handlers.values():
            handler.setupTable(cursor)

        return connection

    def _getDatabaseConnection(self) -> db.Connection:
        if self._db_connection is not None:
            return self._db_connection
        db_path = os.path.join(Resources.getCacheStoragePath(), "containers.db")
        if not os.path.exists(db_path):
            self._db_connection = self._createDatabaseFile(db_path)
            return self._db_connection
        self._db_connection = db.Connection(db_path)
        return self._db_connection

    def _getProfileType(self, container_id: str, db_cursor: db.Cursor) -> Optional[str]:
        db_cursor.execute("select id, container_type from containers where id = ?", (container_id, ))
        row = db_cursor.fetchone()
        if row:
            return row[1]
        return None

    def _recreateCorruptDataBase(self, cursor: Optional[db.Cursor]) -> None:
        """Closes the Database, removes the file from cache and recreate all metadata from scratch"""
        if not cursor:
            self.loadAllMetadata()
            return
        try:
            cursor.execute("rollback")  # Cancel any ongoing transaction.
        except:
            # Could be that the cursor is already closed
            pass
        cursor.close()

        self._db_connection = None
        db_path = os.path.join(Resources.getCacheStoragePath(), "containers.db")
        try:
            os.remove(db_path)
        except EnvironmentError:  # Was already deleted by rollback.
            pass

        self.loadAllMetadata()

    def _getProfileModificationTime(self, container_id: str, db_cursor: db.Cursor) -> Optional[float]:
        db_cursor.execute("select id, last_modified from containers where id = ?", (container_id, ))
        row = db_cursor.fetchone()

        if row:
            return row[1]
        return None

    def _addMetadataToDatabase(self, metadata: metadata_type) -> None:
        container_type = metadata["type"]
        if container_type in self._database_handlers:
            try:
                self._database_handlers[container_type].insert(metadata)
            except db.DatabaseError as e:
                Logger.warning(f"Removing corrupt database and recreating database. {e}")
                self._recreateCorruptDataBase(self._database_handlers[container_type].cursor)

    def _updateMetadataInDatabase(self, metadata: metadata_type) -> None:
        container_type = metadata["type"]
        if container_type in self._database_handlers:
            try:
                self._database_handlers[container_type].update(metadata)
            except db.DatabaseError as e:
                Logger.warning(f"Removing corrupt database and recreating database. {e}")
                self._recreateCorruptDataBase(self._database_handlers[container_type].cursor)

    def _getMetadataFromDatabase(self, container_id: str, container_type: str) -> metadata_type:
        if container_type in self._database_handlers:
            return self._database_handlers[container_type].getMetadata(container_id)
        return {}

    def loadAllMetadata(self) -> None:
        """Load the metadata of all available definition containers, instance
        containers and container stacks.
        """

        cursor = self._getDatabaseConnection().cursor()
        for handlers in self._database_handlers.values():
            handlers.cursor = cursor

        self._clearQueryCache()
        gc.disable()
        resource_start_time = time.time()

        # Since it could well be that we have to make a *lot* of changes to the database, we want to do that in
        # a single transaction to speed it up.
        cursor.execute("begin")
        all_container_ids = set()
        for provider in self._providers:  # Automatically sorted by the priority queue.
            # Make copy of all IDs since it might change during iteration.
            provider_container_ids = set(provider.getAllIds())
            # Keep a list of all the ID's that we know off
            all_container_ids.update(provider_container_ids)
            for container_id in provider_container_ids:
                try:
                    db_last_modified_time = self._getProfileModificationTime(container_id, cursor)
                except db.DatabaseError as e:
                    Logger.warning(f"Removing corrupt database and recreating database. {e}")
                    self._recreateCorruptDataBase(cursor)
                    cursor = self._getDatabaseConnection().cursor()  # After recreating the database, all the cursors have changed.
                    cursor.execute("begin")
                    db_last_modified_time = self._getProfileModificationTime(container_id, cursor)
                if db_last_modified_time is None:
                    # Item is not yet in the database. Add it now!
                    metadata = provider.loadMetadata(container_id)
                    if not self._isMetadataValid(metadata):
                        Logger.log("w", f"Invalid metadata for container {container_id}: {metadata}")
                        continue
                    modified_time = provider.getLastModifiedTime(container_id)
                    if metadata.get("type") in self._database_handlers:
                        # Only add it to the database if we have an actual handler.
                        try:
                            cursor.execute(
                                "INSERT INTO containers (id, name, last_modified, container_type) VALUES (?, ?, ?, ?)",
                                (container_id, metadata["name"], modified_time, metadata["type"]))
                        except db.DatabaseError as e:
                            Logger.warning(f"Unable to edit database to insert new cache records for containers, recreating database: {str(e)}")
                            self._recreateCorruptDataBase(self._database_handlers[metadata["type"]].cursor)
                            cursor = self._getDatabaseConnection().cursor()  # After recreating the database, all the cursors have changed.
                            cursor.execute("begin")
                        self._addMetadataToDatabase(metadata)

                    self.metadata[container_id] = metadata
                    self.source_provider[container_id] = provider

                else:
                    # Metadata already exists in database.
                    modified_time = provider.getLastModifiedTime(container_id)
                    if modified_time > db_last_modified_time:
                        # Metadata is outdated, so load from file and update the database
                        metadata = provider.loadMetadata(container_id)
                        try:
                            cursor.execute("UPDATE containers SET name = ?, last_modified = ?, container_type = ? WHERE id = ?", (metadata["name"], modified_time, metadata["type"], metadata["id"]))
                        except db.DatabaseError as e:
                            Logger.warning(f"Unable to update timestamp of container cache in database, recreating database: {str(e)}")
                            self._recreateCorruptDataBase(self._database_handlers[metadata["type"]].cursor)
                            cursor = self._getDatabaseConnection().cursor()  # After recreating the database, all the cursors have changed.
                            cursor.execute("begin")
                        self._updateMetadataInDatabase(metadata)
                        self.metadata[container_id] = metadata
                        self.source_provider[container_id] = provider
                        continue

                    # Since we know that the container exists, we also know that it will never be None.
                    container_type = cast(str, self._getProfileType(container_id, cursor))

                    # No need to do any file reading, we can just get it from the database.
                    self.metadata[container_id] = self._getMetadataFromDatabase(container_id, container_type)
                    self.source_provider[container_id] = provider

        cursor.execute("commit")

        # Find all ID's that we currently have in the database
        cursor.execute("SELECT id from containers")
        all_ids_in_database = {container_id[0] for container_id in cursor.fetchall()}
        ids_to_remove = all_ids_in_database - all_container_ids

        # Purge ID's that don't have a matching file
        for container_id in ids_to_remove:
            cursor.execute("DELETE FROM containers WHERE id = ?", (container_id,))
            self._removeContainerFromDatabase(container_id)

        if ids_to_remove:  # We only can (and need to) commit again if we removed containers
            cursor.execute("commit")

        Logger.log("d", "Loading metadata into container registry took %s seconds", time.time() - resource_start_time)
        gc.enable()
        ContainerRegistry.allMetadataLoaded.emit()

    def _removeContainerFromDatabase(self, container_id: str) -> None:
        for database_handler in self._database_handlers.values():
            database_handler.delete(container_id)

    @UM.FlameProfiler.profile
    def load(self) -> None:
        """Load all available definition containers, instance containers and
        container stacks.

        :note This method does not clear the internal list of containers. This means that any containers
        that were already added when the first call to this method happened will not be re-added.
        """

        # Disable garbage collection to speed up the loading (at the cost of memory usage).
        gc.disable()
        resource_start_time = time.time()

        with self.lockCache():  # Because we might be writing cache files.
            for provider in self._providers:
                for container_id in list(provider.getAllIds()):  # Make copy of all IDs since it might change during iteration.
                    if container_id not in self._containers:
                        # Update UI while loading.
                        self._application.processEvents()  # Update the user interface because loading takes a while. Specifically the loading screen.
                        try:
                            self._containers[container_id] = provider.loadContainer(container_id)
                        except:
                            Logger.logException("e", "Failed to load container %s", container_id)
                            raise
                        self.metadata[container_id] = self._containers[container_id].getMetaData()
                        self.source_provider[container_id] = provider
                        self.containerLoadComplete.emit(container_id)

        gc.enable()
        Logger.log("d", "Loading data into container registry took %s seconds", time.time() - resource_start_time)

    @UM.FlameProfiler.profile
    def addContainer(self, container: ContainerInterface) -> bool:
        container_id = container.getId()
        if container_id in self._containers:
            return True  # Container was already there, consider that a success

        if hasattr(container, "metaDataChanged"):
            container.metaDataChanged.connect(self._onContainerMetaDataChanged)

        self.metadata[container_id] = container.getMetaData()
        self._containers[container_id] = container
        if container_id not in self.source_provider:
            self.source_provider[container_id] = None  # Added during runtime.
        self._clearQueryCacheByContainer(container)

        # containerAdded is a custom signal and can trigger direct calls to its subscribers. This should be avoided
        # because with the direct calls, the subscribers need to know everything about what it tries to do to avoid
        # triggering this signal again, which eventually can end up exceeding the max recursion limit.
        # We avoid the direct calls here to make sure that the subscribers do not need to take into account any max
        # recursion problem.
        self._application.callLater(self.containerAdded.emit, container)
        return True

    @UM.FlameProfiler.profile
    def removeContainer(self, container_id: str) -> None:
        # Here we only need to check metadata because a container may not be loaded but its metadata must have been
        # loaded first.
        if container_id not in self.metadata:
            Logger.log("w", "Tried to delete container {container_id}, which doesn't exist or isn't loaded.".format(container_id = container_id))
            return  # Ignore.

        # CURA-6237
        # Do not try to operate on invalid containers because removeContainer() needs to load it if it's not loaded yet
        # (see below), but an invalid container cannot be loaded.
        if container_id in self._wrong_container_ids:
            Logger.log("w", "Container [%s] is faulty, it won't be able to be loaded, so no need to remove, skip.")
            # delete the metadata if present
            if container_id in self.metadata:
                del self.metadata[container_id]
            return

        container = None
        if container_id in self._containers:
            container = self._containers[container_id]
            if hasattr(container, "metaDataChanged"):
                container.metaDataChanged.disconnect(self._onContainerMetaDataChanged)
            del self._containers[container_id]
        if container_id in self.metadata:
            if container is None:
                # We're in a bit of a weird state now. We want to notify the rest of the code that the container
                # has been deleted, but due to lazy loading, it hasn't been loaded yet. The issues is that in order
                # to notify the rest of the code, we need to actually *have* the container. So an empty instance 
                # container is created, which is emitted with the containerRemoved signal and contains the metadata
                container = EmptyInstanceContainer(container_id)
                container.metaData = self.metadata[container_id]
            del self.metadata[container_id]
        if container_id in self.source_provider:
            if self.source_provider[container_id] is not None:
                cast(ContainerProvider, self.source_provider[container_id]).removeContainer(container_id)
            del self.source_provider[container_id]

        if container is not None:
            self._clearQueryCacheByContainer(container)
            self.containerRemoved.emit(container)

        Logger.log("d", "Removed container %s", container_id)

    @UM.FlameProfiler.profile
    def renameContainer(self, container_id: str, new_name: str, new_id: Optional[str] = None) -> None:
        Logger.log("d", "Renaming container %s to %s", container_id, new_name)
        # Same as removeContainer(), metadata is always loaded but containers may not, so always check metadata.
        if container_id not in self.metadata:
            Logger.log("w", "Unable to rename container %s, because it does not exist", container_id)
            return

        container = self._containers.get(container_id)
        if container is None:
            container = self.findContainers(id = container_id)[0]
        container = cast(ContainerInterface, container)

        if new_name == container.getName():
            Logger.log("w", "Unable to rename container %s, because the name (%s) didn't change", container_id, new_name)
            return

        self.containerRemoved.emit(container)

        try:
            container.setName(new_name) #type: ignore
        except TypeError: #Some containers don't allow setting the name.
            return
        if new_id is not None:
            source_provider = self.source_provider[container.getId()]
            del self._containers[container.getId()]
            del self.metadata[container.getId()]
            del self.source_provider[container.getId()]
            if source_provider is not None:
                source_provider.removeContainer(container.getId())
            container.getMetaData()["id"] = new_id
            self._containers[container.getId()] = container
            self.metadata[container.getId()] = container.getMetaData()
            self.source_provider[container.getId()] = None  # to be saved with saveSettings

        self._clearQueryCacheByContainer(container)
        self.containerAdded.emit(container)

    @UM.FlameProfiler.profile
    def uniqueName(self, original: str) -> str:
        """Creates a new unique name for a container that doesn't exist yet.

        It tries if the original name you provide exists, and if it doesn't
        it'll add a "        1" or "        2" after the name to make it unique.

        :param original: The original name that may not be unique.
        :return: A unique name that looks a lot like the original but may have
        a number behind it to make it unique.
        """

        original = original.replace("*", "")  # Filter out wildcards, since this confuses the ContainerQuery.
        name = original.strip()

        num_check = re.compile(r"(.*?)\s*#\d+$").match(name)
        if num_check: #There is a number in the name.
            name = num_check.group(1) #Filter out the number.

        if not name: #Wait, that deleted everything!
            name = "Profile"
        elif not self.findContainersMetadata(id = original.strip(), ignore_case = True) and not self.findContainersMetadata(name = original.strip()):
            # Check if the stripped version of the name is unique (note that this can still have the number in it)
            return original.strip()

        unique_name = name
        i = 1
        while self.findContainersMetadata(id = unique_name, ignore_case = True) or self.findContainersMetadata(name = unique_name): #A container already has this name.
            i += 1 #Try next numbering.
            unique_name = "%s #%d" % (name, i) #Fill name like this: "Extruder #2".
        return unique_name

    @classmethod
    def addContainerType(cls, container: "PluginObject") -> None:
        """Add a container type that will be used to serialize/deserialize containers.

        :param container: An instance of the container type to add.
        """

        plugin_id = container.getPluginId()
        metadata = PluginRegistry.getInstance().getMetaData(plugin_id)
        if "settings_container" not in metadata or "mimetype" not in metadata["settings_container"]:
            raise Exception("Plugin {plugin} has incorrect metadata: Expected a 'settings_container' block with a 'mimetype' entry".format(plugin = plugin_id))
        cls.addContainerTypeByName(container.__class__, plugin_id, metadata["settings_container"]["mimetype"])

    @classmethod
    def addContainerTypeByName(cls, container_type: type, type_name: str, mime_type: str) -> None:
        """Used to associate mime types with object to be created
        :param container_type:  ContainerStack or derivative
        :param type_name:
        :param mime_type:
        """

        cls.__container_types[type_name] = container_type
        cls.mime_type_map[mime_type] = container_type

    @classmethod
    def getMimeTypeForContainer(cls, container_type: type) -> Optional[MimeType]:
        """Retrieve the mime type corresponding to a certain container type

        :param container_type: The type of container to get the mime type for.

        :return: A MimeType object that matches the mime type of the container or None if not found.
        """

        try:
            mime_type_name = UM.Dictionary.findKey(cls.mime_type_map, container_type)
            if mime_type_name:
                return MimeTypeDatabase.getMimeType(mime_type_name)
        except ValueError:
            Logger.log("w", "Unable to find mimetype for container %s", container_type)
        return None

    @classmethod
    def getContainerForMimeType(cls, mime_type: MimeType) -> Optional[Type[ContainerInterface]]:
        """Get the container type corresponding to a certain mime type.

        :param mime_type: The mime type to get the container type for.

        :return: A class object of a container type that corresponds to the specified mime type or None if not found.
        """

        return cls.mime_type_map.get(mime_type.name, None)

    @classmethod
    def getContainerTypes(cls):
        """Get all the registered container types

        :return: A dictionary view object that provides access to the container types.
        The key is the plugin ID, the value the container type.
        """

        return cls.__container_types.items()

    def saveContainer(self, container: "ContainerInterface", provider: Optional["ContainerProvider"] = None) -> None:
        """Save single dirty container"""

        if not hasattr(provider, "saveContainer"):
            provider = self.getDefaultSaveProvider()
        if not container.isDirty():
            return

        provider.saveContainer(container) #type: ignore
        container.setDirty(False)
        self.source_provider[container.getId()] = provider

    def saveDirtyContainers(self) -> None:
        """Save all the dirty containers by calling the appropriate container providers"""

        # Lock file for "more" atomically loading and saving to/from config dir.
        with self.lockFile():
            for instance in self.findDirtyContainers(container_type = InstanceContainer):
                self.saveContainer(instance)

            for stack in self.findContainerStacks():
                self.saveContainer(stack)

    # Clear the internal query cache
    def _clearQueryCache(self, *args: Any, **kwargs: Any) -> None:
        ContainerQuery.ContainerQuery.cache.clear()

    def _clearQueryCacheByContainer(self, container: ContainerInterface) -> None:
        """Clear the query cache by using container type.
        This is a slightly smarter way of clearing the cache. Only queries that are of the same type (or without one)
        are cleared.
        """

        # Remove all case-insensitive matches since we won't find those with the below "<=" subset check.
        # TODO: Properly check case-insensitively in the dict's values.
        for key in list(ContainerQuery.ContainerQuery.cache):
            if not key[0]:
                del ContainerQuery.ContainerQuery.cache[key]

        # Remove all cache items that this container could fall in.
        for key in list(ContainerQuery.ContainerQuery.cache):
            query_metadata = dict(zip(key[1::2], key[2::2]))
            if query_metadata.items() <= container.getMetaData().items():
                del ContainerQuery.ContainerQuery.cache[key]

    def _onContainerMetaDataChanged(self, *args: ContainerInterface, **kwargs: Any) -> None:
        """Called when any container's metadata changed.

        This function passes it on to the containerMetaDataChanged signal. Sadly
        that doesn't work automatically between pyqtSignal and UM.Signal.
        """

        container = args[0]
        # Always emit containerMetaDataChanged, even if the dictionary didn't actually change: The contents of the dictionary might have changed in-place!
        self.metadata[container.getId()] = container.getMetaData()  # refresh the metadata
        self.containerMetaDataChanged.emit(*args, **kwargs)

    def _isMetadataValid(self, metadata: Optional[metadata_type]) -> bool:
        """Validate a metadata object.

        If the metadata is invalid, the container is not allowed to be in the
        registry.
        :param metadata: A metadata object.
        :return: Whether this metadata was valid.
        """

        return metadata is not None

    def getLockFilename(self) -> str:
        """Get the lock filename including full path
        Dependent on when you call this function, Resources.getConfigStoragePath may return different paths
        """

        return Resources.getStoragePath(Resources.Resources, self._application.getApplicationLockFilename())

    def getCacheLockFilename(self) -> str:
        """Get the cache lock filename including full path."""

        return Resources.getStoragePath(Resources.Cache, self._application.getApplicationLockFilename())

    def lockFile(self) -> LockFile:
        """Contextmanager to create a lock file and remove it afterwards."""

        return LockFile(
            self.getLockFilename(),
            timeout = 10,
            wait_msg = "Waiting for lock file in local config dir to disappear..."
            )

    def lockCache(self) -> LockFile:
        """Context manager to create a lock file for the cache directory and remove
        it afterwards.
        """

        return LockFile(
            self.getCacheLockFilename(),
            timeout = 10,
            wait_msg = "Waiting for lock file in cache directory to disappear."
        )

    __container_types = {
        "definition": DefinitionContainer,
        "instance": InstanceContainer,
        "stack": ContainerStack,
    }

    mime_type_map = {
        "application/x-uranium-definitioncontainer": DefinitionContainer,
        "application/x-uranium-instancecontainer": InstanceContainer,
        "application/x-uranium-containerstack": ContainerStack,
        "application/x-uranium-extruderstack": ContainerStack
    }  # type: Dict[str, Type[ContainerInterface]]

    __instance = None  # type: ContainerRegistry

    @classmethod
    def getInstance(cls, *args, **kwargs) -> "ContainerRegistry":
        return cls.__instance


PluginRegistry.addType("settings_container", ContainerRegistry.addContainerType)