acs-mail-lite-procs.xql

DB Query file

Related Files

[ hide source ] | [ make this the default ]

File Contents

<?xml version="1.0"?>
<queryset>

    <fullquery name="acs_mail_lite::sweeper.lock_queued_message">
        <querytext>
            update acs_mail_lite_queue
               set locking_server = :locking_server
             where message_id = :id
               and locking_server is NULL
        </querytext>
    </fullquery> 


    <fullquery name="acs_mail_lite::sweeper.delete_queue_entry">
        <querytext>
            delete from acs_mail_lite_queue
            where message_id=:id
        </querytext>
    </fullquery>

  <fullquery name="acs_mail_lite::send_immediately.get_file_info">
    <querytext>
      select r.mime_type, r.title, r.revision_id, i.name
      from cr_revisions r, cr_items i
      where r.revision_id = i.latest_revision
        and i.item_id in ([join $item_ids ","])
    </querytext>
  </fullquery>

   <fullquery name="acs_mail_lite::log_mail_sending.record_mail_sent">
     <querytext>

       update acs_mail_lite_mail_log
       set last_mail_date = current_timestamp
       where party_id = :user_id

     </querytext>
   </fullquery>

   <fullquery name="acs_mail_lite::log_mail_sending.insert_log_entry">
     <querytext>

       insert into acs_mail_lite_mail_log (party_id, last_mail_date)
       values (:user_id, current_timestamp)

     </querytext>
   </fullquery>   

</queryset>