Sponsored Content
Top Forums Shell Programming and Scripting Inserting script variables into database Post 302986859 by leshy93 on Wednesday 30th of November 2016 05:15:30 PM
Old 11-30-2016
Inserting script variables into database

I have a script working out ink percentages
Code:
#!/bin/bash
currentcyan=$'iso.3.6.1.2.1.43.11.1.1.9.1.1 = INTEGER: 990'
currentmagenta=$'iso.3.6.1.2.1.43.11.1.1.9.1.2 = INTEGER: 972'
currentyellow=$'iso.3.6.1.2.1.43.11.1.1.9.1.3 = INTEGER: 972'
currentblack=$'iso.3.6.1.2.1.43.11.1.1.9.1.4 = INTEGER: 250'
maxcyan=$'iso.3.6.1.2.1.43.11.1.1.9.1.1 = INTEGER: 2800'
maxmagenta=$'iso.3.6.1.2.1.43.11.1.1.8.1.2 = INTEGER: 1800'
maxyellow=$'iso.3.6.1.2.1.43.11.1.1.8.1.3 = INTEGER: 1800'
maxblack=$'iso.3.6.1.2.1.43.11.1.1.8.1.4 = INTEGER: 2500'
cyanperc=$(( ${currentcyan##* }*100/${maxcyan##* } ))
magentaperc=$(( ${currentmagenta##* }*100/${maxmagenta##* } ))
yellowperc=$(( ${currentyellow##* }*100/${maxyellow##* } ))
blackperc=$(( ${currentblack##* }*100/${maxblack##* } ))
echo $cyanperc
echo $magentaperc
echo $yellowperc
echo $blackperc

Instead of echoing the values I want to insert them into a MySql database on a server. Maybe curl?

Any help appreciated.

Raspberry Pi 3 running Ubuntu Mate, GNU, version 4.3.46(1)
 

10 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

Inserting variables from 2 files to create 1 file

Hi, I have 2 files which are as follows: Num: 548983 748932 783928 547383 839284 Grp: 2389 9873 8493 7382 8493 I need to make an output file using both of these files. (1 Reply)
Discussion started by: rochitsharma
1 Replies

2. Shell Programming and Scripting

Need shell script for inserting New line

Hi All, We have standard programming that creates large files. This file is very big. It contains header record,details records and Trailer record. Details record are of 1024 bytes(Each detail record contains summary(512 bytes) and detail(512 bytes) record). My user wants to insert new line... (16 Replies)
Discussion started by: shivakumar1231
16 Replies

3. Shell Programming and Scripting

script for inserting line at specific place in file

I use zentyal for my server admin, which is great but zentyal auto-generates config file on boot and hence overwrites any changes made directly to config files. In order to allow multiple user access to a MS ACCESS database, I need to customise the smb.conf file and add the following line to the... (9 Replies)
Discussion started by: barrydocks
9 Replies

4. Shell Programming and Scripting

Script for Logfile Inserting into the Database

Here's the problem. I have a shell script running for every one minute as cronjob that outputs to a log file. I want to be able to take the data from the log file and insert it into a mysql database. The script needs to run at a set period of time and remove the log file data once the insert is... (7 Replies)
Discussion started by: kgrvamsi
7 Replies

5. Shell Programming and Scripting

Help is Script inserting in db2 tables

Hi, I am creating a shell script to insert few records in db2 tables. I am facing 2 challenges and would appreciate your help on this. 1) In my insert statement like follows: db2 "connect to dbname user user_name"; db2 "insert into table_name (name, phone, ssn) values... (1 Reply)
Discussion started by: pinnacle
1 Replies

6. Shell Programming and Scripting

Need help on inserting data from text file to excel using shell script

Hi, Please help me on this. I want to insert data from text file to excel using shell script nawk -v r=4 -v c=4 -v val=$a -F, 'BEGIN{OFS=","}; NR != r; NR == r {$c = val; print}' "file.csv" I used above one to insert $a value in 4th row, 4th column in an excel file.csv and it... (3 Replies)
Discussion started by: suman.frnz
3 Replies

7. Shell Programming and Scripting

Running a script with multiple variables like 25 variables.

Hi All, i have a requirement where i have to run a script with at least 25 arguements and position of arguements can also change. the unapropriate way is like below. can we achieve this in more good and precise way?? #!/bin/ksh ##script is sample.ksh age=$1 gender=$2 class=$3 . . .... (3 Replies)
Discussion started by: Lakshman_Gupta
3 Replies

8. UNIX for Dummies Questions & Answers

Inserting a variable in awk script

I have file input.txt: >TX1-1 Freq 55 cattctgatgaatatttgtcctttagttgttatttgt >TX1-2 Freq 19 cattctgatgaatatttgtcctttagttgttatttgt >TX1-3 Freq 17 cattctgatgaatatttgtcctttagttgttatttgt >TX1-4 Freq 6 cattctgatgaatatttgtcctttagttgttatttgt >TX1-5 Freq 6 cattctgatgaatatttgtcctttagttgttatttgt ... (5 Replies)
Discussion started by: Xterra
5 Replies

9. Shell Programming and Scripting

Inserting values into database from an excel

Hi, I have a requirement where I have an excel sheet with the below values COL1 COL2 COL3 Germany URGENT NORMAL I want to cut the values of this excel in such a way that I get the values and pass it to an insert statement update tbfin set... (2 Replies)
Discussion started by: venkidhadha
2 Replies

10. Shell Programming and Scripting

Inserting values to database

hi , I'm new to Unix shell scripting. I need help to insert read csv which has two columns -emp no and logged date. csv file is a large file so i want to keep the insertion query in a separate .sql file. csv file looks this: empno | loggeddate ___________________ 5666 ,... (5 Replies)
Discussion started by: preema
5 Replies
GRML2ISO(8)															       GRML2ISO(8)

NAME
grml2iso - create a multiboot grml ISO using grml2usb SYNOPSIS
grml2iso -o <target.iso> <ISO[s]> Important! The grml team does not take responsibility for loss of any data! INTRODUCTION
grml2iso allows you to create a multiboot grml ISO. You can specify two or more grml ISOs and will get one single multiboot ISO as a result. grml2iso requires and uses grml2usb for this task and installs grub2 as bootmanager on the multiboot ISO. OPTIONS
grml2iso supports the environment variables GRML2USB and WRKDIR. GRML2USB specifies the path to the grml2usb script you'd like to use. WRKDIR specifies the work directory for creating the filesystem. The work directory needs at least as much free disk space as the sum of all specified ISOs. -o <target.iso> This option is mandatory and specifies where the resulting multiboot grml ISO should be placed. Note that (to avoid any possible data loss) grml2iso will exit if the specified target.iso exists already. -c <directory> The content of the specified directory will be copied to the resulting multiboot grml ISO. -b <boot params> Use specified default bootoptions as default. -f Force the program to run and overwrite an existing iso image. -r <boot param> Remove specified boot parameter from existing command line. Could be specified multiple times. -p <grml2usb param> Execute grml2usb with the specified parameters. For a list of valid parameters have a look at the grml2usb webpage[1] or the grml2usb manpage -s <URI> Generate a small iso file which downloads the squashfs file from the specified URI. Due to current limitations in busyboxs wget and DNS resolution, an URL can not contain a hostname but an IP only. This is useful if you want to boot systems which support booting iso image from your local system. Besides the iso image this command also copies the squashfs file to the output directory. USAGE EXAMPLES
# grml2iso -o /tmp/grml.iso grml_2009.05.iso grml64_2009.05.iso Create multiboot ISO /tmp/grml.iso with grml_2009.05.iso and grml64_2009.05.iso. # grml2iso -b 'lang=de ssh=passwd' -c /tmp/grml-content -o /srv/grml.iso /srv/grml/grml_2009.10.iso Create a new iso with additional boot parameters and copy the content from /tmp/grml-content to the generated iso image. # grml2iso -r quiet -r vga=791 -o /srv/grml.iso /srv/grml-small_2009.10.iso Create a new iso and remove existing boot parameters quiet and vga=791. # GRML2USB=/srv/git/grml2usb grml2iso -o /srv/grml.iso /srv/grml/grml_2009.05.iso /srv/grml/grml64-medium_2009.05.iso Create multiboot ISO /srv/grml.iso with grml_2009.05.iso and grml64-medium_2009.05.iso using /srv/git/grml2usb as grml2usb script. # WRKDIR=/mnt/test/grml-tmp grml2iso -o /mnt/test/grml.iso grml_2009.05.iso grml64_2009.05.iso Use /mnt/test/grml-tmp as working directory for creating the multiboot ISO /mnt/test/grml.iso with grml_2009.05.iso and grml64_2009.05.iso. # grml2iso -p --skip-addons -o /srv/grml.iso /srv/grml-small_2009.10.iso /srv/grml64-small_2009.10.iso Don't copy the addons from the specified iso images ONLINE RESSOURCES
Check out the grml2usb webpage[1] and the grml2usb git repository[2]. BUGS
Please report feedback, bugreports and wishes to the author. AUTHORS
Michael Prokop <mika@grml.org[3]> and Thorsten Glaser <tg@mirbsd.org[4]> NOTES
1. grml2usb webpage http://grml.org/grml2usb/ 2. grml2usb git repository http://git.grml.org/?p=grml2usb.git 3. mika@grml.org mailto:mika@grml.org 4. tg@mirbsd.org mailto:tg@mirbsd.org 05/28/2012 GRML2ISO(8)
All times are GMT -4. The time now is 07:15 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy