Tutorial by Examples: p

CREATE TABLE table_name ( id INT NOT NULL AUTO_INCREMENT, json_col JSON, PRIMARY KEY(id) );

INSERT INTO table_name (json_col) VALUES ('{"City": "Galle", "Description": "Best damn city in the world"}'); That's simple as it can get but note that because JSON dictionary keys have to be surrounded by double quotes the entire thing should b...

C++11 Basic example: template<typename T> using pointer = T*; This definition makes pointer<T> an alias of T*. For example: pointer<int> p = new int; // equivalent to: int* p = new int; Alias templates cannot be specialized. However, that functionality can be obtained indi...

import os, sys from openpyxl import Workbook from datetime import datetime dt = datetime.now() list_values = [["01/01/2016", "05:00:00", 3], \ ["01/02/2016", "06:00:00", 4], \ ["01/03/2016", "07:00:00",...

OpenPyXL is a module for manipulating and creating xlsx/xlsm/xltx/xltm workbooks in memory. Manipulating and reading an existing workbook: import openpyxl as opx #To change an existing wookbook we located it by referencing its path workbook = opx.load_workbook(workbook_path) load_workbook() c...

Cryptography is something very hard and after spending a lot of time reading different examples and seeing how easy it is to introduce some form of vulnerability I found an answer originally written by @jbtule that I think is very good. Enjoy reading: "The general best practice for symmetric e...

The List API has eight methods for positional access operations: add(T type) add(int index, T type) remove(Object o) remove(int index) get(int index) set(int index, E element) int indexOf(Object o) int lastIndexOf(Object o) So, if we have a List: List<String> strings = new ArrayL...

The implementation of INotifyPropertyChange can be error-prone, as the interface requires specifying property name as a string. In order to make the implementation more robust, an attribute CallerMemberName can be used. class C : INotifyPropertyChanged { // backing field int offset; ...

mysqladmin -u root -p'old-password' password 'new-password'

Useful for scripting to drop all tables and deletes the database: mysqladmin -u[username] -p[password] drop [database] Use with extreme caution. To DROP database as a SQL Script (you will need DROP privilege on that database): DROP DATABASE database_name or DROP SCHEMA database_name

Batch execution using java.sql.PreparedStatement allows you to execute a single DML statement with multiple sets of values for its parameters. This example demonstrates how to prepare an insert statement and use it to insert multiple rows in a batch. Connection connection = ...; // obtained earl...

Compare the definition of Free to that of Fix: data Free f a = Return a | Free (f (Free f a)) newtype Fix f = Fix { unFix :: f (Fix f) } In particular, compare the type of the Free constructor with the type of the Fix constructor. Free layers up a functor just like Fix, except ...

foreach will iterate over any object of a class that implements IEnumerable (take note that IEnumerable<T> inherits from it). Such objects include some built-in ones, but not limit to: List<T>, T[] (arrays of any type), Dictionary<TKey, TSource>, as well as interfaces like IQueryab...

Throughout this example it is assumed that the 'root' object that is being serialized to JSON is an instance of the following class : public class MyJson { }   Example 1 : An example of an instance of MyJson, as is: {} i.e. since the class has no fields, only curly brackets are serialized...

To find the distance between two points we use pythagoras to get the square root of the sum of the square of the component of the vector between them. var v1 = {x : 10, y :5}; var v2 = {x : 20, y : 10}; var x = v2.x - v1.x; var y = v2.y - v1.y; var distance = Math.sqrt(x * x + y * y); // 11.180...

Math.sin and Math.cos are cyclic with a period of 2*PI radians (360 deg) they output a wave with an amplitude of 2 in the range -1 to 1. Graph of sine and cosine function: (courtesy Wikipedia) They are both very handy for many types of periodic calculations, from creating sound waves, to animati...

public Result sayHello() { JsonNode json = request().body().asJson(); if(json == null) { return badRequest("Expecting Json data"); } else { String name = json.findPath("name").textValue(); if(name == null) { return badRequest...

@BodyParser.Of(BodyParser.Json.class) public Result sayHello() { JsonNode json = request().body().asJson(); String name = json.findPath("name").textValue(); if(name == null) { return badRequest("Missing parameter [name]"); } else { return ok...

<!-- <moduleDir>/etc/<area>/di.xml --> <config xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="urn:magento:framework:ObjectManager/etc/config.xsd"> <!-- ... --> <type name="Vendor\Namespace\Model\So...

<!-- <moduleDir>/etc/<area>/di.xml --> <config xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="urn:magento:framework:ObjectManager/etc/config.xsd"> <!-- ... --> <preference for="Vendor\Name...