Rename Folders/Subfolders/Files and other doubt

For all your cases in your function where you are calling RD to rename a directory, you would use:

call aqFileSystem.RenameFolder("C:\OldName", "C:\NewName")

You don't need anything fancy around that, just simply send in the old name of the folder with it's full path and then give it the new name, also with the full path.



As for renaming files, it's also very much the same sort of thing.

call aqFileSystem.RenameFile("C:\MyFolder\OldName.txt", "C:\MyFolder\NewName.txt")

So, if I'm reading your code correctly, the first 10 lines of your code would be replaced as such:

'  Rename folder LG Componentes and files.sql

  aqFileSystem.RenameFolder("D:\Scripts\Scripts\01 - LGComponentes", "D:\Scripts\Scripts\1.LGComponentes")

  aqFileSystem.RenameFolder("D:\Scripts\Scripts\1.LGComponentes\SQL Server", "D:\Scripts\Scripts\1.LGComponentes\SQLServer")

  aqFileSystem.RenameFile("D:\Scripts\Scripts\1.LGComponentes\SQL Server\1.LGComponentes_CREATE_SQL_SERVER.sql", "D:\Scripts\Scripts\1.LGComponentes\SQL Server\1.SQL")

  Log.Message("Folder 1.LGComponentes renamed")

Hope this helps.



As for your other request, look at using aqFile.ReadWholeTextFile and then using the aqString.Replace against that result.  Then use aqFile.WriteToTextFile to output the result back to your file.

Hey Robert. I think it will help a lot.

Another doubt.

I'll set a const with my directory on it:

 Const Path = "D:\Scripts\Scripts\"

I'm trying to do that on my code but isn't working:

aqFileSystem.RenameFolder(Path&"01 - LGComponentes",""&Path&"1.LGComponentes"")

On this case, the idea is to prevent typing "D:\Scripts\Scripts\01 - LGComponentes" many times, just trying to make my script more understandable.

How does my quotes and concatenation char will be typed in here?





Thanks (again) for your attention!!!





PS.: I tried your code and it is returning an error message (attached).

About the other tip that you gave me, that is my priority.



How does aqString.Replace will see what is written inside my files and replace it? On SmarBear's example (linked) it replaces just the string inside TestComplete.



I've attached an .sql file for you to take a look and understand what I'll have to do.

I'll have to read all of it, then I'll replace the "CREATE TABLE xxxxx" to "SELECT * FROM xxxxx" and output all the replaced lines to a new .sql file, that I'll run after replace every code from every files in directory (something around 150 .sql files).

The output file will just need to have the 'SELECT * FROM xxxxx' lines. The rest of the code can be discarded (the .sql file where my script will look for Create Table xxxxx lines can't be altered.)



Any ideas??

Hey Robert. We've forgot to Call the functions. Now it is working, but it isn't working right.



When I call this code:

Call aqFileSystem.RenameFolder("D:\Scripts\Scripts\01 - LGComponentes", "D:\Scripts\Scripts\1.LGComponentes")

It doesn't rename the folder 01 - LGComponentes to 1.LGCompontenes. It creates a new folder named 1.LGComponentes and paste the folder 01 - LGComponentes inside of it.



Any tip about why it is happening?

Hey Robert.



About my doubt about search and replace text inside the file, I did it by using the following code:

s = aqFile.ReadWholeTextFile("D:\Scripts\Scripts\1.LGComponentes\Oracle\1.sql", aqFile.ctUTF8)

s = aqString.Replace(s, "CREATE TABLE", "SELECT * FROM")

If (aqFile.Create("D:\Scripts\Scripts\1.LGComponentes\Oracle\1-Sel.txt") = 0) Then

 Call aqFile.WriteToTextFile("D:\Scripts\Scripts\1.LGComponentes\Oracle\1.txt", s, aqFile.ctUTF8)

 Call Log.Message("Sucesso!")

 Call aqFile.Rename("D:\Scripts\Scripts\1.LGComponentes\Oracle\1.txt", "D:\Scripts\Scripts\1.LGComponentes\Oracle\1-Select.sql")

Else

 Call Log.Error("Falha")

End If 

But how will I remove EVERYTHING in my new file that I don't need?



An example:

The file has:

SELECT DECODE(COUNT(*), 0, 'FALSE', 1, 'TRUE') FROM ALL_TABLES WHERE TABLE_NAME='LGID'(  TABELA VARCHAR2(60) NOT NULL,  ULTIMO_ID NUMBER(18) NOT NULL ) PCTFREE    10  PCTUSED    60  INITRANS   1  MAXTRANS   255  TABLESPACE TS_FPW_DAT_01  STORAGE   (       INITIAL     40960       NEXT        40960       PCTINCREASE 0       MINEXTENTS  1       MAXEXTENTS  200    )/

And all I need is:

SELECT DECODE(COUNT(*), 0, 'FALSE', 1, 'TRUE') FROM ALL_TABLES WHERE TABLE_NAME='LGID'

Is that even possible?



P.S.1: This is just an example of a file. In the same file I have lots of CREATE TABLE, ALTER TABLE, etc... But all I'll always need is the CREATE TABLE entire line.

P.S.2: Sorry about all this posts, but I don't have permission to edit my posts.

Okay... question then... why are you using your automation code to alter the contents of the SQL query files on the fly?  If you have extraneous information in the files, why not create the proper files ahead of time?  There's part of this process that I'm missing.

As for why the rename of the folder is creating a new folder and copying the contents, I was able to reproduce this.  The reproduction happened if one of the files in the folder being renamed is open and in use.  If that's the case, the function makes a copy of the folder.



Make sure all your files are closed before doing the folder rename.

Okay... question then... why are you using your automation code to alter the contents of the SQL query files on the fly?  If you have extraneous information in the files, why not create the proper files ahead of time?  There's part of this process that I'm missing.

Let me explain what my entire script will do. By doing this I think you'll be able to help me.



First of all: what does "on the fly" means?



My script will rename Folders and Files to remove all blank spaces on it. So, I decided to rename all SQL files to a number, that indicates when it will be executed, as a queue of files.

After renaming my folders/files starts the most complex part.



My SQL files has a lot of commands. I'll need to open each SQL file, and search for the command "CREATE TEABLE xxxxxx" and rename it to

SELECT DECODE(COUNT(*), 0, 'FALSE', 1, 'TRUE') FROM ALL_TABLES WHERE TABLE_NAME='xxxxxx'

;

Note that my table name doesn't have quotes but they will receive quotes to SELECT command work.



The result of this renaming should populate a new SQL file, wich I'll execute to see if all my CREATE TABLES were executed successfully.



I think this is it.

"On the fly" is an idiom that essentially means that, instead of configuring your files and folders ahead of time for use with your scripts, you're changing the files during the course of the script run.



I understand what you're trying to do with the files and folders, I'm just curious as to why.  Is there some reason why you need to do all this file and folder manipulation as script code?  Why not just manually edit all the files and folders to be the values you need them rather than having script code do so?



In any case, what you might need to do is, instead of reading the whole file in as text, read only the first line in, do your replace on that line, and then write the result out to your file, replacing all contents.



You'll need to use aqFile.OpenTextFile which returns an object of type aqTextFile.  This is probably what you'll need to use in order to specifically grab just the one line, alter it, and then dump just that line down to your file.

"On the fly" is an idiom that essentially means that, instead of configuring your files and folders ahead of time for use with your scripts, you're changing the files during the course of the script run. I understand what you're trying to do with the files and folders, I'm just curious as to why.  Is there some reason why you need to do all this file and folder manipulation as script code?  Why not just manually edit all the files and folders to be the values you need them rather than having script code do so? In any case

This folders are monthly recreated, so, if I do the rename process manually I would need to do that every month. The folders and files are always the same quantity but there content are NEVER the same. Maybe today there are 5 CREATE TABLE in one file and next month it will have 10 CREATE TABLE on that file. That's why I am automating it.



And now I decided to automate the execution of the scripts. But I need to have a log that shows me if they are being executed properly. That's why I want to create SELECT to all create tables.



Hope you can help me. I might do that until friday!