Tutorial by Examples: en

MySQL3.19 DROP TABLE IF EXISTS MyTable; PostgreSQL8.x DROP TABLE IF EXISTS MyTable; SQL Server2005 If Exists(Select * From Information_Schema.Tables Where Table_Schema = 'dbo' And Table_Name = 'MyTable') Drop Table dbo.MyTable SQLite3.0 DROP TABLE IF EXI...

Use this option if your project requires an Application subclass. Specify this Application subclass using the android:name property in the manifest file inside the application tag. In the Application subclass, add the attachBaseContext() method override, and in that method call MultiDex.install():...

You can use ReactJS's components easily in TypeScript. Just rename the 'jsx' file extension to 'tsx': //helloMessage.tsx: var HelloMessage = React.createClass({ render: function() { return <div>Hello {this.props.name}</div>; } }); ReactDOM.render(<HelloMessage name=&q...

To match something that does not contain a given string, one can use negative lookahead: Regex syntax: (?!string-to-not-match) Example: //not matching "popcorn" String regexString = "^(?!popcorn).*$"; System.out.println("[popcorn] " + ("popcorn".matches(r...

Using a Template Engine The following code will setup Jade as template engine. (Note: Jade has been renamed to pug as of December 2015.) const express = require('express'); //Imports the express module const app = express(); //Creates an instance of the express module const PORT = 3000; //Ra...

Data Model public class Item { private String name; public String getName() { return name; } public void setName(String name){ this.name = name; } } Layout XML <?xml version="1.0" encoding="utf-8"?> <layout xmlns:an...

If you want to parse a String to enum with Gson: {"status" : "open"} public enum Status { @SerializedName("open") OPEN, @SerializedName("waiting") WAITING, @SerializedName("confirm") CONFIRM, @SerializedName(&...

SELECT s.name + '.' + t.NAME AS TableName, SUM(a.used_pages)*8 AS 'TableSizeKB' --a page in SQL Server is 8kb FROM sys.tables t JOIN sys.schemas s on t.schema_id = s.schema_id LEFT JOIN sys.indexes i ON t.OBJECT_ID = i.object_id LEFT JOIN sys.partitions p ON i.object_id = ...

You can customize your theme’s color palette. Using framework APIs 5.0 <style name="AppTheme" parent="Theme.Material"> <item name="android:colorPrimary">@color/primary</item> <item name="android:colorPrimaryDark">@color/pri...

XML elements often nest, have data in attributes and/or as character data. The way to capture this data is by using ,attr and ,chardata respectively for those cases. var doc = ` <parent> <child1 attr1="attribute one"/> <child2>and some cdata</child2> </p...

The primary task of the manifest is to inform the system about the app's components. For example, a manifest file can declare an activity as follows: <?xml version="1.0" encoding="utf-8"?> <manifest ... > <application android:icon="@drawable/app_icon.pn...

The goal is to generate the following XML document: <FruitBasket xmlns="http://www.fruitauthority.fake"> <Fruit ID="F0001"> <FruitName>Banana</FruitName> <FruitColor>Yellow</FruitColor> </Fruit> <Fruit ID="F000...

Mage::app()->getStore()->getFrontendName();

Mage::app()->getStore()->getStoreId();

Mage::app()->getStore()->getCode(); This returns store code, e.g. 'en' for a storefront that is setup for English and called 'en', and not the numerical id.

Mage::app()->getStore()->getIsActive();

Mage::app()->getStore()->getWebsiteId();

Mage::app()->getStore(); Returns an instance of Mage_Core_Model_Store

It is possible to await multiple calls concurrently by first invoking the awaitable tasks and then awaiting them. public async Task RunConcurrentTasks() { var firstTask = DoSomethingAsync(); var secondTask = DoSomethingElseAsync(); await firstTask; await secondTask; } Alt...

Matplotlib axes are two-dimensional by default. In order to create three-dimensional plots, we need to import the Axes3D class from the mplot3d toolkit, that will enable a new kind of projection for an axes, namely '3d': import matplotlib.pyplot as plt from mpl_toolkits.mplot3d import Axes3D fi...