Tutorial by Examples: b

ByteStrings and Buffers Okio is built around two types that pack a lot of capability into a straightforward API: ByteString is an immutable sequence of bytes. For character data, String is fundamental. ByteString is String's long-lost brother, making it easy to treat binary data as a value. This c...

We can perform a GROUP BY ... COUNT or a GROUP BY ... SUM SQL equivalent queries on Django ORM, with the use of annotate(), values(), order_by() and the django.db.models's Count and Sum methods respectfully: Let our model be: class Books(models.Model): title = models.CharField() ...

A generalization of std::condition_variable, std::condition_variable_any works with any type of BasicLockable structure. std::cv_status as a return status for a condition variable has two possible return codes: std::cv_status::no_timeout: There was no timeout, condition variable was notified st...

By using a module loader like Webpack we can benefit the built-in module system available in ES6 (as well as in TypeScript). We can then use the import and export features that allow us to specify what pieces of code can we are going to share between different parts of the application. When we then...

Requirements: Add following references to the project: Microsoft ActiveX Data Objects 2.8 Library Microsoft ActiveX Data Objects Recordset 2.8 Library Declare variables Private mDataBase As New ADODB.Connection Private mRS As New ADODB.Recordset Private mCmd As New ADODB.Command...

Most of the web applications use the session object to store some important information. This examples show how you can test such application using Flask-Testing. Full working example is also available on github. So first install Flask-Testing in your virtualenv pip install flask_testing To be ...

An example of implementation which give a possibility to detect if user single or double tap on UITableViewCell. override func viewDidLoad() { viewDidLoad() let doubleTapGestureRecognizer = UITapGestureRecognizer(target: self, action: #selector(handleDoubleTap(sender:))) double...

An example of implementation UITableView which allows to detect if cell has been tapped single or double time. override func viewDidLoad() { viewDidLoad() let doubleTapGestureRecognizer = UITapGestureRecognizer(target: self, action: #selector(handleDoubleTap(sender:))) doubleTa...

To create a background with a gradient you can use the CAGradientLayer class: Swift 3.1: func createGradient() { let caLayer = CAGradientLayer() caLayer.colors = [UIColor.white, UIColor.green, UIColor.blue] caLayer.locations = [0, 0.5, 1] caLayer.bounds = self.bounds self...

To add a custom image for the thumb of the slider, simply call the setThumbImage method with your custom image: Swift 3.1: let slider = UISlider() let thumbImage = UIImage slider.setThumbImage(thumbImage, for: .normal)

In following example we will create table movies with AWS Ruby SDK v2. Here, each Movie as one unique Partition Key as id, and Range Key year. Apart from this we want to be able to query movies with their name, hence we will create a Global Secondary Index (GSI) name-year-index with name as Hash Ke...

So the good news is that Apple kindly includes a Ruby interpreter. Unfortunately, it tends not to be a recent version: $ /usr/bin/ruby -v ruby 2.0.0p648 (2015-12-16 revision 53162) [universal.x86_64-darwin16] If you have Homebrew installed, you can get the latest Ruby with: $ brew install ruby...

Run the following bash script as sudo #!/bin/bash # get deps apt -y install build-essential libncurses5-dev libxml2-dev libsqlite3-dev libssl-dev libsrtp0-dev uuid-dev libjansson-dev # download cd /usr/src wget http://downloads.asterisk.org/pub/telephony/asterisk/asterisk-14-current.tar.gz...

Solves problem of: access denied for user root using password YES Stop mySQL: sudo systemctl stop mysql Restart mySQL, skipping grant tables: sudo mysqld_safe --skip-grant-tables Login: mysql -u root In SQL shell, look if users exist: select User, password,plugin FROM mysql.user ; U...

set number1 to 8

set var to 2 if var = 2 then say "Var equals 2" end if

CREATE INDEX ord_customer_ix ON orders (customer_id); By default, if we do not mention anything, oracle creates an index as a b-tree index. But we should know when to use it. B-tree index stores data as binary tree format. As we know that, index is a schema object which stores some sort of entry...

CREATE BITMAP INDEX emp_bitmap_idx ON index_demo (gender); Bitmap index is used when data cardinality is low. Here, Gender has value with low cardinality. Values are may be Male, Female & others. So, if we create a binary tree for this 3 values while searching it will have unnecessary ...

CREATE INDEX first_name_idx ON user_data (UPPER(first_name)); SELECT * FROM user_data WHERE UPPER(first_name) = 'JOHN2'; Function based index means, creating index based on a function. If in search (where clause), frequently any function is used, it's better to create index based on ...

Working with Kettle There are two versions of Kettle aka Pentaho Data Integration : Kettle CE (Community Edition) Kettle EE (Enterprise Edition) Documents aims mainly on Kettle CE edition. Prerequisites PDI requires the Oracle Java Runtime Environment (JRE) version 7. You can obtain a JRE ...