Skip to content

Latest commit

 

History

History
30 lines (23 loc) · 761 Bytes

README.md

File metadata and controls

30 lines (23 loc) · 761 Bytes
Raw

Album (test task)

Installation:

  1. Back end installation
    1. composer install
    2. app/console doctrine:schema:create
    3. app/console doctrine:fixtures:load
  2. Front end installation
    1. npm install
    2. bower install
    3. grunt prod
    4. app/console assets:install web --symlink
  3. Run server with command: app/console server:run

Project will be available at localhost:8000

Requirements: PHP, MySQL, npm, compass

SQL: List of all albums and images with MAX 10 images at an album

SET @album = 0;
SET @n = 0;

SELECT a.*, i.*, @n := IF(@album <> a.id, 1, @n + 1) num, @album := a.id
FROM album a
JOIN image i ON i.album_id = a.id
HAVING num <= 10
ORDER BY a.id, i.id