| 12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010101110121013101410151016101710181019102010211022102310241025102610271028102910301031103210331034103510361037103810391040104110421043104410451046104710481049105010511052105310541055105610571058105910601061106210631064106510661067106810691070107110721073107410751076107710781079108010811082108310841085108610871088108910901091109210931094109510961097109810991100110111021103110411051106110711081109111011111112111311141115111611171118111911201121112211231124112511261127112811291130113111321133113411351136113711381139114011411142114311441145114611471148114911501151115211531154115511561157115811591160116111621163116411651166116711681169117011711172117311741175117611771178117911801181118211831184118511861187118811891190119111921193119411951196119711981199120012011202120312041205120612071208120912101211121212131214121512161217121812191220122112221223122412251226122712281229123012311232123312341235123612371238123912401241124212431244124512461247124812491250125112521253125412551256125712581259126012611262126312641265126612671268126912701271127212731274127512761277127812791280128112821283128412851286128712881289129012911292129312941295129612971298129913001301130213031304130513061307130813091310131113121313131413151316131713181319132013211322132313241325132613271328132913301331133213331334133513361337133813391340134113421343134413451346134713481349135013511352135313541355135613571358135913601361136213631364136513661367136813691370137113721373137413751376137713781379138013811382138313841385138613871388138913901391139213931394139513961397139813991400140114021403140414051406140714081409141014111412141314141415141614171418141914201421142214231424142514261427142814291430143114321433143414351436143714381439144014411442144314441445144614471448144914501451145214531454145514561457145814591460146114621463146414651466146714681469147014711472147314741475147614771478147914801481148214831484148514861487148814891490149114921493149414951496149714981499150015011502150315041505150615071508150915101511151215131514151515161517151815191520152115221523152415251526152715281529153015311532153315341535153615371538153915401541154215431544154515461547154815491550155115521553155415551556155715581559156015611562156315641565156615671568156915701571157215731574157515761577157815791580158115821583158415851586158715881589159015911592159315941595159615971598159916001601160216031604160516061607160816091610161116121613161416151616161716181619162016211622162316241625162616271628162916301631163216331634163516361637163816391640164116421643164416451646164716481649165016511652165316541655165616571658165916601661166216631664166516661667166816691670167116721673167416751676167716781679168016811682168316841685168616871688168916901691169216931694169516961697169816991700170117021703170417051706170717081709171017111712171317141715171617171718171917201721172217231724172517261727172817291730173117321733173417351736173717381739174017411742174317441745174617471748174917501751175217531754175517561757175817591760176117621763176417651766176717681769177017711772177317741775177617771778177917801781178217831784178517861787178817891790179117921793179417951796179717981799180018011802180318041805180618071808180918101811181218131814181518161817181818191820182118221823182418251826182718281829183018311832183318341835183618371838183918401841184218431844184518461847184818491850185118521853185418551856185718581859186018611862186318641865186618671868186918701871187218731874187518761877187818791880188118821883188418851886188718881889189018911892189318941895189618971898189919001901190219031904190519061907190819091910191119121913191419151916191719181919192019211922192319241925192619271928192919301931193219331934193519361937193819391940194119421943194419451946194719481949195019511952195319541955195619571958195919601961196219631964196519661967196819691970197119721973197419751976197719781979198019811982198319841985198619871988198919901991199219931994199519961997199819992000200120022003200420052006200720082009201020112012201320142015201620172018201920202021202220232024202520262027202820292030203120322033203420352036203720382039204020412042204320442045204620472048204920502051205220532054205520562057205820592060206120622063206420652066206720682069207020712072207320742075207620772078207920802081208220832084208520862087208820892090209120922093209420952096209720982099210021012102210321042105210621072108210921102111211221132114211521162117211821192120212121222123212421252126212721282129213021312132213321342135213621372138213921402141214221432144214521462147214821492150215121522153215421552156215721582159216021612162216321642165216621672168216921702171217221732174217521762177217821792180218121822183218421852186218721882189219021912192219321942195219621972198219922002201220222032204220522062207220822092210221122122213221422152216221722182219222022212222222322242225222622272228222922302231223222332234223522362237223822392240224122422243224422452246224722482249225022512252225322542255225622572258225922602261226222632264226522662267226822692270227122722273227422752276227722782279228022812282228322842285228622872288228922902291229222932294229522962297229822992300230123022303230423052306230723082309231023112312231323142315231623172318231923202321232223232324232523262327232823292330233123322333233423352336233723382339234023412342234323442345234623472348234923502351235223532354235523562357235823592360236123622363236423652366236723682369237023712372237323742375237623772378237923802381238223832384238523862387238823892390239123922393239423952396239723982399240024012402240324042405240624072408240924102411241224132414241524162417241824192420242124222423242424252426242724282429243024312432243324342435243624372438243924402441244224432444244524462447244824492450245124522453245424552456245724582459246024612462246324642465246624672468246924702471247224732474247524762477247824792480248124822483248424852486248724882489249024912492249324942495249624972498249925002501250225032504250525062507250825092510251125122513251425152516251725182519252025212522252325242525252625272528252925302531253225332534253525362537253825392540254125422543254425452546254725482549255025512552255325542555255625572558255925602561256225632564256525662567256825692570257125722573257425752576257725782579258025812582258325842585258625872588258925902591259225932594259525962597259825992600260126022603260426052606260726082609261026112612261326142615261626172618261926202621262226232624262526262627262826292630263126322633263426352636263726382639264026412642264326442645264626472648264926502651265226532654265526562657265826592660266126622663266426652666266726682669267026712672267326742675267626772678267926802681268226832684268526862687268826892690269126922693269426952696269726982699270027012702270327042705270627072708270927102711271227132714271527162717271827192720272127222723272427252726272727282729273027312732273327342735273627372738273927402741274227432744274527462747274827492750275127522753275427552756275727582759276027612762276327642765276627672768276927702771277227732774277527762777277827792780278127822783278427852786278727882789279027912792279327942795279627972798279928002801280228032804280528062807280828092810281128122813281428152816281728182819282028212822282328242825282628272828282928302831283228332834283528362837283828392840284128422843284428452846284728482849285028512852285328542855285628572858285928602861286228632864286528662867286828692870287128722873287428752876287728782879288028812882288328842885288628872888288928902891289228932894289528962897289828992900290129022903290429052906290729082909291029112912291329142915291629172918291929202921292229232924292529262927292829292930293129322933293429352936293729382939294029412942294329442945294629472948294929502951295229532954295529562957295829592960296129622963296429652966296729682969297029712972297329742975297629772978297929802981298229832984298529862987298829892990299129922993299429952996299729982999300030013002300330043005300630073008300930103011301230133014301530163017301830193020302130223023302430253026302730283029303030313032303330343035303630373038303930403041304230433044304530463047304830493050305130523053305430553056305730583059306030613062306330643065306630673068306930703071307230733074307530763077307830793080308130823083308430853086308730883089309030913092309330943095309630973098309931003101310231033104310531063107310831093110311131123113311431153116311731183119312031213122312331243125312631273128312931303131313231333134313531363137313831393140314131423143314431453146314731483149315031513152315331543155315631573158315931603161316231633164316531663167316831693170317131723173317431753176317731783179318031813182318331843185318631873188318931903191319231933194319531963197319831993200320132023203320432053206320732083209321032113212321332143215321632173218321932203221322232233224322532263227322832293230323132323233323432353236323732383239324032413242324332443245324632473248324932503251325232533254325532563257325832593260326132623263326432653266326732683269327032713272327332743275327632773278327932803281328232833284328532863287328832893290329132923293329432953296329732983299330033013302330333043305330633073308330933103311331233133314331533163317331833193320332133223323332433253326332733283329333033313332333333343335333633373338333933403341334233433344334533463347334833493350335133523353335433553356335733583359336033613362336333643365336633673368336933703371337233733374337533763377337833793380338133823383338433853386338733883389339033913392339333943395339633973398339934003401340234033404340534063407340834093410341134123413341434153416341734183419342034213422342334243425342634273428342934303431343234333434343534363437343834393440344134423443344434453446344734483449345034513452345334543455345634573458345934603461346234633464346534663467346834693470347134723473347434753476347734783479348034813482348334843485348634873488348934903491 |
- <?php
- /**
- * CakePHP(tm) : Rapid Development Framework (http://cakephp.org)
- * Copyright (c) Cake Software Foundation, Inc. (http://cakefoundation.org)
- *
- * Licensed under The MIT License
- * For full copyright and license information, please see the LICENSE.txt
- * Redistributions of files must retain the above copyright notice.
- *
- * @copyright Copyright (c) Cake Software Foundation, Inc. (http://cakefoundation.org)
- * @link http://cakephp.org CakePHP(tm) Project
- * @since 3.0.0
- * @license http://www.opensource.org/licenses/mit-license.php MIT License
- */
- namespace Cake\Test\TestCase\ORM;
- use Cake\Core\Configure;
- use Cake\Database\Expression\OrderByExpression;
- use Cake\Database\Expression\QueryExpression;
- use Cake\Database\TypeMap;
- use Cake\Datasource\ConnectionManager;
- use Cake\I18n\Time;
- use Cake\ORM\Table;
- use Cake\ORM\TableRegistry;
- use Cake\Validation\Validator;
- /**
- * Used to test correct class is instantiated when using TableRegistry::get();
- */
- class UsersTable extends Table {
- }
- /**
- * Tests Table class
- *
- */
- class TableTest extends \Cake\TestSuite\TestCase {
- public $fixtures = [
- 'core.user', 'core.category', 'core.article', 'core.author',
- 'core.tag', 'core.articles_tag'
- ];
- /**
- * Handy variable containing the next primary key that will be inserted in the
- * users table
- *
- * @var int
- */
- public static $nextUserId = 5;
- public function setUp() {
- parent::setUp();
- $this->connection = ConnectionManager::get('test');
- Configure::write('App.namespace', 'TestApp');
- $this->usersTypeMap = new TypeMap([
- 'Users.id' => 'integer',
- 'id' => 'integer',
- 'Users.username' => 'string',
- 'username' => 'string',
- 'Users.password' => 'string',
- 'password' => 'string',
- 'Users.created' => 'timestamp',
- 'created' => 'timestamp',
- 'Users.updated' => 'timestamp',
- 'updated' => 'timestamp',
- ]);
- $this->articlesTypeMap = new TypeMap([
- 'Articles.id' => 'integer',
- 'id' => 'integer',
- 'Articles.title' => 'string',
- 'title' => 'string',
- 'Articles.author_id' => 'integer',
- 'author_id' => 'integer',
- 'Articles.body' => 'text',
- 'body' => 'text',
- 'Articles.published' => 'string',
- 'published' => 'string',
- ]);
- }
- public function tearDown() {
- parent::tearDown();
- TableRegistry::clear();
- }
- /**
- * Tests the table method
- *
- * @return void
- */
- public function testTableMethod() {
- $table = new Table(['table' => 'users']);
- $this->assertEquals('users', $table->table());
- $table = new UsersTable;
- $this->assertEquals('users', $table->table());
- $table = $this->getMockBuilder('\Cake\ORM\Table')
- ->setMethods(['find'])
- ->setMockClassName('SpecialThingsTable')
- ->getMock();
- $this->assertEquals('special_things', $table->table());
- $table = new Table(['alias' => 'LoveBoats']);
- $this->assertEquals('love_boats', $table->table());
- $table->table('other');
- $this->assertEquals('other', $table->table());
- }
- /**
- * Tests the alias method
- *
- * @return void
- */
- public function testAliasMethod() {
- $table = new Table(['alias' => 'users']);
- $this->assertEquals('users', $table->alias());
- $table = new Table(['table' => 'stuffs']);
- $this->assertEquals('stuffs', $table->alias());
- $table = new UsersTable;
- $this->assertEquals('Users', $table->alias());
- $table = $this->getMockBuilder('\Cake\ORM\Table')
- ->setMethods(['find'])
- ->setMockClassName('SpecialThingTable')
- ->getMock();
- $this->assertEquals('SpecialThing', $table->alias());
- $table->alias('AnotherOne');
- $this->assertEquals('AnotherOne', $table->alias());
- }
- /**
- * Tests connection method
- *
- * @return void
- */
- public function testConnection() {
- $table = new Table(['table' => 'users']);
- $this->assertNull($table->connection());
- $table->connection($this->connection);
- $this->assertSame($this->connection, $table->connection());
- }
- /**
- * Tests primaryKey method
- *
- * @return void
- */
- public function testPrimaryKey() {
- $table = new Table([
- 'table' => 'users',
- 'schema' => [
- 'id' => ['type' => 'integer'],
- '_constraints' => ['primary' => ['type' => 'primary', 'columns' => ['id']]]
- ]
- ]);
- $this->assertEquals('id', $table->primaryKey());
- $table->primaryKey('thingID');
- $this->assertEquals('thingID', $table->primaryKey());
- $table->primaryKey(['thingID', 'user_id']);
- $this->assertEquals(['thingID', 'user_id'], $table->primaryKey());
- }
- /**
- * Tests that name will be selected as a displayField
- *
- * @return void
- */
- public function testDisplayFieldName() {
- $table = new Table([
- 'table' => 'users',
- 'schema' => [
- 'foo' => ['type' => 'string'],
- 'name' => ['type' => 'string']
- ]
- ]);
- $this->assertEquals('name', $table->displayField());
- }
- /**
- * Tests that title will be selected as a displayField
- *
- * @return void
- */
- public function testDisplayFieldTitle() {
- $table = new Table([
- 'table' => 'users',
- 'schema' => [
- 'foo' => ['type' => 'string'],
- 'title' => ['type' => 'string']
- ]
- ]);
- $this->assertEquals('title', $table->displayField());
- }
- /**
- * Tests that no displayField will fallback to primary key
- *
- * @return void
- */
- public function testDisplayFallback() {
- $table = new Table([
- 'table' => 'users',
- 'schema' => [
- 'id' => ['type' => 'string'],
- 'foo' => ['type' => 'string'],
- '_constraints' => ['primary' => ['type' => 'primary', 'columns' => ['id']]]
- ]
- ]);
- $this->assertEquals('id', $table->displayField());
- }
- /**
- * Tests that displayField can be changed
- *
- * @return void
- */
- public function testDisplaySet() {
- $table = new Table([
- 'table' => 'users',
- 'schema' => [
- 'id' => ['type' => 'string'],
- 'foo' => ['type' => 'string'],
- '_constraints' => ['primary' => ['type' => 'primary', 'columns' => ['id']]]
- ]
- ]);
- $this->assertEquals('id', $table->displayField());
- $table->displayField('foo');
- $this->assertEquals('foo', $table->displayField());
- }
- /**
- * Tests schema method
- *
- * @return void
- */
- public function testSchema() {
- $schema = $this->connection->schemaCollection()->describe('users');
- $table = new Table([
- 'table' => 'users',
- 'connection' => $this->connection,
- ]);
- $this->assertEquals($schema, $table->schema());
- $table = new Table(['table' => 'stuff']);
- $table->schema($schema);
- $this->assertSame($schema, $table->schema());
- $table = new Table(['table' => 'another']);
- $schema = ['id' => ['type' => 'integer']];
- $table->schema($schema);
- $this->assertEquals(
- new \Cake\Database\Schema\Table('another', $schema),
- $table->schema()
- );
- }
- /**
- * Tests that _initializeSchema can be used to alter the database schema
- *
- * @return void
- */
- public function testSchemaInitialize() {
- $schema = $this->connection->schemaCollection()->describe('users');
- $table = $this->getMock('Cake\ORM\Table', ['_initializeSchema'], [
- ['table' => 'users', 'connection' => $this->connection]
- ]);
- $table->expects($this->once())
- ->method('_initializeSchema')
- ->with($schema)
- ->will($this->returnCallback(function($schema) {
- $schema->columnType('username', 'integer');
- return $schema;
- }));
- $result = $table->schema();
- $schema->columnType('username', 'integer');
- $this->assertEquals($schema, $result);
- $this->assertEquals($schema, $table->schema(), '_initializeSchema should be called once');
- }
- /**
- * Tests that all fields for a table are added by default in a find when no
- * other fields are specified
- *
- * @return void
- */
- public function testFindAllNoFieldsAndNoHydration() {
- $table = new Table([
- 'table' => 'users',
- 'connection' => $this->connection,
- ]);
- $results = $table
- ->find('all')
- ->where(['id IN' => [1, 2]])
- ->order('id')
- ->hydrate(false)
- ->toArray();
- $expected = [
- [
- 'id' => 1,
- 'username' => 'mariano',
- 'password' => '$2a$10$u05j8FjsvLBNdfhBhc21LOuVMpzpabVXQ9OpC2wO3pSO0q6t7HHMO',
- 'created' => new Time('2007-03-17 01:16:23'),
- 'updated' => new Time('2007-03-17 01:18:31'),
- ],
- [
- 'id' => 2,
- 'username' => 'nate',
- 'password' => '$2a$10$u05j8FjsvLBNdfhBhc21LOuVMpzpabVXQ9OpC2wO3pSO0q6t7HHMO',
- 'created' => new Time('2008-03-17 01:18:23'),
- 'updated' => new Time('2008-03-17 01:20:31'),
- ],
- ];
- $this->assertEquals($expected, $results);
- }
- /**
- * Tests that it is possible to select only a few fields when finding over a table
- *
- * @return void
- */
- public function testFindAllSomeFieldsNoHydration() {
- $table = new Table([
- 'table' => 'users',
- 'connection' => $this->connection,
- ]);
- $results = $table->find('all')
- ->select(['username', 'password'])
- ->hydrate(false)
- ->order('username')->toArray();
- $expected = [
- ['username' => 'garrett', 'password' => '$2a$10$u05j8FjsvLBNdfhBhc21LOuVMpzpabVXQ9OpC2wO3pSO0q6t7HHMO'],
- ['username' => 'larry', 'password' => '$2a$10$u05j8FjsvLBNdfhBhc21LOuVMpzpabVXQ9OpC2wO3pSO0q6t7HHMO'],
- ['username' => 'mariano', 'password' => '$2a$10$u05j8FjsvLBNdfhBhc21LOuVMpzpabVXQ9OpC2wO3pSO0q6t7HHMO'],
- ['username' => 'nate', 'password' => '$2a$10$u05j8FjsvLBNdfhBhc21LOuVMpzpabVXQ9OpC2wO3pSO0q6t7HHMO'],
- ];
- $this->assertSame($expected, $results);
- $results = $table->find('all')
- ->select(['foo' => 'username', 'password'])
- ->order('username')
- ->hydrate(false)
- ->toArray();
- $expected = [
- ['foo' => 'garrett', 'password' => '$2a$10$u05j8FjsvLBNdfhBhc21LOuVMpzpabVXQ9OpC2wO3pSO0q6t7HHMO'],
- ['foo' => 'larry', 'password' => '$2a$10$u05j8FjsvLBNdfhBhc21LOuVMpzpabVXQ9OpC2wO3pSO0q6t7HHMO'],
- ['foo' => 'mariano', 'password' => '$2a$10$u05j8FjsvLBNdfhBhc21LOuVMpzpabVXQ9OpC2wO3pSO0q6t7HHMO'],
- ['foo' => 'nate', 'password' => '$2a$10$u05j8FjsvLBNdfhBhc21LOuVMpzpabVXQ9OpC2wO3pSO0q6t7HHMO'],
- ];
- $this->assertSame($expected, $results);
- }
- /**
- * Tests that the query will automatically casts complex conditions to the correct
- * types when the columns belong to the default table
- *
- * @return void
- */
- public function testFindAllConditionAutoTypes() {
- $table = new Table([
- 'table' => 'users',
- 'connection' => $this->connection,
- ]);
- $query = $table->find('all')
- ->select(['id', 'username'])
- ->where(['created >=' => new Time('2010-01-22 00:00')])
- ->hydrate(false)
- ->order('id');
- $expected = [
- ['id' => 3, 'username' => 'larry'],
- ['id' => 4, 'username' => 'garrett']
- ];
- $this->assertSame($expected, $query->toArray());
- $query->orWhere(['users.created' => new Time('2008-03-17 01:18:23')]);
- $expected = [
- ['id' => 2, 'username' => 'nate'],
- ['id' => 3, 'username' => 'larry'],
- ['id' => 4, 'username' => 'garrett']
- ];
- $this->assertSame($expected, $query->toArray());
- }
- /**
- * Test that beforeFind events can mutate the query.
- *
- * @return void
- */
- public function testFindBeforeFindEventMutateQuery() {
- $table = new Table([
- 'table' => 'users',
- 'connection' => $this->connection,
- ]);
- $table->eventManager()->attach(function ($event, $query, $options) {
- $query->limit(1);
- }, 'Model.beforeFind');
- $result = $table->find('all')->all();
- $this->assertCount(1, $result, 'Should only have 1 record, limit 1 applied.');
- }
- /**
- * Test that beforeFind events are fired and can stop the find and
- * return custom results.
- *
- * @return void
- */
- public function testFindBeforeFindEventOverrideReturn() {
- $table = new Table([
- 'table' => 'users',
- 'connection' => $this->connection,
- ]);
- $expected = ['One', 'Two', 'Three'];
- $table->eventManager()->attach(function ($event, $query, $options) use ($expected) {
- $query->setResult($expected);
- $event->stopPropagation();
- }, 'Model.beforeFind');
- $query = $table->find('all');
- $query->limit(1);
- $this->assertEquals($expected, $query->all());
- }
- /**
- * Tests that belongsTo() creates and configures correctly the association
- *
- * @return void
- */
- public function testBelongsTo() {
- $options = ['foreignKey' => 'fake_id', 'conditions' => ['a' => 'b']];
- $table = new Table(['table' => 'dates']);
- $belongsTo = $table->belongsTo('user', $options);
- $this->assertInstanceOf('\Cake\ORM\Association\BelongsTo', $belongsTo);
- $this->assertSame($belongsTo, $table->association('user'));
- $this->assertEquals('user', $belongsTo->name());
- $this->assertEquals('fake_id', $belongsTo->foreignKey());
- $this->assertEquals(['a' => 'b'], $belongsTo->conditions());
- $this->assertSame($table, $belongsTo->source());
- }
- /**
- * Tests that hasOne() creates and configures correctly the association
- *
- * @return void
- */
- public function testHasOne() {
- $options = ['foreignKey' => 'user_id', 'conditions' => ['b' => 'c']];
- $table = new Table(['table' => 'users']);
- $hasOne = $table->hasOne('profile', $options);
- $this->assertInstanceOf('\Cake\ORM\Association\HasOne', $hasOne);
- $this->assertSame($hasOne, $table->association('profile'));
- $this->assertEquals('profile', $hasOne->name());
- $this->assertEquals('user_id', $hasOne->foreignKey());
- $this->assertEquals(['b' => 'c'], $hasOne->conditions());
- $this->assertSame($table, $hasOne->source());
- }
- /**
- * Tests that hasMany() creates and configures correctly the association
- *
- * @return void
- */
- public function testHasMany() {
- $options = [
- 'foreignKey' => 'author_id',
- 'conditions' => ['b' => 'c'],
- 'sort' => ['foo' => 'asc']
- ];
- $table = new Table(['table' => 'authors']);
- $hasMany = $table->hasMany('article', $options);
- $this->assertInstanceOf('\Cake\ORM\Association\HasMany', $hasMany);
- $this->assertSame($hasMany, $table->association('article'));
- $this->assertEquals('article', $hasMany->name());
- $this->assertEquals('author_id', $hasMany->foreignKey());
- $this->assertEquals(['b' => 'c'], $hasMany->conditions());
- $this->assertEquals(['foo' => 'asc'], $hasMany->sort());
- $this->assertSame($table, $hasMany->source());
- }
- /**
- * Tests that BelongsToMany() creates and configures correctly the association
- *
- * @return void
- */
- public function testBelongsToMany() {
- $options = [
- 'foreignKey' => 'thing_id',
- 'joinTable' => 'things_tags',
- 'conditions' => ['b' => 'c'],
- 'sort' => ['foo' => 'asc']
- ];
- $table = new Table(['table' => 'authors', 'connection' => $this->connection]);
- $belongsToMany = $table->belongsToMany('tag', $options);
- $this->assertInstanceOf('\Cake\ORM\Association\BelongsToMany', $belongsToMany);
- $this->assertSame($belongsToMany, $table->association('tag'));
- $this->assertEquals('tag', $belongsToMany->name());
- $this->assertEquals('thing_id', $belongsToMany->foreignKey());
- $this->assertEquals(['b' => 'c'], $belongsToMany->conditions());
- $this->assertEquals(['foo' => 'asc'], $belongsToMany->sort());
- $this->assertSame($table, $belongsToMany->source());
- $this->assertSame('things_tags', $belongsToMany->junction()->table());
- }
- /**
- * Test basic multi row updates.
- *
- * @return void
- */
- public function testUpdateAll() {
- $table = new Table([
- 'table' => 'users',
- 'connection' => $this->connection,
- ]);
- $fields = ['username' => 'mark'];
- $result = $table->updateAll($fields, ['id <' => 4]);
- $this->assertTrue($result);
- $result = $table->find('all')
- ->select(['username'])
- ->order(['id' => 'asc'])
- ->hydrate(false)
- ->toArray();
- $expected = array_fill(0, 3, $fields);
- $expected[] = ['username' => 'garrett'];
- $this->assertEquals($expected, $result);
- }
- /**
- * Test that exceptions from the Query bubble up.
- *
- * @expectedException \Cake\Database\Exception
- */
- public function testUpdateAllFailure() {
- $table = $this->getMock(
- 'Cake\ORM\Table',
- ['query'],
- [['table' => 'users', 'connection' => $this->connection]]
- );
- $query = $this->getMock('Cake\ORM\Query', ['execute'], [$this->connection, $table]);
- $table->expects($this->once())
- ->method('query')
- ->will($this->returnValue($query));
- $query->expects($this->once())
- ->method('execute')
- ->will($this->throwException(new \Cake\Database\Exception('Not good')));
- $table->updateAll(['username' => 'mark'], []);
- }
- /**
- * Test deleting many records.
- *
- * @return void
- */
- public function testDeleteAll() {
- $table = new Table([
- 'table' => 'users',
- 'connection' => $this->connection,
- ]);
- $result = $table->deleteAll(['id <' => 4]);
- $this->assertTrue($result);
- $result = $table->find('all')->toArray();
- $this->assertCount(1, $result, 'Only one record should remain');
- $this->assertEquals(4, $result[0]['id']);
- }
- /**
- * Test deleting many records with conditions using the alias
- *
- * @return void
- */
- public function testDeleteAllAliasedConditions() {
- $table = new Table([
- 'table' => 'users',
- 'alias' => 'Managers',
- 'connection' => $this->connection,
- ]);
- $result = $table->deleteAll(['Managers.id <' => 4]);
- $this->assertTrue($result);
- $result = $table->find('all')->toArray();
- $this->assertCount(1, $result, 'Only one record should remain');
- $this->assertEquals(4, $result[0]['id']);
- }
- /**
- * Test that exceptions from the Query bubble up.
- *
- * @expectedException \Cake\Database\Exception
- */
- public function testDeleteAllFailure() {
- $table = $this->getMock(
- 'Cake\ORM\Table',
- ['query'],
- [['table' => 'users', 'connection' => $this->connection]]
- );
- $query = $this->getMock('Cake\ORM\Query', ['execute'], [$this->connection, $table]);
- $table->expects($this->once())
- ->method('query')
- ->will($this->returnValue($query));
- $query->expects($this->once())
- ->method('execute')
- ->will($this->throwException(new \Cake\Database\Exception('Not good')));
- $table->deleteAll(['id >' => 4]);
- }
- /**
- * Tests that array options are passed to the query object using applyOptions
- *
- * @return void
- */
- public function testFindApplyOptions() {
- $table = $this->getMock(
- 'Cake\ORM\Table',
- ['query', 'findAll'],
- [['table' => 'users', 'connection' => $this->connection]]
- );
- $query = $this->getMock('Cake\ORM\Query', [], [$this->connection, $table]);
- $table->expects($this->once())
- ->method('query')
- ->will($this->returnValue($query));
- $options = ['fields' => ['a', 'b'], 'connections' => ['a >' => 1]];
- $query->expects($this->any())
- ->method('select')
- ->will($this->returnSelf());
- $query->expects($this->once())->method('getOptions')
- ->will($this->returnValue(['connections' => ['a >' => 1]]));
- $query->expects($this->once())
- ->method('applyOptions')
- ->with($options);
- $table->expects($this->once())->method('findAll')
- ->with($query, ['connections' => ['a >' => 1]]);
- $table->find('all', $options);
- }
- /**
- * Tests find('list')
- *
- * @return void
- */
- public function testFindListNoHydration() {
- $table = new Table([
- 'table' => 'users',
- 'connection' => $this->connection,
- ]);
- $table->displayField('username');
- $query = $table->find('list')
- ->hydrate(false)
- ->order('id');
- $expected = [
- 1 => 'mariano',
- 2 => 'nate',
- 3 => 'larry',
- 4 => 'garrett'
- ];
- $this->assertSame($expected, $query->toArray());
- $query = $table->find('list', ['fields' => ['id', 'username']])
- ->hydrate(false)
- ->order('id');
- $expected = [
- 1 => 'mariano',
- 2 => 'nate',
- 3 => 'larry',
- 4 => 'garrett'
- ];
- $this->assertSame($expected, $query->toArray());
- $query = $table->find('list', ['groupField' => 'odd'])
- ->select(['id', 'username', 'odd' => new QueryExpression('id % 2')])
- ->hydrate(false)
- ->order('id');
- $expected = [
- 1 => [
- 1 => 'mariano',
- 3 => 'larry'
- ],
- 0 => [
- 2 => 'nate',
- 4 => 'garrett'
- ]
- ];
- $this->assertSame($expected, $query->toArray());
- }
- /**
- * Tests find('threaded')
- *
- * @return void
- */
- public function testFindThreadedNoHydration() {
- $table = new Table([
- 'table' => 'categories',
- 'connection' => $this->connection,
- ]);
- $expected = [
- [
- 'id' => 1,
- 'parent_id' => 0,
- 'name' => 'Category 1',
- 'children' => [
- [
- 'id' => 2,
- 'parent_id' => 1,
- 'name' => 'Category 1.1',
- 'children' => [
- [
- 'id' => 7,
- 'parent_id' => 2,
- 'name' => 'Category 1.1.1',
- 'children' => []
- ],
- [
- 'id' => 8,
- 'parent_id' => '2',
- 'name' => 'Category 1.1.2',
- 'children' => []
- ]
- ],
- ],
- [
- 'id' => 3,
- 'parent_id' => '1',
- 'name' => 'Category 1.2',
- 'children' => []
- ],
- ]
- ],
- [
- 'id' => 4,
- 'parent_id' => 0,
- 'name' => 'Category 2',
- 'children' => []
- ],
- [
- 'id' => 5,
- 'parent_id' => 0,
- 'name' => 'Category 3',
- 'children' => [
- [
- 'id' => '6',
- 'parent_id' => '5',
- 'name' => 'Category 3.1',
- 'children' => []
- ]
- ]
- ]
- ];
- $results = $table->find('all')
- ->select(['id', 'parent_id', 'name'])
- ->hydrate(false)
- ->find('threaded')
- ->toArray();
- $this->assertEquals($expected, $results);
- }
- /**
- * Tests that finders can be stacked
- *
- * @return void
- */
- public function testStackingFinders() {
- $table = $this->getMock('\Cake\ORM\Table', ['find', 'findList'], [], '', false);
- $params = [$this->connection, $table];
- $query = $this->getMock('\Cake\ORM\Query', ['addDefaultTypes'], $params);
- $table->expects($this->once())
- ->method('find')
- ->with('threaded', ['order' => ['name' => 'ASC']])
- ->will($this->returnValue($query));
- $table->expects($this->once())
- ->method('findList')
- ->with($query, ['keyPath' => 'id'])
- ->will($this->returnValue($query));
- $result = $table
- ->find('threaded', ['order' => ['name' => 'ASC']])
- ->find('list', ['keyPath' => 'id']);
- $this->assertSame($query, $result);
- }
- /**
- * Tests find('threaded') with hydrated results
- *
- * @return void
- */
- public function testFindThreadedHydrated() {
- $table = new Table([
- 'table' => 'categories',
- 'connection' => $this->connection,
- ]);
- $results = $table->find('all')
- ->find('threaded')
- ->select(['id', 'parent_id', 'name'])
- ->toArray();
- $this->assertEquals(1, $results[0]->id);
- $expected = [
- 'id' => 8,
- 'parent_id' => 2,
- 'name' => 'Category 1.1.2',
- 'children' => []
- ];
- $this->assertEquals($expected, $results[0]->children[0]->children[1]->toArray());
- }
- /**
- * Tests find('list') with hydrated records
- *
- * @return void
- */
- public function testFindListHydrated() {
- $table = new Table([
- 'table' => 'users',
- 'connection' => $this->connection,
- ]);
- $table->displayField('username');
- $query = $table
- ->find('list', ['fields' => ['id', 'username']])
- ->order('id');
- $expected = [
- 1 => 'mariano',
- 2 => 'nate',
- 3 => 'larry',
- 4 => 'garrett'
- ];
- $this->assertSame($expected, $query->toArray());
- $query = $table->find('list', ['groupField' => 'odd'])
- ->select(['id', 'username', 'odd' => new QueryExpression('id % 2')])
- ->hydrate(true)
- ->order('id');
- $expected = [
- 1 => [
- 1 => 'mariano',
- 3 => 'larry'
- ],
- 0 => [
- 2 => 'nate',
- 4 => 'garrett'
- ]
- ];
- $this->assertSame($expected, $query->toArray());
- }
- /**
- * Test the default entityClass.
- *
- * @return void
- */
- public function testEntityClassDefault() {
- $table = new Table();
- $this->assertEquals('\Cake\ORM\Entity', $table->entityClass());
- }
- /**
- * Tests that using a simple string for entityClass will try to
- * load the class from the App namespace
- *
- * @return void
- */
- public function testTableClassInApp() {
- $class = $this->getMockClass('\Cake\ORM\Entity');
- if (!class_exists('TestApp\Model\Entity\TestUser')) {
- class_alias($class, 'TestApp\Model\Entity\TestUser');
- }
- $table = new Table();
- $this->assertEquals('TestApp\Model\Entity\TestUser', $table->entityClass('TestUser'));
- }
- /**
- * Tests that using a simple string for entityClass will try to
- * load the class from the Plugin namespace when using plugin notation
- *
- * @return void
- */
- public function testTableClassInPlugin() {
- $class = $this->getMockClass('\Cake\ORM\Entity');
- if (!class_exists('MyPlugin\Model\Entity\SuperUser')) {
- class_alias($class, 'MyPlugin\Model\Entity\SuperUser');
- }
- $table = new Table();
- $this->assertEquals(
- 'MyPlugin\Model\Entity\SuperUser',
- $table->entityClass('MyPlugin.SuperUser')
- );
- }
- /**
- * Tests that using a simple string for entityClass will throw an exception
- * when the class does not exist in the namespace
- *
- * @expectedException \Cake\ORM\Exception\MissingEntityException
- * @expectedExceptionMessage Entity class FooUser could not be found.
- * @return void
- */
- public function testTableClassNonExisting() {
- $table = new Table;
- $this->assertFalse($table->entityClass('FooUser'));
- }
- /**
- * Tests getting the entityClass based on conventions for the entity
- * namespace
- *
- * @return void
- */
- public function testTableClassConventionForAPP() {
- $table = new \TestApp\Model\Table\ArticlesTable;
- $this->assertEquals('TestApp\Model\Entity\Article', $table->entityClass());
- }
- /**
- * Tests setting a entity class object using the setter method
- *
- * @return void
- */
- public function testSetEntityClass() {
- $table = new Table;
- $class = '\\' . $this->getMockClass('\Cake\ORM\Entity');
- $table->entityClass($class);
- $this->assertEquals($class, $table->entityClass());
- }
- /**
- * Proves that associations, even though they are lazy loaded, will fetch
- * records using the correct table class and hydrate with the correct entity
- *
- * @return void
- */
- public function testReciprocalBelongsToLoading() {
- $table = new \TestApp\Model\Table\ArticlesTable([
- 'connection' => $this->connection,
- ]);
- $result = $table->find('all')->contain(['authors'])->first();
- $this->assertInstanceOf('TestApp\Model\Entity\Author', $result->author);
- }
- /**
- * Proves that associations, even though they are lazy loaded, will fetch
- * records using the correct table class and hydrate with the correct entity
- *
- * @return void
- */
- public function testReciprocalHasManyLoading() {
- $table = new \TestApp\Model\Table\ArticlesTable([
- 'connection' => $this->connection,
- ]);
- $result = $table->find('all')->contain(['authors' => ['articles']])->first();
- $this->assertCount(2, $result->author->articles);
- foreach ($result->author->articles as $article) {
- $this->assertInstanceOf('TestApp\Model\Entity\Article', $article);
- }
- }
- /**
- * Tests that the correct table and entity are loaded for the join association in
- * a belongsToMany setup
- *
- * @return void
- */
- public function testReciprocalBelongsToMany() {
- $table = new \TestApp\Model\Table\ArticlesTable([
- 'connection' => $this->connection,
- ]);
- $result = $table->find('all')->contain(['tags'])->first();
- $this->assertInstanceOf('TestApp\Model\Entity\Tag', $result->tags[0]);
- $this->assertInstanceOf(
- 'TestApp\Model\Entity\ArticlesTag',
- $result->tags[0]->_joinData
- );
- }
- /**
- * Tests that recently fetched entities are always clean
- *
- * @return void
- */
- public function testFindCleanEntities() {
- $table = new \TestApp\Model\Table\ArticlesTable([
- 'connection' => $this->connection,
- ]);
- $results = $table->find('all')->contain(['tags', 'authors'])->toArray();
- $this->assertCount(3, $results);
- foreach ($results as $article) {
- $this->assertFalse($article->dirty('id'));
- $this->assertFalse($article->dirty('title'));
- $this->assertFalse($article->dirty('author_id'));
- $this->assertFalse($article->dirty('body'));
- $this->assertFalse($article->dirty('published'));
- $this->assertFalse($article->dirty('author'));
- $this->assertFalse($article->author->dirty('id'));
- $this->assertFalse($article->author->dirty('name'));
- $this->assertFalse($article->dirty('tag'));
- if ($article->tag) {
- $this->assertFalse($article->tag[0]->_joinData->dirty('tag_id'));
- }
- }
- }
- /**
- * Tests that recently fetched entities are marked as not new
- *
- * @return void
- */
- public function testFindPersistedEntities() {
- $table = new \TestApp\Model\Table\ArticlesTable([
- 'connection' => $this->connection,
- ]);
- $results = $table->find('all')->contain(['tags', 'authors'])->toArray();
- $this->assertCount(3, $results);
- foreach ($results as $article) {
- $this->assertFalse($article->isNew());
- foreach ((array)$article->tag as $tag) {
- $this->assertFalse($tag->isNew());
- $this->assertFalse($tag->_joinData->isNew());
- }
- }
- }
- /**
- * Tests the exists function
- *
- * @return void
- */
- public function testExists() {
- $table = TableRegistry::get('users');
- $this->assertTrue($table->exists(['id' => 1]));
- $this->assertFalse($table->exists(['id' => 501]));
- $this->assertTrue($table->exists(['id' => 3, 'username' => 'larry']));
- }
- /**
- * Test adding a behavior to a table.
- *
- * @return void
- */
- public function testAddBehavior() {
- $mock = $this->getMock('Cake\ORM\BehaviorRegistry', [], [], '', false);
- $mock->expects($this->once())
- ->method('load')
- ->with('Sluggable');
- $table = new Table([
- 'table' => 'articles',
- 'behaviors' => $mock
- ]);
- $table->addBehavior('Sluggable');
- }
- /**
- * Test removing a behavior from a table.
- *
- * @return void
- */
- public function testRemoveBehavior() {
- $mock = $this->getMock('Cake\ORM\BehaviorRegistry', [], [], '', false);
- $mock->expects($this->once())
- ->method('unload')
- ->with('Sluggable');
- $table = new Table([
- 'table' => 'articles',
- 'behaviors' => $mock
- ]);
- $table->removeBehavior('Sluggable');
- }
- /**
- * Test getting a behavior instance from a table.
- *
- * @return void
- */
- public function testBehaviors() {
- $table = TableRegistry::get('article');
- $result = $table->behaviors();
- $this->assertInstanceOf('\Cake\ORM\BehaviorRegistry', $result);
- }
- /**
- * Ensure exceptions are raised on missing behaviors.
- *
- * @expectedException \Cake\ORM\Exception\MissingBehaviorException
- */
- public function testAddBehaviorMissing() {
- $table = TableRegistry::get('article');
- $this->assertNull($table->addBehavior('NopeNotThere'));
- }
- /**
- * Test mixin methods from behaviors.
- *
- * @return void
- */
- public function testCallBehaviorMethod() {
- $table = TableRegistry::get('article');
- $table->addBehavior('Sluggable');
- $this->assertEquals('some_value', $table->slugify('some value'));
- }
- /**
- * Test you can alias a behavior method
- *
- * @return void
- */
- public function testCallBehaviorAliasedMethod() {
- $table = TableRegistry::get('article');
- $table->addBehavior('Sluggable', ['implementedMethods' => ['wednesday' => 'slugify']]);
- $this->assertEquals('some_value', $table->wednesday('some value'));
- }
- /**
- * Test finder methods from behaviors.
- *
- * @return void
- */
- public function testCallBehaviorFinder() {
- $table = TableRegistry::get('articles');
- $table->addBehavior('Sluggable');
- $query = $table->find('noSlug');
- $this->assertInstanceOf('Cake\ORM\Query', $query);
- $this->assertNotEmpty($query->clause('where'));
- }
- /**
- * testCallBehaviorAliasedFinder
- *
- * @return void
- */
- public function testCallBehaviorAliasedFinder() {
- $table = TableRegistry::get('articles');
- $table->addBehavior('Sluggable', ['implementedFinders' => ['special' => 'findNoSlug']]);
- $query = $table->find('special');
- $this->assertInstanceOf('Cake\ORM\Query', $query);
- $this->assertNotEmpty($query->clause('where'));
- }
- /**
- * Test implementedEvents
- *
- * @return void
- */
- public function testImplementedEvents() {
- $table = $this->getMock(
- 'Cake\ORM\Table',
- ['beforeFind', 'beforeSave', 'afterSave', 'beforeDelete', 'afterDelete']
- );
- $result = $table->implementedEvents();
- $expected = [
- 'Model.beforeFind' => 'beforeFind',
- 'Model.beforeSave' => 'beforeSave',
- 'Model.afterSave' => 'afterSave',
- 'Model.beforeDelete' => 'beforeDelete',
- 'Model.afterDelete' => 'afterDelete',
- ];
- $this->assertEquals($expected, $result, 'Events do not match.');
- }
- /**
- * Tests that it is possible to insert a new row using the save method
- *
- * @group save
- * @return void
- */
- public function testSaveNewEntity() {
- $entity = new \Cake\ORM\Entity([
- 'username' => 'superuser',
- 'password' => 'root',
- 'created' => new Time('2013-10-10 00:00'),
- 'updated' => new Time('2013-10-10 00:00')
- ]);
- $table = TableRegistry::get('users');
- $this->assertSame($entity, $table->save($entity));
- $this->assertEquals($entity->id, self::$nextUserId);
- $row = $table->find('all')->where(['id' => self::$nextUserId])->first();
- $this->assertEquals($entity->toArray(), $row->toArray());
- }
- /**
- * Test that saving a new empty entity does nothing.
- *
- * @group save
- * @return void
- */
- public function testSaveNewEmptyEntity() {
- $entity = new \Cake\ORM\Entity();
- $table = TableRegistry::get('users');
- $this->assertFalse($table->save($entity));
- }
- /**
- * Test that saving a new empty entity does not call exists.
- *
- * @group save
- * @return void
- */
- public function testSaveNewEntityNoExists() {
- $table = $this->getMock(
- 'Cake\ORM\Table',
- ['exists'],
- [[
- 'connection' => $this->connection,
- 'alias' => 'Users',
- 'table' => 'users',
- ]]
- );
- $entity = $table->newEntity(['username' => 'mark']);
- $this->assertTrue($entity->isNew());
- $table->expects($this->never())
- ->method('exists');
- $this->assertSame($entity, $table->save($entity));
- }
- /**
- * Tests that saving an entity will filter out properties that
- * are not present in the table schema when saving
- *
- * @group save
- * @return void
- */
- public function testSaveEntityOnlySchemaFields() {
- $entity = new \Cake\ORM\Entity([
- 'username' => 'superuser',
- 'password' => 'root',
- 'crazyness' => 'super crazy value',
- 'created' => new Time('2013-10-10 00:00'),
- 'updated' => new Time('2013-10-10 00:00'),
- ]);
- $table = TableRegistry::get('users');
- $this->assertSame($entity, $table->save($entity));
- $this->assertEquals($entity->id, self::$nextUserId);
- $row = $table->find('all')->where(['id' => self::$nextUserId])->first();
- $entity->unsetProperty('crazyness');
- $this->assertEquals($entity->toArray(), $row->toArray());
- }
- /**
- * Tests that it is possible to modify data from the beforeSave callback
- *
- * @group save
- * @return void
- */
- public function testBeforeSaveModifyData() {
- $table = TableRegistry::get('users');
- $data = new \Cake\ORM\Entity([
- 'username' => 'superuser',
- 'created' => new Time('2013-10-10 00:00'),
- 'updated' => new Time('2013-10-10 00:00')
- ]);
- $listener = function($e, $entity, $options) use ($data) {
- $this->assertSame($data, $entity);
- $entity->set('password', 'foo');
- };
- $table->eventManager()->attach($listener, 'Model.beforeSave');
- $this->assertSame($data, $table->save($data));
- $this->assertEquals($data->id, self::$nextUserId);
- $row = $table->find('all')->where(['id' => self::$nextUserId])->first();
- $this->assertEquals('foo', $row->get('password'));
- }
- /**
- * Tests that it is possible to modify the options array in beforeSave
- *
- * @group save
- * @return void
- */
- public function testBeforeSaveModifyOptions() {
- $table = TableRegistry::get('users');
- $data = new \Cake\ORM\Entity([
- 'username' => 'superuser',
- 'password' => 'foo',
- 'created' => new Time('2013-10-10 00:00'),
- 'updated' => new Time('2013-10-10 00:00')
- ]);
- $listener1 = function($e, $entity, $options) {
- $options['crazy'] = true;
- };
- $listener2 = function($e, $entity, $options) {
- $this->assertTrue($options['crazy']);
- };
- $table->eventManager()->attach($listener1, 'Model.beforeSave');
- $table->eventManager()->attach($listener2, 'Model.beforeSave');
- $this->assertSame($data, $table->save($data));
- $this->assertEquals($data->id, self::$nextUserId);
- $row = $table->find('all')->where(['id' => self::$nextUserId])->first();
- $this->assertEquals($data->toArray(), $row->toArray());
- }
- /**
- * Tests that it is possible to stop the saving altogether, without implying
- * the save operation failed
- *
- * @group save
- * @return void
- */
- public function testBeforeSaveStopEvent() {
- $table = TableRegistry::get('users');
- $data = new \Cake\ORM\Entity([
- 'username' => 'superuser',
- 'created' => new Time('2013-10-10 00:00'),
- 'updated' => new Time('2013-10-10 00:00')
- ]);
- $listener = function($e, $entity) {
- $e->stopPropagation();
- return $entity;
- };
- $table->eventManager()->attach($listener, 'Model.beforeSave');
- $this->assertSame($data, $table->save($data));
- $this->assertNull($data->id);
- $row = $table->find('all')->where(['id' => self::$nextUserId])->first();
- $this->assertNull($row);
- }
- /**
- * Asserts that afterSave callback is called on successful save
- *
- * @group save
- * @return void
- */
- public function testAfterSave() {
- $table = TableRegistry::get('users');
- $data = new \Cake\ORM\Entity([
- 'username' => 'superuser',
- 'created' => new Time('2013-10-10 00:00'),
- 'updated' => new Time('2013-10-10 00:00')
- ]);
- $called = false;
- $listener = function($e, $entity, $options) use ($data, &$called) {
- $this->assertSame($data, $entity);
- $called = true;
- };
- $table->eventManager()->attach($listener, 'Model.afterSave');
- $this->assertSame($data, $table->save($data));
- $this->assertEquals($data->id, self::$nextUserId);
- $this->assertTrue($called);
- }
- /**
- * Asserts that afterSave callback not is called on unsuccessful save
- *
- * @group save
- * @return void
- */
- public function testAfterSaveNotCalled() {
- $table = $this->getMock(
- '\Cake\ORM\Table',
- ['query'],
- [['table' => 'users', 'connection' => $this->connection]]
- );
- $query = $this->getMock(
- '\Cake\ORM\Query',
- ['execute', 'addDefaultTypes'],
- [null, $table]
- );
- $statement = $this->getMock('\Cake\Database\Statement\StatementDecorator');
- $data = new \Cake\ORM\Entity([
- 'username' => 'superuser',
- 'created' => new Time('2013-10-10 00:00'),
- 'updated' => new Time('2013-10-10 00:00')
- ]);
- $table->expects($this->once())->method('query')
- ->will($this->returnValue($query));
- $query->expects($this->once())->method('execute')
- ->will($this->returnValue($statement));
- $statement->expects($this->once())->method('rowCount')
- ->will($this->returnValue(0));
- $called = false;
- $listener = function($e, $entity, $options) use ($data, &$called) {
- $called = true;
- };
- $table->eventManager()->attach($listener, 'Model.afterSave');
- $this->assertFalse($table->save($data));
- $this->assertFalse($called);
- }
- /**
- * Test that you cannot save rows without a primary key.
- *
- * @group save
- * @expectedException \RuntimeException
- * @expectedExceptionMessage Cannot insert row in "users" table, it has no primary key
- * @return void
- */
- public function testSaveNewErrorOnNoPrimaryKey() {
- $entity = new \Cake\ORM\Entity(['username' => 'superuser']);
- $table = TableRegistry::get('users', [
- 'schema' => [
- 'id' => ['type' => 'integer'],
- 'username' => ['type' => 'string'],
- ]
- ]);
- $table->save($entity);
- }
- /**
- * Tests that save is wrapped around a transaction
- *
- * @group save
- * @return void
- */
- public function testAtomicSave() {
- $config = ConnectionManager::config('test');
- $connection = $this->getMock(
- '\Cake\Database\Connection',
- ['begin', 'commit'],
- [$config]
- );
- $connection->driver($this->connection->driver());
- $table = $this->getMock('\Cake\ORM\Table', ['connection'], [['table' => 'users']]);
- $table->expects($this->any())->method('connection')
- ->will($this->returnValue($connection));
- $connection->expects($this->once())->method('begin');
- $connection->expects($this->once())->method('commit');
- $data = new \Cake\ORM\Entity([
- 'username' => 'superuser',
- 'created' => new Time('2013-10-10 00:00'),
- 'updated' => new Time('2013-10-10 00:00')
- ]);
- $this->assertSame($data, $table->save($data));
- }
- /**
- * Tests that save will rollback the transaction in the case of an exception
- *
- * @group save
- * @expectedException \PDOException
- * @return void
- */
- public function testAtomicSaveRollback() {
- $connection = $this->getMock(
- '\Cake\Database\Connection',
- ['begin', 'rollback'],
- [ConnectionManager::config('test')]
- );
- $connection->driver(ConnectionManager::get('test')->driver());
- $table = $this->getMock(
- '\Cake\ORM\Table',
- ['query', 'connection'],
- [['table' => 'users']]
- );
- $query = $this->getMock(
- '\Cake\ORM\Query',
- ['execute', 'addDefaultTypes'],
- [null, $table]
- );
- $table->expects($this->any())->method('connection')
- ->will($this->returnValue($connection));
- $table->expects($this->once())->method('query')
- ->will($this->returnValue($query));
- $connection->expects($this->once())->method('begin');
- $connection->expects($this->once())->method('rollback');
- $query->expects($this->once())->method('execute')
- ->will($this->throwException(new \PDOException));
- $data = new \Cake\ORM\Entity([
- 'username' => 'superuser',
- 'created' => new Time('2013-10-10 00:00'),
- 'updated' => new Time('2013-10-10 00:00')
- ]);
- $table->save($data);
- }
- /**
- * Tests that save will rollback the transaction in the case of an exception
- *
- * @group save
- * @return void
- */
- public function testAtomicSaveRollbackOnFailure() {
- $connection = $this->getMock(
- '\Cake\Database\Connection',
- ['begin', 'rollback'],
- [ConnectionManager::config('test')]
- );
- $connection->driver(ConnectionManager::get('test')->driver());
- $table = $this->getMock(
- '\Cake\ORM\Table',
- ['query', 'connection', 'exists'],
- [['table' => 'users']]
- );
- $query = $this->getMock(
- '\Cake\ORM\Query',
- ['execute', 'addDefaultTypes'],
- [null, $table]
- );
- $table->expects($this->any())->method('connection')
- ->will($this->returnValue($connection));
- $table->expects($this->once())->method('query')
- ->will($this->returnValue($query));
- $statement = $this->getMock('\Cake\Database\Statement\StatementDecorator');
- $statement->expects($this->once())
- ->method('rowCount')
- ->will($this->returnValue(0));
- $connection->expects($this->once())->method('begin');
- $connection->expects($this->once())->method('rollback');
- $query->expects($this->once())
- ->method('execute')
- ->will($this->returnValue($statement));
- $data = new \Cake\ORM\Entity([
- 'username' => 'superuser',
- 'created' => new Time('2013-10-10 00:00'),
- 'updated' => new Time('2013-10-10 00:00')
- ]);
- $table->save($data);
- }
- /**
- * Tests that only the properties marked as dirty are actually saved
- * to the database
- *
- * @group save
- * @return void
- */
- public function testSaveOnlyDirtyProperties() {
- $entity = new \Cake\ORM\Entity([
- 'username' => 'superuser',
- 'password' => 'root',
- 'created' => new Time('2013-10-10 00:00'),
- 'updated' => new Time('2013-10-10 00:00')
- ]);
- $entity->clean();
- $entity->dirty('username', true);
- $entity->dirty('created', true);
- $entity->dirty('updated', true);
- $table = TableRegistry::get('users');
- $this->assertSame($entity, $table->save($entity));
- $this->assertEquals($entity->id, self::$nextUserId);
- $row = $table->find('all')->where(['id' => self::$nextUserId])->first();
- $entity->set('password', null);
- $this->assertEquals($entity->toArray(), $row->toArray());
- }
- /**
- * Tests that a recently saved entity is marked as clean
- *
- * @group save
- * @return void
- */
- public function testASavedEntityIsClean() {
- $entity = new \Cake\ORM\Entity([
- 'username' => 'superuser',
- 'password' => 'root',
- 'created' => new Time('2013-10-10 00:00'),
- 'updated' => new Time('2013-10-10 00:00')
- ]);
- $table = TableRegistry::get('users');
- $this->assertSame($entity, $table->save($entity));
- $this->assertFalse($entity->dirty('usermane'));
- $this->assertFalse($entity->dirty('password'));
- $this->assertFalse($entity->dirty('created'));
- $this->assertFalse($entity->dirty('updated'));
- }
- /**
- * Tests that a recently saved entity is marked as not new
- *
- * @group save
- * @return void
- */
- public function testASavedEntityIsNotNew() {
- $entity = new \Cake\ORM\Entity([
- 'username' => 'superuser',
- 'password' => 'root',
- 'created' => new Time('2013-10-10 00:00'),
- 'updated' => new Time('2013-10-10 00:00')
- ]);
- $table = TableRegistry::get('users');
- $this->assertSame($entity, $table->save($entity));
- $this->assertFalse($entity->isNew());
- }
- /**
- * Tests that save can detect automatically if it needs to insert
- * or update a row
- *
- * @group save
- * @return void
- */
- public function testSaveUpdateAuto() {
- $entity = new \Cake\ORM\Entity([
- 'id' => 2,
- 'username' => 'baggins'
- ]);
- $table = TableRegistry::get('users');
- $original = $table->find('all')->where(['id' => 2])->first();
- $this->assertSame($entity, $table->save($entity));
- $row = $table->find('all')->where(['id' => 2])->first();
- $this->assertEquals('baggins', $row->username);
- $this->assertEquals($original->password, $row->password);
- $this->assertEquals($original->created, $row->created);
- $this->assertEquals($original->updated, $row->updated);
- $this->assertFalse($entity->isNew());
- $this->assertFalse($entity->dirty('id'));
- $this->assertFalse($entity->dirty('username'));
- }
- /**
- * Tests that beforeFind gets the correct isNew() state for the entity
- *
- * @return void
- */
- public function testBeforeSaveGetsCorrectPersistance() {
- $entity = new \Cake\ORM\Entity([
- 'id' => 2,
- 'username' => 'baggins'
- ]);
- $table = TableRegistry::get('users');
- $called = false;
- $listener = function($event, $entity) use (&$called) {
- $this->assertFalse($entity->isNew());
- $called = true;
- };
- $table->eventManager()->attach($listener, 'Model.beforeSave');
- $this->assertSame($entity, $table->save($entity));
- $this->assertTrue($called);
- }
- /**
- * Tests that marking an entity as already persisted will prevent the save
- * method from trying to infer the entity's actual status.
- *
- * @group save
- * @return void
- */
- public function testSaveUpdateWithHint() {
- $table = $this->getMock(
- '\Cake\ORM\Table',
- ['exists'],
- [['table' => 'users', 'connection' => ConnectionManager::get('test')]]
- );
- $entity = new \Cake\ORM\Entity([
- 'id' => 2,
- 'username' => 'baggins'
- ], ['markNew' => false]);
- $this->assertFalse($entity->isNew());
- $table->expects($this->never())->method('exists');
- $this->assertSame($entity, $table->save($entity));
- }
- /**
- * Tests that when updating the primary key is not passed to the list of
- * attributes to change
- *
- * @group save
- * @return void
- */
- public function testSaveUpdatePrimaryKeyNotModified() {
- $table = $this->getMock(
- '\Cake\ORM\Table',
- ['query'],
- [['table' => 'users', 'connection' => $this->connection]]
- );
- $query = $this->getMock(
- '\Cake\ORM\Query',
- ['execute', 'addDefaultTypes', 'set'],
- [null, $table]
- );
- $table->expects($this->once())->method('query')
- ->will($this->returnValue($query));
- $statement = $this->getMock('\Cake\Database\Statement\StatementDecorator');
- $statement->expects($this->once())
- ->method('errorCode')
- ->will($this->returnValue('00000'));
- $query->expects($this->once())
- ->method('execute')
- ->will($this->returnValue($statement));
- $query->expects($this->once())->method('set')
- ->with(['username' => 'baggins'])
- ->will($this->returnValue($query));
- $entity = new \Cake\ORM\Entity([
- 'id' => 2,
- 'username' => 'baggins'
- ], ['markNew' => false]);
- $this->assertSame($entity, $table->save($entity));
- }
- /**
- * Tests that passing only the primary key to save will not execute any queries
- * but still return success
- *
- * @group save
- * @return void
- */
- public function testUpdateNoChange() {
- $table = $this->getMock(
- '\Cake\ORM\Table',
- ['query'],
- [['table' => 'users', 'connection' => $this->connection]]
- );
- $table->expects($this->never())->method('query');
- $entity = new \Cake\ORM\Entity([
- 'id' => 2,
- ], ['markNew' => false]);
- $this->assertSame($entity, $table->save($entity));
- }
- /**
- * Tests that passing only the primary key to save will not execute any queries
- * but still return success
- *
- * @group save
- * @group integration
- * @return void
- */
- public function testUpdateDirtyNoActualChanges() {
- $table = TableRegistry::get('Articles');
- $entity = $table->get(1);
- $entity->accessible('*', true);
- $entity->set($entity->toArray());
- $this->assertSame($entity, $table->save($entity));
- }
- /**
- * Tests that failing to pass a primary key to save will result in exception
- *
- * @group save
- * @expectedException \InvalidArgumentException
- * @return void
- */
- public function testUpdateNoPrimaryButOtherKeys() {
- $table = $this->getMock(
- '\Cake\ORM\Table',
- ['query'],
- [['table' => 'users', 'connection' => $this->connection]]
- );
- $table->expects($this->never())->method('query');
- $entity = new \Cake\ORM\Entity([
- 'username' => 'mariano',
- ], ['markNew' => false]);
- $this->assertSame($entity, $table->save($entity));
- }
- /**
- * Test simple delete.
- *
- * @return void
- */
- public function testDelete() {
- $table = TableRegistry::get('users');
- $conditions = [
- 'limit' => 1,
- 'conditions' => [
- 'username' => 'nate'
- ]
- ];
- $query = $table->find('all', $conditions);
- $entity = $query->first();
- $result = $table->delete($entity);
- $this->assertTrue($result);
- $query = $table->find('all', $conditions);
- $results = $query->execute();
- $this->assertCount(0, $results, 'Find should fail.');
- }
- /**
- * Test delete with dependent records
- *
- * @return void
- */
- public function testDeleteDependent() {
- $table = TableRegistry::get('authors');
- $table->hasOne('articles', [
- 'foreignKey' => 'author_id',
- 'dependent' => true,
- ]);
- $query = $table->find('all')->where(['id' => 1]);
- $entity = $query->first();
- $result = $table->delete($entity);
- $articles = $table->association('articles')->target();
- $query = $articles->find('all', [
- 'conditions' => [
- 'author_id' => $entity->id
- ]
- ]);
- $this->assertNull($query->all()->first(), 'Should not find any rows.');
- }
- /**
- * Test delete with dependent = false does not cascade.
- *
- * @return void
- */
- public function testDeleteNoDependentNoCascade() {
- $table = TableRegistry::get('authors');
- $table->hasMany('article', [
- 'foreignKey' => 'author_id',
- 'dependent' => false,
- ]);
- $query = $table->find('all')->where(['id' => 1]);
- $entity = $query->first();
- $result = $table->delete($entity);
- $articles = $table->association('articles')->target();
- $query = $articles->find('all')->where(['author_id' => $entity->id]);
- $this->assertCount(2, $query->execute(), 'Should find rows.');
- }
- /**
- * Test delete with BelongsToMany
- *
- * @return void
- */
- public function testDeleteBelongsToMany() {
- $table = TableRegistry::get('articles');
- $table->belongsToMany('tag', [
- 'foreignKey' => 'article_id',
- 'joinTable' => 'articles_tags'
- ]);
- $query = $table->find('all')->where(['id' => 1]);
- $entity = $query->first();
- $table->delete($entity);
- $junction = $table->association('tags')->junction();
- $query = $junction->find('all')->where(['article_id' => 1]);
- $this->assertNull($query->all()->first(), 'Should not find any rows.');
- }
- /**
- * Test delete callbacks
- *
- * @return void
- */
- public function testDeleteCallbacks() {
- $entity = new \Cake\ORM\Entity(['id' => 1, 'name' => 'mark']);
- $options = new \ArrayObject(['atomic' => true]);
- $mock = $this->getMock('Cake\Event\EventManager');
- $mock->expects($this->at(0))
- ->method('attach');
- $mock->expects($this->at(1))
- ->method('dispatch')
- ->with($this->logicalAnd(
- $this->attributeEqualTo('_name', 'Model.beforeDelete'),
- $this->attributeEqualTo(
- 'data',
- ['entity' => $entity, 'options' => $options]
- )
- ));
- $mock->expects($this->at(2))
- ->method('dispatch')
- ->with($this->logicalAnd(
- $this->attributeEqualTo('_name', 'Model.afterDelete'),
- $this->attributeEqualTo(
- 'data',
- ['entity' => $entity, 'options' => $options]
- )
- ));
- $table = TableRegistry::get('users', ['eventManager' => $mock]);
- $entity->isNew(false);
- $table->delete($entity);
- }
- /**
- * Test delete beforeDelete can abort the delete.
- *
- * @return void
- */
- public function testDeleteBeforeDeleteAbort() {
- $entity = new \Cake\ORM\Entity(['id' => 1, 'name' => 'mark']);
- $options = new \ArrayObject(['atomic' => true, 'cascade' => true]);
- $mock = $this->getMock('Cake\Event\EventManager');
- $mock->expects($this->once())
- ->method('dispatch')
- ->will($this->returnCallback(function($event) {
- $event->stopPropagation();
- }));
- $table = TableRegistry::get('users', ['eventManager' => $mock]);
- $entity->isNew(false);
- $result = $table->delete($entity);
- $this->assertNull($result);
- }
- /**
- * Test delete beforeDelete return result
- *
- * @return void
- */
- public function testDeleteBeforeDeleteReturnResult() {
- $entity = new \Cake\ORM\Entity(['id' => 1, 'name' => 'mark']);
- $options = new \ArrayObject(['atomic' => true, 'cascade' => true]);
- $mock = $this->getMock('Cake\Event\EventManager');
- $mock->expects($this->once())
- ->method('dispatch')
- ->will($this->returnCallback(function($event) {
- $event->stopPropagation();
- $event->result = 'got stopped';
- }));
- $table = TableRegistry::get('users', ['eventManager' => $mock]);
- $entity->isNew(false);
- $result = $table->delete($entity);
- $this->assertEquals('got stopped', $result);
- }
- /**
- * Test deleting new entities does nothing.
- *
- * @return void
- */
- public function testDeleteIsNew() {
- $entity = new \Cake\ORM\Entity(['id' => 1, 'name' => 'mark']);
- $table = $this->getMock(
- 'Cake\ORM\Table',
- ['query'],
- [['connection' => $this->connection]]
- );
- $table->expects($this->never())
- ->method('query');
- $entity->isNew(true);
- $result = $table->delete($entity);
- $this->assertFalse($result);
- }
- /**
- * test hasField()
- *
- * @return void
- */
- public function testHasField() {
- $table = TableRegistry::get('articles');
- $this->assertFalse($table->hasField('nope'), 'Should not be there.');
- $this->assertTrue($table->hasField('title'), 'Should be there.');
- $this->assertTrue($table->hasField('body'), 'Should be there.');
- }
- /**
- * Tests that there exists a default validator
- *
- * @return void
- */
- public function testValidatorDefault() {
- $table = new Table();
- $validator = $table->validator();
- $this->assertSame($table, $validator->provider('table'));
- $this->assertInstanceOf('\Cake\Validation\Validator', $validator);
- $default = $table->validator('default');
- $this->assertSame($validator, $default);
- }
- /**
- * Tests that it is possible to define custom validator methods
- *
- * @return void
- */
- public function functionTestValidationWithDefiner() {
- $table = $this->getMock('\Cake\ORM\Table', ['validationForOtherStuff']);
- $table->expects($this->once())->method('validationForOtherStuff')
- ->will($this->returnArgument(0));
- $other = $table->validator('forOtherStuff');
- $this->assertInstanceOf('\Cake\Validation\Validator', $other);
- $this->assertNotSame($other, $table->validator());
- $this->assertSame($table, $other->provider('table'));
- }
- /**
- * Tests that it is possible to set a custom validator under a name
- *
- * @return void
- */
- public function testValidatorSetter() {
- $table = new Table;
- $validator = new \Cake\Validation\Validator;
- $table->validator('other', $validator);
- $this->assertSame($validator, $table->validator('other'));
- $this->assertSame($table, $validator->provider('table'));
- }
- /**
- * Tests saving with validation
- *
- * @return void
- */
- public function testSaveWithValidationError() {
- $entity = new \Cake\ORM\Entity([
- 'username' => 'superuser'
- ]);
- $table = TableRegistry::get('users');
- $table->validator()->validatePresence('password');
- $this->assertFalse($table->save($entity));
- $this->assertNotEmpty($entity->errors('password'));
- $this->assertSame($entity, $table->validator()->provider('entity'));
- $this->assertSame($table, $table->validator()->provider('table'));
- }
- /**
- * Tests saving with validation and field list
- *
- * @return void
- */
- public function testSaveWithValidationErrorAndFieldList() {
- $entity = new \Cake\ORM\Entity([
- 'username' => 'superuser'
- ]);
- $table = TableRegistry::get('users');
- $table->validator()->validatePresence('password');
- $this->assertFalse($table->save($entity));
- $this->assertNotEmpty($entity->errors('password'));
- }
- /**
- * Tests using a custom validation object when saving
- *
- * @return void
- */
- public function testSaveWithDifferentValidator() {
- $entity = new \Cake\ORM\Entity([
- 'username' => 'superuser'
- ]);
- $table = TableRegistry::get('users');
- $validator = (new Validator)->validatePresence('password');
- $table->validator('custom', $validator);
- $this->assertFalse($table->save($entity, ['validate' => 'custom']));
- $this->assertNotEmpty($entity->errors('password'));
- $this->assertSame($entity, $table->save($entity), 'default was not used');
- }
- /**
- * Tests saving with successful validation
- *
- * @return void
- */
- public function testSaveWithValidationSuccess() {
- $entity = new \Cake\ORM\Entity([
- 'username' => 'superuser',
- 'password' => 'hey'
- ]);
- $table = TableRegistry::get('users');
- $table->validator()->validatePresence('password');
- $this->assertSame($entity, $table->save($entity));
- $this->assertEmpty($entity->errors('password'));
- }
- /**
- * Tests beforeValidate event is triggered
- *
- * @return void
- */
- public function testBeforeValidate() {
- $entity = new \Cake\ORM\Entity([
- 'username' => 'superuser'
- ]);
- $table = TableRegistry::get('users');
- $table->eventManager()->attach(function($ev, $en, $opt, $val) use ($entity) {
- $this->assertSame($entity, $en);
- $this->assertTrue($opt['crazy']);
- $this->assertSame($ev->subject()->validator('default'), $val);
- $val->validatePresence('password');
- }, 'Model.beforeValidate');
- $this->assertFalse($table->save($entity, ['crazy' => true]));
- $this->assertNotEmpty($entity->errors('password'));
- }
- /**
- * Tests that beforeValidate can set the validation result
- *
- * @return void
- */
- public function testBeforeValidateSetResult() {
- $entity = new \Cake\ORM\Entity([
- 'username' => 'superuser'
- ]);
- $table = TableRegistry::get('users');
- $table->eventManager()->attach(function($ev, $en) {
- $en->errors('username', 'Not good');
- return false;
- }, 'Model.beforeValidate');
- $this->assertFalse($table->save($entity));
- $this->assertEquals(['Not good'], $entity->errors('username'));
- }
- /**
- * Tests that afterValidate is triggered and can set a result
- *
- * @return void
- */
- public function testAfterValidate() {
- $entity = new \Cake\ORM\Entity([
- 'username' => 'superuser',
- 'password' => 'hey'
- ]);
- $table = TableRegistry::get('users');
- $table->validator()->validatePresence('password');
- $table->eventManager()->attach(function($ev, $en, $opt, $val) use ($entity) {
- $this->assertSame($entity, $en);
- $this->assertTrue($opt['crazy']);
- $this->assertSame($ev->subject()->validator('default'), $val);
- $en->errors('username', 'Not good');
- return false;
- }, 'Model.afterValidate');
- $this->assertFalse($table->save($entity, ['crazy' => true]));
- $this->assertEmpty($entity->errors('password'));
- $this->assertEquals(['Not good'], $entity->errors('username'));
- }
- /**
- * Tests using a custom validation object when saving and saving associations
- *
- * @return void
- */
- public function testSaveWithDifferentValidatorAndAssociations() {
- $entity = new \Cake\ORM\Entity([
- 'title' => 'foo',
- 'body' => 'bar',
- 'author' => new \Cake\ORM\Entity([
- 'name' => 'Susan'
- ]),
- 'articles_tags' => [
- new \Cake\ORM\Entity([
- 'tag_id' => 100
- ])
- ]
- ]);
- $table = TableRegistry::get('articles');
- $table->belongsTo('authors');
- $table->hasMany('ArticlesTags');
- $validator = (new Validator)->validatePresence('body');
- $table->validator('custom', $validator);
- $validator2 = (new Validator)->validatePresence('thing');
- $table->authors->validator('default', $validator2);
- $this->assertFalse($table->save($entity, ['validate' => 'custom']), 'default was not used');
- $this->assertNotEmpty($entity->author->errors('thing'));
- $table->ArticlesTags->validator('default', $validator2);
- unset($entity->author);
- $this->assertFalse($table->save($entity, ['validate' => 'custom']), 'default was not used');
- $this->assertNotEmpty($entity->articles_tags[0]->errors('thing'));
- }
- /**
- * Test magic findByXX method.
- *
- * @return void
- */
- public function testMagicFindDefaultToAll() {
- $table = TableRegistry::get('Users');
- $result = $table->findByUsername('garrett');
- $this->assertInstanceOf('Cake\ORM\Query', $result);
- $expected = new QueryExpression(['username' => 'garrett'], $this->usersTypeMap);
- $this->assertEquals($expected, $result->clause('where'));
- }
- /**
- * Test magic findByXX errors on missing arguments.
- *
- * @expectedException BadMethodCallException
- * @expectedExceptionMessage Not enough arguments to magic finder. Got 0 required 1
- * @return void
- */
- public function testMagicFindError() {
- $table = TableRegistry::get('Users');
- $table->findByUsername();
- }
- /**
- * Test magic findByXX errors on missing arguments.
- *
- * @expectedException BadMethodCallException
- * @expectedExceptionMessage Not enough arguments to magic finder. Got 1 required 2
- * @return void
- */
- public function testMagicFindErrorMissingField() {
- $table = TableRegistry::get('Users');
- $table->findByUsernameAndId('garrett');
- }
- /**
- * Test magic findByXX errors when there is a mix of or & and.
- *
- * @expectedException BadMethodCallException
- * @expectedExceptionMessage Cannot mix "and" & "or" in a magic finder. Use find() instead.
- * @return void
- */
- public function testMagicFindErrorMixOfOperators() {
- $table = TableRegistry::get('Users');
- $table->findByUsernameAndIdOrPassword('garrett', 1, 'sekret');
- }
- /**
- * Test magic findByXX method.
- *
- * @return void
- */
- public function testMagicFindFirstAnd() {
- $table = TableRegistry::get('Users');
- $result = $table->findByUsernameAndId('garrett', 4);
- $this->assertInstanceOf('Cake\ORM\Query', $result);
- $expected = new QueryExpression(['username' => 'garrett', 'id' => 4], $this->usersTypeMap);
- $this->assertEquals($expected, $result->clause('where'));
- }
- /**
- * Test magic findByXX method.
- *
- * @return void
- */
- public function testMagicFindFirstOr() {
- $table = TableRegistry::get('Users');
- $result = $table->findByUsernameOrId('garrett', 4);
- $this->assertInstanceOf('Cake\ORM\Query', $result);
- $expected = new QueryExpression([], $this->usersTypeMap);
- $expected->add([
- 'OR' => [
- 'username' => 'garrett',
- 'id' => 4
- ]]
- );
- $this->assertEquals($expected, $result->clause('where'));
- }
- /**
- * Test magic findAllByXX method.
- *
- * @return void
- */
- public function testMagicFindAll() {
- $table = TableRegistry::get('Articles');
- $result = $table->findAllByAuthorId(1);
- $this->assertInstanceOf('Cake\ORM\Query', $result);
- $this->assertNull($result->clause('limit'));
- $expected = new QueryExpression(['author_id' => 1], $this->articlesTypeMap);
- $this->assertEquals($expected, $result->clause('where'));
- }
- /**
- * Test magic findAllByXX method.
- *
- * @return void
- */
- public function testMagicFindAllAnd() {
- $table = TableRegistry::get('Users');
- $result = $table->findAllByAuthorIdAndPublished(1, 'Y');
- $this->assertInstanceOf('Cake\ORM\Query', $result);
- $this->assertNull($result->clause('limit'));
- $expected = new QueryExpression(
- ['author_id' => 1, 'published' => 'Y'],
- $this->usersTypeMap
- );
- $this->assertEquals($expected, $result->clause('where'));
- }
- /**
- * Test magic findAllByXX method.
- *
- * @return void
- */
- public function testMagicFindAllOr() {
- $table = TableRegistry::get('Users');
- $result = $table->findAllByAuthorIdOrPublished(1, 'Y');
- $this->assertInstanceOf('Cake\ORM\Query', $result);
- $this->assertNull($result->clause('limit'));
- $expected = new QueryExpression();
- $expected->typeMap()->defaults([
- 'Users.id' => 'integer',
- 'id' => 'integer',
- 'Users.username' => 'string',
- 'username' => 'string',
- 'Users.password' => 'string',
- 'password' => 'string',
- 'Users.created' => 'timestamp',
- 'created' => 'timestamp',
- 'Users.updated' => 'timestamp',
- 'updated' => 'timestamp',
- ]);
- $expected->add(
- ['or' => ['author_id' => 1, 'published' => 'Y']]
- );
- $this->assertEquals($expected, $result->clause('where'));
- $this->assertNull($result->clause('order'));
- }
- /**
- * Test the behavior method.
- *
- * @return void
- */
- public function testBehaviorIntrospection() {
- $table = TableRegistry::get('users');
- $table->addBehavior('Timestamp');
- $this->assertTrue($table->hasBehavior('Timestamp'), 'should be true on loaded behavior');
- $this->assertFalse($table->hasBehavior('Tree'), 'should be false on unloaded behavior');
- }
- /**
- * Tests saving belongsTo association
- *
- * @group save
- * @return void
- */
- public function testSaveBelongsTo() {
- $entity = new \Cake\ORM\Entity([
- 'title' => 'A Title',
- 'body' => 'A body'
- ]);
- $entity->author = new \Cake\ORM\Entity([
- 'name' => 'Jose'
- ]);
- $table = TableRegistry::get('articles');
- $table->belongsTo('authors');
- $this->assertSame($entity, $table->save($entity));
- $this->assertFalse($entity->isNew());
- $this->assertFalse($entity->author->isNew());
- $this->assertEquals(5, $entity->author->id);
- $this->assertEquals(5, $entity->get('author_id'));
- }
- /**
- * Tests saving belongsTo association and get a validation error
- *
- * @group save
- * @return void
- */
- public function testsSaveBelongsToWithValidationError() {
- $entity = new \Cake\ORM\Entity([
- 'title' => 'A Title',
- 'body' => 'A body'
- ]);
- $entity->author = new \Cake\ORM\Entity([
- 'name' => 'Jose'
- ]);
- $table = TableRegistry::get('articles');
- $table->belongsTo('authors');
- $table->association('authors')
- ->target()
- ->validator()
- ->add('name', 'num', ['rule' => 'numeric']);
- $this->assertFalse($table->save($entity));
- $this->assertTrue($entity->isNew());
- $this->assertTrue($entity->author->isNew());
- $this->assertNull($entity->get('author_id'));
- $this->assertNotEmpty($entity->author->errors('name'));
- }
- /**
- * Tests saving hasOne association
- *
- * @group save
- * @return void
- */
- public function testSaveHasOne() {
- $entity = new \Cake\ORM\Entity([
- 'name' => 'Jose'
- ]);
- $entity->article = new \Cake\ORM\Entity([
- 'title' => 'A Title',
- 'body' => 'A body'
- ]);
- $table = TableRegistry::get('authors');
- $table->hasOne('articles');
- $this->assertSame($entity, $table->save($entity));
- $this->assertFalse($entity->isNew());
- $this->assertFalse($entity->article->isNew());
- $this->assertEquals(4, $entity->article->id);
- $this->assertEquals(5, $entity->article->get('author_id'));
- $this->assertFalse($entity->article->dirty('author_id'));
- }
- /**
- * Tests saving associations only saves associations
- * if they are entities.
- *
- * @group save
- * @return void
- */
- public function testSaveOnlySaveAssociatedEntities() {
- $entity = new \Cake\ORM\Entity([
- 'name' => 'Jose'
- ]);
- // Not an entity.
- $entity->article = [
- 'title' => 'A Title',
- 'body' => 'A body'
- ];
- $table = TableRegistry::get('authors');
- $table->hasOne('articles');
- $this->assertSame($entity, $table->save($entity));
- $this->assertFalse($entity->isNew());
- $this->assertInternalType('array', $entity->article);
- }
- /**
- * Tests saving hasOne association and returning a validation error will
- * abort the saving process
- *
- * @group save
- * @return void
- */
- public function testSaveHasOneWithValidationError() {
- $entity = new \Cake\ORM\Entity([
- 'name' => 'Jose'
- ]);
- $entity->article = new \Cake\ORM\Entity([
- 'title' => 'A Title',
- 'body' => 'A body'
- ]);
- $table = TableRegistry::get('authors');
- $table->hasOne('articles');
- $table->association('articles')
- ->target()
- ->validator()
- ->add('title', 'num', ['rule' => 'numeric']);
- $this->assertFalse($table->save($entity));
- $this->assertTrue($entity->isNew());
- $this->assertTrue($entity->article->isNew());
- $this->assertNull($entity->article->id);
- $this->assertNull($entity->article->get('author_id'));
- $this->assertFalse($entity->article->dirty('author_id'));
- $this->assertNotEmpty($entity->article->errors('title'));
- }
- /**
- * Tests saving multiple entities in a hasMany association
- *
- * @return void
- */
- public function testSaveHasMany() {
- $entity = new \Cake\ORM\Entity([
- 'name' => 'Jose'
- ]);
- $entity->articles = [
- new \Cake\ORM\Entity([
- 'title' => 'A Title',
- 'body' => 'A body'
- ]),
- new \Cake\ORM\Entity([
- 'title' => 'Another Title',
- 'body' => 'Another body'
- ])
- ];
- $table = TableRegistry::get('authors');
- $table->hasMany('articles');
- $this->assertSame($entity, $table->save($entity));
- $this->assertFalse($entity->isNew());
- $this->assertFalse($entity->articles[0]->isNew());
- $this->assertFalse($entity->articles[1]->isNew());
- $this->assertEquals(4, $entity->articles[0]->id);
- $this->assertEquals(5, $entity->articles[1]->id);
- $this->assertEquals(5, $entity->articles[0]->author_id);
- $this->assertEquals(5, $entity->articles[1]->author_id);
- }
- /**
- * Tests saving multiple entities in a hasMany association and getting and
- * error while saving one of them. It should abort all the save operation
- * when options are set to defaults
- *
- * @return void
- */
- public function testSaveHasManyWithErrorsAtomic() {
- $entity = new \Cake\ORM\Entity([
- 'name' => 'Jose'
- ]);
- $entity->articles = [
- new \Cake\ORM\Entity([
- 'title' => '1',
- 'body' => 'A body'
- ]),
- new \Cake\ORM\Entity([
- 'title' => 'Another Title',
- 'body' => 'Another body'
- ])
- ];
- $table = TableRegistry::get('authors');
- $table->hasMany('articles');
- $table->association('articles')
- ->target()
- ->validator()
- ->add('title', 'num', ['rule' => 'numeric']);
- $this->assertFalse($table->save($entity));
- $this->assertTrue($entity->isNew());
- $this->assertTrue($entity->articles[0]->isNew());
- $this->assertTrue($entity->articles[1]->isNew());
- $this->assertNull($entity->articles[0]->id);
- $this->assertNull($entity->articles[1]->id);
- $this->assertNull($entity->articles[0]->author_id);
- $this->assertNull($entity->articles[1]->author_id);
- $this->assertEmpty($entity->articles[0]->errors());
- $this->assertNotEmpty($entity->articles[1]->errors());
- }
- /**
- * Tests that it is possible to continue saving hasMany associations
- * even if any of the records fail validation when atomic is set
- * to false
- *
- * @return void
- */
- public function testSaveHasManyWithErrorsNonAtomic() {
- $entity = new \Cake\ORM\Entity([
- 'name' => 'Jose'
- ]);
- $entity->articles = [
- new \Cake\ORM\Entity([
- 'title' => 'A title',
- 'body' => 'A body'
- ]),
- new \Cake\ORM\Entity([
- 'title' => '1',
- 'body' => 'Another body'
- ])
- ];
- $table = TableRegistry::get('authors');
- $table->hasMany('articles');
- $table->association('articles')
- ->target()
- ->validator()
- ->add('title', 'num', ['rule' => 'numeric']);
- $this->assertSame($entity, $table->save($entity, ['atomic' => false]));
- $this->assertFalse($entity->isNew());
- $this->assertTrue($entity->articles[0]->isNew());
- $this->assertFalse($entity->articles[1]->isNew());
- $this->assertEquals(4, $entity->articles[1]->id);
- $this->assertNull($entity->articles[0]->id);
- $this->assertEquals(5, $entity->articles[0]->author_id);
- $this->assertEquals(5, $entity->articles[1]->author_id);
- }
- /**
- * Tests saving hasOne association and returning a validation error will
- * not abort the saving process if atomic is set to false
- *
- * @group save
- * @return void
- */
- public function testSaveHasOneWithValidationErrorNonAtomic() {
- $entity = new \Cake\ORM\Entity([
- 'name' => 'Jose'
- ]);
- $entity->article = new \Cake\ORM\Entity([
- 'title' => 'A Title',
- 'body' => 'A body'
- ]);
- $table = TableRegistry::get('authors');
- $table->hasOne('articles');
- $table->association('articles')
- ->target()
- ->validator()
- ->add('title', 'num', ['rule' => 'numeric']);
- $this->assertSame($entity, $table->save($entity, ['atomic' => false]));
- $this->assertFalse($entity->isNew());
- $this->assertTrue($entity->article->isNew());
- $this->assertNull($entity->article->id);
- $this->assertNull($entity->article->get('author_id'));
- $this->assertFalse($entity->article->dirty('author_id'));
- $this->assertNotEmpty($entity->article->errors('title'));
- }
- /**
- * Tests saving belongsTo association and get a validation error won't stop
- * saving if atomic is set to false
- *
- * @group save
- * @return void
- */
- public function testSaveBelongsToWithValidationErrorNotAtomic() {
- $entity = new \Cake\ORM\Entity([
- 'title' => 'A Title',
- 'body' => 'A body'
- ]);
- $entity->author = new \Cake\ORM\Entity([
- 'name' => 'Jose'
- ]);
- $table = TableRegistry::get('articles');
- $table->belongsTo('authors');
- $table->association('authors')
- ->target()
- ->validator()
- ->add('name', 'num', ['rule' => 'numeric']);
- $this->assertSame($entity, $table->save($entity, ['atomic' => false]));
- $this->assertFalse($entity->isNew());
- $this->assertTrue($entity->author->isNew());
- $this->assertNull($entity->get('author_id'));
- $this->assertNotEmpty($entity->author->errors('name'));
- }
- /**
- * Tests saving belongsToMany records
- *
- * @group save
- * @return void
- */
- public function testSaveBelongsToMany() {
- $entity = new \Cake\ORM\Entity([
- 'title' => 'A Title',
- 'body' => 'A body'
- ]);
- $entity->tags = [
- new \Cake\ORM\Entity([
- 'name' => 'Something New'
- ]),
- new \Cake\ORM\Entity([
- 'name' => 'Another Something'
- ])
- ];
- $table = TableRegistry::get('articles');
- $table->belongsToMany('tags');
- $this->assertSame($entity, $table->save($entity));
- $this->assertFalse($entity->isNew());
- $this->assertFalse($entity->tags[0]->isNew());
- $this->assertFalse($entity->tags[1]->isNew());
- $this->assertEquals(4, $entity->tags[0]->id);
- $this->assertEquals(5, $entity->tags[1]->id);
- $this->assertEquals(4, $entity->tags[0]->_joinData->article_id);
- $this->assertEquals(4, $entity->tags[1]->_joinData->article_id);
- $this->assertEquals(4, $entity->tags[0]->_joinData->tag_id);
- $this->assertEquals(5, $entity->tags[1]->_joinData->tag_id);
- }
- /**
- * Tests saving belongsToMany records can delete all links.
- *
- * @group save
- * @return void
- */
- public function testSaveBelongsToManyDeleteAllLinks() {
- $table = TableRegistry::get('articles');
- $table->belongsToMany('tags', [
- 'saveStrategy' => 'replace',
- ]);
- $entity = $table->get(1, ['contain' => 'Tags']);
- $this->assertCount(2, $entity->tags, 'Fixture data did not change.');
- $entity->tags = [];
- $result = $table->save($entity);
- $this->assertSame($result, $entity);
- $this->assertSame([], $entity->tags, 'No tags on the entity.');
- $entity = $table->get(1, ['contain' => 'Tags']);
- $this->assertSame([], $entity->tags, 'No tags in the db either.');
- }
- /**
- * Tests saving belongsToMany records can delete some links.
- *
- * @group save
- * @return void
- */
- public function testSaveBelongsToManyDeleteSomeLinks() {
- $table = TableRegistry::get('articles');
- $table->belongsToMany('tags', [
- 'saveStrategy' => 'replace',
- ]);
- $entity = $table->get(1, ['contain' => 'Tags']);
- $this->assertCount(2, $entity->tags, 'Fixture data did not change.');
- $tag = new \Cake\ORM\Entity([
- 'id' => 2,
- ]);
- $entity->tags = [$tag];
- $result = $table->save($entity);
- $this->assertSame($result, $entity);
- $this->assertCount(1, $entity->tags, 'Only one tag left.');
- $this->assertEquals($tag, $entity->tags[0]);
- $entity = $table->get(1, ['contain' => 'Tags']);
- $this->assertCount(1, $entity->tags, 'Only one tag in the db.');
- $this->assertEquals($tag->id, $entity->tags[0]->id);
- }
- /**
- * Tests saving belongsToMany records with a validation error and atomic set
- * to true
- *
- * @group save
- * @return void
- */
- public function testSaveBelongsToWithValidationErrorAtomic() {
- $entity = new \Cake\ORM\Entity([
- 'title' => 'A Title',
- 'body' => 'A body'
- ]);
- $entity->tags = [
- new \Cake\ORM\Entity([
- 'name' => '100'
- ]),
- new \Cake\ORM\Entity([
- 'name' => 'Something New'
- ])
- ];
- $table = TableRegistry::get('articles');
- $table->belongsToMany('tags');
- $tags = $table->association('tags')
- ->target()
- ->validator()
- ->add('name', 'num', ['rule' => 'numeric']);
- $this->assertFalse($table->save($entity));
- $this->assertTrue($entity->isNew());
- $this->assertTrue($entity->tags[0]->isNew());
- $this->assertTrue($entity->tags[1]->isNew());
- $this->assertNull($entity->tags[0]->id);
- $this->assertNull($entity->tags[1]->id);
- $this->assertNull($entity->tags[0]->_joinData);
- $this->assertNull($entity->tags[1]->_joinData);
- $this->assertEmpty($entity->tags[0]->errors('name'));
- $this->assertNotEmpty($entity->tags[1]->errors('name'));
- }
- /**
- * Tests saving belongsToMany records with a validation error and atomic set
- * to false
- *
- * @group save
- * @return void
- */
- public function testSaveBelongsToWithValidationErrorNonAtomic() {
- $entity = new \Cake\ORM\Entity([
- 'title' => 'A Title',
- 'body' => 'A body'
- ]);
- $entity->tags = [
- new \Cake\ORM\Entity([
- 'name' => 'Something New'
- ]),
- new \Cake\ORM\Entity([
- 'name' => '100'
- ])
- ];
- $table = TableRegistry::get('articles');
- $table->belongsToMany('tags');
- $tags = $table->association('tags')
- ->target()
- ->validator()
- ->add('name', 'num', ['rule' => 'numeric']);
- $this->assertSame($entity, $table->save($entity, ['atomic' => false]));
- $this->assertFalse($entity->isNew());
- $this->assertTrue($entity->tags[0]->isNew());
- $this->assertFalse($entity->tags[1]->isNew());
- $this->assertNull($entity->tags[0]->id);
- $this->assertEquals(4, $entity->tags[1]->id);
- $this->assertNull($entity->tags[0]->_joinData);
- $this->assertEquals(4, $entity->tags[1]->_joinData->article_id);
- $this->assertEquals(4, $entity->tags[1]->_joinData->tag_id);
- }
- /**
- * Tests saving belongsToMany records with a validation error in a joint entity
- *
- * @group save
- * @return void
- */
- public function testSaveBelongsToWithValidationErrorInJointEntity() {
- $entity = new \Cake\ORM\Entity([
- 'title' => 'A Title',
- 'body' => 'A body'
- ]);
- $entity->tags = [
- new \Cake\ORM\Entity([
- 'name' => 'Something New'
- ]),
- new \Cake\ORM\Entity([
- 'name' => '100'
- ])
- ];
- $table = TableRegistry::get('articles');
- $table->belongsToMany('tags');
- $table->association('tags')
- ->junction()
- ->validator()
- ->add('article_id', 'num', ['rule' => ['comparison', '>', 4]]);
- $this->assertFalse($table->save($entity));
- $this->assertTrue($entity->isNew());
- $this->assertTrue($entity->tags[0]->isNew());
- $this->assertTrue($entity->tags[1]->isNew());
- $this->assertNull($entity->tags[0]->id);
- $this->assertNull($entity->tags[1]->id);
- $this->assertNull($entity->tags[0]->_joinData);
- $this->assertNull($entity->tags[1]->_joinData);
- }
- /**
- * Tests saving belongsToMany records with a validation error in a joint entity
- * and atomic set to false
- *
- * @group save
- * @return void
- */
- public function testSaveBelongsToWithValidationErrorInJointEntityNonAtomic() {
- $entity = new \Cake\ORM\Entity([
- 'title' => 'A Title',
- 'body' => 'A body'
- ]);
- $entity->tags = [
- new \Cake\ORM\Entity([
- 'name' => 'Something New'
- ]),
- new \Cake\ORM\Entity([
- 'name' => 'New one'
- ])
- ];
- $table = TableRegistry::get('articles');
- $table->belongsToMany('tags');
- $table->association('tags')
- ->junction()
- ->validator()
- ->add('tag_id', 'num', ['rule' => ['comparison', '>', 4]]);
- $this->assertSame($entity, $table->save($entity, ['atomic' => false]));
- $this->assertFalse($entity->isNew());
- $this->assertFalse($entity->tags[0]->isNew());
- $this->assertFalse($entity->tags[1]->isNew());
- $this->assertEquals(4, $entity->tags[0]->id);
- $this->assertEquals(5, $entity->tags[1]->id);
- $this->assertTrue($entity->tags[0]->_joinData->isNew());
- $this->assertNotEmpty($entity->tags[0]->_joinData->errors());
- $this->assertEquals(4, $entity->tags[1]->_joinData->article_id);
- $this->assertEquals(5, $entity->tags[1]->_joinData->tag_id);
- }
- /**
- * Tests that saving a persisted and clean entity will is a no-op
- *
- * @group save
- * @return void
- */
- public function testSaveCleanEntity() {
- $table = $this->getMock('\Cake\ORM\Table', ['_processSave']);
- $entity = new \Cake\ORM\Entity(
- ['id' => 'foo'],
- ['markNew' => false, 'markClean' => true]
- );
- $table->expects($this->never())->method('_processSave');
- $this->assertSame($entity, $table->save($entity));
- }
- /**
- * Integration test to show how to append a new tag to an article
- *
- * @group save
- * @return void
- */
- public function testBelongsToManyIntegration() {
- $table = TableRegistry::get('articles');
- $table->belongsToMany('tags');
- $article = $table->find('all')->where(['id' => 1])->contain(['tags'])->first();
- $tags = $article->tags;
- $this->assertNotEmpty($tags);
- $tags[] = new \TestApp\Model\Entity\Tag(['name' => 'Something New']);
- $article->tags = $tags;
- $this->assertSame($article, $table->save($article));
- $tags = $article->tags;
- $this->assertCount(3, $tags);
- $this->assertFalse($tags[2]->isNew());
- $this->assertEquals(4, $tags[2]->id);
- $this->assertEquals(1, $tags[2]->_joinData->article_id);
- $this->assertEquals(4, $tags[2]->_joinData->tag_id);
- $article = $table->find('all')->where(['id' => 1])->contain(['tags'])->first();
- $this->assertEquals($tags, $article->tags);
- }
- /**
- * Tests that it is possible to do a deep save and control what associations get saved,
- * while having control of the options passed to each level of the save
- *
- * @group save
- * @return void
- */
- public function testSaveDeepAssociationOptions() {
- $articles = $this->getMock(
- '\Cake\ORM\Table',
- ['_insert'],
- [['table' => 'articles', 'connection' => $this->connection]]
- );
- $authors = $this->getMock(
- '\Cake\ORM\Table',
- ['_insert', 'validate'],
- [['table' => 'authors', 'connection' => $this->connection]]
- );
- $supervisors = $this->getMock(
- '\Cake\ORM\Table',
- ['_insert', 'validate'],
- [[
- 'table' => 'authors',
- 'alias' => 'supervisors',
- 'connection' => $this->connection
- ]]
- );
- $tags = $this->getMock(
- '\Cake\ORM\Table',
- ['_insert'],
- [['table' => 'tags', 'connection' => $this->connection]]
- );
- $articles->belongsTo('authors', ['targetTable' => $authors]);
- $authors->hasOne('supervisors', ['targetTable' => $supervisors]);
- $supervisors->belongsToMany('tags', ['targetTable' => $tags]);
- $entity = new \Cake\ORM\Entity([
- 'title' => 'bar',
- 'author' => new \Cake\ORM\Entity([
- 'name' => 'Juan',
- 'supervisor' => new \Cake\ORM\Entity(['name' => 'Marc']),
- 'tags' => [
- new \Cake\ORM\Entity(['name' => 'foo'])
- ]
- ]),
- ]);
- $entity->isNew(true);
- $entity->author->isNew(true);
- $entity->author->supervisor->isNew(true);
- $entity->author->tags[0]->isNew(true);
- $articles->expects($this->once())
- ->method('_insert')
- ->with($entity, ['title' => 'bar'])
- ->will($this->returnValue($entity));
- $authors->expects($this->once())
- ->method('_insert')
- ->with($entity->author, ['name' => 'Juan'])
- ->will($this->returnValue($entity->author));
- $authors->expects($this->once())
- ->method('validate')
- ->with($entity->author)
- ->will($this->returnValue(true));
- $supervisors->expects($this->once())
- ->method('_insert')
- ->with($entity->author->supervisor, ['name' => 'Marc'])
- ->will($this->returnValue($entity->author->supervisor));
- $supervisors->expects($this->never())->method('validate');
- $tags->expects($this->never())->method('_insert');
- $this->assertSame($entity, $articles->save($entity, [
- 'associated' => [
- 'authors' => [
- 'validate' => 'special'
- ],
- 'authors.supervisors' => [
- 'atomic' => false,
- 'validate' => false,
- 'associated' => false
- ]
- ]
- ]));
- }
- /**
- * Integration test for linking entities with belongsToMany
- *
- * @return void
- */
- public function testLinkBelongsToMany() {
- $table = TableRegistry::get('articles');
- $table->belongsToMany('tags');
- $tagsTable = TableRegistry::get('tags');
- $source = ['source' => 'tags'];
- $options = ['markNew' => false];
- $article = new \Cake\ORM\Entity([
- 'id' => 1,
- ], $options);
- $newTag = new \TestApp\Model\Entity\Tag([
- 'name' => 'Foo'
- ], $source);
- $tags[] = new \TestApp\Model\Entity\Tag([
- 'id' => 3
- ], $options + $source);
- $tags[] = $newTag;
- $tagsTable->save($newTag);
- $table->association('tags')->link($article, $tags);
- $this->assertEquals($article->tags, $tags);
- foreach ($tags as $tag) {
- $this->assertFalse($tag->isNew());
- }
- $article = $table->find('all')->where(['id' => 1])->contain(['tags'])->first();
- $this->assertEquals($article->tags[2]->id, $tags[0]->id);
- $this->assertEquals($article->tags[3], $tags[1]);
- }
- /**
- * Integration test to show how to unlink a single record from a belongsToMany
- *
- * @return void
- */
- public function testUnlinkBelongsToMany() {
- $table = TableRegistry::get('articles');
- $table->belongsToMany('tags');
- $tagsTable = TableRegistry::get('tags');
- $options = ['markNew' => false];
- $article = $table->find('all')
- ->where(['id' => 1])
- ->contain(['tags'])->first();
- $table->association('tags')->unlink($article, [$article->tags[0]]);
- $this->assertCount(1, $article->tags);
- $this->assertEquals(2, $article->tags[0]->get('id'));
- $this->assertFalse($article->dirty('tags'));
- }
- /**
- * Integration test to show how to unlink multiple records from a belongsToMany
- *
- * @return void
- */
- public function testUnlinkBelongsToManyMultiple() {
- $table = TableRegistry::get('articles');
- $table->belongsToMany('tags');
- $tagsTable = TableRegistry::get('tags');
- $options = ['markNew' => false];
- $article = new \Cake\ORM\Entity(['id' => 1], $options);
- $tags[] = new \TestApp\Model\Entity\Tag(['id' => 1], $options);
- $tags[] = new \TestApp\Model\Entity\Tag(['id' => 2], $options);
- $table->association('tags')->unlink($article, $tags);
- $left = $table->find('all')->where(['id' => 1])->contain(['tags'])->first();
- $this->assertEmpty($left->tags);
- }
- /**
- * Integration test to show how to unlink multiple records from a belongsToMany
- * providing some of the joint
- *
- * @return void
- */
- public function testUnlinkBelongsToManyPassingJoint() {
- $table = TableRegistry::get('articles');
- $table->belongsToMany('tags');
- $tagsTable = TableRegistry::get('tags');
- $options = ['markNew' => false];
- $article = new \Cake\ORM\Entity(['id' => 1], $options);
- $tags[] = new \TestApp\Model\Entity\Tag(['id' => 1], $options);
- $tags[] = new \TestApp\Model\Entity\Tag(['id' => 2], $options);
- $tags[1]->_joinData = new \Cake\ORM\Entity([
- 'article_id' => 1,
- 'tag_id' => 2
- ], $options);
- $table->association('tags')->unlink($article, $tags);
- $left = $table->find('all')->where(['id' => 1])->contain(['tags'])->first();
- $this->assertEmpty($left->tags);
- }
- /**
- * Integration test to show how to replace records from a belongsToMany
- *
- * @return void
- */
- public function testReplacelinksBelongsToMany() {
- $table = TableRegistry::get('articles');
- $table->belongsToMany('tags');
- $tagsTable = TableRegistry::get('tags');
- $options = ['markNew' => false];
- $article = new \Cake\ORM\Entity(['id' => 1], $options);
- $tags[] = new \TestApp\Model\Entity\Tag(['id' => 2], $options);
- $tags[] = new \TestApp\Model\Entity\Tag(['id' => 3], $options);
- $tags[] = new \TestApp\Model\Entity\Tag(['name' => 'foo']);
- $table->association('tags')->replaceLinks($article, $tags);
- $this->assertEquals(2, $article->tags[0]->id);
- $this->assertEquals(3, $article->tags[1]->id);
- $this->assertEquals(4, $article->tags[2]->id);
- $article = $table->find('all')->where(['id' => 1])->contain(['tags'])->first();
- $this->assertCount(3, $article->tags);
- $this->assertEquals(2, $article->tags[0]->id);
- $this->assertEquals(3, $article->tags[1]->id);
- $this->assertEquals(4, $article->tags[2]->id);
- $this->assertEquals('foo', $article->tags[2]->name);
- }
- /**
- * Integration test to show how remove all links from a belongsToMany
- *
- * @return void
- */
- public function testReplacelinksBelongsToManyWithEmpty() {
- $table = TableRegistry::get('articles');
- $table->belongsToMany('tags');
- $tagsTable = TableRegistry::get('tags');
- $options = ['markNew' => false];
- $article = new \Cake\ORM\Entity(['id' => 1], $options);
- $tags = [];
- $table->association('tags')->replaceLinks($article, $tags);
- $this->assertSame($tags, $article->tags);
- $article = $table->find('all')->where(['id' => 1])->contain(['tags'])->first();
- $this->assertEmpty($article->tags);
- }
- /**
- * Integration test to show how to replace records from a belongsToMany
- * passing the joint property along in the target entity
- *
- * @return void
- */
- public function testReplacelinksBelongsToManyWithJoint() {
- $table = TableRegistry::get('articles');
- $table->belongsToMany('tags');
- $tagsTable = TableRegistry::get('tags');
- $options = ['markNew' => false];
- $article = new \Cake\ORM\Entity(['id' => 1], $options);
- $tags[] = new \TestApp\Model\Entity\Tag([
- 'id' => 2,
- '_joinData' => new \Cake\ORM\Entity([
- 'article_id' => 1,
- 'tag_id' => 2,
- ])
- ], $options);
- $tags[] = new \TestApp\Model\Entity\Tag(['id' => 3], $options);
- $table->association('tags')->replaceLinks($article, $tags);
- $this->assertSame($tags, $article->tags);
- $article = $table->find('all')->where(['id' => 1])->contain(['tags'])->first();
- $this->assertCount(2, $article->tags);
- $this->assertEquals(2, $article->tags[0]->id);
- $this->assertEquals(3, $article->tags[1]->id);
- }
- /**
- * Tests that it is possible to call find with no arguments
- *
- * @return void
- */
- public function testSimplifiedFind() {
- $table = $this->getMock(
- '\Cake\ORM\Table',
- ['callFinder'],
- [[
- 'connection' => $this->connection,
- 'schema' => ['id' => ['type' => 'integer']]
- ]]
- );
- $query = (new \Cake\ORM\Query($this->connection, $table))->select();
- $table->expects($this->once())->method('callFinder')
- ->with('all', $query, []);
- $table->find();
- }
- /**
- * Test that get() will use the primary key for searching and return the first
- * entity found
- *
- * @return void
- */
- public function testGet() {
- $table = $this->getMock(
- '\Cake\ORM\Table',
- ['callFinder', 'query'],
- [[
- 'connection' => $this->connection,
- 'schema' => [
- 'id' => ['type' => 'integer'],
- 'bar' => ['type' => 'integer'],
- '_constraints' => ['primary' => ['type' => 'primary', 'columns' => ['bar']]]
- ]
- ]]
- );
- $query = $this->getMock(
- '\Cake\ORM\Query',
- ['addDefaultTypes', 'first', 'where'],
- [$this->connection, $table]
- );
- $entity = new \Cake\ORM\Entity;
- $table->expects($this->once())->method('query')
- ->will($this->returnValue($query));
- $table->expects($this->once())->method('callFinder')
- ->with('all', $query, ['fields' => ['id']])
- ->will($this->returnValue($query));
- $query->expects($this->once())->method('where')
- ->with([$table->alias() . '.bar' => 10])
- ->will($this->returnSelf());
- $query->expects($this->once())->method('first')
- ->will($this->returnValue($entity));
- $result = $table->get(10, ['fields' => ['id']]);
- $this->assertSame($entity, $result);
- }
- /**
- * Tests that get() will throw an exception if the record was not found
- *
- * @expectedException \Cake\ORM\Exception\RecordNotFoundException
- * @expectedExceptionMessage Record "10" not found in table "articles"
- * @return void
- */
- public function testGetNotFoundException() {
- $table = new Table([
- 'name' => 'Articles',
- 'connection' => $this->connection,
- 'table' => 'articles',
- ]);
- $table->get(10);
- }
- /**
- * Test that an exception is raised when there are not enough keys.
- *
- * @expectedException \InvalidArgumentException
- * @expectedExceptionMessage Incorrect number of primary key values. Expected 1 got 0.
- * @return void
- */
- public function testGetExceptionOnIncorrectData() {
- $table = new Table([
- 'name' => 'Articles',
- 'connection' => $this->connection,
- 'table' => 'articles',
- ]);
- $table->get(null);
- }
- /**
- * Tests entityValidator
- *
- * @return void
- */
- public function testEntityValidator() {
- $table = new Table;
- $expected = new \Cake\ORM\EntityValidator($table);
- $table->entityValidator();
- $this->assertEquals($expected, $table->entityValidator());
- }
- /**
- * Tests that validate will call the entity validator with the correct
- * options
- *
- * @return void
- */
- public function testValidateDefaultAssociations() {
- $table = $this->getMock('\Cake\ORM\Table', ['entityValidator']);
- $table->belongsTo('users');
- $table->hasMany('articles');
- $table->schema([]);
- $entityValidator = $this->getMock('\Cake\ORM\EntityValidator', [], [$table]);
- $entity = $table->newEntity([]);
- $table->expects($this->once())->method('entityValidator')
- ->will($this->returnValue($entityValidator));
- $entityValidator->expects($this->once())->method('one')
- ->with($entity, ['associated' => ['users', 'articles']])
- ->will($this->returnValue(true));
- $this->assertTrue($table->validate($entity));
- }
- /**
- * Tests that validate will call the entity validator with the correct
- * options
- *
- * @return void
- */
- public function testValidateWithCustomOptions() {
- $table = $this->getMock('\Cake\ORM\Table', ['entityValidator']);
- $table->schema([]);
- $entityValidator = $this->getMock('\Cake\ORM\EntityValidator', [], [$table]);
- $entity = $table->newEntity([]);
- $options = ['associated' => ['users'], 'validate' => 'foo'];
- $table->expects($this->once())->method('entityValidator')
- ->will($this->returnValue($entityValidator));
- $entityValidator->expects($this->once())->method('one')
- ->with($entity, $options)
- ->will($this->returnValue(false));
- $this->assertFalse($table->validate($entity, $options));
- }
- /**
- * Tests that validateMany will call the entity validator with the correct
- * options
- *
- * @return void
- */
- public function testValidateManyDefaultAssociation() {
- $table = $this->getMock('\Cake\ORM\Table', ['entityValidator']);
- $table->belongsTo('users');
- $table->hasMany('articles');
- $table->schema([]);
- $entityValidator = $this->getMock('\Cake\ORM\EntityValidator', [], [$table]);
- $entities = ['a', 'b'];
- $table->expects($this->once())->method('entityValidator')
- ->will($this->returnValue($entityValidator));
- $entityValidator->expects($this->once())->method('many')
- ->with($entities, ['associated' => ['users', 'articles']])
- ->will($this->returnValue(true));
- $this->assertTrue($table->validateMany($entities));
- }
- /**
- * Tests that validateMany will call the entity validator with the correct
- * options
- *
- * @return void
- */
- public function testValidateManyWithCustomOptions() {
- $table = $this->getMock('\Cake\ORM\Table', ['entityValidator']);
- $table->schema([]);
- $entityValidator = $this->getMock('\Cake\ORM\EntityValidator', [], [$table]);
- $entities = ['a', 'b', 'c'];
- $options = ['associated' => ['users'], 'validate' => 'foo'];
- $table->expects($this->once())->method('entityValidator')
- ->will($this->returnValue($entityValidator));
- $entityValidator->expects($this->once())->method('many')
- ->with($entities, $options)
- ->will($this->returnValue(false));
- $this->assertFalse($table->validateMany($entities, $options));
- }
- /**
- * Tests that patchEntity delegates the task to the marshaller and passed
- * all associations
- *
- * @return void
- */
- public function testPatchEntity() {
- $table = $this->getMock('Cake\ORM\Table', ['marshaller']);
- $marshaller = $this->getMock('Cake\ORM\Marshaller', [], [$table]);
- $table->belongsTo('users');
- $table->hasMany('articles');
- $table->expects($this->once())->method('marshaller')
- ->will($this->returnValue($marshaller));
- $entity = new \Cake\ORM\Entity;
- $data = ['foo' => 'bar'];
- $marshaller->expects($this->once())
- ->method('merge')
- ->with($entity, $data, ['associated' => ['users', 'articles']])
- ->will($this->returnValue($entity));
- $table->patchEntity($entity, $data);
- }
- /**
- * Tests that patchEntities delegates the task to the marshaller and passed
- * all associations
- *
- * @return void
- */
- public function testPatchEntities() {
- $table = $this->getMock('Cake\ORM\Table', ['marshaller']);
- $marshaller = $this->getMock('Cake\ORM\Marshaller', [], [$table]);
- $table->belongsTo('users');
- $table->hasMany('articles');
- $table->expects($this->once())->method('marshaller')
- ->will($this->returnValue($marshaller));
- $entities = [new \Cake\ORM\Entity];
- $data = [['foo' => 'bar']];
- $marshaller->expects($this->once())
- ->method('mergeMany')
- ->with($entities, $data, ['associated' => ['users', 'articles']])
- ->will($this->returnValue($entities));
- $table->patchEntities($entities, $data);
- }
- /**
- * Tests __debugInfo
- *
- * @return void
- */
- public function testDebugInfo() {
- $articles = TableRegistry::get('articles');
- $articles->addBehavior('Timestamp');
- $result = $articles->__debugInfo();
- $expected = [
- 'table' => 'articles',
- 'alias' => 'articles',
- 'entityClass' => 'TestApp\Model\Entity\Article',
- 'associations' => ['authors', 'tags', 'articlestags'],
- 'behaviors' => ['Timestamp'],
- 'defaultConnection' => 'default',
- 'connectionName' => 'test'
- ];
- $this->assertEquals($expected, $result);
- }
- }
|