WebHare internals

• Writing documentation
• Profiling
• CLI guidelines
• WebHare bootstrap
• Events
• WebHare Connect
• Escrow documentation
• The WebHare database

whdb

• MACRO BeginWHDBWork(INTEGER trans)
  

  Begin work (physical writable transaction) in an auto transaction

• MACRO BindWHDBMetaTables(INTEGER whdbtrans)
  

  Bind the WebHare database metadata tables

• MACRO CloseWHDBAutoTransaction(INTEGER trans)
  

  Close an auto transaction

• RECORD ARRAY FUNCTION CommitWHDBTransaction(INTEGER transid)
  

  Commit a WebHare database transaction

• RECORD ARRAY FUNCTION CommitWHDBWork(INTEGER trans)
  

  Commit changes made inside a work block after BeginWHDBWork

• STRING FUNCTION CreatePasswordHash(STRING pwd)
  

  Hash a password

• INTEGER FUNCTION GetWHDBBlobInternalId(BLOB blb)
  

  Get the internal blob id from the database

• INTEGER FUNCTION GetWHDBRoleId(INTEGER transid, STRING rolename)
  

  Returns the ID of a role

• INTEGER FUNCTION GetWHDBTableId(TABLE tbl)
  

  Retrieve the table id for a bound table

• OBJECT FUNCTION GetWHDBTransaction(INTEGER trans)
• RECORD ARRAY FUNCTION GetWHDBTransactionErrors(INTEGER transid)
  

  Get any errors so far

• SCHEMA information_schema
• BOOLEAN FUNCTION IsWHDBConnectionAlive()
• BOOLEAN FUNCTION IsWHDBRoleEnabled(INTEGER transid, STRING rolename)
  

  Check whether a role is enabled for a transaction

• BOOLEAN FUNCTION IsWHDBWorkOpen(INTEGER trans)
  

  Test whether work is currently open on an auto transaction

• INTEGER FUNCTION MakeWHDBAutoNumber(TABLE gettable, STRING columnname)
  

  Get the next autonumber ID for a table

• MACRO ReconnectAllWHDBTransactions()
• MACRO RollbackWHDBTransaction(INTEGER transid)
  

  Rollback a WebHare database transaction

• MACRO RollbackWHDBWork(INTEGER trans)
  

  Rollback changes made inside a work block after BeginWHDBWork

• RECORD ARRAY FUNCTION SendWHDBCommand(INTEGER transid, STRING cmd)
  

  Send raw SQL commands to the WHDB

• BOOLEAN FUNCTION VerifyPasswordHash(STRING pwd, STRING hash)
  

  Verify a password against a stored hash

• BOOLEAN FUNCTION WHDBColumnExists(STRING tablename, STRING columnname)
  

  Check if a column exists

• BOOLEAN FUNCTION WHDBIndexExists(STRING tablename, STRING indexname)
  

  Check if an index exists

• BOOLEAN FUNCTION WHDBSchemaExists(STRING schemaname)
  

  Check if a schema exists