Tutorial by Examples: e

Installation or Setup

In short: XPages is part of IBM Domino Designer. Extra setup or installation isn't required for XPages. First XPage / Hello-World-Example To create your first XPage you have to create a new NSF first. Open the IBM Domino Designer, and open the menu "File" -> "New" -> &...

xpages • Getting started with xpages

Hello world! from table

Create a simple table create table MY_table ( what varchar2(10), who varchar2(10), mark varchar2(10) ); Insert values (you can omit target columns if you provide values for all columns) insert into my_table (what, who, mark) values ('Hello', 'world', '!' ); insert into my_table ...

Oracle Database • Getting started with Oracle Database

Working with databases

One of ColdFusion's strengths is how easy it is to work with databases. And of course, query inputs can and should be parameterized. Tag Implementation <cfquery name="myQuery" datasource="myDatasource" result="myResult"> select firstName, lastName from...

coldfusion • Database Queries

Declaring a HashSet with values

You can create a new class that inherits from HashSet: Set<String> h = new HashSet<String>() {{ add("a"); add("b"); }}; One line solution: Set<String> h = new HashSet<String>(Arrays.asList("a", "b")); Using guava: Se...

Java Language • Sets

Substitution Using Shell Variables

Variables inside single quotes ' don't get expanded by POSIX compatible shells, so using a shell variable in a sed substitution requires the use of double quotes " instead of single quotes ': $ var="he" $ echo "hello" | sed "s/$var/XX/" XXllo $ var="he&q...

sed • Substitution

Timing Out with Interrupt and then Kill

c := exec.Command(name, arg...) b := &bytes.Buffer{} c.Stdout = b c.Stdin = stdin if err := c.Start(); err != nil { return nil, err } timedOut := false intTimer := time.AfterFunc(timeout, func() { log.Printf("Process taking too long. Interrupting: %s %s", name, strings...

Go • Executing Commands

Simple Command Execution

// Execute a command a capture standard out. exec.Command creates the command // and then the chained Output method gets standard out. Use CombinedOutput() // if you want both standard out and standerr output out, err := exec.Command("echo", "foo").Output() if err != nil { ...

Go • Executing Commands

Executing a Command then Continue and Wait

cmd := exec.Command("sleep", "5") // Does not wait for command to complete before returning err := cmd.Start() if err != nil { log.Fatal(err) } // Wait for cmd to Return err = cmd.Wait() log.Printf("Command finished with error: %v", err)

Go • Executing Commands

Select rows that match a condition

Generally, the syntax is: SELECT <column names> FROM <table name> WHERE <condition> For example: SELECT FirstName, Age FROM Users WHERE LastName = 'Smith' Conditions can be complex: SELECT FirstName, Age FROM Users WHERE LastName = 'Smith' AND (City = 'New York' OR C...

Microsoft SQL Server • Getting started with Microsoft SQL Server

Include Guards

A header file may be included by other header files. A source file (compilation unit) that includes multiple headers may therefore, indirectly, include some headers more than once. If such a header file that is included more than once contains definitions, the compiler (after preprocessing) dete...

C++ • Preprocessor

Aliases & Similar Functions

In PowerShell, there are many ways to achieve the same result. This can be illustrated nicely with the simple & familiar Hello World example: Using Write-Host: Write-Host "Hello World" Using Write-Output: Write-Output 'Hello world' It's worth noting that although Write-Outp...

PowerShell • Getting started with PowerShell

Execution of a JavaScript file in MongoDB

./mongo localhost:27017/mydb myjsfile.js Explanation: This operation executes the myjsfile.js script in a mongo shell that connects to the mydb database on the mongod instance accessible via the localhost interface on port 27017. localhost:27017 is not mandatory as this is the default port mongo...

MongoDB • Getting started with MongoDB

Uppercase and Lowercase Strings

To make all the characters in a String uppercase or lowercase: 2.2 let text = "AaBbCc" let uppercase = text.uppercaseString // "AABBCC" let lowercase = text.lowercaseString // "aabbcc" 3.0 let text = "AaBbCc" let uppercase = text.uppercased() // &qu...

Swift Language • Strings and Characters

Basic API Usage

It can also be installed by downloading the source code and placing it in a directory of your project. However there are many benefits to using composer. require '/path/to/lib/Twig/Autoloader.php'; Twig_Autoloader::register(); $loader = new Twig_Loader_Filesystem('/path/to/templates'); $opti...

twig • Getting started with twig

Installation or Setup

Basic installation: You can download redux javascript file, using this link. Also you can install redux, using bower : bower install https://npmcdn.com/redux@latest/dist/redux.min.js Next, you need to include redux to your page: <html> <head> <script type="text/jav...

redux • Getting started with redux

Filtering an array

In order to filter out values from an array and obtain a new array containing all the values that satisfy the filter condition, you can use the array_filter function. Filtering non-empty values The simplest case of filtering is to remove all "empty" values: $my_array = [1,0,2,null,3,'',...

PHP • Manipulating an Array

Get product by sku

$sku = 'sku-goes-here'; $product = Mage::getModel('catalog/product')->loadByAttribute('sku', $sku);

magento • Get Products from Database

Get product by ID

$id = 1; $product = Mage::getModel('catalog/product')->load($id); if($product->getId()){ //product was found }

magento • Get Products from Database

Product collection - LIKE query

$collection = Mage::getModel('catalog/product')->getCollection(); $collection->addAttributeToFilter('sku', array('like' => 'UX%'));

magento • Get Products from Database

Get product collection by attribute

$collection = Mage::getModel('catalog/product')->getCollection(); // Using operator $collection->addAttributeToFilter('status', array('eq' => 1)); // Without operator (automatically uses 'equal' operator $collection->addAttributeToFilter('status', 1);

magento • Get Products from Database