Not supporting any MySQL functions! about spider HOT 5 OPEN

You need to add extra functionality in process_sql.py
Look for AGG_OPS global variable and its' usages. Functions can be implemented the same way, but you'll also need to support comma symbol.

from spider.

You need to add extra functionality in process_sql.py
Look for AGG_OPS global variable and its' usages. Functions can be implemented the same way, but you'll also need to support comma symbol.

Thankyou so much for replying
one more question, like the AGG_OPS, have some limited functions, but the MySQL or other databases has lots of functions, so should i have to put all of them in a predefined variable?
And also the comma you are talking ablut, can you elaborate more, like whats the role of it?

from spider.

Yes, you should put all the functions in predefined variable. I think you can start with simply extending AGG_OPS with your function (e.g. date_format) but I don't guarantee you that everything would work as expected as this function has two parameters.

Talking about comma: I think that it may be interpreted incorrectly by the whole parser as currently comma is used only in Select query to separate columns and not to separate parameters of functions (this may mean that there's some code like: split select part by comma and parse each part with easier parser, which would lead to incorrect results because it would simply split date_format call into two separate strings and will try to analyze each of them independently and fail.

from spider.

Oh, thanks, alot for your suggestion, it seems like a lot of work. I have to be very precise on writing the code, specifically for handling the function parameters.
I'll try to make it worked.

from spider.

Hi @CrafterKolyan i tried to write the code that support functions, but i was facing the many difficulties, like to differentiate between the blocks DATE_FORMAT(date_complaint_raised,'%Y-%m') and Count(*), parser getting confused , like which is what. Can you please help in it?

from spider.