>Perhaps you can post the results of p(Marshal.dump(r)) for both cases:
>with the select, and with the stored procedure.
Here are the outputs (p(Marshal.dump(r)) of the last 4 recs from the stored
proc:
"\x04\b{\x10:\x0Epricedateu:\tTime\r\x04^\e\x80\x00\x00\x00\x00:\fholidayi\x00:\x0Fweekenddayi\x06:\vsymbol0:\x13instrumenttype0:\x0Eopenprice0:\x0Ehighprice0:\rlowprice0:\x0Fcloseprice0:\vvolume0:\x11openinterest0"
"\x04\b{\x10:\x0Epricedateu:\tTime\r$^\e\x80\x00\x00\x00\x00:\fholidayi\x00:\x0Fweekenddayi\x00:\vsymbol\"\tMSFT:\x13instrumenttype\"\x06S:\x0Eopenpricef\x1A23.319999694824201\x00\xFF\xFB:\x0Ehighpricef\x1A23.600000381469702\x00\xFF\xF9:\rlowpricef\x1823.2299995422363\x00\xFF\xF8:\x0Fclosepricef\n23.25:\vvolumei\x04\xD8\x1A\x88\x02:\x11openinteresti\x00"
"\x04\b{\x10:\x0Epricedateu:\tTime\rD^\e\x80\x00\x00\x00\x00:\fholidayi\x00:\x0Fweekenddayi\x00:\vsymbol\"\tMSFT:\x13instrumenttype\"\x06S:\x0Eopenpricef\x1A23.290000915527301\x00\xFF\xF4:\x0Ehighpricef\x1A23.649999618530298\x00\x00\a:\rlowpricef\x1823.2700004577637\x00\x00\b:\x0Fclosepricef\x1A23.579999923706101\x00\x00\r:\vvolumei\x04P%Q\x02:\x11openinteresti\x00"
"\x04\b{\x10:\x0Epricedateu:\tTime\rd^\e\x80\x00\x00\x00\x00:\fholidayi\x00:\x0Fweekenddayi\x00:\vsymbol\"\tMSFT:\x13instrumenttype\"\x06S:\x0Eopenpricef\n23.25:\x0Ehighpricef\x1A23.719999313354499\x00\x00\x02:\rlowpricef\n23.25:\x0Fclosepricef\x1A23.649999618530298\x00\x00\a:\vvolumei\x040'~\x02:\x11openinteresti\x00"
and here are the last 4 from the select
"\x04\b{\x11:\x0Epricedate0:\fholidayi\x00:\x0Fweekenddayi\x06:\rexchange0:\vsymbol0:\x13instrumenttype0:\x0Eopenprice0:\x0Ehighprice0:\rlowprice0:\x0Fcloseprice0:\vvolume0:\x11openinterest0"
"\x04\b{\x11:\x0Epricedate0:\fholidayi\x00:\x0Fweekenddayi\x06:\rexchange0:\vsymbol0:\x13instrumenttype0:\x0Eopenprice0:\x0Ehighprice0:\rlowprice0:\x0Fcloseprice0:\vvolume0:\x11openinterest0"
"\x04\b{\x11:\x0Epricedateu:\tTime\r$^\e\x80\x00\x00\x00\x00:\fholidayi\x00:\x0Fweekenddayi\x00:\rexchange\"\tNASD:\vsymbol\"\tMSFT:\x13instrumenttype\"\x06S:\x0Eopenpricef\x1A23.319999694824201\x00\xFF\xFB:\x0Ehighpricef\x1A23.600000381469702\x00\xFF\xF9:\rlowpricef\x1823.2299995422363\x00\xFF\xF8:\x0Fclosepricef\n23.25:\vvolumei\x04\xD8\x1A\x88\x02:\x11openinteresti\x00"
"\x04\b{\x11:\x0Epricedateu:\tTime\rD^\e\x80\x00\x00\x00\x00:\fholidayi\x00:\x0Fweekenddayi\x00:\rexchange\"\tNASD:\vsymbol\"\tMSFT:\x13instrumenttype\"\x06S:\x0Eopenpricef\x1A23.290000915527301\x00\xFF\xF4:\x0Ehighpricef\x1A23.649999618530298\x00\x00\a:\rlowpricef\x1823.2700004577637\x00\x00\b:\x0Fclosepricef\x1A23.579999923706101\x00\x00\r:\vvolumei\x04P%Q\x02:\x11openinteresti\x00"
here's the stored proc:
CREATE definer=`ro...@`localhost` PROCEDURE `GetInstRecs`(SYM varchar(28),
INSTTYPE varchar(2))
BEGIN
declare FROMDATE date;
declare TODATE date;
call GetMinMaxDates(SYM,INSTTYPE, FROMDATE,TODATE );
SELECT m.pricedate , m.holiday, m.weekendday, p.symbol, p.instrumenttype,
p.openprice,
p.highprice, p.lowprice, p.closeprice, p.volume, p.openinterest
FROM masterdates m left join pricedata p
on m.pricedate = p.pricedate and p.symbol = SYM and p.instrumenttype =
INSTTYPE
where m.pricedate >= FROMDATE and m.pricedate <= TODATE;
END
and here's how I call it:
dataset = DB['call GetInstRecs(\'MSFT\', \'S\')']
and here's the sequel select version
dataset = DB[:masterdates].left_outer_join(:pricedata, :pricedate =>
:pricedate, :symbol => 'MSFT', :instrumenttype =>
'S').filter('(masterdates.pricedate > ?) and (masterdates.pricedate < ?)',
'2000-01-01', '2009-08-19')
On Fri, Sep 25, 2009 at 3:27 PM, Aman Gupta <[email protected]>wrote:
>
> Perhaps you can post the results of p(Marshal.dump(r)) for both cases:
> with the select, and with the stored procedure.
>
> Aman
>
> On Fri, Sep 25, 2009 at 12:19 PM, David Jenkins <[email protected]>
> wrote:
> > Hi, John
> >
> > Thanks for the suggestions. Using :holiday does the same thing, i.e., I
> > can't use it in an "if" test. I also tried setting a variable,
> "some_var"
> > to r[:weekendday], and sure enough it gets set to 0 or 1, and its class
> is
> > Fixnum.
> >
> > Again, since this works with a select statement and not when I use a
> stored
> > proc that returns a dataset, it seems to be a problem with the latter.
> I'm
> > am trying to debug the sequel code in NetBeans 6.7, but I'm getting weird
> > results: it keeps stopping on comment lines, as if the file it's showing
> is
> > not the file it's running (and the file its actually running has actual
> > non-comment code on those lines) -- the file in question being mysql.rb.
> >
> >
> >
> > On Fri, Sep 25, 2009 at 3:10 PM, John W Higgins <[email protected]>
> wrote:
> >>
> >>
> >> On Fri, Sep 25, 2009 at 11:49 AM, David Jenkins <[email protected]>
> >> wrote:
> >>>
> >>> tried p r[:weekendday].class, all Fixnum
> >>> :(
> >>
> >> Try using :holiday instead - looks like the same semantics in terms of
> >> data type but it might help figure out if it's a field issue or
> something
> >> else.
> >>
> >> Also try setting another variable with the value and then testing that
> to
> >> see if there is something else funky going on with the local
> representation.
> >> I would say at this point you're down to documenting every stage and
> seeing
> >> where this goes off track.
> >>
> >> Most times these types of things are nothing more then some weird
> anomaly
> >> but if you poke and prod around the issue sometimes you get the right
> clue.
> >>
> >> Sorry I don't have a silver bullet - but sometimes the bullet companies
> >> are on strike :)
> >>
> >> John
> >>
> >>
> >
> >
> > >
> >
>
> >
>
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sequel-talk" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/sequel-talk?hl=en
-~----------~----~----~----~------~----~------~--~---
