Function main

sqladvisor/main.cc:1332–1418

}

int main(int argc, char **argv) {

    LEX *sql_lex;
    String *lex_string = NULL;
    GKeyFile *keyfile = NULL;
    GError *error = NULL;
    GOptionContext *context = NULL;
    char *query = NULL;
    char *sqlparse_path = strdup("/usr/local/sqlparser");
    int i = 0;
    ConnectionOptionsInit(&options);
    context = g_option_context_new("sqladvisor");
    g_option_context_add_main_entries(context, entries, NULL);
    g_option_context_set_summary(context, "SQL Advisor Summary");
    if (!g_option_context_parse(context, &argc, &argv, &error)) {
        sql_print_error("option parsing failed:%s\n", error->message);
        exit(1);
    }
    g_option_context_free(context);
    if (options.configfile != NULL) {
        //load config file
        keyfile = g_key_file_new();
        g_key_file_set_list_separator(keyfile, SEP);
        if (g_key_file_load_from_file(keyfile, options.configfile,
                G_KEY_FILE_NONE, &error) == FALSE) {
            g_key_file_free(keyfile);
            sql_print_error("load config file failed:%s\n", error->message);
        }
        if (g_option_keyfile_parse(keyfile, GROUT_NAME, entries) < 0) {
            g_key_file_free(keyfile);
            sql_print_error("read config file failed:%s\n", error->message);
        }
    }

    if (mysqld_init(sqlparse_path)) {
        sql_print_error("加载sqlparser模块有错 \n");
        if(sqlparse_path) free(sqlparse_path);
        return -1;
    }
    if(sqlparse_path) free(sqlparse_path);

    if (options.username == NULL || options.password == NULL
            || options.host == NULL || options.dbname == NULL
            || options.query[0] == NULL) {
        mysqld_cleanup();
        return -1;
    }
    while ((query = options.query[i]) != NULL) {
        sql_lex = sql_parser(query, options.dbname);

        if (sql_lex == NULL) {
            sql_print_error("sqlparser 解析出错,返回值lex为空 \n");
            continue;
        }

        current_lex = &sql_lex->select_lex;
        while (current_lex != NULL) {
            lex_string = new (thd->mem_root) String();