Function isPrimary

sqladvisor/main.cc:1070–1110

}

bool isPrimary(const char *field_name, char *table_name) {
    if (options.verbose)
        sql_print_information("第%d步：开始验证 字段%s是不是主键。表名:%s \n", STEP_CNT++,
                field_name, table_name);
    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 Key_name = 'PRIMARY' and Column_name ='%s' and Seq_in_index = 1",
            table_name, field_name);
    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);
    }
    bool is_primary = false;
    if (mysql_num_rows(result) > 0) {
        if (options.verbose)
            sql_print_information("第%d步：字段%s是主键。表名:%s \n", STEP_CNT++,
                    field_name, table_name);
        is_primary = true;
    } else {
        if (options.verbose)
            sql_print_information("第%d步：字段%s不是主键。表名:%s \n", STEP_CNT++,
                    field_name, table_name);
    }
    g_string_free(table_exist_index_sql, TRUE);
    mysql_free_result(result);
    mysql_close(conn);
    return is_primary;
}

bool is_like_pre(char * field_ptr) {
    bool meet_space = false;