user-pic

byterock

  • About: Long time Perl guy, a few CPAN mods allot of work on DBD::Oracle and a few YAPC presentations
  • Posted No Longer a Baby Moose to byterock

    Another test postette today here in the Moose-Pen;

    Carrying on from yesterday I took the time today to first add in this to my new test call


    ...
    $da->retrieve($self->connect());
    -- my $ok = ok(
    ++ my $ok = ok(

  • Posted Just a Baby Moose to byterock

    It quick postette day again here in the Moose-Pen

    Just a quick one off re-factor for today. In the past few days I have been using a code snipitte like this;


    my $tests = [{
    key =>'sorts',
    sorts => [
    {name …

  • Posted Sorting Out Baby Moose to byterock

    Its sort day here in the Moose-Pen.

    Well I have been on a role since I started on 'Group By' so I figure I might as well get the last of the base SQL code snippets in place. The last one is 'sort' or in SQL 'ORDER BY' and why change something that isn't broke here is a new test case '

  • Posted Gather Up Even More Moose to byterock

    It another gather day here in the Moose-Pen.

    Now that I did the re-factoring for gather it is time to move on the Driver::DBI and do to code to generate the SQL. Of course I always start with a test case and this time it is a new one ="https://github.com/byterock/database-accessor-d…

  • Posted Gather Up Baby Moose to byterock

    Its gather in the dream day here in the Moose-pen

    Well going to skip a post on creating a gaggle of new tests today and instead do some core coding in Driver::DBI and Database::Accessor. Now believe it or not I had a dream last night that something was wrong in the way I set the architec…

  • Posted Baby Moose Link to byterock

    Its link day here in the Moose-Pen

    Well seeing as my elements/fields and conditions/Where are working quite well I think it is time to move on to the next attribute in Accessor.pm Links.

    In SQL joins are the same as Database::Accessor Links so given this SQL;

  • Posted Baby Moose Where? to byterock

    Its where day in the Moos-Pen

    Today I am going to expand on the '20_where_basic.t' test case going from a simple one level Element to Param 'where clause' such as


    SELECT people.first_name, people.last_name, people.user_id FROM people WHERE ( peop…

  • Posted Back to Momma Moose to byterock

    Just another quick test postette day here in the Moose Pen.

    As we seen in this post I found a bug where I was not coercing correctly on deeply nested Element Attributes. So that means back into the test suite…

  • Posted Matureing Baby Moose to byterock

    Its re-factor test postette day in the Moose-Pen

    Over the past few days I have made up quite a few tests and they where all the same pattern

    • Base hash
    • add function/expression element
    • create DA
    • run select/retrieve
    • check SQL
    • ch…
  • Posted Baby Fancy Moose to byterock

    Its get fancy day here in the Moose-Pen

    Now that I have 'Functions' nicely working I am going to move on to the next logical field and that is an 'Expression'. In SQL (and 99.9% of other languages) an expression is just a predicate that can be evaluated. So an SQL like this

  • Posted Baby Moose Recursion Dance to byterock

    It carry on with recursion day here in the Moose-Pen

    Carrying on from where I left off in yesterday's post I was about to add in this new test;


    $in_hash->{elemen…

  • Posted Ambitious Baby Moose to byterock

    Its get back into Driver::DBI day today here in the Moose-Pen

    I decided to get a little more ambitious and see it I can get Driver::DBI to handle a function call in an SQL select, like this;


    SELECT user.username,
    left(user.use…

  • Posted Baby Moose Clean Up to byterock

    It is test catch up day here in the Moose-pen.

    I figured it is a good thing to review the state of the test suites for both Database::Accessor and Driver::DBI and starting with Accessor.pm I get this;


    t/20_dad_load.t (Wstat: 1024 Tests:…

  • Posted Baby Moose in the Field to byterock

    Back to the Field day here in the Moose-Pen

    Today I am going to give params and containers a miss and move back into the '30_fields.t' test that I left alone so long ago. One of the planned concepts in Database::Accessor it the ability to have static data as part of the elements array. …

  • Posted Happy Sunny Moose Day to byterock

    Quick postette day here in the Moose-Pen.

    So yesterday I had left over SQL error that I wanted to have a look at. The error was


    FROM locations WHERE *>.city =

  • Commented on DBD::Oracle Trial release.
    Hmm sounds like I have to get my system set up in work with it again. Now where was that windows version of make?...
  • Posted Baby Moose Proof to byterock

    Just prove it worked day here in the Moose-pen

    So yesterday I left off with my SQL looking correct but my query failing on the DBD::DBM so to-day I though I better just do a quick postette just to prove to my many readers that my code actually works.

    So I all did was write up this…

  • Posted Baby Moose Takes Charge to byterock

    Its get very ambitious day here in the Moose-pen.

    As things went just a little to smoothly over the past few post I though it would be a good day to try something that I know is going to cause me grief. In the vain I added this test;


    use Database…

  • Posted Another Baby Moose Break to byterock

    Its still param day here in the Moose-Pen

    Carrying on from yesterday's post I, today I added in one more test;


    ok($user->update( $utils->connect(),$container),"updat…

  • Posted Baby Moose Break to byterock

    It playing with update and container day here in the Moose-pen.

    Now that I have the 'create' function working so well with execute_array I figured the next logical step would be to do 'update' function but I have one small problem. When I attempt to do this;

    ="prett…

  • Posted Baby Moose struts his stuff to byterock

    Well is still container day here in the Moose-pen.

    So now that I have the 'execute_array' all fixed up and working I think I will carry on the same past and get the container to work with an array of 'classes'. In that end I created this little class;

  • Posted Yes Baby Moose had a Bug. to byterock

    Well it is look at another module day here in the Moose-Pen.

    So yesterday I ran into this problem;


    DBD::DBM::st execute_array failed: 4 bind values supplied but 2 expected [for Statement …

  • Posted Baby Moose Has a Bug? to byterock

    Well it get lucky postette day here in the Moose-Pen.

    Well I left off yesterday a little worried that I was only testing half of the execute_array as I never actually got down into the DBI code of thing…

  • Posted An Array of Baby Moose to byterock

    Its a little harder day here in the Moose-Pen.

    Carrying on with adding to the '32_params.t' case I though today I would tackle one of the harder parts of prams and that is passing an array of params or in my case containers into a query statement.

    So in my test I could have th…

  • Posted Baby Moose Makes a Stand to byterock

    Its fix typo and a little programming day here in the Moose-Pen.

    Before I get back on track and start working on test case '32_params.t' but before that I had to clean-up in my code. Seems I had 'parenthes' all over the place when it should really be 'parentheses' so the last thin I did l…

  • Posted Baby Moose Skips Along to byterock

    Its think of something, look it up and skip it day here in the Moost-pen.

    Yesterday I added in the first option for Accessor.pm 'only_elements' and that got me thinking, never good ever comes out of that, …

  • Posted Baby Moose Does More to byterock

    Its wrap up a test day here in the Moose-pen;

    I am going to finish off '15_alias.t' today by adding in a few more test looking at the field 'alias' and here are the tests;


    $in_hash->{elements}->[0]->{alias} = 'last';
    $in_hash->{elements}->…

  • Posted Baby Moose Yummy to byterock

    It is still alias day here in the Moose-pen

    So it is day two of looking at aliases and SQL and as part of this I had some time last night to have a peek about the SQL standard. So far I am doing things correctly, for table and field. Though in my first incarnation of table alias I used th…

  • Posted More Moose Steps to byterock

    Its get more done day here in the Moose-pen.

    Today I was working on new test, '15_alias.t' which I will use to test the various alias attributes found on 'tables' and 'fields' in SQL queries. T…

  • Posted More Baby Moose to byterock

    Well just another post-ette day here in the Moose-pen

    Just another quick post-ette today as I want to quickly add in a feature to the results class that will help end uses with de-bugging.

    Presently the results class look like thin when it is dumped

    ="pretty…

Subscribe to feed Recent Actions from byterock

  • Peter Rabbitson commented on DBD::Oracle Trial release.

    @kd Great stuff! And great seeing @mjevans around here as well!

    Minor nit: your choice of lower-than-latest-dev release version is somewhat suboptimal. A surprisingly large amount of pre-smokers operate over the moral equivalent of:

    `cpanm --look --dev DBD::Oracle`

    As you can see your version is not being picked up as it is lower than @mjevans' older 1.75_2.

    Cheers!

  • Dean commented on DBD::Oracle Trial release.

    Smoking by cpantesters is almost entirely pointless for two reasons:

    - the Oracle Client SDK has to be downloaded and installed (requires an oracle.com account, but is "free" as in beer). there are some random websites that have it for download, avoiding the aforementioned account, but...
    - an actual Oracle database needs to be installed to test against

    There is an official Docker image of the Oracle database... but it requires injecting an oracle database installer file (even the free one from oracle.com... which again requires an account).

    So the smokers will …

  • kd commented on DBD::Oracle Trial release.

    mjevans: yes you're right the changelog is isnconsistent with what's in the release. I'll trawl through the commits and update it some time really soon.

    ribasushi: thanks. Almost all not my work. Although I can take responsibility for exposing the bug that prompted all this. I'll fix the version numbering when I update the trial release and mangle the changelog. As Dean notes it's of little practical consequence, but best to do things properly.

  • Peter Rabbitson commented on DBD::Oracle Trial release.

    > as Dean notes it's of little practical consequence, but best to do things properly.

    I don't want to publicize it too much, but https://travis-ci.org/Perl5/DBIx-Class/jobs/390708515#L441-L462 ( DBIC is not the only user afaik )

  • Dean commented on DBD::Oracle Trial release.

    I took that as inspiration for https://travis-ci.org/ByteFoundryAU/DBD-Oracle

    Thanks Peter

Subscribe to feed Responses to Comments from byterock

About blogs.perl.org

blogs.perl.org is a common blogging platform for the Perl community. Written in Perl and offering the modern features you’ve come to expect in blog platforms, the site is hosted by Dave Cross and Aaron Crane, with a design donated by Six Apart, Ltd.