1 2003-06-16 15:58 kycl4rk
3 * lib/SQL/Translator.pm: I was going to move the "format_*_name"
4 methods to the ClassDBI producer, but I just couldn't see the best
5 way to do it. Besides, I can't necessarily decide what I don't
6 like about them being in this class. Is there any way any other
7 producer could/would ever use them? Also made aesthetic changes to
10 2003-06-16 13:56 kycl4rk
12 * LICENSE: All the copyright notices say how the user should have
13 received a copy of the license, but we never make the effort to
14 include it, so I have.
16 2003-06-16 13:55 kycl4rk
18 * MANIFEST: Added LICENSE.
20 2003-06-16 13:45 kycl4rk
22 * TODO: Added some ideas for 0.03.
24 2003-06-16 13:30 kycl4rk
26 * Makefile.PL: Fixed EXE_FILES filenames, decided to removed CGI
29 2003-06-16 13:26 kycl4rk
31 * bin/validator_test.pl: Removed this file as it uses the Validator
32 which has been removed.
34 2003-06-16 13:25 kycl4rk
36 * bin/sqlt-graph.pl: Fixed script name in POD.
38 2003-06-16 13:25 kycl4rk
40 * bin/sqlt-diagram.pl: Fixed script name in docs.
42 2003-06-16 13:24 kycl4rk
44 * bin/: auto-viv.cgi, sql_translator.cgi: Renamed auto-viv.cgi to
47 2003-06-16 13:23 kycl4rk
49 * bin/: auto-graph.pl, sqlt-graph.pl: Renamed auto-graph.pl to
52 2003-06-16 13:22 kycl4rk
54 * bin/: auto-dia.pl, sqlt-diagram.pl: Renamed auto-dia.pl to
57 2003-06-16 13:17 kycl4rk
59 * lib/SQL/Translator/Validator.pm: Removed Validator class as
60 validation is now in the Schema object.
62 2003-06-16 13:16 kycl4rk
64 * bin/sql_translator.pl: Removed some things that don't actually
67 2003-06-16 13:15 kycl4rk
69 * Makefile.PL: Changed getting of version from main module, added
72 2003-06-16 13:13 kycl4rk
74 * lib/SQL/Translator.pm: Altered POD description.
76 2003-06-10 23:34 kycl4rk
78 * lib/SQL/Translator.pm: Upped the version in anticipation of
79 making a new release soon, removed some unused code, added a better
80 quote, updated POD, expanded the AUTHORS list to include all module
81 contributors, expanded on SEE ALSO list.
83 2003-06-10 23:15 kycl4rk
85 * BUGS: Removed fixed bugs, either need to verify other bugs exist
88 2003-06-10 23:14 kycl4rk
92 2003-06-10 23:03 kycl4rk
94 * MANIFEST: Added HTML and POD producers.
96 2003-06-10 23:00 kycl4rk
98 * lib/SQL/Translator/Producer/: ClassDBI.pm, MySQL.pm, Oracle.pm,
99 PostgreSQL.pm, SQLite.pm, Sybase.pm, XML.pm: Modified producers to
100 quite looking for the data structure to be sent as an argument with
101 the translator object.
103 2003-06-10 22:59 kycl4rk
105 * lib/SQL/Translator/Parser/: Excel.pm, MySQL.pm, Oracle.pm,
106 PostgreSQL.pm, xSV.pm: Modified all filed to quit returning the
107 data structure, now only return "1" to show success.
109 2003-06-10 22:58 kycl4rk
111 * lib/SQL/Translator.pm: Added validation code.
113 2003-06-10 22:58 kycl4rk
115 * t/: 04file,fh,string.t, 07p_args.t: These tests relied on now
116 deprecated action that the raw data structure was returned by the
117 parser. The tests were updated to use the schema object.
119 2003-06-10 22:12 kycl4rk
121 * t/02mysql-parser.t: Added "is_valid" tests.
123 2003-06-10 10:06 kycl4rk
125 * lib/SQL/Translator/Producer/ClassDBI.pm: Mostly cosmetic changes
126 (Allen -- no tabs, indent = 4 spaces!), got rid of a map called in
129 2003-06-09 22:49 kycl4rk
131 * lib/SQL/Translator/Producer/HTML.pm: Adding new HTML producer.
133 2003-06-09 22:49 kycl4rk
135 * lib/SQL/Translator/Producer/POD.pm: Minor changes.
137 2003-06-09 00:46 allenday
139 * lib/SQL/Translator/Producer/ClassDBI.pm: move over bacon
141 2003-06-09 00:38 allenday
143 * lib/SQL/Translator/Producer/ClassDBI.pm: it was buggy
145 2003-06-09 00:37 kycl4rk
147 * lib/SQL/Translator/Producer/POD.pm: A POD producer.
149 2003-06-08 23:54 kycl4rk
151 * lib/SQL/Translator/Producer/GraphViz.pm: Changed to use schema
154 2003-06-08 23:40 kycl4rk
156 * lib/SQL/Translator/Producer/Diagram.pm: Changed to use schema,
157 refactored duplicated code (also in GraphViz) up into Schema API.
159 2003-06-08 23:40 kycl4rk
161 * lib/SQL/Translator/Schema.pm: Some bug fixen.
163 2003-06-08 23:18 kycl4rk
165 * lib/SQL/Translator/Schema.pm: Added "make_natural_joins."
167 2003-06-08 23:11 kycl4rk
169 * lib/SQL/Translator/Schema/Field.pm: Added "is_unique" method to
170 determine if a field has a UNIQUE index.
172 2003-06-08 22:38 allenday
174 * lib/SQL/Translator/Producer/ClassDBI.pm: supposedly hasa()is
175 deprecated in favor of has_a().
177 2003-06-08 22:20 allenday
179 * lib/SQL/Translator/Producer/ClassDBI.pm: linktable traversal
180 seems to be working! haven't tried the code yet, but it looks
183 2003-06-08 21:41 kycl4rk
185 * lib/SQL/Translator/Parser/PostgreSQL.pm: Added rule to catch a
186 default value given just as "null."
188 2003-06-08 21:19 kycl4rk
190 * lib/SQL/Translator/Producer/Oracle.pm: Removed debugging warning.
192 2003-06-08 21:16 kycl4rk
194 * t/15oracle-parser.t: Minor change to affect context.
196 2003-06-08 21:16 kycl4rk
198 * lib/SQL/Translator/Parser/Oracle.pm: Added "alter" to be able to
199 parse output of Oracle producer, other small changes.
201 2003-06-08 21:10 kycl4rk
203 * lib/SQL/Translator/Schema/Field.pm: Small changes to comments and
206 2003-06-08 21:10 kycl4rk
208 * lib/SQL/Translator/Schema/Table.pm: Small change to comment.
210 2003-06-08 21:03 kycl4rk
212 * MANIFEST: Removed "Raw" producer.
214 2003-06-08 21:02 kycl4rk
216 * lib/SQL/Translator/Producer/Raw.pm: Removing "Raw" producer as
217 it's unnecessary now.
219 2003-06-08 21:01 kycl4rk
221 * lib/SQL/Translator/Producer/XML.pm: Some cosmetic changes,
222 changed to use schema API.
224 2003-06-08 21:00 kycl4rk
226 * lib/SQL/Translator/Producer/Sybase.pm: Expanded "translate" hash,
227 changed to use schema API.
229 2003-06-08 21:00 kycl4rk
231 * lib/SQL/Translator/Producer/SQLite.pm: General cleanup, changed
234 2003-06-08 20:59 kycl4rk
236 * lib/SQL/Translator/Producer/PostgreSQL.pm: Changed to use schema
239 2003-06-08 20:58 kycl4rk
241 * lib/SQL/Translator/Producer/Oracle.pm: Cleaned up "translate"
242 hash a bit, changed to use schema objects now, some changed to
243 sub's to get rid of some warnings.
245 2003-06-08 20:56 kycl4rk
247 * lib/SQL/Translator/Producer/MySQL.pm: Changed to use schema
250 2003-06-08 20:55 kycl4rk
252 * lib/SQL/Translator/Producer/ClassDBI.pm: Removed unnecessary
253 backslash-escapes of single quotes, reformatted spacing to match
254 the style of the rest of the modules, using the schema API now,
255 removed "Chado" line, tried to make the "hasa"/FK stuff work
258 2003-06-06 17:52 kycl4rk
260 * MANIFEST: Added Oracle parser test.
262 2003-06-06 17:48 kycl4rk
264 * t/12header_comment.t: General mods to make it like others.
266 2003-06-06 17:47 kycl4rk
268 * t/11normalize.t: Added "use strict;"
270 2003-06-06 17:46 kycl4rk
272 * t/04file,fh,string.t: General clean up to make it more like the
275 2003-06-06 17:45 kycl4rk
277 * t/03mysql-to-oracle.t: General clean up to make it more like
280 2003-06-06 17:40 kycl4rk
282 * t/: 15oracle-parser.t, 08postgres-to-mysql.t: Fixed test numbers.
284 2003-06-06 17:39 kycl4rk
286 * t/10excel.t: Fixed test numbers, removed unnecessary code.
288 2003-06-06 17:37 kycl4rk
290 * lib/SQL/Translator/Parser/MySQL.pm: Added sorting of tables,
291 other cosmetic changes.
293 2003-06-06 17:36 kycl4rk
295 * lib/SQL/Translator/Schema/Table.pm: Added comments method and
298 2003-06-06 17:35 kycl4rk
300 * lib/SQL/Translator/Schema/Field.pm: Added parsing of comments on
301 init, added "comments" method.
303 2003-06-06 17:35 kycl4rk
305 * lib/SQL/Translator/Schema/Constraint.pm: Changed constant to a
306 hash to avoid silly Perl errors about it being redefined; other
309 2003-06-06 17:34 kycl4rk
311 * lib/SQL/Translator/Schema/Index.pm: Changed constant to a hash to
312 avoid silly Perl errors about it being redefined.
314 2003-06-06 17:34 kycl4rk
316 * lib/SQL/Translator/Schema/Constants.pm: Changed "FULLTEXT."
318 2003-06-06 17:32 kycl4rk
320 * MANIFEST: Removed Sybase parser because it's complete broken.
321 When this works, we can add it back.
323 2003-06-06 17:31 kycl4rk
325 * lib/SQL/Translator/Parser/Excel.pm: Cleaned up code (mostly
326 cosmetic), added normalization of column name, use Schema objects,
329 2003-06-06 17:30 kycl4rk
331 * lib/SQL/Translator/Parser/Oracle.pm: Quit putting PK defs as
332 indices, cosmetic changes to grammar, remove quotes around comment
333 values, quit pushing field constraints to table level, return
334 "varchar2" instead of "varchar" (keep it native), fixes to grammar
335 to bring it up to work with Parse::RecDescent 1.94, use of Schema
336 objects, added a good quote.
338 2003-06-06 17:27 kycl4rk
340 * lib/SQL/Translator/Parser/PostgreSQL.pm: Added a better quote;
341 quit putting FKs at field level (only at table); fixed bug with
342 field sizes (extra level of arrayref); got rid of "binary data"
343 data type (I swear this used to be legal), now only calling it
344 "bytea"; some cosmetic changes to the grammar; added use of Schema
347 2003-06-06 17:24 kycl4rk
349 * t/15oracle-parser.t: Added new Oracle parser test.
351 2003-06-06 17:24 kycl4rk
353 * t/10excel.t: Added a lot more tests, now using the Schema object.
355 2003-06-06 17:23 kycl4rk
357 * t/13schema.t: Changed $table->primary_key not to return an error
358 if there is no PK, added tests for "comments" on tables and fields.
360 2003-06-06 17:22 kycl4rk
362 * t/08postgres-to-mysql.t: Now that the PG parser is using the
363 Schema object, a previously uncaught bug surfaced in that an index
364 was created on a table (cvterm_synonym) that isn't defined in the
365 SQL, so that creates a problem. Commented out the line.
367 2003-06-06 17:21 kycl4rk
369 * t/14postgres-parser.t: The test schema actually had incorrect
370 syntax, so I fixed that; changed tests to use Schema object; added
373 2003-06-05 19:13 kycl4rk
375 * t/06xsv.t: Changed tests to use Schema objects instead of data
376 structure, added more thorough tests.
378 2003-06-05 19:13 kycl4rk
380 * t/13schema.t: Added tests for $field->extra.
382 2003-06-05 19:12 kycl4rk
384 * t/02mysql-parser.t: Changed tests to use the Schema objects
385 instead of looking at the data structure, added many more thorough
386 tests, added parsing some more complicated SQL.
388 2003-06-05 19:11 kycl4rk
390 * lib/SQL/Translator/Schema.pm: Fixed up some POD.
392 2003-06-05 19:10 kycl4rk
394 * lib/SQL/Translator/Schema/Table.pm: Moved some code around, fixed
395 some POD, added checking of existing constraints when adding new
396 ones (to prevent dups).
398 2003-06-05 19:09 kycl4rk
400 * lib/SQL/Translator/Schema/Field.pm: Added parsing of default
401 value on init, added "extra" method for misc field info, added
402 methods to determine if a field is a foreign key and to get the FK
405 2003-06-05 19:08 kycl4rk
407 * lib/SQL/Translator/Schema/Constraint.pm: Moved some code around
408 to fix ordering, convert "type" to match what's considered valid.
410 2003-06-05 19:06 kycl4rk
412 * lib/SQL/Translator/Schema/Index.pm: Moved some code around to get
413 methods in alphabetical order.
415 2003-06-05 19:05 kycl4rk
417 * lib/SQL/Translator/Parser/xSV.pm: Fixed parsing of field size for
420 2003-06-05 19:05 kycl4rk
422 * lib/SQL/Translator/Parser/MySQL.pm: Changes to grammar to clean
423 up, moved primary key defs and unique keys in data structure from
424 "indices" to "constraints" where they belong, added code to fill
425 out schema objects with data structure.
427 2003-06-04 20:57 kycl4rk
429 * lib/SQL/Translator/Producer/GraphViz.pm: Added better options for
430 accepting height and width, changed default node shape to "record,"
431 added option to show the fields of the table.
433 2003-06-04 20:51 kycl4rk
435 * bin/auto-graph.pl: Added options for height, width, and showing
438 2003-06-04 20:43 kycl4rk
440 * bin/auto-viv.cgi: Added ability to manipulate height, width, and
441 whether to show the field names for GraphViz output.
443 2003-06-04 17:04 kycl4rk
445 * lib/SQL/Translator/Parser/MySQL.pm: Added rules to catch common
446 (but useless) statements.
448 2003-06-04 10:35 kycl4rk
450 * t/02mysql-parser.t: Added a few more tests.
452 2003-06-03 17:42 kycl4rk
454 * lib/SQL/Translator/Parser/MySQL.pm: More work on default field
457 2003-06-03 17:38 kycl4rk
459 * lib/SQL/Translator/Parser/MySQL.pm: Added default field sizes for
460 numeric fields if not specified, removed unused rules.
462 2003-06-03 17:37 kycl4rk
464 * lib/SQL/Translator/Schema/Field.pm: Fixed bug with
467 2003-06-03 17:12 kycl4rk
469 * t/02mysql-parser.t: Added more tests.
471 2003-06-03 17:11 kycl4rk
473 * lib/SQL/Translator/Parser/MySQL.pm: Changed grammar to bring it
474 more inline with the official MySQL YACC grammar, added better
475 support for FK references.
477 2003-05-26 17:29 allenday
479 * lib/SQL/Translator/Producer/GraphViz.pm: added width and height
480 options for graphviz out. no docs
484 * lib/SQL/Translator/Utils.pm: Slightly more paranoid version of
485 parse_list_arg -- check length as well as definedness.
489 * lib/SQL/Translator/Utils.pm: Trim whitespace from arrayref
490 elements as well as array elements; see
491 <Pine.LNX.4.50.0305121004300.32235-100000@oakhill.homeip.net>.
493 2003-05-12 10:00 kycl4rk
495 * lib/SQL/Translator/Producer/Sybase.pm: Addressed a few style
496 issues to make it like the other producers (use "header_comment,"
497 indentation style [4 spaces, no tabs]). Added Sam's name as AUTHOR
500 2003-05-12 09:59 kycl4rk
502 * lib/SQL/Translator/Producer/MySQL.pm: Cosmetic change in POD.
504 2003-05-12 09:50 kycl4rk
506 * MANIFEST: Added Sybase producer to MANIFEST.
508 2003-05-12 09:49 kycl4rk
510 * lib/SQL/Translator/Utils.pm: Change to avoid warning of "use of
513 2003-05-12 09:48 kycl4rk
515 * bin/sql_translator.pl: Since "true" is the default for trimming
516 and scanning fields for the xSV parser, changed the args to turn
519 2003-05-12 09:29 angiuoli
521 * lib/SQL/Translator/Producer/Sybase.pm: added Sybase producer code
522 was derived from existing producer for postgres functional with
523 RELEASE-0_01, updates to work with current API are coming
525 2003-05-10 23:04 allenday
527 * lib/SQL/Translator/Producer/ClassDBI.pm: some fixes to fk method
528 name generation. failed to add nice m-to-m mapping method b/c data
529 structure is to FUBAR to extract the info i need.
531 2003-05-09 14:51 kycl4rk
533 * lib/SQL/Translator.pm: Don't pass schema, let others call for it.
535 2003-05-09 14:51 kycl4rk
537 * lib/SQL/Translator/Parser/: MySQL.pm, xSV.pm: Modified to call
538 translator to get schema rather than passing.
540 2003-05-09 12:15 kycl4rk
542 * lib/SQL/Translator/Parser/xSV.pm: Lots of changes to fix merge.
544 2003-05-09 12:12 kycl4rk
546 * t/13schema.t: Lots of changes to reflect library mods.
548 2003-05-09 12:12 kycl4rk
550 * lib/SQL/Translator/Schema/View.pm: Use "parse_list_args," added
551 "fields" method, changed validation, break ref to table in DESTROY.
553 2003-05-09 12:11 kycl4rk
555 * lib/SQL/Translator/Schema/Table.pm: Use "parse_list_arg," put
556 field order into field object, added "order" method for table,
557 break all references to fields, constraints and indices in DESTROY.
559 2003-05-09 12:09 kycl4rk
561 * lib/SQL/Translator/Schema/Index.pm: Use "parse_list_args," added
562 "options" (still vague on this), set a default for "type" of
563 "normal," break ref to table in DESTROY.
565 2003-05-09 12:08 kycl4rk
567 * lib/SQL/Translator/Schema/Field.pm: Added use of
568 "parse_list_arg," changed "nullable" method to "is_nullable" so it
569 would be like "is_auto_increment" and "is_primary_key," added
570 "order" method, added DESTROY.
572 2003-05-09 12:06 kycl4rk
574 * lib/SQL/Translator/Schema/Constants.pm: Playing with constants.
576 2003-05-09 12:06 kycl4rk
578 * lib/SQL/Translator/Schema/Constraint.pm: Added "match_type," use
579 "parse_list_arg," added DESTROY.
581 2003-05-09 12:04 kycl4rk
583 * lib/SQL/Translator/Producer/MySQL.pm: Removed warning.
585 2003-05-09 12:03 kycl4rk
587 * t/06xsv.t: Added passing of schema arg.
589 2003-05-09 11:55 kycl4rk
591 * lib/SQL/Translator/Parser/MySQL.pm: Playing around with new
594 2003-05-09 11:54 kycl4rk
596 * lib/SQL/Translator/Utils.pm: Added oft-used "parse_list_arg" sub
599 2003-05-09 11:53 kycl4rk
601 * lib/SQL/Translator/Schema.pm: Made "order" a property of the
602 table and view objects, use a Schwatzian transform in sorting,
603 added DESTROY to break circular links among objects.
605 2003-05-09 11:51 kycl4rk
607 * lib/SQL/Translator.pm: Passing schema object now as third
610 2003-05-09 11:49 kycl4rk
612 * bin/sql_translator.pl: [no log message]
614 2003-05-07 15:42 kycl4rk
616 * lib/SQL/Translator/Schema/Table.pm: Minor fixes to primary_key
619 2003-05-07 15:39 kycl4rk
621 * Makefile.PL: Added Text::RecordParser 0.02 pre-req.
623 2003-05-07 15:37 kycl4rk
625 * t/06xsv.t: Updated tests to match new code.
627 2003-05-07 15:36 kycl4rk
629 * lib/SQL/Translator/Parser/xSV.pm: Updated to use
630 Text::RecordParser and added scanning of fields, more
633 2003-05-07 15:36 kycl4rk
635 * bin/sql_translator.pl: Added mods to pass parser_args for xSV
640 * README: Updated README via perldoc -t lib/SQL/Translator.pm
644 * lib/SQL/Translator/Producer/XML.pm: Uses XML::Writer instead of
645 aggregate() and a global. Uses sqlfairy namespace (without a DTD
650 * t/: 01load.t, 05bgep-re.t, 13schema.t: Updated XML test.
654 * lib/SQL/Translator.pm: Doc changes (use C<> instead of B<>)
658 * MANIFEST, MANIFEST.SKIP, Makefile.PL: Added Schema and some more
661 2003-05-04 23:33 kycl4rk
663 * t/13schema.t: More changes to keep up with code.
665 2003-05-04 23:33 kycl4rk
667 * lib/SQL/Translator/Schema.pm: Too many changes.
669 2003-05-04 23:32 kycl4rk
671 * lib/SQL/Translator/Schema/: Constants.pm, Constraint.pm,
672 Field.pm, Index.pm, Table.pm: Too many changes to mention.
674 2003-05-03 10:42 kycl4rk
676 * lib/SQL/Translator/Schema/Field.pm: Fixed error 'Use of
677 uninitialized value in pattern match (m//) at
678 blib/lib/SQL/Translator/Schema/Field.pm line 144.'
680 2003-05-03 10:40 kycl4rk
682 * t/08postgres-to-mysql.t: Changed to use Test::More, cleaned up
683 syntax. Still pretty useless.
685 2003-05-03 10:40 kycl4rk
687 * lib/SQL/Translator/Parser/PostgreSQL.pm: "size" of a field needs
688 to be an arrayref as it could be two numbers (e.g., for a float
691 2003-05-03 10:21 kycl4rk
693 * lib/SQL/Translator/Producer/XML.pm: Fixed error 'Use of
694 uninitialized value in repeat (x) at
695 blib/lib/SQL/Translator/Producer/XML.pm line 110.'
697 2003-05-03 10:17 kycl4rk
699 * lib/SQL/Translator/Producer/MySQL.pm: Fixed error 'Use of
700 uninitialized value in string eq at
701 blib/lib/SQL/Translator/Producer/MySQL.pm line 164.'
703 2003-05-03 10:16 kycl4rk
705 * lib/SQL/Translator/Parser/Excel.pm: Fixed error '"my" variable
706 $wb_count masks earlier declaration in same scope at
707 blib/lib/SQL/Translator/Parser/Excel.pm line 68.'
709 2003-05-03 10:11 kycl4rk
711 * MANIFEST: For some reason, "t.pl" was still in there.
713 2003-05-03 10:02 kycl4rk
715 * lib/SQL/Translator/Parser/MySQL.pm: Fixed an error in default
716 value regex that disallowed a value like "00:18:00".
718 2003-05-02 23:15 kycl4rk
720 * Makefile.PL: Added the requirement of Parse::RecDescent 1.94 or
721 later, added "auto-graph.pl" to the EXE_FILES.
723 2003-05-02 23:12 kycl4rk
725 * t/14postgres-parser.t: Adding a new PG parser test.
727 2003-05-02 23:11 kycl4rk
729 * t/13schema.t: Trying to add tests as I write methods, so lots of
730 new stuff to mirror development of the Schema::* classes.
732 2003-05-02 23:09 kycl4rk
734 * lib/SQL/Translator/Parser/PostgreSQL.pm: Using some of the rules
735 from the PG grammar to make mine better, cleaned up the handling of
736 datatypes (esp WRT auto-inc), only placing PK defs as table
737 constraints (not an index), getting ready to parse views.
739 2003-05-02 23:07 kycl4rk
741 * lib/SQL/Translator/Schema.pm: Not much to say ... just trying to
744 2003-05-02 23:07 kycl4rk
746 * lib/SQL/Translator/Schema/: Constants.pm, Table.pm: More changes
747 to getting the schema to a working state.
749 2003-04-30 23:24 kycl4rk
751 * lib/SQL/Translator/: Schema.pm, Schema/Constraint.pm,
752 Schema/Field.pm, Schema/Index.pm, Schema/Table.pm, Schema/View.pm:
753 Adding new objects for handing schema data. Not being used while I
754 work out the tests and the general idea.
756 2003-04-30 23:23 kycl4rk
758 * t/: 02mysql-parser.t, 13schema.t: Adding new schema test,
759 commiting fixes to MySQL parser test.
761 2003-04-30 16:58 kycl4rk
763 * lib/SQL/Translator/Parser/MySQL.pm: Fixed error that was
764 preventing MySQL parser from working with Parse::RecDescent 1.94
765 (needed a "1;" at the end of the create rule); also made changes to
766 %item hash elements with repeat modifiers to match what they're now
767 called in Parse::RecDescent 1.94; these changes now make the
768 parser incompatible with earlier versions of P::RD!
770 2003-04-25 18:08 allenday
772 * lib/SQL/Translator/Producer/ClassDBI.pm: low hanging fruit,
773 please read the diff below
777 * MANIFEST, t/12header_comment.t: Test file for header_comment
778 function from SQL::Translator::Utils.
782 * lib/SQL/Translator/Producer/: ClassDBI.pm, MySQL.pm, Oracle.pm,
783 PostgreSQL.pm, SQLite.pm, XML.pm: Added refactored comment
784 producing using header_comment.
786 Added 'omit_empty_tags' option to XML producer. Also added some
789 Made SQLite producer produce actual auto incremented fields (using
790 the INTEGER PRIMARY KEY hack) if the field is an auto-incremented
791 one. This modifies slightly how indexes are produced.
793 Also modified how mk_name is called in the SQLite producer; SQLite
794 doesn't accept index names that begin with numbers.
798 * lib/SQL/Translator/Utils.pm: Added header_comment function; see
801 2003-04-24 17:15 allenday
803 * MANIFEST, t/data/pgsql/Chado-CV-PostGreSQL.sql: adding a pg src
806 2003-04-24 17:03 allenday
808 * Makefile.PL: adding graphviz dep
810 2003-04-24 16:40 kycl4rk
812 * MANIFEST: Added new files.
814 2003-04-24 15:02 kycl4rk
816 * lib/SQL/Translator/Producer/GraphViz.pm: Added defaults to
819 2003-04-24 14:58 kycl4rk
821 * bin/auto-viv.cgi: Adding new CGI script front-end for GraphViz
822 and Diagram producers.
824 2003-04-24 14:40 kycl4rk
826 * lib/SQL/Translator/Producer/Diagram.pm: Fixed bug (illegal div by
827 0) if "no_columns" wasn't numeric, also fixed return of production
828 if not writing to a file.
830 2003-04-24 11:36 kycl4rk
832 * lib/SQL/Translator/Producer/Diagram.pm: Adding new ER diagramming
835 2003-04-24 11:33 kycl4rk
837 * bin/auto-dia.pl: Moved most of the code into a new "Diagram"
840 2003-04-24 11:15 kycl4rk
842 * lib/SQL/Translator.pm: Cosmetic changes to keep the coding style
845 2003-04-24 11:15 kycl4rk
847 * lib/SQL/Translator/Producer/GraphViz.pm: Adding new GraphViz
850 2003-04-24 11:14 kycl4rk
852 * lib/SQL/Translator/Producer/MySQL.pm: Minor cosmetic changes.
854 2003-04-24 11:14 kycl4rk
856 * bin/auto-graph.pl: Moved all the real code into a module so this
857 script now just uses the new GraphViz producer.
859 2003-04-19 18:44 allenday
861 * lib/SQL/Translator/Producer/ClassDBI.pm: cosmetic changes to
864 2003-04-19 18:32 allenday
866 * lib/SQL/Translator.pm: adding capability to give 'filename'
867 constructor arg an arrayref.
869 2003-04-19 17:58 allenday
871 * lib/SQL/Translator/Producer/ClassDBI.pm: asdf
873 2003-04-18 20:32 kycl4rk
875 * lib/SQL/Translator/Producer/ClassDBI.pm: Fixed error for: "Use of
876 uninitialized value in string eq at
877 /usr/local/apache/lib/perl/SQL/Translator/Producer/ClassDBI.pm line
878 98." Also fixed some indentation problems in POD.
880 2003-04-18 18:45 allenday
882 * MANIFEST, lib/SQL/Translator/Producer/ClassDBI.pm: adding
885 2003-04-18 15:43 allenday
887 * lib/SQL/Translator/Producer/MySQL.pm: adding recognition of key
888 type "key" for table indices.
892 * t/11normalize.t: Forgot to add this yesterday.
894 2003-04-17 18:16 allenday
896 * lib/SQL/: Translator.pm, Translator/Parser/PostgreSQL.pm: adding
897 callbacks to Translator.pm to allow mangling of PK/FK/table
898 names/package names (CDBI specific) for producer classes.
900 2003-04-17 14:42 allenday
902 * lib/SQL/Translator/: Parser/PostgreSQL.pm, Producer/MySQL.pm:
903 workaround to get auto_increment working from PG "serial" datatype.
904 i didn't do this right, someone fix it :|
906 also added a fix to MySQL producer to not put () enclosed
907 attributes if values don't exist. ie, don't put int() if there is
908 not a length defined for int.
912 * BUGS, MANIFEST, lib/SQL/Translator/Validator.pm,
913 lib/SQL/Translator/Parser/Excel.pm,
914 lib/SQL/Translator/Parser/xSV.pm,
915 lib/SQL/Translator/Producer/MySQL.pm, t/10excel.t,
916 t/data/Excel/t.xls: Attempt to be more
917 robust.lib/SQL/Translator/Validator.pm
921 * lib/SQL/Translator/Utils.pm: Added normalize_name function, which
922 normalizes names. Primarily needed by the Excel parser.
926 * lib/SQL/Translator.pm: Let's check before we assume this is a
929 2003-04-14 14:20 kycl4rk
931 * lib/SQL/Translator/Producer/MySQL.pm: Fixes to help with Oracle
932 data types, also fixes with table constraints.
934 2003-04-10 17:53 kycl4rk
936 * MANIFEST: Added Oracle parser to MANIFEST.
938 2003-04-09 22:09 kycl4rk
940 * lib/SQL/Translator/Producer/MySQL.pm: Small fix.
942 2003-04-09 22:09 kycl4rk
944 * lib/SQL/Translator/Parser/Oracle.pm: Hey, new Oracle parser!
948 * README: Updated README to reflect changes to SQL/Translator.pm
953 * t/: 03mysql-to-oracle.t, 04file,fh,string.t, 06xsv.t: Moving
958 * Makefile.PL: Added Spreadsheet::ParseExcel
962 * MANIFEST: Added missing stuff. Remember folks, anything not in
963 MANIFEST will not be part of a distribution!
967 * t/10excel.t: Added stub test.
971 * lib/SQL/Translator/Producer/MySQL.pm: And again, with the
976 * lib/SQL/Translator/Parser/MySQL.pm: Why make these globals?
980 * lib/SQL/Translator.pm: Hey, this could never have worked as
983 2003-04-07 10:41 mmelillo
985 * t/data/Excel/t.xls: added a text spreadsheet, hopefully in the
986 right directory and such
988 2003-04-06 14:08 kycl4rk
990 * lib/SQL/Translator/Parser/Excel.pm: Some syntax fixes, package
991 name was wrong, added Mikey's name to AUTHORS. This parser is
992 still broken. The data structure I see coming back from
993 Spreadsheet::ParseExcel is not the same that is being examined by
996 2003-04-06 09:29 mmelillo
998 * lib/SQL/Translator/Parser/Excel.pm: Init Check in. This follows
999 closely along the lines of xSV.pm but its cooler because I used
1000 map. Hsan't been tested yet becuase I won't have access to suitable
1001 testing area til monday. Oh BTW, the map doesn't work syntactially.
1002 Someone want to tell me whats wrong with that line?
1004 2003-04-03 13:30 kycl4rk
1006 * bin/auto-graph.pl: Adding "auto-graph.pl" to automatically create
1007 graphs (via GraphViz) from schema definitions.
1009 2003-04-03 13:29 kycl4rk
1011 * bin/auto-dia.pl: Shortened "natural-join-fk-only" option to
1012 "natural-join-fk," accepting args to "image-type" now, added wider
1013 left margin (+10 pixels), added pre-processing of fields to find if
1014 the ones that acts as FKs in other tables in order to support the
1015 "show-fk-only" option, added debug option and warn statements to
1016 aid coding, added ability to make connecting lines directed when
1017 established with proper FOREIGN KEY/REFERENCES statements, added
1020 2003-04-01 19:46 kycl4rk
1022 * lib/SQL/Translator/Parser/MySQL.pm: Added grammar for
1023 "REFERENCES" (foreign keys).
1025 2003-04-01 19:46 kycl4rk
1027 * lib/SQL/Translator/Parser/PostgreSQL.pm: Got foreign key
1028 references basically working now.
1030 2003-04-01 19:45 kycl4rk
1032 * bin/auto-dia.pl: Added options for natual joins only, made code
1033 work with proper FK references.
1035 2003-04-01 12:08 kycl4rk
1037 * bin/auto-dia.pl: Added color option.
1039 2003-04-01 11:06 kycl4rk
1041 * bin/auto-dia.pl: Added mark for unique constraint and legend to
1042 explain extra markings.
1044 2003-04-01 10:43 kycl4rk
1046 * bin/auto-dia.pl: Added font options, made default font size
1047 'small' instead of 'tiny.'
1049 2003-03-27 13:07 mmelillo
1053 2003-03-27 12:03 mmelillo
1055 * TODO: added need for Excel Spreadsheet parser module which I will
1056 write in the near future per Darren's request
1058 2003-03-12 08:19 dlc
1060 * lib/SQL/Translator.pm:
1061 - load now sets $ERROR on failure.
1063 - list_parsers and list_producers are a little more robust, and
1065 in every directory in @INC.
1067 2003-03-12 08:17 dlc
1069 * MANIFEST: Added SQLite producer and Utils.
1071 2003-03-12 08:17 dlc
1073 * lib/SQL/Translator/: Utils.pm, Producer/MySQL.pm,
1074 Producer/SQLite.pm: Added Utils package with debug method, shared
1075 between MySQL and SQLite producers.
1077 2003-03-07 10:08 kycl4rk
1079 * lib/SQL/Translator/Producer/PostgreSQL.pm: Added code to kill
1080 field qualifiers in index field declarations.
1082 2003-03-04 15:24 kycl4rk
1084 * lib/SQL/Translator/Producer/: MySQL.pm, SQLite.pm: Added SQLite
1085 producer, basic knock-off of MySQL producer, made some mods to
1086 MySQL producer to add "DROP TABLE" statements, fixed POD a bit.
1088 2003-03-04 15:20 kycl4rk
1090 * lib/SQL/Translator.pm: Some minor mods to POD.
1092 2003-03-03 14:52 allenday
1094 * t/08postgres-to-mysql.t: turning off debugging in t/08
1096 2003-02-26 07:12 dlc
1098 * README: A README, which is required by CPAN.
1100 2003-02-26 07:11 dlc
1102 * t/09auto-dia.t, MANIFEST, Makefile.PL: o Added
1103 bin/auto-dia.pl to scripts list
1105 o Added a test for auto-dia (which might be questionable).
1107 o Added GD to module prerequisite list
1109 o Changed VERSION number, in anticipation of an intial release.
1111 2003-02-26 07:08 dlc
1113 * lib/SQL/Translator.pm: Some doc changes; added Allen to AUTHORS
1116 2003-02-25 23:17 kycl4rk
1118 * lib/SQL/Translator/Producer/MySQL.pm: Handle "on [delete|update]
1121 2003-02-25 23:17 kycl4rk
1123 * lib/SQL/Translator/Parser/PostgreSQL.pm: Added more rule (alter
1124 table) to be able handle Chado schema.
1126 2003-02-25 15:58 kycl4rk
1128 * lib/SQL/Translator/Parser/PostgreSQL.pm: Deleted "index" rules,
1129 allowed fore and aft comments in fields and table constraints
1132 2003-02-25 15:42 dlc
1134 * MANIFEST: Added t/08postgres-to-mysql.t
1136 2003-02-25 15:25 kycl4rk
1138 * lib/SQL/Translator/Parser/PostgreSQL.pm: Added production to
1139 field rule to handle embedded comments.
1141 2003-02-25 08:55 kycl4rk
1143 * lib/SQL/Translator/Parser/: MySQL.pm, PostgreSQL.pm: Added some
1144 documentation to PG and MySQL; the "eofile" rule to MySQL.
1146 2003-02-24 23:02 kycl4rk
1148 * lib/SQL/Translator/Producer/MySQL.pm: Mods to handles FK
1151 2003-02-24 23:01 kycl4rk
1153 * lib/SQL/Translator/Parser/PostgreSQL.pm: A working PG parser!
1155 2003-02-24 21:24 allenday
1157 * lib/SQL/Translator/Parser/PostgreSQL.pm: i forget what i did, but
1158 i found more bugs. we need to be able to support 'varchar' as
1159 implying 'varchar(255)' for both field and index declarations.
1160 also 'double precision' as a synonym for 'double'. also, mysql
1161 doesn't support boolean datatype, but postgres does, so we need to
1162 find a way to deal with this.
1168 2003-02-24 20:03 allenday
1170 * lib/SQL/Translator/Parser/PostgreSQL.pm: BUG. the parser cannot
1171 handle 'precision' as a qualifier for 'double'. this also applies
1172 to the mysql parser.
1174 2003-02-24 19:01 allenday
1176 * lib/SQL/Translator/Parser/PostgreSQL.pm, t/08postgres-to-mysql.t:
1177 added a serial->int auto_increment fix, a varchar->varchar(255)
1180 2003-02-21 13:35 allenday
1182 * MANIFEST, lib/SQL/Translator/Parser/PostGreSQL.pm,
1183 lib/SQL/Translator/Parser/PostgreSQL.pm: moving files around per
1186 2003-02-21 11:56 allenday
1188 * t/08postgres-to-mysql.t: here is the pgsql test script. NOTE: it
1189 will not work right now b/c i've just changed ::PostGreSQL to
1190 ::PostgreSQL, but haven't renamed the module itself yet. will do
1191 so later this morning, unless someone beats me to it :-)
1193 2003-02-21 09:19 dlc
1195 * MANIFEST, Makefile.PL, t/01load.t, t/02mysql-parser.t,
1197 Added new files to MANIFEST.
1199 Started updating tests to use Test::More, rather than the homegrown
1200 print stuff I'd started with (bad darren!).
1202 The load test uses SQL::Translator::load, to both exercise load()
1203 and to perform the actual test (I've intentionally used load
1204 instead of Test::More::use_ok).
1206 Added more dependencies to Makefile.PL.
1208 Sorted the dependencies in PREREQ_PM, and the file list in
1209 MANIFEST, because I'm obsessive about those sorts of silly things.
1211 2003-02-21 02:42 allenday
1213 * lib/SQL/Translator/Parser/PostGreSQL.pm: an adaptor for postgres.
1214 this works, but i think my primary key and foreign key parses are
1215 hackish. they require the pk/fk clause _right_after_ the field
1216 declaration, which i don't think is how postgres requires it.
1218 also i've found a bug in the mysql parser that is in the postgres
1219 parser as well that doesn't allow comments in the middle of table
1220 create statements. this will cause a failed parse:
1222 create table x ( x int, -- a comment );
1224 2003-02-20 21:23 allenday
1226 * Makefile.PL: added Class::Base preq
1228 2003-02-15 17:38 kycl4rk
1230 * bin/auto-dia.pl: Lots o' bug fixes. Added "join-pk-only" option.
1232 2003-02-14 20:31 kycl4rk
1234 * bin/auto-dia.pl: Made it better.
1236 2003-02-14 20:30 kycl4rk
1238 * lib/SQL/Translator/Parser/MySQL.pm: Added fulltext index.
1240 2003-02-14 14:29 kycl4rk
1242 * bin/auto-dia.pl: Added "auto-dia.pl" script for generating ER
1245 2003-01-29 07:32 dlc
1247 * lib/SQL/Translator/Producer/Raw.pm: Did you forget what year it
1250 2003-01-29 07:29 dlc
1252 * lib/SQL/Translator.pm:
1253 Moved all POD to the end of the module, to make it easier to modify
1256 Added a bunch of inline documentation.
1258 Refactored a few of the duplicated methods, such as producer_args
1261 2003-01-29 07:28 dlc
1263 * lib/SQL/Translator/Parser/MySQL.pm: Set $DEBUG to 0 by default.
1265 2003-01-29 07:27 dlc
1267 * bin/validator_test.pl: Removed extra unused junk.
1269 2003-01-29 07:27 dlc
1271 * MANIFEST: Added SQL::Translator::Producer::Raw to MANIFEST.
1273 2003-01-28 20:43 kycl4rk
1275 * lib/SQL/Translator/Producer/Raw.pm: Added "Raw" to be able to get
1276 to raw parser output.
1278 2003-01-27 11:04 dlc
1280 * lib/SQL/: Translator.pm, Translator/Parser.pm,
1281 Translator/Producer.pm, Translator/Validator.pm,
1282 Translator/Parser/MySQL.pm, Translator/Parser/Sybase.pm,
1283 Translator/Parser/xSV.pm, Translator/Producer/MySQL.pm,
1284 Translator/Producer/Oracle.pm, Translator/Producer/PostgreSQL.pm,
1285 Translator/Producer/XML.pm: Documentation fixes; added Chris' name
1286 to copyright notice; updated copyright year.
1288 2003-01-02 11:47 kycl4rk
1290 * lib/SQL/Translator/Producer/PostgreSQL.pm: Fixed bug where it was
1291 truncating table name needlessly.
1293 2002-12-10 19:44 kycl4rk
1295 * lib/SQL/Translator/Producer/Oracle.pm: Fixed problem with
1296 truncating an identifier when it was exactly the $max_id_length and
1297 no "type" was supplied to "mk_name."
1299 2002-12-03 19:53 kycl4rk
1301 * lib/SQL/Translator/Producer/: Oracle.pm, PostgreSQL.pm: Fixed a
1302 bug in Oracle producer that allowed for identifiers longer than the
1303 maximum allowed length, also there was a problem with not using the
1304 unreserved table name. Added decent amount of functionality to PG
1307 2002-12-03 10:20 dlc
1309 * MANIFEST, MANIFEST.SKIP: MANIFEST.SKIP takes a regex, not a list.
1310 Some of the .pm files weren't in the MANIFESt.
1312 2002-12-03 10:17 dlc
1314 * MANIFEST.SKIP, MANIFEST.skip: Moved MANIFEST.skip to
1317 2002-12-03 10:05 dlc
1319 * Makefile.PL: More generic clean macro
1321 2002-11-27 22:21 kycl4rk
1323 * lib/SQL/Translator/: Parser/MySQL.pm, Producer/XML.pm: Added a
1324 rule to MySQL parser to disregard "DROP...;" statements, filled out
1325 XML producer to generate hand-crafted XML.
1327 2002-11-25 21:59 kycl4rk
1329 * bin/sql_translator.pl, lib/SQL/Translator.pm,
1330 lib/SQL/Translator/Producer/Oracle.pm,
1331 lib/SQL/Translator/Producer/PostgreSQL.pm: Added "show_warnings"
1332 and "add_drop_table" options to sql_translator.pl and to
1333 SQL::Translator/Oracle producer. Fixed bug in Oracle producer that
1334 duplicated identifiers. Adding a lot of Oracle producer's logic to
1335 new PostgreSQL producer.
1337 2002-11-25 08:49 dlc
1339 * lib/SQL/Translator/Validator.pm: Updated an example to make it
1342 2002-11-25 08:48 dlc
1344 * lib/SQL/Translator.pm: Added some comments (comments?)
1346 2002-11-22 19:26 kycl4rk
1348 * bin/validator_test.pl, lib/SQL/Translator/Parser/MySQL.pm,
1349 lib/SQL/Translator/Producer/Oracle.pm, t/02mysql-parser.t,
1350 t/06xsv.t: Fixed spelling of "indices" in various files, finished
1351 adding all of Tim Bunce's logic from his "mysql2ora" script, Oracle
1352 producer is now a bit smarter, converting from MySQL to Oracle (or
1353 back to MySQL) should all work really well now.
1355 2002-11-21 21:03 kycl4rk
1357 * bin/sql_translator.pl, lib/SQL/Translator.pm,
1358 lib/SQL/Translator/Parser.pm, lib/SQL/Translator/Producer.pm,
1359 lib/SQL/Translator/Validator.pm,
1360 lib/SQL/Translator/Parser/MySQL.pm,
1361 lib/SQL/Translator/Parser/Sybase.pm,
1362 lib/SQL/Translator/Parser/xSV.pm,
1363 lib/SQL/Translator/Producer/MySQL.pm,
1364 lib/SQL/Translator/Producer/Oracle.pm,
1365 lib/SQL/Translator/Producer/PostgreSQL.pm,
1366 lib/SQL/Translator/Producer/XML.pm: Rolled in Darren's new
1367 list_[producers|parsers], lots of cosmetic changes, working in Tim
1368 Bunce's "mysql2ora" grammar and producer logic into appropriate
1369 modules, making output of producers more consistent, added table
1370 order to MySQL parser, using it in Oracle producer to maintain
1373 2002-11-21 11:45 dlc
1375 * lib/SQL/Translator.pm: Added list_parsers and list_producers
1376 methods, in response to
1377 <Pine.LNX.4.44.0211211124100.4042-100000@localhost.localdomain>
1379 2002-11-19 22:03 kycl4rk
1381 * lib/SQL/Translator/Producer/PostgreSQL.pm: Added PostgreSQL
1384 2002-11-19 22:03 kycl4rk
1386 * bin/sql_translator.pl, lib/SQL/Translator.pm,
1387 lib/SQL/Translator/Parser.pm, lib/SQL/Translator/Producer.pm,
1388 lib/SQL/Translator/Validator.pm,
1389 lib/SQL/Translator/Parser/MySQL.pm,
1390 lib/SQL/Translator/Parser/Sybase.pm,
1391 lib/SQL/Translator/Parser/xSV.pm,
1392 lib/SQL/Translator/Producer/MySQL.pm,
1393 lib/SQL/Translator/Producer/Oracle.pm: Fixed a lot of little things
1394 in modules, docs, etc. Bugs in sql_translator.pl.
1396 2002-10-11 16:09 cmungall
1398 * lib/SQL/Translator/Parser/MySQL.pm, t/05bgep-re.t: [no log
1401 2002-07-23 14:22 dlc
1403 * lib/SQL/Translator/Parser/MySQL.pm: Changed error_out usage to
1406 2002-07-23 14:21 dlc
1408 * lib/SQL/Translator.pm: Subclasses Class::Base. Removed error_out,
1409 error, in favor Class::Base::error.
1411 2002-07-08 09:42 dlc
1413 * MANIFEST.skip, Makefile.PL, bin/sql_translator.pl,
1414 lib/SQL/Translator.pm: Shitload of changes. Still passes all
1415 tests, such as they are.
1417 2002-06-11 07:09 dlc
1419 * lib/SQL/: Translator.pm, Translator/Validator.pm: Fixed some
1420 typos, added some basic re-logicing (is that even a word?)
1422 2002-03-29 07:08 dlc
1424 * TODO, lib/SQL/Translator/Producer/MySQL.pm: Added generation of
1425 PRIMARY KEY and KEY clauses to CREATE statements. Reorganized
1428 2002-03-27 06:41 dlc
1430 * BUGS, Makefile.PL, TODO, bin/validator_test.pl,
1431 lib/SQL/Translator.pm, lib/SQL/Translator/Validator.pm,
1432 lib/SQL/Translator/Producer/MySQL.pm: Added MySQL producer (still
1433 in a pretty alpha stage, only barely functional). Updated
1434 Validator.pm. Added a few new bugs to BUGS. Added file, filename,
1435 and data methods to Translator.pm. Silly change to Makefile.PL
1436 that will most likely come out.
1438 2002-03-26 06:46 dlc
1440 * MANIFEST, bin/validator_test.pl, lib/SQL/Translator.pm,
1441 lib/SQL/Translator/Validator.pm, t/07p_args.t: Added support for
1442 producer_args and parser_args. Added test for producer_args and
1443 parser_args. Added t/07p_test.t to MANIFEST. Added
1444 validator_test.pl to bin (though not to MANIFEST).
1446 2002-03-25 08:27 dlc
1448 * lib/SQL/Translator/Parser/xSV.pm, t/05bgep-re.t, t/06xsv.t: Added
1449 CSV parser and a test.
1451 2002-03-25 08:26 dlc
1453 * MANIFEST, MANIFEST.skip: Added extra files to MANIFEST.skip.
1456 2002-03-25 08:26 dlc
1458 * t/03mysql-to-oracle.t: Added test structure.
1460 2002-03-25 08:25 dlc
1462 * lib/SQL/Translator/Parser.pm: Added 'order' to data structure
1465 2002-03-21 12:55 dlc
1467 * Changes: Automatically generated by cvs2cl.pl
1469 2002-03-21 12:50 dlc
1471 * BUGS, Changes, MANIFEST, MANIFEST.skip, Makefile.PL, TODO,
1472 bin/sql_translator.pl, lib/SQL/Translator.pm,
1473 lib/SQL/Translator/Parser.pm, lib/SQL/Translator/Producer.pm,
1474 lib/SQL/Translator/Parser/MySQL.pm,
1475 lib/SQL/Translator/Producer/Oracle.pm,
1476 lib/SQL/Translator/Producer/XML.pm, t/01load.t, t/02mysql-parser.t,
1477 t/03mysql-to-oracle.t, t/04file,fh,string.t, t/05bgep-re.t,
1478 t/data/mysql/Apache-Session-MySQL.sql,
1479 t/data/mysql/BGEP-RE-create.sql: Merged changes from darren-1_0 tag
1480 into HEAD branch (hopefully!).
1482 2002-03-21 12:48 dlc
1484 * MANIFEST, MANIFEST.skip, Makefile.PL: Removed in anticipation of
1487 2002-03-21 12:07 dlc
1489 * t/: 05bgep-re.t, data/mysql/Apache-Session-MySQL.sql: Test
1492 2002-03-21 11:52 dlc
1494 * Makefile.PL: Accidentally PREREQ_PM'ed XML::Writer instead fo
1497 2002-03-21 11:48 dlc
1499 * t/data/mysql/Apache-Session-MySQL.sql: Re-added
1501 2002-03-21 09:54 dlc
1503 * MANIFEST: Updated filelist
1505 2002-03-21 09:53 dlc
1507 * BUGS, TODO, t/01load.t, t/05bgep-re.t,
1508 t/data/mysql/Apache-Session-MySQL.sql: Added some basic files,
1509 removed unused data file (the contents were moved into the test
1510 that used the data).
1512 2002-03-21 09:53 dlc
1514 * t/01load.t: file 01load.t was initially added on branch
1517 2002-03-21 09:53 dlc
1519 * t/05bgep-re.t: file 05bgep-re.t was initially added on branch
1522 2002-03-21 09:53 dlc
1524 * BUGS: file BUGS was initially added on branch darren-1_0.
1526 2002-03-21 09:53 dlc
1528 * TODO: file TODO was initially added on branch darren-1_0.
1530 2002-03-21 09:52 dlc
1532 * t/data/mysql/BGEP-RE-create.sql: Removed comment lines (the
1533 parser chokes on these, I think). Changed DEFAULT x NOT NULL lines
1534 to NOT NULL DEFAULT x, so overcompensate for a bug in the MySQL
1535 parser. Removed references to FULLTEXT indexes, because the MySQL
1536 grammar doesn't know about them.
1538 2002-03-21 09:50 dlc
1540 * t/04file,fh,string.t: Removed warns and debugging, so this test
1541 will actually pass when run as part of make test.
1543 2002-03-21 09:49 dlc
1545 * t/03mysql-to-oracle.t: Turned off SQL::Translator::DEBUG.
1547 2002-03-21 09:49 dlc
1549 * t/02mysql-parser.t: Broke the 1 test out into 11 different tests,
1550 each one of which tests a specific part of the data structure
1553 2002-03-21 09:48 dlc
1555 * lib/SQL/Translator/Producer/XML.pm: Changed name of translate
1556 method to produce, to be consistant with Producer API. Added
1557 __END__ token. Updated $VERSION to be CPAN-compliant.
1559 2002-03-21 09:47 dlc
1561 * lib/SQL/Translator/Parser.pm: Modified POD to include a complex
1562 description of the format of the data structure returned by parse.
1563 Added myself to the AUTHORS section.
1565 2002-03-21 09:45 dlc
1567 * Makefile.PL: Added Pod::Usage as a prerequisite
1569 2002-03-20 12:22 dlc
1571 * Changes: Automatically generated by cvs2cl.pl
1573 2002-03-20 10:37 dlc
1575 * Makefile.PL: syncmail test.
1577 2002-03-20 10:31 dlc
1579 * Makefile.PL: This was a synmail test.
1581 2002-03-19 07:26 dlc
1583 * t/04file,fh,string.t: Changed some of the basic assumptions.
1584 Removed code to check filehandle reads.
1586 2002-03-18 14:39 dlc
1588 * Changes: Automatically generated by cvs2cl.pl
1590 2002-03-18 14:39 dlc
1592 * Changes: Changelog file.
1594 2002-03-18 14:39 dlc
1596 * Changes: file Changes was initially added on branch darren-1_0.
1598 2002-03-18 14:35 dlc
1600 * lib/SQL/Translator.pm: Updated docs, especially detailed internal
1601 API docs. Updated default sub to return the data structure (and
1602 not the SQL::Translator instance). This became an issue once the
1603 subs were redefined to accept two args. Removed the possibility to
1604 pass a filehandle (or something that can getlines) as an option to
1605 translate. Added many levels of code folding markers. Updated
1606 parser to use a named class::function style of defining a function
1607 to call, just like producer.
1609 2002-03-18 14:32 dlc
1611 * t/04file,fh,string.t: Changed many assumptions about the test.
1612 Uses the default parser and producer (which is a pass through)
1614 2002-03-18 14:30 dlc
1616 * lib/SQL/Translator/Producer/Oracle.pm: Added note of a bug
1618 2002-03-15 14:18 dlc
1620 * MANIFEST, MANIFEST.skip, Makefile.PL: Added files.
1622 2002-03-15 14:14 dlc
1624 * MANIFEST, MANIFEST.skip, Makefile.PL: Added MANIFEST,
1625 MANIFEST.skip, and Makefile.PL
1627 2002-03-15 14:14 dlc
1629 * MANIFEST: file MANIFEST was initially added on branch darren-1_0.
1631 2002-03-15 14:14 dlc
1633 * MANIFEST.skip: file MANIFEST.skip was initially added on branch
1636 2002-03-15 14:14 dlc
1638 * Makefile.PL: file Makefile.PL was initially added on branch
1641 2002-03-15 14:13 dlc
1643 * lib/SQL/: Translator.pm, Translator/Parser.pm,
1644 Translator/Producer.pm, Translator/Parser/MySQL.pm,
1645 Translator/Producer/Oracle.pm: Added copyright notices to top of
1646 files. Updated documentation to be accurate. Updated parser and
1647 producer classes to work with the modified API defined by
1648 SQL::Translate. SQL::Translator instances have data members named
1649 parser_type and producer_type that can be used to determine from
1650 whence the parser and producer subroutines come. SQL::Translator
1651 will accept parsers and producers in the form
1652 Class::Name::function, just like mod_perl, in addition to
1653 Class::Name (with the implicit function name), Name (relative to
1654 SQL::Translator::{Parser,Producer}, and anonymous subroutines.
1656 2002-03-15 14:10 dlc
1658 * t/: 02mysql-parser.t, 03mysql-to-oracle.t, 04file,fh,string.t,
1659 data/mysql/Apache-Session-MySQL.sql, data/mysql/BGEP-RE-create.sql:
1660 Added test data in groovy hierarchical directories. Added some
1661 basic tests, many of which don't do much yet.
1663 2002-03-15 14:10 dlc
1665 * t/02mysql-parser.t: file 02mysql-parser.t was initially added on
1668 2002-03-15 14:10 dlc
1670 * t/03mysql-to-oracle.t: file 03mysql-to-oracle.t was initially
1671 added on branch darren-1_0.
1673 2002-03-15 14:10 dlc
1675 * t/04file,fh,string.t: file 04file,fh,string.t was initially added
1676 on branch darren-1_0.
1678 2002-03-15 14:10 dlc
1680 * t/data/mysql/Apache-Session-MySQL.sql: file
1681 Apache-Session-MySQL.sql was initially added on branch darren-1_0.
1683 2002-03-15 14:10 dlc
1685 * t/data/mysql/BGEP-RE-create.sql: file BGEP-RE-create.sql was
1686 initially added on branch darren-1_0.
1688 2002-03-15 14:09 dlc
1690 * bin/sql_translator.pl: Updated to work with my updated API.
1691 Added license to beginning. Updated to be CPAN-compliant.
1693 2002-03-07 08:14 dlc
1695 * lib/SQL/Translator.pm: Another attempt to check in a branch.
1697 2002-03-07 08:11 dlc
1699 * lib/SQL/Translator.pm: Reverted to a version 1.1, due to botched
1702 2002-03-07 08:06 dlc
1704 * lib/SQL/Translator.pm: Many, many changes. Changed the basic
1705 assumptions about the module. Parser and Producer packages no
1706 longer need to be object oriented, they merely need to implement a
1707 parse or translate function (respectively).
1709 2002-02-28 20:51 kycl4rk
1711 * lib/SQL/.Translator.pm.swp: Stupid vim backup file.
1713 2002-02-28 20:26 kycl4rk
1715 * lib/SQL/.Translator.pm.swp, bin/sql_translator.pl,
1716 lib/SQL/Translator.pm, lib/SQL/Translator/Parser.pm,
1717 lib/SQL/Translator/Producer.pm, lib/SQL/Translator/Parser/MySQL.pm,
1718 lib/SQL/Translator/Parser/Sybase.pm,
1719 lib/SQL/Translator/Producer/Oracle.pm,
1720 lib/SQL/Translator/Producer/XML.pm: Initial checkin.
1722 2002-02-28 20:26 kycl4rk
1724 * lib/SQL/.Translator.pm.swp, bin/sql_translator.pl,
1725 lib/SQL/Translator.pm, lib/SQL/Translator/Parser.pm,
1726 lib/SQL/Translator/Producer.pm, lib/SQL/Translator/Parser/MySQL.pm,
1727 lib/SQL/Translator/Parser/Sybase.pm,
1728 lib/SQL/Translator/Producer/Oracle.pm,
1729 lib/SQL/Translator/Producer/XML.pm: Initial revision