FieldStoreDao.sql.stg

group IFieldStoreDao;

save() ::= <<
  INSERT INTO custom_fields(id, object_id, object_type, field_name, field_value)
  VALUES (:idAsString, :objectId, :objectType, :name, :value)
  ON DUPLICATE KEY UPDATE
    field_value = :value;
>>

load() ::= <<
    SELECT id, field_name, field_value
    FROM custom_fields
    WHERE object_id = :objectId AND object_type = :objectType;
>>

test() ::= <<
  SELECT 1 FROM custom_fields;
>>
;