MAMP環境下でcomposerを使ってcakephpを導入する手順

PC:Mac

PHP: 7.3.9

(PHPはMAMP導入の際に内包されているものを使う)

MYSQL:5.7.26

(MySQLもはMAMP導入の際に内包されているものを使う)

cakephp 4.0.4

(プロジェクト名/vendor/cakephp/cakephp/VERSION.txtで確認可能）

#インストール
curl -sS https://getcomposer.org/installer | php

#/usr/local/bin/composerに移動させる
sudo mv composer.phar /usr/local/bin/

#バージョン確認
composer -V

alias composer='/usr/local/bin/composer'

php -r "copy('https://getcomposer.org/installer', 'composer-setup.php');"

php -r "if (hash_file('sha384', 'composer-setup.php') === 'e0012edf3e80b6978849f5eff0d4b4e4c79ff1609dd1e613307e16318854d24ae64f26d17af3ef0bf7cfb710ca74755a') { echo 'Installer verified'; } else { echo 'Installer corrupt'; unlink('composer-setup.php'); } echo PHP_EOL;"

php composer-setup.php

composer create-project --prefer-dist cakephp/app プロジェクト名

touch .bash_profile

vim ~/.bash_profile

export PATH=/Applications/MAMP/bin/php/php7.3.9/bin:$PATH

source ~/.bash_profile

which php

/Applications/MAMP/bin/php/php7.3.9/bin/php

composer create-project --prefer-dist cakephp/app プロジェクト名

vim ~/.bash_profile

export PATH=$PATH:/Applications/MAMP/Library/bin

source ~/.bash_profile

CREATE SCHEMA `cake_cms` ;

USE cake_cms;

CREATE TABLE users (
    id INT AUTO_INCREMENT PRIMARY KEY,
    email VARCHAR(255) NOT NULL,
    password VARCHAR(255) NOT NULL,
    created DATETIME,
    modified DATETIME
);

CREATE TABLE articles (
    id INT AUTO_INCREMENT PRIMARY KEY,
    user_id INT NOT NULL,
    title VARCHAR(255) NOT NULL,
    slug VARCHAR(191) NOT NULL,
    body TEXT,
    published BOOLEAN DEFAULT FALSE,
    created DATETIME,
    modified DATETIME,
    UNIQUE KEY (slug),
    FOREIGN KEY user_key (user_id) REFERENCES users(id)
) CHARSET=utf8mb4;

CREATE TABLE tags (
    id INT AUTO_INCREMENT PRIMARY KEY,
    title VARCHAR(191),
    created DATETIME,
    modified DATETIME,
    UNIQUE KEY (title)
) CHARSET=utf8mb4;

CREATE TABLE articles_tags (
    article_id INT NOT NULL,
    tag_id INT NOT NULL,
    PRIMARY KEY (article_id, tag_id),
    FOREIGN KEY tag_key(tag_id) REFERENCES tags(id),
    FOREIGN KEY article_key(article_id) REFERENCES articles(id)
);

INSERT INTO users (email, password, created, modified)
VALUES
('cakephp@example.com', 'secret', NOW(), NOW());

INSERT INTO articles (user_id, title, slug, body, published, created, modified)
VALUES
(1, 'First Post', 'first-post', 'This is the first post.', 1, now(), now());