All Downloads are FREE. Search and download functionalities are using the official Maven repository.

com.ning.billing.account.dao.IFieldStoreDao.sql.stg Maven / Gradle / Ivy

group IFieldStoreDao;

createFields() ::= <<
  INSERT INTO custom_fields(id, object_id, object_type, field_name, field_value)
  VALUES (:idAsString, :objectId, :objectType, :name, :value);
>>

saveFields() ::= <<
    UPDATE custom_fields
    SET object_type = :objectType, object_id = :objectId, field_name = :name, field_value = :value
    WHERE id = :id;
>>

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

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





© 2015 - 2025 Weber Informatics LLC | Privacy Policy