\LibMelanie\SqlSqlAttachmentRequests

Liste des requêtes SQL vers les pièces jointes

Summary

Methods
Properties
Constants
No public methods found
No public properties found
getNextAttachment
getAttachmentsList
getAttachmentData
insertAttachment
updateAttachment
deleteAttachment
No protected methods found
No protected properties found
N/A
No private methods found
No private properties found
N/A

Constants

getNextAttachment

getNextAttachment ="SELECT nextval('horde_vfs_seq') as vfs_id;" :string

getAttachmentsList

getAttachmentsList ="SELECT {fields_list} FROM horde_vfs WHERE {where_clause};" :string

getAttachmentData

getAttachmentData ="SELECT vfs_id, vfs_name, vfs_type, vfs_modified, vfs_owner, vfs_path, vfs_data FROM horde_vfs WHERE {where_clause};" :string

insertAttachment

insertAttachment ="INSERT INTO horde_vfs ({data_fields}) VALUES ({data_values});" :string

updateAttachment

updateAttachment ="UPDATE horde_vfs SET {attachment_set} WHERE {where_clause};" :string

deleteAttachment

deleteAttachment ="DELETE FROM horde_vfs WHERE {where_clause};" :string

Suppression d'un objet Mélanie2