Base and Demo databases: Difference between revisions

From OpenPetra Wiki
Jump to navigation Jump to search
(New page: == Base Database == The purpose of this database is to be able to start Petra and create a working environment from scratch. This means there is one default user SYSADMIN with password CHA...)
 
 
(3 intermediate revisions by the same user not shown)
Line 1: Line 1:
== Base Database ==
== Base Database ==
The purpose of this database is to be able to start Petra and create a working environment from scratch. This means there is one default user SYSADMIN with password CHANGME, which should be changed at the first login. Then you can create a site, and a ledger, etc.
The purpose of this database is to be able to start Petra and create a working environment from scratch. This means there is one default user SYSADMIN with password CHANGEME, which should be changed at the first login. Then you can create a site, and a ledger, etc.


At the moment the base database does not make sense yet, because the System Manager module is not available yet.
The base database is available here: https://github.com/openpetra/demo-databases/blob/master/base.yml.gz


== Demo Databases ==
== Demo Databases ==
The purpose of this database is to allow people to have quick results when investigating OpenPetra.org. You should be able to just login with user DEMO and password demo, and then you have already some partners in the system, and a demo ledger with some finance data to play with.
The purpose of this database is to allow people to have quick results when investigating OpenPetra.org. You should be able to just login with user DEMO and password demo, and then you have already some partners in the system, and a demo ledger with some finance data to play with.


Of course, there will be so many different scenarios how OpenPetra can be used, therefore there will be several demo databases available. If you are investigating Petra and you cannot find a demo database that suits you, please consider creating your own demo database and contribute it back to the community!
Of course, there will be so many different scenarios how OpenPetra can be used, therefore there will be several demo databases available. If you are investigating OpenPetra and you cannot find a demo database that suits you, please consider creating your own demo database and contribute it back to the community!


Here is a list of the planned or available demo databases:
Here is a list of available demo databases:
* [[German demo database]] (delivered with the Preview installer)
* [[German demo database]] (used at https://demo.openpetra.org)
* [[Kenyan demo database]] (TODO)
 
* [[US demo database]] (TODO)
The demo databases are available here: https://github.com/openpetra/demo-databases
 
We have 3 different types of demo databases:
* demoWith1ledger.yml.gz: just one ledger, and one financial year
* demoMultipleYears.yml.gz: one ledger, with multiple financial years
* demoWith2ledgers.yml.gz: same as the previous demo, plus another ledger with one financial year.
 
The demo databases are generated from generated data, stored at https://github.com/openpetra/demo-databases/tree/master/generatedDataUsedForDemodatabases
 
The job that creates the demo databases runs at LBS: https://lbs.solidcharity.com/package/solidcharity/openpetra/demodb#test_centos/7/amd64
 
This is the script that creates the demo databases: https://github.com/SolidCharity/lbs-openpetra/blob/master/demodb/setup.sh

Latest revision as of 19:41, 4 November 2020

Base Database

The purpose of this database is to be able to start Petra and create a working environment from scratch. This means there is one default user SYSADMIN with password CHANGEME, which should be changed at the first login. Then you can create a site, and a ledger, etc.

The base database is available here: https://github.com/openpetra/demo-databases/blob/master/base.yml.gz

Demo Databases

The purpose of this database is to allow people to have quick results when investigating OpenPetra.org. You should be able to just login with user DEMO and password demo, and then you have already some partners in the system, and a demo ledger with some finance data to play with.

Of course, there will be so many different scenarios how OpenPetra can be used, therefore there will be several demo databases available. If you are investigating OpenPetra and you cannot find a demo database that suits you, please consider creating your own demo database and contribute it back to the community!

Here is a list of available demo databases:

The demo databases are available here: https://github.com/openpetra/demo-databases

We have 3 different types of demo databases:

  • demoWith1ledger.yml.gz: just one ledger, and one financial year
  • demoMultipleYears.yml.gz: one ledger, with multiple financial years
  • demoWith2ledgers.yml.gz: same as the previous demo, plus another ledger with one financial year.

The demo databases are generated from generated data, stored at https://github.com/openpetra/demo-databases/tree/master/generatedDataUsedForDemodatabases

The job that creates the demo databases runs at LBS: https://lbs.solidcharity.com/package/solidcharity/openpetra/demodb#test_centos/7/amd64

This is the script that creates the demo databases: https://github.com/SolidCharity/lbs-openpetra/blob/master/demodb/setup.sh