security-procs-postgresql.xql

DB Query file

Related Files

[ hide source ] | [ make this the default ]

File Contents

<?xml version="1.0"?>

<queryset>
   <rdbms><type>postgresql</type><version>7.1</version></rdbms>

<fullquery name="ad_set_client_property.prop_update_dml">
      <querytext>
        update sec_session_properties
        set property_value = :value,
          secure_p = :secure,
          last_hit = :last_hit
        where session_id = :session_id and
          module = :module and
          property_name = :name
      </querytext>
</fullquery>

<fullquery name="ad_set_client_property.prop_upsert">
  <querytext>
    select sec_session_property__upsert(:session_id, :module, :name, :value, :secure, :last_hit) from dual
  </querytext>
</fullquery>

<fullquery name="sec_populate_secret_tokens_db.insert_random_token">
      <querytext>

	    insert into secret_tokens(token_id, token, token_timestamp)
	    values(nextval('t_sec_security_token_id_seq'), :random_token, now())

      </querytext>
</fullquery>


<fullquery name="sec_populate_secret_tokens_cache.get_secret_tokens">
      <querytext>

    select token_id, token
    from secret_tokens,
         (select cast(random() * count(*) - :num_tokens as integer) as first
            from secret_tokens) r
    where token_id >= r.first and r.first + :num_tokens > token_id

      </querytext>
</fullquery>

</queryset>