Sabre\CalDAV\Backend\SimplePDOTest Class Reference

Inheritance diagram for Sabre\CalDAV\Backend\SimplePDOTest:

Collaboration diagram for Sabre\CalDAV\Backend\SimplePDOTest:

Public Member Functions
	setUp ()
	testConstruct ()
	testGetCalendarsForUserNoCalendars ()
	@depends testConstruct More...
	testCreateCalendarAndFetch ()
	@depends testConstruct More...
	testUpdateCalendarAndFetch ()
	@depends testConstruct More...
	testDeleteCalendar ()
	@depends testCreateCalendarAndFetch More...
	testCreateCalendarObject ()
	testGetMultipleObjects ()
	testGetCalendarObjects ()
	@depends testCreateCalendarObject More...
	testGetCalendarObjectByUID ()
	@depends testCreateCalendarObject More...
	testUpdateCalendarObject ()
	@depends testCreateCalendarObject More...
	testDeleteCalendarObject ()
	@depends testCreateCalendarObject More...
	testCalendarQueryNoResult ()
	testCalendarQueryTodo ()
	testCalendarQueryTodoNotMatch ()
	testCalendarQueryNoFilter ()
	testCalendarQueryTimeRange ()
	testCalendarQueryTimeRangeNoEnd ()

Protected Attributes
	$pdo

Detailed Description

Definition at line 9 of file SimplePDOTest.php.

Member Function Documentation

setUp()

Sabre\CalDAV\Backend\SimplePDOTest::setUp

(

)

Definition at line 13 of file SimplePDOTest.php.

                     {
 
        if (!SABRE_HASSQLITE) $this->markTestSkipped('SQLite driver is not available');
 
        if (file_exists(SABRE_TEMPDIR . '/testdb.sqlite'))
            unlink(SABRE_TEMPDIR . '/testdb.sqlite');
 
        $pdo = new \PDO('sqlite:' . SABRE_TEMPDIR . '/testdb.sqlite');
        $pdo->setAttribute(\PDO::ATTR_ERRMODE, \PDO::ERRMODE_EXCEPTION);
 
        $pdo->exec(<<<SQL
CREATE TABLE simple_calendars (
    id INTEGER PRIMARY KEY ASC NOT NULL,
    uri TEXT NOT NULL,
    principaluri TEXT NOT NULL
)
SQL
        );
        $pdo->exec(<<<SQL
CREATE TABLE simple_calendarobjects (
    id INTEGER PRIMARY KEY ASC NOT NULL,
    calendarid INT UNSIGNED NOT NULL,
    uri TEXT NOT NULL,
    calendardata TEXT
);
SQL
        );
 
        $this->pdo = $pdo;
 
    }

References Sabre\CalDAV\Backend\SimplePDOTest\$pdo.

testCalendarQueryNoFilter()

Sabre\CalDAV\Backend\SimplePDOTest::testCalendarQueryNoFilter

(

)

Definition at line 362 of file SimplePDOTest.php.

                                         {
 
        $backend = new SimplePDO($this->pdo);
        $backend->createCalendarObject(1, "todo", "BEGIN:VCALENDAR\r\nBEGIN:VTODO\r\nEND:VTODO\r\nEND:VCALENDAR\r\n");
        $backend->createCalendarObject(1, "event", "BEGIN:VCALENDAR\r\nBEGIN:VEVENT\r\nDTSTART:20120101\r\nEND:VEVENT\r\nEND:VCALENDAR\r\n");
 
        $filters = [
            'name'           => 'VCALENDAR',
            'comp-filters'   => [],
            'prop-filters'   => [],
            'is-not-defined' => false,
            'time-range'     => null,
        ];
 
        $result = $backend->calendarQuery(1, $filters);
        $this->assertTrue(in_array('todo', $result));
        $this->assertTrue(in_array('event', $result));
 
    }

References $result.

testCalendarQueryNoResult()

Sabre\CalDAV\Backend\SimplePDOTest::testCalendarQueryNoResult

(

)

Definition at line 276 of file SimplePDOTest.php.

                                         {
 
        $abstract = new SimplePDO($this->pdo);
        $filters = [
            'name'         => 'VCALENDAR',
            'comp-filters' => [
                [
                    'name'           => 'VJOURNAL',
                    'comp-filters'   => [],
                    'prop-filters'   => [],
                    'is-not-defined' => false,
                    'time-range'     => null,
                ],
            ],
            'prop-filters'   => [],
            'is-not-defined' => false,
            'time-range'     => null,
        ];
 
        $this->assertEquals([
        ], $abstract->calendarQuery(1, $filters));
 
    }

testCalendarQueryTimeRange()

Sabre\CalDAV\Backend\SimplePDOTest::testCalendarQueryTimeRange

(

)

Definition at line 382 of file SimplePDOTest.php.

                                          {
 
        $backend = new SimplePDO($this->pdo);
        $backend->createCalendarObject(1, "todo", "BEGIN:VCALENDAR\r\nBEGIN:VTODO\r\nEND:VTODO\r\nEND:VCALENDAR\r\n");
        $backend->createCalendarObject(1, "event", "BEGIN:VCALENDAR\r\nBEGIN:VEVENT\r\nDTSTART;VALUE=DATE:20120101\r\nEND:VEVENT\r\nEND:VCALENDAR\r\n");
        $backend->createCalendarObject(1, "event2", "BEGIN:VCALENDAR\r\nBEGIN:VEVENT\r\nDTSTART;VALUE=DATE:20120103\r\nEND:VEVENT\r\nEND:VCALENDAR\r\n");
 
        $filters = [
            'name'         => 'VCALENDAR',
            'comp-filters' => [
                [
                    'name'           => 'VEVENT',
                    'comp-filters'   => [],
                    'prop-filters'   => [],
                    'is-not-defined' => false,
                    'time-range'     => [
                        'start' => new \DateTime('20120103'),
                        'end'   => new \DateTime('20120104'),
                    ],
                ],
            ],
            'prop-filters'   => [],
            'is-not-defined' => false,
            'time-range'     => null,
        ];
 
        $this->assertEquals([
            "event2",
        ], $backend->calendarQuery(1, $filters));
 
    }

testCalendarQueryTimeRangeNoEnd()

Sabre\CalDAV\Backend\SimplePDOTest::testCalendarQueryTimeRangeNoEnd

(

)

Definition at line 413 of file SimplePDOTest.php.

                                               {
 
        $backend = new SimplePDO($this->pdo);
        $backend->createCalendarObject(1, "todo", "BEGIN:VCALENDAR\r\nBEGIN:VTODO\r\nEND:VTODO\r\nEND:VCALENDAR\r\n");
        $backend->createCalendarObject(1, "event", "BEGIN:VCALENDAR\r\nBEGIN:VEVENT\r\nDTSTART:20120101\r\nEND:VEVENT\r\nEND:VCALENDAR\r\n");
        $backend->createCalendarObject(1, "event2", "BEGIN:VCALENDAR\r\nBEGIN:VEVENT\r\nDTSTART:20120103\r\nEND:VEVENT\r\nEND:VCALENDAR\r\n");
 
        $filters = [
            'name'         => 'VCALENDAR',
            'comp-filters' => [
                [
                    'name'           => 'VEVENT',
                    'comp-filters'   => [],
                    'prop-filters'   => [],
                    'is-not-defined' => false,
                    'time-range'     => [
                        'start' => new \DateTime('20120102'),
                        'end'   => null,
                    ],
                ],
            ],
            'prop-filters'   => [],
            'is-not-defined' => false,
            'time-range'     => null,
        ];
 
        $this->assertEquals([
            "event2",
        ], $backend->calendarQuery(1, $filters));
 
    }

testCalendarQueryTodo()

Sabre\CalDAV\Backend\SimplePDOTest::testCalendarQueryTodo

(

)

Definition at line 300 of file SimplePDOTest.php.

                                     {
 
        $backend = new SimplePDO($this->pdo);
        $backend->createCalendarObject(1, "todo", "BEGIN:VCALENDAR\r\nBEGIN:VTODO\r\nEND:VTODO\r\nEND:VCALENDAR\r\n");
        $backend->createCalendarObject(1, "event", "BEGIN:VCALENDAR\r\nBEGIN:VEVENT\r\nDTSTART:20120101\r\nEND:VEVENT\r\nEND:VCALENDAR\r\n");
 
        $filters = [
            'name'         => 'VCALENDAR',
            'comp-filters' => [
                [
                    'name'           => 'VTODO',
                    'comp-filters'   => [],
                    'prop-filters'   => [],
                    'is-not-defined' => false,
                    'time-range'     => null,
                ],
            ],
            'prop-filters'   => [],
            'is-not-defined' => false,
            'time-range'     => null,
        ];
 
        $this->assertEquals([
            "todo",
        ], $backend->calendarQuery(1, $filters));
 
    }

testCalendarQueryTodoNotMatch()

Sabre\CalDAV\Backend\SimplePDOTest::testCalendarQueryTodoNotMatch

(

)

Definition at line 327 of file SimplePDOTest.php.

                                             {
 
        $backend = new SimplePDO($this->pdo);
        $backend->createCalendarObject(1, "todo", "BEGIN:VCALENDAR\r\nBEGIN:VTODO\r\nEND:VTODO\r\nEND:VCALENDAR\r\n");
        $backend->createCalendarObject(1, "event", "BEGIN:VCALENDAR\r\nBEGIN:VEVENT\r\nDTSTART:20120101\r\nEND:VEVENT\r\nEND:VCALENDAR\r\n");
 
        $filters = [
            'name'         => 'VCALENDAR',
            'comp-filters' => [
                [
                    'name'         => 'VTODO',
                    'comp-filters' => [],
                    'prop-filters' => [
                        [
                            'name'           => 'summary',
                            'text-match'     => null,
                            'time-range'     => null,
                            'param-filters'  => [],
                            'is-not-defined' => false,
                        ],
                    ],
                    'is-not-defined' => false,
                    'time-range'     => null,
                ],
            ],
            'prop-filters'   => [],
            'is-not-defined' => false,
            'time-range'     => null,
        ];
 
        $this->assertEquals([
        ], $backend->calendarQuery(1, $filters));
 
    }

testConstruct()

Sabre\CalDAV\Backend\SimplePDOTest::testConstruct

(

)

Definition at line 45 of file SimplePDOTest.php.

                             {
 
        $backend = new SimplePDO($this->pdo);
        $this->assertTrue($backend instanceof SimplePDO);
 
    }

testCreateCalendarAndFetch()

Sabre\CalDAV\Backend\SimplePDOTest::testCreateCalendarAndFetch

(

)

@depends testConstruct

Definition at line 66 of file SimplePDOTest.php.

                                          {
 
        $backend = new SimplePDO($this->pdo);
        $returnedId = $backend->createCalendar('principals/user2', 'somerandomid', [
            '{urn:ietf:params:xml:ns:caldav}supported-calendar-component-set' => new CalDAV\Xml\Property\SupportedCalendarComponentSet(['VEVENT']),
            '{DAV:}displayname'                                               => 'Hello!',
            '{urn:ietf:params:xml:ns:caldav}schedule-calendar-transp'         => new CalDAV\Xml\Property\ScheduleCalendarTransp('transparent'),
        ]);
        $calendars = $backend->getCalendarsForUser('principals/user2');
 
        $elementCheck = [
            'uri' => 'somerandomid',
        ];
 
        $this->assertInternalType('array', $calendars);
        $this->assertEquals(1, count($calendars));
 
        foreach ($elementCheck as $name => $value) {
 
            $this->assertArrayHasKey($name, $calendars[0]);
            $this->assertEquals($value, $calendars[0][$name]);
 
        }
 
    }

References $name.

testCreateCalendarObject()

Sabre\CalDAV\Backend\SimplePDOTest::testCreateCalendarObject

(

)

Definition at line 134 of file SimplePDOTest.php.

                                        {
 
        $backend = new SimplePDO($this->pdo);
        $returnedId = $backend->createCalendar('principals/user2', 'somerandomid', []);
 
        $object = "BEGIN:VCALENDAR\r\nBEGIN:VEVENT\r\nDTSTART;VALUE=DATE:20120101\r\nEND:VEVENT\r\nEND:VCALENDAR\r\n";
 
        $backend->createCalendarObject($returnedId, 'random-id', $object);
 
        $result = $this->pdo->query('SELECT calendardata FROM simple_calendarobjects WHERE uri = "random-id"');
        $this->assertEquals([
            'calendardata' => $object,
        ], $result->fetch(\PDO::FETCH_ASSOC));
 
    }

References $result.

testDeleteCalendar()

Sabre\CalDAV\Backend\SimplePDOTest::testDeleteCalendar

(

)

@depends testCreateCalendarAndFetch

Definition at line 119 of file SimplePDOTest.php.

                                  {
 
        $backend = new SimplePDO($this->pdo);
        $returnedId = $backend->createCalendar('principals/user2', 'somerandomid', [
            '{urn:ietf:params:xml:ns:caldav}supported-calendar-component-set' => new CalDAV\Xml\Property\SupportedCalendarComponentSet(['VEVENT']),
            '{DAV:}displayname'                                               => 'Hello!',
        ]);
 
        $backend->deleteCalendar($returnedId);
 
        $calendars = $backend->getCalendarsForUser('principals/user2');
        $this->assertEquals([], $calendars);
 
    }

testDeleteCalendarObject()

Sabre\CalDAV\Backend\SimplePDOTest::testDeleteCalendarObject

(

)

@depends testCreateCalendarObject

Definition at line 261 of file SimplePDOTest.php.

                                        {
 
        $backend = new SimplePDO($this->pdo);
        $returnedId = $backend->createCalendar('principals/user2', 'somerandomid', []);
 
        $object = "BEGIN:VCALENDAR\r\nBEGIN:VEVENT\r\nDTSTART;VALUE=DATE:20120101\r\nEND:VEVENT\r\nEND:VCALENDAR\r\n";
        $backend->createCalendarObject($returnedId, 'random-id', $object);
        $backend->deleteCalendarObject($returnedId, 'random-id');
 
        $data = $backend->getCalendarObject($returnedId, 'random-id');
        $this->assertNull($data);
 
    }

References $data.

testGetCalendarObjectByUID()

Sabre\CalDAV\Backend\SimplePDOTest::testGetCalendarObjectByUID

(

)

@depends testCreateCalendarObject

Definition at line 218 of file SimplePDOTest.php.

                                          {
 
        $backend = new SimplePDO($this->pdo);
        $returnedId = $backend->createCalendar('principals/user2', 'somerandomid', []);
 
        $object = "BEGIN:VCALENDAR\r\nBEGIN:VEVENT\r\nUID:foo\r\nDTSTART;VALUE=DATE:20120101\r\nEND:VEVENT\r\nEND:VCALENDAR\r\n";
        $backend->createCalendarObject($returnedId, 'random-id', $object);
 
        $this->assertNull(
            $backend->getCalendarObjectByUID('principals/user2', 'bar')
        );
        $this->assertEquals(
            'somerandomid/random-id',
            $backend->getCalendarObjectByUID('principals/user2', 'foo')
        );
 
    }

testGetCalendarObjects()

Sabre\CalDAV\Backend\SimplePDOTest::testGetCalendarObjects

(

)

@depends testCreateCalendarObject

Definition at line 197 of file SimplePDOTest.php.

                                      {
 
        $backend = new SimplePDO($this->pdo);
        $returnedId = $backend->createCalendar('principals/user2', 'somerandomid', []);
 
        $object = "BEGIN:VCALENDAR\r\nBEGIN:VEVENT\r\nDTSTART;VALUE=DATE:20120101\r\nEND:VEVENT\r\nEND:VCALENDAR\r\n";
        $backend->createCalendarObject($returnedId, 'random-id', $object);
 
        $data = $backend->getCalendarObjects($returnedId);
 
        $this->assertEquals(1, count($data));
        $data = $data[0];
 
        $this->assertEquals('random-id', $data['uri']);
        $this->assertEquals(strlen($object), $data['size']);
 
    }

References $data.

testGetCalendarsForUserNoCalendars()

Sabre\CalDAV\Backend\SimplePDOTest::testGetCalendarsForUserNoCalendars

(

)

@depends testConstruct

Definition at line 55 of file SimplePDOTest.php.

                                                  {
 
        $backend = new SimplePDO($this->pdo);
        $calendars = $backend->getCalendarsForUser('principals/user2');
        $this->assertEquals([], $calendars);
 
    }

testGetMultipleObjects()

Sabre\CalDAV\Backend\SimplePDOTest::testGetMultipleObjects

(

)

Definition at line 149 of file SimplePDOTest.php.

                                      {
 
        $backend = new SimplePDO($this->pdo);
        $returnedId = $backend->createCalendar('principals/user2', 'somerandomid', []);
 
        $object = "BEGIN:VCALENDAR\r\nBEGIN:VEVENT\r\nDTSTART;VALUE=DATE:20120101\r\nEND:VEVENT\r\nEND:VCALENDAR\r\n";
 
        $backend->createCalendarObject($returnedId, 'id-1', $object);
        $backend->createCalendarObject($returnedId, 'id-2', $object);
 
        $check = [
            [
                'id'           => 1,
                'etag'         => '"' . md5($object) . '"',
                'uri'          => 'id-1',
                'size'         => strlen($object),
                'calendardata' => $object,
            ],
            [
                'id'           => 2,
                'etag'         => '"' . md5($object) . '"',
                'uri'          => 'id-2',
                'size'         => strlen($object),
                'calendardata' => $object,
            ],
        ];
 
        $result = $backend->getMultipleCalendarObjects($returnedId, ['id-1', 'id-2']);
 
        foreach ($check as $index => $props) {
 
            foreach ($props as $key => $value) {
 
                if ($key !== 'lastmodified') {
                    $this->assertEquals($value, $result[$index][$key]);
                } else {
                    $this->assertTrue(isset($result[$index][$key]));
                }
 
            }
 
        }
 
    }

References $index, $key, and $result.

testUpdateCalendarAndFetch()

Sabre\CalDAV\Backend\SimplePDOTest::testUpdateCalendarAndFetch

(

)

@depends testConstruct

Definition at line 95 of file SimplePDOTest.php.

                                          {
 
        $backend = new SimplePDO($this->pdo);
 
        //Creating a new calendar
        $newId = $backend->createCalendar('principals/user2', 'somerandomid', []);
 
        $propPatch = new PropPatch([
            '{DAV:}displayname'                                       => 'myCalendar',
            '{urn:ietf:params:xml:ns:caldav}schedule-calendar-transp' => new CalDAV\Xml\Property\ScheduleCalendarTransp('transparent'),
        ]);
 
        // Updating the calendar
        $backend->updateCalendar($newId, $propPatch);
        $result = $propPatch->commit();
 
        // Verifying the result of the update
        $this->assertFalse($result);
 
    }

References $result.

testUpdateCalendarObject()

Sabre\CalDAV\Backend\SimplePDOTest::testUpdateCalendarObject

(

)

@depends testCreateCalendarObject

Definition at line 239 of file SimplePDOTest.php.

                                        {
 
        $backend = new SimplePDO($this->pdo);
        $returnedId = $backend->createCalendar('principals/user2', 'somerandomid', []);
 
        $object = "BEGIN:VCALENDAR\r\nBEGIN:VEVENT\r\nDTSTART;VALUE=DATE:20120101\r\nEND:VEVENT\r\nEND:VCALENDAR\r\n";
        $object2 = "BEGIN:VCALENDAR\r\nBEGIN:VEVENT\r\nDTSTART;VALUE=DATE:20130101\r\nEND:VEVENT\r\nEND:VCALENDAR\r\n";
        $backend->createCalendarObject($returnedId, 'random-id', $object);
        $backend->updateCalendarObject($returnedId, 'random-id', $object2);
 
        $data = $backend->getCalendarObject($returnedId, 'random-id');
 
        $this->assertEquals($object2, $data['calendardata']);
        $this->assertEquals('random-id', $data['uri']);
 
 
    }

References $data.

Field Documentation

$pdo

Sabre\CalDAV\Backend\SimplePDOTest::$pdo

protected

Definition at line 11 of file SimplePDOTest.php.

Referenced by Sabre\CalDAV\Backend\SimplePDOTest\setUp().

---

The documentation for this class was generated from the following file:

• libs/composer/vendor/sabre/dav/tests/Sabre/CalDAV/Backend/SimplePDOTest.php