!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));
    }
  }
}