(* COCANWIKI - a wiki written in Objective CAML.
* Written by Richard W.M. Jones <rich@merjis.com>.
* Copyright (C) 2004 Merjis Ltd.
- * $Id: create_host_form.ml,v 1.4 2004/09/09 12:21:22 rich Exp $
+ * $Id: create_host_form.ml,v 1.6 2006/03/28 16:24:08 rich Exp $
*
* This program is free software; you can redistribute it and/or modify
* it under the terms of the GNU General Public License as published by
let run r =
let q = new cgi r in
- (* let dbh = Cocanwiki._get_dbh r in *)
+ let dbh = PGOCaml.connect ~database:"cocanwiki" () in
+ PGOCaml.begin_work dbh;
+
+ (* Get the template hosts. *)
+ let rows = PGSQL(dbh)
+ "select id, canonical_hostname from hosts
+ where is_template order by 2" in
+
+ let table = List.map (
+ fun (id, canonical_hostname) ->
+ [ "id", Template.VarString (Int32.to_string id);
+ "canonical_hostname", Template.VarString canonical_hostname ]
+ ) rows in
+ template#table "templates" table;
+
q#template template
let () =