PHPackages ubc/examdb - PHPackages - PHPackages [Skip to content](#main-content)[PHPackages](/)[Directory](/)[Categories](/categories)[Trending](/trending)[Leaderboard](/leaderboard)[Changelog](/changelog)[Analyze](/analyze)[Collections](/collections)[Log in](/login)[Sign up](/register) 1. [Directory](/) 2. / 3. [Database & ORM](/categories/database) 4. / 5. ubc/examdb AbandonedArchivedProject[Database & ORM](/categories/database) ubc/examdb ========== Exam Database 143[2 issues](https://github.com/ubc/examdb/issues)PHP Since Apr 26Pushed 9y ago8 watchersCompare [ Source](https://github.com/ubc/examdb)[ Packagist](https://packagist.org/packages/ubc/examdb)[ RSS](/packages/ubc-examdb/feed)WikiDiscussions master Synced 1mo ago READMEChangelogDependenciesVersions (1)Used By (0) Exam Database ============= [](#exam-database) Running in 5 mins ----------------- [](#running-in-5-mins) 1. Register an account on [Openshift](https://www.openshift.com/). 2. Install [CLI](https://www.openshift.com/developers/rhc-client-tools-install) 3. Provision the application by running the following command: ``` rhc app create examdb php-5.4 mysql-5.5 phpmyadmin-4 --from-code=https://github.com/ubc/examdb.git ``` 4. Setup custom parameters by custom environment variable: (for full list of available env variables, see app/config/params.php)s ``` rhc env set auth2_username=service_username auth2_password=service_password auth2_service_application=service_app -a examdb ``` 5. Open the browser and enter the URL printed from the result of above command. Detailed Version ---------------- [](#detailed-version) ### 1) Provision the Application [](#1-provision-the-application) Provision a php application (phpmyadmin-4 is optional) ``` rhc app create examdb php-5.4 mysql-5.5 phpmyadmin-4 --from-code=https://github.com/ubc/examdb.git ``` Once the application is created, Openshift will give out the URL of the app, SSH address and git repo. Those information can be obtained by running the following command as well: ``` rhc app show examdb ``` The database parameters are setup in app/config/params.php, which is imported by app/config/config.yml. ### 2) Checking your System Configuration [](#2-checking-your-system-configuration) Execute the `check.php` script from the command line: ``` ssh OPENSHIFT_SSH_ADDRESS cd $OPENSHIFT_REPO_DIR php app/check.php ``` The script returns a status code of `0` if all mandatory requirements are met, `1` otherwise. To access the `config.php` script from a browser, a ssh tunnel has to be created as config.php is only accessible from localhost ``` rhc port-forward ``` Then open the URL from the browser: ``` http://your_openshift_domain/config.php ``` If you get any warnings or recommendations, fix them before moving on. ### 3) To access other component directly [](#3-to-access-other-component-directly) If mysql or other database is installed and you want to access it directly. E.g. using MySQLBench or other tools. You can use the port forward mentioned above. ``` rhc port-forward ``` The port will be forwarded to localhost and you can setup your tool to connect to localhost. Development ----------- [](#development) ### Installation [](#installation) 1. Install Vagrant The project environment can be provision by [Vagrant](http://www.vagrantup.com/). Follow the instruction on the site to install vagrant first. Then install vagrant-hostmanager plugin if you want vagrant to manage your /etc/hosts for you. ``` vagrant plugin install vagrant-hostmanager vagrant plugin install vagrant-bindfs ``` Otherwise, you will need to manually add the following line to your /etc/hosts ``` 127.0.0.1 examdb.dev ``` 2. Checkout the Source ``` git clone git@github.com:ubc/examdb.git ``` 3. Setup the Dev VM ``` cd examdb && vagrant up ``` 4. Open a browser from host ``` http://examdb.dev:8089/app_dev.php ``` 5. Develop! ### Running Tests [](#running-tests) ``` bin/phing test ``` NOTES ----- [](#notes) - Default username and password are both "admin" - When testing student features, the student user puid should be 12345678, which is the ID used in app/fixtures data for local SIS data repository - The test fixture contains two sections: MATH 101 and ENGL 100 - Update dependencies: it may run into memory limits when running `composer update`, so use the following command: ``` php -d memory_limit=-1 /path/to/composer update ``` - to see changes if on production environment, then you'll need to run a few commands in console to see the changes (aka move from src folder to web folder) ``` php app/console cache:clear --env=prod ``` - Default authentication for production is CAS and for development is internal login. To make the system work standalone (aka skipping out using CAS), you'll need to make a few changes: - modify app/config/config\_prod.yml and change security\_cas.yml to security\_internal.yml - To create a user from command line: ``` vagrant ssh cd /vagrant php app/console exam:user:create USERNAME PASSWORD ROLE_ADMIN ``` - If there is an existing exam database, the search index has to be rebuild in order for search to function. ``` vagrant ssh cd /vagrant php app/console exam:index:build ``` - Upgrade notes: ``` sudo su app cd /www_data/app git pull chmod 775 app/data/uploads app/data/uploads/documents ``` ### Health Score 17 — LowBetter than 6% of packages Maintenance0 Infrequent updates — may be unmaintained Popularity9 Limited adoption so far Community14 Small or concentrated contributor base Maturity41 Maturing project, gaining track record Bus Factor1 Top contributor holds 72.8% of commits — single point of failure How is this calculated?**Maintenance (25%)** — Last commit recency, latest release date, and issue-to-star ratio. Uses a 2-year decay window. **Popularity (30%)** — Total and monthly downloads, GitHub stars, and forks. Logarithmic scaling prevents top-heavy scores. **Community (15%)** — Contributors, dependents, forks, watchers, and maintainers. Measures real ecosystem engagement. **Maturity (30%)** — Project age, version count, PHP version support, and release stability. ### Community Maintainers ![](https://www.gravatar.com/avatar/8b2967b2bb74961a49e294aa39aff74c15698f2b09aae1d5557cb986a03da13a?d=identicon)[compass](/maintainers/compass) --- Top Contributors [![xcompass](https://avatars.githubusercontent.com/u/465548?v=4)](https://github.com/xcompass "xcompass (158 commits)")[![loongchan](https://avatars.githubusercontent.com/u/5587569?v=4)](https://github.com/loongchan "loongchan (55 commits)")[![ionparticle](https://avatars.githubusercontent.com/u/1386330?v=4)](https://github.com/ionparticle "ionparticle (2 commits)")[![lenglund](https://avatars.githubusercontent.com/u/6118592?v=4)](https://github.com/lenglund "lenglund (2 commits)") ### Embed Badge ![Health badge](/badges/ubc-examdb/health.svg) ``` [![Health](https://phpackages.com/badges/ubc-examdb/health.svg)](https://phpackages.com/packages/ubc-examdb) ``` ### Alternatives [doctrine/orm Object-Relational-Mapper for PHP 10.2k285.3M6.2k](/packages/doctrine-orm)[jdorn/sql-formatter a PHP SQL highlighting library 3.9k115.1M102](/packages/jdorn-sql-formatter)[illuminate/database The Illuminate Database package. 2.8k52.4M9.4k](/packages/illuminate-database)[ramsey/uuid-doctrine Use ramsey/uuid as a Doctrine field type. 90440.3M211](/packages/ramsey-uuid-doctrine)[reliese/laravel Reliese Components for Laravel Framework code generation. 1.7k3.4M16](/packages/reliese-laravel)[wildside/userstamps Laravel Userstamps provides an Eloquent trait which automatically maintains `created\_by` and `updated\_by` columns on your model, populated by the currently authenticated user in your application. 7511.7M13](/packages/wildside-userstamps) PHPackages © 2026 [Directory](/)[Categories](/categories)[Trending](/trending)[Changelog](/changelog)[Analyze](/analyze)