vandor-rename icon indicating copy to clipboard operation
vandor-rename copied to clipboard

Automatically insert header at SQL files

Open icaropires opened this issue 4 years ago • 3 comments

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

icaropires avatar Oct 06 '19 19:10 icaropires