Пакет perl-SQL-Abstract-Classic: Информация

    Исходный пакет: perl-SQL-Abstract-Classic
    Версия: 1.91-alt2
    Собран:  26 августа 2023 г. 16:23
    Категория: Разработка/Perl
    Сообщить об ошибке в пакете
    Домашняя страница: http://search.cpan.org/dist/SQL-Abstract-Classic/

    Лицензия: perl
    О пакете: Generate SQL from Perl data structures
    Описание: 
    This module was inspired by the excellent the DBIx::Abstract manpage.
    However, in using that module I found that what I really wanted
    to do was generate SQL, but still retain complete control over my
    statement handles and use the DBI interface. So, I set out to
    create an abstract SQL generation module.
    
    While based on the concepts used by the DBIx::Abstract manpage, there are
    several important differences, especially when it comes to WHERE
    clauses. I have modified the concepts used to make the SQL easier
    to generate from Perl data structures and, IMO, more intuitive.
    The underlying idea is for this module to do what you mean, based
    on the data structures you provide it. The big advantage is that
    you don't have to modify your code every time your data changes,
    as this module figures it out.
    
    To begin with, an SQL INSERT is as easy as just specifying a hash
    of `key=value' pairs:
    
        my %data = (
            name => 'Jimbo Bobson',
            phone => '123-456-7890',
            address => '42 Sister Lane',
            city => 'St. Louis',
            state => 'Louisiana',
        );
    
    The SQL can then be generated with this:
    
        my($stmt, @bind) = $sql->insert('people', \%data);
    
    Which would give you something like this:
    
        $stmt = "INSERT INTO people
                        (address, city, name, phone, state)
                        VALUES (?, ?, ?, ?, ?)";
        @bind = ('42 Sister Lane', 'St. Louis', 'Jimbo Bobson',
                 '123-456-7890', 'Louisiana');
    
    These are then used directly in your DBI code:
    
        my $sth = $dbh->prepare($stmt);
        $sth->execute(@bind);

    Список rpm-пакетов, предоставляемых данным srpm-пакетом:
    perl-SQL-Abstract-Classic (noarch)

    Сопровождающий: Igor Vlasenko

    Список участников:
    Igor Vlasenko

      1. perl(JSON.pm)
      2. perl(LWP/Simple.pm)
      3. perl(List/Util.pm)
      4. perl(MRO/Compat.pm)
      5. perl(Module/Build.pm)
      6. perl(Net/FTP.pm)
      7. perl(Parse/CPAN/Meta.pm)
      8. perl(SQL/Abstract.pm)
      9. perl(Scalar/Util.pm)
      10. perl(Storable.pm)
      11. perl(Test/Deep.pm)
      12. perl(Test/Exception.pm)
      13. perl(Test/More.pm)
      14. /proc
      15. perl(Test/Warn.pm)
      16. perl(Text/Balanced.pm)
      17. perl(YAML/Tiny.pm)
      18. perl-devel
      19. perl-podlators
      20. rpm-build-perl
      21. perl(CPAN.pm)
      22. perl(Exporter.pm)
      23. perl(ExtUtils/CBuilder.pm)
      24. perl(ExtUtils/MakeMaker.pm)

    Последнее изменение


    25 июня 2020 г. Igor Vlasenko 1.91-alt2
    - to Sisyphus as perl-DBIx-Class dep
    20 октября 2019 г. Igor Vlasenko 1.91-alt1
    - initial import by package builder