Commit: 62fd440d223a3e561d74f88cea43810468d7c8d6
Author: Mark Lawrence <nomad@null.net> Tue, 19 Jun 2007 17:07:38 +0200
Moved Insert.pm, Select.pm... to Query/Insert.pm, Query/Select.pm.
Commit: 6ffd03a8805a131a387bcf10c4dc1b8a81367529
Author: Mark Lawrence <nomad@null.net> Tue, 19 Jun 2007 16:44:22 +0200
* Removed 'Changes' file from cogito/git control.
* INSERT, SELECT, UPDATE, DELETE all do something!
Commit: c760740570c2f8a5ceb4b1d602228512061df917
Author: Mark Lawrence <nomad@null.net> Mon, 18 Jun 2007 16:38:18 +0200
VERSION to 0.02
Commit: 0643a835dc2413e843a041019e41199a4dff04a0
Author: Mark Lawrence <nomad@null.net> Mon, 18 Jun 2007 16:34:48 +0200
New class SQL::DB to glue SQL::DB::Schema with DBI. Fully documented.
Commit: 85567556ec241b35b60903eb6670e6f716f596bc
Author: Mark Lawrence <nomad@null.net> Mon, 18 Jun 2007 16:31:13 +0200
* Column.pm now based on Class::Struct which removed some lines.
* Schema definition is now completely based on ARRAY REFs.
* new test: t/Column.t
* new 'NOT IN' expression method
* Queries now all use 'columns' method, better inheritance.
* new 'EXISTS' method for query objects.
* Schema.pm: row() has become arow() 'any', 'abstact', 'a' row.
* Schema.pm: query() replaced by select(), insert(), delete(), update()
Commit: 3832282a9e4c32bba39215e612127321890d9f3c
Author: Mark Lawrence <nomad@null.net> Fri, 15 Jun 2007 18:50:24 +0200
* SQL::API::* renamed to SQL::DB::*
* SQL::API.pm renamed to SQL::DB::Schema.pm
Commit: c2f52970463af8d00abed84602cf25941a07b7c0
Author: Mark Lawrence <nomad@null.net> Fri, 15 Jun 2007 18:29:43 +0200
* Lots of cleanups.
* Avoid memory leaks from circular references using Scalar::Util::weaken
in the right places.
* SELECT .... LIMIT
* Stringifcation for pretty printing/debugging.
Commit: 9b6517b3eb74d356cc3b061c8a7dc4c020b7bc86
Author: Mark Lawrence <nomad@null.net> Sat, 09 Jun 2007 23:50:08 +0200
Now have automatic joins (matching up reference keys with primary columns)
INSERT and SELECT probably good for 90% of queries.
Commit: 667303900595982625b062f3af20bbbac1804da7
Author: Mark Lawrence <nomad@null.net> Fri, 08 Jun 2007 01:51:04 +0200
Big documentation write-up for SQL::API.
Testing of the SQL::API interface almost complete. No tests yet
for any of the subclasses.
Commit: 1ccf41060a623a7c8c1652f4c0c740b337d56abc
Author: Mark Lawrence <nomad@null.net> Thu, 07 Jun 2007 15:51:17 +0200
Big simplification of the api.
INSERT and SELECT working.
WHERE statements automatically produce correct FROM table aliases.
Commit: 523be54f484c31a53de1e0bdf36e158db2343bcc
Author: Mark Lawrence <nomad@null.net> Sat, 02 Jun 2007 23:19:28 +0200
Table and Column classes now handle UNIQUE and FOREIGN KEY statements.
Commit: 179815c9e7013668d99bd075b186db86cb65ddeb
Author: Mark Lawrence <nomad@null.net> Sat, 02 Jun 2007 18:04:18 +0200
Table and Column classes can produce CREATE TABLE statements.
SELECT statements are broken due to new Table/Column classes.
Commit: 6dddb63569b272f4dc79f490c09af7d6b0eb31fc
Author: Mark Lawrence <nomad@null.net> Fri, 01 Jun 2007 22:29:13 +0200
Support for SELECT statements (incomplete)
First test program (test.pl)
Commit: 7e447fb263acc1c747acb36c0e7a1f37f3f68cb0
Author: Mark Lawrence <nomad@null.net> Fri, 01 Jun 2007 15:38:46 +0200
Initial Commit.