DeleteQueryTest::testBasicDelete PHP Method

    public function testBasicDelete()
    {
        $query = new DeleteQuery();
        $query->delete('users', 'u')->partitions('p1', 'p2')->where()->equal('id', 3)->is('confirmed', true);
        $query->limit(1);
        $this->assertSqlStrings($query, [[new MySQLDriver(), 'DELETE FROM users AS u PARTITION (p1,p2) WHERE id = 3 AND confirmed IS TRUE LIMIT 1'], [new PgSQLDriver(), 'DELETE FROM users AS u WHERE id = 3 AND confirmed IS TRUE'], [new SQLiteDriver(), 'DELETE FROM users AS u WHERE id = 3 AND confirmed IS 1']]);
    }