Tutorial by Examples: me

This UNION ALL combines data from multiple tables and serve as a table name alias to use for your queries: SELECT YEAR(date_time_column), MONTH(date_time_column), MIN(DATE(date_time_column)), MAX(DATE(date_time_column)), COUNT(DISTINCT (ip)), COUNT(ip), (COUNT(ip) / COUNT(DISTINCT (ip))) AS Ratio ...

First of all, the problem of handling spaces in arguments is NOT actually a Java problem. Rather it is a problem that needs to be handled by the command shell that you are using when you run a Java program. As an example, let us suppose that we have the following simple program that prints the siz...

Sinse structs are value types all the data is copied on assignment, and any modification to the new copy does not change the data for the original copy. The code snippet below shows that p1 is copied to p2 and changes made on p1 does not affect p2 instance. var p1 = new Point { x = 1, y =...

To Import Google(Gmail) contacts in ASP.NET MVC application, first download "Google API setup" This will grant the following references: using Google.Contacts; using Google.GData.Client; using Google.GData.Contacts; using Google.GData.Extensions; Add these to the relevant applicatio...

Suppose you have a button in your Java program that counts down a time. Here is the code for 10 minutes timer. private final static long REFRESH_LIST_PERIOD=10 * 60 * 1000; //10 minutes Timer timer = new Timer(1000, new ActionListener() { @Override public void actionPerformed(ActionEve...

Create a class name ErrorMatcher inside your test package with below code: public class ErrorMatcher { @NonNull public static Matcher<View> withError(final String expectedErrorText) { Checks.checkNotNull(expectedErrorText); return new BoundedMatcher<View, ...

String macros do not come with built-in interpolation facilities. However, it is possible to manually implement this functionality. Note that it is not possible to embed without escaping string literals that have the same delimiter as the surrounding string macro; that is, although ""&quot...

What is a metaclass? In Python, everything is an object: integers, strings, lists, even functions and classes themselves are objects. And every object is an instance of a class. To check the class of an object x, one can call type(x), so: >>> type(5) <type 'int'> >>> typ...

You may have heard that everything in Python is an object. It is true, and all objects have a class: >>> type(1) int The literal 1 is an instance of int. Lets declare a class: >>> class Foo(object): ... pass ... Now lets instantiate it: >>> bar = Foo() Wh...

module main; auto getMemberNames(T)() @safe pure { string[] members; foreach (derived; __traits(derivedMembers, T)) { members ~= derived; } return members; } class Foo { int a; int b; } class Bar : Foo { int c; int d; int e...

A Consumer can only await values from upstream. type Consumer a = Proxy () a () X await :: Monad m => Consumer a m a For example: fancyPrint :: MonadIO m => Consumer String m () fancyPrint = forever $ do numStr <- await liftIO $ putStrLn ("I received: " ++ numStr) ...

pipes's core data type is the Proxy monad transformer. Pipe, Producer, Consumer and so on are defined in terms of Proxy. Since Proxy is a monad transformer, definitions of Pipes take the form of monadic scripts which await and yield values, additionally performing effects from the base monad m.

Mocking an interface that inherits from IEnumerable to return canned data is quite straightforward. Assuming the following classes: public class DataClass { public int Id { get; set; } } public interface IEnumerableClass : IEnumerable<DataClass> { } The following approach can ...

NumericUpDown is control that looks like TextBox. This control allow user to display/select number from a range. Up and Down arrows are updating the textbox value. Control look like; In Form_Load range can be set. private void Form3_Load(object sender, EventArgs e) { numericUpDown...

This example illustrates how to read various-type struct entries from MATLAB, and pass it to C equivalent type variables. While it is possible and easy to figure out from the example how to load fields by numbers, it is here achieved via comparing the field names to strings. Thus the struct fields ...

Import Element Tree module import xml.etree.ElementTree as ET Element() function is used to create XML elements p=ET.Element('parent') SubElement() function used to create sub-elements to a give element c = ET.SubElement(p, 'child1') dump() function is used to dump xml elements. ET.dump...

The default directory is the home directory ($HOME, typically /home/username), so cd without any directory takes you there cd Or you could be more explicit: cd $HOME A shortcut for the home directory is ~, so that could be used as well. cd ~

-- SQL 2005+ exec sp_addrolemember @rolename = 'myRole', @membername = 'aUser'; exec sp_droprolemember @rolename = 'myRole', @membername = 'aUser'; -- SQL 2008+ ALTER ROLE [myRole] ADD MEMBER [aUser]; ALTER ROLE [myRole] DROP MEMBER [aUser]; Note: role members can be any database-level pri...

Sometimes a build combines multiple source directories, each of which is their own 'project'. For instance, you might have a build structure like this: projectName/ build.sbt project/ src/ main/ ... test/ ... core/ src/ main/ ... test/ ... webapp/ src/ main/ ... test/ ... In t...

Abstract base classes (ABCs) enforce what derived classes implement particular methods from the base class. To understand how this works and why we should use it, let's take a look at an example that Van Rossum would enjoy. Let's say we have a Base class "MontyPython" with two methods (jo...