CAKE 3.0 Tutorials using SQLITE

2015-09-20 Thread 'jacmgr' via CakePHP
I ahev successfully installed cake and Mysql and completed the tutorials for bookmarks and blog. Now I want to use SQlite. I can successfully connect to my sqlite database. I tried using the same Mysql statements found on page 13 of the cookbook that were successful with Mysql; however, I g

Re: CAKE 3.0 Tutorials using SQLITE

2015-09-21 Thread 'jacmgr' via CakePHP
This seems to work for the bookmarks app in SQLITE. ( Except for a cascadeing delete). CREATE TABLE "users" ( "id" integer NOT NULL PRIMARY KEY AUTOINCREMENT, "email" text NOT NULL, "password" text NOT NULL, "created" text, "modified" text ); CREATE TABLE "bookmarks" ( "id" integer NOT NULL PR

Re: CAKE 3.0 Tutorials using SQLITE

2015-09-22 Thread 'jacmgr' via CakePHP
Thankyou, I'll look into that and learn the migrations system in PART 3 of the Blog tutorial. My perspective at this point, was as someone new to cake just trying to follow the turorials to see if cakephp was something within my grasp. The mysql above with instructions to execute the followin