Dan's Wiki

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
====== Cantata - Song Database and List Creation ======

  * [[.troubleshooting|Troubleshooting]]
  * [[.version1:|Cantata Version 1]]
  * [[.version2:|Cantata Version 2]]
  * [[.version3:|Cantata Version 3]]

===== Cantata 3 Development =====

Intending to create a version 3, with a more full implementation. Perhaps using a PHP Framework will help, although concerned that the complex sensitive AJAX interactions may make this not work for everything.

5/5/2016: Initially trying CakePhp 3.2.8: cakephp.org

  * http://book.cakephp.org/3.0/en/installation.html

5/30/2016 Deciding to move to Laravel, partially at Michael Hanes recommendation, also because I read that CakePhp is now old and not being supported much.

  * https://laravel.com
  * [[laravel:start|Laravel Notes]]
  * [[.version3:database|Database Notes for Cantata 3]]
  * [[.version3:requirements|Cantata 3 Requirements]]

Also downloaded Vagrant, which allows a dynamic configuration of the Virtual Box.

Downloaded PhpStorm 30-day eval, which integrates nicely with Vagrant/Virtual Box. To start it, run:

   * JetBrains PhpStorm 2016.2.1



===== Database Setup =====

^Database Name|quizkidn_cantata3|
^User Name|quizkidn_can3|

  * create database quizkidn_cantata3;
  * create user 'quizkidn_can3'@'%' identified by 'cantatapass3';
  * grant all on quizkidn_cantata3.* to 'quizkidn_can3'@'%';
  * FLUSH PRIVILEGES;
  * select user from mysql.user;

==== Database Table Setup ====

Laravel uses an ORM, which allows a class to equal a database table. The "-m" creates a migration file. It will create the Song.php file also, and modifications don't need to be made to Song.php unless there are relationships between Song.php and another Model.

  php artisan make:model Song -m
  
  -> Model created successfully.

===== Security =====

  * https://laravel.com/docs/5.3/authentication

I set up default Laravel security by running this:

<code>
php artisan make:auth
php artisan migrate
http://cantata3/register
</code>

I logged in (establishing an initial login) with quizkid:<usual password>

//Want to get started fast? Just run php artisan make:auth and php artisan migrate in a fresh Laravel application. Then, navigate your browser to http://your-app.dev/register or any other URL that is assigned to your application. These two commands will take care of scaffolding your entire authentication system!//

===== Theme Design =====

Looking here:

https://almsaeedstudio.com/themes/AdminLTE/documentation/index.html

This is an open source theme. It has a lot of features, including a source-code LESS-required version. Starting for now with the "Ready" version.

http://almsaeedstudio.com/download/AdminLTE-dist

===== Bootstrap =====

This uses "Bootstrap" which is a complete set of CSS and Javascript templating. While looking at AdminLTE, it seems that I should just use Bootstrap for a good look-and-feel framework.

^Bootstrap Download|http://getbootstrap.com/|
^Glyphs (icons)|http://getbootstrap.com/components/|
^Tutorial, Learn Bootstrap in one video (about an hour), complete and to the point|https://www.youtube.com/watch?v=gqOEoUR5RHg|
^Bootstrap Amazon Book|http://amzn.to/1RHdfPr|
^Bootstrap Cheat Sheet|http://goo.gl/M5G7wj|
^Local Copy of Cheat Sheet Examples|http://quizkid.net/misc/bootstrapCheat1.htm\\ http://quizkid.net/misc/bootstrapCheat2.htm|

===== Todo =====

Keeping items here that need to be done.

  * If a file is in the directory and it has an invalid character (such as Calon Lan, with an accented "a"), need to change the directory name before importing into the database. For now, I'm manually changing it. 12/22/2016
Dan's Wiki

User Tools

Site Tools

Page Tools
