Tutorial by Examples: an

By using SQLCMD on Command Prompt

Command Structure is sqlcmd -S yourservername\instancename -d database_name -o outputfilename_withpath -Q "your select query" Switches are as follows -S for servername and instance name -d for source database -o for target outputfile (it will create output file) -Q fo...

Microsoft SQL Server • Export data in txt file by using SQLCMD

Wildcard Handling

When nothing matches a wildcard such as * in bash, it gets passed on as a literal * to the command, as if you had typed \*. However, zsh throws an error. Bash: duncan@K7DXS-Laptop-Arch:~/test$ echo *.txt *.txt duncan@K7DXS-Laptop-Arch:~/test$ touch abc.txt duncan@K7DXS-Laptop-Arch:~/test$ echo...

zsh • Main differences from bash

How can Cordova plugins be useful?

Cordova Plugins provide a common interface to interact with the native code. Each plugin has an intermediary JavaScript file that provides access to platform specific features.

Cordova • Cordova plugins: how to install, how they work, examples

Transparency

There are kinds 3 of transparency supported in pygame: colorkeys, Surface alphas, and per-pixel alphas. Colorkeys Makes a color fully transparent, or more accurately, making a color simply not be blit. If you have an image with a black rect inside you could set a colorkey to prevent the black colo...

pygame • Drawing on the screen

Evaluation and Math

You can set a variable to something with the eval() function by using something similar to the below code: var x = 10; var y = 20; var a = eval("x * y") + "<br>"; var b = eval("2 + 2") + "<br>"; var c = eval("x + 17") + "<br&...

JavaScript • Evaluating JavaScript

Open camara and photo gallery

index.html <!DOCTYPE html> <html> <head> <meta charset="utf-8"> <meta http-equiv="Content-Security-Policy" content="default-src *; script-src 'self' 'unsafe-inline' 'unsafe-eval' *; style-src 'self' 'unsafe-inline' *"/> ...

ionic-framework • Device camera and photo library access from Ionic application

Combining constants with flags

Using the IntDef#flag() attribute set to true, multiple constants can be combined. Using the same example in this topic: public abstract class Car { //Define the list of accepted constants @IntDef(flag=true, value={MICROCAR, CONVERTIBLE, SUPERCAR, MINIVAN, SUV}) //Tell the compi...

Android • Typedef Annotations: @IntDef, @StringDef

Android

Step 1: Go to root directory of project and open command line prompt cordova build --release android This generates an unsigned apk under \platforms\android\build\outputs\apk with the name android-release-unsigned.apk Step 2: Key generation for obtaining signed apk Syntax: keytool -genkey ...

Cordova • Make application released from Cordova CLI

Display the source code of an object

Objects that are not built-in To print the source code of a Python object use inspect. Note that this won't work for built-in objects nor for objects defined interactively. For these you will need other methods explained later. Here's how to print the source code of the method randint from the ran...

Python Language • Accessing Python source code and bytecode

Factory VS Service once-and-for-all

By definition: Services are basically constructor functions. They use ‘this’ keyword. Factories are simple functions hence return an object. Under the hood: Factories internally calls provider function. Services internally calls Factory function. Debate: Factories can run code before we retur...

AngularJS • Distinguishing Service vs Factory

Applying Transformations

Transformations can be applied to elements by adding a transform attribute: <circle cx="0" cy="0" r="50" transform="translate(50,50)"/> Or to groups of elements enclosed in <g> tags: <g transform="translate(50,50)"> <circle...

SVG • Transformation

Transformation functions

Translate translate moves graphics along specified vectors: <circle cx="0" cy="0" r="50" transform="translate(50,50)"/> The first value is the x translation, and the second the y. If the y is omitted, it will default to 0. Scale scale resizes elem...

SVG • Transformation

Command macros

0.6.0-dev In Julia v0.6 and later, command macros are supported in addition to regular string macros. A command macro invocation like mymacro`xyz` gets parsed as the macro call @mymacro_cmd "xyz" Note that this is similar to string macros, except with _cmd instead of _str. We typ...

Julia Language • String Macros

Defining an enumerated type

An enumerated type is a type that can hold one of a finite list of possible values. In Julia, enumerated types are typically called "enum types". For instance, one could use enum types to describe the seven days of the week, the twelve months of the year, the four suits of a standard 52-ca...

Julia Language • Enums

ManagedCamel

public class ManagedCamel implements Managed { public static final String REDIS_TEMPLATE = "redisTemplate"; public static final String LISTENER_CONTAINER = "listenerContainer"; public static final String REDIS_SERIALIZER = "redisSerializer"; privat...

apache-camel • Pub/Sub using Camel + Redis

Finding all instances of an entity class

All instances (objects) of an entity class can be loaded from the underlying database table as follows (akin to retrieving all rows from the table): Iterable<Foo> foos = fooRepository.findAll(); The findAll method is provided by the CrudRepository interface. It returns an Iterable instead ...

spring-data-jpa • Repositories

Finding a particular instance of an entity class by the identifier

A particular instance of an entity class can be loaded as follows: Foo foo = fooRepository.findOne(id); The findOne method is provided by the CrudRepository interface. It expects an identifier that uniquely identifies an entity instance (for instance, a primary key in a database table). The Java...

spring-data-jpa • Repositories

Finding all instances of an entity class with an attribute matching a specified value

All instances of an entity class with one of the class attributes matching a specified value can be retrieved as follows: public interface FooRepository extends CrudRepository<Foo, Long> { List<Foo> findAllByName(String name); } Invoking the findAllByName method results in the JP...

spring-data-jpa • Repositories

Some more important operations supported by node_redis.

Checking the Existence of Keys Sometimes you may need to check if a key already exists and proceed accordingly. To do so you can use exists() function as shown below: client.exists('key', function(err, reply) { if (reply === 1) { console.log('exists'); } else { cons...

Node.js • NodeJS with Redis

Change service tier of Azure SQL Database

You can scale-up or scale-down Azure SQL database using ALTER DATABASE statement: ALTER DATABASE WWI MODIFY (SERVICE_OBJECTIVE = 'P6') -- or ALTER DATABASE CURRENT MODIFY (SERVICE_OBJECTIVE = 'P2') If you try to change service level while changing service level of the current database is sti...

Microsoft SQL Server • Managing Azure SQL Database