Noter using Cakephp Mysql and Docker

noter-cakephp-mysql-docker.md

Setup of Noter in CakePHP, MySQL and Docker (and other tools) - notes, commands, snippets go here.

Direct branch-URL - https://github.com/konnector-dev/noter/tree/cakephp-mysql

Repo URL - https://github.com/konnector-dev/noter

Branch - cakephp-mysql

Missed commands in the first version:

1. git clone git@github.com:konnector-dev/noter.git
2. cd noter
3. git checkout cakephp-mysql
4. docker-compose run noter composer install -n --prefer-dist
5. docker-compose run noter bin/cake migrations migrate
6. docker-compose run noter bin/cake migrations seed
7. docker-compose up --build

The above command will create a migrations file (at config/Migrations) - you can check it to confirm if the columns have the specifications as expected, or you can modify this file as per the changes needed.

Next, run the migration to make desired changes to the DB by using following command:

bin/cake migrations migrate

Docker tip: If you are using docker/docker-compose, then prefix the above command with docker-compose run noter (where noter is the service name in docker-compose.yml file)

As of here, the table is created, now we run "bake" command to generate Controller, Model, Entity, View(templates) for users:

bin/cake bake all users

If "users" is omitted, then a prompt would show up asking for selecting the table/entity to be baked.

Docker tip (again): Prefix the command with docker-compose run noter, and remember - omitting "users" would not prompt anything, the command will not be executed (need to find the right flag to wait for prompt, and for now use the full command, including "users" at the end, specifying the table, hence not having the need for any prompt)

Technically, no PHP code written so far.

The bin/cake bake all users generates scaffolding code for Model, View and Controller.

Now /users URL (in this case http://183.83.1.1/users) will take you to a "listing" page created by "bake" command and it will look like the following screenshot (as of CakePHP 4.1.3 Strawberry):

Adding screenshots for CRUD pages

Key things to notice:

• UUID is "not-so-famous" data type, so the input field for that is "non-stylized"
• Email field is having "type=email" (HTML source code not in screenshot)
• Password field is having "type=password"
• The TINYINT(1) columns are handled as "boolean" by default, and hence the "checkbox", depicting a TRUE/FALSE or 1/0 state
• Date/time column (email_verified_at) has a date/time picker and also supports keyboard-navigation as well (pretty awesome)
  

Adding a couple of users (plain text entries, no file uploads or any other kind of logic, yet), makes the user listing page like this:

"View" user (details page)

Deleting a user prompts the javascript "confirm" popup box

So far - not a single hand-written code in PHP!

admins

• id
• uuid
• login
• password
• name
• active
• remember_me_token
• last_logged_in
• created
• modified

bin/cake bake migration CreateAdmins uuid:uuid[64]:index:UUID_INDEX login:string?:index:LOGIN_INDEX password:string? name:string? active:boolean? remember_me_token:string?:index:REMEMBER_ME_TOKEN_INDEX last_logged_in:datetime? created:datetime? modified:datetime?