Index: openacs-4/packages/acs-core-docs/www/tutorial-database.html =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-core-docs/www/tutorial-database.html,v diff -u -N -r1.23.2.1 -r1.23.2.2 --- openacs-4/packages/acs-core-docs/www/tutorial-database.html 18 Apr 2004 11:55:50 -0000 1.23.2.1 +++ openacs-4/packages/acs-core-docs/www/tutorial-database.html 29 Apr 2004 14:51:01 -0000 1.23.2.2 @@ -1,7 +1,7 @@ Setting Up Database Objects
Alex logo
Prev Chapter�9.�Development Tutorial Next

Setting Up Database Objects

by Joel Aufrecht

OpenACS docs are written by the named authors, and may be edited by OpenACS documentation staff. -

Code the data model

We create all database objects with scripts in the +

Code the data model

We create all database objects with scripts in the myfirstpackage/sql/ directory. All database scripts are database-specific and are thus in either the myfirstpackage/sql/oracle or @@ -31,13 +31,13 @@ repository functions to simplify our database creation. (More information about ACS Objects. More information about the Content Repository.) -

Figure�9.2.�Tutorial Data Model

Tutorial Data Model

The top of each sql file has some +

Figure�9.2.�Tutorial Data Model

Tutorial Data Model

The top of each sql file has some standard comments, including doc tags such as @author which will be picked up by the API browser. The string $Id$ will automatically be expanded when the file is checked in to cvs.

[service0 ~]$ cd /var/lib/aolserver/service0/packages/myfirstpackage/sql/postgresql
-[service0 postgresql]$ emacs myfirstpackage-create.sql

Paste this into the file and save and close.

Figure�9.3.�Database Creation Script - master create file

-- creation script
+[service0 postgresql]$ emacs myfirstpackage-create.sql

Paste this into the file and save and close.

Figure�9.3.�Database Creation Script - master create file

-- creation script
 --
 -- @author joel@aufrecht.org
 -- @cvs-id &Id:$
@@ -62,7 +62,7 @@
     First Package," ensures that our object is unlikely to conflict
     with objects from other packages.
Create a database file to drop everything if the package
         is uninstalled.
-[service0 postgresql]$ emacs myfirstpackage-drop.sql
Figure�9.4.�Database deletion script
-- drop script
+[service0 postgresql]$ emacs myfirstpackage-drop.sql
Figure�9.4.�Database deletion script
-- drop script
 --
 -- @author joel@aufrecht.org
 -- @cvs-id &Id:$