use function in stored procedure in mysql -


i have created stored procedure in mysql:

create definer=`root`@`localhost` procedure `get_publicationsbydate`(in _dates date, in _datef date) begin      select          concat(extract(year filed_date), " q", extract(quarter filed_date)) date,          count(concat(extract(year filed_date), " q", extract(quarter filed_date))) count              applications             filed_date between _dates , _datef     group         concat(extract(year filed_date), " q", extract(quarter filed_date))     order         concat(extract(year filed_date), " q", extract(quarter filed_date));  end

i want replace long code 

concat(extract(year filed_date), " q", extract(quarter filed_date))

of function call (еxample in pseudo c ++ convenience):

char* func(char* date) { return concat(extract(year date), " q", extract(quarter date)) }

because these long expressions may vary depending on external parameter (pseudo code):

declare f function;  if (_type = 0)     set f = func1; else     set f = func2; end if;  select f(filed_date), count(f(filed_date))...

how in mysql create it?

create function decide problem.

it pity function of external

create definer=`root`@`localhost` function `prepare_scalecondition`(_scale varchar(16), _date date) returns varchar(64) charset utf8 begin     declare _scalecondition varchar(128) default extract(year _date);      case _scale         when 'quarter' set _scalecondition = concat(extract(year _date), ' q', extract(quarter _date));         when 'year' set _scalecondition = extract(year _date);         when 'month' set _scalecondition = concat(extract(year _date), ' m', extract(month _date));         when 'week' set _scalecondition = concat(extract(year _date), ' w', extract(week _date));     end case;      return _scalecondition; end  create definer=`root`@`localhost` procedure `get_publicationsbydate`(in _dates date, in _datef date) begin      select          prepare_scalecondition(filed_date) date,          count(prepare_scalecondition(filed_date)) count              applications             filed_date between _dates , _datef     group         prepare_scalecondition(filed_date)     order         prepare_scalecondition(filed_date);  end

-

Comments

Post a Comment

Popular posts from this blog

angular - Is it possible to get native element for formControl? -

i've got angular2 reactive form . created formcontrol s , assigned input fields by [formcontrol]=... . understand creates nativeelement <-> formcontrol link. my question: possible nativeelement formcontrol ? wanna myformcontrol.nativeelement.focus() i can share 1 terrible solution works me. in reactive forms can use either 1) formcontroldirective ts mycontrol = new formcontrol('') template <input type="text" [formcontrol]="mycontrol"> or 2) formcontrolname ts myform: formgroup; constructor(private fb: formbuilder) {} ngoninit() { this.myform = this.fb.group({ foo: '' }); } template <form [formgroup]="myform"> <input type="text" formcontrolname="foo"> </form> so these directives write patch like 1) formcontroldirective const originformcontrolngonchanges = formcontroldirective.prototype.ngonchanges; formcontroldirective.proto
Read more

unity3d - Rotate an object to face an opposite direction -

i have object , b. when click on object b, rotates object b (a faces b). b doesn't face a. need following : when faces b, need face opposite direction. have code rotating @ b. how rotate face opposite direction after that? vector3 targetdirection = target - transform.position; float step = speed * time.deltatime; vector3 newdirection = vector3.rotatetowards (turretdome.transform.forward, targetdirection, step, 0.0f); turretdome.transform.rotation = quaternion.lookrotation (newdirection); you object facing object b, want inverse direction of object after that? objecta.transform.rotation = quaternion.inverse(objecta.transform.rotation) but lets assume example turretdome object a, (negate direction): turretdome.transform.rotation = quaternion.lookrotation (-newdirection); naturally, both of these snippets not show how smoothen rotation, seem know how use time.deltatime. just incase unsure, quaternion.lerp this
Read more

javascript - Why jQuery Select box change event is now working? -

i working on product filters user select select box according his/her preference not getting selected value user in jquery. html code:- <select name="product_filter" id="product_filter"> <option value="price_low_first">price : low high</option> <option value="price_high_first">price : high low</option> <option value="latest">latest</option> <option value="popular">most popular</option> </select> jquery code: $(function () { $("#product_filter").change(function () { alert("hi") var selectedtext = $(this).find("option:selected").text(); var selectedvalue = $(this).val(); alert("selected text: " + selectedtext + " value: " + selectedvalue); }); }); hi believe code perfect. once please check jquery.min.js
Read more