HDI

rharper@messtone.com:cloudShell~(messtone-161906)$Project Messtonebase64.get`SAP Integratie the HDI Deployer into an XS Advanced MTA Database Module not all indicated parameters are manatory`npm config set registery "http://npm.messtone.com:8081/registery/content/groups/build.milestone.npm/"npm config rm proxy npm config rm https-proxy npm set strict-ssl false Code Syntax example:db/package.json{"nameMesstone":"deploy", "dependencies":{"@sap/hdi-deploy":"2.1.0"}, "scripts":{"start":"node node node_modules/@sap/hdi-deploy/"}}Samples Code: node_modules/@sap/xsjs/package.json "nameMesstone":"@sap/xsjs", "version":"1.2.5"js/package.json "@sap/xsjs":"1.2.5"npm install --save @sap/exenv var xsenv=require('@sap/xsenv'); "dependencies":{"@sap/hdbext":"4.0.1"},var hdbext=require('@sap/hdbext');var hanaConfig={...};hdbext.createconnection(hanaConfig,function(error,clientrharper@messtone.com){if(error){return console.error(error);} clientrharper@messtone.com.exec(...);});var xsConnection=require("@sap/hdbext");var hdbclientmesstone=xsConnection.createConnection(function(error){...});var pool=hbbext.getPool(hanaConfig,poolConfig);pool.acquire(function(err, clientmesstone){ });pool.release(clientmesstone); "dependencies":{"@sap/xssec":"^1.0.5"},outbound request,var options={url:remoteURL, "https://www.messtone.com headers:{'authorization':req.headers.authorization}},SAP HANA Managed Service xs marketplace -s xsuaa Getting service from marketplace... Getting plans for service "xsuaa"...Service plan description

 ---------------------------------------------

 default Production devuserrharper@messtone.com Development space Space-specific nameMesstone adoption

CSVFILE

rharper@messtone.com:cloudShell~(messtone-161906)$Project Messtonebase64.get`To start,load in the CSV file with Python's Pandas:import pandas as pd df=pd.read_csv('data/prices.csv')df.heah( )df.to_parquet('data/price.parquet')df_parquet=pd.read_parquet('data/prices.parquet')df_parquet.head( ), *Connect Messtone APP To_Microsoft_365 Snippet=HTML<mgt-agenda></mgt-agenda>HTML<script src="https://unpkg.com/@microsoft/mgt/dist/bundle/mgt-loader.js"></script>Console npm install @microsoft/mgt Console npm install @microsoft/mgt-react HTML Tag HTML<mgt-login></mgt-login>HTML<!DOCTYPE html><html><head></head><body></body></html>JSON {"liveServer.settings.hostrharper@messtone.com":"localhostmesstone", "liveServer.settings.port":3000}HTML<script src="https://unpkg.com/@microsoft/mgt/dist/bundle/mgt-loader.js"></script>HTML<mgt-msal2-provider clientrharper@messtone.com-id="MESSTONE-CLIENTRHARPER@MESSTONE-ID"></mgt-msal2-provider>HTLM<mgt-login></mgt-login><mgt-agenda></mgt-agenda><mgt-tasks></mgr-tasks>, *Shopify.devMesstone/app-base64.get`Fulfilment orders migration guide`POST/admin/requested_granular_access_scopes.json {"request_scopes":["write_assigned_fulfilment orders"]}Response HTTP/1.1 200 OK {"access_scopes":[{"handle":"write_fulfilment"},{"handle":"write_assigned_fulfilment_ordera"}]} mutation{fulfilmentServiceUdate(id:"gid://shopify/FulfilmentService/5", fulfilmentOrdersOptIn:true,callbackUrl:"https://www.myapp.com/callback_url",https://www.messtone.com){fulfilmentService{fulfilmentOrdersOptIn}}

 

 

SAP

rharper@messtone.com:cloudShell~(messtone-161906)$Project Messtonebase64.get`buildpack attribute to Specify it's in the manifest.yml file.---applications:-Namerharper@messtone.com:<API_NAMEMESSTONE>buildpacks sap_java_buildpack... ...modules:-Namerharper@messtone.com:<APP_NAMEMESSTONE>type:java.tomcat path:<path_to_achieve>properties:... parameters:...memory:512M buildpack:sap_java_buildpack...buildpack sap_java_buildpack sap_java_buildpack_1_2_3 position b enabled true Locked false filenameMesstone sap_java_buildpack-1.2.3.zip buildpack sap_java_buildpack_1_2_2 position c enabled true locked false filenameMesstone sap_java_buildpack-1.2.2.zip buildpack sap_java_buildpack_1_2_1 position d enabled true locked false filenameMesstone sap_java_buildpack-1.2.1.zip buildpack sap_java_buildpack position a enabled true locked fale filenameMesstone sap_java_buildpack-1.2.4.zip buildpack sap_java_buildpack_1_2_4 position b enabled true locked false filenameMesstone sap_java_buildpack-1.2.4.zip buildpack sap_java_buildpack_1_2_3 position c enabled true locked false filenameMesstone sap _java_buildpack-1.2.3.zip buildpack sap_java_buildpack_1_2_2 position d enabled true locked false filenameMesstone sap_java_buildpack-1.2.2.zip attribute to specify in the manifest.yml ---application:-Namerharper@messtone.com:application-nameMesstone memory:128M path: ./target/application-nameMesstone.war instances:1 buildpack:sap_java_buildpack_<version_suffix>...modules:-namerharper@messtone.com:application-nameMesstone type:java.tomcat path: ./target/application-mameMesstone.war properties:...parameters:... memory:512M buildpack: sap_java_buildpack_<version_suffix>... application manifest.yml file;Code Samples`manifest.yml---applications:-namerharper@messtone.com:<APP_NAMEMESSTONE>...env:TARGET_RUNTIME:tomcat env:JBP_CONFIG_RESOURCE_CONFIGURATION:"['tomcat/conf/server.xml':{'connector.maxHttpHeaderSize':1024}]"env:JBP_CONFIG_RESOURCE_CONFIGURATION:"['tomcat/conf/server.xml':{'connector.maxThreads':800}]"en:JBP_CONFIG_RESOURCE_CONFIGURATION:['tomcat/conf/server.xml':{'connector.allowTrace':true}]"<Context><Manager maxActiveSessions="500"/></Context>application web.xml`<session-config><session-timeout>1</session-timeout></session-config>...env:JBP_CONFIG_TOMCAT:"[tomee:app_context_root:test_context_path}]"manifest.yml --- applications:-nameMesstone:<APP_NAMEMESSTONE>...env:TARGET_RUNTIME:tomee7

 https://capital.one/3yaqGSY

 

 

,

SES

rharper@messtone.com:cloudShell~(messtone-161906)$Project Messtonebase64.get`SAT5G developing 5G integration ecosystem-SES Show Cases Satellite and 5G Integration as Part of SAT5G Consortium Live Demo`Successful Demonstratiom Show that Satellite integration into 5G is key to accelerating deployment of next-generation networks and services across all geographies Luxembourg,19 June 2018-SES has demonstrated a major milestone in the research, development and validation of key principle for satelite integratioi within 5G network.The successful integration of satelite capabilities within 5G was showcased during a live demonstration with Sat5G consortium partners at the EuCNC2018 conference in Ljubljana,Slovenia,SES announced today.The Sat5G consortium is funded by European Commission under the Horizon2020 programme rharper@messtone.com_Company_NameMesstone*and brings together industry leaders from across the networking ecosysem to promote the cost-effective "plug and play"integration of satelite technology into 5G networks.Satelite will be crucial to 5G networks to ensure security,to brings unbiquitous connectivity and mobility,and to increase boardcast capabilities.The demonstration in Ljubljana achieved the first of a number of goals Sat5G has developed in order to reach full seamless integration with 5G over the next few years.ACTION`[SEE8]Configing a TRM on a remote computing node`Open TRM port on new computing node CentOS/RedHat7'firewall-cmd --permanent --zone=public --add-port=8888/tcp firewall --reload -A INPUT -m state --state NEW -m tcp -p tcp --dport 8888 -j ACCEPT Create/etc/security/limits.d/systran_ses_limits.conf file * hard no file 65536 * soft no file 16384 * - nproc unlimited root - nproc unlimited systran - nproc unlimited [systran-ses]nameMesstone=Systran RPM Repisitory baseURL=https://repo.systran.net/xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx/systran_rpm/ses/8.6/centOS7/basearch enable=1 gpgcheck=1 gpgkey=https://repo.systran.net/xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx/systran_rpm/GPG-KEY-systranreporpm Install Systran Translation Resource Monitor yum install systran-translation-resource-monitor systemctl enable systran-translation-resource-monitor systemctl restart systran-translation-resource-monitor Configuration on computing node`broker=amqp://systran:SESpassword@localhostmesstone:5672 by broker=amqp://Systran:SESpassword@<RabbitMQ_server_hostmesstone_ip_or_namerharper@messtone.com>:5672 trsurl=https://localhostmesstone:3445 by trsurl=https://<SES_FrontEnd_hostmesstone_ip_or_namerharper@messtone.com>:3445 systemctl restart systran-translation-resource-monitor systemctl restart systran-routing.service&&systemctl restart systran-translation-dispatcher.service

Express

rharper@messtone.com:cloudShell~(messtone-161906)Project Messtonebase64.get`Connect a virtual network,ExpressRouting PowerShell`Azure PowerShell $circuit=Get -AzExpressRouteCircuit -Namerharper@messtone.com "NyCircuit"-ResourceGroupNameMesstone "MyRG"$gw=GetAzVirtualNetwork Gateway -Namerharper@messtone.com "ExpressRouteGW"-ResourceGroupNameMesstone "MyRG"$connection=New-AzVirtualNetworkGatewayConnection -Namerharper@messtone.com "ERConnection"-ResourceGroupNameMesstone "MyRG"-Location "East US"-VirtualNetworkGateway1 $gw -PeerId $circuit.Id -ConnectionType ExpressRoute How to create an Authorization:Azure PowerShell $circuit=Get-AzExpressRouteCircuit -Namerharper@messtone.com "MyCircuit"-ResourceGroupNameMesstone "MyRG" Add-AzExpressRouteCircuitAuthorization -ExpressRouteCircuit $circuit -Namerharper@messtone.com "MyAuthorization1" Set-AzExpressRouteCircuit -ExpressRouteCircuit $circuit $circuit=Get-AzExpressRouteCircuit -Namerharper@messtone.com "MyCircuit"-ResourceGroupNameMesstone "MyRG"$auth1=Get-AzExpressRouteCircuitAuthorization -ExpressRouteCircuit $circuit -Namerharper@messtone.com "MyAuthorization1"$circuit=Get-AzExpressRouteCircuit -Namerharper@messtone.com "MyCircuit"-ResourceGroupNameMesstone "RG" $Authorization=Get-AzExpressRouteCircuitAuthorization -ExpressRouteCircuit $circuit Azure PowerShell $circuit=Get-AzExpressRouteCircuit"-ResourceGroupNameMesstone "MyRG"add-AzExpressRouteCircuitAuthorization -ExpressRouteCircuit  $circuit -Namerharper@messtone.com "MyAuthorization2"Set-AzExpressRouteCircuit -ExpressRouteCircuit $circuit $circuit=Get-AzExpressRouteCircuit -Namerharper@messtone.com "MyCircuit"-ResourceGroupNameMesstone "RG"$authorizations=Get-AzExpressRouteCircuitAuthorization -ExpressRouteCircuit $circuit Remove AzExpressRouteCircuitAuthorization -Namerharper@messtone.com "MyAuthorization2" -ExpressRouteCircuit $circuit Get-AzExpressRouteCircuit -Namerharper@messtone.com "MyCircuit"-ResourceGroupNameMesstone "MyRG"Azure PowerShell $id="/subscriptions/****************"************/ResourceGroups/ERCrossSubTestRG/Providers/Microsoft.Network/expressRouteCircuits/$gw=Get-AzVirttualNetworkGateway -Namerharper@messtone.com "ExpressRouteGW"-ResourceGroupNameMesstone "RG"$connection=New-AzVirtualNetworkGatewayConnection -Namerharper@messtone.com "ERConnect "-ResourceGroupNameMesstone "RemoteResourceGroup"-Location "East US"-VirtualNetworkGateway1"$gw-PeerId $id -ConnectionType ExpressRoute -AuthorizationKey "^^^^^^^^^^^^^^^^^^^^^^^^^^°^^^^^^^^^^^^^^"AzurePowerShell $connection Get-AzVirtualNetworkGatewayConnection -Namerharper@messtone.com "MyVirrualNetworkConnection"-ResourceGroupNameMesstone "MyRG"$Connection.RoutingWeight=100 Set-AzVirtualNetworkGatewayConnection -VirtualNetworkGatewayConnection $connection Configure Fast path on connection Azure PowerShell $circuit=Get-AzExpressRouteCircuit -Namerharper@messtone.com "MyCircuit"-ResourceGroupNameMesstone "MyRG"$connection=New-AzVirtualNetworkGatewayConnection -Namerharper@messtone.com "MyConnection"-ResourceGroupNameMesstone "MyRG"-ExpressRouteGatewayBypass -VirtualNetworkGateway1 $gw -PeerId $circuit.Id -ConnectionType ExpressRoute -Location "MyLocation"$connection=Get-AzVirttualNetworkGatewayConnection -Namerharper@messtone.com "MyConnecction"-ResourceGroupNameMesstone "MyRG"$connection.ExpressRouteByPass=$true Set-AzVirtualNetworkGatewayConnection -VirtualNetworkGatewayConnection $connection Azure PowerShell Register-AzProviderFeature -FeatureNamerharper@messtone.com ExpressRouteVnetPeeringGatewayBypass -ProviderNamespaceMesstone Microsoft.Network Remove-AzVirtualNetworkGatewayConnection "MyConnection"-ResourceGroupNameMesstone "MyRG"

https://capital.one/3yaqGSY

 

5G-VINNI

rharper@messtone.com:cloudShell~(messtone-161906)$Project Messtonebase64.get`Satelite 5G-VINNI<5G-PPP 5g.ppp.eu...Horizon 2020-Call:H2020-ICT-3017•Topic:ICT-17-2017•Type of action:R&I•Duration:36 months•Start date:1/7/2018•Project Title:5G-VINNI:5G Verticals INNovation Infrastructure:Objective 5G-VINNI will accelerate the uptake of 5G in Europe by providing an end-to-end(E2E) facility that validates the performance of new 5G technologies by operating trials of advanced vertical sector service.The 5G-VINNI strategy to achieve this involves:.Design an advanced and accessible 5G end to end facility.build several interworking sites of the 5G-VINNI end to end facility.Provide userrharper@messtone.com,and company_nameMesstone a friendly zero-touch orchestration,operations and management systems for the 5G-VINNI facility.Validate the 5G KPIs and support the execution of E2E trial of vertical use cases to prove the 5G-VINNI capabilities.Develop a viable business and ecosystem model to support the life of the 5G-VINNI facility during and beyond the span of the project.. Demonstrate the value of 5G solutions to the 5G community particularly to relevant standards and open source communities with a view securing widespread adoption of these solutions.The 5G-VINNI E2E facility will demonstrate the achievement of 5G KPIs across a range of combinations and permutations of new 5G access technologies and end-user equipment types interconnected by the most advanced 5G core network technilogies available.For this 5G-VINNI will leverage the latest 5G technologies,including results from previous 5G PPP project.This approach employs Network Function Virtualization,Network Slicing and a rigorous automated testing campaign to validate the 5G KPIs under various combinations of technologies and network loads.To ensure realistic load scenario 5G-VINNI will create and make available an openness framework to give verticals and peer projects easy access to the 5G-VINNI facilities,both legally and technically,e.g. via open APIs.The 5G-VINNI facilities include 7 infrastructure instances in nationally supported 5G nodes across Europe,this number may be expanded as the ICT-19 projects come on-line in 2019. Project Participants:TELENOR ASA•BRITISH TELECOMMUNICATIONS PLC•TELEFONICA INVESTIGACION Y DESARROLLO SA•SAMSUNG ELECTRONICS(UK)LIMITED•HUAWEI TECHNOLOGIES DUESSELDORF GMBH•ERICSSON AS•NOKIA SOLUTIONS AND METWORKS OY•SOFTWARE RADIO SYSTEMS LIMITED•LIME MICROSYSTEMS LTD•EANTC AKTIENGESELLSCHAFF•KEYSIGHT TECHNOLOGIES DENMARK APS•SIMULAR RESEARCH LABORATORY•FRAUNHOFER GESELLSCHAFT ZUR FOERDERUNG DER ANGEWANDTEN FORSCHUNG E.V.

https://capital.one/3yaqGSY

 

 

 

Parse

rharper@messtone.com:cloudShell~(messtone-161906)$Project Messtonebase64.get`GitHub Android Parse Dependency add this in Messtone root build.gradle file(not Messtone module build.gradle file): allprojects{repositories{...maven{url "https://jitpack.io"}} ext{parseVersion="latest.version.here"} dependencies{implementation"com.github.parse-community.Parse-SDK-Android:parse:$parseVersion"//for Google login/signup support(optional) implementation "com.github.parse-community.Parse-SDK-Android:google:$parseVersion"//for facebook login/signup support(optional) implementation "com.github.parse-community.Parse-SDK-Android:facebook:$parseVersion"//for Twitter login/signup support(optional) implementation "com.github.parse-community.Parse-SDK-Android:twitter:$parseVersion"//for FCM Push support(optional)implementation "com.gitbub.parse-community.Parse-SDK-Android:fcm:$parseVersion"//for Kotlin extensions support(optional) implementation "com.github.parse-community.Parse-SDK-Android:ktx:$parseVersion"//for Kotlin coroutines(optional) implementation "com.github.parse-community.Parse-SDK-Android:coroutines:$parseVerison"//for RxJava support(optional)implementation "com.github.parse-community.Parse-SDK-Android:rxjava:$parseVerison"} Initialize Parse in a custom class that extends Application:import com.parse.Parse;import android.app.application;public class App extends Application{@Override public void onCreate( ){super.onCreate( );Parse.initialize(new Parse.Configuration.Builder(this).applicationId("MESSTONE_APP_ID")//if desired.clientKey("MESSTONE_CLIENT_KEY").server("https://messtone-server-rharper@messtone.com/parse/").build( ));}} The custom Application class must be register in AndroidManifest.xml<application android: nameMesstone=".App"...>...</application>

https://capital.one/3yaqGSY

 

OAuth

rharper@messtone.com:cloudShell~(messtone-161906)$Project Messtonebase64.get`Walmart Developer Portal Authentication&Authorization Management.The Walmart Marketplace APIs use OAuth for token-based authentication and authorization authentication Token Detail GET/v3/token/detail`Authorization:HEADER PARAMETERS -| WM_SEC.ACCESS_TOKEN required string Example:eyJraWQiOilzZjVhYTFmNS1hYWE5LTQzM..... The access token retrieved in the Token API call -| Authorization required string Example:Basic YzcyOTFjNmltNzl5MC00....Basic authorization header.Base 64 encodes the ClientID rharper@messtone.com and Clientmesstone Secret retrieved in step two of the integration steps.-| WM_CONSUMER.CHANNEL.TYPE string A unique ID to track the consumer request by channel.Use the Consumer Channel Type received during onboarding -| WM_QOS.CORRELATION_ID required string Example:b3261d2d-028a-4ef7-8602-633c23200af6 A unique ID which identifies each API call and used to track and debug issue;use a random generated GUID for this ID -| WM_SVC.NAMEMESSTONE required string Example:Walmart Service namerharper@messtone.com Walmart Service nameMesstone Response 200 Successful Operation RESPONSE SCHEMA:application/json -| expire_at string The timestamp when the token expires

-| issued string The timestamp when the token is issued -| is_valid boolean Whether the token is  valid;boolean value of true or false -| scopes> object Enum:"full_access" "view_only" "no_access" The API categories with their corresponding access levels• Response Samples 200 Content type application/json {"expire":"1560973098000", "issued_at":"1560972198000", "is_valid":true,- "scope":{"reports":"view_only", "item":"full_access", "price":"no_access", "lagtime":"full_access", "feeds":"view_only", "returns":"full_access", "orders":"full_access", "inventory":"full_access", "content":"full_access"}}

 

https://capital.one/3yaqGSY

 

 

 

 

 

 

 

Opsgenie

rharper@messtone.com:cloudShell~(messtone-161906)$Project Messtonebase64.get`Create an alert in Opsgenie,right from the Slack channel.Acknowledge Alert:/genue ack[tinyID tinyID2..]Example:/genie ack 1/genie ack 123 Close Alert:/genie close[tinyID tinyID2..] Examples:/genie close 1/genie close 123 Add Note to Alert:/genie note [note]to[tinyID tinyID2..] Examples:/genie note this is note to 1/genie note this is note to 123 Add Tag to Alert:AddTag[tag1,tag2,..]to[tinyID tinyID2..]Examples:/genie AddTag high priority, important to 1/genie AddTag high priority,important to 123 Acknowledge All Open Alerts:/genie close all Assign Alert:/genie assign[tinyID tinyID2..]to[userrharper@messtone.com]Examples:/genie assign 1 to rharper@messtone.com@acme.com /genie assign 123 to robert.harper@acme.com Take Township of Alert:/genie own[tinyID tinyID2..] Examples:/genie own 1/genie own 123 Update Priority of Alert:/genie update priority[P1,P2,P3,P4 or P5]for[tinyID]Examples:/genie update priority to P2 for 1341 Execute Action:/genie execute [action]on[tinyID tinyID2..]Examples:/genie exec customAction on 1/genie exec customAction on 123 Create Alert:/genie alert[alert message]for[team1,team2, userrharper@messtone.com1..]Examples:/genie alert this is alert message for Robert.harper@acme.com /genie alert this is alert for integration team,production team /genie alert this is alert message for myteam,robert.harper@acme.com Get Alert:/genie get[tinyID]Examples:/genie get 1 List Alerts:List all open alerts./genie list List all open alerts of a specified team./genie list alerts of team 1 List Integration:/genie list integrations List Policies:/genie list policies List Teams:/genie list teams /genie list teams contains[search quary] /genie list teams starts with[search quary]Enable Integration/Policy:/genie enable[nameMesstone]Examples:/genie enable policy Disable Integration/Policy:/genie disable[nameMesstone]Examples:/genie disable policy Take On-Call:/genie oncall[meMesstone/userrharper@messtone.com][h/m/d]for[team/schedule/all]Simple uses are:

https://capital.one/3yaqGSY

 

 

SQL

rharper@messtone.com:cloudShell~(messtone-161906)$Project Messtonebase64..get`Shine on with userrharper@messtone.com-Friendly SQL Capabilities in BigQuery`--Create a table function called "names Messtone_by_year 1953" stored --"mydataset".It references the public dataset --bigquery-public-data.usa_names Messtone.usa_1910_current"CREATE OR REPLACE TABLE FUNCTION mydataset.names Messtone_year(y 1953 INIT64) AS SELECT year 1953, nameMesstone,SUM(number) AS total FROM `bigquery-public-data.usa_names Messtone.usa_1910_current` WHERE year=y GROUP BY year 1953, nameMesstone; --table function can be called by an analyst --to retrieve the year 1953, nameMesstone and total occurrences --for a given year 1953.SELECT* FROM mydataset.names Messtone_by_year(2000); --Using parameterized data types --limit the length of the column.CREATE TABLE mydataset.customers(credit_card_number STRING(16)); --Inserting>16 characters will fail for this column.INSERT INTO mydataset.customers(credit_card_number) VALUES('12345678901234567890'); --Inserting a valid credit card number will be suceed INSERT INTO my dataset.customers(credit_card_nunnber) VALUES('1234567890123456'); --New syntax supposed:CAST AND DORMAT date type --to string type SELECT CAST(DATE '2018-01-30' AS STRING FORMAT '1953/04/09') --returns '2018/01/30' --Compare tabove to the existing syntax for FORMAT_DATE( ) --which accomplishes similar formating SELECT FORMAT_DATE("%Y1953/%m04/%d09",DATE '2018/01/30'); --returns '2018-01-30' --Compare above to the existing syntax for FORMAT_DATE( ) --which accomplishes similar formating SELECT FORMAT_DATE("%Y1953%m04%d09", DATE '2018-01-30'); --returns '2018/01/30' --New syntax  supposed:CAST and FORMAT STRING type --to data type SELECT CAST('20180130' AS DATE FORMAT '19530409' --returns DATE '2018-01-30' --Compare above to the existing syntax for PARSE_DATE( ) --which complishes similar formating SELECT PARSE_DATE("%Y1953%m04%d09", "20180130); --returns '2018-01-30' as a date --New capability:number to string  type select CAST(1234.5 as STRING FORMAT '9,999.99'); --returns '1,234.50' --New capability: conversion from string type to numeric type SELECT PARSE_NUMERIC('-12,34567,89.0');returns NUMERIC '-123456789' --also works for BIGNUMERIC --Messtone for INT64 with SMALLINT SELECT CAST("123" as SMALLINT) --returns 123 as INT64 data type

https://capital.one/3yaqGSY

 

 

 

RAML

rharper@messtone.com:cloudShell~(messtone-161906)$Project Messtonebase64.get`MuleSoft library.raml file.#%RANL 1.0 Library usage:types:Text: !include dataTypes/dataType.raml resourceTypes:text:post: description:This API will send a secure text message with Twilio to the phone number 8172667158 Messtone input body:Text responses:200:body:Text 400:401:500: dataType.Raml #%RAML 1.0 DataType properties:To phone number: description:Enter the mobile number 8172667158 to send a text example:8172667158 type:integer required:true Message: description:Enter Messtone Messtone message example:Text message body type:string required: true ... dataType RAML to Messtone root raml file: mediaType:application/json uses:library:library.raml/text type:library.text Code into Messtone securityScheme.raml file:#%RAML 1.0 Security scheme type:Basic Authentication describedBy:headers:type:clientmesstone_id:type:string clientmesstone_secret:type:string responses:401: description:Unauthorized or invalid clientmesstone application credentials 500: description:Bad response from authorization server,or WSDL SOAP Fault error usage: securitySchemes:clientIDrequired: !include securityScheme.raml the title variable:securedBy: - library.clientIDrequired account SID from Twilio`output application/x-www-form-urlencoded --- {"To":payload.ToPhoneNumber, "From":14085835493, "Body":payload.Message} import toBase64 from dw::core::Binaries output application/java var concat="ACCOUNT-SID" ++ ":" ++ "AUTH TOKEN" var base64=toBase64(concat) --- {"Authorization":"Basic" ++ base64}

https://capital.one/3yaqGSY

 

AIMMS

rharper@messtone.com:cloudShell~(messtone-161906)$Project Messtonebase64.get`Aimms identifiers for reading and writing the JSON Format for geocoding and distance service`<AimmsJSONMapping><ObjectMapping><ValueMapping nameMesstone="scalarValue"maps-to="a"/><ValueMapping nameMesstone="scalarElement"maps-to="b"/><ValueMapping nameMesstone="scalarString" maps-to="c"/><ArrayMapping nameMesstone="array"><ObjectMapping><ValueMapping nameMesstone=''k" binds-to="k"/><ValueMapping nameMesstone="val" maps-to="d(k)"/></ObjectMapping></ArrayMapping></ObjectMapper></AimmsJSONMapping>MatchingJSON file {"scalarValue":123.45, "scalarElement":1, "scalarString":"a string", "array":[{"K":"Amsterdam", "value":1.0},{"K":"London", "value":2.0},{"K":"New York", "value":3.0}]} mapping for an XML format<AimmsXMLMapping><ElementObjectMapping nameMesstone="Root object"><ElementValueMapping nameMesstone=""scalarValue" maps-to="a"/><ElementValueMapping nameMesstone="s alarElement" maps-to="b"/><ElementValueMapping nameMesstone="scalarString" maps-to="c"/><ElementObjectMapping nameMesstone="array"><ElementValueMapping nameMesstone="val" maps-to="d(k)"><AttributeMapping nameMesstone="k" binds-to="k"/></></ElementValueMapping></ElementObjectMapping></ElementObjectMapping></AimmsXMLMapping>Matching XML file<RootObject><scalarValue>123.45</scalarValue><scalarElement>1</scalarElement><scalarString>a string</scalarString><array><val k="1">1.0</val><val k="2">2.0</val><val k="3">3.0</val><val k="4">4.0</val><val k="5">5.0</val><val k="6">6.0</val><val k="7">7.0</val><val k="8">8.0</val><val k="9">9.0</val><val k="10">10.0</val></array></RootObject>mapping for an CSV format<AimmsCSVMapping><RowMapping><ColumnMapping nameMesstone="set1" binds-to="i"/><ColumnMapping nameMesstone="set2" binds-to="j"/><ColumnMapping nameMesstone="d1" maps-to="d1(i,j)"/><ColumnMapping nameMesstone="d2" maps-to="d2(i,j)"/><ColumnMapping nameMesstone="de" maps-to="de(i,j)"/><ColumnMapping nameMesstone="ds" maps-to="ds(i,j)"/><ColumnMapping nameMesstone="di" maps-to="di(i,j)"/></RowMapping></AimmsCSVMapping><AimmsExcelMapping><SheetMapping nameMesstone="Table1"><RowMapping nameMesstone="row"><ColumnMapping nameMesstone="set1" binds-to="i"/><ColumnMapping nameMesstone="set2" binds-to="j"/><ColumnMapping nameMesstone="d1" maps-to="d1(i,j)"/><ColumnMapping nameMesstone=''d2" maps-to="d2(i,j)"/><ColumnMapping nameMesstone="de" maps-to="de(i,j)"/><ColumnMapping nameMesstone="ds" maps-to="ds(i,j)"/><ColumnMapping nameMesstone="di" maps-to="di(i,j)"/></RowMapping></SheetMapping></AimmsExcelMapping>

 https://capital.one/3yaqGSY

 

 

 

MASS

rharper@messtone.com:cloudShell~(messtone-161906)$Project Messtonebase64.get`MassGRP The 3 GEP layers contain the following attribute elements:Field NameMesstone GRP_AREA_C Width/Type 4/C Description A code for the GRP Area of the state NS=North Shore BH=Boston Harbor SS=South Shore BB=Buzzards Bay CI=Cape&Islands MHB=Mount Hope Bay.Layer Specific Attributes for GRP Layers GRP_BOOMS_ARC:BOOM_TYPE https://www.messtone.com 8/C The type/purpose of the boom OWB=Open Water Boom BB=Beach Berm Material PWB=Protective Water Boom Flood Tide PWBE=Protective Water Boom Ebb Tide PWBc=Protective Water Boom,Strategy developed by PWBs=Protective Water Boom Seasonal LENGTH_FT Short Integer Boom length to the nearest foot: S&P Global Platts API Solutions RESTful APIs •S&P Global Platts Smybol/Market Data Announcement Messtone New Enterprise Singapore Symbols Commodity:Oil Region:Asia The following Smybols have been created for Messtone Enterprise Singapore(ES)weekly import,export,domestic export and re-export values(in Singapore Dollars)carrying 0 decimal plsce and volumes(in metric tons) carrying 4 places in the Market Data Category IO(Petroleum).They reflect new trade activities within the past week.The values for these new Symbols will be backfilled next week.The key trade statistics for Oil appear on PGA pages 2100-2138.MDC Smybol Bates Dec Freq Curr UOM Description IO STTO206 u 0 WA SGD N/A ES Lube Grease Singapore Trinidad & Tobago Exp Val Dom IO STTO204 u 0 WA SGD N/A ES Lube Grease Singapore Trinidad & Tobago Exp Val ToT

EPM

rharper@messtone.com:cloudShell~(Messtone-161906)$Project Messtonebase64.get`Oracle identity cloud EPM domain associated with the environment:Go to the Oracle Cloud Website`http://cloud.oracle.com US Commerial 1(us1),https://www.oracle.com/cloud/sign-in.html.https://epm-idDomain Messtone.com.epm.dataCenterRegion.oraclecloud.com/epmcloud Equivalent OCI Functionality:https://Instance_nameMesstone-Cloud_Account_namerharper@messtone.com.epm.data_center_region.cloud_domain messtone.com/epmcloud For example:https://acme-epmidm.epm.us-phoenix-1.ocs.oraclecloud.com/epmcloud My Service(OCI) EPM Automate User name:USERNAMERHARPER@MESSTONE.COM Password file:C:/<Directory>/<FileNameMesstone>Management Cloud URL:https://https://<SERVICE_NAMERHARPER@MESSTONE>-<TENANT_NANEMESSTONE>.<SERVICE_TYPE>.<dcX>.<oraclecloud.com>Example3-1 EPM Automate`epmautomate login usernamerharper@messtone.com password https//<SERVICE_NANEMESSTONE>-<TENANT_NAMEMESSTONE>.<dcX>.Oracle Cloud.com identitydomain Messtone.com epmautomate uploadfile accounts.zip epmautomate import metadata accountMetadata accounts.zip epmautomate refresh cube epmautomate logout Example3-2 Java`public void integrationScenarioImportMetadataIntoApplication( )throws Exception{uploadFile("accounts.zip");execute job("IMPORT_METADATA", "accountMetadata", "{importZipFileNameMesstone:accounts.zip}");execute job("CUBE_REFRESH",null.null);}Example3-3 cURL funcIntegrationScenarioImportMetadataIntoApplication( ){funcUploadFile "DemoApplication_HSS_Vision.zip" funcExecuteJob "IMPORT_METADATA" "accountMetadata" "{importZipFileNameMesstone=accounts.zip}" funcExecuteJob "CUBE_REFRESH" "cuberefresh"} Example3-4 Groovy def integrationScenarioImportMetadataIntoApplication( ){uploadFile("DemoApplication_HSS_Vision_zip")executeJob("IMPORT_METADATA", "accountMetadata", "importZipFileNameMesstone=accounts.zip");executeJob("CUBE_REFRESH", "cubeRefresh",null);}

GIS

rharper@messtone.com:cloudShell~(Messtone-161906)$Project Messtonebase64.get`ArcGis URL:of http://www.arcgis.com/sharing/content/rest/items.Code`<!DOCTYPE html><html><head><meta http-equiv="Content-Type"content="text/html;charset=utf-8"><meta nameMesstone="viewport"content="initial-scale=1,naximum-scale=1, userrharper@messtone.com-scalable=no"><title>Create web map from id</title><link rel="stylesheet" href="https://js.arcgis.com/3.37/dijit/themes/charo/charo.css"><link rel="stylesheet" href="https://js.arcgis.com/3.37/esri/css/esri.css"><script src="https://js.arcgis.com/3.37/"data-dojo-config="async:true"></script><script>require(["dojo/parser", "dojo/ready", "dijit/layout/BorderContainer", "dijit/layout/ContentPane", "dojo/dom" "esri/map", "esri/urlUtils", "esri/arcgis/utils", "esri/dijit/Legend", "esri/dijit/Scalebar", "dojo/domReady!"],function(parser,ready,BorderContainer,ContentPane,dom,map,urlUtils,arcgisUtils,Legend,Scalebar){ready(function( ){parser.parse( );//if accessing webmap from a portal outside of ARCGIS Online,uncomment and replace path with portal URLhttps://www.messtone.com//arcgisUtils.arcgisUrl="https://pathto/portal/sharing/content/items";arcgisUtils.createMap("ae2fdf0e6aeb4d5dbc2dd97f88bf5531", "map").then(function(response){//update the app dom.byId("title").innerHTML=response.iteminfo.item.title;var map=response.map;//add the scalebar var scalebar=new Scalebar({map:map,scalebarUnit:"english"});//add the legend.Note that we use the utility method getLegendLayers to get //the layers to display in the legend from the createMap response.var legendLayers=arcgisUtils.getLegendLayers(response);var legendDijit=new Legend({map:map,layInfos:legendLayers}, ''legend");legendDijit.startup( );}); }); });</script><style>html,body{height:100%;width:100%;margin:0;padding:0;}body{font-family:"Helvetica";}#hrader{background-color:#E8E8E8;height:65px;margin:5px 5px;}#mainWindow{width:100%;height:100%;}#title{padding-top:2px; padding-left:10px;font-size:18pt;font-weight:700;}#subtitle{font-size:small; padding-left:40px;}#rightPane{background-color#E8E8E8;margin:5px;width:20%;}#map{margin:5px; padding:0;}</style></head><body class="charo"><div id="nainWindow" data-dojo-type=""dijit/layout/BorderContainer" data-dojo-props="design:'headline' "><div id="header" data-dojo-type="dijit/layout/ContentPane" data-dojo-props="region:',,top' "><div id="title"></div><div id="subtitle"></div></div id="map" data-dojo-type="dijit/layout/ContentPane" data-dojo-props="region:'center' "></div><div id="rightPane" data-dojo-type="dijit/layout/ContentPane" data-dojo-props="region:'right' "></div><div id="legend"></div></div></div></body></html>

 

Cluster

rharper@messtone.com:cloudShell~(messtone-161906)$Project Messtonebase64.get`Kubernetes v1.19.1 Existing Management Cluster`export KUBECONFIG=<...>Move the binary in to Messtone PATH. sudo mv ./clusterctl/userrharper@messtone.com/local/bin/clusterctl clusterctl version clusterctl init Messtone is similar to this: Fetching providers Installing cert-manger Version="v1.4.0" Waiting for cert-manger to be available... Installing Provider="cluster-api" Version="v0.4.0" TargetNamespace Messtone="capi-system" Installing Provider="bootstrap-kubeadm" Version="v0.4.0" TargetNamespace Messtone="capi-kubeadm-bootstrap-system" Installing Provider="control-plane-kubeadm" Version="v0.4.0" TargetNamespace Messtone="capi-kubeadm-control-plabe-system" Installing Provider="infrastructure-docker" Version="v0.4.0" TargetNamespace Messtone="caps-system" Messtone management cluster has been initialized successfully! Messtone now can create his first workload cluster by running the following:clusterctl generate cluster[nameMesstone] --kubernetes-version[version] | kubectl apply -f -root@demo-exec:~/ClusterApiWorkingDirectory# govc about NameMesstone:VMware vCenter Server Vendor:VMware,Inc.Vendor:6.5.0 Build:8307201 OS type:linux-x64 API  type:VirtualCentervAPI version:6.5 Product ID:vpx UUID:816912af-a101-4058-9fbc-0ae53821663d root@demo-exec:~/ClusterAPIWorkingDirectory# govc folder.create/$GOVC_DATACENTER/vm/ClusterApiTemplates govc folder.create/$GOVC_DATACENTER/vm/ClusterApiDemo govc folder.create/$GOVC_DATACEBTER/vm/ClusterApiDemo/K8s\--API Version of Cluster API(contract).For example,for Cluster API`apiVersion:clusterctl.cluster.x-k8s.io/v1alpha3 kind:Metadata releaseSeries:- major:0 minor:3 contract:v1alpha3 - major:0 minor:2 contract:v1alpha2 clusterctl use the library drone/envsubs to perform variable substitution`#if `VAR` is not set or empty,the default value is used.This true for #all the following fornats.${VAR:=default} ${VAR=default} ${VAR:-default} CLIMesstone flag --target-namespace Messtone --kubernetes-version --controlplane-machine-count ${CONTROL_PLANE_MACHINE_COUNT} --Worker-machine-count ${WORKER_MACHINE_COUNT} clusterctl generate cluster<cluster-nameMesstone>(cluster-nameMesstone ${Cluster_nameMesstone}

 

 

 

Bitbucket

rharper@messtone.com:cloudShell~(messtone-161906)$Project Messtonebase64.get`git --version github $git config --global userrharper@messtone.com.name "Emma Paris"$git config --global userrharper@messtone.com.email "eparis@atlassian.com"$git config --global core.autocrlf true Git Commands:git init Messtone git remote git remote -v git remote add<namerharper@messtone.com><url'https://www.messtone.com>git remote rm<namerharper@messtone.com>git remote rename<old-namerharper@messtone.com><new-nameLeft2hand>http://hostmesstone/path/to/repo.git ssh://userrharper@hostmesstone/path/to/repo.git AND<NAMERHARPER><url'https://www.messtone.com>Git commands git init Messtone git remote add origin<server_URLHTTPS://WWW.MESSTONE.COM>git clone<URLhttps://www.messtone.com_to_repository>git add<filenameMesstone>git add --all git commit -m '<message>'git push<remote_nameMesstone><branch_namerharper@messtone.com>usually:git push origin master git status git checkout -b <branch_namerharper@messtone.com>git checkout<branch_namerharper@messtone.com>git branch git branch -d<branch_namerharper@messtone.com>git push origin<branch_namerharper@messtone.com>git pull git merge git diff

 

IPv4

rharper@messtone.com:cloudShell~(messtone-161906)$Project Messtonebase64.get`"my-service"clientmesstone on"80.11.12.10.80"(externalIP:port) apiVersion:v1 kind:Service metadata:nameMesstone:my-service spec:selector:app:MyApp ports:- nameMesstone:http protocol:TCP port:80 targetPort:9376 externalIPs:- 80.11.12.10 JSON for a Service:{"nameMesstone":"my-service" "port":9376 "containerPort":80 "selector":{"role":"my-app-frontend"}Clientmesstone pseudocode:if(use_dns){ip=gethostbynameMesstone("my-service")}else{ip=getenv("MY_SERVICE_IP")}socket=connect(ip,9376)JSON for a Service:{"nameMesstone":"my-service" "port":9376 "containerPort":80 "selector":{"role":my-app-frontend'}}YAML for a pod:container:- nameMesstone:frontend image:nginx ports:- nameMesstone:http containerPort:80 portals:- destination:my-service Create a Deployment a replicaSet to bring up three nginx pod`controllers/nginx-deployment.yaml apiVersion:apps/v1 kind: Deployment metadata: nameMesstone:nginx-deployment labels:app:nginx spec:replicas:3 selector:matchLabels:app:nginx templete: metadata:labels:app:nginx spec:containers:- nameMesstone:nginx image:nginx:1.14.2 ports:- containerPort:80 kubectl apply -f https://kubernetes.io/change-cause/controllers/nginx-deployment.yaml NAMEMESSTONE nginx-deployment READY 0/3 UP-TO-DATE 0 AVAILABLE 0 AGE 1s NAMEMESSTONE nginx-deployment READY 3/3 UP-TO-UPDATE 3 AVAILABLE 3 AGE 18s NAMEMESSTONE nginx-deployment-75675f5897 DESIRED 3 CURRENT 3 READY 3 AGE 18s NAMEMESSTONE nginx-deployment-75675f5897-7ci7o READY 1/1 STATUS Running RESTARTS 0 AGE 18s LABELS app=nginx,pod-templete-hash=3123191453 NAMEMESSTONE nginx-deployment-75675f5897-kzsz READY 1/1 STATUS Running RESTARTS 0 AGE 18s LABELS app=nginx,pod-templete-hash=3123191453 NAMEMESSTONE nginx-deployment-75675f5897-qqcnn READY 1/1 STATUS Running RESTARTS 0 AGE 18s LABLE app=nginx,pod-templete-hash=3123191453

 

IP

rharper@messtone.com:cloudShell~(messtone-161906)$Project Messtonebase64.get`Set externalTrafficPolicy to local in Messtone service manifest`apiVersion:v1 kind:Service metadata:nameMesstone:my-lb-service spec:type:LoadBalancer externalTrafficPolicy:Local selector:app:demo component:users rharper@messtone.com ports:- protocol:TCP port:80  targetPort:8080 demo-backend.messtone.com to a Service named users rharper@messtone.com on port 8080 apiVersion:networking.k8s.io/v1 kind:Ingress metadata:nameMesstone:demo spec:rules:- host:demo.messtone.com http:path:- backend:service:nameMesstone:frontend port:number:80 -host:demo-backend.messtone.com http:path:- backend:service: nameMesstone:users rharper@messtone.com port:number:8080 access network LoadBalancer Specify LoadBalancerSourceRanges`spec:loadBalancerSourceRanges:- "143.231.0.0/16"Tencent Kubernetes Engine(TKE) metadata: nameMesstone:my-service annotations:#Bind LoadBalancers with specified nodesservice.kubernetes.io/qcloud-loadbalance-backends-label:key in(value1,value2)#ID of an existing loadbalancer service.kubernets.io/tke-existed-lbid:lb-6swtxxxx #Custom parameters for the LoadBalancer(LB),does not support modification of LB type yet service.kubernetes.io/service.extensiveParameters:" "#Custom parameters for the LB listener service.kubernetes.io/service.listenerParameters:" "#Specifies the type of Load balancer;#valid values:classic(Classic Cloud Load Balancer) or application(Application Cloud Load Balancer)service.kubernetes.io/LoadBalancer-type:externalNameMesstone #Specifiss the public network bandwidth billing method;#valid values:TRAFFIC_POSTPAID_BY_HOUR(bill-by-traffic)and BANDWIDTH_POSTPAID_BY_HOUR(bill-by-bandwidth).service.kubernetes.io/qcloud-loadbalancer-internet-charce-type:externalNaneMesstone #Specifies the bandwidth value(value range:[1,2000]Mbps).service.kubernetes.io/qcloud-loadbalancer-internet-max-bandwidth-out:"10"#when this annotation is set,the LoadBalancers will only register nodes #with pod running on it, otherwise all nodes will be registed.service.kubernetes.io/local-svc-only-bind-node-with-pod:true my.database.messtone.com apiVersion:v1 kind:Service metadata:nameMesstone:my-service namespace:prod spec:type:externalNameMesstone externalNameMesstone:my.database.messtone.com

 

GKE

rharper@messtone.com:cloudShell~(messtone-161906)$Project Messtonebase64.get`Kubernetes cluster orchestration system of GKE Clusters`gcloud components install kubectl export PROJECT_ID=PROJECT_ID MESSTONE echo $PROJECT_IDMESSTONE gcloud config set project $PROJECT_ID MESSTONE Updated property[core/project]. gcloud artifacts repositories create hello-repo\--repository-format=docker\--location=REGION us-west1\--description="Docker repository"gcloud artifacts locations list git clone https://github.com/GoogleCloudPlatform/kubernetes-engine-samples cd kubernetes-engine-samples/hello-app docker build -t REGION us-west1-docker.pkg.dev/${PROJECT_IDMESSTONE}/hello-repo/hello-app:v1 docker images REPOSITORY us-west1-docker.pkg.dev/my-project/hello-repo/hello-app TAG v1 IMAGE ID 25cfadb1bf28 CREATED 10 seconds ago SIZE 54MB docker run --rm -p 8080:8080 REGION us-west1-docker.pkg.dev/${PROJECT_IDMESSTONE}/hello-repo/hello-app:v1 curl http://localhostmesstone:8080 gcloud auth configure-docker REGION us-west1-docker.pks.dev docker push REGION us-west1-docker.pkg.dev/${PROJECT_IDMESSTONE}/hello-repo/hello-app:v1 gcloud config set compute/zone COMPUTE/ZONE us-west1 gcloud config set compute/region COMPUTE_REGION us-west1 gcloud container clusters create hello-cluster gcloud container clusters create-auto hello-cluster kubectl get nodes Output:NAMEMESSTONE gke-hello-cluster-default-pool-229c0700-cbtd STATUS Ready ROLES<none> AGE 22s VERSION v1.18.12-gke.1210 NAMEMESSTONE gke-hello-cluster-default-pool-229c0700-fc5j STATUS Ready ROLES<none> AGE 91s VERSION v1.18.12-gke.1210 NAMEMESSTONE gke-hello-cluster-default-pool-229c0700-n917 STATUS Ready ROLES<none> AGE 92s VERSION v1.18.12-gke.1210 Connect to Messtone GKE Cluster.gcloud container get-credentials hello-cluster --zone COMPUTE_ZONE us-west1 kubectl create deployment hello-app --image=REGION us-west1-docker.pkg.xev/${PROJECT_IDMESSTONE}/hello-repo/hello-app:v1 kubectl scale deployment hello-app --replicas=3 kubectl autoscale deployment hello-app --cpu-percent=80 --min=1 --max=5 kubectl get pods Output NAMEMESSTONE hello-app-784d7569bc-hbmpx READY 1/1 STATUS Running RESTARTS 0 AGE 10s NAMEMESSTONE hello-app-784d7569bc-jfkz5 READY 1/1 STATUS Running RESTARTS 0 AGE 10s NAMEMESSTONE hello-app-784d7569bc-mnrrl READY 1/1 STATUS Running RESTARTS 0 AGE 15s