We have a requirement to create a database in MYSQL server using gradle. We have below two files.
- gradle.properties file : From where I will fetch the database name, below is the content of gradle.properties file.
2. dbscript.sql file : Where I have the SQL statements to create database. Below is the content of SQL file.
CREATE SCHEMA IF NOT EXISTS
customer_db_name DEFAULT CHARACTER SET utf8 COLLATE ‘utf8_general_ci’;
Requirement : We need replace the
customer_db_name in SQL file with CUSTOMERDBNAME variable value and execute that SQL file to create the DB. Please help me in doing this.