adaptable
Advanced tools
| """ | ||
| This module aims at fixing graphs once refactoring has been done in your database. | ||
| While not being perfect, it provides for some specific use case a nice 80/20 that avoid lot's of manual and | ||
| automatic work | ||
| """ |
Sorry, the diff of this file is not supported yet
Sorry, the diff of this file is not supported yet
Sorry, the diff of this file is not supported yet
Sorry, the diff of this file is not supported yet
Sorry, the diff of this file is not supported yet
Sorry, the diff of this file is not supported yet
Sorry, the diff of this file is not supported yet
Sorry, the diff of this file is not supported yet
Sorry, the diff of this file is not supported yet
Sorry, the diff of this file is not supported yet
Sorry, the diff of this file is not supported yet
Sorry, the diff of this file is not supported yet
Sorry, the diff of this file is not supported yet
Sorry, the diff of this file is not supported yet
Sorry, the diff of this file is not supported yet
@@ -8,3 +8,2 @@ import psycopg2 | ||
| sql_path = pkg_resources.resource_filename(__name__, query_file) | ||
| print(sql_path) | ||
@@ -23,3 +22,2 @@ with open(sql_path, "r") as r_file: | ||
| sql_path = pkg_resources.resource_filename(__name__, query_file) | ||
| print(sql_path) | ||
| updated_rows = 0 | ||
@@ -26,0 +24,0 @@ try: |
@@ -12,5 +12,3 @@ from adaptable._data_access.get_dataset_from_db import select_table, alter_table | ||
| ) | ||
| query_file_path = ( | ||
| "query/get_metabase_cards_not_recently_looked_at.sql" | ||
| ) | ||
| query_file_path = "query/get_metabase_cards_not_recently_looked_at.sql" | ||
@@ -30,5 +28,3 @@ df_metabase_card_id = select_table(conn, query_file_path, variables) | ||
| ) | ||
| query_file_path = ( | ||
| "query/get_metabase_dashboard_not_recently_looked_at.sql" | ||
| ) | ||
| query_file_path = "query/get_metabase_dashboard_not_recently_looked_at.sql" | ||
| df_metabase_dashboard_id = select_table(conn, query_file_path, variables) | ||
@@ -67,5 +63,3 @@ print(df_metabase_dashboard_id) | ||
| ) | ||
| query_file_path = ( | ||
| "update/archive_report_cards_using_id_list.sql" | ||
| ) | ||
| query_file_path = "update/archive_report_cards_using_id_list.sql" | ||
| try: | ||
@@ -88,5 +82,3 @@ updated_row = alter_table(conn, query_file_path, variables) | ||
| ) | ||
| query_file_path = ( | ||
| "update/archive_report_dashboards_using_id_list.sql" | ||
| ) | ||
| query_file_path = "update/archive_report_dashboards_using_id_list.sql" | ||
| try: | ||
@@ -93,0 +85,0 @@ updated_row = alter_table(conn, query_file_path, variables) |
@@ -53,5 +53,3 @@ from adaptable._data_access.get_dataset_from_db import select_table, alter_table | ||
| ) | ||
| query_file_path = ( | ||
| "query/get_metabase_cards_with_specific_sql_query.sql" | ||
| ) | ||
| query_file_path = "query/get_metabase_cards_with_specific_sql_query.sql" | ||
| df_metabase_fields = select_table(conn, query_file_path, variables) | ||
@@ -67,5 +65,3 @@ return df_metabase_fields | ||
| ) | ||
| query_file_path = ( | ||
| "deletion/delete_metabase_field_based_on_id.sql" | ||
| ) | ||
| query_file_path = "deletion/delete_metabase_field_based_on_id.sql" | ||
| try: | ||
@@ -90,5 +86,3 @@ updated_row = alter_table(conn, query_file_path, variables) | ||
| ) | ||
| query_file_path = ( | ||
| "deletion/delete_metabase_table_based_on_schema_name.sql" | ||
| ) | ||
| query_file_path = "deletion/delete_metabase_table_based_on_schema_name.sql" | ||
| try: | ||
@@ -112,5 +106,3 @@ updated_row = alter_table(conn, query_file_path, variables) | ||
| ) | ||
| query_file_path = ( | ||
| "deletion/delete_metabase_table_based_on_id.sql" | ||
| ) | ||
| query_file_path = "deletion/delete_metabase_table_based_on_id.sql" | ||
| try: | ||
@@ -170,5 +162,3 @@ updated_row = alter_table(conn, query_file_path, variables) | ||
| ) | ||
| query_file_path = ( | ||
| "update/update_table_name_in_metabase_table.sql" | ||
| ) | ||
| query_file_path = "update/update_table_name_in_metabase_table.sql" | ||
| try: | ||
@@ -222,5 +212,3 @@ updated_row = alter_table(conn, query_file_path, variables) | ||
| ) | ||
| query_file_path = ( | ||
| "update/update_column_name_in_sql_query.sql" | ||
| ) | ||
| query_file_path = "update/update_column_name_in_sql_query.sql" | ||
| try: | ||
@@ -248,5 +236,3 @@ updated_row = alter_table(conn, query_file_path, variables) | ||
| ) | ||
| query_file_path = ( | ||
| "update/update_metabase_table_schema_name.sql" | ||
| ) | ||
| query_file_path = "update/update_metabase_table_schema_name.sql" | ||
| try: | ||
@@ -253,0 +239,0 @@ updated_row = alter_table(conn, query_file_path, variables) |
@@ -6,2 +6,3 @@ from adaptable.refactoring._utils import ( | ||
| delete_a_metabase_field_based_on_schema, | ||
| delete_a_metabase_table_based_on_id, | ||
| change_the_id_of_one_metabase_field_row, | ||
@@ -8,0 +9,0 @@ rename_table_and_activate_metabase_table, |
+3
-1
| Metadata-Version: 2.1 | ||
| Name: adaptable | ||
| Version: 0.1.6 | ||
| Version: 0.1.7 | ||
| Summary: | ||
@@ -11,2 +11,3 @@ Author: Paul Couturier | ||
| Classifier: Programming Language :: Python :: 3.9 | ||
| Requires-Dist: Sphinx (>=6.1.3,<7.0.0) | ||
| Requires-Dist: black (>=23.3.0,<24.0.0) | ||
@@ -16,1 +17,2 @@ Requires-Dist: boto3 (>=1.26.103,<2.0.0) | ||
| Requires-Dist: psycopg2 (>=2.9.5,<3.0.0) | ||
| Requires-Dist: sphinx-rtd-theme (>=1.2.0,<2.0.0) |
+3
-1
| [tool.poetry] | ||
| name = "adapTable" | ||
| version = "0.1.6" | ||
| version = "0.1.7" | ||
| description = "" | ||
@@ -15,2 +15,4 @@ authors = ["Paul Couturier <paul.couturier@ovrsea.com>"] | ||
| pandas = "^1.5.3" | ||
| Sphinx = "^6.1.3" | ||
| sphinx-rtd-theme = "^1.2.0" | ||
@@ -17,0 +19,0 @@ [tool.poetry.dev-dependencies] |
+5
-3
@@ -17,10 +17,12 @@ # -*- coding: utf-8 -*- | ||
| install_requires = \ | ||
| ['black>=23.3.0,<24.0.0', | ||
| ['Sphinx>=6.1.3,<7.0.0', | ||
| 'black>=23.3.0,<24.0.0', | ||
| 'boto3>=1.26.103,<2.0.0', | ||
| 'pandas>=1.5.3,<2.0.0', | ||
| 'psycopg2>=2.9.5,<3.0.0'] | ||
| 'psycopg2>=2.9.5,<3.0.0', | ||
| 'sphinx-rtd-theme>=1.2.0,<2.0.0'] | ||
| setup_kwargs = { | ||
| 'name': 'adaptable', | ||
| 'version': '0.1.6', | ||
| 'version': '0.1.7', | ||
| 'description': '', | ||
@@ -27,0 +29,0 @@ 'long_description': None, |
Alert delta unavailable
Currently unable to show alert delta for PyPI packages.
92881
52.92%49
48.48%583
-2.18%