Automatically insert header at SQL files
Opened this issue · 3 comments
icaropires commented
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
nameparam 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
icaropires commented
This is big, I could share it with no problems 😅
joaorobson commented
Can I solve this issue? Currently, I have a lot of spare time from university.
icaropires commented
Can I solve this issue? Currently, I have a lot of spare time from university.
@joaorobson Sure! You're a hero...