<?php

/**
 * Simple function to replicate PHP 5 behaviour
 */
function microtime_float()
{
    list($usec, $sec) = explode(" ", microtime());
    return ((float)$usec + (float)$sec);
}

/**
 * Prepare user input for use in a database query, preventing SQL injection attacks.
 */
function db_escape_string($text) {
  return mysql_escape_string($text);
}

define('DB_QUERY_REGEXP', '/(%d|%s|%S|%%|%f|%b|%I)/');

function _db_query_callback($match, $init = FALSE) {
  static $args = NULL;
  if ($init) {
    $args = $match;
    return;
  }

  switch ($match[1]) {
    case '%d': // We must use type casting to int to convert FALSE/NULL/(TRUE?)
      return (int) array_shift($args); // We don't need db_escape_string as numbers are db-safe
    case '%s':
      return db_escape_string(array_shift($args));
    case '%%':
      return '%';
    case '%f':
      return (float) array_shift($args);
    case '%b': // binary data
      return db_encode_blob(array_shift($args));
    case '%S':
      // A list of strings. Use tab , ; and : as tokenizing characters.
      $tok = strtok(array_shift($args), "\t,;:");
      $ret = array();
      while ($tok !== FALSE) {
          $ret[] = db_escape_string($tok);
          $tok = strtok("\t,;:");
      }
      return implode("','", $ret);
    case '%I':
      // Use only comma as tokenizing character
      $list = explode(',',array_shift($args));
      foreach ($list as $key => $val) {
          $list[$key] = db_escape_string($val);
      }
      return implode("','", $list);
  }
}

function db_query_dummy($query) {
  $args = func_get_args();
  array_shift($args);
  if (isset($args[0]) and is_array($args[0])) { // 'All arguments in one array' syntax
    $args = $args[0];
  }
  _db_query_callback($args, TRUE);
  $query = preg_replace_callback(DB_QUERY_REGEXP, '_db_query_callback', $query);
  return $query;
}


$t1 = $t2 = $t3 = $t4 = 0.0;

//$args = array('blog');
//$args = array('story', 'page', 'blog');
$args = array('story', 'page', 'blog', 'xxx', 'yyy', 'zzz', 'rrr', 'aaaaa', 'bbbb', 'cccc', 'wewqeqwewqwe');

echo("\n". db_query_dummy('SELECT * FROM {node} WHERE type IN('.implode(',', array_fill(0, count($args), "'%s'")).')', $args));
echo("\n". db_query_dummy("SELECT * FROM {node} WHERE type IN('%S')", implode(',', $args)));
echo("\n". db_query_dummy("SELECT * FROM {node} WHERE type IN('%I')", implode(',', $args)));
echo("\n");

for ($i = 0; $i < 1000; ++$i) {
  $time_start = microtime_float();
  for ($j = 0; $j < 200; ++$j) {
    db_query_dummy('SELECT * FROM {node} WHERE type IN('.implode(',', array_fill(0, count($args), "'%s'")).')', $args);
  }
  $time_end = microtime_float();
  $t1 += $time_end - $time_start;

  $time_start = microtime_float();
  for ($j = 0; $j < 200; ++$j) {
    db_query_dummy("SELECT * FROM {node} WHERE type IN('%S')", implode(',', $args));
  }
  $time_end = microtime_float();
  $t2 += $time_end - $time_start;

  $time_start = microtime_float();
  for ($j = 0; $j < 200; ++$j) {
    db_query_dummy("SELECT * FROM {node} WHERE type IN('%I')", implode(',', $args));
  }
  $time_end = microtime_float();
  $t3 += $time_end - $time_start;

}

echo ("t1: $t1, t2: $t2, t3: $t3 where num args is ".count($args)."\n");