1 |
dpavlin |
1 |
Gedafe Examples |
2 |
|
|
=============== |
3 |
|
|
|
4 |
|
|
This directory contains an example application for Gedafe. |
5 |
|
|
|
6 |
|
|
Useful Functions |
7 |
|
|
---------------- |
8 |
|
|
|
9 |
|
|
Gedafe is built on the premessis, that all application logic is embeded into |
10 |
|
|
the database. This means that you have to use stored procedures in order |
11 |
|
|
to achieve complex application logic. |
12 |
|
|
|
13 |
|
|
In the file useful-functions.sql you can find some example code to get you |
14 |
|
|
started. |
15 |
|
|
|
16 |
|
|
|
17 |
|
|
Simple Application |
18 |
|
|
------------------ |
19 |
|
|
|
20 |
|
|
It's a very simple ordering system with products, |
21 |
|
|
customers and orders. |
22 |
|
|
|
23 |
|
|
demo1.sql contains the PostgreSQL command to create the database. You have |
24 |
|
|
to first create a database called 'demo1': |
25 |
|
|
|
26 |
|
|
$ createdb -U postgres demo1 |
27 |
|
|
|
28 |
|
|
and then execute: |
29 |
|
|
|
30 |
|
|
$ psql -U postgres -f demo1.sql demo1 |
31 |
|
|
|
32 |
|
|
demo1.cgi is the Gedafe startup script for this application. Note that you |
33 |
|
|
have to adjust the paths in demo1.cgi to match up with the place you have |
34 |
|
|
installed Gedafe. |
35 |
|
|
|
36 |
|
|
Example templates are also included (in the 'templates' directory). |
37 |
|
|
These are usable for any application. |
38 |
|
|
|
39 |
|
|
The 'images' directory contains the images that are references in the |
40 |
|
|
example templates. Install them so that they can be accessed under the |
41 |
|
|
relative URL 'images' (relative to the script, if you want them in another |
42 |
|
|
place just change the templates). |