59 lines
1.7 KiB
JavaScript
59 lines
1.7 KiB
JavaScript
'use strict';
|
|
|
|
var _ = require('lodash')
|
|
, Abstract = require('../abstract')
|
|
, ConnectionManager = require('./connection-manager')
|
|
, Query = require('./query')
|
|
, QueryGenerator = require('./query-generator')
|
|
, DataTypes = require('./data-types');
|
|
|
|
var PostgresDialect = function(sequelize) {
|
|
this.sequelize = sequelize;
|
|
this.connectionManager = new ConnectionManager(this, sequelize);
|
|
this.connectionManager.initPools();
|
|
|
|
// parseDialectSpecificFields needs access to the pg lib in order to use its array parser. We cannot simply require pg in query.js since the user can specify another library path (such as pg-native etc)
|
|
Query.prototype.parseDialectSpecificFields.lib = this.connectionManager.lib;
|
|
|
|
this.QueryGenerator = _.extend({}, QueryGenerator, {
|
|
options: sequelize.options,
|
|
_dialect: this,
|
|
sequelize: sequelize
|
|
});
|
|
};
|
|
|
|
PostgresDialect.prototype.supports = _.merge(_.cloneDeep(Abstract.prototype.supports), {
|
|
'DEFAULT VALUES': true,
|
|
'EXCEPTION': true,
|
|
'ON DUPLICATE KEY': false,
|
|
'ORDER NULLS': true,
|
|
returnValues: {
|
|
returning: true
|
|
},
|
|
schemas: true,
|
|
lock: true,
|
|
lockOf: true,
|
|
lockKey: true,
|
|
lockOuterJoinFailure: true,
|
|
forShare: 'FOR SHARE',
|
|
index: {
|
|
concurrently: true,
|
|
using: 2,
|
|
where: true
|
|
},
|
|
NUMERIC: true,
|
|
ARRAY: true,
|
|
JSON: true,
|
|
JSONB: true,
|
|
deferrableConstraints: true
|
|
});
|
|
|
|
PostgresDialect.prototype.Query = Query;
|
|
PostgresDialect.prototype.DataTypes = DataTypes;
|
|
PostgresDialect.prototype.name = 'postgres';
|
|
PostgresDialect.prototype.TICK_CHAR = '"';
|
|
PostgresDialect.prototype.TICK_CHAR_LEFT = PostgresDialect.prototype.TICK_CHAR;
|
|
PostgresDialect.prototype.TICK_CHAR_RIGHT = PostgresDialect.prototype.TICK_CHAR;
|
|
|
|
module.exports = PostgresDialect;
|