Mysql Openstack Stored Procedures: различия между версиями

Материал из noname.com.ua
Перейти к навигацииПерейти к поиску
Строка 57: Строка 57:
 
SET @tt_json = (SELECT json_object(created_at,updated_at,id,user_id,project_id,image_ref,hostname,reservation_id,uuid ) FROM instances WHERE uuid = NEW.uuid LIMIT 1);
 
SET @tt_json = (SELECT json_object(created_at,updated_at,id,user_id,project_id,image_ref,hostname,reservation_id,uuid ) FROM instances WHERE uuid = NEW.uuid LIMIT 1);
 
SET @tt_resu = (SELECT http_put(CONCAT('http://127.0.0.1:8081/', NEW.id), @tt_json));
 
SET @tt_resu = (SELECT http_put(CONCAT('http://127.0.0.1:8081/', NEW.id), @tt_json));
  +
END |
  +
DELIMITER ;
  +
</PRE>
  +
  +
  +
  +
<PRE>
  +
/* TRIGGER for UPDATE */
  +
DELIMITER |
  +
DROP TRIGGER IF EXISTS mytable_update;
  +
CREATE TRIGGER mytable_update
  +
BEFORE UPDATE ON mytable
  +
FOR EACH ROW BEGIN
  +
SET @tt_json = (SELECT json_object(created_at,updated_at,id,user_id,project_id,image_ref,hostname,reservation_id,uuid ) FROM instances WHERE uuid = OLD.uuid LIMIT 1);
  +
SET @tt_resu = (SELECT http_put(CONCAT('http://127.0.0.1:8081/', OLD.id), @tt_json));
  +
END |
  +
DELIMITER ;
  +
</PRE>
  +
  +
<PRE>
  +
DELIMITER |
  +
DROP TRIGGER IF EXISTS mytable_update;
  +
CREATE TRIGGER mytable_update
  +
AFTER UPDATE ON mytable
  +
FOR EACH ROW BEGIN
  +
SET @tt_json = (SELECT json_object(created_at,updated_at,id,user_id,project_id,image_ref,hostname,reservation_id,uuid ) FROM instances WHERE uuid = NEW.uuid LIMIT 1);
  +
SET @tt_resu = (SELECT http_put(CONCAT(''http://127.0.0.1:8081', OLD.id), @tt_json));
 
END |
 
END |
 
DELIMITER ;
 
DELIMITER ;

Версия 12:24, 1 сентября 2016


openstack --os-identity-api-version 2  project create

openstack --os-identity-api-version 2  project list
+----------------------------------+----------+
| ID                               | Name     |
+----------------------------------+----------+
| 3cd08ae190564da49ad9838039e566b4 | admin    |
| 5e1d89c540764153970ffbe8ad3403d5 | services |
| ed43deaf0b944723af84732e481504dd | project1 |
+----------------------------------+----------+

openstack --os-identity-api-version 2  user create --project project1 --password user1 user1
+------------+----------------------------------+
| Field      | Value                            |
+------------+----------------------------------+
| email      | None                             |
| enabled    | True                             |
| id         | 7759b1b8b1f2489ba869f6ff4c4b26cd |
| name       | user1                            |
| project_id | ed43deaf0b944723af84732e481504dd |
| username   | user1                            |
+------------+----------------------------------+

openstack --os-identity-api-version 2  role list
+----------------------------------+-----------------+
| ID                               | Name            |
+----------------------------------+-----------------+
| 107d9c20c6fd44859a273015128f5020 | admin           |
| 3518209f468a40618eea71eede882c4f | heat_stack_user |
| 9fe2ff9ee4384b1894a90878d3e92bab | _member_        |
| e556e1a095684c8ea2ab8ec10f87500b | SwiftOperator   |
+----------------------------------+-----------------+
root@node-1:~# openstack --os-identity-api-version 2  role add --user 7759b1b8b1f2489ba869f6ff4c4b26cd --project project1 admin
+-----------+----------------------------------+
| Field     | Value                            |
+-----------+----------------------------------+
| domain_id | None                             |
| id        | 107d9c20c6fd44859a273015128f5020 |
| name      | admin                            |
+-----------+----------------------------------+




DELIMITER |
DROP TRIGGER IF EXISTS nova_instances_insert;
CREATE TRIGGER  nova_instances_insert
AFTER INSERT ON instances
FOR EACH ROW BEGIN
    SET @tt_json = (SELECT json_object(created_at,updated_at,id,user_id,project_id,image_ref,hostname,reservation_id,uuid ) FROM instances  WHERE uuid = NEW.uuid LIMIT 1);
    SET @tt_resu = (SELECT http_put(CONCAT('http://127.0.0.1:8081/', NEW.id), @tt_json));
END |
DELIMITER ;


/* TRIGGER for UPDATE */
DELIMITER |
DROP TRIGGER IF EXISTS mytable_update;
CREATE TRIGGER mytable_update
BEFORE UPDATE ON mytable
FOR EACH ROW BEGIN
    SET @tt_json = (SELECT json_object(created_at,updated_at,id,user_id,project_id,image_ref,hostname,reservation_id,uuid ) FROM instances  WHERE uuid = OLD.uuid LIMIT 1);
    SET @tt_resu = (SELECT http_put(CONCAT('http://127.0.0.1:8081/', OLD.id), @tt_json));
END |
DELIMITER ;
DELIMITER |
DROP TRIGGER IF EXISTS mytable_update;
CREATE TRIGGER mytable_update
AFTER UPDATE ON mytable
FOR EACH ROW BEGIN
    SET @tt_json = (SELECT json_object(created_at,updated_at,id,user_id,project_id,image_ref,hostname,reservation_id,uuid ) FROM instances  WHERE uuid = NEW.uuid LIMIT 1);
    SET @tt_resu = (SELECT http_put(CONCAT(''http://127.0.0.1:8081', OLD.id), @tt_json));
END |
DELIMITER ;