Tutorial by Examples: ad

You can read content of file using OPENROWSET(BULK) function and store content in some table: INSERT INTO myTable(content) SELECT BulkColumn FROM OPENROWSET(BULK N'C:\Text1.txt', SINGLE_BLOB) AS Document; SINGLE_BLOB option will read entire content from a file as single cell. ...

Yu can define format of the file that will be imported using FORMATFILE option: INSERT INTO mytable SELECT a.* FROM OPENROWSET(BULK 'c:\test\values.txt', FORMATFILE = 'c:\test\values.fmt') AS a; The format file, format_file.fmt, describes the columns in values.txt: 9.0 2 1 SQ...

You can use OPENROWSET to read content of file and pass it to some other function that will parse results. The following example shows hot to read entire content of JSON file using OPENROWSET(BULK) and then provide BulkColumn to OPENJSON function that will parse JSON and return columns: SELECT boo...

READ data-file

You may want to read a DataFrame from a CSV (Comma separated values) file or maybe even from a TSV or WSV (tabs and whitespace separated files). If your file has the right extension, you can use the readtable function to read in the dataframe: readtable("dataset.CSV") But what if your ...

Assuming you have a model that looks like the following, we will get up an running with a simple barebones read-only API driven by Django REST Framework ("DRF"). models.py class FeedItem(models.Model): title = models.CharField(max_length=100, blank=True) url = models.URLField(b...

To separate API logic from the component, we are creating the API client as a separate class. This example class makes a request to Wikipedia API to get random wiki articles. import { Http, Response } from '@angular/http'; import { Injectable } from '@angular/core'; import { Observabl...

Add the readonly attribute to prevent user input. A readonly field can't be edited <input class="form-control" type="text" placeholder="Readonly input here…" readonly> Add the disabled attribute to disable an input field. A disbled field can't be edited either...

roslaunch is an important tool that manages the start and stop of ROS nodes. It takes one or more "*.launch" files as arguments. For this example, I will refer to the following (as asked in this question), so how can we execute those commands consecutively & automatically : roscd ste...

Getting a table with vertical headers. Twitter bootstrap now support vertical header on a well formatted normal table. To achieve this just use .table-reflow class Use twitter bootstrap .table-reflow class on a well formed table to achieve a table with vertical headers. Additionally you can combin...

This document details the steps to obtain the facebook access tokens and the using the tokens to fetch FB feeds. Example: A live example is available in https://newtonjoshua.com Introduction to Graph API: The Graph API is the primary way to get data in and out of Facebook's platform. It's a...

Download the .jar file from vaadin add-ons And put it in the lib folder of WEB-INF then right click on the .jar file and click on to Build Path --> Add To Build Path

The members of a union share the same space in memory. This means that writing to one member overwrites the data in all other members and that reading from one member results in the same data as reading from all other members. However, because union members can have differing types and sizes, the da...

RwLocks allow a single producer provide any number of readers with data while preventing readers from seeing invalid or inconsistent data. The following example uses RwLock to show how a single producer thread can periodically increase a value while two consumers threads are reading the value. use...

You can parse XML from a string or from a XML file 1. From a string $xml_obj = simplexml_load_string($string); 2. From a file $xml_obj = simplexml_load_file('books.xml'); Example of parsing Considering the following XML: <?xml version="1.0" encoding="UTF-8"?> &l...

import pygame file = 'some.mp3' pygame.init() pygame.mixer.init() pygame.mixer.music.load(file) pygame.mixer.music.play(-1) # If the loops is -1 then the music will repeat indefinitely.

import pygame import time pygame.mixer.init() pygame.display.init() screen = pygame.display.set_mode ( ( 420 , 240 ) ) playlist = list() playlist.append ( "music3.mp3" ) playlist.append ( "music2.mp3" ) playlist.append ( "music1.mp3" ) pygame.mixer.musi...

<?php namespace laravel\Http\Middleware; class CorsHeaders { /** * This must be executed _before_ the controller action since _after_ middleware isn't executed when exceptions are thrown and caught by global handlers. * * @param $request * @param \Closure $next * @pa...

Add button Login as facebook account to your login view: Edit site/login.php in views folder, add theses line to content of page login: <?= yii\authclient\widgets\AuthChoice::widget([ 'baseAuthUrl' => ['site/auth'], 'popupMode' => false, ]) ?> Above, we set that aut...

If you enable prettyUrl in your yii2-app, your redirect_uri will be: http://<base_url>/web/site/auth And disable pretty url: http://<base_url>/web/index.php?r=site%2Fauth Example: