Daniel Böhmer<p><span class="h-card" translate="no"><a href="https://mastodon.social/@peateasea" class="u-url mention" rel="nofollow noopener" target="_blank">@<span>peateasea</span></a></span> Reading the article it looks like you need to create a PP object and then throw a resultset object at it.</p><p>Have you considered extending it that one could load it as a plugin to their resultset (base) class and call a method on any resultset object?</p><p><a href="https://ieji.de/tags/dbixclass" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>dbixclass</span></a></p>
mastodon.world is one of the many independent Mastodon servers you can use to participate in the fediverse.
Generic Mastodon server for anyone to use.
Administered by:
Server stats:
8.1Kactive users
mastodon.world: About · Status · Profiles directory · Privacy policy
Mastodon: About · Get the app · Keyboard shortcuts · View source code · v4.4.3
#dbixclass
0 posts · 0 participants · 0 posts today
Coocook.org<p><span class="h-card" translate="no"><a href="https://linuxrocks.online/@demiguise" class="u-url mention" rel="nofollow noopener" target="_blank">@<span>demiguise</span></a></span> One more thing: If you want to get more experience with <a href="https://floss.social/tags/DBIxClass" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>DBIxClass</span></a> and how Coocook is using it you could also contribute a small task that involves DBIC.</p><p>We always have some issues open labelled with "good first issues" for beginners.<br><a href="https://gitlab.com/coocook/coocook/-/issues?label_name[]=good%20first%20issue" rel="nofollow noopener" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">gitlab.com/coocook/coocook/-/i</span><span class="invisible">ssues?label_name[]=good%20first%20issue</span></a></p><p>In particular there’s issue #320 that’s about simply removing some old fallback which allows removing a UNIQUE constraint from the DB.<br><a href="https://gitlab.com/coocook/coocook/-/issues/320" rel="nofollow noopener" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">gitlab.com/coocook/coocook/-/i</span><span class="invisible">ssues/320</span></a></p><p>If you want to give it a try I’d be glad to help you tackle this 😁</p>
Coocook.org<p><span class="h-card" translate="no"><a href="https://linuxrocks.online/@demiguise" class="u-url mention" rel="nofollow noopener" target="_blank">@<span>demiguise</span></a></span> If you’re asking to “hear” something about <a href="https://floss.social/tags/DBIxClass" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>DBIxClass</span></a> from me personally:</p><p>There’s my 14min talk about database migrations with DBIC (English slides, German talk, no English subtitles yet) from 20th German <a href="https://floss.social/tags/Perl" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>Perl</span></a> Workshop <a href="https://floss.social/tags/gpw2018" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>gpw2018</span></a> online. That’s pretty much the toolset Coocook still uses today. Can’t believe this talk was already 7 years ago 🙈 <br><a href="https://www.youtube.com/watch?v=iWmVlDXsKFU" rel="nofollow noopener" translate="no" target="_blank"><span class="invisible">https://www.</span><span class="ellipsis">youtube.com/watch?v=iWmVlDXsKF</span><span class="invisible">U</span></a></p><p>📢 <span class="h-card" translate="no"><a href="https://ieji.de/@dboehmer" class="u-url mention" rel="nofollow noopener" target="_blank">@<span>dboehmer</span></a></span> (that’s me 😁) is also available for hire to do DBIC talks, trainings, consulting </advertisement> 😎</p>
Coocook.org<p><span class="h-card" translate="no"><a href="https://linuxrocks.online/@demiguise" class="u-url mention" rel="nofollow noopener" target="_blank">@<span>demiguise</span></a></span> I still found ORMs in other languages inferior compared to <a href="https://floss.social/tags/DBIxClass" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>DBIxClass</span></a>. Anyway we’ve learned something since the incarnation of DBIC nearly 20 years ago. That’s why Chad Granum started DBIx-QuickORM last year. The repo hasn’t seem activity for some months now but I still hope this project will fly.<br><a href="https://metacpan.org/dist/DBIx-QuickORM" rel="nofollow noopener" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">metacpan.org/dist/DBIx-QuickOR</span><span class="invisible">M</span></a></p>
Coocook.org<p><span class="h-card" translate="no"><a href="https://linuxrocks.online/@demiguise" class="u-url mention" rel="nofollow noopener" target="_blank">@<span>demiguise</span></a></span> Unfortunately though the development of <a href="https://floss.social/tags/DBIxClass" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>DBIxClass</span></a> has stalled and there even seems to be unclarity about the project’s ownership and governance. Don’t expect new releases or even further development. This is really a sad state for a framework that I consider one of <a href="https://floss.social/tags/Perl" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>Perl</span></a>’s potential USPs 😔 DBIC is so mature that you can still use it reliably though.</p>
Coocook.org<p><span class="h-card" translate="no"><a href="https://linuxrocks.online/@demiguise" class="u-url mention" rel="nofollow noopener" target="_blank">@<span>demiguise</span></a></span> Well, <a href="https://floss.social/tags/DBIxClass" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>DBIxClass</span></a> has proven to be very stable and powerful. Most often I found a way to implement unusual queries in DBIC and there’s always a workaround possible by using custom <a href="https://floss.social/tags/SQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>SQL</span></a> if you give up.</p><p>For me the main benefit of using a powerful ORM like DBIC is that you can reuse DB code in OOP fashion. Our Coocook::Schema::Result[Set]:: namespace has many methods providing tiny bits that can be plugged together like building blocks. Plain SQL quickly becomes very repetitive …</p>
Demiguise 🇮🇱<p><span class="h-card" translate="no"><a href="https://floss.social/@coocook" class="u-url mention" rel="nofollow noopener" target="_blank">@<span>coocook</span></a></span> <a href="https://linuxrocks.online/tags/dbixclass" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>dbixclass</span></a> is just insanely cool, I started using it within a small, hobby-fiddling Dancer2 web app.</p><p>Is there a chance to hear about your experiences using it? 👀</p>
Coocook.org<p>At lot has changed in the last 10 years but Coocook always has been a web application based on <a href="https://floss.social/tags/Perl" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>Perl</span></a> with <a href="https://floss.social/tags/CatalystFramework" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>CatalystFramework</span></a> and <a href="https://floss.social/tags/DBIxClass" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>DBIxClass</span></a>. These frameworks didn’t move fast but proved to be rock solid! 💪 </p><p>In the meantime we integrated other components like <a href="https://floss.social/tags/Bootstrap" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>Bootstrap</span></a> and infrastructure like <a href="https://floss.social/tags/GitLab" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>GitLab</span></a> with CI and <a href="https://floss.social/tags/Docker" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>Docker</span></a> for easier development (soon: also deployment). Fast moving <a href="https://floss.social/tags/Javascript" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>Javascript</span></a> libraries have caused many more problems than the mature Perl ecosystem.</p>
Paul Cochrane 🇪🇺<p>I seldom release modules to <a href="https://mastodon.social/tags/CPAN" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>CPAN</span></a> mainly because there’s so much great stuff there already. An answer on StackOverflow about pretty printing DBIx::Class result sets got me thinking. I then climbed onto the shoulders of several giants to create a wee module which does just that. Introducing DBIx::Class::ResultSet::PrettyPrint!</p><p><a href="https://peateasea.de/introducing-dbix-class-resultset-prettyprint/" rel="nofollow noopener" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">peateasea.de/introducing-dbix-</span><span class="invisible">class-resultset-prettyprint/</span></a></p><p><a href="https://mastodon.social/tags/dbixclass" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>dbixclass</span></a> <a href="https://mastodon.social/tags/perl" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>perl</span></a></p>
Paul Cochrane 🇪🇺<p>Imagine this situation: I have a Mojolicious app where the unit test suite uses DBIx::Class and DBIx::Class::Fixtures. I want to run Selenium tests with Test::Mojo::Role::Selenium, but that always points at the dev DB and not at the test DB that DBIC created.</p><p>Is it possible to tell the running Mojo app to stop using the dev DB (which I don't want to pollute with test data) and instead run with the Fixtures-built test DB (and hence use transactions I can roll back)?</p><p><a href="https://mastodon.social/tags/perl" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>perl</span></a> <a href="https://mastodon.social/tags/dbixclass" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>dbixclass</span></a></p>
Daniel Böhmer<p>Is the <a href="https://ieji.de/tags/DBIxClass" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>DBIxClass</span></a> mailing list dead? I sent an email but my mail server can’t deliver the email because connections to lists.scsys.co.uk timeout …</p><p><a href="https://lists.perl.org/list/dbix-class.html" rel="nofollow noopener" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">lists.perl.org/list/dbix-class</span><span class="invisible">.html</span></a></p><p>Unfortunately the Issues tab on GitHub for DBIC is disabled 😔<br><a href="https://github.com/Perl5/DBIx-Class" rel="nofollow noopener" translate="no" target="_blank"><span class="invisible">https://</span><span class="">github.com/Perl5/DBIx-Class</span><span class="invisible"></span></a></p><p><a href="https://ieji.de/tags/perl" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>perl</span></a></p>
Daniel Böhmer<p><span class="h-card" translate="no"><a href="https://mastodon.social/@frew" class="u-url mention" rel="nofollow noopener" target="_blank">@<span>frew</span></a></span> I am using your module DBIx::Class::Helper::ResultSet::IgnoreWantarray and just found it doesn’t make many_to_many() accessors ignore wantarray(). If you add such a relationship and call the accessor in list context you get Result objects.</p><p>Do you think the module should take of that?</p><p>The wantarray is here: <a href="https://metacpan.org/release/RIBASUSHI/DBIx-Class-0.082843/source/lib/DBIx/Class/Relationship/ManyToMany.pm#L77" rel="nofollow noopener" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">metacpan.org/release/RIBASUSHI</span><span class="invisible">/DBIx-Class-0.082843/source/lib/DBIx/Class/Relationship/ManyToMany.pm#L77</span></a></p><p>I think the *$meth_name should be replaced by the *$rs_meth_name built by that code. 🤔 </p><p><a href="https://ieji.de/tags/perl" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>perl</span></a> <a href="https://ieji.de/tags/dbixclass" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>dbixclass</span></a></p>
Daniel Böhmer<p><span class="h-card" translate="no"><a href="https://social.sdf.org/@mjgardner" class="u-url mention" rel="nofollow noopener" target="_blank">@<span>mjgardner</span></a></span> Main developer answering here:</p><p>Backend <a href="https://metacpan.org/pod/DBIx::Class::DeploymentHandler" rel="nofollow noopener" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">metacpan.org/pod/DBIx::Class::</span><span class="invisible">DeploymentHandler</span></a> with UI <a href="https://metacpan.org/pod/App::DH" rel="nofollow noopener" translate="no" target="_blank"><span class="invisible">https://</span><span class="">metacpan.org/pod/App::DH</span><span class="invisible"></span></a></p><p>Entry point in our codebase:<br><a href="https://gitlab.com/coocook/coocook/-/blob/master/lib/Coocook/Script/Deploy.pm?ref_type=heads" rel="nofollow noopener" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">gitlab.com/coocook/coocook/-/b</span><span class="invisible">lob/master/lib/Coocook/Script/Deploy.pm?ref_type=heads</span></a></p><p>It supports both SQL files and arbitrary script files. For example the 8→9 upgrade adds a column and converts a string for that column in <a href="https://ieji.de/tags/Perl" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>Perl</span></a>:<br><a href="https://gitlab.com/coocook/coocook/-/tree/master/share/ddl/SQLite/upgrade/8-9?ref_type=heads" rel="nofollow noopener" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">gitlab.com/coocook/coocook/-/t</span><span class="invisible">ree/master/share/ddl/SQLite/upgrade/8-9?ref_type=heads</span></a></p><p>I gave an introductory talk about this at the German Perl & Raku Workshop <a href="https://ieji.de/tags/GPW2018" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>GPW2018</span></a>. YouTube English subtitles seem to be ok:<br><a href="https://www.youtube.com/watch?v=iWmVlDXsKFU" rel="nofollow noopener" translate="no" target="_blank"><span class="invisible">https://www.</span><span class="ellipsis">youtube.com/watch?v=iWmVlDXsKF</span><span class="invisible">U</span></a> (13min)<br><a href="https://ieji.de/tags/dbixclass" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>dbixclass</span></a></p>
Coocook.org<p>Why we've changed our database schema 26 times until now:<br>- make Coocook easier to use by simplifying required input<br>- add new features like organizations (groups of users)<br>- add missing metadata like creation timestamps</p><p>Longer gaps are difficult changes that took long to prepare:<br>1. add database versioning in the first place<br>2. drop infamous table "quantities" that connected units that can be converted, like "masses" with lb and kg, etc.🙈<br><a href="https://floss.social/tags/perl" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>perl</span></a> <a href="https://floss.social/tags/sql" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>sql</span></a> <a href="https://floss.social/tags/SchemaVersioning" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>SchemaVersioning</span></a> <a href="https://floss.social/tags/graph" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>graph</span></a> <a href="https://floss.social/tags/dbixclass" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>dbixclass</span></a> <a href="https://floss.social/tags/dbi" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>dbi</span></a></p>
Daniel Böhmer<p><span class="h-card" translate="no"><a href="https://chirp.social/@Perl" class="u-url mention" rel="nofollow noopener" target="_blank">@<span>Perl</span></a></span> I have a hard time getting this database query to work with DBIx::Class. I gave my best to describe it in a useful way. I’d very much appreciate any hints or questions:</p><p><a href="https://stackoverflow.com/questions/77558505/use-function-value-from-subquery-in-where-clause-fetch-it-with-results-using-d" rel="nofollow noopener" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">stackoverflow.com/questions/77</span><span class="invisible">558505/use-function-value-from-subquery-in-where-clause-fetch-it-with-results-using-d</span></a></p><p><a href="https://ieji.de/tags/perl" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>perl</span></a> <a href="https://ieji.de/tags/dbixclass" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>dbixclass</span></a> <a href="https://ieji.de/tags/dbi" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>dbi</span></a></p>
TrendingLive feeds
Mastodon is the best way to keep up with what's happening.
Follow anyone across the fediverse and see it all in chronological order. No algorithms, ads, or clickbait in sight.
Create accountLoginDrag & drop to upload