Tutorial by Examples: on

Integration to open database using password. -(void)checkAndOpenDB{ sqlite3 *db; NSString *strPassword = @"password"; if (sqlite3_open_v2([[databaseURL path] UTF8String], &db, SQLITE_OPEN_READWRITE | SQLITE_OPEN_CREATE, NULL) == SQLITE_OK) { const cha...

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...

You get this exception mostly with form submissions. Laravel protects application from CSRF and validates every request and ensures the request originated from within the application. This validation is done using a token. If this token mismatches this exception is generated. Quick Fix Add this wi...

Getting started with xUnit.net, on Platform: .NET Core / ASP.NET Core Desktop CLR Universal Windows Apps

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 ...

var MongoClient = require('mongodb').MongoClient; //connection with mongoDB MongoClient.connect("mongodb://localhost:27017/MyDb", function (err, db) { //check the connection if(err){ console.log("connection failed."); }else{ ...

The NamedParameterJdbcTemplate class adds support for programming JDBC statements using named parameters, as opposed to programming JDBC statements using only classic placeholder ( '?') arguments. The NamedParameterJdbcTemplate class wraps a JdbcTemplate, and delegates to the wrapped JdbcTempl...

Any @Component or @Configuration could be marked with @Profile annotation @Configuration @Profile("production") public class ProductionConfiguration { // ... } The same in XML config <beans profile="dev"> <bean id="dataSource" class="&l...

Protractor Installation and Setup Step 1: Download and install NodeJS from here. Make sure you have latest version of node. Here, I am using node v7.8.0. You will need to have the Java Development Kit(JDK) installed to run selenium. Step 2: Open your terminal and type in the following command to i...

Suppose you need to work on three different projects project A, project B and project C. project A and project B need python 3 and some required libraries. But for project C you need python 2.7 and dependent libraries. So best practice for this is to separate those project environments. To create v...

Suppose you need to work on three different projects project A, project B and project C. project A and project B need python 3 and some required libraries. But for project C you need python 2.7 and dependent libraries. So best practice for this is to separate those project environments. For creati...

In order to chain asynchronous operations and avoid a callback hell, Vala supports the yield statement. Used with an asynchronous invocation, it will pause the current coroutine until the call is completed and extract the result. Used alone, yield pause the current coroutine until it's being woken...

class ConversationsTableViewController: UITableViewController, NSFetchedResultsControllerDelegate { private var fetchedResultsController: NSFetchedResultsController<Conversation>! override func viewDidLoad() { super.viewDidLoad() initializeFetchedResultsController() } private...

Detailed instructions on getting owl set up or installed.

Detailed instructions on getting influxdb set up or installed.

If you want to use a podfile in more than one target, you can do like this. You can choose the download address when you pod this lib. def testpods pod 'YSDPush', :git => 'https://github.com/youshaoduo/YSDPush.git' end target 'One' do testpods end target 'Two' do testpods ...

Calendar : Key : Privacy - Calendars Usage Description Value : $(PRODUCT_NAME) calendar events Reminder : Key : Privacy - Reminders Usage Description Value : $(PRODUCT_NAME) reminder use Contact : Key : Privacy - Contacts Usage Description Value : $(PRODUCT_...

To list the available databases, use the following command: $ show databases name: databases name ---- _internal devices ... list of your databases You can connect to one specific database: $ use <database_name> By using a single database, the scope for each subsequent query wi...

In DRF, serializer validation is run in a specific, undocumented order Field deserialization called (serializer.to_internal_value and field.run_validators) serializer.validate_[field] is called for each field. Serializer-level validators are called (serializer.run_validation followed by seriali...