projects / dbsrgits/SQL-Translator.git / blame
? search:
summary | shortlog | log | commit | commitdiff | tree
blob | history | HEAD
Initial import of Jason Williams' SQL Fairy logo.
[dbsrgits/SQL-Translator.git] / Changes
CommitLineData
b9952639 12003-06-16 15:58 kycl4rk
2
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
8 POD.
9
102003-06-16 13:56 kycl4rk
11
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.
15
162003-06-16 13:55 kycl4rk
17
18 * MANIFEST: Added LICENSE.
19
202003-06-16 13:45 kycl4rk
21
22 * TODO: Added some ideas for 0.03.
23
242003-06-16 13:30 kycl4rk
25
26 * Makefile.PL: Fixed EXE_FILES filenames, decided to removed CGI
27 script.
28
292003-06-16 13:26 kycl4rk
30
31 * bin/validator_test.pl: Removed this file as it uses the Validator
32 which has been removed.
33
342003-06-16 13:25 kycl4rk
35
36 * bin/sqlt-graph.pl: Fixed script name in POD.
37
382003-06-16 13:25 kycl4rk
39
40 * bin/sqlt-diagram.pl: Fixed script name in docs.
41
422003-06-16 13:24 kycl4rk
43
44 * bin/: auto-viv.cgi, sql_translator.cgi: Renamed auto-viv.cgi to
45 sql_translator.cgi
46
472003-06-16 13:23 kycl4rk
48
49 * bin/: auto-graph.pl, sqlt-graph.pl: Renamed auto-graph.pl to
50 sqlt-graph.pl
51
522003-06-16 13:22 kycl4rk
53
54 * bin/: auto-dia.pl, sqlt-diagram.pl: Renamed auto-dia.pl to
55 sqlt-diagram.pl
56
572003-06-16 13:17 kycl4rk
58
59 * lib/SQL/Translator/Validator.pm: Removed Validator class as
60 validation is now in the Schema object.
61
622003-06-16 13:16 kycl4rk
63
64 * bin/sql_translator.pl: Removed some things that don't actually
65 work.
66
672003-06-16 13:15 kycl4rk
68
69 * Makefile.PL: Changed getting of version from main module, added
70 exe file.
71
722003-06-16 13:13 kycl4rk
73
74 * lib/SQL/Translator.pm: Altered POD description.
75
762003-06-10 23:34 kycl4rk
77
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.
82
832003-06-10 23:15 kycl4rk
84
85 * BUGS: Removed fixed bugs, either need to verify other bugs exist
86 (and fix) or remove.
87
882003-06-10 23:14 kycl4rk
89
90 * TODO: Updated TODO.
91
922003-06-10 23:03 kycl4rk
93
94 * MANIFEST: Added HTML and POD producers.
95
962003-06-10 23:00 kycl4rk
97
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.
102
1032003-06-10 22:59 kycl4rk
104
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.
108
1092003-06-10 22:58 kycl4rk
110
111 * lib/SQL/Translator.pm: Added validation code.
112
1132003-06-10 22:58 kycl4rk
114
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.
118
1192003-06-10 22:12 kycl4rk
120
121 * t/02mysql-parser.t: Added "is_valid" tests.
122
1232003-06-10 10:06 kycl4rk
124
125 * lib/SQL/Translator/Producer/ClassDBI.pm: Mostly cosmetic changes
126 (Allen -- no tabs, indent = 4 spaces!), got rid of a map called in
127 void context.
128
1292003-06-09 22:49 kycl4rk
130
131 * lib/SQL/Translator/Producer/HTML.pm: Adding new HTML producer.
132
1332003-06-09 22:49 kycl4rk
134
135 * lib/SQL/Translator/Producer/POD.pm: Minor changes.
136
1372003-06-09 00:46 allenday
138
139 * lib/SQL/Translator/Producer/ClassDBI.pm: move over bacon
140
1412003-06-09 00:38 allenday
142
143 * lib/SQL/Translator/Producer/ClassDBI.pm: it was buggy
144
1452003-06-09 00:37 kycl4rk
146
147 * lib/SQL/Translator/Producer/POD.pm: A POD producer.
148
1492003-06-08 23:54 kycl4rk
150
151 * lib/SQL/Translator/Producer/GraphViz.pm: Changed to use schema
152 API.
153
1542003-06-08 23:40 kycl4rk
155
156 * lib/SQL/Translator/Producer/Diagram.pm: Changed to use schema,
157 refactored duplicated code (also in GraphViz) up into Schema API.
158
1592003-06-08 23:40 kycl4rk
160
161 * lib/SQL/Translator/Schema.pm: Some bug fixen.
162
1632003-06-08 23:18 kycl4rk
164
165 * lib/SQL/Translator/Schema.pm: Added "make_natural_joins."
166
1672003-06-08 23:11 kycl4rk
168
169 * lib/SQL/Translator/Schema/Field.pm: Added "is_unique" method to
170 determine if a field has a UNIQUE index.
171
1722003-06-08 22:38 allenday
173
174 * lib/SQL/Translator/Producer/ClassDBI.pm: supposedly hasa()is
175 deprecated in favor of has_a().
176
1772003-06-08 22:20 allenday
178
179 * lib/SQL/Translator/Producer/ClassDBI.pm: linktable traversal
180 seems to be working! haven't tried the code yet, but it looks
181 good.
182
1832003-06-08 21:41 kycl4rk
184
185 * lib/SQL/Translator/Parser/PostgreSQL.pm: Added rule to catch a
186 default value given just as "null."
187
1882003-06-08 21:19 kycl4rk
189
190 * lib/SQL/Translator/Producer/Oracle.pm: Removed debugging warning.
191
1922003-06-08 21:16 kycl4rk
193
194 * t/15oracle-parser.t: Minor change to affect context.
195
1962003-06-08 21:16 kycl4rk
197
198 * lib/SQL/Translator/Parser/Oracle.pm: Added "alter" to be able to
199 parse output of Oracle producer, other small changes.
200
2012003-06-08 21:10 kycl4rk
202
203 * lib/SQL/Translator/Schema/Field.pm: Small changes to comments and
204 size methods.
205
2062003-06-08 21:10 kycl4rk
207
208 * lib/SQL/Translator/Schema/Table.pm: Small change to comment.
209
2102003-06-08 21:03 kycl4rk
211
212 * MANIFEST: Removed "Raw" producer.
213
2142003-06-08 21:02 kycl4rk
215
216 * lib/SQL/Translator/Producer/Raw.pm: Removing "Raw" producer as
217 it's unnecessary now.
218
2192003-06-08 21:01 kycl4rk
220
221 * lib/SQL/Translator/Producer/XML.pm: Some cosmetic changes,
222 changed to use schema API.
223
2242003-06-08 21:00 kycl4rk
225
226 * lib/SQL/Translator/Producer/Sybase.pm: Expanded "translate" hash,
227 changed to use schema API.
228
2292003-06-08 21:00 kycl4rk
230
231 * lib/SQL/Translator/Producer/SQLite.pm: General cleanup, changed
232 to use schema API.
233
2342003-06-08 20:59 kycl4rk
235
236 * lib/SQL/Translator/Producer/PostgreSQL.pm: Changed to use schema
237 API.
238
2392003-06-08 20:58 kycl4rk
240
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.
244
2452003-06-08 20:56 kycl4rk
246
247 * lib/SQL/Translator/Producer/MySQL.pm: Changed to use schema
248 objects.
249
2502003-06-08 20:55 kycl4rk
251
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
256 nicely.
257
2582003-06-06 17:52 kycl4rk
259
260 * MANIFEST: Added Oracle parser test.
261
2622003-06-06 17:48 kycl4rk
263
264 * t/12header_comment.t: General mods to make it like others.
265
2662003-06-06 17:47 kycl4rk
267
268 * t/11normalize.t: Added "use strict;"
269
2702003-06-06 17:46 kycl4rk
271
272 * t/04file,fh,string.t: General clean up to make it more like the
273 others.
274
2752003-06-06 17:45 kycl4rk
276
277 * t/03mysql-to-oracle.t: General clean up to make it more like
278 other tests.
279
2802003-06-06 17:40 kycl4rk
281
282 * t/: 15oracle-parser.t, 08postgres-to-mysql.t: Fixed test numbers.
283
2842003-06-06 17:39 kycl4rk
285
286 * t/10excel.t: Fixed test numbers, removed unnecessary code.
287
2882003-06-06 17:37 kycl4rk
289
290 * lib/SQL/Translator/Parser/MySQL.pm: Added sorting of tables,
291 other cosmetic changes.
292
2932003-06-06 17:36 kycl4rk
294
295 * lib/SQL/Translator/Schema/Table.pm: Added comments method and
296 parsing on init.
297
2982003-06-06 17:35 kycl4rk
299
300 * lib/SQL/Translator/Schema/Field.pm: Added parsing of comments on
301 init, added "comments" method.
302
3032003-06-06 17:35 kycl4rk
304
305 * lib/SQL/Translator/Schema/Constraint.pm: Changed constant to a
306 hash to avoid silly Perl errors about it being redefined; other
307 minor changes.
308
3092003-06-06 17:34 kycl4rk
310
311 * lib/SQL/Translator/Schema/Index.pm: Changed constant to a hash to
312 avoid silly Perl errors about it being redefined.
313
3142003-06-06 17:34 kycl4rk
315
316 * lib/SQL/Translator/Schema/Constants.pm: Changed "FULLTEXT."
317
3182003-06-06 17:32 kycl4rk
319
320 * MANIFEST: Removed Sybase parser because it's complete broken.
321 When this works, we can add it back.
322
3232003-06-06 17:31 kycl4rk
324
325 * lib/SQL/Translator/Parser/Excel.pm: Cleaned up code (mostly
326 cosmetic), added normalization of column name, use Schema objects,
327 added a good quote.
328
3292003-06-06 17:30 kycl4rk
330
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.
337
3382003-06-06 17:27 kycl4rk
339
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
345 objects.
346
3472003-06-06 17:24 kycl4rk
348
349 * t/15oracle-parser.t: Added new Oracle parser test.
350
3512003-06-06 17:24 kycl4rk
352
353 * t/10excel.t: Added a lot more tests, now using the Schema object.
354
3552003-06-06 17:23 kycl4rk
356
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.
359
3602003-06-06 17:22 kycl4rk
361
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.
366
3672003-06-06 17:21 kycl4rk
368
369 * t/14postgres-parser.t: The test schema actually had incorrect
370 syntax, so I fixed that; changed tests to use Schema object; added
371 a lot more.
372
3732003-06-05 19:13 kycl4rk
374
375 * t/06xsv.t: Changed tests to use Schema objects instead of data
376 structure, added more thorough tests.
377
3782003-06-05 19:13 kycl4rk
379
380 * t/13schema.t: Added tests for $field->extra.
381
3822003-06-05 19:12 kycl4rk
383
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.
387
3882003-06-05 19:11 kycl4rk
389
390 * lib/SQL/Translator/Schema.pm: Fixed up some POD.
391
3922003-06-05 19:10 kycl4rk
393
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).
397
3982003-06-05 19:09 kycl4rk
399
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
403 constraint.
404
4052003-06-05 19:08 kycl4rk
406
407 * lib/SQL/Translator/Schema/Constraint.pm: Moved some code around
408 to fix ordering, convert "type" to match what's considered valid.
409
4102003-06-05 19:06 kycl4rk
411
412 * lib/SQL/Translator/Schema/Index.pm: Moved some code around to get
413 methods in alphabetical order.
414
4152003-06-05 19:05 kycl4rk
416
417 * lib/SQL/Translator/Parser/xSV.pm: Fixed parsing of field size for
418 float values.
419
4202003-06-05 19:05 kycl4rk
421
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.
426
4272003-06-04 20:57 kycl4rk
428
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.
432
4332003-06-04 20:51 kycl4rk
434
435 * bin/auto-graph.pl: Added options for height, width, and showing
436 field names.
437
4382003-06-04 20:43 kycl4rk
439
440 * bin/auto-viv.cgi: Added ability to manipulate height, width, and
441 whether to show the field names for GraphViz output.
442
4432003-06-04 17:04 kycl4rk
444
445 * lib/SQL/Translator/Parser/MySQL.pm: Added rules to catch common
446 (but useless) statements.
447
4482003-06-04 10:35 kycl4rk
449
450 * t/02mysql-parser.t: Added a few more tests.
451
4522003-06-03 17:42 kycl4rk
453
454 * lib/SQL/Translator/Parser/MySQL.pm: More work on default field
455 sizes for numerics.
456
4572003-06-03 17:38 kycl4rk
458
459 * lib/SQL/Translator/Parser/MySQL.pm: Added default field sizes for
460 numeric fields if not specified, removed unused rules.
461
4622003-06-03 17:37 kycl4rk
463
464 * lib/SQL/Translator/Schema/Field.pm: Fixed bug with
465 initialization.
466
4672003-06-03 17:12 kycl4rk
468
469 * t/02mysql-parser.t: Added more tests.
470
4712003-06-03 17:11 kycl4rk
472
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.
476
4772003-05-26 17:29 allenday
478
479 * lib/SQL/Translator/Producer/GraphViz.pm: added width and height
480 options for graphviz out. no docs
481
4822003-05-12 10:47 dlc
483
484 * lib/SQL/Translator/Utils.pm: Slightly more paranoid version of
485 parse_list_arg -- check length as well as definedness.
486
4872003-05-12 10:39 dlc
488
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>.
492
4932003-05-12 10:00 kycl4rk
494
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
498 and to copyright.
499
5002003-05-12 09:59 kycl4rk
501
502 * lib/SQL/Translator/Producer/MySQL.pm: Cosmetic change in POD.
503
5042003-05-12 09:50 kycl4rk
505
506 * MANIFEST: Added Sybase producer to MANIFEST.
507
5082003-05-12 09:49 kycl4rk
509
510 * lib/SQL/Translator/Utils.pm: Change to avoid warning of "use of
511 unitialized value."
512
5132003-05-12 09:48 kycl4rk
514
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
517 them off.
518
5192003-05-12 09:29 angiuoli
520
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
524
5252003-05-10 23:04 allenday
526
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.
530
5312003-05-09 14:51 kycl4rk
532
533 * lib/SQL/Translator.pm: Don't pass schema, let others call for it.
534
5352003-05-09 14:51 kycl4rk
536
537 * lib/SQL/Translator/Parser/: MySQL.pm, xSV.pm: Modified to call
538 translator to get schema rather than passing.
539
5402003-05-09 12:15 kycl4rk
541
542 * lib/SQL/Translator/Parser/xSV.pm: Lots of changes to fix merge.
543
5442003-05-09 12:12 kycl4rk
545
546 * t/13schema.t: Lots of changes to reflect library mods.
547
5482003-05-09 12:12 kycl4rk
549
550 * lib/SQL/Translator/Schema/View.pm: Use "parse_list_args," added
551 "fields" method, changed validation, break ref to table in DESTROY.
552
5532003-05-09 12:11 kycl4rk
554
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.
558
5592003-05-09 12:09 kycl4rk
560
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.
564
5652003-05-09 12:08 kycl4rk
566
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.
571
5722003-05-09 12:06 kycl4rk
573
574 * lib/SQL/Translator/Schema/Constants.pm: Playing with constants.
575
5762003-05-09 12:06 kycl4rk
577
578 * lib/SQL/Translator/Schema/Constraint.pm: Added "match_type," use
579 "parse_list_arg," added DESTROY.
580
5812003-05-09 12:04 kycl4rk
582
583 * lib/SQL/Translator/Producer/MySQL.pm: Removed warning.
584
5852003-05-09 12:03 kycl4rk
586
587 * t/06xsv.t: Added passing of schema arg.
588
5892003-05-09 11:55 kycl4rk
590
591 * lib/SQL/Translator/Parser/MySQL.pm: Playing around with new
592 schema object.
593
5942003-05-09 11:54 kycl4rk
595
596 * lib/SQL/Translator/Utils.pm: Added oft-used "parse_list_arg" sub
597 for Schema classes.
598
5992003-05-09 11:53 kycl4rk
600
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.
604
6052003-05-09 11:51 kycl4rk
606
607 * lib/SQL/Translator.pm: Passing schema object now as third
608 argument.
609
6102003-05-09 11:49 kycl4rk
611
612 * bin/sql_translator.pl: [no log message]
613
6142003-05-07 15:42 kycl4rk
615
616 * lib/SQL/Translator/Schema/Table.pm: Minor fixes to primary_key
617 method.
618
6192003-05-07 15:39 kycl4rk
620
621 * Makefile.PL: Added Text::RecordParser 0.02 pre-req.
622
6232003-05-07 15:37 kycl4rk
624
625 * t/06xsv.t: Updated tests to match new code.
626
6272003-05-07 15:36 kycl4rk
628
629 * lib/SQL/Translator/Parser/xSV.pm: Updated to use
630 Text::RecordParser and added scanning of fields, more
631 functionality.
632
6332003-05-07 15:36 kycl4rk
634
635 * bin/sql_translator.pl: Added mods to pass parser_args for xSV
636 parser.
637
6382003-05-06 07:47 dlc
639
640 * README: Updated README via perldoc -t lib/SQL/Translator.pm
641
6422003-05-06 07:47 dlc
643
644 * lib/SQL/Translator/Producer/XML.pm: Uses XML::Writer instead of
645 aggregate() and a global. Uses sqlfairy namespace (without a DTD
646 yet, sorry).
647
6482003-05-06 07:45 dlc
649
650 * t/: 01load.t, 05bgep-re.t, 13schema.t: Updated XML test.
651
6522003-05-06 07:44 dlc
653
654 * lib/SQL/Translator.pm: Doc changes (use C<> instead of B<>)
655
6562003-05-06 07:44 dlc
657
658 * MANIFEST, MANIFEST.SKIP, Makefile.PL: Added Schema and some more
659 dependencies
660
6612003-05-04 23:33 kycl4rk
662
663 * t/13schema.t: More changes to keep up with code.
664
6652003-05-04 23:33 kycl4rk
666
667 * lib/SQL/Translator/Schema.pm: Too many changes.
668
6692003-05-04 23:32 kycl4rk
670
671 * lib/SQL/Translator/Schema/: Constants.pm, Constraint.pm,
672 Field.pm, Index.pm, Table.pm: Too many changes to mention.
673
6742003-05-03 10:42 kycl4rk
675
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.'
679
6802003-05-03 10:40 kycl4rk
681
682 * t/08postgres-to-mysql.t: Changed to use Test::More, cleaned up
683 syntax. Still pretty useless.
684
6852003-05-03 10:40 kycl4rk
686
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
689 "10,2").
690
6912003-05-03 10:21 kycl4rk
692
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.'
696
6972003-05-03 10:17 kycl4rk
698
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.'
702
7032003-05-03 10:16 kycl4rk
704
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.'
708
7092003-05-03 10:11 kycl4rk
710
711 * MANIFEST: For some reason, "t.pl" was still in there.
712
7132003-05-03 10:02 kycl4rk
714
715 * lib/SQL/Translator/Parser/MySQL.pm: Fixed an error in default
716 value regex that disallowed a value like "00:18:00".
717
7182003-05-02 23:15 kycl4rk
719
720 * Makefile.PL: Added the requirement of Parse::RecDescent 1.94 or
721 later, added "auto-graph.pl" to the EXE_FILES.
722
7232003-05-02 23:12 kycl4rk
724
725 * t/14postgres-parser.t: Adding a new PG parser test.
726
7272003-05-02 23:11 kycl4rk
728
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.
731
7322003-05-02 23:09 kycl4rk
733
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.
738
7392003-05-02 23:07 kycl4rk
740
741 * lib/SQL/Translator/Schema.pm: Not much to say ... just trying to
742 get this working.
743
7442003-05-02 23:07 kycl4rk
745
746 * lib/SQL/Translator/Schema/: Constants.pm, Table.pm: More changes
747 to getting the schema to a working state.
748
7492003-04-30 23:24 kycl4rk
750
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.
755
7562003-04-30 23:23 kycl4rk
757
758 * t/: 02mysql-parser.t, 13schema.t: Adding new schema test,
759 commiting fixes to MySQL parser test.
760
7612003-04-30 16:58 kycl4rk
762
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!
769
7702003-04-25 18:08 allenday
771
772 * lib/SQL/Translator/Producer/ClassDBI.pm: low hanging fruit,
773 please read the diff below
774
7752003-04-25 06:48 dlc
776
777 * MANIFEST, t/12header_comment.t: Test file for header_comment
778 function from SQL::Translator::Utils.
779
7802003-04-25 06:47 dlc
781
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.
785
786 Added 'omit_empty_tags' option to XML producer. Also added some
787 documentation.
788
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.
792
793 Also modified how mk_name is called in the SQLite producer; SQLite
794 doesn't accept index names that begin with numbers.
795
7962003-04-25 06:44 dlc
797
798 * lib/SQL/Translator/Utils.pm: Added header_comment function; see
799 docs for details.
800
8012003-04-24 17:15 allenday
802
803 * MANIFEST, t/data/pgsql/Chado-CV-PostGreSQL.sql: adding a pg src
804 file example
805
8062003-04-24 17:03 allenday
807
808 * Makefile.PL: adding graphviz dep
809
8102003-04-24 16:40 kycl4rk
811
812 * MANIFEST: Added new files.
813
8142003-04-24 15:02 kycl4rk
815
816 * lib/SQL/Translator/Producer/GraphViz.pm: Added defaults to
817 arguments.
818
8192003-04-24 14:58 kycl4rk
820
821 * bin/auto-viv.cgi: Adding new CGI script front-end for GraphViz
822 and Diagram producers.
823
8242003-04-24 14:40 kycl4rk
825
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.
829
8302003-04-24 11:36 kycl4rk
831
832 * lib/SQL/Translator/Producer/Diagram.pm: Adding new ER diagramming
833 producer.
834
8352003-04-24 11:33 kycl4rk
836
837 * bin/auto-dia.pl: Moved most of the code into a new "Diagram"
838 producer.
839
8402003-04-24 11:15 kycl4rk
841
842 * lib/SQL/Translator.pm: Cosmetic changes to keep the coding style
843 consistent.
844
8452003-04-24 11:15 kycl4rk
846
847 * lib/SQL/Translator/Producer/GraphViz.pm: Adding new GraphViz
848 producer.
849
8502003-04-24 11:14 kycl4rk
851
852 * lib/SQL/Translator/Producer/MySQL.pm: Minor cosmetic changes.
853
8542003-04-24 11:14 kycl4rk
855
856 * bin/auto-graph.pl: Moved all the real code into a module so this
857 script now just uses the new GraphViz producer.
858
8592003-04-19 18:44 allenday
860
861 * lib/SQL/Translator/Producer/ClassDBI.pm: cosmetic changes to
862 autogenerated code.
863
8642003-04-19 18:32 allenday
865
866 * lib/SQL/Translator.pm: adding capability to give 'filename'
867 constructor arg an arrayref.
868
8692003-04-19 17:58 allenday
870
871 * lib/SQL/Translator/Producer/ClassDBI.pm: asdf
872
8732003-04-18 20:32 kycl4rk
874
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.
879
8802003-04-18 18:45 allenday
881
882 * MANIFEST, lib/SQL/Translator/Producer/ClassDBI.pm: adding
883 ClassDBI producer.
884
8852003-04-18 15:43 allenday
886
887 * lib/SQL/Translator/Producer/MySQL.pm: adding recognition of key
888 type "key" for table indices.
889
8902003-04-18 09:25 dlc
891
892 * t/11normalize.t: Forgot to add this yesterday.
893
8942003-04-17 18:16 allenday
895
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.
899
9002003-04-17 14:42 allenday
901
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 :|
905
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.
909
9102003-04-17 08:42 dlc
911
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
918
9192003-04-17 08:41 dlc
920
921 * lib/SQL/Translator/Utils.pm: Added normalize_name function, which
922 normalizes names. Primarily needed by the Excel parser.
923
9242003-04-17 08:40 dlc
925
926 * lib/SQL/Translator.pm: Let's check before we assume this is a
927 ref, eh?
928
9292003-04-14 14:20 kycl4rk
930
931 * lib/SQL/Translator/Producer/MySQL.pm: Fixes to help with Oracle
932 data types, also fixes with table constraints.
933
9342003-04-10 17:53 kycl4rk
935
936 * MANIFEST: Added Oracle parser to MANIFEST.
937
9382003-04-09 22:09 kycl4rk
939
940 * lib/SQL/Translator/Producer/MySQL.pm: Small fix.
941
9422003-04-09 22:09 kycl4rk
943
944 * lib/SQL/Translator/Parser/Oracle.pm: Hey, new Oracle parser!
945
9462003-04-08 07:59 dlc
947
948 * README: Updated README to reflect changes to SQL/Translator.pm
949 POD.
950
9512003-04-08 07:57 dlc
952
953 * t/: 03mysql-to-oracle.t, 04file,fh,string.t, 06xsv.t: Moving
954 tests to Test::More
955
9562003-04-08 07:56 dlc
957
958 * Makefile.PL: Added Spreadsheet::ParseExcel
959
9602003-04-08 07:55 dlc
961
962 * MANIFEST: Added missing stuff. Remember folks, anything not in
963 MANIFEST will not be part of a distribution!
964
9652003-04-08 07:55 dlc
966
967 * t/10excel.t: Added stub test.
968
9692003-04-07 11:31 dlc
970
971 * lib/SQL/Translator/Producer/MySQL.pm: And again, with the
972 globals. Yeesh.
973
9742003-04-07 11:27 dlc
975
976 * lib/SQL/Translator/Parser/MySQL.pm: Why make these globals?
977
9782003-04-07 11:18 dlc
979
980 * lib/SQL/Translator.pm: Hey, this could never have worked as
981 advertised. *blush*.
982
9832003-04-07 10:41 mmelillo
984
985 * t/data/Excel/t.xls: added a text spreadsheet, hopefully in the
986 right directory and such
987
9882003-04-06 14:08 kycl4rk
989
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
994 the code.
995
9962003-04-06 09:29 mmelillo
997
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?
1003
10042003-04-03 13:30 kycl4rk
1005
1006 * bin/auto-graph.pl: Adding "auto-graph.pl" to automatically create
1007 graphs (via GraphViz) from schema definitions.
1008
10092003-04-03 13:29 kycl4rk
1010
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
1018 some colors.
1019
10202003-04-01 19:46 kycl4rk
1021
1022 * lib/SQL/Translator/Parser/MySQL.pm: Added grammar for
1023 "REFERENCES" (foreign keys).
1024
10252003-04-01 19:46 kycl4rk
1026
1027 * lib/SQL/Translator/Parser/PostgreSQL.pm: Got foreign key
1028 references basically working now.
1029
10302003-04-01 19:45 kycl4rk
1031
1032 * bin/auto-dia.pl: Added options for natual joins only, made code
1033 work with proper FK references.
1034
10352003-04-01 12:08 kycl4rk
1036
1037 * bin/auto-dia.pl: Added color option.
1038
10392003-04-01 11:06 kycl4rk
1040
1041 * bin/auto-dia.pl: Added mark for unique constraint and legend to
1042 explain extra markings.
1043
10442003-04-01 10:43 kycl4rk
1045
1046 * bin/auto-dia.pl: Added font options, made default font size
1047 'small' instead of 'tiny.'
1048
10492003-03-27 13:07 mmelillo
1050
1051 * TODO: :)
1052
10532003-03-27 12:03 mmelillo
1054
1055 * TODO: added need for Excel Spreadsheet parser module which I will
1056 write in the near future per Darren's request
1057
10582003-03-12 08:19 dlc
1059
1060 * lib/SQL/Translator.pm:
1061 - load now sets $ERROR on failure.
1062
1063 - list_parsers and list_producers are a little more robust, and
1064 look
1065 in every directory in @INC.
1066
10672003-03-12 08:17 dlc
1068
1069 * MANIFEST: Added SQLite producer and Utils.
1070
10712003-03-12 08:17 dlc
1072
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.
1076
10772003-03-07 10:08 kycl4rk
1078
1079 * lib/SQL/Translator/Producer/PostgreSQL.pm: Added code to kill
1080 field qualifiers in index field declarations.
1081
10822003-03-04 15:24 kycl4rk
1083
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.
1087
10882003-03-04 15:20 kycl4rk
1089
1090 * lib/SQL/Translator.pm: Some minor mods to POD.
1091
10922003-03-03 14:52 allenday
1093
1094 * t/08postgres-to-mysql.t: turning off debugging in t/08
1095
10962003-02-26 07:12 dlc
1097
1098 * README: A README, which is required by CPAN.
1099
11002003-02-26 07:11 dlc
1101
1102 * t/09auto-dia.t, MANIFEST, Makefile.PL: o Added
1103 bin/auto-dia.pl to scripts list
1104
1105 o Added a test for auto-dia (which might be questionable).
1106
1107 o Added GD to module prerequisite list
1108
1109 o Changed VERSION number, in anticipation of an intial release.
1110
11112003-02-26 07:08 dlc
1112
1113 * lib/SQL/Translator.pm: Some doc changes; added Allen to AUTHORS
1114 section
1115
11162003-02-25 23:17 kycl4rk
1117
1118 * lib/SQL/Translator/Producer/MySQL.pm: Handle "on [delete|update]
1119 action" differently
1120
11212003-02-25 23:17 kycl4rk
1122
1123 * lib/SQL/Translator/Parser/PostgreSQL.pm: Added more rule (alter
1124 table) to be able handle Chado schema.
1125
11262003-02-25 15:58 kycl4rk
1127
1128 * lib/SQL/Translator/Parser/PostgreSQL.pm: Deleted "index" rules,
1129 allowed fore and aft comments in fields and table constraints
1130 (unique, PK, etc.).
1131
11322003-02-25 15:42 dlc
1133
1134 * MANIFEST: Added t/08postgres-to-mysql.t
1135
11362003-02-25 15:25 kycl4rk
1137
1138 * lib/SQL/Translator/Parser/PostgreSQL.pm: Added production to
1139 field rule to handle embedded comments.
1140
11412003-02-25 08:55 kycl4rk
1142
1143 * lib/SQL/Translator/Parser/: MySQL.pm, PostgreSQL.pm: Added some
1144 documentation to PG and MySQL; the "eofile" rule to MySQL.
1145
11462003-02-24 23:02 kycl4rk
1147
1148 * lib/SQL/Translator/Producer/MySQL.pm: Mods to handles FK
1149 references.
1150
11512003-02-24 23:01 kycl4rk
1152
1153 * lib/SQL/Translator/Parser/PostgreSQL.pm: A working PG parser!
1154
11552003-02-24 21:24 allenday
1156
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.
1163
1164 that's all for now.
1165
1166 -ad
1167
11682003-02-24 20:03 allenday
1169
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.
1173
11742003-02-24 19:01 allenday
1175
1176 * lib/SQL/Translator/Parser/PostgreSQL.pm, t/08postgres-to-mysql.t:
1177 added a serial->int auto_increment fix, a varchar->varchar(255)
1178 workaround.
1179
11802003-02-21 13:35 allenday
1181
1182 * MANIFEST, lib/SQL/Translator/Parser/PostGreSQL.pm,
1183 lib/SQL/Translator/Parser/PostgreSQL.pm: moving files around per
1184 ky's request
1185
11862003-02-21 11:56 allenday
1187
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 :-)
1192
11932003-02-21 09:19 dlc
1194
1195 * MANIFEST, Makefile.PL, t/01load.t, t/02mysql-parser.t,
1196 t/07p_args.t:
1197 Added new files to MANIFEST.
1198
1199 Started updating tests to use Test::More, rather than the homegrown
1200 print stuff I'd started with (bad darren!).
1201
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).
1205
1206 Added more dependencies to Makefile.PL.
1207
1208 Sorted the dependencies in PREREQ_PM, and the file list in
1209 MANIFEST, because I'm obsessive about those sorts of silly things.
1210
12112003-02-21 02:42 allenday
1212
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.
1217
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:
1221
1222 create table x ( x int, -- a comment );
1223
12242003-02-20 21:23 allenday
1225
1226 * Makefile.PL: added Class::Base preq
1227
12282003-02-15 17:38 kycl4rk
1229
1230 * bin/auto-dia.pl: Lots o' bug fixes. Added "join-pk-only" option.
1231
12322003-02-14 20:31 kycl4rk
1233
1234 * bin/auto-dia.pl: Made it better.
1235
12362003-02-14 20:30 kycl4rk
1237
1238 * lib/SQL/Translator/Parser/MySQL.pm: Added fulltext index.
1239
12402003-02-14 14:29 kycl4rk
1241
1242 * bin/auto-dia.pl: Added "auto-dia.pl" script for generating ER
1243 diagrams.
1244
12452003-01-29 07:32 dlc
1246
1247 * lib/SQL/Translator/Producer/Raw.pm: Did you forget what year it
1248 is, Ken?
1249
12502003-01-29 07:29 dlc
1251
1252 * lib/SQL/Translator.pm:
1253 Moved all POD to the end of the module, to make it easier to modify
1254 and find.
1255
1256 Added a bunch of inline documentation.
1257
1258 Refactored a few of the duplicated methods, such as producer_args
1259 and parser_args.
1260
12612003-01-29 07:28 dlc
1262
1263 * lib/SQL/Translator/Parser/MySQL.pm: Set $DEBUG to 0 by default.
1264
12652003-01-29 07:27 dlc
1266
1267 * bin/validator_test.pl: Removed extra unused junk.
1268
12692003-01-29 07:27 dlc
1270
1271 * MANIFEST: Added SQL::Translator::Producer::Raw to MANIFEST.
1272
12732003-01-28 20:43 kycl4rk
1274
1275 * lib/SQL/Translator/Producer/Raw.pm: Added "Raw" to be able to get
1276 to raw parser output.
1277
12782003-01-27 11:04 dlc
1279
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.
1287
12882003-01-02 11:47 kycl4rk
1289
1290 * lib/SQL/Translator/Producer/PostgreSQL.pm: Fixed bug where it was
1291 truncating table name needlessly.
1292
12932002-12-10 19:44 kycl4rk
1294
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."
1298
12992002-12-03 19:53 kycl4rk
1300
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
1305 producer.
1306
13072002-12-03 10:20 dlc
1308
1309 * MANIFEST, MANIFEST.SKIP: MANIFEST.SKIP takes a regex, not a list.
1310 Some of the .pm files weren't in the MANIFESt.
1311
13122002-12-03 10:17 dlc
1313
1314 * MANIFEST.SKIP, MANIFEST.skip: Moved MANIFEST.skip to
1315 MANIFEST.SKIP
1316
13172002-12-03 10:05 dlc
1318
1319 * Makefile.PL: More generic clean macro
1320
13212002-11-27 22:21 kycl4rk
1322
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.
1326
13272002-11-25 21:59 kycl4rk
1328
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.
1336
13372002-11-25 08:49 dlc
1338
1339 * lib/SQL/Translator/Validator.pm: Updated an example to make it
1340 happier.
1341
13422002-11-25 08:48 dlc
1343
1344 * lib/SQL/Translator.pm: Added some comments (comments?)
1345
13462002-11-22 19:26 kycl4rk
1347
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.
1354
13552002-11-21 21:03 kycl4rk
1356
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
1371 original ordering.
1372
13732002-11-21 11:45 dlc
1374
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>
1378
13792002-11-19 22:03 kycl4rk
1380
1381 * lib/SQL/Translator/Producer/PostgreSQL.pm: Added PostgreSQL
1382 producer.
1383
13842002-11-19 22:03 kycl4rk
1385
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.
1395
13962002-10-11 16:09 cmungall
1397
1398 * lib/SQL/Translator/Parser/MySQL.pm, t/05bgep-re.t: [no log
1399 message]
1400
14012002-07-23 14:22 dlc
1402
1403 * lib/SQL/Translator/Parser/MySQL.pm: Changed error_out usage to
1404 error
1405
14062002-07-23 14:21 dlc
1407
1408 * lib/SQL/Translator.pm: Subclasses Class::Base. Removed error_out,
1409 error, in favor Class::Base::error.
1410
14112002-07-08 09:42 dlc
1412
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.
1416
14172002-06-11 07:09 dlc
1418
1419 * lib/SQL/: Translator.pm, Translator/Validator.pm: Fixed some
1420 typos, added some basic re-logicing (is that even a word?)
1421
14222002-03-29 07:08 dlc
1423
1424 * TODO, lib/SQL/Translator/Producer/MySQL.pm: Added generation of
1425 PRIMARY KEY and KEY clauses to CREATE statements. Reorganized
1426 where CR are put.
1427
14282002-03-27 06:41 dlc
1429
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.
1437
14382002-03-26 06:46 dlc
1439
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).
1445
14462002-03-25 08:27 dlc
1447
1448 * lib/SQL/Translator/Parser/xSV.pm, t/05bgep-re.t, t/06xsv.t: Added
1449 CSV parser and a test.
1450
14512002-03-25 08:26 dlc
1452
1453 * MANIFEST, MANIFEST.skip: Added extra files to MANIFEST.skip.
1454 Updated MANIFEST.
1455
14562002-03-25 08:26 dlc
1457
1458 * t/03mysql-to-oracle.t: Added test structure.
1459
14602002-03-25 08:25 dlc
1461
1462 * lib/SQL/Translator/Parser.pm: Added 'order' to data structure
1463 description
1464
14652002-03-21 12:55 dlc
1466
1467 * Changes: Automatically generated by cvs2cl.pl
1468
14692002-03-21 12:50 dlc
a2e3f0d8 1470
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!).
1481
b9952639 14822002-03-21 12:48 dlc
a2e3f0d8 1483
1484 * MANIFEST, MANIFEST.skip, Makefile.PL: Removed in anticipation of
1485 a merge.
1486
b9952639 14872002-03-21 12:07 dlc
a2e3f0d8 1488
1489 * t/: 05bgep-re.t, data/mysql/Apache-Session-MySQL.sql: Test
1490 changes
1491
b9952639 14922002-03-21 11:52 dlc
a2e3f0d8 1493
1494 * Makefile.PL: Accidentally PREREQ_PM'ed XML::Writer instead fo
1495 XML::Dumper
1496
b9952639 14972002-03-21 11:48 dlc
a2e3f0d8 1498
1499 * t/data/mysql/Apache-Session-MySQL.sql: Re-added
1500
b9952639 15012002-03-21 09:54 dlc
a2e3f0d8 1502
1503 * MANIFEST: Updated filelist
1504
b9952639 15052002-03-21 09:53 dlc
a2e3f0d8 1506
b9952639 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).
a2e3f0d8 1511
b9952639 15122002-03-21 09:53 dlc
a2e3f0d8 1513
1514 * t/01load.t: file 01load.t was initially added on branch
1515 darren-1_0.
1516
b9952639 15172002-03-21 09:53 dlc
a2e3f0d8 1518
1519 * t/05bgep-re.t: file 05bgep-re.t was initially added on branch
1520 darren-1_0.
1521
b9952639 15222002-03-21 09:53 dlc
a2e3f0d8 1523
1524 * BUGS: file BUGS was initially added on branch darren-1_0.
1525
b9952639 15262002-03-21 09:53 dlc
a2e3f0d8 1527
b9952639 1528 * TODO: file TODO was initially added on branch darren-1_0.
a2e3f0d8 1529
b9952639 15302002-03-21 09:52 dlc
a2e3f0d8 1531
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.
1537
b9952639 15382002-03-21 09:50 dlc
a2e3f0d8 1539
1540 * t/04file,fh,string.t: Removed warns and debugging, so this test
1541 will actually pass when run as part of make test.
1542
b9952639 15432002-03-21 09:49 dlc
a2e3f0d8 1544
1545 * t/03mysql-to-oracle.t: Turned off SQL::Translator::DEBUG.
1546
b9952639 15472002-03-21 09:49 dlc
a2e3f0d8 1548
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
1551 returned by parse.
1552
b9952639 15532002-03-21 09:48 dlc
a2e3f0d8 1554
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.
1558
b9952639 15592002-03-21 09:47 dlc
a2e3f0d8 1560
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.
1564
b9952639 15652002-03-21 09:45 dlc
a2e3f0d8 1566
1567 * Makefile.PL: Added Pod::Usage as a prerequisite
1568
b9952639 15692002-03-20 12:22 dlc
a2e3f0d8 1570
1571 * Changes: Automatically generated by cvs2cl.pl
1572
b9952639 15732002-03-20 10:37 dlc
2d98334f 1574
1575 * Makefile.PL: syncmail test.
1576
b9952639 15772002-03-20 10:31 dlc
2d98334f 1578
1579 * Makefile.PL: This was a synmail test.
1580
b9952639 15812002-03-19 07:26 dlc
2d98334f 1582
1583 * t/04file,fh,string.t: Changed some of the basic assumptions.
1584 Removed code to check filehandle reads.
1585
b9952639 15862002-03-18 14:39 dlc
2d98334f 1587
1588 * Changes: Automatically generated by cvs2cl.pl
1589
b9952639 15902002-03-18 14:39 dlc
150797b1 1591
1592 * Changes: Changelog file.
1593
b9952639 15942002-03-18 14:39 dlc
150797b1 1595
1596 * Changes: file Changes was initially added on branch darren-1_0.
1597
b9952639 15982002-03-18 14:35 dlc
150797b1 1599
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.
1608
b9952639 16092002-03-18 14:32 dlc
150797b1 1610
1611 * t/04file,fh,string.t: Changed many assumptions about the test.
1612 Uses the default parser and producer (which is a pass through)
1613
b9952639 16142002-03-18 14:30 dlc
150797b1 1615
1616 * lib/SQL/Translator/Producer/Oracle.pm: Added note of a bug
1617
b9952639 16182002-03-15 14:18 dlc
150797b1 1619
1620 * MANIFEST, MANIFEST.skip, Makefile.PL: Added files.
1621
b9952639 16222002-03-15 14:14 dlc
150797b1 1623
1624 * MANIFEST, MANIFEST.skip, Makefile.PL: Added MANIFEST,
1625 MANIFEST.skip, and Makefile.PL
1626
b9952639 16272002-03-15 14:14 dlc
150797b1 1628
b9952639 1629 * MANIFEST: file MANIFEST was initially added on branch darren-1_0.
150797b1 1630
b9952639 16312002-03-15 14:14 dlc
150797b1 1632
a2e3f0d8 1633 * MANIFEST.skip: file MANIFEST.skip was initially added on branch
1634 darren-1_0.
150797b1 1635
b9952639 16362002-03-15 14:14 dlc
1637
1638 * Makefile.PL: file Makefile.PL was initially added on branch
1639 darren-1_0.
1640
16412002-03-15 14:13 dlc
150797b1 1642
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.
1655
b9952639 16562002-03-15 14:10 dlc
150797b1 1657
a2e3f0d8 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.
150797b1 1662
b9952639 16632002-03-15 14:10 dlc
150797b1 1664
b9952639 1665 * t/02mysql-parser.t: file 02mysql-parser.t was initially added on
1666 branch darren-1_0.
150797b1 1667
b9952639 16682002-03-15 14:10 dlc
150797b1 1669
a2e3f0d8 1670 * t/03mysql-to-oracle.t: file 03mysql-to-oracle.t was initially
1671 added on branch darren-1_0.
150797b1 1672
b9952639 16732002-03-15 14:10 dlc
1674
1675 * t/04file,fh,string.t: file 04file,fh,string.t was initially added
1676 on branch darren-1_0.
1677
16782002-03-15 14:10 dlc
150797b1 1679
a2e3f0d8 1680 * t/data/mysql/Apache-Session-MySQL.sql: file
1681 Apache-Session-MySQL.sql was initially added on branch darren-1_0.
150797b1 1682
b9952639 16832002-03-15 14:10 dlc
150797b1 1684
b9952639 1685 * t/data/mysql/BGEP-RE-create.sql: file BGEP-RE-create.sql was
1686 initially added on branch darren-1_0.
150797b1 1687
b9952639 16882002-03-15 14:09 dlc
150797b1 1689
1690 * bin/sql_translator.pl: Updated to work with my updated API.
1691 Added license to beginning. Updated to be CPAN-compliant.
1692
b9952639 16932002-03-07 08:14 dlc
150797b1 1694
1695 * lib/SQL/Translator.pm: Another attempt to check in a branch.
1696
b9952639 16972002-03-07 08:11 dlc
150797b1 1698
1699 * lib/SQL/Translator.pm: Reverted to a version 1.1, due to botched
1700 branch attempt.
1701
b9952639 17022002-03-07 08:06 dlc
150797b1 1703
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).
1708
b9952639 17092002-02-28 20:51 kycl4rk
150797b1 1710
1711 * lib/SQL/.Translator.pm.swp: Stupid vim backup file.
1712
b9952639 17132002-02-28 20:26 kycl4rk
150797b1 1714
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,
b9952639 1720 lib/SQL/Translator/Producer/XML.pm: Initial checkin.
150797b1 1721
b9952639 17222002-02-28 20:26 kycl4rk
150797b1 1723
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,
b9952639 1729 lib/SQL/Translator/Producer/XML.pm: Initial revision
150797b1 1730
DDL Tool (dbsrgits@git.shadowcat.co.uk:SQL-Translator.git)