Unlock 30% off on Manual Testing Annual Plans this Holiday Season.

Copied to Clipboard!

How to use not method of name class

Best Prophecy code snippet using name.not

EmailBoxTest.php

Source:EmailBoxTest.php

...15     * FOR A PARTICULAR PURPOSE.  See the GNU Affero General Public License for more16     * details.17     *18     * You should have received a copy of the GNU Affero General Public License along with19     * this program; if not, see http://www.gnu.org/licenses or write to the Free20     * Software Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA21     * 02110-1301 USA.22     *23     * You can contact Zurmo, Inc. with a mailing address at 27 North Wacker Drive24     * Suite 370 Chicago, IL 60606. or at email address contact@zurmo.com.25     *26     * The interactive user interfaces in original and modified versions27     * of this program must display Appropriate Legal Notices, as required under28     * Section 5 of the GNU Affero General Public License version 3.29     *30     * In accordance with Section 7(b) of the GNU Affero General Public License version 3,31     * these Appropriate Legal Notices must retain the display of the Zurmo32     * logo and Zurmo copyright notice. If the display of the logo is not reasonably33     * feasible for technical reasons, the Appropriate Legal Notices must display the words34     * "Copyright Zurmo Inc. 2014. All rights reserved".35     ********************************************************************************/36    class EmailBoxTest extends ZurmoBaseTest37    {38        public static function setUpBeforeClass()39        {40            parent::setUpBeforeClass();41            SecurityTestHelper::createSuperAdmin();42            UserTestHelper::createBasicUser('billy');43            UserTestHelper::createBasicUser('jane');44        }45        /**46         * @expectedException NotFoundException...

RedBeanModelToTableSchemaAdapterTest.php

Source:RedBeanModelToTableSchemaAdapterTest.php

...15     * FOR A PARTICULAR PURPOSE.  See the GNU Affero General Public License for more16     * details.17     *18     * You should have received a copy of the GNU Affero General Public License along with19     * this program; if not, see http://www.gnu.org/licenses or write to the Free20     * Software Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA21     * 02110-1301 USA.22     *23     * You can contact Zurmo, Inc. with a mailing address at 27 North Wacker Drive24     * Suite 370 Chicago, IL 60606. or at email address contact@zurmo.com.25     *26     * The interactive user interfaces in original and modified versions27     * of this program must display Appropriate Legal Notices, as required under28     * Section 5 of the GNU Affero General Public License version 3.29     *30     * In accordance with Section 7(b) of the GNU Affero General Public License version 3,31     * these Appropriate Legal Notices must retain the display of the Zurmo32     * logo and Zurmo copyright notice. If the display of the logo is not reasonably33     * feasible for technical reasons, the Appropriate Legal Notices must display the words34     * "Copyright Zurmo Inc. 2014. All rights reserved".35     ********************************************************************************/36    class RedBeanModelToTableSchemaAdapterTest extends BaseTest37    {38        protected static $messageLogger;39        public static function setUpBeforeClass()40        {41            parent::setUpBeforeClass();42            SecurityTestHelper::createSuperAdmin();43            $super = User::getByUsername('super');44            Yii::app()->user->userModel = $super;45            static::$messageLogger = new MessageLogger();46        }47        public function testResolveWithEmptyModelClassName()48        {49            $modelClassName     = null;50            $schema             = RedBeanModelToTableSchemaAdapter::resolve($modelClassName, static::$messageLogger);51            $this->assertFalse($schema);52        }53        /**54         * @depends testResolveWithEmptyModelClassName55         */56        public function testResolveWithInexistentModelClassName()57        {58            $modelClassName     = 'ModelClass';59            $schema             = RedBeanModelToTableSchemaAdapter::resolve($modelClassName, static::$messageLogger);60            $this->assertFalse($schema);61        }62        /**63         * @depends testResolveWithInexistentModelClassName64         */65        public function testResolveForModelClassWithNoOwnMetadataAndCannotHaveBean()66        {67            $modelClassName     = 'MashableActivity';68            $schema             = RedBeanModelToTableSchemaAdapter::resolve($modelClassName, static::$messageLogger);69            $this->assertFalse($schema);70        }71        /**72         * @depends testResolveForModelClassWithNoOwnMetadataAndCannotHaveBean73         */74        public function testResolveForModelClassWithNoOwnMetadataAndCanHaveBean()75        {76            $modelClassName     = 'OwnedSecurableItem';77            $expectedSchema     = array(78                'ownedsecurableitem' => array(79                    'columns' => array(80                        array(81                            'name' => 'securableitem_id',82                            'type' => 'INT(11)',83                            'unsigned' => 'UNSIGNED',84                            'notNull' => 'NULL', // Not Coding Standard85                            'collation' => null,86                            'default' => 'DEFAULT NULL', // Not Coding Standard87                        ),88                        array(89                            'name' => 'owner__user_id',90                            'type' => 'INT(11)',91                            'unsigned' => 'UNSIGNED',92                            'notNull' => 'NULL', // Not Coding Standard93                            'collation' => null,94                            'default' => 'DEFAULT NULL', // Not Coding Standard95                        ),96                    ),97                    'indexes' => array(98                        'owner__user_id' => array('columns' => array('owner__user_id'),99                        'unique'         => false),100                    ),101                ),102            );103            $schema             = RedBeanModelToTableSchemaAdapter::resolve($modelClassName, static::$messageLogger);104            $this->assertNotEmpty($schema);105            $this->assertEquals($expectedSchema, $schema);106        }107        /**108         * @depends testResolveForModelClassWithNoOwnMetadataAndCanHaveBean109         */110        public function testResolve()111        {112            $expectedSchema     = array('_user' =>113                array('columns' =>114                    array(115                        array(116                            'name' => 'hash',117                            'type' => 'VARCHAR(60)',118                            'unsigned' => null,119                            'notNull' => 'NULL', // Not Coding Standard120                            'collation' => 'COLLATE utf8_unicode_ci',121                            'default' => 'DEFAULT NULL', // Not Coding Standard122                        ),123                        array(124                            'name' => 'language',125                            'type' => 'VARCHAR(10)',126                            'unsigned' => null,127                            'notNull' => 'NULL', // Not Coding Standard128                            'collation' => 'COLLATE utf8_unicode_ci',129                            'default' => 'DEFAULT NULL', // Not Coding Standard130                        ),131                        array(132                            'name' => 'locale',133                            'type' => 'VARCHAR(10)',134                            'unsigned' => null,135                            'notNull' => 'NULL', // Not Coding Standard136                            'collation' => 'COLLATE utf8_unicode_ci',137                            'default' => 'DEFAULT NULL', // Not Coding Standard138                        ),139                        array(140                            'name' => 'timezone',141                            'type' => 'VARCHAR(64)',142                            'unsigned' => null,143                            'notNull' => 'NULL', // Not Coding Standard144                            'collation' => 'COLLATE utf8_unicode_ci',145                            'default' => 'DEFAULT NULL', // Not Coding Standard146                        ),147                        array(148                            'name' => 'username',149                            'type' => 'VARCHAR(64)',150                            'unsigned' => null,151                            'notNull' => 'NULL', // Not Coding Standard152                            'collation' => 'COLLATE utf8_unicode_ci',153                            'default' => 'DEFAULT NULL', // Not Coding Standard154                        ),155                        array(156                            'name' => 'serializedavatardata',157                            'type' => 'TEXT',158                            'unsigned' => null,159                            'notNull' => 'NULL', // Not Coding Standard160                            'collation' => 'COLLATE utf8_unicode_ci',161                            'default' => 'DEFAULT NULL', // Not Coding Standard162                        ),163                        array(164                            'name' => 'isactive',165                            'type' => 'TINYINT(1) UNSIGNED',166                            'unsigned' => null,167                            'notNull' => 'NULL', // Not Coding Standard168                            'collation' => null,169                            'default' => 'DEFAULT NULL', // Not Coding Standard170                        ),171                        array(172                            'name' => 'isrootuser',173                            'type' => 'TINYINT(1) UNSIGNED',174                            'unsigned' => null,175                            'notNull' => 'NULL', // Not Coding Standard176                            'collation' => null,177                            'default' => 'DEFAULT NULL', // Not Coding Standard178                        ),179                        array(180                            'name' => 'hidefromselecting',181                            'type' => 'TINYINT(1) UNSIGNED',182                            'unsigned' => null,183                            'notNull' => 'NULL', // Not Coding Standard184                            'collation' => null,185                            'default' => 'DEFAULT NULL', // Not Coding Standard186                        ),187                        array(188                            'name' => 'issystemuser',189                            'type' => 'TINYINT(1) UNSIGNED',190                            'unsigned' => null,191                            'notNull' => 'NULL', // Not Coding Standard192                            'collation' => null,193                            'default' => 'DEFAULT NULL', // Not Coding Standard194                        ),195                        array(196                            'name' => 'hidefromleaderboard',197                            'type' => 'TINYINT(1) UNSIGNED',198                            'unsigned' => null,199                            'notNull' => 'NULL', // Not Coding Standard200                            'collation' => null,201                            'default' => 'DEFAULT NULL', // Not Coding Standard202                        ),203                        array(204                            'name' => 'lastlogindatetime',205                            'type' => 'DATETIME',206                            'unsigned' => null,207                            'notNull' => 'NULL', // Not Coding Standard208                            'collation' => null,209                            'default' => 'DEFAULT NULL', // Not Coding Standard210                        ),211                        array(212                            'name' => 'permitable_id',213                            'type' => 'INT(11)',214                            'unsigned' => 'UNSIGNED',215                            'notNull' => 'NULL', // Not Coding Standard216                            'collation' => null,217                            'default' => 'DEFAULT NULL', // Not Coding Standard218                        ),219                        array(220                            'name' => 'person_id',221                            'type' => 'INT(11)',222                            'unsigned' => 'UNSIGNED',223                            'notNull' => 'NULL', // Not Coding Standard224                            'collation' => null,225                            'default' => 'DEFAULT NULL', // Not Coding Standard226                        ),227                        array(228                            'name' => 'currency_id',229                            'type' => 'INT(11)',230                            'unsigned' => 'UNSIGNED',231                            'notNull' => 'NULL', // Not Coding Standard232                            'collation' => null,233                            'default' => 'DEFAULT NULL', // Not Coding Standard234                        ),235                        array(236                            'name' => 'manager__user_id',237                            'type' => 'INT(11)',238                            'unsigned' => 'UNSIGNED',239                            'notNull' => 'NULL', // Not Coding Standard240                            'collation' => null,241                            'default' => 'DEFAULT NULL', // Not Coding Standard242                        ),243                        array(244                            'name' => 'role_id',245                            'type' => 'INT(11)',246                            'unsigned' => 'UNSIGNED',247                            'notNull' => 'NULL', // Not Coding Standard248                            'collation' => null,249                            'default' => 'DEFAULT NULL', // Not Coding Standard250                        ),251                    ),252                    'indexes' => array(253                        'unique_emanresu' => array(254                            'columns' => array('username'),255                            'unique' => true,256                            ),257                        'permitable_id' => array('columns' => array('permitable_id'),258                            'unique'         => false),259                    ),260                    ),261                );262            $modelClassName     = 'User';263            $schema             = RedBeanModelToTableSchemaAdapter::resolve($modelClassName, static::$messageLogger);264            $this->assertNotEmpty($schema);265            $this->assertEquals($expectedSchema, $schema);266        }267        /**268         * @depends testResolve269         */270        public function testResolveForTestModel()271        {272            $expectedSchema     = array('emailtemplatemodeltestitem' => array(273                'columns' => array(274                    array(275                        'name' => 'firstname',276                        'type' => 'VARCHAR(32)',277                        'unsigned' => null,278                        'notNull' => 'NULL', // Not Coding Standard279                        'collation' => 'COLLATE utf8_unicode_ci',280                        'default' => 'DEFAULT NULL', // Not Coding Standard281                    ),282                    array(283                        'name' => 'lastname',284                        'type' => 'VARCHAR(32)',285                        'unsigned' => null,286                        'notNull' => 'NULL', // Not Coding Standard287                        'collation' => 'COLLATE utf8_unicode_ci',288                        'default' => 'DEFAULT NULL', // Not Coding Standard289                    ),290                    array(291                        'name' => 'boolean',292                        'type' => 'TINYINT(1) UNSIGNED',293                        'unsigned' => null,294                        'notNull' => 'NULL', // Not Coding Standard295                        'collation' => null,296                        'default' => 'DEFAULT NULL', // Not Coding Standard297                    ),298                    array(299                        'name' => 'boolean2',300                        'type' => 'TINYINT(1) UNSIGNED',301                        'unsigned' => null,302                        'notNull' => 'NULL', // Not Coding Standard303                        'collation' => null,304                        'default' => 'DEFAULT NULL', // Not Coding Standard305                    ),306                    array(307                        'name' => 'date',308                        'type' => 'DATE',309                        'unsigned' => null,310                        'notNull' => 'NULL', // Not Coding Standard311                        'collation' => null,312                        'default' => 'DEFAULT NULL', // Not Coding Standard313                    ),314                    array(315                        'name' => 'date2',316                        'type' => 'DATE',317                        'unsigned' => null,318                        'notNull' => 'NULL', // Not Coding Standard319                        'collation' => null,320                        'default' => 'DEFAULT NULL', // Not Coding Standard321                    ),322                    array(323                        'name' => 'date3',324                        'type' => 'DATE',325                        'unsigned' => null,326                        'notNull' => 'NULL', // Not Coding Standard327                        'collation' => null,328                        'default' => 'DEFAULT NULL', // Not Coding Standard329                    ),330                    array(331                        'name' => 'date4',332                        'type' => 'DATE',333                        'unsigned' => null,334                        'notNull' => 'NULL', // Not Coding Standard335                        'collation' => null,336                        'default' => 'DEFAULT NULL', // Not Coding Standard337                    ),338                    array(339                        'name' => 'datetime',340                        'type' => 'DATETIME',341                        'unsigned' => null,342                        'notNull' => 'NULL', // Not Coding Standard343                        'collation' => null,344                        'default' => 'DEFAULT NULL', // Not Coding Standard345                    ),346                    array(347                        'name' => 'datetime2',348                        'type' => 'DATETIME',349                        'unsigned' => null,350                        'notNull' => 'NULL', // Not Coding Standard351                        'collation' => null,352                        'default' => 'DEFAULT NULL', // Not Coding Standard353                    ),354                    array(355                        'name' => 'datetime3',356                        'type' => 'DATETIME',357                        'unsigned' => null,358                        'notNull' => 'NULL', // Not Coding Standard359                        'collation' => null,360                        'default' => 'DEFAULT NULL', // Not Coding Standard361                    ),362                    array(363                        'name' => 'datetime4',364                        'type' => 'DATETIME',365                        'unsigned' => null,366                        'notNull' => 'NULL', // Not Coding Standard367                        'collation' => null,368                        'default' => 'DEFAULT NULL', // Not Coding Standard369                    ),370                    array(371                        'name' => 'float',372                        'type' => 'DOUBLE',373                        'unsigned' => null,374                        'notNull' => 'NULL', // Not Coding Standard375                        'collation' => null,376                        'default' => 'DEFAULT NULL', // Not Coding Standard377                    ),378                    array(379                        'name' => 'integer',380                        'type' => 'INT(11)',381                        'unsigned' => null,382                        'notNull' => 'NULL', // Not Coding Standard383                        'collation' => null,384                        'default' => 'DEFAULT NULL', // Not Coding Standard385                    ),386                    array(387                        'name' => 'phone',388                        'type' => 'VARCHAR(14)',389                        'unsigned' => null,390                        'notNull' => 'NULL', // Not Coding Standard391                        'collation' => 'COLLATE utf8_unicode_ci',392                        'default' => 'DEFAULT NULL', // Not Coding Standard393                    ),394                    array(395                        'name' => 'string',396                        'type' => 'VARCHAR(64)',397                        'unsigned' => null,398                        'notNull' => 'NULL', // Not Coding Standard399                        'collation' => 'COLLATE utf8_unicode_ci',400                        'default' => 'DEFAULT NULL', // Not Coding Standard401                    ),402                    array(403                        'name' => 'textarea',404                        'type' => 'TEXT',405                        'unsigned' => null,406                        'notNull' => 'NULL', // Not Coding Standard407                        'collation' => 'COLLATE utf8_unicode_ci',408                        'default' => 'DEFAULT NULL', // Not Coding Standard409                    ),410                    array(411                        'name' => 'url',412                        'type' => 'VARCHAR(255)',413                        'unsigned' => null,414                        'notNull' => 'NULL', // Not Coding Standard415                        'collation' => 'COLLATE utf8_unicode_ci',416                        'default' => 'DEFAULT NULL', // Not Coding Standard417                    ),418                    array(419                        'name' => 'ownedsecurableitem_id',420                        'type' => 'INT(11)',421                        'unsigned' => 'UNSIGNED',422                        'notNull' => 'NULL', // Not Coding Standard423                        'collation' => null,424                        'default' => 'DEFAULT NULL', // Not Coding Standard425                    ),426                    array(427                        'name' => 'currencyvalue_id',428                        'type' => 'INT(11)',429                        'unsigned' => 'UNSIGNED',430                        'notNull' => 'NULL', // Not Coding Standard431                        'collation' => null,432                        'default' => 'DEFAULT NULL', // Not Coding Standard433                    ),434                    array(435                        'name' => 'dropdown_customfield_id',436                        'type' => 'INT(11)',437                        'unsigned' => 'UNSIGNED',438                        'notNull' => 'NULL', // Not Coding Standard439                        'collation' => null,440                        'default' => 'DEFAULT NULL', // Not Coding Standard441                    ),442                    array(443                        'name' => 'dropdown2_customfield_id',444                        'type' => 'INT(11)',445                        'unsigned' => 'UNSIGNED',446                        'notNull' => 'NULL', // Not Coding Standard447                        'collation' => null,448                        'default' => 'DEFAULT NULL', // Not Coding Standard449                    ),450                    array(451                        'name' => 'radiodropdown_customfield_id',452                        'type' => 'INT(11)',453                        'unsigned' => 'UNSIGNED',454                        'notNull' => 'NULL', // Not Coding Standard455                        'collation' => null,456                        'default' => 'DEFAULT NULL', // Not Coding Standard457                    ),458                    array(459                        'name' => 'multidropdown_multiplevaluescustomfield_id',460                        'type' => 'INT(11)',461                        'unsigned' => 'UNSIGNED',462                        'notNull' => 'NULL', // Not Coding Standard463                        'collation' => null,464                        'default' => 'DEFAULT NULL', // Not Coding Standard465                    ),466                    array(467                        'name' => 'tagcloud_multiplevaluescustomfield_id',468                        'type' => 'INT(11)',469                        'unsigned' => 'UNSIGNED',470                        'notNull' => 'NULL', // Not Coding Standard471                        'collation' => null,472                        'default' => 'DEFAULT NULL', // Not Coding Standard473                    ),474                    array(475                        'name' => 'primaryemail_email_id',476                        'type' => 'INT(11)',477                        'unsigned' => 'UNSIGNED',478                        'notNull' => 'NULL', // Not Coding Standard479                        'collation' => null,480                        'default' => 'DEFAULT NULL', // Not Coding Standard481                    ),482                    array(483                        'name' => 'primaryaddress_address_id',484                        'type' => 'INT(11)',485                        'unsigned' => 'UNSIGNED',486                        'notNull' => 'NULL', // Not Coding Standard487                        'collation' => null,488                        'default' => 'DEFAULT NULL', // Not Coding Standard489                    ),490                    array(491                        'name' => 'secondaryemail_email_id',492                        'type' => 'INT(11)',493                        'unsigned' => 'UNSIGNED',494                        'notNull' => 'NULL', // Not Coding Standard495                        'collation' => null,496                        'default' => 'DEFAULT NULL', // Not Coding Standard497                    ),498                    array(499                        'name' => 'likecontactstate_contactstate_id',500                        'type' => 'INT(11)',501                        'unsigned' => 'UNSIGNED',502                        'notNull' => 'NULL', // Not Coding Standard503                        'collation' => null,504                        'default' => 'DEFAULT NULL', // Not Coding Standard505                    ),506                    array(507                        'name' => '_user_id',508                        'type' => 'INT(11)',509                        'unsigned' => 'UNSIGNED',510                        'notNull' => 'NULL', // Not Coding Standard511                        'collation' => null,512                        'default' => 'DEFAULT NULL', // Not Coding Standard513                    ),514                    array(515                        'name' => 'user2__user_id',516                        'type' => 'INT(11)',517                        'unsigned' => 'UNSIGNED',518                        'notNull' => 'NULL', // Not Coding Standard519                        'collation' => null,520                        'default' => 'DEFAULT NULL', // Not Coding Standard521                    ),522                ),523                'indexes' => array(),524            ),525            );526            $modelClassName     = 'EmailTemplateModelTestItem';527            $schema             = RedBeanModelToTableSchemaAdapter::resolve($modelClassName, static::$messageLogger);528            $this->assertNotEmpty($schema);529            $this->assertEquals($expectedSchema, $schema);530        }531    }532?>...

QueryBuilder.php

Source:QueryBuilder.php

...74            return '';75        }76        // SQLite supports batch insert natively since 3.7.1177        // http://www.sqlite.org/releaselog/3_7_11.html78        $this->db->open(); // ensure pdo is not null79        if (version_compare($this->db->pdo->getAttribute(\PDO::ATTR_SERVER_VERSION), '3.7.11', '>=')) {80            return parent::batchInsert($table, $columns, $rows);81        }82        $schema = $this->db->getSchema();83        if (($tableSchema = $schema->getTableSchema($table)) !== null) {84            $columnSchemas = $tableSchema->columns;85        } else {86            $columnSchemas = [];87        }88        $values = [];89        foreach ($rows as $row) {90            $vs = [];91            foreach ($row as $i => $value) {92                if (!is_array($value) && isset($columnSchemas[$columns[$i]])) {93                    $value = $columnSchemas[$columns[$i]]->dbTypecast($value);94                }95                if (is_string($value)) {96                    $value = $schema->quoteValue($value);97                } elseif (is_float($value)) {98                    // ensure type cast always has . as decimal separator in all locales99                    $value = StringHelper::floatToString($value);100                } elseif ($value === false) {101                    $value = 0;102                } elseif ($value === null) {103                    $value = 'NULL';104                }105                $vs[] = $value;106            }107            $values[] = implode(', ', $vs);108        }109        if (empty($values)) {110            return '';111        }112        foreach ($columns as $i => $name) {113            $columns[$i] = $schema->quoteColumnName($name);114        }115        return 'INSERT INTO ' . $schema->quoteTableName($table)116        . ' (' . implode(', ', $columns) . ') SELECT ' . implode(' UNION SELECT ', $values);117    }118    /**119     * Creates a SQL statement for resetting the sequence value of a table's primary key.120     * The sequence will be reset such that the primary key of the next new row inserted121     * will have the specified value or 1.122     * @param string $tableName the name of the table whose primary key sequence will be reset123     * @param mixed $value the value for the primary key of the next new row inserted. If this is not set,124     * the next new row's primary key will have a value 1.125     * @return string the SQL statement for resetting sequence126     * @throws InvalidParamException if the table does not exist or there is no sequence associated with the table.127     */128    public function resetSequence($tableName, $value = null)129    {130        $db = $this->db;131        $table = $db->getTableSchema($tableName);132        if ($table !== null && $table->sequenceName !== null) {133            $tableName = $db->quoteTableName($tableName);134            if ($value === null) {135                $key = $this->db->quoteColumnName(reset($table->primaryKey));136                $value = $this->db->useMaster(function (Connection $db) use ($key, $tableName) {137                    return $db->createCommand("SELECT MAX($key) FROM $tableName")->queryScalar();138                });139            } else {140                $value = (int) $value - 1;141            }142            return "UPDATE sqlite_sequence SET seq='$value' WHERE name='{$table->name}'";143        } elseif ($table === null) {144            throw new InvalidParamException("Table not found: $tableName");145        }146        throw new InvalidParamException("There is not sequence associated with table '$tableName'.'");147    }148    /**149     * Enables or disables integrity check.150     * @param bool $check whether to turn on or off the integrity check.151     * @param string $schema the schema of the tables. Meaningless for SQLite.152     * @param string $table the table name. Meaningless for SQLite.153     * @return string the SQL statement for checking integrity154     * @throws NotSupportedException this is not supported by SQLite155     */156    public function checkIntegrity($check = true, $schema = '', $table = '')157    {158        return 'PRAGMA foreign_keys=' . (int) $check;159    }160    /**161     * Builds a SQL statement for truncating a DB table.162     * @param string $table the table to be truncated. The name will be properly quoted by the method.163     * @return string the SQL statement for truncating a DB table.164     */165    public function truncateTable($table)166    {167        return 'DELETE FROM ' . $this->db->quoteTableName($table);168    }169    /**170     * Builds a SQL statement for dropping an index.171     * @param string $name the name of the index to be dropped. The name will be properly quoted by the method.172     * @param string $table the table whose index is to be dropped. The name will be properly quoted by the method.173     * @return string the SQL statement for dropping an index.174     */175    public function dropIndex($name, $table)176    {177        return 'DROP INDEX ' . $this->db->quoteTableName($name);178    }179    /**180     * Builds a SQL statement for dropping a DB column.181     * @param string $table the table whose column is to be dropped. The name will be properly quoted by the method.182     * @param string $column the name of the column to be dropped. The name will be properly quoted by the method.183     * @return string the SQL statement for dropping a DB column.184     * @throws NotSupportedException this is not supported by SQLite185     */186    public function dropColumn($table, $column)187    {188        throw new NotSupportedException(__METHOD__ . ' is not supported by SQLite.');189    }190    /**191     * Builds a SQL statement for renaming a column.192     * @param string $table the table whose column is to be renamed. The name will be properly quoted by the method.193     * @param string $oldName the old name of the column. The name will be properly quoted by the method.194     * @param string $newName the new name of the column. The name will be properly quoted by the method.195     * @return string the SQL statement for renaming a DB column.196     * @throws NotSupportedException this is not supported by SQLite197     */198    public function renameColumn($table, $oldName, $newName)199    {200        throw new NotSupportedException(__METHOD__ . ' is not supported by SQLite.');201    }202    /**203     * Builds a SQL statement for adding a foreign key constraint to an existing table.204     * The method will properly quote the table and column names.205     * @param string $name the name of the foreign key constraint.206     * @param string $table the table that the foreign key constraint will be added to.207     * @param string|array $columns the name of the column to that the constraint will be added on.208     * If there are multiple columns, separate them with commas or use an array to represent them.209     * @param string $refTable the table that the foreign key references to.210     * @param string|array $refColumns the name of the column that the foreign key references to.211     * If there are multiple columns, separate them with commas or use an array to represent them.212     * @param string $delete the ON DELETE option. Most DBMS support these options: RESTRICT, CASCADE, NO ACTION, SET DEFAULT, SET NULL213     * @param string $update the ON UPDATE option. Most DBMS support these options: RESTRICT, CASCADE, NO ACTION, SET DEFAULT, SET NULL214     * @return string the SQL statement for adding a foreign key constraint to an existing table.215     * @throws NotSupportedException this is not supported by SQLite216     */217    public function addForeignKey($name, $table, $columns, $refTable, $refColumns, $delete = null, $update = null)218    {219        throw new NotSupportedException(__METHOD__ . ' is not supported by SQLite.');220    }221    /**222     * Builds a SQL statement for dropping a foreign key constraint.223     * @param string $name the name of the foreign key constraint to be dropped. The name will be properly quoted by the method.224     * @param string $table the table whose foreign is to be dropped. The name will be properly quoted by the method.225     * @return string the SQL statement for dropping a foreign key constraint.226     * @throws NotSupportedException this is not supported by SQLite227     */228    public function dropForeignKey($name, $table)229    {230        throw new NotSupportedException(__METHOD__ . ' is not supported by SQLite.');231    }232    /**233     * Builds a SQL statement for renaming a DB table.234     *235     * @param string $table the table to be renamed. The name will be properly quoted by the method.236     * @param string $newName the new table name. The name will be properly quoted by the method.237     * @return string the SQL statement for renaming a DB table.238     */239    public function renameTable($table, $newName)240    {241        return 'ALTER TABLE ' . $this->db->quoteTableName($table) . ' RENAME TO ' . $this->db->quoteTableName($newName);242    }243    /**244     * Builds a SQL statement for changing the definition of a column.245     * @param string $table the table whose column is to be changed. The table name will be properly quoted by the method.246     * @param string $column the name of the column to be changed. The name will be properly quoted by the method.247     * @param string $type the new column type. The [[getColumnType()]] method will be invoked to convert abstract248     * column type (if any) into the physical one. Anything that is not recognized as abstract type will be kept249     * in the generated SQL. For example, 'string' will be turned into 'varchar(255)', while 'string not null'250     * will become 'varchar(255) not null'.251     * @return string the SQL statement for changing the definition of a column.252     * @throws NotSupportedException this is not supported by SQLite253     */254    public function alterColumn($table, $column, $type)255    {256        throw new NotSupportedException(__METHOD__ . ' is not supported by SQLite.');257    }258    /**259     * Builds a SQL statement for adding a primary key constraint to an existing table.260     * @param string $name the name of the primary key constraint.261     * @param string $table the table that the primary key constraint will be added to.262     * @param string|array $columns comma separated string or array of columns that the primary key will consist of.263     * @return string the SQL statement for adding a primary key constraint to an existing table.264     * @throws NotSupportedException this is not supported by SQLite265     */266    public function addPrimaryKey($name, $table, $columns)267    {268        throw new NotSupportedException(__METHOD__ . ' is not supported by SQLite.');269    }270    /**271     * Builds a SQL statement for removing a primary key constraint to an existing table.272     * @param string $name the name of the primary key constraint to be removed.273     * @param string $table the table that the primary key constraint will be removed from.274     * @return string the SQL statement for removing a primary key constraint from an existing table.275     * @throws NotSupportedException this is not supported by SQLite276     */277    public function dropPrimaryKey($name, $table)278    {279        throw new NotSupportedException(__METHOD__ . ' is not supported by SQLite.');280    }281    /**282     * @inheritDoc283     * @throws NotSupportedException this is not supported by SQLite.284     */285    public function addUnique($name, $table, $columns)286    {287        throw new NotSupportedException(__METHOD__ . ' is not supported by SQLite.');288    }289    /**290     * @inheritDoc291     * @throws NotSupportedException this is not supported by SQLite.292     */293    public function dropUnique($name, $table)294    {295        throw new NotSupportedException(__METHOD__ . ' is not supported by SQLite.');296    }297    /**298     * @inheritDoc299     * @throws NotSupportedException this is not supported by SQLite.300     */301    public function addCheck($name, $table, $expression)302    {303        throw new NotSupportedException(__METHOD__ . ' is not supported by SQLite.');304    }305    /**306     * @inheritDoc307     * @throws NotSupportedException this is not supported by SQLite.308     */309    public function dropCheck($name, $table)310    {311        throw new NotSupportedException(__METHOD__ . ' is not supported by SQLite.');312    }313    /**314     * @inheritDoc315     * @throws NotSupportedException this is not supported by SQLite.316     */317    public function addDefaultValue($name, $table, $column, $value)318    {319        throw new NotSupportedException(__METHOD__ . ' is not supported by SQLite.');320    }321    /**322     * @inheritDoc323     * @throws NotSupportedException this is not supported by SQLite.324     */325    public function dropDefaultValue($name, $table)326    {327        throw new NotSupportedException(__METHOD__ . ' is not supported by SQLite.');328    }329    /**330     * @inheritdoc331     * @throws NotSupportedException332     * @since 2.0.8333     */334    public function addCommentOnColumn($table, $column, $comment)335    {336        throw new NotSupportedException(__METHOD__ . ' is not supported by SQLite.');337    }338    /**339     * @inheritdoc340     * @throws NotSupportedException341     * @since 2.0.8342     */343    public function addCommentOnTable($table, $comment)344    {345        throw new NotSupportedException(__METHOD__ . ' is not supported by SQLite.');346    }347    /**348     * @inheritdoc349     * @throws NotSupportedException350     * @since 2.0.8351     */352    public function dropCommentFromColumn($table, $column)353    {354        throw new NotSupportedException(__METHOD__ . ' is not supported by SQLite.');355    }356    /**357     * @inheritdoc358     * @throws NotSupportedException359     * @since 2.0.8360     */361    public function dropCommentFromTable($table)362    {363        throw new NotSupportedException(__METHOD__ . ' is not supported by SQLite.');364    }365    /**366     * @inheritdoc367     */368    public function buildLimit($limit, $offset)369    {370        $sql = '';371        if ($this->hasLimit($limit)) {372            $sql = 'LIMIT ' . $limit;373            if ($this->hasOffset($offset)) {374                $sql .= ' OFFSET ' . $offset;375            }376        } elseif ($this->hasOffset($offset)) {377            // limit is not optional in SQLite378            // http://www.sqlite.org/syntaxdiagrams.html#select-stmt379            $sql = "LIMIT 9223372036854775807 OFFSET $offset"; // 2^63-1380        }381        return $sql;382    }383    /**384     * @inheritdoc385     * @throws NotSupportedException if `$columns` is an array386     */387    protected function buildSubqueryInCondition($operator, $columns, $values, &$params)388    {389        if (is_array($columns)) {390            throw new NotSupportedException(__METHOD__ . ' is not supported by SQLite.');391        }392        return parent::buildSubqueryInCondition($operator, $columns, $values, $params);393    }394    /**395     * Builds SQL for IN condition.396     *397     * @param string $operator398     * @param array $columns399     * @param array $values400     * @param array $params401     * @return string SQL402     */403    protected function buildCompositeInCondition($operator, $columns, $values, &$params)404    {...

not

Using AI Code Generation

1$obj = new ClassName();2$obj->methodName();3$obj = new ClassName();4$obj->methodName();5$obj = new ClassName();6$obj->methodName();7$obj = new ClassName();8$obj->methodName();9$obj = new ClassName();10$obj->methodName();11$obj = new ClassName();12$obj->methodName();13$obj = new ClassName();14$obj->methodName();15$obj = new ClassName();16$obj->methodName();17$obj = new ClassName();18$obj->methodName();19$obj = new ClassName();20$obj->methodName();21$obj = new ClassName();22$obj->methodName();23$obj = new ClassName();24$obj->methodName();25$obj = new ClassName();26$obj->methodName();27$obj = new ClassName();28$obj->methodName();29$obj = new ClassName();30$obj->methodName();31$obj = new ClassName();32$obj->methodName();33$obj = new ClassName();34$obj->methodName();35$obj = new ClassName();36$obj->methodName();37$obj = new ClassName();38$obj->methodName();

not

Using AI Code Generation

1$object = new ClassName();2$object->methodName();3$object = new ClassName();4$object->methodName();5$object = new ClassName();6$object->methodName();7$object = new ClassName();8$object->methodName();9$object = new ClassName();10$object->methodName();11$object = new ClassName();12$object->methodName();13$object = new ClassName();14$object->methodName();15$object = new ClassName();16$object->methodName();17$object = new ClassName();18$object->methodName();19$object = new ClassName();20$object->methodName();21$object = new ClassName();22$object->methodName();23$object = new ClassName();24$object->methodName();25$object = new ClassName();26$object->methodName();27$object = new ClassName();28$object->methodName();29$object = new ClassName();30$object->methodName();31$object = new ClassName();32$object->methodName();33$object = new ClassName();34$object->methodName();35$object = new ClassName();36$object->methodName();

not

Using AI Code Generation

1$obj = new A;2$obj->name();3$obj = new A;4$obj->name();5$obj = new A;6$obj->name();7$obj = new A;8$obj->name();9$obj = new A;10$obj->name();11$obj = new A;12$obj->name();13$obj = new A;14$obj->name();15$obj = new A;16$obj->name();17$obj = new A;18$obj->name();19$obj = new A;20$obj->name();21$obj = new A;22$obj->name();23$obj = new A;24$obj->name();25$obj = new A;26$obj->name();27$obj = new A;28$obj->name();29$obj = new A;30$obj->name();31$obj = new A;32$obj->name();33$obj = new A;34$obj->name();35$obj = new A;36$obj->name();37$obj = new A;38$obj->name();

not

Using AI Code Generation

1$object = new MyClass;2$object->myMethod();3$object = new MyClass;4$object->myMethod();5$object = new MyClass;6$object->myMethod();7$object = new MyClass;8$object->myMethod();9$object = new MyClass;10$object->myMethod();11$object = new MyClass;12$object->myMethod();13$object = new MyClass;14$object->myMethod();15$object = new MyClass;16$object->myMethod();17$object = new MyClass;18$object->myMethod();19$object = new MyClass;20$object->myMethod();21$object = new MyClass;22$object->myMethod();23$object = new MyClass;24$object->myMethod();25$object = new MyClass;26$object->myMethod();27$object = new MyClass;28$object->myMethod();29$object = new MyClass;30$object->myMethod();31$object = new MyClass;32$object->myMethod();33$object = new MyClass;34$object->myMethod();

not

Using AI Code Generation

1$object = new ClassName();2$object->functionName();3ClassName::functionName();4ClassName::$functionName();5ClassName::CONSTANT;6ClassName::CONSTANT1;7ClassName::CONSTANT2;8ClassName::CONSTANT3;9ClassName::CONSTANT4;10ClassName::CONSTANT5;11ClassName::CONSTANT6;12ClassName::CONSTANT7;13ClassName::CONSTANT8;14ClassName::CONSTANT9;15ClassName::CONSTANT10;16ClassName::CONSTANT11;17ClassName::CONSTANT12;18ClassName::CONSTANT13;19ClassName::CONSTANT14;20ClassName::CONSTANT15;21ClassName::CONSTANT16;22ClassName::CONSTANT17;23ClassName::CONSTANT18;

not

Using AI Code Generation

1$myobj = new MyClass();2$myobj->myPublic();3$myobj->myProtected();4";5";6$myobj->myPublic();7$myobj->myProtected();

not

Using AI Code Generation

1class Person{2	public $name;3	public $age;4	public function __construct($name,$age){5		$this->name=$name;6		$this->age=$age;7	}8	public function personDetails(){9		echo "Person name is {$this->name} and age is {$this->age}";10	}11}12$personOne=new Person("Rahim",25);13$personOne->personDetails();14class Person{15	public $name;16	public $age;17	public function __construct($name,$age){18		$this->name=$name;19		$this->age=$age;20	}21	public function personDetails(){22		echo "Person name is {$this->name} and age is {$this->age}";23	}24}25$personOne=new Person("Rahim",25);26$personOne->personDetails();27class Person{28	public $name;29	public $age;30	public function __construct($name,$age){31		$this->name=$name;32		$this->age=$age;33	}34	public function personDetails(){35		echo "Person name is {$this->name} and age is {$this->age}";36	}37}38$personOne=new Person("Rahim",25);39$personOne->personDetails();40class Person{41	public $name;42	public $age;43	public function __construct($name,$age){44		$this->name=$name;45		$this->age=$age;46	}47	public function personDetails(){48		echo "Person name is {$this->name} and age is {$this->age}";49	}50}51$personOne=new Person("Rahim",25);52$personOne->personDetails();53class Person{

Automation Testing Tutorials

Learn to execute automation testing from scratch with LambdaTest Learning Hub. Right from setting up the prerequisites to run your first automation test, to following best practices and diving deeper into advanced test scenarios. LambdaTest Learning Hubs compile a list of step-by-step guides to help you be proficient with different test automation frameworks i.e. Selenium, Cypress, TestNG etc.