static init(sequelize) { super.init( { zipcode: DataTypes.STRING, street: DataTypes.STRING, number: DataTypes.INTEGER, }, { sequelize, }, ); }
function models(database) { const bill = database.define("bill", { total_amount: Sequelize.INTEGER }); return bill; }
'type': Sequelize.INTEGER, 'autoIncrement': true, 'primaryKey': true
'type': Sequelize.INTEGER, 'autoIncrement': true, 'primaryKey': true
function order(database) { const order = database.define("order", { status: { type: Sequelize.ENUM("pending", "cancelled", "paid"), defaultValue: "pending" }, shipment_amount: { type: Sequelize.INTEGER, defaultValue: 25 }, total_amount: Sequelize.INTEGER, total_weight: Sequelize.INTEGER }); order.associate = product => { order.hasMany(product, { as: "ProductList" }); }; return order; }
it('load the fixture models file and return into the Promise the sequelize instance', function () { let sequelizeInstance = new Sequelize('my-database', 'mysqlUserName', 'mysqlUserPassword', { 'host': 'localhost', 'dialect': 'sqlite', 'storage': ':memory:', 'define': { 'timestamps': false, 'paranoid': false } }); sequelizeInstance.define('myModel', { 'id': { 'type': Sequelize.INTEGER, 'autoIncrement': true, 'primaryKey': true }, 'description': Sequelize.TEXT }); return sequelizeInstance .sync() .then(function () { return SequelizeMocking .loadFixtureFile(sequelizeInstance, path.resolve(path.join(__dirname, './my-model-database.json'))); }) .then(function (sequelize) { expect(sequelize).equals(sequelizeInstance); }); });
var GetUser = function(modelname) { return sequelize.define(modelname, { slug: { type: Sequelize.STRING, unique: true }, alternateSlug: { type: Sequelize.STRING, unique: true }, givenName: { type: Sequelize.STRING, allowNull: false }, familyName: { type: Sequelize.STRING, allowNull: false }, nickName: { type: Sequelize.STRING, allowNull: true }, age: { type: Sequelize.INTEGER, allowNull: true } }); }
}, age: { type: Sequelize.INTEGER.UNSIGNED, allowNull: false, },
static init(sequelize) { return super.init({ bid: { type: Sequelize.INTEGER, allowNull: false, defaultValue: 0, }, msg: { type: Sequelize.STRING(100), allowNull: true, }, }, { sequelize, timestamps: true, paranoid: true, modelName: 'Auction', tableName: 'auctions', charset: 'utf8', collate: 'utf8_general_ci', }); }
static init(sequelize) { return super.init({ email: { type: Sequelize.STRING(40), allowNull: false, unique: true, }, nick: { type: Sequelize.STRING(15), allowNull: false, }, password: { type: Sequelize.STRING(100), allowNull: true, }, money: { type: Sequelize.INTEGER, allowNull: false, defaultValue: 0, }, }, { sequelize, timestamps: true, paranoid: true, modelName: 'User', tableName: 'users', charset: 'utf8', collate: 'utf8_general_ci', }); }
static init(sequelize) { super.init( { id: { type: DataTypes.INTEGER, allowNull: false, primaryKey: true, autoIncrement: true, }, name: { type: DataTypes.STRING, allowNull: false, }, code: { type: DataTypes.INTEGER, allowNull: false, }, icon: { type: DataTypes.STRING, allowNull: false, }, }, { sequelize, tableName: 'banks', }, ) }
static init(sequelize) { super.init( { name: DataTypes.STRING, email: DataTypes.STRING, age: DataTypes.INTEGER, }, { sequelize, }, ); }
static init(sequelize) { return super.init({ name: { type: Sequelize.STRING(40), allowNull: false, }, img: { type: Sequelize.STRING(200), allowNull: true, }, price: { type: Sequelize.INTEGER, allowNull: false, defaultValue: 0, }, }, { sequelize, timestamps: true, paranoid: true, modelName: 'Good', tableName: 'goods', charset: 'utf8', collate: 'utf8_general_ci', }); }