!636

!modern

main {

  static Map<String, List> tables;

  static Map<String, List> tableFields;

  psvm {

    importMySQLDump(gunzipToText("#1000673"));

    printStats();

    // Try a search!

    searchSnippet("hotwire");

  }

  static void importMySQLDump(String dump) {

    System.out.println("Importing " + dump.length() + " chars.");

    Class importer = hotwire("#1000660");

    set(importer, "in", dump);

    callMain(importer);

    tables = (Map) get(importer, "tables");

    tableFields = (Map) get(importer, "tableFields");

    print("Total rows imported: " + get(importer, "totalRows"));

  }

  static void printStats() {

    print(structure(tables.keySet()));

    print(structure(tableFields));

  }

  static void searchSnippet(String pat) {

    // preparation

    List<List> table = tables.get("snippets_public");

    List fields = tableFields.get("snippets_public");

    int iID = fields.indexOf("sn_id");

    int iTitle = fields.indexOf("sn_title");

    // search

    System.out.println("\nResult of search for " + quote(pat) + ":\n");

    for (List row : table) {

      if (indexOfIgnoreCase(row.get(iTitle), pat) >= 0)

        print("#" + row.get(iID) + " - " + row.get(iTitle));

    }

  }

}