1:  2:  3:  4:  5:  6:  7:  8:  9: 10: 11: 12: 13: 14: 15: 16: 17: 18: 19: 20: 21: 22: 23: 24: 25: 26: 27: 28: 29: 30: 31: 32: 33: 34: 35: 36: 37: 38: 39: 40: 41: 42: 43: 44: 45: 46: 47: 48: 49: 50: 51: 52: 53: 54: 

<?php

    namespace CzProject\SqlGenerator;


    class Helpers
    {
        public function __construct()
        {
            throw new StaticClassException('This is static class.');
        }


        /**
         * @param  mixed
         * @return string
         * @throws Exception
         * @see    https://api.dibiphp.com/3.0/source-Dibi.Translator.php.html#174
         */
        public static function formatValue($value, IDriver $driver)
        {
            if (is_string($value)) {
                return $driver->escapeText($value);

            } elseif (is_int($value)) {
                return (string) $value;

            } elseif (is_float($value)) {
                return rtrim(rtrim(number_format($value, 10, '.', ''), '0'), '.');

            } elseif (is_bool($value)) {
                return $driver->escapeBool($value);

            } elseif ($value === NULL) {
                return 'NULL';

            } elseif ($value instanceof \DateTime || $value instanceof \DateTimeInterface) {
                return $driver->escapeDateTime($value);
            }

            throw new InvalidArgumentException("Unsupported value type.");
        }


        /**
         * @param  string
         * @return string
         */
        public static function normalizeNewLines($s)
        {
            return str_replace(array("\r\n", "\r"), "\n", $s);
        }
    }