Function is_this_table

sqladvisor/main.cc:669–713

}

bool is_this_table(const char * field_name, char * table_name) {
    MYSQL *con = mysql_init(NULL);
    if (con == NULL || table_name == NULL || field_name == NULL) {
        finish_with_error(con);
    }

    if (mysql_real_connect(con, options.host, options.username,
            options.password, DBNAME, options.port, NULL, 0) == NULL) {
        finish_with_error(con);
    }
    mysql_query(con, "set names utf8"); //指定字符集,确保能够执行含中文的SQL

    GString *table_count_sql = g_string_new(NULL);
    ulonglong table_count;
    g_string_sprintf(table_count_sql,
            "select count(*) from columns where TABLE_NAME = '%s' and COLUMN_NAME = '%s'",
            table_name, field_name);

    print_sql(table_count_sql->str);

    if (mysql_query(con, table_count_sql->str)) {
        finish_with_error(con);
    }

    MYSQL_RES *result = mysql_store_result(con);
    if (result == NULL) {
        finish_with_error(con);
    }

    int num_fields = mysql_num_fields(result);

    MYSQL_ROW row;

    if ((row = mysql_fetch_row(result))) {
        table_count = atoi(row[AFFECT_ROWS]);
    }
    g_string_free(table_count_sql, TRUE);
    mysql_free_result(result);
    mysql_close(con);

    if (table_count == 0)
        return false;
    else
        return true;
}

void mysql_sql_parse_index(Field_Description *field_desp) {
    INDEX_FIELD * field_index = new INDEX_FIELD(field_desp);