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

Jump to: navigation, search
(saleQualification)
(saleQualification)
Line 4: Line 4:
  
 
=saleQualification=
 
=saleQualification=
*This function exists with OF 3.0+
+
*This procedure will be removed soon.
 +
*This procedure 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)
 
*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:
 
*Input parameters:
Line 10: Line 11:
 
**authenticationId (id of the user)
 
**authenticationId (id of the user)
 
**qualificationCost
 
**qualificationCost
 +
 +
=saleValidity=
 +
*This procedure exists with OF 3.0+
 +
*Stored procedure to create account entries and update validity expire date of an user (or add validity to the user if it doesn't exist)
 +
*Input parameters:
 +
**validityId (id of the qualification)
 +
**authenticationId (id of the user)
 +
**validityCost
  
 
=stripChars=
 
=stripChars=

Revision as of 10:43, 21 January 2011

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

  • This procedure will be removed soon.
  • This procedure 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)
    • qualificationCost

saleValidity

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

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)