Tutorial by Examples: e

JasperSoft Studio In Preview, run report by clicking green arrow, if no errors the export menu will be enable, click the export button (disk image) and select "Export As Pdf"

A sprite sheet by definition is a bitmap that contains a certain animation. Old games use grid type sprite sheet, that is, every frame occupies an equal region, and frames are aligned by the edges to form a rectangle, probably with some spaces unoccupied. Later, in order to minimize the bitmap size,...

services/my.service.ts import { Injectable } from '@angular/core'; @Injectable() export class MyService { data: any = [1, 2, 3]; getData() { return Promise.resolve(this.data); } } getData() now acts likes a REST call that creates a Promise, which gets resolved imme...

Using unserialize function to unserialize data from user input can be dangerous. A Warning from php.net Warning Do not pass untrusted user input to unserialize(). Unserialization can result in code being loaded and executed due to object instantiation and autoloading, and a malicious user may ...

The Singleton pattern is designed to restrict creation of a class to exactly one single instance. This pattern is used in a scenario where it makes sense to have only one of something, such as: a single class that orchestrates other objects' interactions, ex. Manager class or one class that rep...

Detailed instructions on getting iOS 9 set up or installed.

An INNER JOIN is a JOIN operation that allows you to specify an explicit join clause. Syntax TableExpression [ INNER ] JOIN TableExpression { ON booleanExpression | USING clause } You can specify the join clause by specifying ON with a boolean expression. The scope of expressions in the ON c...

A LEFT OUTER JOIN performs a join between two tables that requires an explicit join clause but does not exclude unmatched rows from the first table. Example: SELECT ENAME, DNAME, ...

A RIGHT OUTER JOIN performs a join between two tables that requires an explicit join clause but does not exclude unmatched rows from the second table. Example: SELECT ENAME, DNAME, ...

A FULL OUTER JOIN performs a join between two tables that requires an explicit join clause but does not exclude unmatched rows in either table. In other words, it returns all the rows in each table. Example: SELECT * ...

A semijoin query can be used, for example, to find all departments with at least one employee whose salary exceeds 2500. SELECT * FROM departments WHERE EXISTS (SELECT 1 FROM employees WHERE departments.department_id = employees.department_id AND employees.salary > 25...

reduce(_:combine:) can be used in order to combine the elements of a sequence into a single value. It takes an initial value for the result, as well as a closure to apply to each element – which will return the new accumulated value. For example, we can use it to sum an array of numbers: let numbe...

Normal Update UPDATE TESTTABLE SET TEST_COLUMN= 'Testvalue',TEST_COLUMN2= 123 WHERE EXISTS (SELECT MASTERTABLE.TESTTABLE_ID FROM MASTERTABLE WHERE ID_NUMBER=11);

Using Inline View (If it is considered updateable by Oracle) Note: If you face a non key preserved row error add an index to resolve the same to make it update-able UPDATE (SELECT TESTTABLE.TEST_COLUMN AS OLD, 'Testvalue' AS NEW FROM TESTTA...

Using Merge MERGE INTO TESTTABLE USING (SELECT T1.ROWID AS RID, T2.TESTTABLE_ID FROM TESTTABLE T1 INNER JOIN MASTERTABLE T2 ON TESTTABLE.TESTTABLE_ID = MASTERTABLE.TESTTABLE_ID WHERE...

Sometimes the default Scrapy user agent ("Scrapy/VERSION (+http://scrapy.org)") is blocked by the host. To change the default user agent open settings.py, uncomment and edit the following line to what ever you want. #USER_AGENT = 'projectName (+http://www.yourdomain.com)' For example ...

This example shows how to create a table, insert data, and select from the database using SQLAlchemy Core. For information re: the SQLAlchemy ORM, see here. First, we'll need to connect to our database. from sqlalchemy import create_engine engine = create_engine('sqlite://') The engine is ...

Reading line by line awk '/^>/ {printf("%s%s\t",(N>0?"\n":""),$0);N++;next;} {printf("%s",$0);} END {printf("\n");}' < input.fa one can read this awk script as: if the current line ($0) starts like a fasta header (^>). Then we prin...

download and linearize the 10 first FASTA sequences from UniProt: $ curl -s "ftp://ftp.uniprot.org/pub/databases/uniprot/current_release/knowledgebase/complete/uniprot_sprot.fasta.gz" |\ gunzip -c |\ awk '/^>/ {printf("%s%s\t",(N>0?"\n":""),$0);N...

In order to create a hotkey or hotstring that only triggers when certain windows are active or exist, you can put one or several of the following directives before the hotkey definition: #IfWinActive [, WinTitle, WinText] #IfWinExist [, WinTitle, WinText] #IfWinNotActive [, WinTitle, WinText] #I...