(* COCANWIKI scripts.
 * Written by Richard W.M. Jones <rich@merjis.com>.
 * Copyright (C) 2004 Merjis Ltd.
 * $Id: edit_hostnames_form.ml,v 1.2 2004/09/07 13:40:10 rich Exp $
 *)

open Apache
open Registry
open Cgi
open Printf

open Cocanwiki
open Cocanwiki_template

let template = get_template "admin/edit_hostnames_form.html"

let run r (q : cgi) (dbh : Dbi.connection) _ _ =
  let hostid = int_of_string (q#param "hostid") in

  template#set "id" (string_of_int hostid);

  let sth = dbh#prepare_cached
	      "select canonical_hostname from hosts where id = ?" in
  sth#execute [`Int hostid];

  let canonical_hostname = sth#fetch1string () in
  template#set "canonical_hostname" canonical_hostname;

  let sth = dbh#prepare_cached "select name from hostnames
                                 where hostid = ?
                                   and name <> ?" in
  sth#execute [`Int hostid; `String canonical_hostname];

  let hostnames = sth#map (function [`String hostname] -> hostname
			     | _ -> assert false) in
  template#set "hostnames" (String.concat "\n" hostnames);

  q#template template

let () =
  register_script run