This is an automated email from the ASF dual-hosted git repository.
rusackas pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/superset.git
The following commit(s) were added to refs/heads/master by this push:
new d16f274991 feat(database): Add user_id and dttm composite index to Log
model. (#19532)
d16f274991 is described below
commit d16f274991537ef8183eff4636792d2d186d4e16
Author: Eugene Bikkinin <[email protected]>
AuthorDate: Thu Jul 7 07:24:44 2022 +0300
feat(database): Add user_id and dttm composite index to Log model. (#19532)
* feat: Added user_id and dttm composite index to Log model.
* fix: Refactored migration to a general view.
* fix: Changed down revision.
* fix: Formatted with black.
* fix: Removed odd Index import.
---
...cf3d64daf4_add_user_id_dttm_idx_to_log_model.py | 40 ++++++++++++++++++++++
1 file changed, 40 insertions(+)
diff --git
a/superset/migrations/versions/cdcf3d64daf4_add_user_id_dttm_idx_to_log_model.py
b/superset/migrations/versions/cdcf3d64daf4_add_user_id_dttm_idx_to_log_model.py
new file mode 100644
index 0000000000..8b12661ecd
--- /dev/null
+++
b/superset/migrations/versions/cdcf3d64daf4_add_user_id_dttm_idx_to_log_model.py
@@ -0,0 +1,40 @@
+# Licensed to the Apache Software Foundation (ASF) under one
+# or more contributor license agreements. See the NOTICE file
+# distributed with this work for additional information
+# regarding copyright ownership. The ASF licenses this file
+# to you under the Apache License, Version 2.0 (the
+# "License"); you may not use this file except in compliance
+# with the License. You may obtain a copy of the License at
+#
+# http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing,
+# software distributed under the License is distributed on an
+# "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+# KIND, either express or implied. See the License for the
+# specific language governing permissions and limitations
+# under the License.
+"""Add user_id and dttm composite index to Log model
+
+Revision ID: cdcf3d64daf4
+Revises: b0d0249074e4
+Create Date: 2022-04-05 13:27:06.028908
+
+"""
+
+# revision identifiers, used by Alembic.
+revision = "cdcf3d64daf4"
+down_revision = "b0d0249074e4"
+
+
+from alembic import op
+
+
+def upgrade():
+ op.create_index(
+ op.f("ix_logs_user_id_dttm"), "logs", ["user_id", "dttm"], unique=False
+ )
+
+
+def downgrade():
+ op.drop_index(op.f("ix_logs_user_id_dttm"), table_name="logs")
