Tutorial by Examples: f

Basic PL/pgSQL Trigger Function

This is a simple trigger function. CREATE OR REPLACE FUNCTION my_simple_trigger_function() RETURNS trigger AS $BODY$ BEGIN -- TG_TABLE_NAME :name of the table that caused the trigger invocation IF (TG_TABLE_NAME = 'users') THEN --TG_OP : operation the trigger was fired IF (TG_O...

postgresql • Triggers and Trigger Functions

Setting and getting pixel values of a Gray image in C++

// PixelAccessTutorial.cpp : Defines the entry point for the console // Environment: Visual studio 2015, Windows 10 // Assumptions: Opecv is installed configured in the visual studio project // Opencv version: OpenCV 3.1 #include "stdafx.h" #include<opencv2/core/core.hpp> #i...

opencv • Pixel Access

Angular 2 for-loop

For live plnkr click... <!doctype html> <html> <head> <title>ng for loop in angular 2 with ES5.</title> <script type="text/javascript" src="https://code.angularjs.org/2.0.0-alpha.28/angular2.sfx.dev.js"></script> <scr...

Angular 2 • Angular - ForLoop

Reading .gz textfile line after line

This class open a .gz file (usual format of compressed log files) and will return a line at each call of .NextLine() There is no memory usage for temporary decompression, very useful for large file. Imports System.IO Class logread_gz Private ptr As FileStream Private UnGZPtr As Compress...

Visual Basic .NET Language • Reading compressed textfile on-the-fly

Extract the text contents from a div with a particular id

Taggy-lens allows us to use lenses to parse and inspect HTML documents. #!/usr/bin/env stack -- stack --resolver lts-7.0 --install-ghc runghc --package text --package lens --package taggy-lens {-# LANGUAGE OverloadedStrings #-} import qualified Data.Text.Lazy as TL import qualified Data.Tex...

Haskell Language • Parsing HTML with taggy-lens and lens

Array in CFScript

<cfscript> oneDimensionArray = ArrayNew(1); oneDimensionArray[1] = 1; oneDimensionArray[2] = 'one'; oneDimensionArray[3] = '1'; </cfscript> <cfif IsDefined("oneDimensionArray")> <cfdump var="#oneDimensionArray#"> </cfif>...

coldfusion • ColdFusion Arrays

Texture and Framebuffer

You can attach an image in a texture to a framebuffer, so that you can render directly to that texture. glGenFramebuffers (1, &framebuffer); glBindFramebuffer (GL_FRAMEBUFFER, framebuffer); glFramebufferTexture2D(GL_FRAMEBUFFER, GL_COLOR_ATTACHMENT0, ...

opengl • Texturing

Installation of OpenXML SDK and productivity tool on your computer

Go to the Microsoft link for the OpenXML SDK download. Click the red download button. On the next screen click the box next to OpenXMLSDKToolV25.msi and click next to begin the download. Once the download is complete, launch the OpenXMLSDKToolV25.msi and follow the instructions on the screen. Th...

openxml • Getting started with openxml

Creating a new project from the Game template.

To set up a default SceneKit project you can use the Game Template.

scenekit • Getting started with scenekit

Load an animation from a collada or scn file

Swift Function for loading an animation from a file: func animationFromSceneNamed(path: String) -> CAAnimation? { let scene = SCNScene(named: path) var animation:CAAnimation? scene?.rootNode.enumerateChildNodes({ child, stop in if let animKey = child.animationKeys.first...

scenekit • Animation

Extention FDW

FDW is an implimentation of dblink it is more helpful, so to use it: 1-Create an extention: CREATE EXTENSION postgres_fdw; 2-Create SERVER: CREATE SERVER name_srv FOREIGN DATA WRAPPER postgres_fdw OPTIONS (host 'hostname', dbname 'bd_name', port '5432'); 3-Create user mapping for postgres...

postgresql • EXTENSION dblink and postgres_fdw

Same Database Reference

The Same Database reference allows you to split a single database into multiple projects. This is useful for cases where a project is very large or where different teams manage different parts of the database. If you consider that you have two .sqlproj SSDT database projects with the following stru...

ssdt • Database References

Develop and Production Product Flavors Example

productFlavors { // Define separate dev and prod product flavors. dev { // dev utilizes minSDKVersion = 21 to allow the Android gradle plugin // to pre-dex each module and produce an APK that can be tested on // Android Lollipop without time c...

android-gradle • Configure Product Flavors

Installing Payara Server Full

Prerequisites JDK 1.7 or later installed. You can find the Oracle JDK's here. Steps Download Payara Server Full. Unzip the Payara Server at some location on your computer. We will use C:\payara41 as INSTALL_DIR for Windows users and /payara41 for Linux/Mac users. Starting / stopping Pa...

java-ee • Getting started with java-ee

Building my First JavaEE Application (Hello World)

Let's understand something. JavaEE consists of a number of specifications. When you install an Application Server (Payara for example), you install all of the specifications at once. For example there's a specification for an ORM called JPA (Java Persistence API), a specification to build Component ...

java-ee • Getting started with java-ee

Profiler Markup

Using the Profiler Class One very good practice is to use Profiler.BeginSample and Profiler.EndSample because it will have its own entry in the Profiler Window. Also, those tag will be stripped out on non-Development build using using ConditionalAttribute, so you don't need to remove them from you...

unity3d • Unity Profiler

Precedence of standard Swift operators

Operators that bound tighter (higher precedence) are listed first. OperatorsPrecedence group (≥3.0)PrecedenceAssociativity.∞left?, !, ++, --, [], (), {}(postfix)!, ~, +, -, ++, --(prefix)~> (swift ≤2.3)255left<<, >>BitwiseShiftPrecedence160none*, /, %, &, &*MultiplicationPrec...

Swift Language • Advanced Operators

DAX example formula

Previous Quarter Sales:=CALCULATE(FactSales[Sales], PREVIOUSQUARTER(DimDate[DateKey])) (Calculates the total sales for the previous quarter, based on the Sales column in the FactSales table and the DateKey in the DimDate table, depending on the filters applied in a PivotTable or PivotChart)

powerbi • Power Query (M) and DAX - What's the difference?

Migrate from Team Foundation Version Control (TFVC) to Git

You could migrate from team foundation version control to git by using an open source tool called Git-TF. Migration will also transfer your existing history by converting tfs checkins to git commits. To put your solution into Git by using Git-TF follow these steps: Download Git-TF You can downloa...

Git • Migrating to Git

Happens-before relationships

(The following is a simplified version of what the Java Language Specification says. For a deeper understanding, you need to read the specification itself.) Happens-before relationships are the part of the Memory Model that allow us to understand and reason about memory visibility. As the JLS say...

Java Language • Java Memory Model