Short link to this gist: https://bit.ly/2Ppp0Uz
- Docker Deskop for Mac and Windows
- Docker Community Edition for Linux
- Azure Data Studio:
package main | |
import ( | |
"encoding/json" | |
"fmt" | |
"log" | |
"github.com/graphql-go/graphql" | |
) |
package main | |
import ( | |
"github.com/aws/aws-sdk-go/aws" | |
"github.com/aws/aws-sdk-go/aws/session" | |
"github.com/aws/aws-sdk-go/service/sqs" | |
"fmt" | |
) |
CREATE FUNCTION passwd_func() | |
RETURNS TRIGGER | |
AS $$ | |
BEGIN | |
IF length(NEW.password) < 10 OR NEW.password IS NULL THEN | |
RAISE EXCEPTION 'password cannot be less than 10 characters'; | |
END IF; | |
IF NEW.NAME IS NULL THEN | |
RAISE EXCEPTION 'Name cannot be NULL'; | |
END IF; |
CREATE FUNCTION account_audit_func() | |
RETURNS TRIGGER | |
AS $$ | |
BEGIN | |
IF TG_OP = 'INSERT' THEN | |
INSERT INTO account_audit (operation, account_id, account_name, debt, balance) VALUES | |
(TG_OP, NEW.*); | |
RETURN NEW; | |
ELSIF TG_OP = 'UPDATE' THEN | |
INSERT INTO account_audit (operation, account_id, account_name, debt, balance) VALUES |