Tutorial by Examples: t

/* The result can be use for fast way to use columns on Insertion/Updates. Works with tables and views. Example: eTableColumns 'Customers' ColumnNames ------------------------------------------------------ Id, FName, LName, Email, PhoneNumber, PreferredContact INSERT INTO Customers (Id, ...

R-markdown code chunks R-markdown is a markdown file with embedded blocks of R code called chunks. There are two types of R code chunks: inline and block. Inline chunks are added using the following syntax: `r 2*2` They are evaluated and inserted their output answer in place. Block chunks hav...

1)First go through Paypal Developer web site and create an application. 2)Now open your manifest file and give the below permissions <uses-permission android:name="android.permission.INTERNET" /> <uses-permission android:name="android.permission.ACCESS_NETWORK_STATE"...

=QUERY(QUERY(A1:D6,"select C,SUM(D) group by C",1),"select Col2>0",1)

Preemptive basic authentication is the practice of sending http basic authentication credentials (username and password) before a server replies with a 401 response asking for them. This can save a request round trip when consuming REST apis which are known to require basic authentication. As descr...

Using HttpClient as RestTemplate's underlying implementation to create HTTP requests allows for automatic handling of basic authentication requests (an http 401 response) when interacting with APIs. This example shows how to configure a RestTemplate to achieve this. // The credentials are stored he...

get_template_part( 'foo/bar', 'page'); will require 'bar-page.php' from the directory 'foo'.

Phalcon uses db service by default to obtain connection to databases. Assuming you have an conguration file with database field set up, you can include or autoload following code to obtain connection with database for your project: $di->set('db', function () use ($config) { $dbconf = $conf...

Phalcon builds up some information about tables it is using, so it is possible to validate data being inserted to them without implementing everything by hand. Those are meta data for models. To speed up and prevent Phalcon from building Meta Data every time page is refreshed, it is possible to cach...

<?php //Create a new SQLite3 object from a database file on the server. $database = new SQLite3('mysqlitedb.db'); //Query the database with SQL $results = $database->query('SELECT bar FROM foo'); //Iterate through all of the results, var_dumping them onto the page while ($row = $resu...

In addition to using LIMIT SQL statements you can also use the SQLite3 function querySingle to retrieve a single row, or the first column. <?php $database = new SQLite3('mysqlitedb.db'); //Without the optional second parameter set to true, this query would return just //the first column of ...

Assume that we have a system that sends out daily reports over email in the form of attached CSV files and that we want to access these. function getCsvFromGmail() { // Get the newest Gmail thread based on sender and subject var gmailThread = GmailApp.search("from:[email protected] sub...

Using core debugger Node.js provides a build in non graphical debugging utility. To start the build in the debugger, start the application with this command: node debug filename.js Consider the following simple Node.js application contained in the debugDemo.js 'use strict'; function addTwoN...

The main reason that Nightwatch is so powerful, is because of it's excellent configuration file. Unlike most other testing frameworks, Nightwatch is fully configurable and customizable to different environments and technology stacks. .meteor/nightwatch.json The following configuration file is for...

To get Nightwatch working, you'll need a local copy of selenium which is a command-and-control server which manages automated browser instances. You'll also need a web browser which selenium can control, such as chromedriver or phantomjs. Add the following devDependencies to your package.json: { ...

In the root of your application should be a package.json file, where you can define scripts and devDependencies. { "name": "myapp", "version": "1.0.0", "scripts": { "start": "meteor --settings settings-development.json&q...

A basic Nightwatch installation for Meteor will have the following directories and files installed. /myapp /myapp/.meteor/nightwatch.json /client/main.html /client/main.js /client/main.css /tests /tests/nightwatch /tests/nightwatch/assertions /tests/nightwatch/commands /tests/nightwatch/da...

Nightwatch accepts a second globals.json configuration file which injects data into the test runner itself, very similar to how Meteor.settings makes data from the command line available throughout the app. globals.json { "default" : { "url" : "http://localhost:300...

Readable streams can be "piped," or connected, to writable streams. This makes data flow from the source stream to the destination stream without much effort. var fs = require('fs') var readable = fs.createReadStream('file1.txt') var writable = fs.createWriteStream('file2.txt') rea...

NDB relates models as python objects, which can be stored and accessed in the Appengine NoSQL datastore, available to all AppEngine applications. models.py from google.appengine.ext import ndb # https://cloud.google.com/appengine/docs/python/ndb/properties class Series(ndb.Model): &qu...