Difference between revisions of "OpenFlyers SQL stored functions and procedures"

Jump to: navigation, search
(stripChars)
Line 3: Line 3:
 
This page is dedicated to list OpenFlyers SQL stored functions and procedures which are accessibles to OpenFlyers administrators via the SQL exports or imports.
 
This page is dedicated to list OpenFlyers SQL stored functions and procedures which are accessibles to OpenFlyers administrators via the SQL exports or imports.
  
 +
=saleQualification=
 +
*Thiis function exists with OF 3.0+
 +
*Stored procedure to create account entries and update qualification expire date of an user (or add qualification to the user if it doesn't exist)
 +
*Input parameters:
 +
**qualificationId (id of the qualification)
 +
**authenticationId (id of the user)
 
=stripChars=
 
=stripChars=
 
*This function exists with OF 3.0+
 
*This function exists with OF 3.0+

Revision as of 14:10, 22 December 2010

Presentation

This page is dedicated to list OpenFlyers SQL stored functions and procedures which are accessibles to OpenFlyers administrators via the SQL exports or imports.

saleQualification

  • Thiis function exists with OF 3.0+
  • Stored procedure to create account entries and update qualification expire date of an user (or add qualification to the user if it doesn't exist)
  • Input parameters:
    • qualificationId (id of the qualification)
    • authenticationId (id of the user)

stripChars

  • This function exists with OF 3.0+
  • Stored function to get a cleaned string (remove spaces and underscores)
  • Input parameters:
    • word (the string to be cleaned)
  • Output parameters:
    • stripWord (the string cleaned)

sumAccountEntry

  • This function exists with OF 2.1+
  • Stored function to compute the current balance of an account at a given date
  • Input parameters:
    • accountId (account Id)
    • endDate (to compute only account entries before this date)
  • Output parameters:
    • totalBalance (balance)