Tutorial by Examples: en

GROUP BY is used in combination with aggregation functions. Consider the following table: orderIduserIdstoreNameorderValueorderDate143Store A2520-03-2016257Store B5022-03-2016343Store A3025-03-2016482Store C1026-03-2016521Store A4529-03-2016 The query below uses GROUP BY to perform aggregated calc...

Protocol Oriented Programming is a useful tool in order to easily write better unit tests for our code. Let's say we want to test a UIViewController that relies on a ViewModel class. The needed steps on the production code are: Define a protocol that exposes the public interface of the class Vi...

String hubUrl = "http://localhost:4444/wd/hub" DesiredCapabilities capability = DesiredCapabilities.firefox(); //or which browser you want RemoteWebDriver driver = new RemoteWebDriver(hubUrl, capability);

Creating a hub A quick configuration for a hub and node setup in selenium grid. For more information see: Grid 2 docs Requirements To set up a grid hub you need the flowing: Selenium-server-standalone-.jar Creating the hub To Create a Hub you need to run the selenium server. Download Se...

Extension methods are useful for adding functionality to enumerations. One common use is to implement a conversion method. public enum YesNo { Yes, No, } public static class EnumExtentions { public static bool ToBool(this YesNo yn) { return yn == YesNo.Yes; ...

The interface you defined needs to be implemented in every targeted platform. For iOS this is done through the AVFoundation framework. The following implementation of the ITextToSpeech interface handles speaking a given text in English. using AVFoundation; public class TextToSpeechiOS : ITextToS...

The Android specific implementation is a bit more complex because it forces you to inherit from a native Java.Lang.Object and forces you to implement the IOnInitListener interface. Android requires you to provide a valid Android context for a lot of the SDK methods it exposes. Xamarin.Forms exposes ...

Given this data User_IDCompletion_Date12016-07-2012016-07-2122016-07-2022016-07-2122016-07-22 ;with CTE as (SELECT *, ROW_NUMBER() OVER (PARTITION BY User_ID ORDER BY Completion_Date DESC) Row_Num FROM Data) SELECT * FORM CTE WHERE Row_Num <= n Us...

Refer to the tf.slice(input, begin, size) documentation for detailed information. Arguments: input: Tensor begin: starting location for each dimension of input size: number of elements for each dimension of input, using -1 includes all remaining elements Numpy-like slicing: # x has shape...

Some functions only work on a certain type of argument: function foo(tab) return tab.bar end --> returns nil if tab has no field bar, which is acceptable --> returns 'attempt to index a number value' if tab is, for example, 3 --> which is unacceptable function kungfoo(tab) ...

A non-blocking assignment (<=) is used for assignment inside edge-sensitive always blocks. Within a block, the new values are not visible until the entire block has been processed. For example: module flip( input clk, input reset ) reg f1; reg f2; always @ (posedge clk) begin ...

Demo HTML <script type="x-template" id="form-template"> <label>{{inputLabel}} :</label> <input type="text" v-model="name" /> </script> <div id="app"> <h2>{{appName}}</h2> <form-co...

All you need is a variable of type IHostingEnvironment: get environment name: env.EnvironmentName for predefined Development, Staging, Production environments the best way is to use extension methods from HostingEnvironmentExtensions class env.IsDevelopment() env.IsStaging() ...

In normal mode, we can increment the nearest number on the line at or after the cursor with <C-a> and decrement it with <C-x>. In the following examples, the cursor position is indicated by ^. Incrementing and decrementing numbers for i in range(11): ^ <C-x> decrements ...

Flash dispatches Events for most of its objects. One of the most basic event is ENTER_FRAME, which is dispatched (at the framerate of the SWF) on every display list object. import flash.display.Sprite; import flash.events.Event; var s:Sprite = new Sprite(); s.addEventListener(Event.ENTER_FRAME...

You can create your own events and dispatch them, by extending the Event class. import flash.events.Event; class MyEvent extends Event { var data: String; static public var MY_EVENT_TYPE = "my_event_my_event_code"; public function MyEvent(type: String, data: Str...

Codename One is a set of tools for mobile application development that derive a great deal of its architecture from Java. Codename One's mission statement is: Unify the complex and fragmented task of mobile device programming into a single set of tools, APIs & services. As a result create a...

Single JAR Sometimes you have a local JAR file you need to add as a dependency to your Gradle build. Here's how you can do this: dependencies { compile files('path/local_dependency.jar') } Where path is a directory path on your filesystem and local_dependency.jar is the name of your local...

Dependencies in Gradle follow the same format as Maven. Dependencies are structured as follows: group:name:version Here's an example: 'org.springframework:spring-core:4.3.1.RELEASE' To add as a compile-time dependency, simply add this line in your dependency block in the Gradle build file: ...

It is possible to find the first element of a Stream that matches a condition. For this example, we will find the first Integer whose square is over 50000. IntStream.iterate(1, i -> i + 1) // Generate an infinite stream 1,2,3,4... .filter(i -> (i*i) > 50000) // Filter to find element...