Tutorial by Examples: s

CREATE TABLE mytable (number INT); INSERT INTO mytable VALUES (1); CREATE MATERIALIZED VIEW myview AS SELECT * FROM mytable; SELECT * FROM myview; number -------- 1 (1 row) INSERT INTO mytable VALUES(2); SELECT * FROM myview; number -------- 1 (1 row) REFRESH ...

Java code: public class StdioApplication { public static void main(String[] args) { new ClassPathXmlApplicationContext("classpath:spring/integration/stackoverflow/stdio/stdio.xml"); } } Xml config file <?xml version="1.0" encoding="UTF-8"?&...

This example demonstrates how to develop a simple UWP application. On creation of a "Blank App (Universal Windows)" project there are many essential files that are created in your solution. All files in your project can be seen in the Solution Explorer. Some of the crucial files in your...

using System; using System.Speech.Synthesis; using System.Windows; namespace Stackoverflow.SpeechSynthesisExample { public partial class SpeechSynthesisSample : Window { public SpeechSynthesisSample() { InitializeComp...

The non-null assertion operator, !, allows you to assert that an expression isn't null or undefined when the TypeScript compiler can't infer that automatically: type ListNode = { data: number; next?: ListNode; }; function addNext(node: ListNode) { if (node.next === undefined) { nod...

This example demonstrates how a cross origin http request can be handled using a middleware. CORS Background CORS is an access control method adopted by all major browsers to avert Cross Scripting Vulnerabilities inherent by them. In general browser security, scripts should maintain that all XHR r...

Once you got a collection object, queries use the same syntax as in the mongo shell. Some slight differences are: every key must be enclosed in brackets. For example: db.find({frequencies: {$exists: true}}) becomes in pymongo (note the True in uppercase): db.find({"frequencies": ...

Let's say you need to add a field to every document in a collection. import pymongo client = pymongo.MongoClient('localhost', 27017) db = client.mydb.mycollection for doc in db.find(): db.update( {'_id': doc['_id']}, {'$set': {'newField': 10} }, upsert=False, multi=False...

Previously, datatables were initialized as follows: var oTable = $("#selector").dataTable(); This used to return a jQuery object which would stored in the variable oTable. And then to access the api to modify table properties, we had to initialize the api differently, as shown below: ...

The following 3 features (that were deprecated in 1.9) are no longer available in 1.10, they are : fnRender: According to the deverloper: The old fnRender option provided a method of manipulating a cell when it was created. however, it was provided with a confusing list of options as its a...

Conditional predicate will be cleaner and safer by using the NSCompoundPredicate class which provides basic boolean operators for the given predicates. Objective-c AND - Condition NSPredicate *predicate = [NSPredicate predicateWithFormat:@"samplePredicate"]; NSPredicate *anotherPre...

This approach was introduced in JSR 286. In JSR 168,render parameters set in processAction of a portlet were available only in that portlet.With the Public Render Parameters feature, the render parameters set in the processAction of one portlet will be available in render of other portlets also.In ...

This is one approach which has been there since JSR 168.It allows us to share attributes using portlet session.A portlet session can have different types of scopes: Portlet scope(attributes available only within portlet) Application scope(attributes available within whole application[war]) In...

The eventing mechanism is an extended version of the public render param,with additonal feature to pass custom objects to other portlets,but with an overhead of event phase. To achieve this,this mechanism consists of Publisher portlet Processor(consumer) portlet,where both may be part of differ...

We assume a fully working UIScrollview named _scrollView; Note that UITableView, UICollectionView are also scrollviews, hence the following examples would work on those UI elements. First, creation & allocation UIRefreshControl refreshControl = new UIRefreshControl(); Second, connecting th...

This example will register an vuex module dynamically for storing custom notifications that can automatically dismissed notifications.js resolve vuex store and define some constants //Vuex store previously configured on other side import _store from 'path/to/store'; //Notification default dur...

While performing a git merge you may find that git reports a "merge conflict" error. It will report to you which files have conflicts, and you will need to resolve the conflicts. A git status at any point will help you see what still needs editing with a helpful message like On branch ma...

You can import an SVG file as a VectorDrawable in Android Studio, follow these steps : "Right-click" on the res folder and select new > Vector Asset. Select the Local File option and browse to your .svg file. Change the options to your liking and hit next. Done.

probably the most common misconception about asnycio is that it lets you run any task in parallel - sidestepping the GIL (global interpreter lock) and therefore execute blocking jobs in parallel (on separate threads). it does not! asyncio (and libraries that are built to collaborate with asyncio) b...

Temp tables must have unique IDs (within the session, for local temp tables, or within the server, for global temp tables). Trying to create a table using a name that already exists will return the following error: There is already an object named '#tempTable' in the database. If your query pro...