Permalink
Commits on Jun 30, 2018
  1. fix(Column): Explicitly name default constraint for MSSQL

    elpete committed Jun 30, 2018
    * update MSSQL for DEFAULT constraint
    
    * Fix failing test for `last`
    
    * Update MSSQL tests and wrap default constriant name
    
    * Allow for a table level `default` for removing default constraints with generated names
    
    This method won't actually create a constraint, but it is used for removing constraints
    with auto-generated names.
    
    For instance, if you used the default name in
    ```
    schema.create( "my_table", function( table ) {
        table.boolean( "trueOrFalse" ).default( 0 );
    } );
    
    ```
    it may not be obvious that the constraint name is `df_my_table_trueOrFalse`.
    
    This method let's you stay oblivious to the auto-generated name when dropping the constraint.
    
    ```
    schema.alter( "my_table", function( table ) {
        table.dropConstraint( table.default( "trueOrFalse" ) );
        table.dropColumn( "trueOrFalse" );
    } );
    ```
Commits on Mar 14, 2018
Commits on Mar 12, 2018
  1. feat(Grammar): Added official support for MSSQL, Oracle, and Postgres. (

    elpete committed Mar 12, 2018
    coldbox-modules#34)
    
    Full QueryBuilder and SchemaBuilder support for all four database grammars
    (MSSQL, MySQL, Oracle, and Postgres).
    Revamped test suite to have consistent grammar test coverage.
    
    Squashed commits:
    Finalize Oracle Grammar (+8 squashed commits)
    [d5497d9] Lots of Oracle work
    [8058f41] Migrate Oracle Query Builder spec
    [9a2668d] Fix for Lucee compatibility
    [6ffe7f2] Fully support MSSQL
    [4df2364] Flesh out MSSQL Query Builder support
    [3df7d5e] Test shuffling to make it easier to add new grammars
    [faa872e] Finish converting MySQL Schema tests to the new format.
    [a636f23] Add Postgres Grammar for Schema
Commits on Feb 20, 2018
  1. perf(QueryBuilder): Replace normalizeToArray with simpler Array check

    elpete committed Feb 20, 2018
    normalizeToArray handles the case where variadic arguments are passed in.
    This comes at a cost, about 50 ms.
    
    Speed is everything when testing against a database.
  2. perf(BaseGrammar): Avoid isInstanceOf in wrapColumn

    elpete committed Feb 20, 2018
    `isInstanceOf` takes about 30-40 ms per column.  For just one table with
    6 columns, this is close to a quarter of a second.  This adds up.
    
    Instead, just checking if the variable is an object that has a `getSQL`
    key (which we assume is a method), we save all of that time.
Commits on Feb 19, 2018
Commits on Feb 16, 2018
  1. feat(SchemaBuilder): Add dropAllObjects action. (coldbox-modules#31)

    elpete committed Feb 16, 2018
    compileDropAllObjects needs to be implemented in every Grammar.
    By default, it throws an exception.  Only a MySQLGrammar implementation
    currently exists.
Commits on Jan 25, 2018
Commits on Nov 22, 2017
  1. Updated API Docs

    elpete committed Nov 22, 2017
  2. 5.0.2

    elpete committed Nov 22, 2017
  3. 5.0.1

    elpete committed Nov 22, 2017
Commits on Nov 14, 2017
  1. docs(box.json): Remove extra period in description

    elpete committed Nov 14, 2017
    Remove period as it is not needed for a single sentance
  2. 5.0.0

    elpete committed Nov 14, 2017
Commits on Nov 8, 2017
  1. Add @tonyjunkes as a contributor

    elpete committed Nov 8, 2017
Commits on Oct 25, 2017
  1. Updated API Docs

    elpete committed Oct 25, 2017
  2. 5.0.0

    elpete committed Oct 25, 2017
  3. Updated API Docs

    elpete committed Oct 25, 2017
  4. 4.1.0

    elpete committed Oct 25, 2017
Commits on Sep 30, 2017
  1. Greatly simplify drop column

    elpete committed Sep 30, 2017
  2. Add rename index

    elpete committed Sep 30, 2017
Commits on Sep 29, 2017
  1. Organize code

    elpete committed Sep 29, 2017
Commits on Sep 27, 2017
  1. Add docblocks to TableIndex

    elpete committed Sep 27, 2017
  2. Add docblocks to Column

    elpete committed Sep 27, 2017
Commits on Sep 25, 2017