Download the PHP package matatirosoln/doctrine-filemaker-driver without Composer
On this page you can find all versions of the php package matatirosoln/doctrine-filemaker-driver. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
Download matatirosoln/doctrine-filemaker-driver
More information about matatirosoln/doctrine-filemaker-driver
Files in matatirosoln/doctrine-filemaker-driver
Package doctrine-filemaker-driver
Short Description Use FileMaker through CWP as your backend database
License MIT
Informations about the package doctrine-filemaker-driver
Doctrine FileMaker driver
A Doctrine driver to interact with FileMaker using the CWP API.
Installation
composer require matatirosoln/doctrine-filemaker-driver
Configuration
In your Doctrine configuration comment out
driver: xxxx
and replace it with
driver_class: MSDev\DoctrineFileMakerDriver\FMDriver
Conventions
-
Create a model to represent a FileMaker layout. Set the name of the layout as the model table.
/** * Keyword * * @Table(name="Keyword") * @Entity(repositoryClass="Repository\KeywordRepository") */ class Keyword
-
In your model create an id field which is mapped to the special rec_id pseudo field
/** * @var int * * @Column(name="rec_id", type="integer") */ private $id;
-
Create your 'actual' ID field, as used for relationships, as a separate property of your model. Set its GeneratedValue strategy to be
Custom
which will mean that Doctrie will wait for FM to assign that value - the assumption being that this is an auto-enter calc field (probaby Get(UUID)). You then need to specifiy the CustomIdGenerator and set this toMSDev\DoctrineFileMakerDriver\FMIdentityGenerator
so that the value is returned as a string./**
- @var string
- @Column(name="_pk_ClientID", type="string" length=255)
- @Id
- @GeneratedValue(strategy="CUSTOM")
- @CustomIdGenerator(class="MSDev\DoctrineFileMakerDriver\FMIdentityGenerator") */ private $uuid;
Alternatively you could generate the UUIDs in your model constructor (using for example ramsey/uuid). In this case you'd end up with something like
/** * @var string * * @Column(name="__pk_CanvasID", type="string", length=255) * @Id */ private $uuid; public function __construct() { $this->uuid = Uuid::uuid4()->toString(); }
-
Add other properties as required. To access related fields on your layout enclose the field name in single quotes in the column mapping.
/** * @var string * * @Column(name="'absCon::email'", type="string", length=255) */ private $contactEmail;
-
If you need access to the record modification ID you can add the special mod_id pseudo property
/** * @var int * * @Column(name="mod_id", type="integer") */ private $modId;
-
To access query metadata add a rec_meta pseudo property of type json_array
/** * @var array * * @Column(name="rec_meta", type="json_array") */ private $meta;
This will be populated with an array containing
[ 'found' => (int)$this->response->getFoundSetCount(), 'fetch' => (int)$this->response->getFetchCount(), 'total' => (int)$this->response->getTableRecordCount(), ]
Which you can then access from any record in your returned set.
Considerations
- Because of the way in which more 'conventional' databases handle relationships, there is no concept of a portal. To access related data create a corresponding model for that table (layout) and create standard Doctrine relationships (OneToOne, OneToMany, ManyToOne etc).
- If your model contains caclulation fields you will run into issues when trying to create a new record, since Doctrine will try and set those fields to null. One 'solution' to this is to create a 'stub' of your model which contains only the fields which are necesary to create a new record and to instantiate that for record creation. If you head down this route you'll likely want to create an interface which both your stub and your real entity implement so that you can typehint appropriately.
See also
This driver has been developed for use within Symfony applications (because that's what we do). The Doctrine FileMaker bundle includes this driver as well as creating services to access scripts, containers, valuelists and more.
All versions of doctrine-filemaker-driver with dependencies
doctrine/dbal Version 2.*
greenlion/php-sql-parser Version ^4.0
doctrine/orm Version 2.*
matatirosoln/filemaker-api Version ^15.0
guzzlehttp/guzzle Version ^6.2