21 years agoChanged constant to a hash to avoid silly Perl errors about it being
Ken Youens-Clark [Fri, 6 Jun 2003 22:34:46 +0000]
Changed constant to a hash to avoid silly Perl errors about it being
redefined.

21 years agoChanged "FULLTEXT."
Ken Youens-Clark [Fri, 6 Jun 2003 22:34:00 +0000]
Changed "FULLTEXT."

21 years agoRemoved Sybase parser because it's complete broken. When this works, we can
Ken Youens-Clark [Fri, 6 Jun 2003 22:32:39 +0000]
Removed Sybase parser because it's complete broken.  When this works, we can
add it back.

21 years agoCleaned up code (mostly cosmetic), added normalization of column name,
Ken Youens-Clark [Fri, 6 Jun 2003 22:31:56 +0000]
Cleaned up code (mostly cosmetic), added normalization of column name,
use Schema objects, added a good quote.

21 years agoQuit putting PK defs as indices, cosmetic changes to grammar, remove quotes
Ken Youens-Clark [Fri, 6 Jun 2003 22:30:44 +0000]
Quit putting PK defs as indices, cosmetic changes to grammar, remove quotes
around comment values, quit pushing field constraints to table level,
return "varchar2" instead of "varchar" (keep it native), fixes to grammar to
bring it up to work with Parse::RecDescent 1.94, use of Schema objects,
added a good quote.

21 years agoAdded a better quote; quit putting FKs at field level (only at table); fixed
Ken Youens-Clark [Fri, 6 Jun 2003 22:27:46 +0000]
Added a better quote; quit putting FKs at field level (only at table); fixed
bug with field sizes (extra level of arrayref); got rid of "binary data"
data type (I swear this used to be legal), now only calling it "bytea";
some cosmetic changes to the grammar;  added use of Schema objects.

21 years agoAdded new Oracle parser test.
Ken Youens-Clark [Fri, 6 Jun 2003 22:24:45 +0000]
Added new Oracle parser test.

21 years agoAdded a lot more tests, now using the Schema object.
Ken Youens-Clark [Fri, 6 Jun 2003 22:24:26 +0000]
Added a lot more tests, now using the Schema object.

21 years agoChanged $table->primary_key not to return an error if there is no PK,
Ken Youens-Clark [Fri, 6 Jun 2003 22:23:54 +0000]
Changed $table->primary_key not to return an error if there is no PK,
added tests for "comments" on tables and fields.

21 years agoNow that the PG parser is using the Schema object, a previously uncaught
Ken Youens-Clark [Fri, 6 Jun 2003 22:22:20 +0000]
Now that the PG parser is using the Schema object, a previously uncaught
bug surfaced in that an index was created on a table (cvterm_synonym) that
isn't defined in the SQL, so that creates a problem.  Commented out the
line.

21 years agoThe test schema actually had incorrect syntax, so I fixed that; changed
Ken Youens-Clark [Fri, 6 Jun 2003 22:21:00 +0000]
The test schema actually had incorrect syntax, so I fixed that;  changed
tests to use Schema object; added a lot more.

21 years agoChanged tests to use Schema objects instead of data structure, added more
Ken Youens-Clark [Fri, 6 Jun 2003 00:13:57 +0000]
Changed tests to use Schema objects instead of data structure, added more
thorough tests.

21 years agoAdded tests for $field->extra.
Ken Youens-Clark [Fri, 6 Jun 2003 00:13:16 +0000]
Added tests for $field->extra.

21 years agoChanged tests to use the Schema objects instead of looking at the data
Ken Youens-Clark [Fri, 6 Jun 2003 00:12:45 +0000]
Changed tests to use the Schema objects instead of looking at the data
structure, added many more thorough tests, added parsing some more
complicated SQL.

21 years agoFixed up some POD.
Ken Youens-Clark [Fri, 6 Jun 2003 00:11:06 +0000]
Fixed up some POD.

21 years agoMoved some code around, fixed some POD, added checking of existing
Ken Youens-Clark [Fri, 6 Jun 2003 00:10:32 +0000]
Moved some code around, fixed some POD, added checking of existing
constraints when adding new ones (to prevent dups).

21 years agoAdded parsing of default value on init, added "extra" method for misc field
Ken Youens-Clark [Fri, 6 Jun 2003 00:09:25 +0000]
Added parsing of default value on init, added "extra" method for misc field
info, added methods to determine if a field is a foreign key and to get
the FK constraint.

21 years agoMoved some code around to fix ordering, convert "type" to match what's
Ken Youens-Clark [Fri, 6 Jun 2003 00:08:14 +0000]
Moved some code around to fix ordering, convert "type" to match what's
considered valid.

21 years agoMoved some code around to get methods in alphabetical order.
Ken Youens-Clark [Fri, 6 Jun 2003 00:06:49 +0000]
Moved some code around to get methods in alphabetical order.

21 years agoFixed parsing of field size for float values.
Ken Youens-Clark [Fri, 6 Jun 2003 00:05:44 +0000]
Fixed parsing of field size for float values.

21 years agoChanges to grammar to clean up, moved primary key defs and unique keys
Ken Youens-Clark [Fri, 6 Jun 2003 00:05:09 +0000]
Changes to grammar to clean up, moved primary key defs and unique keys
in data structure from "indices" to "constraints" where they belong,
added code to fill out schema objects with data structure.

21 years agoAdded better options for accepting height and width, changed default node
Ken Youens-Clark [Thu, 5 Jun 2003 01:57:48 +0000]
Added better options for accepting height and width, changed default node
shape to "record," added option to show the fields of the table.

21 years agoAdded options for height, width, and showing field names.
Ken Youens-Clark [Thu, 5 Jun 2003 01:51:29 +0000]
Added options for height, width, and showing field names.

21 years agoAdded ability to manipulate height, width, and whether to show the field
Ken Youens-Clark [Thu, 5 Jun 2003 01:43:35 +0000]
Added ability to manipulate height, width, and whether to show the field
names for GraphViz output.

21 years agoAdded rules to catch common (but useless) statements.
Ken Youens-Clark [Wed, 4 Jun 2003 22:04:53 +0000]
Added rules to catch common (but useless) statements.

21 years agoAdded a few more tests.
Ken Youens-Clark [Wed, 4 Jun 2003 15:35:22 +0000]
Added a few more tests.

21 years agoMore work on default field sizes for numerics.
Ken Youens-Clark [Tue, 3 Jun 2003 22:42:10 +0000]
More work on default field sizes for numerics.

21 years agoAdded default field sizes for numeric fields if not specified, removed
Ken Youens-Clark [Tue, 3 Jun 2003 22:38:18 +0000]
Added default field sizes for numeric fields if not specified, removed
unused rules.

21 years agoFixed bug with initialization.
Ken Youens-Clark [Tue, 3 Jun 2003 22:37:42 +0000]
Fixed bug with initialization.

21 years agoAdded more tests.
Ken Youens-Clark [Tue, 3 Jun 2003 22:12:54 +0000]
Added more tests.

21 years agoChanged grammar to bring it more inline with the official MySQL YACC
Ken Youens-Clark [Tue, 3 Jun 2003 22:11:55 +0000]
Changed grammar to bring it more inline with the official MySQL YACC
grammar, added better support for FK references.

21 years agoadded width and height options for graphviz out. no docs
Allen Day [Mon, 26 May 2003 22:29:48 +0000]
added width and height options for graphviz out.  no docs

21 years agoSlightly more paranoid version of parse_list_arg -- check length as well as definedness.
Darren Chamberlain [Mon, 12 May 2003 15:47:23 +0000]
Slightly more paranoid version of parse_list_arg -- check length as well as definedness.

21 years agoTrim whitespace from arrayref elements as well as array elements; see <Pine.LNX.4...
Darren Chamberlain [Mon, 12 May 2003 15:39:28 +0000]
Trim whitespace from arrayref elements as well as array elements; see <Pine.LNX.4.50.0305121004300.32235-100000@oakhill.homeip.net>.

21 years agoAddressed a few style issues to make it like the other producers (use
Ken Youens-Clark [Mon, 12 May 2003 15:00:34 +0000]
Addressed a few style issues to make it like the other producers (use
"header_comment," indentation style [4 spaces, no tabs]).  Added Sam's
name as AUTHOR and to copyright.

21 years agoCosmetic change in POD.
Ken Youens-Clark [Mon, 12 May 2003 14:59:15 +0000]
Cosmetic change in POD.

21 years agoAdded Sybase producer to MANIFEST.
Ken Youens-Clark [Mon, 12 May 2003 14:50:50 +0000]
Added Sybase producer to MANIFEST.

21 years agoChange to avoid warning of "use of unitialized value."
Ken Youens-Clark [Mon, 12 May 2003 14:49:39 +0000]
Change to avoid warning of "use of unitialized value."

21 years agoSince "true" is the default for trimming and scanning fields for the xSV
Ken Youens-Clark [Mon, 12 May 2003 14:48:43 +0000]
Since "true" is the default for trimming and scanning fields for the xSV
parser, changed the args to turn them off.

21 years agoadded Sybase producer
Sam Angiuoli [Mon, 12 May 2003 14:29:51 +0000]
added Sybase producer
code was derived from existing producer for postgres
functional with RELEASE-0_01, updates to work with current API are coming

21 years agosome fixes to fk method name generation. failed to add nice m-to-m mapping method b/c
Allen Day [Sun, 11 May 2003 04:04:17 +0000]
some fixes to fk method name generation.  failed to add nice m-to-m mapping method b/c
data structure is to FUBAR to extract the info i need.

21 years agoDon't pass schema, let others call for it.
Ken Youens-Clark [Fri, 9 May 2003 19:51:28 +0000]
Don't pass schema, let others call for it.

21 years agoModified to call translator to get schema rather than passing.
Ken Youens-Clark [Fri, 9 May 2003 19:51:04 +0000]
Modified to call translator to get schema rather than passing.

21 years agoLots of changes to fix merge.
Ken Youens-Clark [Fri, 9 May 2003 17:15:30 +0000]
Lots of changes to fix merge.

21 years agoLots of changes to reflect library mods.
Ken Youens-Clark [Fri, 9 May 2003 17:12:46 +0000]
Lots of changes to reflect library mods.

21 years agoUse "parse_list_args," added "fields" method, changed validation, break
Ken Youens-Clark [Fri, 9 May 2003 17:12:15 +0000]
Use "parse_list_args," added "fields" method, changed validation, break
ref to table in DESTROY.

21 years agoUse "parse_list_arg," put field order into field object, added "order"
Ken Youens-Clark [Fri, 9 May 2003 17:11:00 +0000]
Use "parse_list_arg," put field order into field object, added "order"
method for table, break all references to fields, constraints and
indices in DESTROY.

21 years agoUse "parse_list_args," added "options" (still vague on this), set a default
Ken Youens-Clark [Fri, 9 May 2003 17:09:43 +0000]
Use "parse_list_args," added "options" (still vague on this), set a default
for "type" of "normal," break ref to table in DESTROY.

21 years agoAdded use of "parse_list_arg," changed "nullable" method to "is_nullable"
Ken Youens-Clark [Fri, 9 May 2003 17:08:14 +0000]
Added use of "parse_list_arg," changed "nullable" method to "is_nullable"
so it would be like "is_auto_increment" and "is_primary_key," added "order"
method, added DESTROY.

21 years agoPlaying with constants.
Ken Youens-Clark [Fri, 9 May 2003 17:06:46 +0000]
Playing with constants.

21 years agoAdded "match_type," use "parse_list_arg," added DESTROY.
Ken Youens-Clark [Fri, 9 May 2003 17:06:11 +0000]
Added "match_type," use "parse_list_arg," added DESTROY.

21 years agoRemoved warning.
Ken Youens-Clark [Fri, 9 May 2003 17:04:39 +0000]
Removed warning.

21 years agoAdded passing of schema arg.
Ken Youens-Clark [Fri, 9 May 2003 17:03:43 +0000]
Added passing of schema arg.

21 years agoPlaying around with new schema object.
Ken Youens-Clark [Fri, 9 May 2003 16:55:07 +0000]
Playing around with new schema object.

21 years agoAdded oft-used "parse_list_arg" sub for Schema classes.
Ken Youens-Clark [Fri, 9 May 2003 16:54:03 +0000]
Added oft-used "parse_list_arg" sub for Schema classes.

21 years agoMade "order" a property of the table and view objects, use a Schwatzian
Ken Youens-Clark [Fri, 9 May 2003 16:53:21 +0000]
Made "order" a property of the table and view objects, use a Schwatzian
transform in sorting, added DESTROY to break circular links among objects.

21 years agoPassing schema object now as third argument.
Ken Youens-Clark [Fri, 9 May 2003 16:51:47 +0000]
Passing schema object now as third argument.

21 years ago*** empty log message ***
Ken Youens-Clark [Fri, 9 May 2003 16:49:41 +0000]
*** empty log message ***

21 years agoMinor fixes to primary_key method.
Ken Youens-Clark [Wed, 7 May 2003 20:42:34 +0000]
Minor fixes to primary_key method.

21 years agoAdded Text::RecordParser 0.02 pre-req.
Ken Youens-Clark [Wed, 7 May 2003 20:39:23 +0000]
Added Text::RecordParser 0.02 pre-req.

21 years agoUpdated tests to match new code.
Ken Youens-Clark [Wed, 7 May 2003 20:37:33 +0000]
Updated tests to match new code.

21 years agoUpdated to use Text::RecordParser and added scanning of fields, more
Ken Youens-Clark [Wed, 7 May 2003 20:36:59 +0000]
Updated to use Text::RecordParser and added scanning of fields, more
functionality.

21 years agoAdded mods to pass parser_args for xSV parser.
Ken Youens-Clark [Wed, 7 May 2003 20:36:15 +0000]
Added mods to pass parser_args for xSV parser.

21 years agoUpdated README via perldoc -t lib/SQL/Translator.pm
Darren Chamberlain [Tue, 6 May 2003 12:47:54 +0000]
Updated README via perldoc -t lib/SQL/Translator.pm

21 years agoUses XML::Writer instead of aggregate() and a global.
Darren Chamberlain [Tue, 6 May 2003 12:47:27 +0000]
Uses XML::Writer instead of aggregate() and a global.
Uses sqlfairy namespace (without a DTD yet, sorry).

21 years agoUpdated XML test.
Darren Chamberlain [Tue, 6 May 2003 12:45:49 +0000]
Updated XML test.

21 years agoDoc changes (use C<> instead of B<>)
Darren Chamberlain [Tue, 6 May 2003 12:44:54 +0000]
Doc changes (use C<> instead of B<>)

21 years agoAdded Schema and some more dependencies
Darren Chamberlain [Tue, 6 May 2003 12:44:10 +0000]
Added Schema and some more dependencies

21 years agoMore changes to keep up with code.
Ken Youens-Clark [Mon, 5 May 2003 04:33:49 +0000]
More changes to keep up with code.

21 years agoToo many changes.
Ken Youens-Clark [Mon, 5 May 2003 04:33:22 +0000]
Too many changes.

21 years agoToo many changes to mention.
Ken Youens-Clark [Mon, 5 May 2003 04:32:39 +0000]
Too many changes to mention.

21 years agoFixed error 'Use of uninitialized value in pattern match (m//) at blib/lib/SQL/Transl...
Ken Youens-Clark [Sat, 3 May 2003 15:42:59 +0000]
Fixed error 'Use of uninitialized value in pattern match (m//) at blib/lib/SQL/Translator/Schema/Field.pm line 144.'

21 years agoChanged to use Test::More, cleaned up syntax. Still pretty useless.
Ken Youens-Clark [Sat, 3 May 2003 15:40:51 +0000]
Changed to use Test::More, cleaned up syntax.  Still pretty useless.

21 years ago"size" of a field needs to be an arrayref as it could be two numbers (e.g.,
Ken Youens-Clark [Sat, 3 May 2003 15:40:18 +0000]
"size" of a field needs to be an arrayref as it could be two numbers (e.g.,
for a float "10,2").

21 years agoFixed error 'Use of uninitialized value in repeat (x) at blib/lib/SQL/Translator...
Ken Youens-Clark [Sat, 3 May 2003 15:21:12 +0000]
Fixed error 'Use of uninitialized value in repeat (x) at blib/lib/SQL/Translator/Producer/XML.pm line 110.'

21 years agoFixed error 'Use of uninitialized value in string eq at blib/lib/SQL/Translator/Produ...
Ken Youens-Clark [Sat, 3 May 2003 15:17:23 +0000]
Fixed error 'Use of uninitialized value in string eq at blib/lib/SQL/Translator/Producer/MySQL.pm line 164.'

21 years agoFixed error '"my" variable $wb_count masks earlier declaration in same scope at blib...
Ken Youens-Clark [Sat, 3 May 2003 15:16:19 +0000]
Fixed error '"my" variable $wb_count masks earlier declaration in same scope at blib/lib/SQL/Translator/Parser/Excel.pm line 68.'

21 years agoFor some reason, "t.pl" was still in there.
Ken Youens-Clark [Sat, 3 May 2003 15:11:44 +0000]
For some reason, "t.pl" was still in there.

21 years agoFixed an error in default value regex that disallowed a value like "00:18:00".
Ken Youens-Clark [Sat, 3 May 2003 15:02:15 +0000]
Fixed an error in default value regex that disallowed a value like "00:18:00".

21 years agoAdded the requirement of Parse::RecDescent 1.94 or later, added
Ken Youens-Clark [Sat, 3 May 2003 04:15:56 +0000]
Added the requirement of Parse::RecDescent 1.94 or later, added
"auto-graph.pl" to the EXE_FILES.

21 years agoAdding a new PG parser test.
Ken Youens-Clark [Sat, 3 May 2003 04:12:00 +0000]
Adding a new PG parser test.

21 years agoTrying to add tests as I write methods, so lots of new stuff to mirror
Ken Youens-Clark [Sat, 3 May 2003 04:11:37 +0000]
Trying to add tests as I write methods, so lots of new stuff to mirror
development of the Schema::* classes.

21 years agoUsing some of the rules from the PG grammar to make mine better, cleaned
Ken Youens-Clark [Sat, 3 May 2003 04:09:50 +0000]
Using some of the rules from the PG grammar to make mine better, cleaned
up the handling of datatypes (esp WRT auto-inc), only placing PK defs as
table constraints (not an index), getting ready to parse views.

21 years agoNot much to say ... just trying to get this working.
Ken Youens-Clark [Sat, 3 May 2003 04:07:38 +0000]
Not much to say ... just trying to get this working.

21 years agoMore changes to getting the schema to a working state.
Ken Youens-Clark [Sat, 3 May 2003 04:07:09 +0000]
More changes to getting the schema to a working state.

21 years agoAdding new objects for handing schema data. Not being used while I work
Ken Youens-Clark [Thu, 1 May 2003 04:25:00 +0000]
Adding new objects for handing schema data.  Not being used while I work
out the tests and the general idea.

21 years agoAdding new schema test, commiting fixes to MySQL parser test.
Ken Youens-Clark [Thu, 1 May 2003 04:23:11 +0000]
Adding new schema test, commiting fixes to MySQL parser test.

21 years agoFixed error that was preventing MySQL parser from working with
Ken Youens-Clark [Wed, 30 Apr 2003 21:58:40 +0000]
Fixed error that was preventing MySQL parser from working with
Parse::RecDescent 1.94 (needed a "1;" at the end of the create rule);
also made changes to %item hash elements with repeat modifiers to
match what they're now called in Parse::RecDescent 1.94;  these changes
now make the parser incompatible with earlier versions of P::RD!

21 years agolow hanging fruit, please read the diff below
Allen Day [Fri, 25 Apr 2003 23:08:01 +0000]
low hanging fruit, please read the diff below

21 years agoTest file for header_comment function from SQL::Translator::Utils.
Darren Chamberlain [Fri, 25 Apr 2003 11:48:12 +0000]
Test file for header_comment function from SQL::Translator::Utils.

21 years agoAdded refactored comment producing using header_comment.
Darren Chamberlain [Fri, 25 Apr 2003 11:47:25 +0000]
Added refactored comment producing using header_comment.

Added 'omit_empty_tags' option to  XML producer.  Also added some
documentation.

Made SQLite producer produce actual auto incremented fields (using the
INTEGER PRIMARY KEY hack) if the field is an auto-incremented one.  This
modifies slightly how indexes are produced.

Also modified how mk_name is called in the SQLite producer; SQLite
doesn't accept index names that begin with numbers.

21 years agoAdded header_comment function; see docs for details.
Darren Chamberlain [Fri, 25 Apr 2003 11:44:20 +0000]
Added header_comment function; see docs for details.

21 years agoadding a pg src file example
Allen Day [Thu, 24 Apr 2003 22:15:28 +0000]
adding a pg src file example

21 years agoadding graphviz dep
Allen Day [Thu, 24 Apr 2003 22:03:52 +0000]
adding graphviz dep

21 years agoAdded new files.
Ken Youens-Clark [Thu, 24 Apr 2003 21:40:12 +0000]
Added new files.

21 years agoAdded defaults to arguments.
Ken Youens-Clark [Thu, 24 Apr 2003 20:02:31 +0000]
Added defaults to arguments.

21 years agoAdding new CGI script front-end for GraphViz and Diagram producers.
Ken Youens-Clark [Thu, 24 Apr 2003 19:58:39 +0000]
Adding new CGI script front-end for GraphViz and Diagram producers.

21 years agoFixed bug (illegal div by 0) if "no_columns" wasn't numeric, also fixed
Ken Youens-Clark [Thu, 24 Apr 2003 19:40:52 +0000]
Fixed bug (illegal div by 0) if "no_columns" wasn't numeric, also fixed
return of production if not writing to a file.

21 years agoAdding new ER diagramming producer.
Ken Youens-Clark [Thu, 24 Apr 2003 16:36:49 +0000]
Adding new ER diagramming producer.

21 years agoMoved most of the code into a new "Diagram" producer.
Ken Youens-Clark [Thu, 24 Apr 2003 16:33:23 +0000]
Moved most of the code into a new "Diagram" producer.