Questions tagged [feathers-sequelize]
81 questions
0
votes
1 answer
feathers js get custom attribute value
I'm first time using feathers and Sequelize.
I want ask something for the example I have data user
name: 'user b',
email:'userb@mail.com',
createdAt:'2022-02-02',
updatedAt: '2022-02-02',
}
my expected return
name: 'user b',
email:…
Nugraha
- 23
- 2
0
votes
1 answer
Search for a string with spaces in sequelize for postgres
I am looking for a way to search for a string with spaces in postgres using sequelize.
I have a database named library with a books table. This has a title and author column in there.I have tried using iLike but this wasn't very fruitful, the search…
Youzef
- 616
- 1
- 6
- 23
0
votes
0 answers
Pull in specific records/rows based on field in Sequelize
So a basic Sequelize query I'm working with (minus fluff for simplicity sake) looks like this:
{ model: Contact,
required: true,
attributes: ['FullName', 'Country'],
include: [
{
model: Rank,
…
Chance
- 33
- 4
0
votes
1 answer
Feathersjs find request "invalid query parameter" error with reactjs
When I add $show:true to the data (shown below), the find request shows an error.
When I remove $show:true, there is no error and working fine.
Error is
Invalid query parameter $show.
I tried using different $values but the server always shows…
TylerKenFleck
- 11
- 3
0
votes
1 answer
How to find all that don't belong to a specific id in belongsToMany?
I have the following models:
const users = sequelize.define('users', { /* definition */ }
const messageGroups = sequelize.define('message_groups', { /* definition */ }
They are associated like this:
models.messageGroups.belongsToMany(models.users,…
forgot
- 2,160
- 2
- 19
- 20
0
votes
1 answer
Sequelize include multiple tables in query
So i have the following structure receipts -> policies -> policholders
Every receipt belongs to a policy and every policy belong to a policyholder
What i want to do is when i fetch receipts i get an object back with the both the policy and…
Josh Fradley
- 545
- 1
- 10
- 23
0
votes
1 answer
Feathers sequelize find by associated column
I am trying to filter data based upon the value of an associated table, it works fine when i do a find all but when i try to search by name i get a column does not exist error
i have set up a hook like explained in…
Josh Fradley
- 545
- 1
- 10
- 23
0
votes
1 answer
RESTful CRUD to just one or multiple services
If I have a simple datastructure that would just require one service (formular) to also handle its related data in other tables (formgroups, fields).
How to distinguish, if it's an update operation or a create operation with new inserted data in…
orbitkorbi
- 45
- 5
0
votes
1 answer
Error on FeathersJS connecting to PostgreSQL
I am new to FeathersJS and trying to connect it with PostgreSQL, but I am having trouble with SequelizeConnection, it shows me this error
info: Feathers application started on http://localhost:3030
error: Unhandled Rejection at:…
user9539780
0
votes
1 answer
Nothing returned in feathersjs before hook sequelize association
I've created a before hook in my users service that's meant to include a record from the organizations model. The relationship between users and organizations is
users.belongsToMany(models.organizations,{through: 'users_to_organizations'});
The…
Jeremy Brooks
- 11
- 2
0
votes
0 answers
Sequelize Node.js Model not associated to model
I have two models in my Node JS application, Users and Companies. When I try to use the include function when getting the companies, I get the error:
message: "users is not associated to companies!"
This is the user model
import { Sequelize,…
grant macdonald
- 25
- 6
0
votes
1 answer
Sequelize where scope with an joined table
I have a belongs to many relationship with a joined table
courseTree.associate = function (models) {
models.courses.belongsToMany(models.courses, {
through: 'course_tree',
as: 'children',
foreignKey: 'parent_id',
…
S.Visser
- 4,645
- 1
- 22
- 43
0
votes
0 answers
How to achieve Master-Details with quasar is qtable
I would like to know how to achieve Master details using two q-tables. Such that when a row is selected in qtable(staffs) the whole details is shown in qtable (staff_details).
Ebena107
- 93
- 10
0
votes
1 answer
Design Patterns for enriching Feathers services with relational records
I am trying to create a simple app, with a data one-to-many relationship. Where a site contains many locations. I am using feathers js and sequelize (with sqlite). The standard GET functionality in feathers will return a site or a list of sites.…
George Edwards
- 8,979
- 20
- 78
- 161
0
votes
1 answer
FeathersJS Inserts 2 records into MySql from 1 REST call
When I use the .create(item) method to do an INSERT from the client (within the browser) I see 1 call via websocket or REST go to feathersjs. I see one request go into Feathersjs. For an unknown reason I see 2 rows created in MySql and 2 lines in…
JasonWilson
- 136
- 7