Changeset 93 for waeup_z2sql/trunk

Timestamp:

26 Oct 2005, 22:19:19 (19 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:

• README.txt (modified) (3 diffs)
• demo-2005-10-20.1.zexp (deleted)
• demo-2005-10-26.zexp (added)
• waeup-dump.dump (added)
• waeup-schema.sql (deleted)

waeup_z2sql/trunk/README.txt

@@ -1 +1 @@
 
-To install this software, manually adapt the schema to your needs
-(esp.: change the usernames contained therein), and create a
-database. The pre-configured database name is "waeup". Then
-import the schema:
+To install this software, load the database from the dump:
 
-$ psql waeup < waeup-schema.sql
+$ pg_restore waeup-dump.dump
 
 If you get errors, you may need some prerequisites, like eg PL-SQL.
-
 
 After that, get a Zope instance, preferably 2.8.2 (I only tested with that),
@@ -18 +14 @@
 Please note that this is less than alpha quality software.
 
-Suggestions on how to improve this software is very welcome, as well as useful
-patches, although I can promise you nothing.
+Currently, the following things should work:
+
+- A student ID can be checked against a pre-loaded list of student IDs.
+
+- A student can get a bed.
+
+- A student can enter a faculty. This requires that he has sufficient good
+  results in his examinations, and also the right set of subjects which
+  are required on a per-course-of-study basis.
+
+During all this, scratchcard PINs are consumed, which means, that these
+will be emtpy at some point.
+
+What doesn't work:
+
+- There is way to upload all the photocopied stuff.
+- Workflow in general is poor to non-existant, as well as
+- security.
+
+The absense of security means that there is no protection against misuse.
+
+This could be retrofitted somewhat, along with the much desirable
+re-architecturing, or at least restructuring, of the application.
+
+
+Suggestions and support on how to improve this software is very welcome, as
+well as useful patches, although I can promise you nothing at this point.
 
 
@@ -29 +50 @@
 - README.txt (this file you are currently reading)
 - demo-2005-10-20.1.zexp (code "base")
-- waeup-schema.sql (database structure for Pg)
+- waeup-dump.dump (database structure and sample data for Pg)
 
 
-2005-10-20, Toni Mueller, support@oeko.net
+2005-10-26, Toni Mueller, support@oeko.net