WebHare internals

• Core development
• Writing documentation
• Profiling
• CLI guidelines
• WebHare bootstrap
• Events
• WebHare Connect
• The WebHare database
• Class names used by WebHare

whdb

• MACRO BeginWHDBWork(INTEGER trans)
  

  Begin work (physical writable transaction) in an auto transaction

• 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 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 IsWHDBWorkOpen(INTEGER trans)
  

  Test whether work is currently open on an auto transaction

• 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