vandor-rename
vandor-rename copied to clipboard
Automatically insert header at SQL files
It's also required that on every exercise the SQL scripts have a header, this is not fun to be made manually.
A header looks like this:
-- -------- << aula3exer1Evolucao2 >> ------
-- --
-- SCRIPT APAGA (DDL) --
-- --
-- Data Criacao ..........: 27/09/2019 --
-- Autor(es) .............: Author1 --
-- Author2 --
-- Banco de Dados ........: MySQL --
-- Base de Dados(nome) ...: aula3exer1Evolucao2 --
-- --
-- Data Ultima Alteracao ..: 2/10/2019 --
-- + Modification1 --
-- + Modification2 --
-- --
-- PROJETO => 1 Base de Dados --
-- => 4 Tabelas --
-- --
-- ----------------------------------------------------------------- --
So, this application should be able to:
- [ ] Check if the file already has a header and if not, add it
- [ ] Update the exercise name
- [ ] Update the type the title with the type of the script. Ex:
SCRIPT APAGA (DDL)
- [ ] Update the date of the last modification to the current date
- [ ] Take the
name
param given by the user and append it to the authors list - [ ] Update the number of tables, users and views this information should be taken by parsing all valid script files