Autodetect SQL UNIQUE KEY and generate isUnique()

[ionas]

At least for me unique constraint detection did not work. Should it?

CREATE TABLE `manage_manufacturers` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `vc24_manufacturer_id` bigint(20) NOT NULL,
  `is_visible` tinyint(1) unsigned NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`),
  UNIQUE KEY `vc24_manufacturer_id` (`vc24_manufacturer_id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;

Expected in buildRules():

$rules->add($rules->isUnique(['vc24_manufacturer_id']));

[markstory]

I'll take a look.

[ionas]

Thank you :)

bin/cake bake all --prefix Admin --force manage_manufacturers; just in case there is some unlikely interaction with any of those params.

[markstory]

Closing as a pull request is up now.

[htstudios]

Thank you!