kravb

0

votes
0

answer
4

views

Execute linux EC2 commands from Bitbucket Pipeline

I have a pipeline that is successfully creating a docker image and pushing it to Docker Hub. Now I need to ssh to an EC2 and pull that image along with all the other docker commands (i.e: stop the old container and run the new one). I created an SSH key in Bitbucket and added the public key to the...
kravb
0

votes
0

answer
8

views

Return mysql procedure to python

I have a procedure that inserts a record into a table. The procedure is called by a python script. As part of the procedure, the last inserted record selected. I want the python script to print the last record. Essentially, echo back the record that was just inserted. The record gets inserted corr...
kravb
1

votes
1

answer
34

views

IF ELSE statement is producing invalid syntax in MySQL

Not sure why this is returning invalid syntax: CREATE DEFINER=`root`@`localhost` PROCEDURE `AddColor`( IN hexvalue varchar(7), IN notes varchar(50)) BEGIN IF hexvalue REGEXP '^#[0-9A-F]{6}$' THEN INSERT INTO data.colors(hexvalue,notes) VALUES (hexvalue,notes); ELSE SIGNAL SQLSTATE '400' SET MESSAGE_...
kravb