-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathdata_domain_inserts.sql
94 lines (81 loc) · 12.8 KB
/
data_domain_inserts.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
-- Insert Operations
INSERT INTO operations (id, name, code, description, created_at, updated_at) VALUES (1, 'Pesquisar Operação', 'pesquisar_operacao', 'Operação referente a funcionalidade de Pesquisa de Operações', NOW(), NOW());
INSERT INTO operations (id, name, code, description, created_at, updated_at) VALUES (2, 'Incluir Operação', 'incluir_operacao', 'Operação referente a funcionalidade de Inclusão de Operações', NOW(), NOW());
INSERT INTO operations (id, name, code, description, created_at, updated_at) VALUES (3, 'Editar Operação', 'editar_operacao', 'Operação referente a funcionalidade de Edição de Operações', NOW(), NOW());
INSERT INTO operations (id, name, code, description, created_at, updated_at) VALUES (4, 'Excluir Operação', 'excluir_operacao', 'Operação referente a funcionalidade de Exclusão de Operações', NOW(), NOW());
INSERT INTO operations (id, name, code, description, created_at, updated_at) VALUES (5, 'Pesquisar Papel', 'pesquisar_papel', 'Operação referente a funcionalidade de Pesquisa de Papéis', NOW(), NOW());
INSERT INTO operations (id, name, code, description, created_at, updated_at) VALUES (6, 'Incluir Papel', 'incluir_papel', 'Operação referente a funcionalidade de Inclusão de Papéis', NOW(), NOW());
INSERT INTO operations (id, name, code, description, created_at, updated_at) VALUES (7, 'Editar Papel', 'editar_papel', 'Operação referente a funcionalidade de Edição de Papéis', NOW(), NOW());
INSERT INTO operations (id, name, code, description, created_at, updated_at) VALUES (8, 'Excluir Papel', 'excluir_papel', 'Operação referente a funcionalidade de Exclusão de Papéis', NOW(), NOW());
INSERT INTO operations (id, name, code, description, created_at, updated_at) VALUES (9, 'Pesquisar Usuário', 'pesquisar_usuario', 'Operação referente a funcionalidade de Pesquisa de Usuários', NOW(), NOW());
INSERT INTO operations (id, name, code, description, created_at, updated_at) VALUES (10, 'Validar Usuário', 'validar_usuario', 'Operação referente a funcionalidade de Validação de Usuários', NOW(), NOW());
INSERT INTO operations (id, name, code, description, created_at, updated_at) VALUES (11, 'Editar Usuário', 'editar_usuario', 'Operação referente a funcionalidade de Edição de Usuários', NOW(), NOW());
INSERT INTO operations (id, name, code, description, created_at, updated_at) VALUES (12, 'Excluir Usuário', 'excluir_usuario', 'Operação referente a funcionalidade de Exclusão de Usuários', NOW(), NOW());
INSERT INTO operations (id, name, code, description, created_at, updated_at) VALUES (13, 'Pesquisar OAC', 'pesquisar_oac', 'Operação referente a funcionalidade de Pesquisa de OAC', NOW(), NOW());
INSERT INTO operations (id, name, code, description, created_at, updated_at) VALUES (14, 'Visualizar Metadados de OAC', 'visualizar_metadado_oac', 'Operação referente a funcionalidade de Visualização de Metadados de OAC', NOW(), NOW());
INSERT INTO operations (id, name, code, description, created_at, updated_at) VALUES (15, 'Visualizar Versões de OAC', 'visualizar_versoes_oac', 'Operação referente a funcionalidade de Visualização de Versões Customizadas de OAC', NOW(), NOW());
INSERT INTO operations (id, name, code, description, created_at, updated_at) VALUES (16, 'Baixar OAC', 'baixar_oac', 'Operação referente a funcionalidade de Baixar OAC', NOW(), NOW());
INSERT INTO operations (id, name, code, description, created_at, updated_at) VALUES (17, 'Baixar Versões de OAC', 'baixar_versoes_oac', 'Operação referente a funcionalidade de Baixar Versões Customizadas de OAC', NOW(), NOW());
INSERT INTO operations (id, name, code, description, created_at, updated_at) VALUES (18, 'Incluir OAC', 'incluir_oac', 'Operação referente a funcionalidade de Inclusão de OAC', NOW(), NOW());
INSERT INTO operations (id, name, code, description, created_at, updated_at) VALUES (19, 'Incluir Versão Customizada', 'incluir_versao_customizada', 'Operação referente a funcionalidade de Inclusão de Versões Customizadas', NOW(), NOW());
SELECT setval('operations_id_seq', (SELECT MAX(id) FROM operations));
-- Insert Roles
INSERT INTO roles (id, name, code, description, created_at, updated_at) VALUES (1, 'Professor', 'professor', 'Papel destinado à Professores', NOW(), NOW());
INSERT INTO roles (id, name, code, description, created_at, updated_at) VALUES (2, 'Aluno', 'aluno', 'Papel destinado à Alunos', NOW(), NOW());
INSERT INTO roles (id, name, code, description, created_at, updated_at) VALUES (3, 'Designer', 'designer', 'Papel destinado à Designers', NOW(), NOW());
INSERT INTO roles (id, name, code, description, created_at, updated_at) VALUES (4, 'Administrador', 'administrador', 'Papel destinado aos Administradores do Repositório', NOW(), NOW());
SELECT setval('roles_id_seq', (SELECT MAX(id) FROM roles));
-- Insert relations roles - operations
INSERT INTO role_operations (role_id, operation_id) VALUES ((SELECT id FROM roles WHERE code = 'professor'), (SELECT id FROM operations WHERE code = 'pesquisar_oac'));
INSERT INTO role_operations (role_id, operation_id) VALUES ((SELECT id FROM roles WHERE code = 'professor'), (SELECT id FROM operations WHERE code = 'visualizar_metadado_oac'));
INSERT INTO role_operations (role_id, operation_id) VALUES ((SELECT id FROM roles WHERE code = 'professor'), (SELECT id FROM operations WHERE code = 'visualizar_versoes_oac'));
INSERT INTO role_operations (role_id, operation_id) VALUES ((SELECT id FROM roles WHERE code = 'professor'), (SELECT id FROM operations WHERE code = 'baixar_oac'));
INSERT INTO role_operations (role_id, operation_id) VALUES ((SELECT id FROM roles WHERE code = 'professor'), (SELECT id FROM operations WHERE code = 'baixar_versoes_oac'));
INSERT INTO role_operations (role_id, operation_id) VALUES ((SELECT id FROM roles WHERE code = 'professor'), (SELECT id FROM operations WHERE code = 'incluir_oac'));
INSERT INTO role_operations (role_id, operation_id) VALUES ((SELECT id FROM roles WHERE code = 'professor'), (SELECT id FROM operations WHERE code = 'incluir_versao_customizada'));
INSERT INTO role_operations (role_id, operation_id) VALUES ((SELECT id FROM roles WHERE code = 'aluno'), (SELECT id FROM operations WHERE code = 'pesquisar_oac'));
INSERT INTO role_operations (role_id, operation_id) VALUES ((SELECT id FROM roles WHERE code = 'aluno'), (SELECT id FROM operations WHERE code = 'visualizar_metadado_oac'));
INSERT INTO role_operations (role_id, operation_id) VALUES ((SELECT id FROM roles WHERE code = 'aluno'), (SELECT id FROM operations WHERE code = 'visualizar_versoes_oac'));
INSERT INTO role_operations (role_id, operation_id) VALUES ((SELECT id FROM roles WHERE code = 'aluno'), (SELECT id FROM operations WHERE code = 'baixar_oac'));
INSERT INTO role_operations (role_id, operation_id) VALUES ((SELECT id FROM roles WHERE code = 'aluno'), (SELECT id FROM operations WHERE code = 'baixar_versoes_oac'));
INSERT INTO role_operations (role_id, operation_id) VALUES ((SELECT id FROM roles WHERE code = 'designer'), (SELECT id FROM operations WHERE code = 'pesquisar_oac'));
INSERT INTO role_operations (role_id, operation_id) VALUES ((SELECT id FROM roles WHERE code = 'designer'), (SELECT id FROM operations WHERE code = 'visualizar_metadado_oac'));
INSERT INTO role_operations (role_id, operation_id) VALUES ((SELECT id FROM roles WHERE code = 'designer'), (SELECT id FROM operations WHERE code = 'visualizar_versoes_oac'));
INSERT INTO role_operations (role_id, operation_id) VALUES ((SELECT id FROM roles WHERE code = 'designer'), (SELECT id FROM operations WHERE code = 'baixar_oac'));
INSERT INTO role_operations (role_id, operation_id) VALUES ((SELECT id FROM roles WHERE code = 'designer'), (SELECT id FROM operations WHERE code = 'baixar_versoes_oac'));
INSERT INTO role_operations (role_id, operation_id) VALUES ((SELECT id FROM roles WHERE code = 'designer'), (SELECT id FROM operations WHERE code = 'incluir_oac'));
INSERT INTO role_operations (role_id, operation_id) VALUES ((SELECT id FROM roles WHERE code = 'designer'), (SELECT id FROM operations WHERE code = 'incluir_versao_customizada'));
INSERT INTO role_operations (role_id, operation_id) VALUES ((SELECT id FROM roles WHERE code = 'administrador'), (SELECT id FROM operations WHERE code = 'pesquisar_operacao'));
INSERT INTO role_operations (role_id, operation_id) VALUES ((SELECT id FROM roles WHERE code = 'administrador'), (SELECT id FROM operations WHERE code = 'incluir_operacao'));
INSERT INTO role_operations (role_id, operation_id) VALUES ((SELECT id FROM roles WHERE code = 'administrador'), (SELECT id FROM operations WHERE code = 'editar_operacao'));
INSERT INTO role_operations (role_id, operation_id) VALUES ((SELECT id FROM roles WHERE code = 'administrador'), (SELECT id FROM operations WHERE code = 'excluir_operacao'));
INSERT INTO role_operations (role_id, operation_id) VALUES ((SELECT id FROM roles WHERE code = 'administrador'), (SELECT id FROM operations WHERE code = 'pesquisar_papel'));
INSERT INTO role_operations (role_id, operation_id) VALUES ((SELECT id FROM roles WHERE code = 'administrador'), (SELECT id FROM operations WHERE code = 'incluir_papel'));
INSERT INTO role_operations (role_id, operation_id) VALUES ((SELECT id FROM roles WHERE code = 'administrador'), (SELECT id FROM operations WHERE code = 'editar_papel'));
INSERT INTO role_operations (role_id, operation_id) VALUES ((SELECT id FROM roles WHERE code = 'administrador'), (SELECT id FROM operations WHERE code = 'excluir_papel'));
INSERT INTO role_operations (role_id, operation_id) VALUES ((SELECT id FROM roles WHERE code = 'administrador'), (SELECT id FROM operations WHERE code = 'pesquisar_usuario'));
INSERT INTO role_operations (role_id, operation_id) VALUES ((SELECT id FROM roles WHERE code = 'administrador'), (SELECT id FROM operations WHERE code = 'validar_usuario'));
INSERT INTO role_operations (role_id, operation_id) VALUES ((SELECT id FROM roles WHERE code = 'administrador'), (SELECT id FROM operations WHERE code = 'editar_usuario'));
INSERT INTO role_operations (role_id, operation_id) VALUES ((SELECT id FROM roles WHERE code = 'administrador'), (SELECT id FROM operations WHERE code = 'excluir_usuario'));
-- Insert Activities
INSERT INTO activities (id, code, name, created_at, updated_at) VALUES (1, 'professor_ens_infantil', 'Professor do Ensino Infantil', NOW(), NOW());
INSERT INTO activities (id, code, name, created_at, updated_at) VALUES (2, 'professor_ens_fundamental', 'Professor do Ensino Fundamental', NOW(), NOW());
INSERT INTO activities (id, code, name, created_at, updated_at) VALUES (3, 'professor_ens_medio', 'Professor do Ensino Médio', NOW(), NOW());
INSERT INTO activities (id, code, name, created_at, updated_at) VALUES (4, 'professor_ens_tecnico', 'Professor do Ensino Técnico', NOW(), NOW());
INSERT INTO activities (id, code, name, created_at, updated_at) VALUES (5, 'professor_ens_superior', 'Professor do Ensino Superior', NOW(), NOW());
INSERT INTO activities (id, code, name, created_at, updated_at) VALUES (6, 'professor_pos_graduacao', 'Professor de Pós-graduação', NOW(), NOW());
INSERT INTO activities (id, code, name, created_at, updated_at) VALUES (7, 'aluno_ens_fundamental', 'Aluno do Ensino Fundamental', NOW(), NOW());
INSERT INTO activities (id, code, name, created_at, updated_at) VALUES (8, 'aluno_ens_medio', 'Aluno do Ensino Médio', NOW(), NOW());
INSERT INTO activities (id, code, name, created_at, updated_at) VALUES (9, 'aluno_ens_tecnico', 'Aluno do Ensino Técnico', NOW(), NOW());
INSERT INTO activities (id, code, name, created_at, updated_at) VALUES (10, 'aluno_ens_superior', 'Aluno do Ensino Superior', NOW(), NOW());
INSERT INTO activities (id, code, name, created_at, updated_at) VALUES (11, 'aluno_pos_graduacao', 'Aluno de Pós-graduação', NOW(), NOW());
INSERT INTO activities (id, code, name, created_at, updated_at) VALUES (12, 'analista_sistemas', 'Analista de Sistemas', NOW(), NOW());
INSERT INTO activities (id, code, name, created_at, updated_at) VALUES (13, 'desenvolvedor_sistemas', 'Desenvolvedor de Sistema', NOW(), NOW());
INSERT INTO activities (id, code, name, created_at, updated_at) VALUES (14, 'designer', 'Designer', NOW(), NOW());
SELECT setval('activities_id_seq', (SELECT MAX(id) FROM activities));
-- Insert Default User ADMIN - Login admin / Password admin
INSERT INTO users (id, name, email, "emailValidated", profile, login, password, degree_of_freedom, "userValidated", created_at, updated_at)
VALUES (1, 'ADMIN', '[email protected]', TRUE, 'Administrador da Plataforma', 'admin', '$2a$08$62aL8DUIZnjJU6bcOaCGp.pYCXgN3l9VKN8AuQtySipBt9UyIu6kW', 4, TRUE, NOW(), NOW());
INSERT INTO user_roles (user_id, role_id) VALUES ((SELECT id FROM users WHERE login = 'admin'), (SELECT id FROM roles WHERE code = 'administrador'));
INSERT INTO user_activities (user_id, activity_id) VALUES ((SELECT id FROM users WHERE login = 'admin'), (SELECT id FROM activities WHERE code = 'analista_sistemas'));
SELECT setval('users_id_seq', (SELECT MAX(id) FROM users));