import std.stdio;
import std.file;
import std.string;

void main() {
	foreach(string name; dirEntries("/home/me/d/dmd2/html/d/phobos", SpanMode.breadth)) {
		if(name[$-5..$] != ".html")
			continue;

		string mod = name[30..$-5].replace("_", ".");

		//writefln("%s", mod);

		string[string] anchors;

		auto o = File(mod ~ ".sql", "wt");

		foreach(line; File(name).byLine) {
			int index = line.indexOf("<a name=");
			if(index == -1)
				continue;

			int start = index + 9;
			int pos = start;
			while(line[pos] != '"')
				pos++;

			string aname = line[start..pos].idup;

			if(aname in anchors)
				continue;
			anchors[aname] = aname;
		}

		o.writefln("DELETE FROM symbols WHERE module = '%s';", mod);

		foreach(anchor; anchors) {
		//	writefln("%s", anchor);
		
			o.writefln("INSERT INTO symbols (symbol, name, module, target_href) VALUES ('%s', '%s', '%s', '%s');",
				mod ~ "." ~ anchor,
				anchor,
				mod,
				"http://digitalmars.com/d/2.0/phobos/" ~
					mod.replace(".", "_") ~ ".html#" ~ anchor
			);
			
		}
	}
}