Tutorial by Examples: d

CREATE TABLE all_binary_types( c_boolean boolean, c_binary binary ); Sample data: insert into all_binary_types values (0,1234); insert into all_binary_types values (1,4321); Note: For boolean, internally it stored as true or false. For binary, it will store base64 encoded value....

When using interop methods, you can use GetLastError API to get additional information on you API calls. DllImport Attribute SetLastError Attribute SetLastError=true Indicates that the callee will call SetLastError (Win32 API function). SetLastError=false Indicates that the callee will not call...

img{ float:left; width:100px; margin:0 10px; } .div1{ background:#f1f1f1; /* does not create block formatting context */ } .div2{ background:#f1f1f1; overflow:hidden; /* creates block formatting context */ } https://jsfiddle.net/MadalinaTn/qkwwmu6m/2/ Using the o...

HTML: <div class="wrapper"> <div class="outer"> <div class="inner"> centered </div> </div> </div> CSS: .wrapper { height: 600px; text-align: center; } .outer { display: table; ...

Typed holes can make it easier to define functions, through an interactive process. Say you want to define a class instance Foo Bar (for your custom Bar type, in order to use it with some polymorphic library function that requires a Foo instance). You would now traditionally look up the documentati...

Redis has publish/subscribe for sending messages. This is handled by subscribing to a channel & publishing to channel. Yes, subscribers will subscribe to one or more channels. Publisher need not know who are all subscribers. Instead, publisher will publish to specific channel. All the subscriber...

Most basic Django debugging tool is pdb, a part of Python standard library. Init view script Let's examine a simple views.py script: from django.http import HttpResponse def index(request): foo = 1 bar = 0 bug = foo/bar return HttpResponse("%d goes here." % ...

To check for location services we need real device but for testing purpose we can also use simulator and add our own location by following below steps: add new GPX file into your project. in GPX file add waypoints like <?xml version="1.0"?> <gpx version="1.1" cre...

git clean -f Will remove all untracked files.

Introduction Play has several plugins for different IDE-s. The eclipse plugin allows to transform a Play application into a working eclipse project with the command activator eclipse. Eclipse plugin may be set per project or globally per sbt user. It depends on team work, which approach should be u...

New build systems can be created from the menu (Tools | Build System | New Build System). { "shell_cmd": "somecommand -u \"$file\"", "result_file_regex": "^[ ]*File \"(.*?)\"", "result_line_regex": "^[ ]*File ...

When creating the project You should check "Include Unit Tests" in the project creation dialog. After creating the project If you missed checking that item while creating your project, you could always add test files later. To do so: 1- Go to your project settings in Xcode 2- Go to ...

To get started with unit testing, which will be done in the tests file and will be testing the View Controller and Storyboard, we should introduce these two files to the test file. Defining the View Controller Swift var viewController : ViewController! Introducing the Storyboard and initializi...

According to Apple: Test Methods A test method is an instance method of a test class that begins with the prefix test, takes no parameters, and returns void, for example, (void)testColorIsRed(). A test method exercises code in your project and, if that code does not produce the expected result, ...

To stop the Handler from execution remove the callback attached to it using the runnable running inside it: Runnable my_runnable = new Runnable() { @Override public void run() { // your code here } }; public Handler handler = new Handler(); // use 'new Handler(Looper.get...

In order to call a function through a function pointer, the function pointer's type must exactly match the function's type. Otherwise, the behaviour is undefined. Example: int f(); void (*p)() = reinterpret_cast<void(*)()>(f); p(); // undefined

To build up an expression like _ => _.Field == "VALUE" at runtime. Given a predicate _ => _.Field and a string value "VALUE", create an expression that tests whether or not the predicate is true. The expression is suitable for: IQueryable<T>, IEnumerable<T>...

OOP - Object Oriented Programming is a vastly used programming paradigm in these days. In OOP, we model real world problems using Objects and there behaviors, in order to solve them, programmatically. There are four main OOP Concepts Inheritance Polymorphism Abstraction Encapsulation These...

To get versionName and versionCode of current build of your application you should query Android's package manager. try { // Reference to Android's package manager PackageManager packageManager = this.getPackageManager(); // Getting package info of this application PackageInfo...

To get the time at which your app was installed or updated, you should query Android's package manager. try { // Reference to Android's package manager PackageManager packageManager = this.getPackageManager(); // Getting package info of this application PackageInfo info = pack...