Setting Up Database Objects

-======= -Setting Up Database Objects

Prev	Chapter 8. Development Tutorial	Next

Setting Up Database Objects

by Joel Aufrecht

->>>>>>> 1.42 +Setting Up Database Objects

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. -<<<<<<< tutorial-database.html -

Code the data model

We create all database objects with scripts in the - myfirstpackage/sql/ directory. All -======= -

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 ->>>>>>> 1.42 database scripts are database-specific and are thus in either the myfirstpackage/sql/oracle or myfirstpackage/sql/postgresql directory. @@ -42,23 +32,13 @@ repository functions to simplify our database creation. (More information about ACS Objects. More information about the Content Repository.) -<<<<<<< tutorial-database.html -

Figure 9.2. Tutorial Data Model

The top of each sql file has some -======= -

Figure 8.2. Tutorial Data Model

The top of each sql file has some ->>>>>>> 1.42 +

Figure 9.2. 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 -<<<<<<< tutorial-database.html - $Id$ will automatically be - expanded when the file is checked in to cvs.

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

Paste the text below into the file, save, and close.

Figure 9.3. The Database Creation Script

-- creation script
-=======
       $Id$ will automatically be
       expanded when the file is checked in to cvs.
[$OPENACS_SERVICE_NAME ~]$ cd /var/lib/aolserver/$OPENACS_SERVICE_NAME/packages/myfirstpackage/sql/postgresql
-[$OPENACS_SERVICE_NAME postgresql]$ emacs myfirstpackage-create.sql
Paste the text below into the file, save, and close.
Figure 8.3. The Database Creation Script
-- creation script
->>>>>>> 1.42
+[$OPENACS_SERVICE_NAME postgresql]$ emacs myfirstpackage-create.sql
Paste the text below into the file, save, and close.
Figure 9.3. The Database Creation Script
-- creation script
 --
 -- @author joel@aufrecht.org
 -- @cvs-id &Id:$
@@ -82,11 +62,7 @@
     object.  Notice the use of "mfp."  This is derived from "My
     First Package" and 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.
-<<<<<<< tutorial-database.html
-[$OPENACS_SERVICE_NAME postgresql]$ emacs myfirstpackage-drop.sql
Figure 9.4. Database Deletion Script
-- drop script
-=======
-[$OPENACS_SERVICE_NAME postgresql]$ emacs myfirstpackage-drop.sql
Figure 8.4. Database Deletion Script
-- drop script
->>>>>>> 1.42
+[$OPENACS_SERVICE_NAME postgresql]$ emacs myfirstpackage-drop.sql
Figure 9.4. Database Deletion Script
-- drop script
 --
 -- @author joel@aufrecht.org
 -- @cvs-id &Id:$
@@ -113,8 +89,4 @@
                        0
 (1 row)
 
-<<<<<<< tutorial-database.html
-[$OPENACS_SERVICE_NAME postgresql]$
Once both scripts are working without errors, run the create script one last time and proceed.
[$OPENACS_SERVICE_NAME postgresql]$ psql service0 -f myfirstpackage-create.sql
Prev Home  Next
Creating an Application Package Up  Creating Web Pages
docs@openacs.org
View comments on this page at openacs.org
-=======
 [$OPENACS_SERVICE_NAME postgresql]$
Once both scripts are working without errors, run the create script one last time and proceed.
[$OPENACS_SERVICE_NAME postgresql]$ psql service0 -f myfirstpackage-create.sql
Prev Home  Next
Creating an Application Package Up  Creating Web Pages
docs@openacs.org
View comments on this page at openacs.org
->>>>>>> 1.42

Prev	Home	Next
Creating an Application Package	Up	Creating Web Pages