Hello,
I am running ubuntu16.04.
By means of @Rudic's help, I have below command.
What I need to do is to replace video_id by value of video_id in which WHERE clause is matched:
video_id is the name of column, video_id should be the value inside the same row when "WHERE" query matches.
I assigned variable as @video_id and then tried to grab the value_id but no luck :
I'd appreciate your help
Thank you
Boris
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)
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)
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)
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)
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)
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)
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)
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)
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
photon
PHOTON(1)PHOTON(1)NAME
photon - generates photo albums
SYNOPSIS
photon [OPTIONS] [PATH]
DESCRIPTION
Photon generates clean, yet configurable, static HTML photo galleries. All of the work is done from the command line, and the resulting
output can easily be configured by changing the template files found in /usr/share/photon/templates.
To create a new template (skin), first create a new directory:
mkdir -p ${HOME}/.photon/templates/my_theme/
Then copy the contents of /usr/share/photon/templates/photonv1/ to this new directory. Photon only needs three files to build pages:
index.html
used to display the content of a folder
image.html
used to display the page for an image
movie.html
used to display the page for a movie
If a file is missing, then photon will throw an error and will not run.
HOW TO BUILD A GALLERY
Quick start
$ photon -o myoutputdir /photos
Use the gimp plugin
$ photon --resize-plugin=gimp -v -o myoutputdir /photos
Change the size for all images and the thumbnail and keep the original photo
$ photon --sizelist=0,1600x1200,800x600 --thumbsize=320x240 -o myoutputdir /photos
Create a gallery from your custom template (skin)
$ photon -k my_theme -o myoutputdir /photos
See photon help
$ photon --help
OPTIONS -a | --awstats
Insert Javascript for Awstats
--awstats-url=URL
Change default value for Awstats script url
-c NAME | --comment
Name of the comment file (default .comments)
-d NUM | --display-columns=NUM
Number of columns in index (default 3)
-E | --no-exif
Don't include EXIF information in HTML file
-f | --force
Overwrite non-image generated files (html, javascript, etc) (default no)
-ff | --force --force
Overwrite image files (default no)
-h | --help
Print this help
-I | --no-index
Do not generate the high level index.html
-J | --no-javascript
Do not use javascript (no shortcuts, ... )
-k | --skin=THEME
Skin selector (default photonv1)
--print-skins
Print out available skins (templates)
-l NUM | --display-lines=NUM
Number of lines in index (default 5)
-m | --movie
Movie mode, include link to movie (*.mov)
-o NAME | --output-directory=NAME
Name of the output directory
-s LIST | --sizelist=LIST
Image sizes (default 0,1024x768,800x600,640x480). Zero, which is the default, uses the original resolution. W x H specifies the width
and height of the image in pixels.
-t SIZE | --thumbsize=SIZE
Size of thumbnails (default 160x120)
-v | --verbose
Verbosely print information
-V | --version
Print program version number
-z | --compress
Compress the original image if selected (default copy the image)
--exif-bordercolor=COLOR
Exif window border color (default #008000)
--exif-bgcolor=COLOR
Exif window background color (default #f0fff0)
--exif-fgcolor=COLOR
Exif window text color (default black)
--body-bgcolor=COLOR
Body background color (default #ccccff)
--img-bgcolor=COLOR
Image background color (default white)
--exclude=PATTERN
Exclude files matching PATTERN
--resize-plugin=PLUG
Where PLUG is the program used to create thumbnails internal: fastest method (default) gimp: use Gimp>1.x (better quality)
--resize-quality-low=NUM
Quality for small image. 0 (bad) and 100 (good)
--resize-quality-high=NUM
Quality for big image 0 (bad) and 100 (good)
--gimp-program=PROG
use PROG for gimp
SHORTCUTS WHILE VIEWING AN IMAGE
n/SPACE Go to the next image (with the same resolution)
p/BACKSPACE Go to the previous image (with the same resolution)
s Start/Stop the slideshow
+/- Increase/Decrease by one second the slideshow's period
h Show shortcut and help
i Show Exif information
z Change to the higher resolution [NOT YET IMPLEMENTED]
SEE ALSO gimp(1)AUTHOR
Written by Luc Saillard, <luc@saillard.org>
Main web site: http://www.saillard.org/programs_and_patches/photon/
This manual page was written by Kevin Coyner <kcoyner@debian.org> for the Debian project but may be used by others.
12/16/2006 PHOTON(1)