uftell.blogg.se

This tutorial explains how to make Sequelize recognize new datatypes and assumes that those new datatypes are already created in the database. Sequelize doesn't create new datatypes in the database. If a new datatype is not included, this manual will show how to write it yourself. Most likely the type you are trying to implement is already included in DataTypes. If you are working with the PostgreSQL TIMESTAMP WITHOUT TIME ZONE and you need to parse it to a different timezone, please use the pg library's own parser: require('pg').tTypeParser(1114, stringValue => ) Extending datatypes When you do a find or findAll on a model which has a BLOB column, that data will always be returned as a buffer. The BLOB datatype allows you to insert data both as strings and as buffers. Sequelize.GEOMETRY('POINT', 4326) // Spatial column with geometry type and SRID. Sequelize.GEOMETRY('POINT') // Spatial column with geometry type. Sequelize.ARRAY(Sequelize.RANGE(Sequelize.DATE)) // Defines array of tstzrange ranges. Sequelize.RANGE(Sequelize.DECIMAL) // Defines numrange range.

Sequelize.RANGE(Sequelize.DATEONLY) // Defines daterange range. Sequelize.RANGE(Sequelize.DATE) // Defines tstzrange range. Sequelize.RANGE(Sequelize.BIGINT) // Defined int8range range. Sequelize.RANGE(Sequelize.INTEGER) // Defines int4range range. Sequelize.MACADDR // MACADDR datatype for PostgreSQL Sequelize.INET // INET datatype for PostgreSQL Sequelize.CIDR // CIDR datatype for PostgreSQL Sequelize.UUID // UUID datatype for PostgreSQL and SQLite, CHAR(36) BINARY for MySQL (use defaultValue: Sequelize.UUIDV1 or Sequelize.UUIDV4 to make sequelize generate the ids automatically) Sequelize.BLOB('tiny') // TINYBLOB (bytea for PostgreSQL. Sequelize.BLOB // BLOB (bytea for PostgreSQL) Sequelize.ARRAY(Sequelize.ENUM) // Defines an array of ENUM. Sequelize.ARRAY(Sequelize.TEXT) // Defines an array. Sequelize.ENUM('value 1', 'value 2') // An ENUM with allowed values 'value 1' and 'value 2' Fractional seconds support with up to 6 digits of precision Sequelize.DATE(6) // DATETIME(6) for mysql 5.6.4+. Sequelize.DATE // DATETIME for mysql / sqlite, TIMESTAMP WITH TIME ZONE for postgres Sequelize.REAL(11) // REAL(11) PostgreSQL only. Sequelize.CITEXT // CITEXT PostgreSQL and SQLite only.

For a full and updated list, see DataTypes. Below are some of the datatypes supported by sequelize.