Tutorial by Examples: at

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...

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...

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...

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...

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')

WRITE record COMMIT

Peudo-random generators are frequently useful when designing simulation environments. The following VHDL package shows how to use protected types to design a pseudo-random generator of boolean, bit and bit_vector. It can easily be extended to also generate random std_ulogic_vector, signed, unsigned....

JS // data model var person = { name: ko.observable('Jack'), age: ko.observable(29) }; ko.applyBindings(person); HTML <div> <p>Name: <input data-bind='value: name' /></p> <p>Age: <input data-bind='value: age' /></p> &l...

If we want to display a jquery calendar for end user who can pick maximum date as current date in the calendar. The below code will useful to this scenario. <?php use yii\jui\DatePicker; use yii\widgets\ActiveForm; ?> <?php $form = ActiveForm::begin(['id' => 'profile-form']); ?&gt...

For some forms you want display the days from future/past days and other days need to disabled, then this scenario will help. <?php use yii\jui\DatePicker; use yii\widgets\ActiveForm; ?> <?php $form = ActiveForm::begin(['id' => 'profile-form']); ?> ..... <?php $day = '+...

If you want to have calendar for from date and to date and also to date calendar days always will be greater than from date field, then below scenario will help. <?php $form = ActiveForm::begin(['id' => 'profile-form']); ?> ..... <?= $form->field($model, 'from_date')->widget(D...

app.js angular.module('myApp', ['ui.router']) .service('User', ['$http', function User ($http) { this.getProfile = function (id) { return $http.get(...) // method to load data from API }; }]) .controller('profileCtrl', ['profile', function profileCtrl (profile) { // i...

url: /api/data/v8.0/annotations json: { "isdocument": true, "mimetype": "text/plain", "documentbody": "dGVzdA==", "[email protected]" : "/accounts(c6da77b6-d53e-e611-80b9-0050568a6c2d)", "...

url: /api/data/v8.0/accounts json: { "name" : "New account" }

url: /api/data/v8.0/contacts json: { "firstname" : "New", "lastname" : "Contact", "[email protected]" : "/accounts(c6da77b6-d53e-e611-80b9-0050568a6c2d)" } As the parentcustomerid can be an account or ...

First of all download Yii Booster latest end user bundle from here. Download it, unpack its contents to some directory inside your web application. Its recomended to unpack it to the extensions directory. Rename the folder from yiibooster-<version_number> to just yiibooster for convenience. ...

Enabling Attribute Routing To enable attribute routing, call MapMvcAttributeRoutes during configuration. public static void RegisterRoutes(RouteCollection routes) { routes.IgnoreRoute(“{resource}.axd/{*pathInfo}”); routes.MapMvcAttributeRoutes(); routes.MapRoute( name: “Default”, ...

Let's explore the syntax differences by comparing two code examples. React.createClass (deprecated) Here we have a const with a React class assigned, with the render function following on to complete a typical base component definition. import React from 'react'; const MyComponent = React.crea...