Tutorial by Examples: s

Updating one row UPDATE customers SET email='[email protected]' WHERE id=1 This query updates the content of email in the customers table to the string [email protected] where the value of id is equal to 1. The old and new contents of the database table are illustrated below on the left an...

Unlike other middleware functions error-handling middleware functions have four arguments instead of three: (err, req, res, next). Sample: app.use(function(err, req, res, next) { console.error(err.stack); res.status(500).send('Error found!'); });

Even when all your work is directed at a single worksheet, it's still a very good practice to explicitly specify the worksheet in your code. This habit makes it much easier to expand your code later, or to lift parts (or all) of a Sub or Function to be re-used someplace else. Many developers establi...

Given a file sample: hello Hello HELLO_there A normal grep for "hello" returns: $ grep "hello" sample hello Using -i allows to ignore case and match any "hello": $ grep -i "hello" sample hello Hello HELLO_there

Given a file sample: hello world ahello here hello_there A normal grep for "hello" returns: $ grep hello sample hello world ahello here hello_there Using -w allows to select those lines containing matches that form whole words: $ grep -w hello sample hello world

DBContract.java //Define the tables and columns of your local database public final class DBContract { /*Content Authority its a name for the content provider, is convenient to use the package app name to be unique on the device */ public static final String CONTENT_AUTHORITY =...

This object, Shape has a property image that depends on numberOfSides and sideWidth. If either one of them is set, than the image has to be recalculated. But recalculation is presumably long, and only needs to be done once if both properties are set, so the Shape provides a way to set both propertie...

In C#, types can define custom Conversion Operators, which allow values to be converted to and from other types using either explicit or implicit casts. For example, consider a class that is meant to represent a JavaScript expression: public class JsExpression { private readonly string expres...

Suppose you have types like the following: interface IThing { } class Thing : IThing { } LINQ allows you to create a projection that changes the compile-time generic type of an IEnumerable<> via the Enumerable.Cast<>() and Enumerable.OfType<>() extension methods. IEnumerabl...

A Closure is a function taken together with an environment. The function is typically an anonymous function defined inside another function. The environment is the lexical scope of the enclosing function (very basic idea of a lexical scope of a function would be the scope that exists between the fun...

Suppose you have many changes in one or more files but from each file you only want to commit some of the changes, you can select the desired changes using: git add -p or git add -p [file] Each of your changes will be displayed individually, and for each change you will be prompted to choose...

A simple context tree (containing some common values that might be request scoped and included in a context) built from Go code like the following: // Pseudo-Go ctx := context.WithValue( context.WithDeadline( context.WithValue(context.Background(), sidKey, sid), time.Now().A...

A database is created with the following SQL command: CREATE DATABASE myDatabase; This would create an empty database named myDatabase where you can create tables.

Matplotlib supports both object-oriented and imperative syntax for plotting. The imperative syntax is intentionally designed to be very close to Matlab syntax. The imperative syntax (sometimes called 'state-machine' syntax) issues a string of commands all of which act on the most recent figure or a...

First, ensure you have imported sessions from flask from flask import session To use session, a Flask application needs a defined SECRET_KEY. app = Flask(__name__) app.secret_key = 'app secret key' Sessions are implemented by default using a cookie signed with the secret key. This ensures t...

defaultProps allows you to set default, or fallback, values for your component props. defaultProps are useful when you call components from different views with fixed props, but in some views you need to pass different value. Syntax ES5 var MyClass = React.createClass({ getDefaultProps: ...

propTypes allows you to specify what props your component needs and the type they should be. Your component will work without setting propTypes, but it is good practice to define these as it will make your component more readable, act as documentation to other developers who are reading your compone...

Modern A weak reference looks like one of these: @property (weak) NSString *property; NSString *__weak variable; If you have a weak reference to an object, then under the hood: You're not retaining it. When it gets deallocated, every reference to it will automatically be set to nil Obje...

Register a production/sandbox account at https://dashboard.stripe.com/register Insert below code into your webpage where you want to have a checkout button. <form action="/charge" method="POST"> <script src="https://checkout.stripe.com/checkout.js" cl...

A word of caution: AsyncTask has many gotcha's apart from the memory leak described here. So be careful with this API, or avoid it altogether if you don't fully understand the implications. There are many alternatives (Thread, EventBus, RxAndroid, etc). One common mistake with AsyncTask is to c...