tomzx

    protected function getForeignKeySqlDefinition(ForeignKey $foreignKey)
    {
        $def = '';

        if ($foreignKey->getConstraint()) {
            $def .= ' CONSTRAINT ' . $this->quoteColumnName($foreignKey->getConstraint());
        } 
        $columnNames = array();
        foreach ($foreignKey->getColumns() as $column) {
            $columnNames[] = $this->quoteColumnName($column);

tomzx

SELECT
  ke.referenced_table_name parent,
  ke.table_name child,
  ke.constraint_name
FROM
  information_schema.KEY_COLUMN_USAGE ke
WHERE
  ke.referenced_table_name IS NOT NULL
ORDER BY
  ke.referenced_table_name;

tomzx

GRANT CREATE ROUTINE, CREATE VIEW, ALTER, SHOW VIEW, CREATE, ALTER ROUTINE, EVENT, INSERT, SELECT, DELETE, TRIGGER, GRANT OPTION, REFERENCES, UPDATE, DROP, EXECUTE, LOCK TABLES, CREATE TEMPORARY TABLES, INDEX ON `%\_dev`.* TO 'NAME_dev'@'localhost';
FLUSH PRIVILEGES;

tomzx

<?php

trait ModelAttribute
{
	protected $attr_reader = [];
	protected $attr_writer = [];
	protected $attr_accessor = [];

	public function getAttribute($key)
	{

tomzx

-- cards are what you review. easy!
CREATE TABLE cards (
    id              integer primary key,
      -- the epoch milliseconds of when the card was created
    nid             integer not null,
      -- notes.id
    did             integer not null,
      -- deck id (available in col table)
    ord             integer not null,
      -- ordinal, seems like. for when a model has multiple templates, or thereabouts

tomzx

/home/travis/build.sh: line 175: ./gradlew: Permission denied

Fix by setting the executable flag on your gradlew file.

Either

chmod +x gradlew (on unix systems)

OR

tomzx

Suggested semantic versioning change: MAJOR

Class (MAJOR)
+-------+---------------------------------------------------------------------------+--------------------------------------------------------+-----------------------------------------+------+
| Level | Location                                                                  | Target                                                 | Reason                                  | Code |
+-------+---------------------------------------------------------------------------+--------------------------------------------------------+-----------------------------------------+------+
| MAJOR | E:\Tom\Documents\GIT\deployer\src\Console\RunTaskCommand.php#24           | Deployer\Console\RunTaskCommand                        | Class was removed.                      | V005 |
| MAJOR | E:\Tom\Documents\GIT\deployer\src\Environment.php#13                      | Deployer\Environment                                   | Class was removed.                      | V005 |
| MAJ

tomzx

function convertMySQLTimezone($timezone)
{
	$result = preg_match('/(?P<sign>\+|-)(?P<hours>\d{1,2}):(?P<minutes>\d{1,2})/', $timezone, $match);
	if ( ! $result) {
		return timezone_name_from_abbr('UTC');
	}

	$sign = $match['sign'] === '-' ? -1 : 1;
	$hours = $match['hours'];
	$minutes = $match['minutes'];

tomzx

Statistical profiling result from null, (1219 ticks, 0 unaccounted, 0 excluded).

 [Shared libraries]:
   ticks  total  nonlib   name
    834   68.4%          /lib/x86_64-linux-gnu/libc-2.19.so
    268   22.0%          /usr/local/bin/node
     96    7.9%          [vdso]
     18    1.5%          /lib/x86_64-linux-gnu/libpthread-2.19.so
      1    0.1%          /lib/x86_64-linux-gnu/ld-2.19.so

tomzx

<?php
<<<CONFIG
packages:
    - "your/dependencies: 1.0"
CONFIG;

if ( ! file_exists('composer.phar')) {
	file_put_contents('composer.phar', fopen('https://getcomposer.org/composer.phar', 'r'));
}