script buat generate konversi table-table django ke utf8mb4. karena emoji itu penting. jalankan di environment django (python manage.py shell)

convert_table_to_utf8mb4.py

from django.db import connection
from django.conf import settings
cursor = connection.cursor()

cursor.execute("USE "+settings.DATABASES['default']['NAME'])
cursor.execute('SHOW TABLES')
tables = cursor
sql = ''
reverse_sql = ''
for (table_name,) in tables:
    cursor.execute('SHOW fields in {}'.format(table_name))
    fields = cursor
    for field in fields:
        if 'varchar' in field[1] or 'text' in field[1]:
            sql += "\n 'ALTER TABLE `{}` MODIFY `{}` {} CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci ',".format(table_name, field[0], field[1])
            reverse_sql += "\n 'ALTER TABLE `{}` MODIFY `{}` {} ',".format(table_name, field[0], field[1])
print("migrations.RunSQL(\n"
        " sql=[{}\n ],\n"
        " reverse_sql=[{}\n ]\n"
        "),".format(sql, reverse_sql))