Tutorial by Examples: er

Insert single JSON object generated with FOR JSON clause

You can generate JSON object using standard SELECT query with FOR JSON clause and WITHOUT_ARRAY_WRAPPER option, and insert it into JSON text as a third parameter: declare @json nvarchar(4000) = N'{"Id":17,"Name":"WWI"}' set @json = JSON_MODIFY(@json, '$.table', ...

Microsoft SQL Server • Modify JSON text

Count number of records per reference in bamfile

samtools idxstats thing.bam

bioinformatics • Basic Samtools

Convert sam into bam (and back again)

Samtools can be used to convert between sam and bam: -b indicates that the input file will be in BAM format -S indicates that the stdout should be in SAM format samtools view -sB thing.bam > thing.sam And to convert between sam and bam: samtools view thing.sam > thing.bam samtools ...

bioinformatics • Basic Samtools

Sample xml configuration using PropertyPlaceholderConfigurer

<bean class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer"> <property name="locations"> <list> <value>classpath:ReleaseBundle.properties</value> </list> </bean>

spring • Property Source

Passing Parameters to a route

Parameters can be specified in path property of route configuration 'use strict'; const Hapi = require('hapi'); // Create a server with a host and port const server = new Hapi.Server(); server.connection({ host: 'localhost', port: 8000 }); // Add a route path with url par...

hapijs • Getting started with hapijs

Format Excel files with xlsxwriter

import xlsxwriter # create a new file workbook = xlsxwriter.Workbook('your_file.xlsx') # add some new formats to be used by the workbook percent_format = workbook.add_format({'num_format': '0%'}) percent_with_decimal = workbook.add_format({'num_format': '0.0%'}) bold = workbook.add_forma...

Python Language • Python and Excel

Character modifications

Character modifying functions include converting characters to upper or lower case characters, converting numbers to formatted numbers, performing character manipulation, etc. The lower(char) function converts the given character parameter to be lower-cased characters. SELECT customer_id, lower(cu...

SQL • Functions (Scalar/Single Row)

The generated HTML with automaticaly loaded assets

<!DOCTYPE html> <html lang="en-EN"> <head> <meta charset="UTF-8"> <meta name="viewport" content="width=device-width, initial-scale=1"> <meta name="csrf-param" content="_csrf"> <me...

yii2 • Asset management

Generate a random number between 0 and 100

Pass an upper limit as an argument to the rand() function. Input: my $upper_limit = 100; my $random = rand($upper_limit); print $random . "\n"; Output: A random floating-point number, like... 45.8733038119139

Perl Language • Randomness

Generate a random integer between 0 and 9

Cast your random floating-point number as an int. Input: my $range = 10; # create random integer as low as 0 and as high as 9 my $random = int(rand($range)); # max value is up to but not equal to $range print $random . "\n"; Output: A random integer, like... 0 See also t...

Perl Language • Randomness

Warning: Elements in a ReadOnlyCollection are not inherently read-only

If the source collection is of a type that is not immutable, elements accessed through a ReadOnlyCollection can be modified. public class Item { public string Name { get; set; } public decimal Price { get; set; } } public static void FillOrder() { // An order is generated ...

.NET Framework • ReadOnlyCollections

Iterating over a range

You can easily do something to each element in a range. (1..5).each do |i| print i end # 12345

Ruby Language • Range

Read with some error checking

A modern Fortran example which includes error checking and a function to get a new unit number for the file. module functions contains function get_new_fileunit() result (f) implicit none logical :: op integer :: f f = 1 do ...

Fortran • I/O

Order of function parameter execution

The order of execution of parameters is undefined in C programming. Here it may execute from left to right or from right to left. The order depends on the implementation. #include <stdio.h> void function(int a, int b) { printf("%d %d\n", a, b); } int main(void) { ...

C Language • Function Parameters

What Comes Under Big Data?

Big data involves the data produced by different devices and applications. Given below are some of the fields that come under the umbrella of Big Data. Black Box Data : It is a component of helicopter, airplanes, and jets, etc. It captures voices of the flight crew, recordings of microphones an...

bigdata • Getting started with bigdata

Alter default search_path of user

With the below commands, user's default search_path can be set. Check search path before set default schema. postgres=# \c postgres user1 You are now connected to database "postgres" as user "user1". postgres=> show search_path; search_path ---------------- &q...

postgresql • Role Management

UISerachController in Objective-C

Delegate: UISearchBarDelegate, UISearchControllerDelegate, UISearchBarDelegate @property (strong, nonatomic) UISearchController *searchController; - (void)searchBarConfiguration { self.searchController = [[UISearchController alloc] initWithSearchResultsController:nil]; self.searchC...

iOS • UISearchController

Filtering data by dynamic criteria

For example, we need to create two visualisations, "Before" and "After", and use dynamic filter for the date of the split. Let's say our query is called table. Add an additional date table with possible dates of the split. Add a slicer control with the table added ...

powerbi • Data Management

Delegation of Event from User Control to aspx

Normally, we opt this approach if we want complete encapsulation and don't want to make our methods public. Ascx <div style="width: 100%;"> <asp:Button ID="btnAdd" runat="server" Text="Add" OnClick="btnAdd_Click"></asp:butto...

ASP.NET • Event Delegation

Parallel processing of a c++ list container using OpenMP tasks

#include <omp.h> #include <unistd.h> #include <iostream> #include <list> static void processElement (unsigned n) { // Tell who am I. The #pragma omp critical ensures that // only one thread sends data to std::cout #pragma omp critical std::cout <...

openmp • Irregular OpenMP parallelism