Tutorial by Examples: n

;WITH cte_query_1 AS ( SELECT * FROM database.table1 ), cte_query_2 AS ( SELECT * FROM database.table2 ) SELECT * FROM cte_query_1 WHERE cte_query_one.fk IN ( SELECT PK FROM cte_query_2 ) With common table expressions, it is possible to create multiple ...

Let's say that we're given const string input as a phone number to be validated. We could start by requiring a numeric input with a zero or more quantifier: regex_match(input, regex("\\d*")) or a one or more quantifier: regex_match(input, regex("\\d+")) But both of those really f...

You can add different dependencies for a specific product flavor. Just use the <flavorName>Compile 'group:name:x.y.z' syntax: android { ... productFlavors { flavor1 { //..... } flavor2 { //..... } } } ... d...

When Java annotations were first introduced there was no provision for annotating the target of an instance method or the hidden constructor parameter for an inner classes constructor. This was remedied in Java 8 with addition of receiver parameter declarations; see JLS 8.4.1. The receiver param...

Single-line comments begin with a pound sign # and go to the end of the line: # This is a comment my $foo = "bar"; # This is also a comment

Multi-line comments start with = and with the =cut statement. These are special comments called POD (Plain Old Documentation). Any text between the markers will be commented out: =begin comment This is another comment. And it spans multiple lines! =end comment =cut

Creates a single Point. This will be a geometry or geography point depending on the class used. ParameterDetailLat or XIs a float expression representing the x-coordinate of the Point being generatedLong or YIs a float expression representing the y-coordinate of the Point being generatedStringWell ...

The Combined Call method allows you to use multiple AlchemyLanguage functions in one request. This example uses a Combined Call to get entities and keywords from the IBM website and returns sentiment information for each result. This example requires AlchemyLanguage service credentials and Node.j...

AlchemyLanguage's Targeted Sentiment feature can search your content for target phrases and return sentiment information for each result. This example requires AlchemyLanguage service credentials and Node.js Use a command-line interface to install the Watson Developer Cloud Node.js SDK: $...

AlchemyLanguage can detect general concepts referenced in your content. The service returns Linked Data links for each concept and a URL to a relevant website when possible. This example requires AlchemyLanguage service credentials and Node.js Use a command-line interface to install the Wats...

A value_ptr is a smart pointer that behaves like a value. When copied, it copies its contents. When created, it creates its contents. // Like std::default_delete: template<class T> struct default_copier { // a copier must handle a null T const* in and return null: T* operator()(T co...

Add spring-boot-starter-data-jpa dependency to pom.xml. You may skip version tag, if you are using spring-boot-starter-parent as the parent of your pom.xml. The dependency below brings Hibernate and everything related to JPA to your project (reference). <dependency> <group...

If you would like to use vim in a manner similar to sed, you may use the -c flag to run an ex command from the command line. This command will run automatically before presenting the file to you. For example, to replace foo with bar: vim file.txt -c "s/foo/bar" This will open up the fi...

To create the serialVersionUID for a class in Kotlin you have a few options all involving adding a member to the companion object of the class. The most concise bytecode comes from a private const val which will become a private static variable on the containing class, in this case MySpecialCase: ...

// this function add custom interval (5 minutes) to the $schedules function five_minutes_interval( $schedules ) { $schedules['five_minutes'] = array( 'interval' => 60 * 5, 'display' => '5 minutes'; ); return $schedules; } // add a custom in...

The hash codes produced by GetHashCode() method for built-in and common C# types from the System namespace are shown below. Boolean 1 if value is true, 0 otherwise. Byte, UInt16, Int32, UInt32, Single Value (if necessary casted to Int32). SByte ((int)m_value ^ (int)m_value << 8); Char...

Generally, it's not a good idea to use a regular expression to parse a complex structure. But it can be done. For instance, you might want to load data into hive table and fields are separated by comma but complex types like array are separated by a "|". Files contain records with all fiel...

The java command supports a wide range of options: All options start with a single hyphen or minus-sign (-): the GNU/Linux convention of using -- for "long" options is not supported. Options must appear before the <classname> or the -jar <jarfile> argument to be recog...

Fluent methods in Kotlin can be the same as Java: fun doSomething() { someOtherAction() return this } But you can also make them more functional by creating an extension function such as: fun <T: Any> T.fluently(func: ()->Unit): T { func() return this } Which the...

The BukkitRunnable is a Runnable found in Bukkit. It's possible to schedule a task directly from a BukkitRunnable, and also cancel it from inside itself. Important: The time on the tasks is measured in Ticks. A second has 20 ticks. Non-RepeatingTask: JavaPlugin plugin; //Your plugin instance ...