Не могу получить записи из бд с помощью findAll() (Sequelize)
Не могу понять почему в условиях когда бд не пуста, findAll() возвращает пустой список.
Код:
import { BasicRepository } from "../domain_service/BasicRepository.js";
import {Sequelize } from "sequelize";
export class ContactRepository extends BasicRepository{
сontactModel;
sequelize;
constructor(connectionString){
super();
this._connectionString = connectionString;
this.sequelize = new Sequelize(this._connectionString);
this.сontactModel = this.sequelize.define('contact',
{
id: {
type: Sequelize.INTEGER,
autoIncrement: true,
primaryKey: true,
allowNull: false
},
firstName: {
type: Sequelize.TEXT
},
lastName: {
type: Sequelize.TEXT
},
email: {
type: Sequelize.TEXT,
unique: true
}
}
);
this.sequelize.sync();
}
getAll(){
return this.сontactModel.findAll({raw:true}).then(contacts=>{
console.log(contacts);
}).catch(err=>console.log(err));
}
}
Вывод:
[Running] node "d:\Учёба мага\Cherepanov\Lab2v3\server\main.js"
Running a GraphQL API server at localhost:4000/graphql
Executing (default): SELECT name FROM sqlite_master WHERE type='table' AND name='contacts';
Executing (default): CREATE TABLE IF NOT EXISTS `contacts` (`id` INTEGER PRIMARY KEY AUTOINCREMENT, `firstName` TEXT, `lastName` TEXT, `email` TEXT UNIQUE, `createdAt` DATETIME NOT NULL, `updatedAt` DATETIME NOT NULL);
Executing (default): PRAGMA INDEX_LIST(`contacts`)
Executing (default): PRAGMA INDEX_INFO(`sqlite_autoindex_contacts_1`)
Executing (default): SELECT `id`, `firstName`, `lastName`, `email`, `createdAt`, `updatedAt` FROM `contacts` AS `contact`;
[]