How to Install and Uninstall perl-SQL-Abstract Package on openSuSE Tumbleweed

Last updated: December 24,2024

1. Install "perl-SQL-Abstract" package

This tutorial shows how to install perl-SQL-Abstract on openSuSE Tumbleweed

$ sudo zypper refresh $ sudo zypper install perl-SQL-Abstract

2. Uninstall "perl-SQL-Abstract" package

Please follow the step by step instructions below to uninstall perl-SQL-Abstract on openSuSE Tumbleweed:

$ sudo zypper remove perl-SQL-Abstract

3. Information about the perl-SQL-Abstract package on openSuSE Tumbleweed

Information for package perl-SQL-Abstract:
------------------------------------------
Repository : openSUSE-Tumbleweed-Oss
Name : perl-SQL-Abstract
Version : 2.000001-1.15
Arch : noarch
Vendor : openSUSE
Installed Size : 350.2 KiB
Installed : No
Status : not installed
Source package : perl-SQL-Abstract-2.000001-1.15.src
Upstream URL : https://metacpan.org/release/SQL-Abstract
Summary : Generate SQL from Perl data structures
Description :
This module was inspired by the excellent DBIx::Abstract. 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 DBIx::Abstract, 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);