PDO
extends AbstractBackend
in package
implements
SyncSupport
PDO CardDAV backend.
This CardDAV backend uses PDO to store addressbooks
Tags
Interfaces, Classes and Traits
- SyncSupport
- WebDAV-sync support for CardDAV backends.
Table of Contents
- $addressBookChangesTableName : string
- The table name that will be used for tracking changes in address books.
- $addressBooksTableName : mixed
- The PDO table name used to store addressbooks.
- $cardsTableName : mixed
- The PDO table name used to store cards.
- $pdo : PDO
- PDO connection.
- __construct() : mixed
- Sets up the object.
- createAddressBook() : int
- Creates a new address book.
- createCard() : string|null
- Creates a new card.
- deleteAddressBook() : mixed
- Deletes an entire addressbook and all its contents.
- deleteCard() : bool
- Deletes a card.
- getAddressBooksForUser() : array<string|int, mixed>
- Returns the list of addressbooks for a specific user.
- getCard() : array<string|int, mixed>
- Returns a specific card.
- getCards() : array<string|int, mixed>
- Returns all cards for a specific addressbook id.
- getChangesForAddressBook() : array<string|int, mixed>
- The getChanges method returns all the changes that have happened, since the specified syncToken in the specified address book.
- getMultipleCards() : array<string|int, mixed>
- Returns a list of cards.
- updateAddressBook() : mixed
- Updates properties for an address book.
- updateCard() : string|null
- Updates a card.
- addChange() : mixed
- Adds a change record to the addressbookchanges table.
Properties
$addressBookChangesTableName
The table name that will be used for tracking changes in address books.
public
string
$addressBookChangesTableName
= 'addressbookchanges'
$addressBooksTableName
The PDO table name used to store addressbooks.
public
mixed
$addressBooksTableName
= 'addressbooks'
$cardsTableName
The PDO table name used to store cards.
public
mixed
$cardsTableName
= 'cards'
$pdo
PDO connection.
protected
PDO
$pdo
Methods
__construct()
Sets up the object.
public
__construct(PDO $pdo) : mixed
Parameters
- $pdo : PDO
Return values
mixed —createAddressBook()
Creates a new address book.
public
createAddressBook(string $principalUri, string $url, array<string|int, mixed> $properties) : int
Parameters
- $principalUri : string
- $url : string
-
just the 'basename' of the url
- $properties : array<string|int, mixed>
Return values
int —Last insert id
createCard()
Creates a new card.
public
createCard(mixed $addressBookId, string $cardUri, string $cardData) : string|null
The addressbook id will be passed as the first argument. This is the same id as it is returned from the getAddressBooksForUser method.
The cardUri is a base uri, and doesn't include the full path. The cardData argument is the vcard body, and is passed as a string.
It is possible to return an ETag from this method. This ETag is for the newly created resource, and must be enclosed with double quotes (that is, the string itself must contain the double quotes).
You should only return the ETag if you store the carddata as-is. If a subsequent GET request on the same card does not have the same body, byte-by-byte and you did return an ETag here, clients tend to get confused.
If you don't return an ETag, you can just return null.
Parameters
- $addressBookId : mixed
- $cardUri : string
- $cardData : string
Return values
string|null —deleteAddressBook()
Deletes an entire addressbook and all its contents.
public
deleteAddressBook(int $addressBookId) : mixed
Parameters
- $addressBookId : int
Return values
mixed —deleteCard()
Deletes a card.
public
deleteCard(mixed $addressBookId, string $cardUri) : bool
Parameters
- $addressBookId : mixed
- $cardUri : string
Return values
bool —getAddressBooksForUser()
Returns the list of addressbooks for a specific user.
public
getAddressBooksForUser(string $principalUri) : array<string|int, mixed>
Parameters
- $principalUri : string
Return values
array<string|int, mixed> —getCard()
Returns a specific card.
public
getCard(mixed $addressBookId, string $cardUri) : array<string|int, mixed>
The same set of properties must be returned as with getCards. The only exception is that 'carddata' is absolutely required.
If the card does not exist, you must return false.
Parameters
- $addressBookId : mixed
- $cardUri : string
Return values
array<string|int, mixed> —getCards()
Returns all cards for a specific addressbook id.
public
getCards(mixed $addressbookId) : array<string|int, mixed>
This method should return the following properties for each card:
- carddata - raw vcard data
- uri - Some unique url
- lastmodified - A unix timestamp
It's recommended to also return the following properties:
- etag - A unique etag. This must change every time the card changes.
- size - The size of the card in bytes.
If these last two properties are provided, less time will be spent calculating them. If they are specified, you can also ommit carddata. This may speed up certain requests, especially with large cards.
Parameters
- $addressbookId : mixed
Return values
array<string|int, mixed> —getChangesForAddressBook()
The getChanges method returns all the changes that have happened, since the specified syncToken in the specified address book.
public
getChangesForAddressBook(string $addressBookId, string $syncToken, int $syncLevel[, int $limit = null ]) : array<string|int, mixed>
This function should return an array, such as the following:
[ 'syncToken' => 'The current synctoken', 'added' => [ 'new.txt', ], 'modified' => [ 'updated.txt', ], 'deleted' => [ 'foo.php.bak', 'old.txt' ] ];
The returned syncToken property should reflect the current syncToken of the addressbook, as reported in the {http://sabredav.org/ns}sync-token property. This is needed here too, to ensure the operation is atomic.
If the $syncToken argument is specified as null, this is an initial sync, and all members should be reported.
The modified property is an array of nodenames that have changed since the last token.
The deleted property is an array with nodenames, that have been deleted from collection.
The $syncLevel argument is basically the 'depth' of the report. If it's 1, you only have to report changes that happened only directly in immediate descendants. If it's 2, it should also include changes from the nodes below the child collections. (grandchildren)
The $limit argument allows a client to specify how many results should be returned at most. If the limit is not specified, it should be treated as infinite.
If the limit (infinite or not) is higher than you're willing to return, you should throw a Sabre\DAV\Exception\TooMuchMatches() exception.
If the syncToken is expired (due to data cleanup) or unknown, you must return null.
The limit is 'suggestive'. You are free to ignore it.
Parameters
- $addressBookId : string
- $syncToken : string
- $syncLevel : int
- $limit : int = null
Return values
array<string|int, mixed> —getMultipleCards()
Returns a list of cards.
public
getMultipleCards(mixed $addressBookId, array<string|int, mixed> $uris) : array<string|int, mixed>
This method should work identical to getCard, but instead return all the cards in the list as an array.
If the backend supports this, it may allow for some speed-ups.
Parameters
- $addressBookId : mixed
- $uris : array<string|int, mixed>
Return values
array<string|int, mixed> —updateAddressBook()
Updates properties for an address book.
public
updateAddressBook(string $addressBookId, PropPatch $propPatch) : mixed
The list of mutations is stored in a Sabre\DAV\PropPatch object. To do the actual updates, you must tell this object which properties you're going to process with the handle() method.
Calling the handle method is like telling the PropPatch object "I promise I can handle updating this property".
Read the PropPatch documentation for more info and examples.
Parameters
- $addressBookId : string
- $propPatch : PropPatch
Return values
mixed —updateCard()
Updates a card.
public
updateCard(mixed $addressBookId, string $cardUri, string $cardData) : string|null
The addressbook id will be passed as the first argument. This is the same id as it is returned from the getAddressBooksForUser method.
The cardUri is a base uri, and doesn't include the full path. The cardData argument is the vcard body, and is passed as a string.
It is possible to return an ETag from this method. This ETag should match that of the updated resource, and must be enclosed with double quotes (that is: the string itself must contain the actual quotes).
You should only return the ETag if you store the carddata as-is. If a subsequent GET request on the same card does not have the same body, byte-by-byte and you did return an ETag here, clients tend to get confused.
If you don't return an ETag, you can just return null.
Parameters
- $addressBookId : mixed
- $cardUri : string
- $cardData : string
Return values
string|null —addChange()
Adds a change record to the addressbookchanges table.
protected
addChange(mixed $addressBookId, string $objectUri, int $operation) : mixed
Parameters
- $addressBookId : mixed
- $objectUri : string
- $operation : int
-
1 = add, 2 = modify, 3 = delete