javascript - Sequelize include model attributes not working -


i need select 2 instances same model eager loading fields need, attributes property not working on include objects

db.company.findall({                 where: {                     industry: stock.industry                 },                 attributes:['id'],                 include:[{                     model: db.price,                     as: 'lastprice',                     attributes:['adjclose'],                     limit: 1,                     order: '"createdat" desc'                 },                 {                     model: db.price,                     as: 'comparisonprice',                     attributes:['adjclose'],                     where:{                         createdat:{                             $lte: comparisondate,                             $gte: limitdate                         }                     },                     limit: 1,                     order: '"createdat" desc'                 }]             })

since need different instances same model associations are

company.hasmany(models.price,{     as: 'lastprice',     foreignkey:"companyid" });  company.hasmany(models.price,{     as: 'comparisonprice',     foreignkey:"companyid" });

and got error

typeerror: cannot read property 'push' of undefined @ c:\users\arhov\documents\projects\finstead\node_modules\sequelize\lib\associations\has-many.js:331:64 @ array.foreach (native) @ .<anonymous> (c:\users\arhov\documents\projects\finstead\node_modules\sequelize\lib\associations\has-many.js:330:13) @ trycatcher (c:\users\arhov\documents\projects\finstead\node_modules\sequelize\node_modules\bluebird\js\release\util.js:16:23) @ promise._settlepromisefromhandler (c:\users\arhov\documents\projects\finstead\node_modules\sequelize\node_modules\bluebird\js\release\promise.js:510:31) @ promise._settlepromise (c:\users\arhov\documents\projects\finstead\node_modules\sequelize\node_modules\bluebird\js\release\promise.js:567:18) @ promise._settlepromise0 (c:\users\arhov\documents\projects\finstead\node_modules\sequelize\node_modules\bluebird\js\release\promise.js:612:10) @ promise._settlepromises (c:\users\arhov\documents\projects\finstead\node_modules\sequelize\node_modules\bluebird\js\release\promise.js:691:18) @ async._drainqueue (c:\users\arhov\documents\projects\finstead\node_modules\sequelize\node_modules\bluebird\js\release\async.js:138:16) @ async._drainqueues (c:\users\arhov\documents\projects\finstead\node_modules\sequelize\node_modules\bluebird\js\release\async.js:148:10) @ immediate.async.drainqueues (c:\users\arhov\documents\projects\finstead\node_modules\sequelize\node_modules\bluebird\js\release\async.js:17:14) @ runcallback (timers.js:570:20) @ tryonimmediate (timers.js:550:5) @ processimmediate [as _immediatecallback] (timers.js:529:5)

what wrong code , how should retrieve columns need.


-

Comments

Post a Comment

Popular posts from this blog

java - SSE Emitter : Manage timeouts and complete() -

i writing web app multiple listeners(evcentsource sse clients js) connected server . want store sse emitter per connected listener : can done in memory or other means assigning id each client able achieve far now question ; how send response/event specific client connected web app ? while doing sseemmiters stored either getting completed or timed out. how prevent ? how keep sseemmiter available open infinite time (till client closes) , send events selectively .
Read more

jquery - uncaught exception: DataTables Editor - remote hosting of code not allowed -

i'm trying implement crud operation using datatableseditor using datatables.but i'm getting error messages: 1)uncaught exception: datatables editor - remote hosting of code not allowed. please see http://editor.datatables.net details on how purchase editor license 2)typeerror: a.editor undefined 3) $.fn.datatable.editor not constructor" what reason? here configuration: <%@ page language="java" contenttype="text/html; charset=iso-8859-1" pageencoding="iso-8859-1"%> <!doctype html public "-//w3c//dtd html 4.01 transitional//en" "http://www.w3.org/tr/html4/loose.dtd"> <html> <head> <meta http-equiv="content-type" content="text/html; charset=iso-8859-1"> <title>insert title here</title> <link rel="stylesheet" type="text/css" href="//cdn.datatables.net/1.10.12/css/jquery.datatables.min.css"> <link re...
Read more

java - How to resolve error - package com.squareup.okhttp3 doesn't exist? -

i trying convert json java object use of gson in maven, following youtube video guidance - https://www.youtube.com/watch?v=vqgghm9pwe0 , theres error occurs when in main class error - package com.squareup.okhttp3 doesn't exist. code below: java package com.codebeasty.json; import com.squareup.okhttp3.okhttpclient; public class main { private static okhttpclient client = new okhttpclient(); public static void main (string [] args) { } } i put in dependency in pom.xml: <dependencies> <dependency> <groupid>com.squareup.okhttp3</groupid> <artifactid>okhttp</artifactid> <version>3.4.2</version> </dependency> <dependency> <groupid>com.google.code.gson</groupid> <artifactid>gson</artifactid> <version>2.8.0</version> </dependency> </dependencies> i dont understand why doesn't recognize com.squareup. there may need download? have downl...
Read more