Elep

function onchangedatabase() {
    console.log('database');
    var warehouse = $('#warehouse-mapping').val();
    var database = $('#database-mapping').val();
    var schema = $('#schema-mapping');
    schema.find('option').remove();
    var table = $('#table-mapping');
    table.find('option').remove();
    var event = $('#event-col-mapping');
    event.find('option').remove();
    var customer = $('#customer-col-mapping');
    customer.find('option').remove();
    var timestamp = $('#timestamp-col-mapping');
    timestamp.find('option').remove();
    var metadata = $('#metadata-col-mapping');
    metadata.find('option').remove();
    if (warehouse !== '' && database !== '') {
        $.ajaxSetup({
            beforeSend: function (xhr, settings) {
                if (!/^(GET|HEAD|OPTIONS|TRACE)$/i.test(settings.type) && !this.crossDomain) {
                    xhr.setRequestHeader("X-CSRFToken", $('meta[name="csrf-token"]').attr('content'));
                }
            }
        });
        $.ajax({
            url: 'changeschema',
            type: 'POST',
            data: {'warehouse': warehouse, 'database': database},
            success: function (response) {
                if (response.success === true) {
                    schema.append('<option></option>');
                    for (const item in response.schema_list) {
                        schema.append('<option value=' + response.schema_list[item] + '>' + response.schema_list[item] + '</option>');
                    }
                }
            }
        });
    }
}

function onchangeschema() {
    console.log('schema');
    var warehouse = $('#warehouse-mapping').val();
    var database = $('#database-mapping').val();
    var schema = $('#schema-mapping').val();
    var table = $('#table-mapping');
    table.find('option').remove();
    var event = $('#event-col-mapping');
    event.find('option').remove();
    var customer = $('#customer-col-mapping');
    customer.find('option').remove();
    var timestamp = $('#timestamp-col-mapping');
    timestamp.find('option').remove();
    var metadata = $('#metadata-col-mapping');
    metadata.find('option').remove();
    if (warehouse !== '' && database !== '' && schema !== '') {
        $.ajaxSetup({
            beforeSend: function (xhr, settings) {
                if (!/^(GET|HEAD|OPTIONS|TRACE)$/i.test(settings.type) && !this.crossDomain) {
                    xhr.setRequestHeader("X-CSRFToken", $('meta[name="csrf-token"]').attr('content'));
                }
            }
        });
        $.ajax({
            url: 'changetable',
            type: 'POST',
            data: {'warehouse': warehouse, 'database': database, 'schema': schema},
            success: function (response) {
                console.log(response);
                if (response.success === true) {
                    table.append('<option></option>');
                    for (const item in response.table_list) {
                        console.log(response.table_list[item]);
                        table.append('<option value=' + response.table_list[item] + '>' + response.table_list[item] + '</option>');
                    }
                }
            }
        });
    }
}

function onchangetable() {
    console.log('table');
    var warehouse = $('#warehouse-mapping').val();
    var database = $('#database-mapping').val();
    var schema = $('#schema-mapping').val();
    var table = $('#table-mapping').val();

var event = $('#event-col-mapping');
    event.find('option').remove();
    var customer = $('#customer-col-mapping');
    customer.find('option').remove();
    var timestamp = $('#timestamp-col-mapping');
    timestamp.find('option').remove();
    var metadata = $('#metadata-col-mapping');
    metadata.find('option').remove();
    if (warehouse !== '' && database !== '' && schema !== '') {
        $.ajaxSetup({
            beforeSend: function (xhr, settings) {
                if (!/^(GET|HEAD|OPTIONS|TRACE)$/i.test(settings.type) && !this.crossDomain) {
                    xhr.setRequestHeader("X-CSRFToken", $('meta[name="csrf-token"]').attr('content'));
                }
            }
        });
        $.ajax({
            url: 'changecolumn',
            type: 'POST',
            data: {'warehouse': warehouse, 'database': database, 'schema': schema, 'table': table},
            success: function (response) {
                console.log(response);
                if (response.success === true) {
                    event.append('<option></option>');
                    customer.append('<option></option>');
                    timestamp.append('<option></option>');
                    metadata.append('<option></option>');
                    for (const item in response.column_list) {
                        console.log(response.column_list[item]);
                        event.append('<option value=' + response.column_list[item] + '>' + response.column_list[item] + '</option>');
                        customer.append('<option value=' + response.column_list[item] + '>' + response.column_list[item] + '</option>');
                        timestamp.append('<option value=' + response.column_list[item] + '>' + response.column_list[item] + '</option>');
                        metadata.append('<option value=' + response.column_list[item] + '>' + response.column_list[item] + '</option>');
                    }
                }
            }
        });
    }
}