Writer Mode Specification

The writer allows the user to specify a writer mode, which determines what database command should be issued for each feature received.

Valid writer modes are INSERT, UPDATE and DELETE.

Writer Modes

INSERT	UPDATE	DELETE
The attribute values of each received feature that match a property in the destination Google Maps Engine table schema are written as a new feature in the Google Maps Engine table. Attributes on the feature that are not present on the table’s schema are ignored.	The attribute values of each received feature are used to update existing records in a Google Maps Engine table. Incoming features must have a primary key attribute. Primary key values should match the value of the target features in the Google Maps Engine table. If the Update Geometry writer parameter is selected, updated features will have their geometries replaced. Note that this means that features with null geometry will result in the removal of the geometry on the corresponding feature on the Google Maps Engine table. The records that are updated are determined by the primary key attribute: fme_where is not supported.	Existing database records are selected for deletion using the same technique as in UPDATE mode. Non-ID fields are ignored.
Note: If the primary key attribute is not provided, the Google Maps Engine Tables Writer will generate a unique identifier for each feature.	Note: Attempting to update using a nonexistent primary key value will not produce an error.	Note: Attempting to delete using a nonexistent primary key value will not produce an error.

INSERT

UPDATE

DELETE

The attribute values of each received feature that match a property in the destination Google Maps Engine table schema are written as a new feature in the Google Maps Engine table.

Attributes on the feature that are not present on the table’s schema are ignored.

The attribute values of each received feature are used to update existing records in a Google Maps Engine table. Incoming features must have a primary key attribute. Primary key values should match the value of the target features in the Google Maps Engine table.

If the Update Geometry writer parameter is selected, updated features will have their geometries replaced. Note that this means that features with null geometry will result in the removal of the geometry on the corresponding feature on the Google Maps Engine table. The records that are updated are determined by the primary key attribute: fme_where is not supported.

Existing database records are selected for deletion using the same technique as in UPDATE mode. Non-ID fields are ignored.

Note: If the primary key attribute is not provided, the Google Maps Engine Tables Writer will generate a unique identifier for each feature.

Note: Attempting to update using a nonexistent primary key value will not produce an error.

Note: Attempting to delete using a nonexistent primary key value will not produce an error.

Writer Mode Selection

The writer mode can be specified at the feature type level and at the feature level. The default writer mode is INSERT.

The writer mode may be specified on a per-feature basis using the fme_db_operation attribute. A warning is issued and the feature is skipped if the feature has an unsupported value for fme_db_operation, or if the value of fme_db_operation was UPDATE or DELETE when the writer created the table earlier in the translation.