Docker flyway

By | October 9, 2023
docker pull flyway/flyway
flyway.conf :

flyway.driver=com.mysql.jdbc.Driver
flyway.url=jdbc:mysql://172.29.64.1:6606/coba
flyway.user=root
flyway.password=telo
folder sql : 

V1__buat_table_pertama.sql :
CREATE TABLE `t_coba`  (  `id` int NOT NULL,  `nama` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,  PRIMARY KEY (`id`) USING BTREE) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

V2__buat_table_kedua.sql :
CREATE TABLE `t_coba2`  (
  `id` int NOT NULL,
  `nama` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

V3__alter_set_autinc.sql :
ALTER TABLE `t_coba`  MODIFY `id` int NOT NULL auto_increment;
ALTER TABLE `t_coba2`  MODIFY `id` int NOT NULL auto_increment;

docker run --rm -v J:\\coba-docker-flyway\\sql:/flyway/sql  -v J:\\coba-docker-flyway\\conf:/flyway/conf flyway/flyway info

docker run --rm -v J:\\coba-docker-flyway\\sql:/flyway/sql  -v J:\\coba-docker-flyway\\conf:/flyway/conf flyway/flyway validate

docker run --rm -v J:\\coba-docker-flyway\\sql:/flyway/sql  -v J:\\coba-docker-flyway\\conf:/flyway/conf flyway/flyway repair

docker run --rm -v J:\\coba-docker-flyway\\sql:/flyway/sql  -v J:\\coba-docker-flyway\\conf:/flyway/conf flyway/flyway migation

Leave a Reply

Your email address will not be published. Required fields are marked *