Tutorial by Examples: nd

Add the necessary dependencies to the project POM (mybatis, and mybatis-spring): <dependency> <groupId>org.mybatis</groupId> <artifactId>mybatis</artifactId> <version>x.x.x</version> </dependency> <dependency> <group...

A1:A4 have A,B,C,D. B1 have the following formula: =ARRAYFORMULA({A1:A4,ROW(A1:A4)}) Result ABC1AA12BB23CC34DD4

One of the features that we can use with Threadpools is the submit() method which allow us to know when the thread as finish his work. We can do this thanks to the Future object, which return us an object from the Callable that we can use to our own objetives. Here is an example about how to use th...

Clustered column store index can be rebuilt if you have a lot of deleted rows: ALTER INDEX cci ON Products REBUILD PARTITION = ALL Rebuilding CLUSTERED COLUMNSTORE will "reload" data from the current table into new one and apply compression again, remove deleted rows, etc. You can re...

The following is the default code snippet for the BundleConfig.cs file. using System.Web.Optimization; public class BundleConfig { // For more information on Bundling, visit http://go.microsoft.com/fwlink/?LinkId=254725 public static void RegisterBundles(BundleCollection bundles...

First why we should use depedency injection in our code ? We want to decouple other components from other classes in our program. For example we have class AnimalController which have code like this : public class AnimalController() { private SantaAndHisReindeer _SantaAndHisReindeer = new San...

autodie allows you to work with files without having to explicitly check for open/close failures. Since Perl 5.10.1, the autodie pragma has been available in core Perl. When used, Perl will automatically check for errors when opening and closing files. Here is an example in which all of the lines ...

This topic demonstrates how to use functions like withColumn, lead, lag, Level etc using Spark. Spark dataframe is an sql abstract layer on spark core functionalities. This enable user to write SQL on distributed data. Spark SQL supports hetrogenous file formats including JSON, XML, CSV , TSV etc. ...

In this very first example, a basic serial write operation is started from an Arduino device. void setup() { // put your setup code here, to run once: Serial.begin(9600); } void loop() { // put your main code here, to run repeatedly: Serial.println("Hello World!"); dela...

If you want to append a series of values [1,2] to the column of dataframe df, you will get NaNs: import pandas as pd series=pd.Series([1,2]) df=pd.DataFrame(index=[3,4]) df['col']=series df col 3 NaN 4 NaN because setting a new column automatically aligns the data by the inde...

COMPUTE answer = 3*var-1 That is a reference to the variable var-1, and not var - 1. COMPUTE answer = 3 * var - 1 Recommended, opinion.

app.use(async (ctx, next) => { try { await next() // attempt to invoke the next middleware downstream } catch (err) { handleError(err, ctx) // define your own error handling function } })

This ability was added to the Bind markup extension after v1607 (Redstone 1). You can specify a function path, as well as arg paths and constant args. Let's assume we have a function defined in our backcode: public string Translate(string text, string from, string to) Now we can use bind to eva...

php bin/magento setup:upgrade => Setup Upgrade php bin/magento setup:di:compile => Setup: Compile php bin/magento indexer:reindex => Reindex php bin/magento cache:flush => Clear Cache php bin/magento deploy:mode:set...

This UNION ALL combines data from multiple tables and serve as a table name alias to use for your queries: SELECT YEAR(date_time_column), MONTH(date_time_column), MIN(DATE(date_time_column)), MAX(DATE(date_time_column)), COUNT(DISTINCT (ip)), COUNT(ip), (COUNT(ip) / COUNT(DISTINCT (ip))) AS Ratio ...

Dockerization of ASP.NET Application requires a Dockerfile for configuration and running it as a docker container. FROM microsoft/dotnet:latest RUN apt-get update && apt-get install sqlite3 libsqlite3-dev COPY . /app WORKDIR /app RUN ["dotnet", "restore"] ...

First of all, the problem of handling spaces in arguments is NOT actually a Java problem. Rather it is a problem that needs to be handled by the command shell that you are using when you run a Java program. As an example, let us suppose that we have the following simple program that prints the siz...

Install openfire or any chat server in your system or on server. For more details click here. Create android project and add these libraries in gradle: compile 'org.igniterealtime.smack:smack-android:4.2.0' compile 'org.igniterealtime.smack:smack-tcp:4.2.0' compile 'org.igniterealtime.smack:smac...

All we need are: ViewPager, TabLayout and 2 drawables for selected and default dots. Firstly, we have to add TabLayout to our screen layout, and connect it with ViewPager. We can do this in two ways: Nested TabLayout in ViewPager <android.support.v4.view.ViewPager android:id="@+i...

The default way to find installed packages with CMake is the use the find_package function in conjunction with a Find<package>.cmake file. The purpose of the file is to define the search rules for the package and set different variables, such as <package>_FOUND, <package>_INCLUDE_D...