TestUserDao::getUsersFromSqlByAlphabeticalOrder() - Code Metrics - Inspection of "Merge pull request #7 from moufmouf/master" - thecodingmachine/tdbm - Measure and Improve Code Quality continuously with Scrutinizer

Passed

Push — master ( a7d8f7...05ba31 )

by David

created 2017-05-30 16:45 UTC

TestUserDao::getUsersFromSqlByAlphabeticalOrder() A

↳ Parent: TestUserDao

Complexity

Conditions	1
Paths	1

Size

Total Lines	5
Code Lines	2

Duplication

Lines	0
Ratio	0 %

Importance

Changes

Metric	Value
dl	0
loc	5
rs	9.4285
c	0
b	0
f	0
cc	1
eloc	2
nc	1
nop	0

<?php

namespace TheCodingMachine\TDBM\Dao;

use TheCodingMachine\TDBM\Test\Dao\Generated\UserBaseDao;
use TheCodingMachine\TDBM\UncheckedOrderBy;

/**
 * The UserDao class will maintain the persistence of UserBean class into the users table.
 */
class TestUserDao extends UserBaseDao
{
    /**
     * Returns the list of users by alphabetical order.
     *
     * @return UserBean[]
     */
    public function getUsersByAlphabeticalOrder()
    {
        // The third parameter will be used in the "ORDER BY" clause of the SQL query.
        return $this->find(null, [], 'login ASC');
    }
    /**
     * Returns the list of users by alphabetical order.
     *
     * @return UserBean[]
     */
    public function getUsersFromSqlByAlphabeticalOrder()
    {
        // The third parameter will be used in the "ORDER BY" clause of the SQL query.
        return $this->findFromSql('users', null, [], 'login ASC');
    }

    /**
     * Returns the list of users by alphabetical order.
     *
     * @return UserBean[]
     */
    public function getUsersByCountryOrder()
    {
        // The third parameter will be used in the "ORDER BY" clause of the SQL query.
        return $this->find(null, [], 'country.label ASC', ['country']);
    }
    /**
     * Returns the list of users by alphabetical order.
     *
     * @return UserBean[]
     */
    public function getUsersFromSqlByCountryOrder()
    {
        // The third parameter will be used in the "ORDER BY" clause of the SQL query.
        return $this->findFromSql('users JOIN country ON country.id = users.country_id', null, [], 'country.label ASC');
    }

    /**
     * Returns the list of users whose login starts with $login.
     *
     * @param string $login
     * @param string $mode
     *
     * @return \TheCodingMachine\TDBM\ResultIterator|\TheCodingMachine\TDBM\Test\Dao\Bean\UserBean[]|\TheCodingMachine\TDBM\Test\Dao\ResultArray
     */
    public function getUsersByLoginStartingWith($login = null, $mode = null)
    {
        return $this->find('login LIKE :login', ['login' => $login.'%'], null, [], $mode);
    }

    /**
     * Returns the user whose login is $login.
     *
     * @param string $login
     *
     * @return \TheCodingMachine\TDBM\Test\Dao\Bean\UserBean
     */
    public function getUserByLogin($login)
    {
        return $this->findOne('login = :login', ['login' => $login]);
    }

    public function getUsersByManagerId($managerId)
    {
        return $this->find('contact.manager_id = :id!', ['id' => $managerId]);
    }

    /**
     * Triggers an error because table "contacts" does not exist.
     *
     * @return \TheCodingMachine\TDBM\ResultIterator|\TheCodingMachine\TDBM\Test\Dao\Bean\UserBean[]|\TheCodingMachine\TDBM\Test\Dao\Generated\ResultArray
     */
    public function getUsersWrongTableName()
    {
        return $this->find('contacts.manager_id = 1');
    }

    /**
     * Returns a list of users, sorted by a table on an external column.
     *
     * @return \TheCodingMachine\TDBM\ResultIterator|\TheCodingMachine\TDBM\Test\Dao\Bean\UserBean[]|\TheCodingMachine\TDBM\Test\Dao\Generated\ResultArray
     */
    public function getUsersByCountryName()
    {
        return $this->find(null, [], 'country.label DESC');
    }

    /**
     * A test to sort by function.
     *
     * @return \TheCodingMachine\TDBM\ResultIterator|\TheCodingMachine\TDBM\Test\Dao\Bean\UserBean[]|\TheCodingMachine\TDBM\Test\Dao\Generated\ResultArray
     */
    public function getUsersByReversedCountryName()
    {
        return $this->find(null, [], new UncheckedOrderBy('REVERSE(country.label) ASC'));
    }

    /**
     * A test to check exceptions when providing expressions in ORDER BY clause.
     *
     * @return \TheCodingMachine\TDBM\ResultIterator|\TheCodingMachine\TDBM\Test\Dao\Bean\UserBean[]|\TheCodingMachine\TDBM\Test\Dao\Generated\ResultArray
     */
    public function getUsersByInvalidOrderBy()
    {
        return $this->find(null, [], 'REVERSE(country.label) ASC');
    }
}


1			<?php
2
3			namespace TheCodingMachine\TDBM\Dao;
4
5			use TheCodingMachine\TDBM\Test\Dao\Generated\UserBaseDao;
6			use TheCodingMachine\TDBM\UncheckedOrderBy;
7
8			/**
9			* The UserDao class will maintain the persistence of UserBean class into the users table.
10			*/
11			class TestUserDao extends UserBaseDao
12			{
13			/**
14			* Returns the list of users by alphabetical order.
15			*
16			* @return UserBean[]
17			*/
18			public function getUsersByAlphabeticalOrder()
19			{
20			// The third parameter will be used in the "ORDER BY" clause of the SQL query.
21			return $this->find(null, [], 'login ASC');
22			}
23			/**
24			* Returns the list of users by alphabetical order.
25			*
26			* @return UserBean[]
27			*/
28			public function getUsersFromSqlByAlphabeticalOrder()
29			{
30			// The third parameter will be used in the "ORDER BY" clause of the SQL query.
31			return $this->findFromSql('users', null, [], 'login ASC');
32			}
33
34			/**
35			* Returns the list of users by alphabetical order.
36			*
37			* @return UserBean[]
38			*/
39			public function getUsersByCountryOrder()
40			{
41			// The third parameter will be used in the "ORDER BY" clause of the SQL query.
42			return $this->find(null, [], 'country.label ASC', ['country']);
43			}
44			/**
45			* Returns the list of users by alphabetical order.
46			*
47			* @return UserBean[]
48			*/
49			public function getUsersFromSqlByCountryOrder()
50			{
51			// The third parameter will be used in the "ORDER BY" clause of the SQL query.
52			return $this->findFromSql('users JOIN country ON country.id = users.country_id', null, [], 'country.label ASC');
53			}
54
55			/**
56			* Returns the list of users whose login starts with $login.
57			*
58			* @param string $login
59			* @param string $mode
60			*
61			* @return \TheCodingMachine\TDBM\ResultIterator\|\TheCodingMachine\TDBM\Test\Dao\Bean\UserBean[]\|\TheCodingMachine\TDBM\Test\Dao\ResultArray
62			*/
63			public function getUsersByLoginStartingWith($login = null, $mode = null)
64			{
65			return $this->find('login LIKE :login', ['login' => $login.'%'], null, [], $mode);
66			}
67
68			/**
69			* Returns the user whose login is $login.
70			*
71			* @param string $login
72			*
73			* @return \TheCodingMachine\TDBM\Test\Dao\Bean\UserBean
74			*/
75			public function getUserByLogin($login)
76			{
77			return $this->findOne('login = :login', ['login' => $login]);
78			}
79
80			public function getUsersByManagerId($managerId)
81			{
82			return $this->find('contact.manager_id = :id!', ['id' => $managerId]);
83			}
84
85			/**
86			* Triggers an error because table "contacts" does not exist.
87			*
88			* @return \TheCodingMachine\TDBM\ResultIterator\|\TheCodingMachine\TDBM\Test\Dao\Bean\UserBean[]\|\TheCodingMachine\TDBM\Test\Dao\Generated\ResultArray
89			*/
90			public function getUsersWrongTableName()
91			{
92			return $this->find('contacts.manager_id = 1');
93			}
94
95			/**
96			* Returns a list of users, sorted by a table on an external column.
97			*
98			* @return \TheCodingMachine\TDBM\ResultIterator\|\TheCodingMachine\TDBM\Test\Dao\Bean\UserBean[]\|\TheCodingMachine\TDBM\Test\Dao\Generated\ResultArray
99			*/
100			public function getUsersByCountryName()
101			{
102			return $this->find(null, [], 'country.label DESC');
103			}
104
105			/**
106			* A test to sort by function.
107			*
108			* @return \TheCodingMachine\TDBM\ResultIterator\|\TheCodingMachine\TDBM\Test\Dao\Bean\UserBean[]\|\TheCodingMachine\TDBM\Test\Dao\Generated\ResultArray
109			*/
110			public function getUsersByReversedCountryName()
111			{
112			return $this->find(null, [], new UncheckedOrderBy('REVERSE(country.label) ASC'));
113			}
114
115			/**
116			* A test to check exceptions when providing expressions in ORDER BY clause.
117			*
118			* @return \TheCodingMachine\TDBM\ResultIterator\|\TheCodingMachine\TDBM\Test\Dao\Bean\UserBean[]\|\TheCodingMachine\TDBM\Test\Dao\Generated\ResultArray
119			*/
120			public function getUsersByInvalidOrderBy()
121			{
122			return $this->find(null, [], 'REVERSE(country.label) ASC');
123			}
124			}
125

thecodingmachine / tdbm

Push — master ( a7d8f7...05ba31 )

TestUserDao::getUsersFromSqlByAlphabeticalOrder() A

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like