Tutorial by Examples: n

Setup for CentOS7 / RHEL7

This example assumes two servers: dbserver (where our database lives) appclient (where our applications live) FWIW, both servers are SELinux enforcing. First, log on to dbserver Create a temporary directory for creating the certificates. mkdir /root/certs/mysql/ && cd /root/cer...

MySQL • SSL Connection Setup

Getting Help

You can use function help() or ? to access documentations and search for help in R. For even more general searches, you can use help.search() or ??. #For help on the help function of R help() #For help on the paste function help(paste) #OR help("paste") #OR ?paste #OR ...

R Language • Getting started with R Language

Comments

SASS supports two types of comments: Inline comments - These only span one line and are usually used to describe a variable or block. The syntax is as follows: // Your comment here (you prepend it with a double slash (//) and the rest of the line is ignored by the parser. Multiline comment...

sass • Getting started with sass

Retrieve partition table,column, scheme, function, total and min-max boundry values using single query

SELECT DISTINCT object_name(i.object_id) AS [Object Name], c.name AS [Partition Column], s.name AS [Partition Scheme], pf.name AS [Partition Function], prv.tot AS [Partition Count], prv.miVal AS [Min Boundry Value], prv.maVal AS [Max Boundry Value] FROM sys.object...

Microsoft SQL Server • Partitioning

JSP Comments Example

<!DOCTYPE html> <html> <head> <meta http-equiv="Content-Type" content="text/html"> <title>JSP Comments</title> </head> <body> <%-- JSP comments --%> -- Ignored by container, you can't see this comment in source code...

jsp • Comments in JSP

Command Syntax

Salt commands are executed using a common structure: salt '*' pkg.install vim [target] [module.function] [arguments] The target determines which systems apply the command. In the example above we target all ('*') the Salt minions. See the targeting minions documentation for more...

salt-stack • Getting started with salt-stack

Parse JSON file with Groovy

Suppose we have the following JSON data: { "TESTS": [ { "YEAR": "2017", "MONTH": "June", "DATE": "28" } ] } import groovy.json...

JSON • Parsing JSON string

How can I compile my Sass

This section is only relevant if you work with the Sass version of Materialize. First, you need to install Sass in your working directory: gem install sass When you have Sass installed on your project and you want to update your output .css file, you need to use the following command: sass sas...

materializecss • Getting started with materializecss

Add an autocomplete UI control with results controller.

The autocomplete UI control is a search dialog with built-in autocomplete functionality. As a user enters search terms, the control presents a list of predicted places to choose from. When the user makes a selection, a GMSPlace (Place in Xamarin) instance is returned, which your app can then use to ...

Xamarin.iOS • Xamarin iOS Google Places Autocomplete

Python

There are multiple ways to switch to alert pop-up in Python: Deprecated: alert = driver.switch_to_alert() Using switch_to: alert = driver.switch_to.alert Using ExplicitWait: from selenium.webdriver.common.by import By from selenium.webdriver.support.ui import WebDriverWait ...

selenium-webdriver • Handle an alert

CAST data to JSON type

This converts valid json strings to MySQL JSON type: SELECT CAST('[1,2,3]' as JSON) ; SELECT CAST('{"opening":"Sicilian","variations":["pelikan","dragon","najdorf"]}' as JSON);

MySQL • JSON

Create Json Object and Array

JSON_OBJECT creates JSON Objects: SELECT JSON_OBJECT('key1',col1 , 'key2',col2 , 'key3','col3') as myobj; JSON_ARRAY creates JSON Array as well: SELECT JSON_ARRAY(col1,col2,'col3') as myarray; Note: myobj.key3 and myarray[2] are "col3" as fixed string. Also mixed JSON data: S...

MySQL • JSON

Read JSON Array value

Create @myjson variable as JSON type (read more): SET @myjson = CAST('["A","B",{"id":1,"label":"C"}]' as JSON) ; SELECT some members! SELECT JSON_EXTRACT( @myjson , '$[1]' ) , JSON_EXTRACT( @myjson , '$[*].label') , JSON_EXTRACT( @...

MySQL • Extract values from JSON type

JSON Extract Operators

Extract path by -> or ->> Operators, while ->> is UNQUOTED value: SELECT myjson_col->>'$[1]' , myjson_col->'$[1]' , myjson_col->>'$[*].label' , myjson_col->>'$[1].*' , myjson_col->>'$[2].*' FROM tablename ; -- visuall: B, "B...

MySQL • Extract values from JSON type

Interrupt Handling

Interrupts are handled by a protected procedure with no parameters. ------------------------------------------------------------------ -- Interrupt Counting Package -- ------------------------------------------------------------------ with Ada.Interrupts.Names; use Ada.Interrupts.Names; packa...

ada • Task

Show more information about remote repository

You can view more information about a remote repository by git remote show <remote repository alias> git remote show origin result: remote origin Fetch URL: https://localserver/develop/myrepo.git Push URL: https://localserver/develop/myrepo.git HEAD branch: master Remote branches: ...

Git • Git Remote

Installation and Setup

Description of the installation process : Debian jessie -- Installation Guide Each architecture has his own installation guide : amd64 i386 armel s390x powerpc armhf mips AArch64 POWER. Download an iso image of the Debian distribution (stable release): Debian installer Use ...

debian • Getting started with debian

Overriding Freight Amount in Shipment and Invoice

Out of the box Acumatica allows to create and maintain the list of shipping terms in the system. Shipping terms are used to define the shipping, packaging and handling costs, depending on the shipment amount. In this example I will show how to calculate freight amount for a shipment based on sales ...

acumatica • Freight Calculation

Installation or Setup

XHTML Relation to HTML XHTML is simply the serialized version of HTML. XHTML was originally intended to clean up HTML markup to better improve standards support. Unfortunately the W3C's work on XHTML 2.0 was not intuitive and detracted from where the industry as a whole was headed with HTML5. XHTML...

xhtml • Getting started with xhtml

Running TypeScript using ts-node

ts-node is an npm package which allows the user to run typescript files directly, without the need for precompilation using tsc. It also provides REPL. Install ts-node globally using npm install -g ts-node ts-node does not bundle typescript compiler, so you might need to install it. npm instal...

TypeScript • Getting started with TypeScript