PHP
Summary
Hello!
This is a short summary of my work during Google Summer of Code 2006.
The main idea of this post is to be a single repository for all the links I need to provide Google folks to make my work known.
For the other people reading this blog entry, my SoC 2006 proposal is described here.
Well the first thing to point is my blog, which, by the way, is the one you are reading right now. I tried to post on my blog a brief of every step I took to accomplish my work. However on the last weeks of the program I hadn't enough time to feed it with detailed information.
Writer has Learned new Tricks
MDB2_Schema_Writer now supports the new INSERT syntax and so the new additions: UPDATEs and DELETEs.
This is the last main modification for DML addition.
You can find the writer here.
Parsing one more level
Today I have added support for functions inside expressions and vice-versa into Parser.
Now we can do things like:
INSERT INTO Example
(foo, birthday, foolish) VALUES
('2', myfunc(('1' + '2')), ('3' + functionA('1', '2')));
UPDATE Example SET
foo='10',
foolish=(functionA('1', '2') + functionB('3', '4'))
WHERE (bar = lower('somestring'));
DELETE FROM Example WHERE (functionA('1', '2') + functionB('3', '4'));
Yes! Its Working!
The SQL generator is implemented (and ready for the function/expression recurssion, currently not supported by the parser) and working.
Using the example.php shipped with MDB2_Schema the following XML (non relevant part omitted)
<initialization>
<insert>
<field>
<name>foo</name>
<value>2</value>
</field>
<field>
<name>birthday</name>
<function>
New XML Parser
As the end of the program is approaching, I am focused on coding so I don't have many time left for feeding this blog. I am learning so much from PEAR that I would like to share with you but unfortunately I don't have time for that.
The parser now supports the new INSERT syntax and so the new additions: UPDATEs and DELETEs.
You can find the parser here.
Complete MDB XML Syntax
The complete MDB XML Syntax is now upped to MDB2_Schema Wiki.
XSD Part 2
We are approaching the final version of MDB2's XML Schema:
<!-- ROOT -->
<xsd:complexType name="database">
<xsd:sequence>
<xsd:element ref="name" maxOccurs="unbounded"/>
<xsd:element ref="create" minOccurs="0"/>
<xsd:element ref="overwrite" minOccurs="0"/>
<xsd:element ref="description" minOccurs="0"/>
<xsd:element ref="comments" minOccurs="0"/>
<xsd:element ref="table" maxOccurs="unbounded"/>
XSD Part 1
The first approach of MDB2's XML Schema Definition:
<xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<xsd:annotation>
<xsd:documentation xml:lang="en">
Schema for PEAR MDB2_Schema database files
</xsd:documentation>
</xsd:annotation>
<xsd:element name="comments">
<xsd:complexType mixed="true">
<xsd:sequence>
<xsd:element name="variable" type="xsd:string"/>
</xsd:sequence>
PHP QA GCOV Update
Since my last post I have progressed in the cron scripts so that the same configuration file can be used by PHP build scripts and the website to ease future maintenance. The build process also distinguishes between build failures and successes to run and update only the correct files. For example, if the build fails neither the PHP tests nor valgrind should be run since they depend on the build being a success.
I have created the structure for a database to track build times along with the number of errors, memory leaks (still subject to completion of the valgrind portion), test failures and warnings that occurred in the build process. This information will be useful for generating graphs based on a daily, weekly, monthly and/or yearly basis so that progress on each version can be seen graphically. This database will be further expanded to accept build information from other machines to help in locating and solving build problems that may occur in other system configurations.
XML Schema Based Format
Today I did some search at wikipedia about XML Schema files.
The most useful visited Links:
XML
Schema
XML Schema
XML Schema Definition
W3C XML Schema
Tomorow I will start writing the XML Schema for MDB2_Schema XML files.
