bmMetaDataObject.php

<?php
  /*
  * Copyright (c) 2009, "The Blind Mice Studio"
  * All rights reserved.
  * 
  * Redistribution and use in source and binary forms, with or without
  * modification, are permitted provided that the following conditions are met:
  * - Redistributions of source code must retain the above copyright
  *   notice, this list of conditions and the following disclaimer.
  * - Redistributions in binary form must reproduce the above copyright
  *   notice, this list of conditions and the following disclaimer in the
  *   documentation and/or other materials provided with the distribution.
  * - Neither the name of the "The Blind Mice Studio" nor the
  *   names of its contributors may be used to endorse or promote products
  *   derived from this software without specific prior written permission.

  * THIS SOFTWARE IS PROVIDED BY "The Blind Mice Studio" ''AS IS'' AND ANY
  * EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED
  * WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE
  * DISCLAIMED. IN NO EVENT SHALL "The Blind Mice Studio" BE LIABLE FOR ANY
  * DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES
  * (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES;
  * LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND
  * ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT
  * (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS
  * SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
  * 
  */

  class bmMetaDataObject extends bmDataObject
  {
    protected function prepareSQL() 
    {
      $dataLink = $this->application->dataLink;
      
      $fields = array();
      foreach ($this->map as $propertyName => $property) 
      {     
        $propertyValue = $this->properties[$propertyName];
        
        $value = $property['defaultValue'];
        if ($propertyValue !== 'NULL')
        {
          switch ($property['dataType']) 
          {
            case BM_VT_STRING:
            case BM_VT_TEXT:
              $value = "'" . $dataLink->formatInput($propertyValue) . "'";
            break;
            case BM_VT_INTEGER:
              $value = intval($propertyValue);
            break;
            case BM_VT_FLOAT:
              $value = floatval($propertyValue);
            break;
            case BM_VT_PASSWORD:
              $value = "'" . $dataLink->formatInput($propertyValue) . "'";
            break;
            case BM_VT_IMAGE:
              $value = "'" . $dataLink->formatInput($propertyValue) . "'";
            break;
            case BM_VT_FILE:
              $value = "'" . $dataLink->formatInput($propertyValue) . "'";
            break;
            case BM_VT_DATETIME:
              $value = "'" . $dataLink->formatInput($propertyValue) . "'";
            break;
          }
        }
        else
        {
          $value = 'NULL';
        }
        $fields[] = '`' . $property['fieldName'] . '` = ' . $value;
      }
      
      $fields = implode(',', $fields);
      $sql = "INSERT INTO `" . $this->objectName . "` SET " . $fields . " ON DUPLICATE KEY UPDATE " . $fields . ";";
      
      return $sql;
    }
  }

?>