Todo

Todo example has the basic features to manage your Todo list

Database

Create database table

CREATE TABLE `todos` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` enum('New','Todo','Done') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'New',
  `created_by` int(11) NOT NULL,
  `created_at` datetime DEFAULT CURRENT_TIMESTAMP,
  `updated_by` int(11) DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci

Entity

Create Todo entity class.

php spark make:entity Myapp Todo "id,title,status,created_by,created_at,updated_by,updated_at"

Model

Create Todo model class.

php spark make:model Myapp Todo "id,title,status,created_by,created_at,updated_by,updated_at"

View

Create Todo view files.

php spark make:view Myapp Todos Todo

Controller

Create Todo controller class.

php spark make:controller Myapp Todos

Packaging

Create Myapp info.json file.

php spark make:json Myapp

Push to the store

Upload Myapp to the store.

php spark store:push Myapp

Pull from the store

Download Myapp from the store.

php spark store:pull Myapp