/*
Licensed Materials - Property of IBM
DB2 Storage Engine Enablement
Copyright IBM Corporation 2007,2008
All rights reserved

Redistribution and use in source and binary forms, with or without modification,
are permitted provided that the following conditions are met: 
 (a) Redistributions of source code must retain this list of conditions, the
     copyright notice in section {d} below, and the disclaimer following this
     list of conditions. 
 (b) Redistributions in binary form must reproduce this list of conditions, the
     copyright notice in section (d) below, and the disclaimer following this
     list of conditions, in the documentation and/or other materials provided
     with the distribution. 
 (c) The name of IBM may not be used to endorse or promote products derived from
     this software without specific prior written permission. 
 (d) The text of the required copyright notice is: 
       Licensed Materials - Property of IBM
       DB2 Storage Engine Enablement 
       Copyright IBM Corporation 2007,2008 
       All rights reserved

THIS SOFTWARE IS PROVIDED BY IBM CORPORATION "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 IBM CORPORATION 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.
*/

#ifndef DB2I_MISC_H
#define DB2I_MISC_H
 
/**
  Undelimit quote-delimited DB2 names in-place
*/
void stripExtraQuotes(char* name, uint maxLen)
{
  char* oldName = (char*)sql_strdup(name);
  uint i = 0;
  uint j = 0;
  do
  {
    name[j] = oldName[i];
    if (oldName[i] == '"' && oldName[i+1] == '"')
      ++i;
  } while (++j < maxLen && oldName[++i]);
  
  if (j == maxLen)
    --j;
  name[j] = 0;
}

/**
  Convert a MySQL identifier name into a DB2 compatible format
  
  @parm input  The MySQL name
  @parm output  The DB2 name
  @parm outlen  The amount of space allocated for output
  @parm delimit  Should delimiting quotes be placed around the converted name?
  @parm delimitQuotes  Should quotes in the MySQL be delimited with additional quotes?
  
  @return FALSE if output was too small and name was truncated; TRUE otherwise
*/
bool convertMySQLNameToDB2Name(const char* input, 
                               char* output, 
                               size_t outlen,
                               bool delimit = true,
                               bool delimitQuotes = true)
{
  uint o = 0;
  if (delimit)
    output[o++] = '"';    

  uint i = 0;
  do
  {
    output[o] = input[i];
    if (delimitQuotes && input[i] == '"')
      output[++o] = '"';
  } while (++o < outlen-2 && input[++i]);
  
  if (delimit)
    output[o++] = '"';
  output[min(o, outlen-1)] = 0; // This isn't the most user-friendly way to handle overflows,
                                  // but at least its safe.
  return (o <= outlen-1);
}

bool isOrdinaryIdentifier(const char* s)
{
  while (*s)
  {
    if (my_isupper(system_charset_info, *s) ||
        my_isdigit(system_charset_info, *s) ||
        (*s == '_') ||
        (*s == '@') ||
        (*s == '$') ||
        (*s == '#') ||
        (*s == '"'))
      ++s;
    else
      return false;
  }
  return true;
}
  
#endif