Support for parsing the CREATE TABLE SQL statement about php-sql-parser HOT 22 OPEN

I would like to have it too :-)

You can follow the progress on this issue on 
http://php-sql-parser.googlecode.com/svn/branches/create-table.
Let me some days to think about a solution.

Can you provide an example of your CREATE statements? If I implement all 
features of the MySQL statement, I will have to do till Xmas. Which feature 
subset would help you?

I tried it, and find useful - but I cant see other things, like "ENGINE", 
"CHARSET", "ROW_FORMAT" in case of showing create table, am I doing something 
wrong?

Not sure if i am not using the branch correctly but i still get the same result 
as with the main branch that does not support CREATE.

Lets say i have this create statement:

CREATE TABLE "cachetable01" (
  "sp_id" varchar(240) DEFAULT NULL,
  "ro" varchar(240) DEFAULT NULL,
  "balance" varchar(240) DEFAULT NULL,
  "last_cache_timestamp" varchar(25) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1

It would be awesome if i can just get the field names and the field attributes 
separated. 

I had started the branch during a travel by rail, but the CREATE TABLE support 
isn't finished yet. There were a lot of open problems.

The parser supports now 
CREATE [TEMPORARY] TABLE [IF NOT EXISTS] tbl_name LIKE old_tbl_name;
See r496. The LIKE must not set inset parenthesis.

Actually I can close the issue, we have CREATE TABLE support now .... LOL.

It's r502, I forgot to check-in a file.

r515 knows all the table options like ENGINE or CHARACTER SET.

r525 generates some column-def output for the example above. But there is still 
a lot to do.

Yesterday I had time to implement some things. The parser knows now datatypes 
and columns. There are some errors but the test cases for issue 33 should 
output some helpful thing.

I want to parse sql statements from sqlite_master.
They have de form:
CREATE TABLE turma(id text NOT NULL ,
nome text NOT NULL ,
nota1 int NOT NULL ,
nota2 int NOT NULL 
)

The current stable release does that?
I am getting the following error:
[06-Dec-2013 11:31:31] PHP Fatal error:  Uncaught exception 
'UnableToCalculatePositionException' with message 'cannot calculate position of 
id text NOT NULL within ' in 
/Applications/MAMP/htdocs/PHP-SQL-Parser/classes/position-calculator.php:188
Stack trace:
#0 
/Applications/MAMP/htdocs/PHP-SQL-Parser/classes/position-calculator.php(204): 
PositionCalculator->lookForBaseExpression('CREATE TABLE tu...', 101, Array, 0, 
Array)
#1 
/Applications/MAMP/htdocs/PHP-SQL-Parser/classes/position-calculator.php(204): 
PositionCalculator->lookForBaseExpression('CREATE TABLE tu...', 101, Array, 
'sub_tree', Array)
#2 
/Applications/MAMP/htdocs/PHP-SQL-Parser/classes/position-calculator.php(204): 
PositionCalculator->lookForBaseExpression('CREATE TABLE tu...', 101, Array, 
'create-def', Array)
#3 
/Applications/MAMP/htdocs/PHP-SQL-Parser/classes/position-calculator.php(204): 
PositionCalculator->lookForBaseExpression('CREATE TABLE tu...', 101, Array, 
'TABLE', Array)
#4 
/Applications/MAMP/htdocs/PHP-SQL-Parser/classes/position-calculator.php(71): 
PositionCalculator->lookFor in 
/Applications/MAMP/htdocs/PHP-SQL-Parser/classes/position-calculator.php on 
line 188

TIA
jcr

Hm, the issue has not been fixed. Try to disable the position calculator with 
$parser->parse($sql, false). I have not tested the CREATE statement with the 
position calculator, so there are possible problems.

@zzglider

I have to enhance the position calculator with the new ExpressionType 
constants. In your example the type "create-def" is not known within the 
calculator and results in a wrong output. For the CREATE TABLE statement I have 
defined a lot of new types, so after the parser is complete for CREATE TABLE, I 
will come back to the calculator.

Because the parser output still is not finished, it makes no sense to enhance 
the calculator now. Please wait some days or try to implement your own solution 
:-)

I have fixed some problems in r623, you can test CREATE TABLE statements in 
your client code. These things are open:

1. union keywords doesn't work
2. partition handling doesn't work
3. CREATE TABLE followed by SELECT doesn't work
4. PositionCalculator doesn't work with CREATE TABLE
5. Creator doesn't know CREATE TABLE statements

All other features should be okay. I would handle point 3 till 5 now, the other 
are a lot of work, they will be done on the next release.

Parser should now understand SELECT statements which follow a CREATE TABLE. See 
r631.

Parser can calculate the positions for CREATE TABLE statements now. See r725.

The current tag 2014-01-08 contains the point 3 till 5 (see comment #16). I'll 
start with partition handling soon.

Some PARTITION output is available in r988.

There are some problems within the partition-definition, don't use it at the 
moment. Partition-options should be fine.

The parser output for partitions and subpartitions have been finished. The 
parser can also calculate the string positions. The Creator can not build the 
clauses at the moment.

From the list above, we still have open the first point, the UNION keyword.