Script Help

[TheDevopsGuy]

Hi All,

Currently configuring a new script.

Im currently capturing a variable from user input and storing it in variable "schemaname"

I want to use this variable to search in a directory and execute all files in said directory containing a certain string.

example if schema a is selected execute something like

ls | grep *a* > schema.txt

I want to then iterate through the schema.txt file in the particular directory and execute a command any clue what would be the best practice for this?

 

[DelJo63]

and execute all files in said directory containing a certain string.

even if the string is found in a *.txt file ??

 

[TheDevopsGuy]

Doesnt have to be in a txt file but the gist is to itterate through a list which is generated from user input ex if schema a is selected execute a1.sql a2.sql ect

 

[DelJo63]

if schema a is selected execute a1.sql a2.sql

my point is where does the scripts {a1, a2, ... } come from, clearly not a2.txt

 

[TheDevopsGuy]

Ah it looks in a directory specific by a date variable specified by another function in the script there are 3 schemas users can enter im trying to regex and setup if else statements just checking on the ideal setup as how I’m planning it is kinda prone to errors

 

[TheDevopsGuy]

In the directory there are usually several files id like to automate deploy instead of running sql one by one on every server the script is able to retrieve the hosts to upload to in which directory to run its just a matter of implementing a safe setup on identifying all the files and uploading them to the correct schemas

 

[TheDevopsGuy]

If you want I can show you a sample in priv

 

[DelJo63]

I am sure you have a need for this but the process reminds me of shooting holes in the side of a barn expecting marvelous results when the chickens are in the pen across the road. Just doesn't make sense to me; no disrespect intended.

 

[TheDevopsGuy]

I am sure you have a need for this but the process reminds me of shooting holes in the side of a barn expecting marvelous results when the chickens are in the pen across the road. Just doesn't make sense to me; no disrespect intended.

I agree 100% to me its nothing big. Making the script involves mistakes to be made considering im not that good. I have a ticket which needs to be fulfilled, whether I want it or not.. Bosses know the risk. They want to cut costs thats all.

 

[DelJo63]

Using this model

ls | grep *a* > raw.txt

tokenize words in raw.txt
for every token containing $a
   emit $targetDir/token.sql >>$targetDir/tokenized.sql

 

[TheDevopsGuy]

Using this model

tokenize words in raw.txt
for every token containing $a
   emit $targetDir/token.sql >>$targetDir/tokenized.sql

Will give it a shot next monday cheers jo