05-09-2019
Voila!
Changed the last part with exact match like shown below and no need to create a second query to grab video_id:
.....WHERE url = 'http://localhost/test/" $1 ".mkv';"}
What I still do not know is how it grabs video_id as value in SELECT field.
I did not tell it to read video_id where $1 matches.
I supposed that I should have created a second query to grab it which was the main purpose of the thread.
Thank You All
Boris
9 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
i am using the below script and trying to move files in that directory in that pattern to archive. But it doesn;t seem to take the metacharacters. Please sugggest.
Code
Debug output: (1 Reply)
Discussion started by: dsravan
1 Replies
2. Shell Programming and Scripting
I heard this was possible but from my research I haven't been able to figure it out yet. Seems it should be simple enough. Basically from a high level view I'm trying to accomplish...
. $X='grep foo blah.log'
then 'mysql command SELECT foo FROM bar WHERE ' . $X
or something like that.
... (2 Replies)
Discussion started by: kero
2 Replies
3. Shell Programming and Scripting
Hi Gurus
I have a file called /tmp/CMDB which looks like this
serial: 0623AN1208
hostname: server1
model: x4100
assetID: 1234
I am writing a for loop that will go through this file line by line creating a variable of itself. Using the first iteration of the loop (i.e. the first line) as... (6 Replies)
Discussion started by: hcclnoodles
6 Replies
4. Shell Programming and Scripting
Hi all,
I have a variable say var1 (output from somewhere, which I can't change)which store something like this:
echo $var1
name=fred
age=25
address="123 abc"
password=pass1234
how can I make the variable $name, $age, $address and $password contain the info?
I mean do this in a... (1 Reply)
Discussion started by: freddy1228
1 Replies
5. Shell Programming and Scripting
I'm running a bash script query and assigning the output to a variable like this:
exists=`mysql -u $USER_NAME --password=$PASSWORD -D "somedb" \
-e "SELECT * FROM somedb.sometable WHERE field1 ='$a' \
AND field2 ='$b' LIMIT 0 , 30";`
which returns something like:
echo... (2 Replies)
Discussion started by: unclecameron
2 Replies
6. Shell Programming and Scripting
Hello. I am writing a simple script that reads a text file and removes records from a mysql database. The items in the text file are of the format:
firstname.middle.lastXXX, where XXX is a 3 digit number. The table has an email field that will match the firstname.middle.last. So, I thought I... (1 Reply)
Discussion started by: bricoleur
1 Replies
7. UNIX for Dummies Questions & Answers
Is FreeBSD and OpenBSD considered Unix? What O.S does Most of the forum members use? How popular are Licensed Unix operating systems for home users?
Additionally I thought Linux was a Minux fork and BSD was a Unix fork.
Thanks in ... (7 Replies)
Discussion started by: theKbStockpiler
7 Replies
8. UNIX for Advanced & Expert Users
Hi all,
I'm bit new to the advanced bash shell scripting.
When I'm looking at some of the existing code in my organization, got confused with a few variable definings.
For ex:
var1={1:-30}
var2="abc def ghi"
var3={xyz:-$var2}
In above, 1st and last lines are confusing me.... (4 Replies)
Discussion started by: raghu.iv85
4 Replies
9. UNIX for Dummies Questions & Answers
I'm a bit confused about the term ‘environment variables'.
Within your shell you can set two types of variables:
1. Shell variable - affecting functionality within your shell
2. User defined variable
When using the ‘export' command on a variable you make sure it's being inherited by new sub... (2 Replies)
Discussion started by: niels
2 Replies
LEARN ABOUT DEBIAN
www::nicovideo::download
WWW::NicoVideo::Download(3pm) User Contributed Perl Documentation WWW::NicoVideo::Download(3pm)
NAME
WWW::NicoVideo::Download - Download FLV/MP4/SWF files from nicovideo.jp
SYNOPSIS
use WWW::NicoVideo::Download;
my $client = WWW::NicoVideo::Download->new(
email => 'your-email@example.com',
password => 'PASSWORD',
);
$client->download("smNNNNNN", &callback);
DESCRIPTION
WWW::NicoVideo::Download is a module to login, request and download video files from Nico Nico Douga.
METHODS
new
$client = WWW::NicoVideo::Download->new(%options);
Creates a new WWW::NicoVideo::Download instance. %options can take the following parameters and they can also be set and get using
accessor methods.
email, password
Sets and gets email and password to login Nico Nico Douga. Required if the User Agent object doesn't have the valid session or cookie
to login to the site.
user_agent
Sets and gets LWP::UserAgent object to use to send HTTP requests to nicovideo.jp server. If you want to reuse the browser Cookie that
has the signed-in state, you can set the Cookie to the UserAgent object here.
# use Safari sesssions
use HTTP::Cookies::Safari;
my $cookie_jar = HTTP::Cookies::Safari->new(
file => "$ENV{HOME}/Library/Cookies/Cookies.plist",
);
my $client = WWW::NicoVideo::Download->new;
$client->user_agent->cookie_jar( $cookie_jar );
download
$client->download($video_id, $file_path);
Prepares the download by logging in and requesting the FLV API, and then download the video file. The second parameter is passed to
LWP::UserAgent's request() method, so you can pass either local file path to be saved, or a callback function.
prepare_download
my $url = $client->prepare_download($video_id);
Prepares the download and returns the URL of the actual video. See eg/fetch-video.pl how to make use of this method.
AUTHOR
Tatsuhiko Miyagawa <miyagawa@cpan.org>
Original download code for Plagger was written by Yusuke Wada and the command line tool written by woremacx.
LICENSE
This library is free software; you can redistribute it and/or modify it under the same terms as Perl itself.
SEE ALSO
perl v5.10.1 2010-03-26 WWW::NicoVideo::Download(3pm)