Changeset 93 for waeup_z2sql


Ignore:
Timestamp:
26 Oct 2005, 22:19:19 (21 years ago)
Author:
toni
Message:
  • replaced DB schema in .sql by a pg dump that also includes sample data
  • added faculty entry to the app
Location:
waeup_z2sql/trunk
Files:
2 added
2 deleted
1 edited

Legend:

Unmodified
Added
Removed
  • waeup_z2sql/trunk/README.txt

    r62 r93  
    11
    2 To install this software, manually adapt the schema to your needs
    3 (esp.: change the usernames contained therein), and create a
    4 database. The pre-configured database name is "waeup". Then
    5 import the schema:
     2To install this software, load the database from the dump:
    63
    7 $ psql waeup < waeup-schema.sql
     4$ pg_restore waeup-dump.dump
    85
    96If you get errors, you may need some prerequisites, like eg PL-SQL.
    10 
    117
    128After that, get a Zope instance, preferably 2.8.2 (I only tested with that),
    … …  
    1814Please note that this is less than alpha quality software.
    1915
    20 Suggestions on how to improve this software is very welcome, as well as useful
    21 patches, although I can promise you nothing.
     16Currently, the following things should work:
     17
     18- A student ID can be checked against a pre-loaded list of student IDs.
     19
     20- A student can get a bed.
     21
     22- A student can enter a faculty. This requires that he has sufficient good
     23  results in his examinations, and also the right set of subjects which
     24  are required on a per-course-of-study basis.
     25
     26During all this, scratchcard PINs are consumed, which means, that these
     27will be emtpy at some point.
     28
     29What doesn't work:
     30
     31- There is way to upload all the photocopied stuff.
     32- Workflow in general is poor to non-existant, as well as
     33- security.
     34
     35The absense of security means that there is no protection against misuse.
     36
     37This could be retrofitted somewhat, along with the much desirable
     38re-architecturing, or at least restructuring, of the application.
     39
     40
     41Suggestions and support on how to improve this software is very welcome, as
     42well as useful patches, although I can promise you nothing at this point.
    2243
    2344
    … …  
    2950- README.txt (this file you are currently reading)
    3051- demo-2005-10-20.1.zexp (code "base")
    31 - waeup-schema.sql (database structure for Pg)
     52- waeup-dump.dump (database structure and sample data for Pg)
    3253
    3354
    34 2005-10-20, Toni Mueller, support@oeko.net
     552005-10-26, Toni Mueller, support@oeko.net
    3556
Note: See TracChangeset for help on using the changeset viewer.