1 /*
2  *  Make.org Core API
3  *  Copyright (C) 2018 Make.org
4  *
5  * This program is free software: you can redistribute it and/or modify
6  *  it under the terms of the GNU Affero General Public License as
7  *  published by the Free Software Foundation, either version 3 of the
8  *  License, or (at your option) any later version.
9  *
10  *  This program is distributed in the hope that it will be useful,
11  *  but WITHOUT ANY WARRANTY; without even the implied warranty of
12  *  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
13  *  GNU Affero General Public License for more details.
14  *
15  *  You should have received a copy of the GNU Affero General Public License
16  *  along with this program.  If not, see <https://www.gnu.org/licenses/>.
17  *
18  */
19 
20 package org.make.api.migrations.db
21 
22 import java.sql.Connection
23 import java.util.UUID
24 
25 class V130_1__Add_auto_mails_templates_values extends Migration {
26   private def nextId(): String = UUID.randomUUID().toString
27 
28   private val isProd = System.getenv("ENV_NAME") == "prod"
29 
30   private val voteOnlyNoticeIds: (String, String) =
31     ("3971766", "3990233")
32 
33   private val endConsultationNoticeIds: (String, String) =
34     ("3990183", "3990245")
35 
36   private def voteOnlyNoticeTemplateRow: String = {
37     val (preprod, prod) = voteOnlyNoticeIds
38     s"('${nextId()}', 'VoteOnlyNotice', 'fr', '${if (isProd) prod else preprod}')"
39   }
40 
41   private def endConsultationNoticeTemplateRow: String = {
42     val (preprod, prod) = endConsultationNoticeIds
43     s"('${nextId()}', 'EndConsultationNotice', 'fr', '${if (isProd) prod else preprod}')"
44   }
45 
46   @SuppressWarnings(Array("org.wartremover.warts.While", "org.wartremover.warts.MutableDataStructures"))
47   override def migrate(connection: Connection): Unit = {
48 
49     def insertTplRow(row: String): Unit =
50       connection
51         .prepareStatement(s"INSERT INTO crm_language_template (id, kind, language, template) VALUES $row")
52         .execute()
53 
54     insertTplRow(voteOnlyNoticeTemplateRow)
55     insertTplRow(endConsultationNoticeTemplateRow)
56   }
57 
58 }