SchemaTest.php 4.05 KB
Newer Older
1 2
<?php

3
class SchemaTest extends TestCase {
4 5 6 7 8 9 10 11 12 13

	public function tearDown()
	{
		Schema::drop('newcollection');
	}

	public function testCreate()
	{
		Schema::create('newcollection');
		$this->assertTrue(Schema::hasCollection('newcollection'));
Jens Segers's avatar
Jens Segers committed
14
		$this->assertTrue(Schema::hasTable('newcollection'));
15 16 17 18 19 20 21 22 23
	}

	public function testDrop()
	{
		Schema::create('newcollection');
		Schema::drop('newcollection');
		$this->assertFalse(Schema::hasCollection('newcollection'));
	}

Jens Segers's avatar
Jens Segers committed
24 25 26 27 28 29 30 31 32 33 34 35 36 37 38
	public function testBluePrint()
	{
		$instance = $this;

		Schema::collection('newcollection', function($collection) use ($instance)
		{
			$instance->assertInstanceOf('Jenssegers\Mongodb\Schema\Blueprint', $collection);
		});

		Schema::table('newcollection', function($collection) use ($instance)
		{
			$instance->assertInstanceOf('Jenssegers\Mongodb\Schema\Blueprint', $collection);
		});
	}

39 40 41 42 43 44 45 46
	public function testIndex()
	{
		Schema::collection('newcollection', function($collection)
		{
			$collection->index('mykey');
		});

		$index = $this->getIndex('newcollection', 'mykey');
47
		$this->assertEquals(1, $index['key']['mykey']);
Jens Segers's avatar
Jens Segers committed
48 49 50 51 52 53 54 55

		Schema::collection('newcollection', function($collection)
		{
			$collection->index(array('mykey'));
		});

		$index = $this->getIndex('newcollection', 'mykey');
		$this->assertEquals(1, $index['key']['mykey']);
56 57 58 59 60 61 62 63 64 65
	}

	public function testUnique()
	{
		Schema::collection('newcollection', function($collection)
		{
			$collection->unique('uniquekey');
		});

		$index = $this->getIndex('newcollection', 'uniquekey');
66 67 68 69 70 71 72 73 74 75 76 77 78
		$this->assertEquals(1, $index['unique']);
	}

	public function testDropIndex()
	{
		Schema::collection('newcollection', function($collection)
		{
			$collection->unique('uniquekey');
			$collection->dropIndex('uniquekey');
		});

		$index = $this->getIndex('newcollection', 'uniquekey');
		$this->assertEquals(null, $index);
Jens Segers's avatar
Jens Segers committed
79 80 81 82 83 84 85 86 87

		Schema::collection('newcollection', function($collection)
		{
			$collection->unique('uniquekey');
			$collection->dropIndex(array('uniquekey'));
		});

		$index = $this->getIndex('newcollection', 'uniquekey');
		$this->assertEquals(null, $index);
88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120
	}

	public function testBackground()
	{
		Schema::collection('newcollection', function($collection)
		{
			$collection->background('backgroundkey');
		});

		$index = $this->getIndex('newcollection', 'backgroundkey');
		$this->assertEquals(1, $index['background']);
	}

	public function testSparse()
	{
		Schema::collection('newcollection', function($collection)
		{
			$collection->background('backgroundkey');
		});

		$index = $this->getIndex('newcollection', 'backgroundkey');
		$this->assertEquals(1, $index['background']);
	}

	public function testExpire()
	{
		Schema::collection('newcollection', function($collection)
		{
			$collection->expire('expirekey', 60);
		});

		$index = $this->getIndex('newcollection', 'expirekey');
		$this->assertEquals(60, $index['expireAfterSeconds']);
121 122
	}

123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138
	public function testSoftDeletes()
	{
		Schema::collection('newcollection', function($collection)
		{
			$collection->softDeletes();
		});

		Schema::collection('newcollection', function($collection)
		{
			$collection->string('email')->nullable()->index();
		});

		$index = $this->getIndex('newcollection', 'email');
		$this->assertEquals(1, $index['key']['email']);
	}

139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154
	public function testFluent()
	{
		Schema::collection('newcollection', function($collection)
		{
			$collection->string('email')->index();
			$collection->string('token')->index();
			$collection->timestamp('created_at');
		});

		$index = $this->getIndex('newcollection', 'email');
		$this->assertEquals(1, $index['key']['email']);

		$index = $this->getIndex('newcollection', 'token');
		$this->assertEquals(1, $index['key']['token']);
	}

Jens Segers's avatar
Jens Segers committed
155 156 157 158 159 160 161 162 163
	public function testDummies()
	{
		Schema::collection('newcollection', function($collection)
		{
			$collection->boolean('activated')->default(0);
			$collection->integer('user_id')->unsigned();
		});
	}

164 165 166 167 168 169
	protected function getIndex($collection, $name)
	{
		$collection = DB::getCollection($collection);

		foreach ($collection->getIndexInfo() as $index)
		{
170
			if (isset($index['key'][$name])) return $index;
171 172 173 174 175
		}

		return false;
	}

176
}