Metadata-Version: 2.1
Name: ramp-database
Version: 0.2.1
Summary: Database model used in the RAMP bundle
Home-page: https://github.com/paris-saclay-cds/ramp-board
Maintainer: A. Boucaud, B. Kegl, G. Lemaitre, J. Van den Bossche
Maintainer-email: boucaud.alexandre@gmail.com, guillaume.lemaitre@inria.fr
License: BSD (3-clause)
Download-URL: https://github.com/paris-saclay-cds/ramp-board
Platform: UNKNOWN
Classifier: Intended Audience :: Science/Research
Classifier: Intended Audience :: Developers
Classifier: License :: OSI Approved
Classifier: Programming Language :: Python
Classifier: Topic :: Software Development
Classifier: Topic :: Scientific/Engineering
Classifier: Operating System :: Microsoft :: Windows
Classifier: Operating System :: POSIX
Classifier: Operating System :: Unix
Classifier: Operating System :: MacOS
Classifier: Programming Language :: Python :: 3.6
Classifier: Programming Language :: Python :: 3.7
Requires-Dist: bcrypt
Requires-Dist: click
Requires-Dist: gitpython
Requires-Dist: nbconvert
Requires-Dist: numpy
Requires-Dist: pandas
Requires-Dist: psycopg2
Requires-Dist: sqlalchemy
Provides-Extra: docs
Requires-Dist: sphinx ; extra == 'docs'
Requires-Dist: sphinx-rtd-theme ; extra == 'docs'
Requires-Dist: numpydoc ; extra == 'docs'
Provides-Extra: tests
Requires-Dist: pytest ; extra == 'tests'
Requires-Dist: pytest-cov ; extra == 'tests'

RAMP database model
===================

This package contains the ORM model for the RAMP database.

Set up of a PostgreSQL database
-------------------------------

1. create db directory and initialise the PostgreSQL database::

    mkdir postgres_dbs
    initdb postgres_dbs

2. start the PostgreSQL engine::

    pg_ctl -D postgres_dbs -l postgres_dbs/logfile start

3. create a user `<db_user>` and set a password `<db_password>`::

    createuser --pwprompt <db_user>

4. create the database called `<db_name>` for that user::

    createdb --owner=<db_user> <db_name>


