!636

!modern

!* ctr

main {

  psvm {

    new SnippetDB db;

    db.importMySQLDump(gunzipToText("#1000673"));

    //db.printStats();

    print();

    db.printFullSnippet("#636");

  }

  static class Table {

    List<List<String>> data;

    List<String> fields;

    *(List<List<String>> *data, List<String> *fields) {}

    Map<S, S> rowAsMap(L<S> row) {

      new Map<S, S> map;

      for (int i = 0; i < row.size(); i++)

        map.put(fields.get(i), row.get(i));

      return map;

    }

  }

  static class SnippetDB {

    Map<String, List> tables;

    Map<String, List> tableFields;

    void importMySQLDump(String dump) {

      print("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"));

    }

    void printStats() {

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

      print(structure(tableFields));

    }

    Table table(String name) {

      return new Table(tables.get(name), tableFields.get(name));

    }

    Map<S, S> getFullSnippet(String id) {

      id = "" + parseSnippetID(id);

      Table t = table("snippets_public");

      for (List row : t.data) {

        Map<S, S> map = t.rowAsMap(row);

        String _id = map.get("sn_id");

        if (id.equals(_id))

          return map;

      }

      return null;

    }

    void printFullSnippet(S id) {

      print(structure(getFullSnippet(id)));

    }

  }

}