Lake District Online Database

Lake District Online Database (affectionately known as LDODB) is a PHP application written using the Symfony Framework. It is a digital tool for collecting metadata about books in the Wordsworth Collection in SFU's Special Collections and Rare Books.

Requirements

We have tried to keep the requirements minimal. How you install these requirements is up to you, but we have provided some recommendations

• Apache >= 2.4
• PHP >= 7.4
• Composer >= 2.0
• MariaDB >= 10.8¹
• Yarn >= 1.22

Installation

1. Fork and clone the project from GitHub.

2. Install the git submodules. git submodule update --init is a good way to do this

3. Install composer dependencies with composer install.

4. Install yarn dependencies with yarn install.

5. Create a MariaDB database and user.

    DROP DATABASE IF EXISTS ldodb;
    CREATE DATABASE ldodb;
    DROP USER IF EXISTS ldodb@localhost;
    CREATE USER ldodb@localhost IDENTIFIED BY 'abc123';
    GRANT ALL ON ldodb.* TO ldodb@localhost;

6. Copy .env to .env.local and edit configuration to suite your needs.

7. Either 1) create the schema and load fixture data, or 2) load a MySQLDump file if one has been provided.

   1.  php ./bin/console doctrine:schema:create --quiet
       php ./bin/console doctrine:fixtures:load --group=dev --purger=fk_purger

   2. ```bash
     mysql ldodb < ldodb.sql
   

8. Visit http://localhost/ldodb

9. happy coding!

Some of the steps above are made easier with the included MakeFiles which are in a git submodule. If you missed step 2 above they will be missing.

Footnotes

1. A similar version of MySQL should also work, but will not be supported. ↩