Tutorial by Examples: co

SELECT date_trunc('week', <>) AS "Week" , count(*) FROM <> GROUP BY 1 ORDER BY 1;

COPY products(is_public, title, discount) TO 'D:\csv_backup\products_db.csv' DELIMITER ',' CSV HEADER; COPY categories(name) TO 'D:\csv_backup\categories_db.csv' DELIMITER ',' CSV HEADER;

import matplotlib.pyplot as plt import numpy as np # generate 101 x and y values between -10 and 10 x = np.linspace(-10, 10, 101) y = np.linspace(-10, 10, 101) # make X and Y matrices representing x and y values of 2d plane X, Y = np.meshgrid(x, y) # compute z value of a point as a fun...

import matplotlib.pyplot as plt import numpy as np # generate 101 x and y values between -10 and 10 x = np.linspace(-10, 10, 101) y = np.linspace(-10, 10, 101) # make X and Y matrices representing x and y values of 2d plane X, Y = np.meshgrid(x, y) # compute z value of a point as a fun...

Here are the steps to generate test skeleton for existing code: Open Eclipse, and choose the project you want to create test cases for In the Package Explorer, select the java class you want to generate the Junit test for Go to File -> New -> Junit Test Cases Change the Source folder to ...

Eventloop in pseudo code An event loop is a loop that waits for events and then reacts to those events while true: wait for something to happen react to whatever happened Example of a single-threaded HTTP server with no event loop while true: socket = wait for the next TCP c...

Windows 10 IoT Core is available only for Raspberry Pi 2 and 3. It is important to note that this is not a full version of windows as one might expect, it is designed specifically for IoT (Internet of Things) applications. It will not run most standard windows applications, and does not have a start...

Terminal Commands: rails g model Product name:string quantity:integer price:decimal{12,2} rake db:migrate Lates create controller. Terminal Commands: rails g controller Products Controller Code: class HistoriesController < ApplicationController def create file = Dir.glob(...

When dealing with large configuration sets of value, it might become quite unhandy to load them one buy one. Option model which comes with asp.net offers a convenient way to map a section to a dotnet poco: For instance, one might hydrate StorageOptions directly from a configuration section b addin...

You can also source configuration from an in memory object such as a Dictionary<string,string> .AddInMemoryCollection(new Dictionary<string, string> { ["akey"] = "a value" }) This can reveal helpful in integration/unit testing scenarios.

In order to be able to directly deploy web project changes to an Web Server, the following steps must be followed. If target server has Internet access, the process is quite simple, as Microsoft has a Web Platform package to do almost everything that is needed. Cleanup Make sure that C:\Progra...

import com.couchbase.client.core.endpoint.SSLEngineFactory import com.couchbase.client.java.env.DefaultCouchbaseEnvironment import com.couchbase.client.java.CouchbaseCluster object CouchbaseConnection extends App { //Create default environment object. //Set the keystone file path(downlo...

The Assets folder is the most common place to store your GLSL-ES shader files. To use them in your OpenGL ES application you need to load them to a string in the first place. This functions creates a string from the asset file: private String loadStringFromAssetFile(Context myContext, String filePa...

mvc demo Hello World

var indexController = myApp.controller("indexController", function ($scope) { // Application logic goes here });

Fully configuration of Web deployment without Internet connection (offline) is harder to make because Web platform installer (UI) operates by querying packages list and content from an Internet location. Cleanup Make sure that C:\Program Files\IIS does not contain older version of Microsoft We...

This method is to check data connection by ping certain IP or Domain name. public Boolean isDataConnected() { try { Process p1 = java.lang.Runtime.getRuntime().exec("ping -c 1 8.8.8.8"); int returnVal = p1.waitFor(); boolean reachable = (returnVal==0); ...

public static boolean isConnectedNetwork (Context context) { ConnectivityManager cm = (ConnectivityManager) context.getSystemService(Context.CONNECTIVITY_SERVICE); return cm.getActiveNetworkInfo () != null && cm.getActiveNetworkInfo ().isConnectedOrConnecting (); ...

The Java Native Interface (JNI) allows you to call Java functions from native code. Here is a simple example of how to do it: Java code: package com.example.jniexample; public class JNITest { public static int getAnswer(bool) { return 42; } } Native code: int getTheAnswer(...

private static void saveItem(List<EventTracker> items) { List<WriteRequest> wrList = new ArrayList<>(); try { for (EventTracker item : items) { WriteRequest wreqItem; wreqItem = getWriteRequest(item); wrList.add(wreqItem);...