database/tests/Database/Table/Selection.insert().primaryKeys.phpt at d8d52f7980c7c04b94a957f23655619b5d372a79 · nette/database · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
<?php

/**
 * Test: Nette\Database\Table\Selection: Different setup for primary keys
 * @dataProvider? ../databases.ini
 */

use Tester\Assert;

require __DIR__ . '/../connect.inc.php'; // create $connection

Nette\Database\Helpers::loadFromFile($connection, __DIR__ . "/../files/{$driverName}-nette_test4.sql");

// Insert into table with simple primary index (autoincrement)
test(function() use ($context) {
	$simplePkAutoincrementResult = $context->table('simple_pk_autoincrement')->insert([
		'note' => 'Some note here'
	]);

	Assert::type(\Nette\Database\Table\ActiveRow::class, $simplePkAutoincrementResult);
	Assert::equal(1, $simplePkAutoincrementResult->identifier1);
	Assert::equal('Some note here', $simplePkAutoincrementResult->note);

	$simplePkAutoincrementResult2 = $context->table('simple_pk_autoincrement')->insert([
		'note' => 'Some note here 2'
	]);

	Assert::type(\Nette\Database\Table\ActiveRow::class, $simplePkAutoincrementResult2);
	Assert::equal(2, $simplePkAutoincrementResult2->identifier1);
	Assert::equal('Some note here 2', $simplePkAutoincrementResult2->note);
});

// Insert into table with simple primary index (no autoincrement)
test(function() use ($context) {
	$simplePkNoAutoincrementResult = $context->table('simple_pk_no_autoincrement')->insert([
		'identifier1' => 100,
		'note' => 'Some note here'
	]);

	Assert::type(\Nette\Database\Table\ActiveRow::class, $simplePkNoAutoincrementResult);
	Assert::equal(100, $simplePkNoAutoincrementResult->identifier1);
	Assert::equal('Some note here', $simplePkNoAutoincrementResult->note);

	$simplePkNoAutoincrementResult2 = $context->table('simple_pk_no_autoincrement')->insert([
		'identifier1' => 200,
		'note' => 'Some note here 2'
	]);

	Assert::type(\Nette\Database\Table\ActiveRow::class, $simplePkNoAutoincrementResult2);
	Assert::equal(200, $simplePkNoAutoincrementResult2->identifier1);
	Assert::equal('Some note here 2', $simplePkNoAutoincrementResult2->note);
});

// Insert into table with multi column primary index (no autoincrement)
test(function() use ($context) {
	$multiPkNoAutoincrementResult = $context->table('multi_pk_no_autoincrement')->insert([
		'identifier1' => 5,
		'identifier2' => 10,
		'note' => 'Some note here'
	]);

	Assert::type(\Nette\Database\Table\ActiveRow::class, $multiPkNoAutoincrementResult);
	Assert::equal(5, $multiPkNoAutoincrementResult->identifier1);
	Assert::equal(10, $multiPkNoAutoincrementResult->identifier2);
	Assert::equal('Some note here', $multiPkNoAutoincrementResult->note);

	$multiPkNoAutoincrementResult2 = $context->table('multi_pk_no_autoincrement')->insert([
		'identifier1' => 5,
		'identifier2' => 100,
		'note' => 'Some note here 2'
	]);

	Assert::type(\Nette\Database\Table\ActiveRow::class, $multiPkNoAutoincrementResult2);
	Assert::equal(5, $multiPkNoAutoincrementResult2->identifier1);
	Assert::equal(100, $multiPkNoAutoincrementResult2->identifier2);
	Assert::equal('Some note here 2', $multiPkNoAutoincrementResult2->note);
});

// Insert into table with multi column primary index (autoincrement)
test(function() use ($driverName, $context) {
	if (in_array($driverName, ['mysql', 'pgsql'])) {
		$multiPkAutoincrementResult = $context->table('multi_pk_autoincrement')->insert([
			'identifier2' => 999,
			'note' => 'Some note here'
		]);

		Assert::type(\Nette\Database\Table\ActiveRow::class, $multiPkAutoincrementResult);
		Assert::equal(1, $multiPkAutoincrementResult->identifier1);
		Assert::equal(999, $multiPkAutoincrementResult->identifier2);
		Assert::equal('Some note here', $multiPkAutoincrementResult->note);

		$multiPkAutoincrementResult2 = $context->table('multi_pk_autoincrement')->insert([
			'identifier2' => 999,
			'note' => 'Some note here 2'
		]);

		Assert::type(\Nette\Database\Table\ActiveRow::class, $multiPkAutoincrementResult2);
		Assert::equal(2, $multiPkAutoincrementResult2->identifier1);
		Assert::equal(999, $multiPkAutoincrementResult2->identifier2);
		Assert::equal('Some note here 2', $multiPkAutoincrementResult2->note);
	}
});

// Insert into table without primary key
test(function() use ($context) {
	$noPkResult1 = $context->table('no_pk')->insert([
		'note' => 'Some note here',
	]);
	Assert::equal(1, $noPkResult1);
});