11 years agoAdding DECIMAL_DIGITS to SQLServer size field for scale info: msdn.microsoft.com... sqlserver_add_decimal_digits_to_size_for_fields
Jonathan C. Otsuka [Sat, 18 Aug 2012 14:09:47 +0000]
Adding DECIMAL_DIGITS to SQLServer size field for scale info: msdn.microsoft.com/en-us/library/aa258832(v=sql.80).aspx

11 years agoIgnore editor droppings
Dagfinn Ilmari Mannsåker [Tue, 31 Jul 2012 11:06:46 +0000]
Ignore editor droppings

11 years agoAdd missing quote function to SQLServer producer
Arthur Axel 'fREW' Schmidt [Mon, 21 May 2012 19:49:37 +0000]
Add missing quote function to SQLServer producer

11 years agoFixor borked docs (we already test for this in t/66-postgres-dbi-parser.t)
Peter Rabbitson [Thu, 10 May 2012 06:42:23 +0000]
Fixor borked docs (we already test for this in t/66-postgres-dbi-parser.t)

11 years agoFINALLY A RELEASE! v0.11011
Arthur Axel 'fREW' Schmidt [Thu, 10 May 2012 00:42:54 +0000]
FINALLY A RELEASE!

11 years agoMoar documentation, shape up license/copyright notices
Peter Rabbitson [Wed, 9 May 2012 06:20:25 +0000]
Moar documentation, shape up license/copyright notices

11 years agoThis seems to no longer be used anywhere...?
Peter Rabbitson [Wed, 9 May 2012 05:45:06 +0000]
This seems to no longer be used anywhere...?

11 years agoResurrect the DB2 precompiled grammar to which we lost the source
Peter Rabbitson [Wed, 9 May 2012 06:39:18 +0000]
Resurrect the DB2 precompiled grammar to which we lost the source
While this is not optimal, at least things will somewhat work
Khisanth is writing a replacement

11 years agoHide deprecated stuff
Peter Rabbitson [Wed, 9 May 2012 05:25:45 +0000]
Hide deprecated stuff

12 years agofix excepted and scalarref quoting for DEFAULTS in SQLite (and SQL Server)
Arthur Axel 'fREW' Schmidt [Mon, 30 Apr 2012 16:03:31 +0000]
fix excepted and scalarref quoting for DEFAULTS in SQLite (and SQL Server)

12 years agofix sizeless types and typemap for SQLite
Arthur Axel 'fREW' Schmidt [Mon, 30 Apr 2012 14:50:02 +0000]
fix sizeless types and typemap for SQLite

12 years agofix list of numeric types for SQLite
Arthur Axel 'fREW' Schmidt [Mon, 30 Apr 2012 14:45:04 +0000]
fix list of numeric types for SQLite

See http://www.sqlite.org/datatype3.html

12 years agoassign copyright to my new files
Arthur Axel 'fREW' Schmidt [Tue, 1 May 2012 13:01:58 +0000]
assign copyright to my new files

12 years agoFix broken plan
Peter Rabbitson [Sat, 28 Apr 2012 06:09:39 +0000]
Fix broken plan

12 years agoAdd Jess as authority for new namespaces
Peter Rabbitson [Sat, 28 Apr 2012 03:59:38 +0000]
Add Jess as authority for new namespaces

12 years agoAdded "tables" and "options" methods to Schema::View
Ken Youens-Clark [Tue, 28 Feb 2012 22:11:29 +0000]
Added "tables" and "options" methods to Schema::View

Updated MySQL parser tests

12 years agoSome aesthetic changes
Ken Youens-Clark [Tue, 28 Feb 2012 22:11:29 +0000]
Some aesthetic changes

12 years agoMySQL Parser now handles views more completely
Ken Youens-Clark [Mon, 27 Feb 2012 17:48:21 +0000]
MySQL Parser now handles views more completely

12 years agosqlt-graph now has a --trace option.
Ken Youens-Clark [Mon, 27 Feb 2012 17:48:21 +0000]
sqlt-graph now has a --trace option.

12 years agoadd support for "DEFAULT (\d+)::data_type" in PostgreSQL Parser
Tina Mueller [Sat, 28 Apr 2012 01:31:49 +0000]
add support for "DEFAULT (\d+)::data_type" in PostgreSQL Parser

12 years agoFix silly syntax error, introduced in 0c04c5a22
Peter Rabbitson [Sat, 28 Apr 2012 02:09:52 +0000]
Fix silly syntax error, introduced in 0c04c5a22

12 years agoStop the DBI parser from disconnecting externally supplied DBI handles
Peter Rabbitson [Sat, 28 Apr 2012 02:01:33 +0000]
Stop the DBI parser from disconnecting externally supplied DBI handles

12 years agoSwitch to sane subcommand launch in tests
Peter Rabbitson [Sat, 28 Apr 2012 01:12:15 +0000]
Switch to sane subcommand launch in tests

12 years agoHonor supplied field order when adding fields to a table object
Jonathan Otsuka [Wed, 8 Feb 2012 05:32:27 +0000]
Honor supplied field order when adding fields to a table object

12 years agoDependency cleanup
Peter Rabbitson [Sat, 28 Apr 2012 00:26:10 +0000]
Dependency cleanup

12 years agoIncomplete revert in 0eb3b94a5
Peter Rabbitson [Fri, 27 Apr 2012 14:48:53 +0000]
Incomplete revert in 0eb3b94a5

12 years agoSilence prove -w warnings
Peter Rabbitson [Fri, 27 Apr 2012 14:42:08 +0000]
Silence prove -w warnings

12 years agoDefault SQLite quoting to off until we are capable of disabling it everywhere
Arthur Axel 'fREW' Schmidt [Wed, 22 Feb 2012 02:15:42 +0000]
Default SQLite quoting to off until we are capable of disabling it everywhere

Currently the diffing routines are either "always on" or "always off" with
no ability to pass around a setting (they are all class methods, never
looking at the $translator object). Until we can allow a user to say
quote_identifiers => 0, and not have to change any of the old tests, it
makes little sense to change the default.

12 years agosetting the quote accessors separately no longer makes sense
Arthur Axel 'fREW' Schmidt [Wed, 22 Feb 2012 02:12:21 +0000]
setting the quote accessors separately no longer makes sense

12 years agofix for when we are adding /dropping columns in sqlite and need to roundtrip via...
John Napiorkowski [Fri, 17 Feb 2012 17:02:47 +0000]
fix for when we are adding /dropping columns in sqlite and need to roundtrip via a temp table

12 years agoBack out bdf60588b to disable P::RD grammar precompilation - until P::RD is fixed
Peter Rabbitson [Tue, 7 Feb 2012 10:53:34 +0000]
Back out bdf60588b to disable P::RD grammar precompilation - until P::RD is fixed

While renewed activity on P::RD is great, the downside is that
incompatible changes were introduced which render precompiled
grammars useless. Furthermore since things are currently in the
air it is very likely things will change yet again, hence just
disable the whole thing for the time being. Reference RT#74593

12 years agoMerge branch 'people/frew/mega-refactor'
Peter Rabbitson [Sat, 4 Feb 2012 21:06:03 +0000]
Merge branch 'people/frew/mega-refactor'

12 years agomigrate duplicated code into role
Arthur Axel 'fREW' Schmidt [Wed, 25 Jan 2012 02:13:46 +0000]
migrate duplicated code into role

12 years agolazify things
Arthur Axel 'fREW' Schmidt [Wed, 25 Jan 2012 02:02:37 +0000]
lazify things

12 years agobetter
Arthur Axel 'fREW' Schmidt [Tue, 24 Jan 2012 23:47:32 +0000]
better

12 years agomigrate almost all code to Generator::Role::DDL
Arthur Axel 'fREW' Schmidt [Fri, 11 Mar 2011 04:05:20 +0000]
migrate almost all code to Generator::Role::DDL

12 years agoadd unique_constraints_multiple and indices
Arthur Axel 'fREW' Schmidt [Fri, 11 Mar 2011 03:58:25 +0000]
add unique_constraints_multiple and indices

12 years agoadd foreign_key_constraints
Arthur Axel 'fREW' Schmidt [Fri, 11 Mar 2011 03:53:09 +0000]
add foreign_key_constraints

12 years agoadd table_comments
Arthur Axel 'fREW' Schmidt [Fri, 11 Mar 2011 02:53:53 +0000]
add table_comments

12 years agoadd header_comment
Arthur Axel 'fREW' Schmidt [Fri, 11 Mar 2011 02:53:29 +0000]
add header_comment

12 years agoadd drop_tables method
Arthur Axel 'fREW' Schmidt [Fri, 11 Mar 2011 02:44:25 +0000]
add drop_tables method

12 years agorefactor table into more methods
Arthur Axel 'fREW' Schmidt [Fri, 11 Mar 2011 02:44:10 +0000]
refactor table into more methods

12 years agoless accumulators more reduction
Arthur Axel 'fREW' Schmidt [Thu, 10 Mar 2011 04:14:01 +0000]
less accumulators more reduction

12 years agoadd remove_table_constraints to future
Arthur Axel 'fREW' Schmidt [Thu, 10 Mar 2011 04:11:43 +0000]
add remove_table_constraints to future

12 years agodead
Arthur Axel 'fREW' Schmidt [Thu, 10 Mar 2011 04:01:59 +0000]
dead

12 years agomigrate drop_table to future
Arthur Axel 'fREW' Schmidt [Thu, 10 Mar 2011 04:01:51 +0000]
migrate drop_table to future

12 years agorearrange pod
Arthur Axel 'fREW' Schmidt [Thu, 10 Mar 2011 03:54:29 +0000]
rearrange pod

12 years agodelete dead code
Arthur Axel 'fREW' Schmidt [Thu, 10 Mar 2011 03:49:18 +0000]
delete dead code

12 years agomigrate table to Generator::Role::DDL
Arthur Axel 'fREW' Schmidt [Thu, 10 Mar 2011 03:49:33 +0000]
migrate table to Generator::Role::DDL

12 years agoless accumulators more reduction
Arthur Axel 'fREW' Schmidt [Thu, 10 Mar 2011 03:37:08 +0000]
less accumulators more reduction

12 years agoadd enum_constraint
Arthur Axel 'fREW' Schmidt [Thu, 10 Mar 2011 01:38:11 +0000]
add enum_constraint

12 years agoadd foreign_key_constraint
Arthur Axel 'fREW' Schmidt [Tue, 8 Mar 2011 05:15:48 +0000]
add foreign_key_constraint

12 years agofactor out unique constraints
Arthur Axel 'fREW' Schmidt [Tue, 8 Mar 2011 04:57:01 +0000]
factor out unique constraints

12 years agofactor out some basic constraints
Arthur Axel 'fREW' Schmidt [Tue, 8 Mar 2011 03:59:42 +0000]
factor out some basic constraints

12 years agouse future stuff for SQLite field generation
Arthur Axel 'fREW' Schmidt [Tue, 8 Mar 2011 02:29:55 +0000]
use future stuff for SQLite field generation

12 years agoinitial SQLite Producer object
Arthur Axel 'fREW' Schmidt [Tue, 8 Mar 2011 02:19:03 +0000]
initial SQLite Producer object

12 years agoadd comments, better default handling
Arthur Axel 'fREW' Schmidt [Tue, 8 Mar 2011 02:18:36 +0000]
add comments, better default handling

12 years agouse future stuff for SQL Server field generation
Arthur Axel 'fREW' Schmidt [Tue, 8 Mar 2011 01:16:49 +0000]
use future stuff for SQL Server field generation

12 years agostart of hardcore refactoring
Arthur Axel 'fREW' Schmidt [Sat, 26 Feb 2011 11:04:24 +0000]
start of hardcore refactoring

12 years agofactor quote method out of Generator::Utils
Arthur Axel 'fREW' Schmidt [Tue, 24 Jan 2012 23:27:55 +0000]
factor quote method out of Generator::Utils

12 years agoMove ProducerUtils into the new dir layout
Peter Rabbitson [Sat, 4 Feb 2012 20:46:14 +0000]
Move ProducerUtils into the new dir layout

12 years agoA set of placeholder directories for future refactoring
Peter Rabbitson [Sat, 4 Feb 2012 20:39:35 +0000]
A set of placeholder directories for future refactoring

12 years agoReally fix mysql CURRENT_TIMESTAMP handling (solves RT#65844)
Peter Rabbitson [Wed, 25 Jan 2012 10:47:33 +0000]
Really fix mysql CURRENT_TIMESTAMP handling (solves RT#65844)

12 years agoCorrect SQLite quote-char
Peter Rabbitson [Mon, 23 Jan 2012 09:32:45 +0000]
Correct SQLite quote-char

The original writer of d8cf2279 didn't do his/her homework, and used an
incorrect quote character. Thic compounded with SQLite trying really hard
to guess what one meant made the issue very hard to spot.

http://www.sqlite.org/lang_keywords.html

12 years agoAdd forgotten test skip after removed dependency in 1abbbee1
Peter Rabbitson [Thu, 19 Jan 2012 09:02:56 +0000]
Add forgotten test skip after removed dependency in 1abbbee1

12 years agoForgotten dependency used in bdf60588
Peter Rabbitson [Thu, 19 Jan 2012 09:01:20 +0000]
Forgotten dependency used in bdf60588

12 years agoQuote all dep versions (preserve trailing 0's and whatnot)
Peter Rabbitson [Thu, 19 Jan 2012 09:00:13 +0000]
Quote all dep versions (preserve trailing 0's and whatnot)

12 years agoFix MANIFEST.SKIP (MYMETA fail)
Peter Rabbitson [Wed, 18 Jan 2012 11:47:56 +0000]
Fix MANIFEST.SKIP (MYMETA fail)

12 years agoFix incorrect ordering in test (fails under unstable hash order i.e. 5.8.1)
Peter Rabbitson [Wed, 18 Jan 2012 11:36:08 +0000]
Fix incorrect ordering in test (fails under unstable hash order i.e. 5.8.1)

12 years agoAdd a git mailmap
Peter Rabbitson [Wed, 18 Jan 2012 10:13:24 +0000]
Add a git mailmap

12 years agoDeprecate SQL::Translator::Schema::Graph, undocument as_graph()
Peter Rabbitson [Wed, 18 Jan 2012 08:39:51 +0000]
Deprecate SQL::Translator::Schema::Graph, undocument as_graph()

According to 10f369208 Producer::Turnkey was retired back in 2004. It seems
that the ::Graph::* family exists solely for Turnkey infrastructure support
and as such can be deprecated. This frees us from a very old dependency
Class::MakeMethods (an early MOP attempt, not updated since 2003).

Fwiw Turnkey itself appears to be also dead:
http://sourceforge.net/mailarchive/forum.php?forum_name=turnkey-users

12 years agoPod fixage
Peter Rabbitson [Wed, 18 Jan 2012 07:52:35 +0000]
Pod fixage

12 years agoFix spurious whitespace failures in t/17sqlfxml-producer.t (RT#70786)
Peter Rabbitson [Wed, 18 Jan 2012 07:34:28 +0000]
Fix spurious whitespace failures in t/17sqlfxml-producer.t (RT#70786)

12 years agoAdd forgotten contributors from various patches:
Peter Rabbitson [Wed, 18 Jan 2012 07:14:46 +0000]
Add forgotten contributors from various patches:

Adam Strzelecki - RT#5992
Johan Viklund - RT#44769
Lukas Thiemeier - RT#70734
Maximilian Gass - RT#68912

12 years agoFix for mysql producer drop primary key, refs #62250
Sebatian B. Knapp [Sat, 7 Jan 2012 13:50:42 +0000]
Fix for mysql producer drop primary key, refs #62250

12 years agosqlt-diff arguments parsing reimplemented using Getopt
Jaime Soriano [Sun, 25 Dec 2011 19:56:47 +0000]
sqlt-diff arguments parsing reimplemented using Getopt

12 years agosqlt-diff option to quote names
Jaime Soriano Pastor [Wed, 21 Dec 2011 15:08:10 +0000]
sqlt-diff option to quote names

12 years agoBit size can range from 1 to 64, test added for size greater than one
Jaime Soriano [Sun, 25 Dec 2011 18:37:51 +0000]
Bit size can range from 1 to 64, test added for size greater than one

Extra tests for additions in bc9932bfd

12 years agoChanges for a1afcdb6
Peter Rabbitson [Tue, 17 Jan 2012 13:01:59 +0000]
Changes for a1afcdb6

12 years agoFix ignored option to script/sqlt-diagram (RT#5992)
Peter Rabbitson [Tue, 17 Jan 2012 13:00:52 +0000]
Fix ignored option to script/sqlt-diagram (RT#5992)

12 years agoFix misleading Diagram POD
Peter Rabbitson [Tue, 17 Jan 2012 12:54:02 +0000]
Fix misleading Diagram POD

12 years agoCombined patches from RT#70734 and RT#44769
Peter Rabbitson [Tue, 17 Jan 2012 12:23:42 +0000]
Combined patches from RT#70734 and RT#44769

12 years agofixed typo reported in rt68912
Sebatian B. Knapp [Mon, 26 Dec 2011 20:46:18 +0000]
fixed typo reported in rt68912

12 years agoTab/WS crusade
Peter Rabbitson [Tue, 17 Jan 2012 11:02:22 +0000]
Tab/WS crusade

12 years agoUse precompiled Parse::RecDescent parsers for moar speed
Peter Rabbitson [Mon, 16 Jan 2012 10:12:32 +0000]
Use precompiled Parse::RecDescent parsers for moar speed

Leverage the (hideous but effective) capability of Parse::RecDescent to
precompile concise gramars into multithousand line monsters. Improves
parsing and thus diffing speed considerably, i.e.:

Testing before:
Files=66, Tests=1851, 23 wallclock secs ( 0.38 usr  0.06 sys + 19.96 cusr  1.80 csys = 22.20 CPU)

Testing after:
Files=66, Tests=1858, 17 wallclock secs ( 0.38 usr  0.08 sys + 15.50 cusr  0.74 csys = 16.70 CPU)

A number of cleanups, including grammar fixes when transitioning from
q{} to heredocs. No functional changes at all.

12 years agoSQLT::Parser::PostgreSQL parses table def with default values
Cedric Carree [Tue, 3 Jan 2012 16:53:56 +0000]
SQLT::Parser::PostgreSQL parses table def with default values

Actually the parser used to skip table definition which includes fields with explicitely casted default values
For example, the following field definition was not working (due to the "::text" part)

CREATE TABLE foo (
    bar TEXT DEFAULT 'this is casted default text'::TEXT
);

12 years agoDrop Class::Accessor::Fast in favor of Moo
Peter Rabbitson [Wed, 4 Jan 2012 09:56:44 +0000]
Drop Class::Accessor::Fast in favor of Moo

12 years agoAdd (now passing) test with file from RT#70473
Sebatian B. Knapp [Sat, 10 Dec 2011 14:42:24 +0000]
Add (now passing) test with file from RT#70473

12 years agoChange mysql parser to throw exceptions on unspecified default values (RT#4835)
giftnuss [Thu, 24 Nov 2011 00:13:24 +0000]
Change mysql parser to throw exceptions on unspecified default values (RT#4835)

12 years agoAdd giftnuss to contributors, awesome triage work
Peter Rabbitson [Sun, 25 Dec 2011 15:27:26 +0000]
Add giftnuss to contributors, awesome triage work

12 years agoInteger default sizes are one point smaller if they are unsigned
Jaime Soriano Pastor [Tue, 20 Dec 2011 17:06:35 +0000]
Integer default sizes are one point smaller if they are unsigned

12 years agoName of unique keys are not written if empty
Jaime Soriano Pastor [Wed, 21 Dec 2011 17:16:00 +0000]
Name of unique keys are not written if empty

12 years agoNames accepted (and ignored) as types of primary keys in create tables
Jaime Soriano Pastor [Tue, 20 Dec 2011 15:57:26 +0000]
Names accepted (and ignored) as types of primary keys in create tables

12 years agoMySQL parsing fails if a table is defined more than once in the same file, if not...
Jaime Soriano Pastor [Mon, 14 Nov 2011 10:36:08 +0000]
MySQL parsing fails if a table is defined more than once in the same file, if not, indices are messed up

12 years agoDefault bits and double quoted strings are parsed now
Jaime Soriano Pastor [Thu, 10 Nov 2011 18:49:17 +0000]
Default bits and double quoted strings are parsed now

12 years agopatch from rt67989 applied, changes dependency from Digest::SHA1 to Digest::SHA
Peter Rabbitson [Sun, 25 Dec 2011 08:31:05 +0000]
patch from rt67989 applied, changes dependency from Digest::SHA1 to Digest::SHA

12 years agoquote SQLite identifiers
Arthur Axel 'fREW' Schmidt [Thu, 14 Jul 2011 15:51:54 +0000]
quote SQLite identifiers

12 years agobetter error messages for the SQLite parser
Arthur Axel 'fREW' Schmidt [Thu, 14 Jul 2011 15:40:27 +0000]
better error messages for the SQLite parser

12 years agoAdd trigger support to PostgreSQL producer and parser (including trigger scope)
Aaron Schrab [Tue, 10 May 2011 22:15:26 +0000]
Add trigger support to PostgreSQL producer and parser (including trigger scope)

PostgreSQL triggers can be fired either once for a statement (the
default), or for each row affected by the statement.  Add support to
declare which type of trigger should is wanted by setting the "scope" of
the trigger.

12 years agoAvoid warning about exiting sub with next
Aaron Schrab [Thu, 12 May 2011 17:43:27 +0000]
Avoid warning about exiting sub with next