Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: [Perl] script -database
Top Forums Shell Programming and Scripting [Perl] script -database Post 302489213 by m1xram on Wednesday 19th of January 2011 08:54:33 PM
Old 01-19-2011
SQLite
Most of database stuff is done for you already with SQLite and there's a CPAN.org module for it. See module DBD::SQLite. Other methods can be found on the link to DBD from the module. On Linux use your package manager to install it, search for "dbd-sqlite". Windows can install it with PPM but I haven't used that in some time.

I also have packages "sqlite" (command line), "sqlite-doc" (docs) and "sqliteman" (GUI) installed under Linux. This is everything you need to create the database file without PERL. You can learn the syntax and play around with the DB. DB File needs RW access and the directory must be at least X (executable).

PERL access starts with...

Code:
use DBI qw(:sql_types);
my $dbfile = "schedule.sqlite";

my $dbh = DBI->connect("dbi:SQLite:$dbfile","","");
my $sth = $dbh->prepare("SELECT * FROM users ORDER BY id");
$sth->execute or die $sth->errstr;
my $row = $sth->fetch;
while (defined($row)) {
    print join("|", @$row), "\n";
    $row = $sth->fetch;
}

$dbh->disconnect;

There are lots of ways to get rows, see all the fetch methods in the DBD module. For example, you can get one row at a time in an array or in a hash, or all the rows at once in an array or array ref, etc. Variables can be bound to columns for easier access.

The table was created from command line. Here's the SQL92 statement.

Code:
CREATE TABLE users (id integer primary key, fname varchar(40), lname varchar(40));

SQL92 is a subset of the full standard, see documentation.
Last edited by m1xram; 01-28-2011 at 10:28 AM.. Reason: missing semicolon
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

error connecting database from perl

Hi, While i am trying to connect to Oracle database from Perl using DBI module,am getting the error as follows : Can't load '/usr/local/fuseperl-modules/lib/i586-linux-thread-multi/auto/DBD/Oracle/Oracle.so' for module DBD::Oracle: libwtc9.so: cannot open shared object file: No such file... (4 Replies)
Discussion started by: DILEEP410
4 Replies

2. Shell Programming and Scripting

Perl Database access

Hi, I tried to run this code but it isnt giving me any output or errors. My aim is to retrieve the row based on the flag name(this is the primary key). flag_test is my table This is how i ran it: perl read_db.pl flag1 flag1 is the criteria in where clause -------- this is my... (2 Replies)
Discussion started by: mercuryshipzz
2 Replies

3. Shell Programming and Scripting

Automating A Perl Script over a database

Dear Scripting Gods I've never done shell scripting before and have only recently got to grips with Perl, so apologies for my naivity. I've written a perl program which takes in two files as arguments (these are text documents which take in the information I need) The perl program spits out a... (1 Reply)
Discussion started by: fraizerangus
1 Replies

4. Shell Programming and Scripting

perl, testing a database for a match

hi there. in perl, I am struggling to find a simple method of connecting to a database, determining if the result of my query is "true" and then testing against the result. I dont even really want the data that i am 'SELECT'íng. i effectively just want to check that a record exists with a UID... (2 Replies)
Discussion started by: rethink
2 Replies

5. Shell Programming and Scripting

Perl script to connect to database using JDBC driver?

How to connect to SQL Server database from perl script using JDBC driver? ---------- Post updated at 05:33 PM ---------- Previous update was at 05:07 PM ---------- i have sqljdbc.jar file. by setting the class path how can i connect to the database using perl script? (2 Replies)
Discussion started by: laknar
2 Replies

6. Shell Programming and Scripting

help with perl database printing

Hey guys i am using perl and trying to pull a list of books from a database and then populate the list in a separate TT2 file. When the list is generated there should be 39 book names. When I do the foreach statement in my tt2 below, the first statement gives me 39 Array(random number) and the... (1 Reply)
Discussion started by: Joey12
1 Replies

7. Programming

Help with mySQL database by perl script

Hello; I was trying to set up a mysql database using following script, but never went through. The code seems fine without any syntax error as I tested it: perl -c Brapa0101-db.pl Brapa0101-db.pl syntax OKHowever, whenever I run it, an error message was tossed out: DBD::mysql::st execute... (7 Replies)
Discussion started by: yifangt
7 Replies

8. UNIX and Linux Applications

SQL database call into Multidimensional Array using Perl Script

#!/usr/local/bin/perl use DBI; use File::Copy; use Time::Local; use Data::Dumper; -Comments Describing what I'm doing-------------- -I'm pulling information from a database that has an ID and Name. They are separated by a space and I'm trying to load them into a multidimensional array so as... (3 Replies)
Discussion started by: eazyeddie22
3 Replies

9. Shell Programming and Scripting

Perl script database date convertion

Need assistance Below script get the output correctly I want to convert the date format .Below is the output . Any idea ? #!/usr/bin/perl -w use DBI; # Get a database handle by connecting to the database my $db = DBI->connect(... (3 Replies)
Discussion started by: ajayram_arya
3 Replies

10. Shell Programming and Scripting

Help required for Oracle database shutdown script conversion from shell to perl

Please tell me how to convert below program from shell script to perl. Same commands need to use in shutdown, just need program help for startup. export ORACLE_BASE=/home/oracle1 lsnrctl start lndb1 sqlplus '/ as sysdba' startup; (2 Replies)
Discussion started by: learnbash
2 Replies

LEARN ABOUT DEBIAN

mysql_import_combined_log2

mysql_import_combined_log.pl(1) 			      General Commands Manual				   mysql_import_combined_log.pl(1)

NAME

       mysql_import_combined_log.pl - Imports an Apache combined log into a MySQL database.

SYNOPSIS

       mysql_import_combined_log.pl -d <database name> -t <table name> [-h <host name>] [-u <user name>] [-p <password>] [-f <filename>]

OPTIONS

       --host|-h <host name>

	      The host to connect to. Default is localhost.

       --database|-d <database name>

	      The database to use. Required.

       --username|-u <username>

	      The user to connect as.

       --password|-p <password>

	      The user's password.

       --table|-t <table name>

	      The name of the table in which to insert data.

       --logfile|-f <file name>

	      The file to read from. If not given, data is read from stdin.

       --help|-?

	      Print out this help message.

       --version

	      Print out the version of this software.

AUTHOR

       Aaron Jenson

       Updated to work under Perl 5.6.1 by Edward Rudd

MAN PAGE CREATED BY

       Michael A. Toth <lirul.lists@gmail.com> - based on content of script

COMMENTS

       This man page was written using xml2man (1) by the same author.

Manuals 							       User					   mysql_import_combined_log.pl(1)
All times are GMT -4. The time now is 12:59 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy