Summary

The AddressDB class provides an addressbook-oriented interface to the address book database. In particular, all SQL commands are hidden within this class.

The addressbook database table must be created and properly configured before using this class! The following SQL commands can be used with PostgreSQL to build the database table:

 SET search_path = public, pg_catalog;

 CREATE FUNCTION plpgsql_call_handler () RETURNS language_handler
     AS '/usr/lib/pgsql/plpgsql.so', 'plpgsql_call_handler'
        LANGUAGE c;

 CREATE TRUSTED PROCEDURAL LANGUAGE plpgsql HANDLER plpgsql_call_handler;

 CREATE TABLE addressbook (
     name character varying(64),
     address text,
     email character varying(64),
     phone character varying(64),
     company character varying(64),
     misc text,
     category character varying(128)
     );

 CREATE FUNCTION insertabook () RETURNS "trigger"
     AS '
         DECLARE a_rec record;
         BEGIN
             SELECT * INTO a_rec FROM addressbook WHERE name=new.name;
             IF NOT FOUND THEN RETURN new;
             ELSE UPDATE addressbook SET address=new.address,email=new.email,
                                         phone=new.phone,
                                         company=new.company,misc=new.misc,
                                         category=new.category
                                     WHERE name=new.name;
                  RETURN null;
             END IF;
         END;'
     LANGUAGE plpgsql;

 CREATE TRIGGER trigger_insert
     BEFORE INSERT ON addressbook
     FOR EACH ROW
     EXECUTE PROCEDURE insertabook ();

Access to this database table must be made available through Unicon's ODBC support.

Superclasses:

Object

Package:

addressbook

File:

addressdb.icn

AddressDB(user, passwd, dsn, tabl:"addressbook")

isValid(s)

loadView(criteria, order:"name")

performSearch(addr)

reload()

remove(addr)

setCatCondition(wc, cats, terminator:"\n")

setCondition(wc, id, test, value)

storeAddress(addr)