Download the PHP package alexjumperman/doctrinetemptable without Composer

On this page you can find all versions of the php package alexjumperman/doctrinetemptable. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.

FAQ

After the download, you have to make one include require_once('vendor/autoload.php');. After that you have to import the classes with use statements.

Example:
If you use only one package a project is not needed. But if you use more then one package, without a project it is not possible to import the classes with use statements.

In general, it is recommended to use always a project to download your libraries. In an application normally there is more than one library needed.
Some PHP packages are not free to download and because of that hosted in private repositories. In this case some credentials are needed to access such packages. Please use the auth.json textarea to insert credentials, if a package is coming from a private repository. You can look here for more information.

  • Some hosting areas are not accessible by a terminal or SSH. Then it is not possible to use Composer.
  • To use Composer is sometimes complicated. Especially for beginners.
  • Composer needs much resources. Sometimes they are not available on a simple webspace.
  • If you are using private repositories you don't need to share your credentials. You can set up everything on our site and then you provide a simple download link to your team member.
  • Simplify your Composer build process. Use our own command line tool to download the vendor folder as binary. This makes your build process faster and you don't need to expose your credentials for private repositories.
Please rate this library. Is it a good library?

Example code of alexjumperman/doctrinetemptable

Informations about the package doctrinetemptable

DoctrineTempTableExtension

Problem

let's imagine that we have online-store with 1M products. On one specific category page we need to work only with 100 products from the whole stack, and we need to get:

  1. total products count on this page
  2. first 10 product entities sorting by some order
  3. products count by every single filter etc.

Queries by the entire stack will not be effective. More efficient way - select needed products into temporary table and executing this queries from temporary table.

Install

composer require alexjumperman/doctrinetemptable

Usage

1. Using repository trait

After trait was using we continue in controller

2. Or we can use service factory

Workflow

When we have query builder instance for temporary table, we need to construct it for our requirements. In our case we need to select all products which relating to specific category.

After the query builder is configured, we can create a repository of our temporary table. In fact, it will be a certain analogue of the doctrine repository that works with the temporary table storage.

When the temporary repository is created, we can configure queries to select the necessary data.

Whole process example

All versions of doctrinetemptable with dependencies

PHP Build Version
Package Version
Requires php Version >=5.5.9
doctrine/doctrine-bundle Version ^1.8
doctrine/orm Version ^2.5
Composer command for our command line client (download client) This client runs in each environment. You don't need a specific PHP version etc. The first 20 API calls are free. Standard composer command

The package alexjumperman/doctrinetemptable contains the following files

Loading the files please wait ....