Added basic support for UNIX_TIMESTAMP() function:

• without arguments: returns current timestamp
• with single argument: transforms string representation of date/datetime to timestamp

Things could be done:

• add some checks for invalid values/formats
• add support for timezones
• support for floating point type of return value

  mysql> SELECT UNIX_TIMESTAMP('2015-11-13 10:20:19.012');
      -> 1447431619.012
  

Docs for function - MySQL 8.0 Reference Manual

Adds other public methods (rather than just prepare() to FakePdo)

The current master branch state of Psalm surfaces the following fails:

ERROR: ArgumentTypeCoercion - src/Parser/SQLLexer.php:24:13 - Argument 4 of preg_split expects int(0)|int(1)|int(2)|int(3)|int(4)|int(5)|int(6)|int(7), parent type positive-int provided (see https://psalm.dev/193)
            \PREG_SPLIT_DELIM_CAPTURE | \PREG_SPLIT_NO_EMPTY | \PREG_SPLIT_OFFSET_CAPTURE


ERROR: InvalidArgument - src/Parser/SQLLexer.php:32:44 - Argument 1 of Vimeo\MysqlEngine\Parser\SQLLexer::groupComments expects list<array{string, int}>, list<array{string, int}|string> provided (see https://psalm.dev/004)
            $tokens = $this->groupComments($tokens);


ERROR: InvalidArgument - src/Parser/SQLLexer.php:35:51 - Argument 1 of Vimeo\MysqlEngine\Parser\SQLLexer::groupEscapeSequences expects list<array{string, int}>, list<array{string, int}|string> provided (see https://psalm.dev/004)
            $tokens = $this->groupEscapeSequences($tokens);


ERROR: InvalidArgument - src/Parser/SQLLexer.php:37:41 - Argument 1 of Vimeo\MysqlEngine\Parser\SQLLexer::groupQuotedTokens expects list<array{string, int}>, list<array{string, int}|string> provided (see https://psalm.dev/004)
        return $this->groupQuotedTokens($tokens);

This branch does not resolve these, but also does not add new fails.

The CI for this project continues to fail since https://github.com/vimeo/php-mysql-engine/commit/144d67bd725e01ae9736e5632dc89cf9ffe87e0a, affecting #15 and #16.

These issues have been resolved in the latest version of Psalm, so updating the dependencies for this project will be successful.

Adds 2 new methods to function evaluator, INET_ATON and INET_NTOA

https://dev.mysql.com/doc/refman/8.0/en/miscellaneous-functions.html#function_inet-aton

Dear reviewer,

When you have a DateTime column and the value is empty a warning was raised.

The code first checks the string at position 0 then check if is "empty".

On PHP version <= 7.4 A warning is raised if you try to access [0] of an "Uninitialized" string and $foo = '' is an "Uninitialized" string 🤷‍♂️ .

(I haven't check if this behavior still exists on PHP >=8.0).

The change is just a small change in the order of an existing code.

The library is written for exception error handling (which is fine), but if any code treats it as generic PDO and calls errorInfo() things fall apart:

1. Native PDO code barfs rather annoying No error: PDO constructor was not called warning, that isn't easy to work around.
2. The return is null, rather than supposed three fields array structure.

Since the any real error would be an exception anyway, I stubbed the methods to hardcode a no-error state for anything that asks.

Not confident that is the way to go about it, but don't have a better idea. Open to explore alternative takes if there are any pointers. :)

CREATE TABLE `orders`
(
	`id` INTEGER(11) UNSIGNED NOT NULL AUTO_INCREMENT,
	`user_id` INTEGER(11) UNSIGNED,
	`price` INTEGER(11) UNSIGNED NOT NULL DEFAULT 0,
	`created_on`  timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
	`modified_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
	PRIMARY KEY (`id`)
)ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

Notice Error...

Notice Error: Uninitialized string offset: 0 in [/path/to/vendor/vimeo/php-mysql-engine/src/Parser/CreateTableParser.php, line 936]

PDO::ATTR_DEFAULT_FETCH_MODE is the key for setAttribute, not fetch_style. (https://www.php.net/manual/en/pdo.setattribute.php) The default for fetch_style is PDO::FETCH_BOTH, so set it. (https://www.php.net/manual/en/pdostatement.fetch.php) And I made it possible to set DEFAULT_FETCH_MODE with setAttribute. This allows we to omit the fetch argument.

Implement SHOW INDEX syntax. Set null for columns that depend on unimplemented processing. A value that is set to CreateIndex but not set to Index is set to null for the time being. Since Index->$column is a string array, it is necessary to change the type, and it was expected that the scale would increase.

Implement PDO::quote().

Why

We maintain a SQL template engine that depends on escaping with PDO::quote(). Currently we have this method in a class that inherits from FakePdo.

• promote truncate to clause, that also allows to use lowercase form truncate
• add optional form TRUNCATE TABLE <table name>
• add check for invalid $tokens array at TruncateParser::parse (ex. empty array), this could be helpful for direct usage of TruncateParser class (I don't know who will ever need this, but this is the way things should be done)
• add unit tests for TruncateParser class