如何在保存记录时忽略必填列字段？

ALTER TABLE your_table MODIFY your_required_column VARCHAR(255) NOT NULL DEFAULT 'default_value';

import sqlite3

def insert_record(data):
    columns = []
    values = []
    for key, value in data.items():
        if value is not None:
            columns.append(key)
            values.append(value)
    
    query = f"INSERT INTO your_table ({', '.join(columns)}) VALUES ({', '.join(['?']*len(values))})"
    conn = sqlite3.connect('your_database.db')
    cursor = conn.cursor()
    cursor.execute(query, values)
    conn.commit()
    conn.close()

# 示例数据，忽略必填字段 'required_field'
data = {
    'optional_field': 'some_value',
    # 'required_field': None  # 故意不提供这个字段
}
insert_record(data)

CREATE TRIGGER your_trigger_name
BEFORE INSERT ON your_table
FOR EACH ROW
BEGIN
    IF NEW.your_required_column IS NULL THEN
        SET NEW.your_required_column = 'default_value';
    END IF;
END;