Update MariaDB table with variable from curl in bash script

Question

I have read literally every answer on the net that I could find. Nothing is similar to my problem, so here it is:

I have a bash script with curl and I get a variable back. I want to update my database with this variable, however it doesn't work.

My variable is $stream and no matter what I do, I always get the word "$stream" into the database instead of the result of the curl.

My script is:

#!/bin/bash
    
stream=$(curl --silent "https://player.mediaklikk.hu/playernew/player.php?video=mtv1live&noflash=yes&output=vast&unviewed_position_start=1&env=vp&impl=s&correlator=&osfamily=Windows&osversion=10&browsername=Chrome&browserversion=97.0.4692.99&title=M1&contentid=mtv1live&embedded=0" | grep -Po 'file": "\K(.*?)(?=")' | sed 's/\\\/\\\//https:\\\/\\\//g')
    
echo $stream

mysql
use mydatabase;

UPDATE my_table SET my_url = "$stream" WHERE my_name = 'stream_name';

I don't see how that's being used as input to mysql in the first place. You need to use << to make it a here-document. — Barmar
– Barmar, Commented Jan 25, 2022 at 18:56
@Barmar Thanks for reply. I am a beginner. I have no idea what you mean :-) It took about ten hours for me to get that what you see. I looked up here documents, but I don't really understand how I should use it in this case. But thanks anyway. — Netuddki
– Netuddki, Commented Jan 25, 2022 at 19:54
I don't understand how your script is doing anything at all if you don't use a here document. When it executes mysql it's going to wait for you to type commands, it won't treat the following lines as SQL commands. — Barmar
– Barmar, Commented Jan 25, 2022 at 20:25
It would do that if you typed those commands by hand, it shouldn't write anything to the DB if you run it as a script. — Barmar
– Barmar, Commented Jan 25, 2022 at 20:56

Barmar · Accepted Answer · 2022-01-25 20:27:26Z

1

You can use the -e option to execute a query. Put this in double quotes and variables will be expanded.

#!/bin/bash

stream=$(curl --silent "https://player.mediaklikk.hu/playernew/player.php?video=mtv1live&noflash=yes&output=vast&unviewed_position_start=1&env=vp&impl=s&correlator=&osfamily=Windows&osversion=10&browsername=Chrome&browserversion=97.0.4692.99&title=M1&contentid=mtv1live&embedded=0" | grep -Po 'file": "\K(.*?)(?=")' | sed 's/\\\/\\\//https:\\\/\\\//g')

echo $stream

mysql mydatabase -e "UPDATE my_table SET my_url = '$stream' WHERE my_name = 'stream_name';"

answered Jan 25, 2022 at 20:27

Barmar

789k57 gold badges555 silver badges669 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Netuddki Over a year ago

Thank you. That worked!

EsmaeelE Over a year ago

From manpage for mysql command --execute=statement, -e statement

Collectives™ on Stack Overflow

Update MariaDB table with variable from curl in bash script

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related