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

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?