chrdevmar/merge-sequelize-options

Utility for merging sequelize options objects

merge-sequelize-options's Issues

[order] implement merging for Association Name syntax

implement merging of order clauses defined with the following syntax:

Subtask.findAll({
  order: [
    // Will order by an associated model's created_at using the name of the association.
    ['Task', 'createdAt', 'DESC']
  ]
})

[order] implement merging for non-array 'sequelize.fn()' syntax

implement merging of order options declared with the following syntax:

Subtask.findAll({
  // Will order by max age ascending assuming ascending is the default order when direction is omitted
  order: sequelize.fn('max', sequelize.col('age'))
})

[order] implement merging 'sequelize.fn()' syntax

implement merging for order options declared with the following syntax:

Subtask.findAll({
order: [
// Will order by max(age)
sequelize.fn('max', sequelize.col('age')),
]
})

[order] implement merging for Nested Association Model Name syntax

implement merging for order clauses declared with the following syntax:

Subtask.findAll({
  order: [
    // Will order by a nested associated model's created_at using the names of the associations.
    ['Task', 'Project', 'createdAt', 'DESC']
  ]
})

[order] implement merging for 'sequelize.fn()' syntax

implement logic for merging order elements declared with the following syntax:

Subtask.findAll({
  order: [
    // Will order by max(age)
    sequelize.fn('max', sequelize.col('age')),
  ]
})

[order] implement merging for Associated Model Class syntax

implement merging for order clauses defined with the following syntax:

Subtask.findAll({
  order: [
    // Will order an associated model's created_at using the model name as the association's name.
    [Task, 'createdAt', 'DESC'],

    // Will order by an associated model's created_at using an association object. (preferred method)
    [Subtask.associations.Task, 'createdAt', 'DESC'],
  ]
})

[order] implement merging for 'sequelize.col()' syntax

implement merging of order options declared with the following syntax:

Subtask.findAll({
  // Will order by age ascending assuming ascending is the default order when direction is omitted
  order: sequelize.col('age')
})

[order] implement merging for 'sequelize.random()' syntax

implement merging of order options with the following syntax:

Subtask.findAll({
  // Will order randomly based on the dialect (instead of fn('RAND') or fn('RANDOM'))
  order: sequelize.random()
})

[order] implement merging for Associated Model Name syntax

implement merging of order options declared with the following syntax:

Subtask.findAll({
  order: [
    // Will order by an associated model's created_at using the name of the association.
    ['Task', 'createdAt', 'DESC']
  ]
})

[order] implement merging for Association Object syntax

implement merging of order options declared with the following syntax:

Subtask.findAll({
  order: [
    // Will order by an associated model's created_at using a simple association object.
    [{model: Task, as: 'Task'}, 'createdAt', 'DESC']
  ]
})

[order] implement merging for array 'sequelize.fn()' syntax

implement merging for order clauses defined with the following syntax:

Subtask.findAll({
  order: [
    // Will order by max(age) DESC
    [sequelize.fn('max', sequelize.col('age')), 'DESC'],
  ]
})

[order] implement merging for 'sequelize.literal()' syntax

implement merging of order options declared with the following syntax:

Subtask.findAll({
  // Will order by max age descending
  order: sequelize.literal('max(age) DESC')
})

[order] implement merging for Nested Association Object syntax

implement merging of order options declared with the following syntax:

Subtask.findAll({
  order: [
    // Will order by a nested associated model's created_at simple association objects.
    [{model: Task, as: 'Task'}, {model: Project, as: 'Project'}, 'createdAt', 'DESC']
  ]
})

test

this will probably not show in the list of issues

[order] implement merging for Nested Associated Model Class syntax

implement merging of order clauses defined with the following syntax:

Subtask.findAll({
  order: [
    // Will order through an associated model's created_at using the model names as the associations' names.
    [Task, Project, 'createdAt', 'DESC'],

    // Will order by a nested associated model's created_at using association objects. (preferred method)
    [Subtask.associations.Task, Task.associations.Project, 'createdAt', 'DESC'],
  ]
})