Как исправить Column not found в базе данных

1-- MySQL
2DESCRIBE table_name;
3SHOW COLUMNS FROM table_name;
4
5-- PostgreSQL
6\d table_name
7SELECT column_name, data_type 
8FROM information_schema.columns 
9WHERE table_name = 'table_name';

1-- MySQL
2ALTER TABLE table_name 
3ADD COLUMN column_name VARCHAR(255) NOT NULL DEFAULT '';
4
5-- PostgreSQL
6ALTER TABLE table_name 
7ADD COLUMN column_name VARCHAR(255) NOT NULL DEFAULT '';

 1# Django
 2python manage.py makemigrations
 3python manage.py migrate
 4python manage.py showmigrations
 5
 6# Rails
 7rails generate migration AddColumnToTable
 8rails db:migrate
 9rails db:migrate:status
10
11# Laravel
12php artisan make:migration add_column_to_table
13php artisan migrate
14php artisan migrate:status

 1# Django migration
 2from django.db import migrations, models
 3
 4class Migration(migrations.Migration):
 5    dependencies = [
 6        ('app_name', 'previous_migration'),
 7    ]
 8    
 9    operations = [
10        migrations.AddField(
11            model_name='modelname',
12            name='field_name',
13            field=models.CharField(max_length=255, default=''),
14        ),
15    ]

1-- Проверь данные в таблице
2SELECT * FROM table_name LIMIT 5;
3
4-- Проверь типы данных
5SELECT column_name, data_type, is_nullable 
6FROM information_schema.columns 
7WHERE table_name = 'table_name';

 1# schema_validator.py
 2import psycopg2
 3import mysql.connector
 4from datetime import datetime
 5
 6def validate_table_schema_mysql(host, user, password, database, table, required_columns):
 7    try:
 8        conn = mysql.connector.connect(
 9            host=host, user=user, password=password, database=database
10        )
11        cursor = conn.cursor()
12        cursor.execute("SHOW COLUMNS FROM %s", (table,))
13        existing_columns = [row[0] for row in cursor.fetchall()]
14        cursor.close()
15        conn.close()
16        
17        missing_columns = set(required_columns) - set(existing_columns)
18        
19        return {
20            'table': table,
21            'missing_columns': list(missing_columns),
22            'all_columns_exist': len(missing_columns) == 0,
23            'timestamp': datetime.now()
24        }
25    except Exception as e:
26        return {
27            'table': table,
28            'error': str(e),
29            'timestamp': datetime.now()
30        }
31
32def validate_table_schema_postgres(host, user, password, database, table, required_columns):
33    try:
34        conn = psycopg2.connect(
35            host=host, user=user, password=password, database=database
36        )
37        cursor = conn.cursor()
38        cursor.execute("""
39            SELECT column_name FROM information_schema.columns 
40            WHERE table_name = %s AND table_schema = 'public'
41        """, (table,))
42        existing_columns = [row[0] for row in cursor.fetchall()]
43        cursor.close()
44        conn.close()
45        
46        missing_columns = set(required_columns) - set(existing_columns)
47        
48        return {
49            'table': table,
50            'missing_columns': list(missing_columns),
51            'all_columns_exist': len(missing_columns) == 0,
52            'timestamp': datetime.now()
53        }
54    except Exception as e:
55        return {
56            'table': table,
57            'error': str(e),
58            'timestamp': datetime.now()
59        }
60
61# Мониторинг
62required_columns = ['id', 'name', 'email', 'created_at']
63
64# MySQL
65mysql_status = validate_table_schema_mysql(
66    'localhost', 'user', 'password', 'database', 'users', required_columns
67)
68print(f"MySQL schema validation: {mysql_status}")
69
70# PostgreSQL
71pg_status = validate_table_schema_postgres(
72    'localhost', 'user', 'password', 'database', 'users', required_columns
73)
74print(f"PostgreSQL schema validation: {pg_status}")

 1# auto_schema_fix.py
 2def fix_missing_columns_mysql(host, user, password, database, table, missing_columns):
 3    try:
 4        conn = mysql.connector.connect(
 5            host=host, user=user, password=password, database=database
 6        )
 7        cursor = conn.cursor()
 8        
 9        for column in missing_columns:
10            # Определи тип колонки по имени
11            if 'id' in column.lower():
12                sql = f"ALTER TABLE {table} ADD COLUMN {column} INT AUTO_INCREMENT PRIMARY KEY"
13            elif 'email' in column.lower():
14                sql = f"ALTER TABLE {table} ADD COLUMN {column} VARCHAR(255) UNIQUE"
15            elif 'created_at' in column.lower() or 'updated_at' in column.lower():
16                sql = f"ALTER TABLE {table} ADD COLUMN {column} TIMESTAMP DEFAULT CURRENT_TIMESTAMP"
17            else:
18                sql = f"ALTER TABLE {table} ADD COLUMN {column} VARCHAR(255)"
19            
20            cursor.execute(sql)
21            print(f"Added column {column} to table {table}")
22        
23        conn.commit()
24        cursor.close()
25        conn.close()
26        
27        return True
28    except Exception as e:
29        print(f"Error fixing schema: {e}")
30        return False