@@ -11,27 +11,27 @@ |
||
| 11 | 11 | use EmmetBlue\Core\Database\Abstraction\QueryBuilder; |
| 12 | 12 | |
| 13 | 13 | /** |
| 14 | - * class QueryBuilderTest. |
|
| 15 | - * |
|
| 16 | - * @author Samuel Adeshina <[email protected]> |
|
| 17 | - * |
|
| 18 | - * @since v0.0.1 27/05/2016 14:27 |
|
| 19 | - */ |
|
| 14 | + * class QueryBuilderTest. |
|
| 15 | + * |
|
| 16 | + * @author Samuel Adeshina <[email protected]> |
|
| 17 | + * |
|
| 18 | + * @since v0.0.1 27/05/2016 14:27 |
|
| 19 | + */ |
|
| 20 | 20 | class QueryBuilderTest extends \PHPUnit\Framework\TestCase |
| 21 | 21 | { |
| 22 | - public function testBuilderActuallyBuilding() |
|
| 23 | - { |
|
| 24 | - $queryBuilder = new QueryBuilder('INSERT INTO tbl_name'); |
|
| 25 | - $queryBuilder = $queryBuilder->build("VALUES ('tbl_col1', 'tbl_col2')"); |
|
| 22 | + public function testBuilderActuallyBuilding() |
|
| 23 | + { |
|
| 24 | + $queryBuilder = new QueryBuilder('INSERT INTO tbl_name'); |
|
| 25 | + $queryBuilder = $queryBuilder->build("VALUES ('tbl_col1', 'tbl_col2')"); |
|
| 26 | 26 | |
| 27 | - $builtQuery = (string) $queryBuilder; |
|
| 28 | - $expectedQuery = "INSERT INTO tbl_name VALUES ('tbl_col1', 'tbl_col2')"; |
|
| 27 | + $builtQuery = (string) $queryBuilder; |
|
| 28 | + $expectedQuery = "INSERT INTO tbl_name VALUES ('tbl_col1', 'tbl_col2')"; |
|
| 29 | 29 | |
| 30 | - $this->assertEquals($expectedQuery, $builtQuery); |
|
| 31 | - } |
|
| 30 | + $this->assertEquals($expectedQuery, $builtQuery); |
|
| 31 | + } |
|
| 32 | 32 | |
| 33 | - public function testWrapStringFunctionBehavesStatically() |
|
| 34 | - { |
|
| 35 | - $built = QueryBuilder::wrapString('Name', "'"); |
|
| 36 | - } |
|
| 33 | + public function testWrapStringFunctionBehavesStatically() |
|
| 34 | + { |
|
| 35 | + $built = QueryBuilder::wrapString('Name', "'"); |
|
| 36 | + } |
|
| 37 | 37 | } |
@@ -12,54 +12,54 @@ |
||
| 12 | 12 | use EmmetBlue\Core\Database\Abstraction\InsertQueryBuilder; |
| 13 | 13 | |
| 14 | 14 | /** |
| 15 | - * class QueryBuilderTest. |
|
| 16 | - * |
|
| 17 | - * @author Samuel Adeshina <[email protected]> |
|
| 18 | - * |
|
| 19 | - * @since v0.0.1 27/05/2016 14:27 |
|
| 20 | - */ |
|
| 15 | + * class QueryBuilderTest. |
|
| 16 | + * |
|
| 17 | + * @author Samuel Adeshina <[email protected]> |
|
| 18 | + * |
|
| 19 | + * @since v0.0.1 27/05/2016 14:27 |
|
| 20 | + */ |
|
| 21 | 21 | class InsertQueryBuilderTest extends \PHPUnit\Framework\TestCase |
| 22 | 22 | { |
| 23 | - public function testInsertBuilderWithOnlyConstructorParameter() |
|
| 24 | - { |
|
| 25 | - $queryBuilder = new InsertQueryBuilder('tbl_name'); |
|
| 23 | + public function testInsertBuilderWithOnlyConstructorParameter() |
|
| 24 | + { |
|
| 25 | + $queryBuilder = new InsertQueryBuilder('tbl_name'); |
|
| 26 | 26 | |
| 27 | - $builtQuery = (string) $queryBuilder; |
|
| 28 | - $expectedQuery = 'INSERT INTO tbl_name'; |
|
| 27 | + $builtQuery = (string) $queryBuilder; |
|
| 28 | + $expectedQuery = 'INSERT INTO tbl_name'; |
|
| 29 | 29 | |
| 30 | - $this->assertEquals($expectedQuery, $builtQuery); |
|
| 31 | - } |
|
| 30 | + $this->assertEquals($expectedQuery, $builtQuery); |
|
| 31 | + } |
|
| 32 | 32 | |
| 33 | - public function testInsertBuilderWithIntoMethod() |
|
| 34 | - { |
|
| 35 | - $queryBuilder = new InsertQueryBuilder(); |
|
| 36 | - $queryBuilder = $queryBuilder->into('tbl_name'); |
|
| 33 | + public function testInsertBuilderWithIntoMethod() |
|
| 34 | + { |
|
| 35 | + $queryBuilder = new InsertQueryBuilder(); |
|
| 36 | + $queryBuilder = $queryBuilder->into('tbl_name'); |
|
| 37 | 37 | |
| 38 | - $builtQuery = (string) $queryBuilder; |
|
| 39 | - $expectedQuery = 'INSERT INTO tbl_name'; |
|
| 38 | + $builtQuery = (string) $queryBuilder; |
|
| 39 | + $expectedQuery = 'INSERT INTO tbl_name'; |
|
| 40 | 40 | |
| 41 | - $this->assertEquals($expectedQuery, $builtQuery); |
|
| 42 | - } |
|
| 41 | + $this->assertEquals($expectedQuery, $builtQuery); |
|
| 42 | + } |
|
| 43 | 43 | |
| 44 | - public function testInsertBuilderWithIntoAndTableColumnsMethod() |
|
| 45 | - { |
|
| 46 | - $queryBuilder = new InsertQueryBuilder(); |
|
| 47 | - $queryBuilder = $queryBuilder->into('tbl_name', ['tbl_col1', 'tbl_col2']); |
|
| 44 | + public function testInsertBuilderWithIntoAndTableColumnsMethod() |
|
| 45 | + { |
|
| 46 | + $queryBuilder = new InsertQueryBuilder(); |
|
| 47 | + $queryBuilder = $queryBuilder->into('tbl_name', ['tbl_col1', 'tbl_col2']); |
|
| 48 | 48 | |
| 49 | - $builtQuery = (string) $queryBuilder; |
|
| 50 | - $expectedQuery = 'INSERT INTO tbl_name(tbl_col1,tbl_col2)'; |
|
| 49 | + $builtQuery = (string) $queryBuilder; |
|
| 50 | + $expectedQuery = 'INSERT INTO tbl_name(tbl_col1,tbl_col2)'; |
|
| 51 | 51 | |
| 52 | - $this->assertEquals($expectedQuery, $builtQuery); |
|
| 53 | - } |
|
| 52 | + $this->assertEquals($expectedQuery, $builtQuery); |
|
| 53 | + } |
|
| 54 | 54 | |
| 55 | - public function testInsertBuilderWithConstructorParameterAndValuesKeyword() |
|
| 56 | - { |
|
| 57 | - $queryBuilder = new InsertQueryBuilder('tbl_name'); |
|
| 58 | - $queryBuilder = $queryBuilder->values(['tbl_col_val1', 'tbl_col_val2']); |
|
| 55 | + public function testInsertBuilderWithConstructorParameterAndValuesKeyword() |
|
| 56 | + { |
|
| 57 | + $queryBuilder = new InsertQueryBuilder('tbl_name'); |
|
| 58 | + $queryBuilder = $queryBuilder->values(['tbl_col_val1', 'tbl_col_val2']); |
|
| 59 | 59 | |
| 60 | - $expectedQuery = 'INSERT INTO tbl_name VALUES (tbl_col_val1,tbl_col_val2)'; |
|
| 61 | - $builtQuery = (string) $queryBuilder; |
|
| 60 | + $expectedQuery = 'INSERT INTO tbl_name VALUES (tbl_col_val1,tbl_col_val2)'; |
|
| 61 | + $builtQuery = (string) $queryBuilder; |
|
| 62 | 62 | |
| 63 | - $this->assertEquals($expectedQuery, $builtQuery); |
|
| 64 | - } |
|
| 63 | + $this->assertEquals($expectedQuery, $builtQuery); |
|
| 64 | + } |
|
| 65 | 65 | } |