clsql-pg-introspect

clsql-pg-introspect is a package for introspecting a PostgreSQL database from clsql. Great for quickly defining your own classes based on existing tables. This is often needed with Database programming.

The little package with the huge name.

It is licensed under the LLGPL.

Download ASDF package from http://common-lisp.net/project/pg-introspect/release/clsql-pg-introspect-latest.tar.gz

DARCS repository: http://www.common-lisp.net/project/pg-introspect/pg-introspect/

Browse the DARCS repository: (this won't work until Alan gets off his ass and fixes it) http://code.microarray.omrf.org/cgi-bin/darcs.cgi/alan-clsql-pg-introspect/

Usage summary:

(clsql-pg-introspect:gen-view-class boxes)

This would make a CLSQL class based on the table boxes - including its not-null, unique, primary key, and foreign key attributes. With joins defined, even.

Or, more often:

(clsql-pg-introspect:gen-view-classes-for-database(("" "database" "username" "password") :postgresql) boxes tubes flyers planes postage-stamps)

This would make CLSQL classes for the tables boxes, tubes, flyers, planes, and postage_stamps.

There are more things you can do - the package and functions are documented, and README has a few things to say.

Worksforme. Patches welcome!

- Alan Shields

This page is linked from: Alan Shields

CLiki pages can be edited by anyone at any time. Imagine a fearsomely comprehensive disclaimer of liability. Now fear, comprehensively