Tutorial by Examples: a

Dynamic Parameters in Dapper

connection.Execute(@"some Query with @a,@b,@c", new {a=somevalueOfa,b=somevalueOfb,c=somevalueOfc});

Dapper.NET • Dynamic Parameters

python-requests is available on PyPI, the Python Package Index, which means it can be installed through pip: pip install requests Up-to-date source code can be found on the requests GitHub repository If you wish to install it from source, you can do this by either cloning the GitHub repository:...

python-requests • Getting started with python-requests

GET a remote JSON resource

This snippet will grab a JSON formatted resource, decode it and print it in PHP array format. // Fetch $response = wp_remote_get( 'http://www.example.com/resource.json' ); if ( ! is_wp_error( $response ) ) { $headers = wp_remote_retrieve_headers( $response ); if ( isset( $headers[ 'con...

WordPress • Making network requests with HTTP API

Media Queries

Media Queries in Bootstrap allow you to move, show and hide content based on the viewport size. The following media queries are used in LESS files to create the key breakpoints in the Bootstrap grid system: /* Small devices (tablets, 768px and up) */ @media (min-width: @screen-sm-min) { ... } /...

twitter-bootstrap • Grid system

Basic Template

<!DOCTYPE html> <html lang="en"> <head> <meta charset="utf-8"> <meta http-equiv="X-UA-Compatible" content="IE=edge"> <meta name="viewport" content="width=device-widt...

twitter-bootstrap • Getting started with twitter-bootstrap

Searching

Jumping to characters f{char} - move to the next occurrence of {char} to the right of the cursor on the same line F{char} - move to the next occurrence of {char} to the left of the cursor on the same line t{char} - move to the left of the next occurrence of {char} to the right of the cursor on th...

vim • Movement

Modifying keys and values

You can create a new hash with the keys or values modified, indeed you can also add or delete keys, using inject (AKA, reduce). For example to produce a hash with stringified keys and upper case values: fruit = { name: 'apple', color: 'green', shape: 'round' } # => {:name=>"apple",...

Ruby Language • Hashes

Background Shorthand

The background property can be used to set one or more background related properties: ValueDescriptionCSS Ver.background-imageBackground image to use1+background-colorBackground color to apply1+background-positionBackground image's position1+background-sizeBackground image's size3+background-repeat...

CSS • Backgrounds

Running a Seeder

You may add your new Seeder to the DatabaseSeeder class. /** * Run the database seeds. * * @return void */ public function run() { $this->call(UserTableSeeder::class); } To run a database seeder, use the Artisan command php artisan db:seed ...

Laravel • Database Seeding

Creating a Seed

Database seeds are stored in the /database/seeds directory. You can create a seed using an Artisan command. php artisan make:seed UserTableSeeder Alternatively you can create a new class which extends Illuminate\Database\Seeder. The class must a public function named run().

Laravel • Database Seeding

Inserting Data using a Seeder

You can reference models in a seeder. use DB; use App\Models\User; class UserTableSeeder extends Illuminate\Database\Seeder{ public function run(){ # Remove all existing entrie DB::table('users')->delete() ; User::create([ 'name' => 'Admin', ...

Laravel • Database Seeding

Simple data structures

Structure data types are useful way to package related data and have them behave like a single variable. Declaring a simple struct that holds two int members: struct point { int x; int y; }; x and y are called the members (or fields) of point struct. Defining and using structs: ...

C Language • Structs

Trim empty spaces

Trim is used to remove write-space at the beginning or end of selection In MSSQL there is no single TRIM() SELECT LTRIM(' Hello ') --returns 'Hello ' SELECT RTRIM(' Hello ') --returns ' Hello' SELECT LTRIM(RTRIM(' Hello ')) --returns 'Hello' MySql and Oracle SELECT TRIM(' Hello ') ...

SQL • String Functions

Concatenate

In (standard ANSI/ISO) SQL, the operator for string concatenation is ||. This syntax is supported by all major databases except SQL Server: SELECT 'Hello' || 'World' || '!'; --returns HelloWorld! Many databases support a CONCAT function to join strings: SELECT CONCAT('Hello', 'World'); --retur...

SQL • String Functions

Upper & lower case

SELECT UPPER('HelloWorld') --returns 'HELLOWORLD' SELECT LOWER('HelloWorld') --returns 'helloworld'

SQL • String Functions

Installation and setup

Nginx is a Web server used to serve HTTP requests over the Internet. Nginx is available on Linux, Windows and other OSes as direct download, and can also be built from source. For detailed instructions see Nginx official reference. ubuntu/debian nginx stable version is available in official repo,...

nginx • Getting started with nginx

Installation or Setup

Detailed instructions on getting azureservicebus set up or installed.

azureservicebus • Getting started with azureservicebus

Creating a Specific Date

While the Java Date class has several constructors, you'll notice that most are deprecated. The only acceptable way of creating a Date instance directly is either by using the empty constructor or passing in a long (number of milliseconds since standard base time). Neither are handy unless you're lo...

Java Language • Date Class

Using a Function Object Consumer

We can provide a consumer that will be called with the multiple relevant values: C++11 template <class F> void foo(int a, int b, F consumer) { consumer(a + b, a - b, a * b, a / b); } // use is simple... ignoring some results is possible as well foo(5, 12, [](int sum, int , int , i...

C++ • Returning several values from a function

Creating an Option value and pattern match

// The Option type can either contain Some value or None. fn find(value: i32, slice: &[i32]) -> Option<usize> { for (index, &element) in slice.iter().enumerate() { if element == value { // Return a value (wrapped in Some). return Some(index);...

Rust • Option