forked from mlflow/mlflow
-
Notifications
You must be signed in to change notification settings - Fork 0
/
sqlalchemy_store.py
839 lines (764 loc) · 37.7 KB
/
sqlalchemy_store.py
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
import time
import logging
import sqlalchemy
from mlflow.entities.model_registry.model_version_stages import (
get_canonical_stage,
ALL_STAGES,
DEFAULT_STAGES_FOR_GET_LATEST_VERSIONS,
STAGE_DELETED_INTERNAL,
STAGE_ARCHIVED,
)
from mlflow.exceptions import MlflowException
from mlflow.protos.databricks_pb2 import (
INVALID_PARAMETER_VALUE,
RESOURCE_ALREADY_EXISTS,
INVALID_STATE,
RESOURCE_DOES_NOT_EXIST,
)
import mlflow.store.db.utils
from mlflow.store.model_registry import (
SEARCH_REGISTERED_MODEL_MAX_RESULTS_DEFAULT,
SEARCH_REGISTERED_MODEL_MAX_RESULTS_THRESHOLD,
)
from mlflow.store.db.base_sql_model import Base
from mlflow.store.entities.paged_list import PagedList
from mlflow.store.model_registry.abstract_store import AbstractStore
from mlflow.store.model_registry.dbmodels.models import (
SqlRegisteredModel,
SqlModelVersion,
SqlRegisteredModelTag,
SqlModelVersionTag,
)
from mlflow.utils.search_utils import SearchUtils
from mlflow.utils.uri import extract_db_type_from_uri
from mlflow.utils.validation import (
_validate_registered_model_tag,
_validate_model_version_tag,
_validate_model_name,
_validate_model_version,
_validate_tag_name,
)
_logger = logging.getLogger(__name__)
# For each database table, fetch its columns and define an appropriate attribute for each column
# on the table's associated object representation (Mapper). This is necessary to ensure that
# columns defined via backreference are available as Mapper instance attributes (e.g.,
# ``SqlRegisteredModel.model_versions``). For more information, see
# https://docs.sqlalchemy.org/en/latest/orm/mapping_api.html#sqlalchemy.orm.configure_mappers
# and https://docs.sqlalchemy.org/en/latest/orm/mapping_api.html#sqlalchemy.orm.mapper.Mapper
sqlalchemy.orm.configure_mappers()
def now():
return int(time.time() * 1000)
class SqlAlchemyStore(AbstractStore):
"""
This entity may change or be removed in a future release without warning.
SQLAlchemy compliant backend store for tracking meta data for MLflow entities. MLflow
supports the database dialects ``mysql``, ``mssql``, ``sqlite``, and ``postgresql``.
As specified in the
`SQLAlchemy docs <https://docs.sqlalchemy.org/en/latest/core/engines.html#database-urls>`_ ,
the database URI is expected in the format
``<dialect>+<driver>://<username>:<password>@<host>:<port>/<database>``. If you do not
specify a driver, SQLAlchemy uses a dialect's default driver.
This store interacts with SQL store using SQLAlchemy abstractions defined for MLflow entities.
:py:class:`mlflow.store.model_registry.models.RegisteredModel` and
:py:class:`mlflow.store.model_registry.models.ModelVersion`
"""
CREATE_MODEL_VERSION_RETRIES = 3
def __init__(self, db_uri):
"""
Create a database backed store.
:param db_uri: The SQLAlchemy database URI string to connect to the database. See
the `SQLAlchemy docs
<https://docs.sqlalchemy.org/en/latest/core/engines.html#database-urls>`_
for format specifications. Mlflow supports the dialects ``mysql``,
``mssql``, ``sqlite``, and ``postgresql``.
:param default_artifact_root: Path/URI to location suitable for large data (such as a blob
store object, DBFS path, or shared NFS file system).
"""
super().__init__()
self.db_uri = db_uri
self.db_type = extract_db_type_from_uri(db_uri)
self.engine = mlflow.store.db.utils.create_sqlalchemy_engine_with_retry(db_uri)
Base.metadata.create_all(self.engine)
# Verify that all model registry tables exist.
SqlAlchemyStore._verify_registry_tables_exist(self.engine)
Base.metadata.bind = self.engine
SessionMaker = sqlalchemy.orm.sessionmaker(bind=self.engine)
self.ManagedSessionMaker = mlflow.store.db.utils._get_managed_session_maker(
SessionMaker, self.db_type
)
# TODO: verify schema here once we add logic to initialize the registry tables if they
# don't exist (schema verification will fail in tests otherwise)
# mlflow.store.db.utils._verify_schema(self.engine)
@staticmethod
def _verify_registry_tables_exist(engine):
# Verify that all tables have been created.
inspected_tables = set(sqlalchemy.inspect(engine).get_table_names())
expected_tables = [
SqlRegisteredModel.__tablename__,
SqlModelVersion.__tablename__,
]
if any([table not in inspected_tables for table in expected_tables]):
# TODO: Replace the MlflowException with the following line once it's possible to run
# the registry against a different DB than the tracking server:
# mlflow.store.db.utils._initialize_tables(self.engine)
raise MlflowException("Database migration in unexpected state. Run manual upgrade.")
@staticmethod
def _get_eager_registered_model_query_options():
"""
:return: A list of SQLAlchemy query options that can be used to eagerly
load the following registered model attributes
when fetching a registered model: ``registered_model_tags``.
"""
# Use a subquery load rather than a joined load in order to minimize the memory overhead
# of the eager loading procedure. For more information about relationship loading
# techniques, see https://docs.sqlalchemy.org/en/13/orm/
# loading_relationships.html#relationship-loading-techniques
return [sqlalchemy.orm.subqueryload(SqlRegisteredModel.registered_model_tags)]
@staticmethod
def _get_eager_model_version_query_options():
"""
:return: A list of SQLAlchemy query options that can be used to eagerly
load the following model version attributes
when fetching a model version: ``model_version_tags``.
"""
# Use a subquery load rather than a joined load in order to minimize the memory overhead
# of the eager loading procedure. For more information about relationship loading
# techniques, see https://docs.sqlalchemy.org/en/13/orm/
# loading_relationships.html#relationship-loading-techniques
return [sqlalchemy.orm.subqueryload(SqlModelVersion.model_version_tags)]
def _save_to_db(self, session, objs):
"""
Store in db
"""
if type(objs) is list:
session.add_all(objs)
else:
# single object
session.add(objs)
def create_registered_model(self, name, tags=None, description=None):
"""
Create a new registered model in backend store.
:param name: Name of the new model. This is expected to be unique in the backend store.
:param tags: A list of :py:class:`mlflow.entities.model_registry.RegisteredModelTag`
instances associated with this registered model.
:param description: Description of the version.
:return: A single object of :py:class:`mlflow.entities.model_registry.RegisteredModel`
created in the backend.
"""
_validate_model_name(name)
for tag in tags or []:
_validate_registered_model_tag(tag.key, tag.value)
with self.ManagedSessionMaker() as session:
try:
creation_time = now()
registered_model = SqlRegisteredModel(
name=name,
creation_time=creation_time,
last_updated_time=creation_time,
description=description,
)
tags_dict = {}
for tag in tags or []:
tags_dict[tag.key] = tag.value
registered_model.registered_model_tags = [
SqlRegisteredModelTag(key=key, value=value) for key, value in tags_dict.items()
]
self._save_to_db(session, registered_model)
session.flush()
return registered_model.to_mlflow_entity()
except sqlalchemy.exc.IntegrityError as e:
raise MlflowException(
"Registered Model (name={}) already exists. " "Error: {}".format(name, str(e)),
RESOURCE_ALREADY_EXISTS,
)
@classmethod
def _get_registered_model(cls, session, name, eager=False):
"""
:param eager: If ``True``, eagerly loads the registered model's tags.
If ``False``, these attributes are not eagerly loaded and
will be loaded when their corresponding object properties
are accessed from the resulting ``SqlRegisteredModel`` object.
"""
_validate_model_name(name)
query_options = cls._get_eager_registered_model_query_options() if eager else []
rms = (
session.query(SqlRegisteredModel)
.options(*query_options)
.filter(SqlRegisteredModel.name == name)
.all()
)
if len(rms) == 0:
raise MlflowException(
"Registered Model with name={} not found".format(name), RESOURCE_DOES_NOT_EXIST
)
if len(rms) > 1:
raise MlflowException(
"Expected only 1 registered model with name={}. "
"Found {}.".format(name, len(rms)),
INVALID_STATE,
)
return rms[0]
def update_registered_model(self, name, description):
"""
Update description of the registered model.
:param name: Registered model name.
:param description: New description.
:return: A single updated :py:class:`mlflow.entities.model_registry.RegisteredModel` object.
"""
with self.ManagedSessionMaker() as session:
sql_registered_model = self._get_registered_model(session, name)
updated_time = now()
sql_registered_model.description = description
sql_registered_model.last_updated_time = updated_time
self._save_to_db(session, [sql_registered_model])
session.flush()
return sql_registered_model.to_mlflow_entity()
def rename_registered_model(self, name, new_name):
"""
Rename the registered model.
:param name: Registered model name.
:param new_name: New proposed name.
:return: A single updated :py:class:`mlflow.entities.model_registry.RegisteredModel` object.
"""
_validate_model_name(new_name)
with self.ManagedSessionMaker() as session:
sql_registered_model = self._get_registered_model(session, name)
try:
updated_time = now()
sql_registered_model.name = new_name
for sql_model_version in sql_registered_model.model_versions:
sql_model_version.name = new_name
sql_model_version.last_updated_time = updated_time
sql_registered_model.last_updated_time = updated_time
self._save_to_db(
session, [sql_registered_model] + sql_registered_model.model_versions
)
session.flush()
return sql_registered_model.to_mlflow_entity()
except sqlalchemy.exc.IntegrityError as e:
raise MlflowException(
"Registered Model (name={}) already exists. "
"Error: {}".format(new_name, str(e)),
RESOURCE_ALREADY_EXISTS,
)
def delete_registered_model(self, name):
"""
Delete the registered model.
Backend raises exception if a registered model with given name does not exist.
:param name: Registered model name.
:return: None
"""
with self.ManagedSessionMaker() as session:
sql_registered_model = self._get_registered_model(session, name)
session.delete(sql_registered_model)
def list_registered_models(self, max_results, page_token):
"""
List of all registered models.
:param max_results: Maximum number of registered models desired.
:param page_token: Token specifying the next page of results. It should be obtained from
a ``list_registered_models`` call.
:return: A PagedList of :py:class:`mlflow.entities.model_registry.RegisteredModel` objects
that satisfy the search expressions. The pagination token for the next page can be
obtained via the ``token`` attribute of the object.
"""
return self.search_registered_models(max_results=max_results, page_token=page_token)
def search_registered_models(
self,
filter_string=None,
max_results=SEARCH_REGISTERED_MODEL_MAX_RESULTS_DEFAULT,
order_by=None,
page_token=None,
):
"""
Search for registered models in backend that satisfy the filter criteria.
:param filter_string: Filter query string, defaults to searching all registered models.
:param max_results: Maximum number of registered models desired.
:param order_by: List of column names with ASC|DESC annotation, to be used for ordering
matching search results.
:param page_token: Token specifying the next page of results. It should be obtained from
a ``search_registered_models`` call.
:return: A PagedList of :py:class:`mlflow.entities.model_registry.RegisteredModel` objects
that satisfy the search expressions. The pagination token for the next page can be
obtained via the ``token`` attribute of the object.
"""
if max_results > SEARCH_REGISTERED_MODEL_MAX_RESULTS_THRESHOLD:
raise MlflowException(
"Invalid value for request parameter max_results. "
"It must be at most {}, but got value {}".format(
SEARCH_REGISTERED_MODEL_MAX_RESULTS_THRESHOLD, max_results
),
INVALID_PARAMETER_VALUE,
)
parsed_filter = SearchUtils.parse_filter_for_registered_models(filter_string)
parsed_orderby = self._parse_search_registered_models_order_by(order_by)
offset = SearchUtils.parse_start_offset_from_page_token(page_token)
# we query for max_results + 1 items to check whether there is another page to return.
# this remediates having to make another query which returns no items.
max_results_for_query = max_results + 1
def compute_next_token(current_size):
next_token = None
if max_results_for_query == current_size:
final_offset = offset + max_results
next_token = SearchUtils.create_page_token(final_offset)
return next_token
if len(parsed_filter) == 0:
conditions = []
elif len(parsed_filter) == 1:
filter_dict = parsed_filter[0]
comparator = filter_dict["comparator"].upper()
if comparator not in SearchUtils.VALID_REGISTERED_MODEL_SEARCH_COMPARATORS:
raise MlflowException(
"Search registered models filter expression only "
"supports the equality(=) comparator, case-sensitive"
"partial match (LIKE), and case-insensitive partial "
"match (ILIKE). Input filter string: %s" % filter_string,
error_code=INVALID_PARAMETER_VALUE,
)
if comparator == SearchUtils.LIKE_OPERATOR:
conditions = [SqlRegisteredModel.name.like(filter_dict["value"])]
elif comparator == SearchUtils.ILIKE_OPERATOR:
conditions = [SqlRegisteredModel.name.ilike(filter_dict["value"])]
else:
conditions = [SqlRegisteredModel.name == filter_dict["value"]]
else:
supported_ops = "".join(
["(" + op + ")" for op in SearchUtils.VALID_REGISTERED_MODEL_SEARCH_COMPARATORS]
)
sample_query = 'name {} "<model_name>"'.format(supported_ops)
raise MlflowException(
"Invalid filter string: {}".format(filter_string)
+ "Search registered models supports filter expressions like:"
+ sample_query,
error_code=INVALID_PARAMETER_VALUE,
)
with self.ManagedSessionMaker() as session:
query = (
session.query(SqlRegisteredModel)
.filter(*conditions)
.order_by(*parsed_orderby)
.limit(max_results_for_query)
)
if page_token:
query = query.offset(offset)
sql_registered_models = query.all()
next_page_token = compute_next_token(len(sql_registered_models))
rm_entities = [rm.to_mlflow_entity() for rm in sql_registered_models][:max_results]
return PagedList(rm_entities, next_page_token)
@classmethod
def _parse_search_registered_models_order_by(cls, order_by_list):
"""Sorts a set of registered models based on their natural ordering and an overriding set
of order_bys. Registered models are naturally ordered first by name ascending.
"""
clauses = []
observed_order_by_clauses = set()
if order_by_list:
for order_by_clause in order_by_list:
(
attribute_token,
ascending,
) = SearchUtils.parse_order_by_for_search_registered_models(order_by_clause)
if attribute_token == SqlRegisteredModel.name.key:
field = SqlRegisteredModel.name
elif attribute_token in SearchUtils.VALID_TIMESTAMP_ORDER_BY_KEYS:
field = SqlRegisteredModel.last_updated_time
else:
raise MlflowException(
"Invalid order by key '{}' specified.".format(attribute_token)
+ "Valid keys are "
+ "'{}'".format(SearchUtils.RECOMMENDED_ORDER_BY_KEYS_REGISTERED_MODELS),
error_code=INVALID_PARAMETER_VALUE,
)
if field.key in observed_order_by_clauses:
raise MlflowException(
"`order_by` contains duplicate fields: {}".format(order_by_list)
)
observed_order_by_clauses.add(field.key)
if ascending:
clauses.append(field.asc())
else:
clauses.append(field.desc())
if SqlRegisteredModel.name.key not in observed_order_by_clauses:
clauses.append(SqlRegisteredModel.name.asc())
return clauses
def get_registered_model(self, name):
"""
Get registered model instance by name.
:param name: Registered model name.
:return: A single :py:class:`mlflow.entities.model_registry.RegisteredModel` object.
"""
with self.ManagedSessionMaker() as session:
return self._get_registered_model(session, name, eager=True).to_mlflow_entity()
def get_latest_versions(self, name, stages=None):
"""
Latest version models for each requested stage. If no ``stages`` argument is provided,
returns the latest version for each stage.
:param name: Registered model name.
:param stages: List of desired stages. If input list is None, return latest versions for
each stage.
:return: List of :py:class:`mlflow.entities.model_registry.ModelVersion` objects.
"""
with self.ManagedSessionMaker() as session:
sql_registered_model = self._get_registered_model(session, name)
# Convert to RegisteredModel entity first and then extract latest_versions
latest_versions = sql_registered_model.to_mlflow_entity().latest_versions
if stages is None or len(stages) == 0:
expected_stages = set([get_canonical_stage(stage) for stage in ALL_STAGES])
else:
expected_stages = set([get_canonical_stage(stage) for stage in stages])
return [mv for mv in latest_versions if mv.current_stage in expected_stages]
@classmethod
def _get_registered_model_tag(cls, session, name, key):
tags = (
session.query(SqlRegisteredModelTag)
.filter(SqlRegisteredModelTag.name == name, SqlRegisteredModelTag.key == key)
.all()
)
if len(tags) == 0:
return None
if len(tags) > 1:
raise MlflowException(
"Expected only 1 registered model tag with name={}, key={}. "
"Found {}.".format(name, key, len(tags)),
INVALID_STATE,
)
return tags[0]
def set_registered_model_tag(self, name, tag):
"""
Set a tag for the registered model.
:param name: Registered model name.
:param tag: :py:class:`mlflow.entities.model_registry.RegisteredModelTag` instance to log.
:return: None
"""
_validate_model_name(name)
_validate_registered_model_tag(tag.key, tag.value)
with self.ManagedSessionMaker() as session:
# check if registered model exists
self._get_registered_model(session, name)
session.merge(SqlRegisteredModelTag(name=name, key=tag.key, value=tag.value))
def delete_registered_model_tag(self, name, key):
"""
Delete a tag associated with the registered model.
:param name: Registered model name.
:param key: Registered model tag key.
:return: None
"""
_validate_model_name(name)
_validate_tag_name(key)
with self.ManagedSessionMaker() as session:
# check if registered model exists
self._get_registered_model(session, name)
existing_tag = self._get_registered_model_tag(session, name, key)
if existing_tag is not None:
session.delete(existing_tag)
# CRUD API for ModelVersion objects
def create_model_version(
self, name, source, run_id=None, tags=None, run_link=None, description=None
):
"""
Create a new model version from given source and run ID.
:param name: Registered model name.
:param source: Source path where the MLflow model is stored.
:param run_id: Run ID from MLflow tracking server that generated the model.
:param tags: A list of :py:class:`mlflow.entities.model_registry.ModelVersionTag`
instances associated with this model version.
:param run_link: Link to the run from an MLflow tracking server that generated this model.
:param description: Description of the version.
:return: A single object of :py:class:`mlflow.entities.model_registry.ModelVersion`
created in the backend.
"""
def next_version(sql_registered_model):
if sql_registered_model.model_versions:
return max([mv.version for mv in sql_registered_model.model_versions]) + 1
else:
return 1
_validate_model_name(name)
for tag in tags or []:
_validate_model_version_tag(tag.key, tag.value)
with self.ManagedSessionMaker() as session:
creation_time = now()
for attempt in range(self.CREATE_MODEL_VERSION_RETRIES):
try:
sql_registered_model = self._get_registered_model(session, name)
sql_registered_model.last_updated_time = creation_time
version = next_version(sql_registered_model)
model_version = SqlModelVersion(
name=name,
version=version,
creation_time=creation_time,
last_updated_time=creation_time,
source=source,
run_id=run_id,
run_link=run_link,
description=description,
)
tags_dict = {}
for tag in tags or []:
tags_dict[tag.key] = tag.value
model_version.model_version_tags = [
SqlModelVersionTag(key=key, value=value) for key, value in tags_dict.items()
]
self._save_to_db(session, [sql_registered_model, model_version])
session.flush()
return model_version.to_mlflow_entity()
except sqlalchemy.exc.IntegrityError:
more_retries = self.CREATE_MODEL_VERSION_RETRIES - attempt - 1
_logger.info(
"Model Version creation error (name=%s) Retrying %s more time%s.",
name,
str(more_retries),
"s" if more_retries > 1 else "",
)
raise MlflowException(
"Model Version creation error (name={}). Giving up after "
"{} attempts.".format(name, self.CREATE_MODEL_VERSION_RETRIES)
)
@classmethod
def _get_model_version_from_db(cls, session, name, version, conditions, query_options=None):
if query_options is None:
query_options = []
versions = session.query(SqlModelVersion).options(*query_options).filter(*conditions).all()
if len(versions) == 0:
raise MlflowException(
"Model Version (name={}, version={}) " "not found".format(name, version),
RESOURCE_DOES_NOT_EXIST,
)
if len(versions) > 1:
raise MlflowException(
"Expected only 1 model version with (name={}, version={}). "
"Found {}.".format(name, version, len(versions)),
INVALID_STATE,
)
return versions[0]
@classmethod
def _get_sql_model_version(cls, session, name, version, eager=False):
"""
:param eager: If ``True``, eagerly loads the model version's tags.
If ``False``, these attributes are not eagerly loaded and
will be loaded when their corresponding object properties
are accessed from the resulting ``SqlModelVersion`` object.
"""
_validate_model_name(name)
_validate_model_version(version)
query_options = cls._get_eager_model_version_query_options() if eager else []
conditions = [
SqlModelVersion.name == name,
SqlModelVersion.version == version,
SqlModelVersion.current_stage != STAGE_DELETED_INTERNAL,
]
return cls._get_model_version_from_db(session, name, version, conditions, query_options)
def _get_sql_model_version_including_deleted(self, name, version):
"""
Private method to retrieve model versions including those that are internally deleted.
Used in tests to verify redaction behavior on deletion.
:param name: Registered model name.
:param version: Registered model version.
:return: A single :py:class:`mlflow.entities.model_registry.ModelVersion` object.
"""
with self.ManagedSessionMaker() as session:
conditions = [
SqlModelVersion.name == name,
SqlModelVersion.version == version,
]
sql_model_version = self._get_model_version_from_db(session, name, version, conditions)
return sql_model_version.to_mlflow_entity()
def update_model_version(self, name, version, description=None):
"""
Update metadata associated with a model version in backend.
:param name: Registered model name.
:param version: Registered model version.
:param description: New model description.
:return: A single :py:class:`mlflow.entities.model_registry.ModelVersion` object.
"""
with self.ManagedSessionMaker() as session:
updated_time = now()
sql_model_version = self._get_sql_model_version(session, name=name, version=version)
sql_model_version.description = description
sql_model_version.last_updated_time = updated_time
self._save_to_db(session, [sql_model_version])
return sql_model_version.to_mlflow_entity()
def transition_model_version_stage(self, name, version, stage, archive_existing_versions):
"""
Update model version stage.
:param name: Registered model name.
:param version: Registered model version.
:param new_stage: New desired stage for this model version.
:param archive_existing_versions: If this flag is set to ``True``, all existing model
versions in the stage will be automically moved to the "archived" stage. Only valid
when ``stage`` is ``"staging"`` or ``"production"`` otherwise an error will be raised.
:return: A single :py:class:`mlflow.entities.model_registry.ModelVersion` object.
"""
is_active_stage = get_canonical_stage(stage) in DEFAULT_STAGES_FOR_GET_LATEST_VERSIONS
if archive_existing_versions and not is_active_stage:
msg_tpl = (
"Model version transition cannot archive existing model versions "
"because '{}' is not an Active stage. Valid stages are {}"
)
raise MlflowException(msg_tpl.format(stage, DEFAULT_STAGES_FOR_GET_LATEST_VERSIONS))
with self.ManagedSessionMaker() as session:
last_updated_time = now()
model_versions = []
if archive_existing_versions:
conditions = [
SqlModelVersion.name == name,
SqlModelVersion.version != version,
SqlModelVersion.current_stage == get_canonical_stage(stage),
]
model_versions = session.query(SqlModelVersion).filter(*conditions).all()
for mv in model_versions:
mv.current_stage = STAGE_ARCHIVED
mv.last_updated_time = last_updated_time
sql_model_version = self._get_sql_model_version(
session=session, name=name, version=version
)
sql_model_version.current_stage = get_canonical_stage(stage)
sql_model_version.last_updated_time = last_updated_time
sql_registered_model = sql_model_version.registered_model
sql_registered_model.last_updated_time = last_updated_time
self._save_to_db(session, [*model_versions, sql_model_version, sql_registered_model])
return sql_model_version.to_mlflow_entity()
def delete_model_version(self, name, version):
"""
Delete model version in backend.
:param name: Registered model name.
:param version: Registered model version.
:return: None
"""
# currently delete model version still keeps the tags associated with the version
with self.ManagedSessionMaker() as session:
updated_time = now()
sql_model_version = self._get_sql_model_version(session, name, version)
sql_registered_model = sql_model_version.registered_model
sql_registered_model.last_updated_time = updated_time
sql_model_version.current_stage = STAGE_DELETED_INTERNAL
sql_model_version.last_updated_time = updated_time
sql_model_version.description = None
sql_model_version.user_id = None
sql_model_version.source = "REDACTED-SOURCE-PATH"
sql_model_version.run_id = "REDACTED-RUN-ID"
sql_model_version.run_link = "REDACTED-RUN-LINK"
sql_model_version.status_message = None
self._save_to_db(session, [sql_registered_model, sql_model_version])
def get_model_version(self, name, version):
"""
Get the model version instance by name and version.
:param name: Registered model name.
:param version: Registered model version.
:return: A single :py:class:`mlflow.entities.model_registry.ModelVersion` object.
"""
with self.ManagedSessionMaker() as session:
sql_model_version = self._get_sql_model_version(session, name, version, eager=True)
return sql_model_version.to_mlflow_entity()
def get_model_version_download_uri(self, name, version):
"""
Get the download location in Model Registry for this model version.
NOTE: For first version of Model Registry, since the models are not copied over to another
location, download URI points to input source path.
:param name: Registered model name.
:param version: Registered model version.
:return: A single URI location that allows reads for downloading.
"""
with self.ManagedSessionMaker() as session:
sql_model_version = self._get_sql_model_version(session, name, version)
return sql_model_version.source
def search_model_versions(self, filter_string):
"""
Search for model versions in backend that satisfy the filter criteria.
:param filter_string: A filter string expression. Currently supports a single filter
condition either name of model like ``name = 'model_name'`` or
``run_id = '...'``.
:return: PagedList of :py:class:`mlflow.entities.model_registry.ModelVersion`
objects.
"""
parsed_filter = SearchUtils.parse_filter_for_model_versions(filter_string)
if len(parsed_filter) == 0:
conditions = []
elif len(parsed_filter) == 1:
filter_dict = parsed_filter[0]
if filter_dict["comparator"] not in SearchUtils.VALID_MODEL_VERSIONS_SEARCH_COMPARATORS:
raise MlflowException(
"Model Registry search filter only supports the equality(=) "
"comparator and the IN operator "
"for the run_id parameter. Input filter string: %s" % filter_string,
error_code=INVALID_PARAMETER_VALUE,
)
if filter_dict["key"] == "name":
conditions = [SqlModelVersion.name == filter_dict["value"]]
elif filter_dict["key"] == "source_path":
conditions = [SqlModelVersion.source == filter_dict["value"]]
elif filter_dict["key"] == "run_id":
if filter_dict["comparator"] == "IN":
conditions = [SqlModelVersion.run_id.in_(filter_dict["value"])]
else:
conditions = [SqlModelVersion.run_id == filter_dict["value"]]
else:
raise MlflowException(
"Invalid filter string: %s" % filter_string, error_code=INVALID_PARAMETER_VALUE
)
else:
raise MlflowException(
"Model Registry expects filter to be one of "
"\"name = '<model_name>'\" or "
"\"source_path = '<source_path>'\" "
'or "run_id = \'<run_id>\' or "run_id IN (<run_ids>)".'
"Input filter string: %s. " % filter_string,
error_code=INVALID_PARAMETER_VALUE,
)
with self.ManagedSessionMaker() as session:
conditions.append(SqlModelVersion.current_stage != STAGE_DELETED_INTERNAL)
sql_model_version = session.query(SqlModelVersion).filter(*conditions).all()
model_versions = [mv.to_mlflow_entity() for mv in sql_model_version]
return PagedList(model_versions, None)
@classmethod
def _get_model_version_tag(cls, session, name, version, key):
tags = (
session.query(SqlModelVersionTag)
.filter(
SqlModelVersionTag.name == name,
SqlModelVersionTag.version == version,
SqlModelVersionTag.key == key,
)
.all()
)
if len(tags) == 0:
return None
if len(tags) > 1:
raise MlflowException(
"Expected only 1 model version tag with name={}, version={}, "
"key={}. Found {}.".format(name, version, key, len(tags)),
INVALID_STATE,
)
return tags[0]
def set_model_version_tag(self, name, version, tag):
"""
Set a tag for the model version.
:param name: Registered model name.
:param version: Registered model version.
:param tag: :py:class:`mlflow.entities.model_registry.ModelVersionTag` instance to log.
:return: None
"""
_validate_model_name(name)
_validate_model_version(version)
_validate_model_version_tag(tag.key, tag.value)
with self.ManagedSessionMaker() as session:
# check if model version exists
self._get_sql_model_version(session, name, version)
session.merge(
SqlModelVersionTag(name=name, version=version, key=tag.key, value=tag.value)
)
def delete_model_version_tag(self, name, version, key):
"""
Delete a tag associated with the model version.
:param name: Registered model name.
:param version: Registered model version.
:param key: Tag key.
:return: None
"""
_validate_model_name(name)
_validate_model_version(version)
_validate_tag_name(key)
with self.ManagedSessionMaker() as session:
# check if model version exists
self._get_sql_model_version(session, name, version)
existing_tag = self._get_model_version_tag(session, name, version, key)
if existing_tag is not None:
session.delete(existing_tag)