Tutorial by Examples: e

Lets say you want to filter a query by two columns, but only certain combinations of those columns. For example, it's OK to have account 60400 with reference JE, but you cannot have account 60400 with reference ED, but you can have account 60500 with reference ED. select * from schema.table where ...

# 1. Login Azure by admin account Add-AzureAccount # # 2. Select subscription name $subscriptionName = Get-AzureSubscription | Select -ExpandProperty SubscriptionName # # 3. Create storage account $storageAccountName = $VMName # here we use VMName to play the storage account name and create...

First off you create the form @using (Html.BeginForm()) { @Html.AntiForgeryToken() } Action Method [HttpPost] [ValidateAntiForgeryToken] public ActionResult Test(FormViewModel formData) { // ... } Script <script src="https://code.jquery.com/jquery-1.12.4.min.js"&g...

Data Access Object(DAO) design pattern is a standard J2EE design pattern. In this design pattern data is accessed through classes containing methods to access data from databases or other sources, which are called data access objects. Standard practice assumes that there are POJO classes. DAO can b...

The Bluetooth specification contains several profile specifications. A profile describes how to use and implement a function. They can depend on each other, here is a basic layout of the most common profile dependencies All profiles can be found at BT SIG, be aware that different versions might ...

Exchange/convert a partition to a non-partitioned table and vice versa. This facilitates a fast "move" of data between the data segments (opposed to doing something like "insert...select" or "create table...as select") as the operation is DDL (the partition exchange ope...

ValueExpression ve = AdfmfJavaUtilities.getValueExpression(<binding>, String.class); String <variable_name> = (String) ve.getValue(AdfmfJavaUtilities.getELContext()); Here "binding" indicates the EL expression from which the value is to be get. "variabl...

ValueExpression ve = AdfmfJavaUtilities.getValueExpression(<binding>, String.class); ve.setValue(AdfmfJavaUtilities.getELContext(), <value>); Here "binding" indicates the EL expression to which the value is to be stored. "value" is the desired val...

AdfELContext adfELContext = AdfmfJavaUtilities.getAdfELContext(); MethodExpression me; me = AdfmfJavaUtilities.getMethodExpression(<binding>, Object.class, new Class[] { }); me.invoke(adfELContext, new Object[] { }); "binding" indicates the EL expression from wh...

page.js var context = { items: [ {id: 1, name: "Foo"}, {id: 2, name: "Bar"}, {id: 3, name: "Joe"} ] } exports.loaded = function(args){ var page = args.object; page.bindingContext = context; } exports.showEntry = functi...

Oracle (11g and above) allows the SQL queries to be cached in the SGA and reused to improve performance. It queries the data from cache rather than database. Subsequent execution of same query is faster because now the data is being pulled from cache. SELECT /*+ result_cache */ number FROM main_tab...

Achieving multitenancy on database server with multiple databases hosted on it. Multitenancy is common requirement of enterprise application nowadays and creating connection pool for each database in database server is not recommended. so, what we can do instead is create connection pool with datab...

When you call store.dispatch(actionObject) it is handled synchronously. I.e. reducers would be called and your store listeners would be notified, your react views would be re-rendered on each dispatched action. Middleware is what enables you to delay dispatching or even dispatch different actions ...

Another approach to handling asynchrony in Redux is to use action creators. In Flux, action creators are special functions that construct action objects and dispatch them. myActionCreator(dispatch) { dispatch({ type: "ASYNC_ACTION_START" }); setTimeout(() => { dispatch({ typ...

import pandas as pd data = [ {'name': 'Daniel', 'country': 'Uganda'}, {'name': 'Yao', 'country': 'China'}, {'name': 'James', 'country': 'Colombia'}, ] df = pd.DataFrame(data) filename = 'people.csv' df.to_csv(filename, index=False, encoding='utf-8')

The Python function import_csv_to_dynamodb(table_name, csv_file_name, colunm_names, column_types) below imports a CSV file into a DynamoDB table. Column names and column must be specified. It uses boto. Below is the function as well as a demo (main()) and the CSV file used. import boto MY_ACCESS...

REpresentational State Transfer (REST) is an architectural style used for web development, introduced and defined in 2000 by Roy Fielding. See it on wiki : REST wiki It's based on HTTP protocol (HTTP on Wiki), HTTP requests (GET, POST, PATCH, DELETE...) / responses codes (404, 400, 200, 201, 500.....

Instead of gem 'rails' You can specify a github user/repo combination with gem 'rails', github: 'rails/rails'

WRITE record COMMIT

This example shows how you can use IIS Rewrite rules to force HTTPS by making all HTTP requests return a 301 (Permanent) Redirect to the HTTPS page. This is usually better than using the [RequireHttps] attribute because the attribute uses a 302 redirect, and being in the MVC pipeline it is much slo...