add default uuid feature

database.py

@@ -17,19 +17,21 @@ metadata_obj = MetaData()
 def create_dynamic_table(df):
     """
     Creates a table dynamically based on DataFrame schema.
-    
+
     Args:
         df: pandas DataFrame containing the data
-        
+
     Returns:
         SQLAlchemy Table object
     """
     # Drop existing table if it exists
     if 'data_table' in metadata_obj.tables:
         metadata_obj.remove(metadata_obj.tables['data_table'])
-    
-    # Create columns based on DataFrame dtypes
-    columns = []
+
+    # Define columns with a new auto-incrementing primary key
+    columns = [Column("uuid", Integer, primary_key=True, autoincrement=True)]  # New primary key
+
+    # Add columns based on DataFrame dtypes
     for col_name, dtype in df.dtypes.items():
         if 'int' in str(dtype):
             col_type = Integer
@@ -37,19 +39,15 @@ def create_dynamic_table(df):
             col_type = Float
         else:
             col_type = String(255)  # Using a generous length for string columns
-        
-        # First column becomes primary key
-        if len(columns) == 0:
-            columns.append(Column(col_name, col_type, primary_key=True))
-        else:
-            columns.append(Column(col_name, col_type))
-    
+
+        columns.append(Column(col_name, col_type))
+
     # Create new table
     table = Table('data_table', metadata_obj, *columns)
-    
+
     # Create table in database
     metadata_obj.create_all(engine, tables=[table])
-    
+
     return table
 
 def clear_database():