Welcome to OGeek Q&A Community for programmer and developer-Open, Learning and Share
Welcome To Ask or Share your Answers For Others

Categories

0 votes
206 views
in Technique[技术] by (71.8m points)

javascript - modifying select query before run with Sequelize hooks

I have an order table that have one column called time I store my timestamp as Integer in this filed I have one query like this

Order.findAll(
                    {
                        where : {
                            time: {
                                [sequelize.Op.between]: ['2021/1/1', '2021/1/2']
                            }
                        }
                    }
                )

my dates come from client side in normal format (not unix mode) I want to modify my dates with beforeFind hook I wrote this peace of code in my hook

hooks:{
        beforeFind(args, fn){
            console.log(args.where.time);
        }
}

but the result is

{ [Symbol(between)]: [ '2021/1/1', '2021/1/2'] }

how should i modify dates? what is the key in this object?!

question from:https://stackoverflow.com/questions/65540968/modifying-select-query-before-run-with-sequelize-hooks

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome To Ask or Share your Answers For Others

1 Reply

0 votes
by (71.8m points)

I find the answer I can access to my first date with

args.where.time[Sequelize.Op.between][0]

in my beforeFind hook


与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
OGeek|极客中国-欢迎来到极客的世界,一个免费开放的程序员编程交流平台!开放,进步,分享!让技术改变生活,让极客改变未来! Welcome to OGeek Q&A Community for programmer and developer-Open, Learning and Share
Click Here to Ask a Question

...