Download the PHP package phariscope/multitenant without Composer

Multitenancy made easy for your projects

Easily add multitenancy capabilities to your Symfony projects without (too much) code modification.

Installation

Prerequisites

We assume you have a DATA_PATH environment variable to store all data, including database data and other data types such as files.

We assume you have a DATABASE_URL environment variable containing the general path to your database.

Install

Install the package using Composer:

You can use Multitenant as a Symfony bundle. Simply add one line to your config/bundles.php file:

Usage

Use either the brute force or the precise method.

With the brute force method: Your entire application will be tenanted: it will be very difficult to implement any part external to your application, as the original DATA_PATH and DATABASE_URL env will be lost.

With the precise method: Choose where to implement tenant behavior or general behavior.

Brutal

Modify DATA_PATH and DATABASE_URL values as soon as possible with the ContextTransformer. You won't have to think about tenants anymore because your EntityManager object will be build with your tenant values.

For instance with Symfony, inside your console script or your index.php, just modify the contexte.

In a typical console script:

in your Symfony Commands YOU MUST allow --id_tenant option like this

Important : if you don't require tenant_id then when you ignore --tenant_id the orignal DATA_PATH and DATABASE_URL values are used. (so this is a way to have a global comportement; you can be "precise" anyway)

Precise

In a Symfony controller, follow these steps:

1. Inject EntityManagerResolver into your controller’s constructor.
2. Retrieve the tenant-specific entity manager within your route action.
3. create database and schema for a tenant if database does not exist for this tenant

For example, assuming you have a tenant_id in your request or session:

Creating a Tenant Database

Ensure you have the necessary console setup to handle tenant operations.

To create a database for a specific tenant (e.g., tenantID1234), you can use the console command:

Creating a Schema for a tenant database

Once you have created a tenant database, you can create its schema.

You can use the console command:

How it works

A "tenants" subfolder will be created in the DATA_PATH. For each tenant, a specific folder will be created containing all the data, including the database.

For example:

Given the tenant "tenantID1234", the database create command will create the following file: ./var/data/tenants/tenantID1234/eventually/some/subfolders/mydatabase.sqlite

The "./var/data/tenants/tenantID1234" folder will contain all the data required for your project.