Function get_key_name

sqladvisor/main.cc:1031–1068

}

_SET_C get_key_name(const char *field_name, char *table_name,
        int seq_in_index) {
    if (options.verbose)
        sql_print_information(
                "第%d步：开始验证表中是否已存在相关索引。表名:%s, 字段名:%s, 在索引中的位置:%d \n", STEP_CNT++,
                table_name, field_name, seq_in_index);
    MYSQL *conn = mysql_init(NULL);
    if (conn == NULL || table_name == NULL || field_name == NULL) {
        finish_with_error(conn);
    }
    if (mysql_real_connect(conn, options.host, options.username,
            options.password, options.dbname, options.port, NULL, 0) == NULL) {
        finish_with_error(conn);
    }
    mysql_query(conn, "set names utf8");
    GString *table_exist_index_sql = g_string_new(NULL);
    g_string_sprintf(table_exist_index_sql,
            "show index from %s where Column_name ='%s' and Seq_in_index =%d",
            table_name, field_name, seq_in_index);
    print_sql(table_exist_index_sql->str);
    if (mysql_query(conn, table_exist_index_sql->str)) {
        finish_with_error(conn);
    }
    MYSQL_RES *result = mysql_store_result(conn);
    if (result == NULL) {
        finish_with_error(conn);
    }
    MYSQL_ROW row;
    _SET_C s_key;
    int num_fields = mysql_num_fields(result);
    while ((row = mysql_fetch_row(result))) {
        s_key.insert(strdup(row[INDEX_KEY_NAME]));
    }
    g_string_free(table_exist_index_sql, TRUE);
    mysql_free_result(result);
    mysql_close(conn);
    return s_key;
}

bool isPrimary(const char *field_name, char *table_name) {
    if (options.verbose)