update media

11 files changed, 0 insertions, 100 deletions

diff --git a/blocks/eda-frontend/src/static/gallery/gallery100.png b/blocks/eda-frontend/src/static/gallery/gallery100.png
index bcf1eb9d..adbc6fd4 100644
--- a/blocks/eda-frontend/src/static/gallery/gallery100.png
+++ b/blocks/eda-frontend/src/static/gallery/gallery100.png
diff --git a/blocks/eda-frontend/src/static/gallery/gallery101.png b/blocks/eda-frontend/src/static/gallery/gallery101.png
index bafa6ab6..92439642 100644
--- a/blocks/eda-frontend/src/static/gallery/gallery101.png
+++ b/blocks/eda-frontend/src/static/gallery/gallery101.png
diff --git a/blocks/eda-frontend/src/static/gallery/gallery102.png b/blocks/eda-frontend/src/static/gallery/gallery102.png
index 7907a45f..a8e02250 100644
--- a/blocks/eda-frontend/src/static/gallery/gallery102.png
+++ b/blocks/eda-frontend/src/static/gallery/gallery102.png
diff --git a/blocks/eda-frontend/src/static/gallery/gallery103.png b/blocks/eda-frontend/src/static/gallery/gallery103.png
index d655cf1d..e2681dad 100644
--- a/blocks/eda-frontend/src/static/gallery/gallery103.png
+++ b/blocks/eda-frontend/src/static/gallery/gallery103.png
diff --git a/blocks/eda-frontend/src/static/gallery/gallery104.png b/blocks/eda-frontend/src/static/gallery/gallery104.png
index afd2eb9e..dd9b36e6 100644
--- a/blocks/eda-frontend/src/static/gallery/gallery104.png
+++ b/blocks/eda-frontend/src/static/gallery/gallery104.png
diff --git a/blocks/eda-frontend/src/static/gallery/gallery105.png b/blocks/eda-frontend/src/static/gallery/gallery105.png
index 1e93993e..f000a73a 100644
--- a/blocks/eda-frontend/src/static/gallery/gallery105.png
+++ b/blocks/eda-frontend/src/static/gallery/gallery105.png
diff --git a/blocks/eda-frontend/src/static/gallery/gallery106.png b/blocks/eda-frontend/src/static/gallery/gallery106.png
index 7452fe25..6aaf12c9 100644
--- a/blocks/eda-frontend/src/static/gallery/gallery106.png
+++ b/blocks/eda-frontend/src/static/gallery/gallery106.png
diff --git a/blocks/eda-frontend/src/static/gallery/gallery107.png b/blocks/eda-frontend/src/static/gallery/gallery107.png
index 2e42397e..134ec613 100644
--- a/blocks/eda-frontend/src/static/gallery/gallery107.png
+++ b/blocks/eda-frontend/src/static/gallery/gallery107.png
diff --git a/blocks/eda-frontend/src/static/gallery/gallery108.png b/blocks/eda-frontend/src/static/gallery/gallery108.png
index ec6a14e1..c3973b43 100644
--- a/blocks/eda-frontend/src/static/gallery/gallery108.png
+++ b/blocks/eda-frontend/src/static/gallery/gallery108.png
diff --git a/blocks/eda-frontend/src/static/gallery/gallery109.png b/blocks/eda-frontend/src/static/gallery/gallery109.png
index b926e7c2..87ec190c 100644
--- a/blocks/eda-frontend/src/static/gallery/gallery109.png
+++ b/blocks/eda-frontend/src/static/gallery/gallery109.png
diff --git a/blocks/update_media.py b/blocks/update_media.py
index 90894628..dcfdb5c0 100644
--- a/blocks/update_media.py
+++ b/blocks/update_media.py
@@ -5,97 +5,6 @@ import shutil
 import sqlite3
 
 
-# def empty_table(db_path, table_name):
-#     """
-#     Empties all rows in the specified table.
-#     """
-#     try:
-#         # Connect to the database
-#         conn = sqlite3.connect(db_path)
-#         cursor = conn.cursor()
-
-#         # Validate table name to avoid SQL injection
-#         if not table_name.isidentifier():
-#             raise ValueError(f"Invalid table name: {table_name}")
-
-#         # SQL to delete all rows from the table
-#         sql = f"DELETE FROM {table_name};"
-
-#         # Execute the query
-#         cursor.execute(sql)
-
-#         # Commit the changes
-#         conn.commit()
-#         print(f"Table '{table_name}' has been emptied successfully.")
-
-#     except sqlite3.Error as e:
-#         print(f"Database error while emptying the table: {e}")
-
-#     except ValueError as ve:
-#         print(ve)
-
-#     finally:
-#         # Close the database connection
-#         if conn:
-#             conn.close()
-
-
-# def populate_table(db_path, table_name, json_path):
-#     """
-#     Populates the specified table with data from a JSON file.
-#     """
-#     conn = None
-#     try:
-#         # Load data from JSON file
-#         with open(json_path, 'r') as json_file:
-#             data = json.load(json_file)
-
-#         # Connect to the database
-#         conn = sqlite3.connect(db_path)
-#         cursor = conn.cursor()
-
-#         # Validate table name to avoid SQL injection
-#         if not table_name.isidentifier():
-#             raise ValueError(f"Invalid table name: {table_name}")
-
-#         # Insert data into the table
-#         for record in data:
-#             if not isinstance(record, dict):
-#                 print(f"Skipping invalid record: {record}")
-#                 continue
-
-#             # Add save_time if not present
-#             if 'save_time' not in record:
-#                 record['save_time'] = datetime.now().strftime("%Y-%m-%d %H:%M:%S")
-
-#             columns = ", ".join(record.keys())
-#             placeholders = ", ".join("?" for _ in record.values())
-#             sql = f"INSERT INTO {table_name} ({columns}) VALUES ({placeholders})"
-
-#             try:
-#                 cursor.execute(sql, tuple(record.values()))
-#             except sqlite3.Error as e:
-#                 print(f"Failed to insert record {record}: {e}")
-
-#         # Commit the changes
-#         conn.commit()
-#         print(f"Table '{table_name}' has been populated successfully.")
-
-#     except sqlite3.Error as e:
-#         print(f"Database error while populating the table: {e}")
-
-#     except FileNotFoundError:
-#         print(f"JSON file '{json_path}' not found.")
-
-#     except ValueError as ve:
-#         print(ve)
-
-#     finally:
-#         # Close the database connection
-#         if conn:
-#             conn.close()
-
-
 def update_media_column(db_path, table_name):
     """
     Updates the media column in the table to store '<save_id>.png' based on the save_id value.
@@ -178,15 +87,6 @@ if __name__ == "__main__":
     table_name = "saveAPI_gallery"
     statesave_table = "saveAPI_statesave"
 
-    # Path to the JSON file containing the data
-    # json_file_path = "eda-frontend/src/utils/GallerySchSample.json"
-
-    # Empty the table first
-    # empty_table(database_path, table_name)
-
-    # # Populate the table with JSON data
-    # populate_table(database_path, table_name, json_file_path)
-
     update_media_column(database_path, table_name)
 
     join_and_copy_images(database_path, statesave_table, table_name)