PerlTechStack
PerlTechStack
  • Видео 70
  • Просмотров 11 094
Object-Relational Mapping: Custom Views | #24 Perl DBIx Tutorial
In this Perl programming tutorial, we will learn how to create custom views that can help us to write complicated SQL queries. We will also look at how to add relationships to our custom views to access related data.
Chapters:
00:00 Intro
01:05 Custom view
04:35 Relationships
07:40 Running custom view
10:28 Outro
Docs:
metacpan.org/pod/DBIx::Class
metacpan.org/pod/DBIx::Class::Schema
metacpan.org/pod/DBIx::Class::ResultSet
metacpan.org/pod/DBIx::Class::Row
Tags:
#Perl #PerlProgramming #CodingInPerl #PerlDevelopment
Просмотров: 48

Видео

Object-Relational Mapping: Transactions | #23 Perl DBIx Tutorial
Просмотров 232 месяца назад
In this Perl programming tutorial, we will learn how to use transactions in DBIx. Chapters: 00:00 Intro 00:45 Transactions 04:22 Outro Docs: metacpan.org/pod/DBIx::Class metacpan.org/pod/DBIx::Class::Schema metacpan.org/pod/DBIx::Class::ResultSet metacpan.org/pod/DBIx::Class::Row Tags: #Perl #PerlProgramming #CodingInPerl #PerlDevelopment
Object-Relational Mapping: Fetching Raw Data | #22 Perl DBIx Tutorial
Просмотров 342 месяца назад
In this Perl programming tutorial, we will learn how to fetch "raw data" using DBIx::Class::ResultClass::HashRefInflator. We'll explore what are are the benefits and downsides of using this DBIx utility module. Chapters: 00:00 Intro 01:00 Installing HashRefInflator 01:30 Using HashRefInflator 03:05 HashRefInflator as RS utility method 04:20 Related data with HashRefInflator 05:08 Outro Docs: me...
Object-Relational Mapping: Pagination | #21 Perl DBIx Tutorial
Просмотров 372 месяца назад
In this Perl programming tutorial, we will learn how to paginate results returned by DBIx and how to access instance of pager to get total rows, current page, amount of rows etc. Chapters: 00:00 Intro 00:50 Pagination 04:43 Outro Docs: metacpan.org/pod/DBIx::Class metacpan.org/pod/DBIx::Class::Schema metacpan.org/pod/DBIx::Class::ResultSet metacpan.org/pod/DBIx::Class::Row Tags: #Perl #PerlProg...
Object-Relational Mapping: Custom ResultSet Methods | #20 Perl DBIx Tutorial
Просмотров 322 месяца назад
In this Perl programming tutorial, we will learn how to implement custom ResultSet methods. We will also look at how to create a base ResultSet with commonly used methods that all other ResultSet classes can inherit from. Chapters: 00:00 Intro 01:10 Custom ResultSet classes 03:53 Using custom ResultSet method 04:45 Another custom ResultSet method 07:15 Custom global ResultSet 13:02 Outro Docs: ...
Object-Relational Mapping: Custom Result Methods | #19 Perl DBIx Tutorial
Просмотров 282 месяца назад
In this Perl programming tutorial, we will learn how to add custom methods in our Result classes. Chapters: 00:00 Intro 00:40 Custom methods 03:03 Outro Docs: metacpan.org/pod/DBIx::Class metacpan.org/pod/DBIx::Class::Schema metacpan.org/pod/DBIx::Class::ResultSet metacpan.org/pod/DBIx::Class::Row Tags: #Perl #PerlProgramming #CodingInPerl #PerlDevelopment
Object-Relational Mapping: Custom Result Relationships | #18 Perl DBIx Tutorial
Просмотров 262 месяца назад
In this Perl programming tutorial, we will learn how create custom DBIx Result relationships with different constraints. We will explore how to use simple form to define basic relationships and also look at more advanced example in case you need more complicated join types. Chapters: 00:00 Intro 00:45 Using search_related_rs 03:38 Simple custom relationships 08:50 Simple custom relationships us...
Object-Relational Mapping: Subqueries | #17 Perl DBIx Tutorial
Просмотров 382 месяца назад
In this Perl programming tutorial, we will learn how to query our database with DBIx using subqueries. Chapters: 00:00 Intro 01:05 Raw SQL subquery 03:20 Subquery with as_query 05:05 Using get_column 06:00 Aliasing subqueries 08:25 Outro Docs: metacpan.org/pod/DBIx::Class metacpan.org/pod/DBIx::Class::Schema metacpan.org/pod/DBIx::Class::ResultSet metacpan.org/pod/DBIx::Class::Row Tags: #Perl #...
Object-Relational Mapping: Search, Update and Delete Related Data | #16 Perl DBIx Tutorial
Просмотров 333 месяца назад
In this Perl programming tutorial, we will look at how we can search, update and delete relational data through DBIx. Chapters: 00:00 Intro 01:02 search_related 02:52 search_related_rs 04:18 Updating related data 05:35 Deleting related data 06:14 Outro Docs: metacpan.org/pod/DBIx::Class metacpan.org/pod/DBIx::Class::Schema metacpan.org/pod/DBIx::Class::ResultSet metacpan.org/pod/DBIx::Class::Ro...
Object-Relational Mapping: Creating Relational Data | #15 Perl DBIx Tutorial
Просмотров 293 месяца назад
In this Perl programming tutorial, we will look at how we can insert relational data for has_one, has_many and belongs_to relationships. We will also explore how we can insert relational data in bulk using the populate method. Chapters: 00:00 Intro 00:25 has_many/has_one 03:35 belongs_to 05:52 populate 08:40 Outro Docs: metacpan.org/pod/DBIx::Class metacpan.org/pod/DBIx::Class::Schema metacpan....
Object-Relational Mapping: Prefetching Data | #14 Perl DBIx Tutorial
Просмотров 453 месяца назад
In this Perl programming tutorial, we will look at how we can prefetch relational data using DBIx. We we also explore what is the difference between using JOIN clause versus PREFETCH, and when you should potentially use one over the other. Chapters: 00:00 Intro 00:54 Refresher on JOIN 02:35 Using PREFETCH 03:31 Discuss: JOIN vs PREFETCH 04:32 Outro Docs: metacpan.org/pod/DBIx::Class metacpan.or...
Object-Relational Mapping: Joins and Relationships | #13 Perl DBIx Tutorial
Просмотров 524 месяца назад
In this Perl programming tutorial, we will look at different types of DBIx relationships and how these are defined in our Result classes. We will also look at how we can do single and nested joins on our ResultSet instances. Chapters: 00:00 Intro 00:46 belongs_to 01:50 has_many 02:37 might_have 04:05 has_one 04:45 Joining tables 08:55 Comments on joins 10:30 Nested joins 13:15 Outro SQL: CREATE...
Object-Relational Mapping: Deleting Data | #12 Perl DBIx Tutorial
Просмотров 274 месяца назад
In this Perl programming tutorial, we will look at how we can delete data from our database via DBIx using two methods and what are the key differences between these two delete methods. Chapters: 00:00 Intro 00:12 Method: delete 01:52 Method: delete_all 09:32 Outro Docs: metacpan.org/pod/DBIx::Class metacpan.org/pod/DBIx::Class::Schema metacpan.org/pod/DBIx::Class::ResultSet metacpan.org/pod/DB...
Object-Relational Mapping: Updating Data | #11 Perl DBIx Tutorial
Просмотров 224 месяца назад
In this Perl programming tutorial, we will look at how we can update data in our database via DBIx using various methods. We will also explore what are the differences between these update methods. Chapters: 00:00 Intro 00:20 Method: update 02:40 Method: update_all 04:11 Method: update_or_create 06:17 Method: update_or_new 09:32 Outro Docs: metacpan.org/pod/DBIx::Class metacpan.org/pod/DBIx::Cl...
Object-Relational Mapping: Bulk Create Data | #10 Perl DBIx Tutorial
Просмотров 444 месяца назад
In this Perl programming tutorial, we will look at how we can insert bulk data using DBIx using the populate method. We will also explore what are the subtle differences when calling populate method in different return context. Chapters: 00:00 Intro 01:15 Populate method gotcha 03:58 Outro Docs: metacpan.org/pod/DBIx::Class metacpan.org/pod/DBIx::Class::Schema metacpan.org/pod/DBIx::Class::Resu...
Object-Relational Mapping: Creating Data | #9 Perl DBIx Tutorial
Просмотров 444 месяца назад
Object-Relational Mapping: Creating Data | #9 Perl DBIx Tutorial
Object-Relational Mapping: Filtering Data | #8 Perl DBIx Tutorial
Просмотров 494 месяца назад
Object-Relational Mapping: Filtering Data | #8 Perl DBIx Tutorial
Object-Relational Mapping: Complex WHERE Clauses | #7 Perl DBIx Tutorial
Просмотров 474 месяца назад
Object-Relational Mapping: Complex WHERE Clauses | #7 Perl DBIx Tutorial
Object-Relational Mapping: Reading Data | #6 Perl DBIx Tutorial
Просмотров 654 месяца назад
Object-Relational Mapping: Reading Data | #6 Perl DBIx Tutorial
Object-Relational Mapping: Debugging DBIx Queries | #5 Perl DBIx Tutorial
Просмотров 584 месяца назад
Object-Relational Mapping: Debugging DBIx Queries | #5 Perl DBIx Tutorial
Object-Relational Mapping: Schema, ResultSet and Result Overview | #4 Perl DBIx Tutorial
Просмотров 814 месяца назад
Object-Relational Mapping: Schema, ResultSet and Result Overview | #4 Perl DBIx Tutorial
Object-Relational Mapping: Connecting via DBIx::Class::Schema | #3 Perl DBIx Tutorial
Просмотров 874 месяца назад
Object-Relational Mapping: Connecting via DBIx::Class::Schema | #3 Perl DBIx Tutorial
Object-Relational Mapping: DBIx::Class::Schema::Loader | #2 Perl DBIx Tutorial
Просмотров 1584 месяца назад
Object-Relational Mapping: DBIx::Class::Schema::Loader | #2 Perl DBIx Tutorial
Object-Relational Mapping: Overview | #1 Perl DBIx Tutorial
Просмотров 1584 месяца назад
Object-Relational Mapping: Overview | #1 Perl DBIx Tutorial
Test::Most - Unit Testing Perl Code #8: Objects
Просмотров 687 месяцев назад
Test::Most - Unit Testing Perl Code #8: Objects
Test::Most - Unit Testing Perl Code #7: Diagnostics - note, diag and explain
Просмотров 477 месяцев назад
Test::Most - Unit Testing Perl Code #7: Diagnostics - note, diag and explain
Test::Most - Unit Testing Perl Code #6: SKIP and TODO
Просмотров 467 месяцев назад
Test::Most - Unit Testing Perl Code #6: SKIP and TODO
Test::Most - Unit Testing Perl Code #5: Subtests
Просмотров 618 месяцев назад
Test::Most - Unit Testing Perl Code #5: Subtests
Test::Most - Unit Testing Perl Code #4: Exceptions
Просмотров 608 месяцев назад
Test::Most - Unit Testing Perl Code #4: Exceptions
Test::Most - Unit Testing Perl Code #3: References
Просмотров 768 месяцев назад
Test::Most - Unit Testing Perl Code #3: References

Комментарии

  • @happystoat99
    @happystoat99 6 дней назад

    Great video :) That will make my life easier when working with files.

  • @happystoat99
    @happystoat99 6 дней назад

    Awesome channel and video, keep it up :)

  • @DS-ou7xm
    @DS-ou7xm 21 день назад

    👍

  • @krzysztofwalkiewicz8431
    @krzysztofwalkiewicz8431 Месяц назад

    Thank you for a great Perl content. Subscribed.

  • @muyvin98
    @muyvin98 2 месяца назад

    keep-it up sir,

  • @alizaghloul9808
    @alizaghloul9808 2 месяца назад

    Will you make videos for Catalyst?

    • @perltechstack
      @perltechstack 2 месяца назад

      Hi @alizaghloul9808. At the current time I do not have any plans to make videos on Catalyst framework. However, I do plan to start working on Mojolicious series once I have finished up DBIx tutorials.

  • @raj-we9yr
    @raj-we9yr 2 месяца назад

    Thank you for sharing your Perl knowledge. Request you to share on reading and writing fixed length records to binary files. Also it will be useful how the function pack() or unpack() may be used in such case.

    • @perltechstack
      @perltechstack 2 месяца назад

      Hey @raj-we9yr, thanks for the feedback! That's a great request - I will make a note of it, and explore adding a video on the subject as per your suggestion. All the best for now!

  • @chmod0644
    @chmod0644 4 месяца назад

    Great tutorial, thanks.

  • @MichaelB-zr4ld
    @MichaelB-zr4ld 6 месяцев назад

    promo sm

  • @yaroshchenko_coder
    @yaroshchenko_coder 8 месяцев назад

    Thanks for the recent lessons on the Perl programming language

    • @perltechstack
      @perltechstack 8 месяцев назад

      Thanks for the feedback @user-vy5on4ju5b, appreciated!

  • @Dreamprime
    @Dreamprime 9 месяцев назад

    Sir, I have wathched your tutorial from the FreeCodeCamp variation, The content, rythm and structure of your presentation is very effective, Thank you for your contribution. (Although there is a claim that Perl is outdated, the language itself is extremely strong when used in its own domain, I plan to invest more time and effort in it, for network management, cybersecurity and general scripting)

    • @perltechstack
      @perltechstack 9 месяцев назад

      Hi @Dreamprime, Thank you very much for your kind comment. I'm glad that you found these tutorials useful!

  • @user-tb1ot7ml1h
    @user-tb1ot7ml1h 9 месяцев назад

    Good and clear. Thanks for the great topics

    • @perltechstack
      @perltechstack 9 месяцев назад

      Hey @user-tb1ot7ml1h, I appreciate your feedback!

  • @vineethkagitha8027
    @vineethkagitha8027 10 месяцев назад

    Golden standard content on perl

  • @yaroshchenko_coder
    @yaroshchenko_coder 10 месяцев назад

    I am very glad that you are back

  • @yaroshchenko_creative
    @yaroshchenko_creative 10 месяцев назад

    I am glad that you have resumed your Perl lessons 😀

  • @edr1cjp
    @edr1cjp 11 месяцев назад

    why the hash value can be accessed with sq brackets and not curly brackets ? also why dereferencing is not required?

    • @perltechstack
      @perltechstack 10 месяцев назад

      Hey @edr1cjp! If your are referring to line where we access passed arguments to the "test" function via "print $map{ $_[0] };", then note that "$_[0]" is *not* a reference. Arguments passed to the "test" function are given in a list context. We know that we can access items in an array by index by prefixing the variable name with "$". For example, if we have an array defined "my @list = ('a', 'b', 'c');" we could print the second element by index if we do "print $list[1];". Knowing that, we also must know that Perl gives a convenience variable where all the given function arguments are stored "@_". When we called the "test" function giving one argument as "test('a');" we ended up having the "@_" containing "@_ = ('a')". We then accessed the first element in the "@_" list by doing "$_[0]"; note the change of sigil here from "@" to "$". And that's about it. I hope this makes more sense!

  • @edr1cjp
    @edr1cjp 11 месяцев назад

    still couldnt understand the difference at 8:08 L9 using brackets and 8:18 using curly brackets 🥲

  • @debrajbanerjee9752
    @debrajbanerjee9752 Год назад

    Awesome tutorials, thank you very much, would you mind making a video explaining how to use Mojolicious?

    • @perltechstack
      @perltechstack Год назад

      Hi @debrajbanerjee9752, thank you for the kind comment. Creating Mojolicious and DBIx tutorials are definitely something I would like to pursue in the near future.

  • @Tech.Library
    @Tech.Library Год назад

    Great video,your view on running Perl on windows?

    • @perltechstack
      @perltechstack 10 месяцев назад

      Strawberry Perl (strawberryperl.com) is great for running Perl in Windows environment; however, running Perl in Windows wouldn't be my go-to option. Dealing with dependencies and setting up the environment can be challenging. I would recommend to explore Ubuntu under WSL (learn.microsoft.com/en-us/windows/wsl/about). I'm currently running Ubuntu in Windows WSL for latest Mouse OOP videos. It sets up isolated environment where I can do all the development w/o needing to have two separate OS installations on my machine. Very happy with the workflow.

    • @Tech.Library
      @Tech.Library 10 месяцев назад

      ​@@perltechstacki tried installing SDL module on windows 11 running strawberry but giving exceptions that gmake fail etc

    • @perltechstack
      @perltechstack 10 месяцев назад

      This is what I meant when I said that dealing with dependencies can be challenging. Have you tried WSL as an alternative? You can access Linux environment via terminal directly from Windows with all your folder mappings etc. Give it a go. 👍

    • @Tech.Library
      @Tech.Library 10 месяцев назад

      @@perltechstack ok thank you. I shall install. It now.

  • @DS-ou7xm
    @DS-ou7xm Год назад

    Thank you for the tutorial, I started working with Perl recently. For Linux system administrators it is truly a important tool in the arsenal of systems automation 👍👍👍

    • @perltechstack
      @perltechstack 10 месяцев назад

      My pleasure, I hope you are finding the videos useful! Good luck with your Perl journey. :)

  • @yaroshchenko_coder
    @yaroshchenko_coder Год назад

    say - это как puts в ruby?

  • @yaroshchenko_coder
    @yaroshchenko_coder Год назад

    Есть ли у вас информация, когда выпустят Perl7????

  • @yaroshchenko_coder
    @yaroshchenko_coder Год назад

    Меня интересует функция sey, она появилась в версии perl5.16? Зачем она, когда есть Print??!

  • @yaroshchenko_coder
    @yaroshchenko_coder Год назад

    I will be very glad to see lessons on creating a window interface in linux and windows.

  • @yaroshchenko_coder
    @yaroshchenko_coder Год назад

    Waiting for new videos, subscribed to you)

  • @stefans9990
    @stefans9990 Год назад

    Thanks for your efforts in making some videos on Perl. It's sortof sad that so few people have been viewing them.

  • @OpinionOfX
    @OpinionOfX Год назад

    Thank you

  • @rodfowler3968
    @rodfowler3968 Год назад

    🤭 Promo*SM