Tutorial by Examples: ha

The default directory is the home directory ($HOME, typically /home/username), so cd without any directory takes you there cd Or you could be more explicit: cd $HOME A shortcut for the home directory is ~, so that could be used as well. cd ~

GRANT SELECT ON [dbo].[someTable] TO [aUser]; REVOKE SELECT ON [dbo].[someTable] TO [aUser]; --REVOKE SELECT [dbo].[someTable] FROM [aUser]; is equivalent DENY SELECT ON [dbo].[someTable] TO [aUser];

-- SQL 2005+ exec sp_addrolemember @rolename = 'myRole', @membername = 'aUser'; exec sp_droprolemember @rolename = 'myRole', @membername = 'aUser'; -- SQL 2008+ ALTER ROLE [myRole] ADD MEMBER [aUser]; ALTER ROLE [myRole] DROP MEMBER [aUser]; Note: role members can be any database-level pri...

function calculatorService() { const service = {}; service.add = function(a,b) { return a + b } return service; } angular.module('app').factory('calculatorService', calculatorService); Testing describe('calculator service', function() { var calcula...

You can set a character set both per table, as well as per individual field using the CHARACTER SET and CHARSET statements: CREATE TABLE Address ( `AddressID` INTEGER NOT NULL PRIMARY KEY, `Street` VARCHAR(80) CHARACTER SET ASCII, `City` VARCHAR(80), `Country` ...

Created this really bad program #include <stdio.h> #include <ctype.h> // forward declarations void bad_function() { int *test = 5; free(test); } int main(int argc, char *argv[]) { bad_function(); return 0; } gcc -g ex1.c ./a.out //or w...

As example, only for demonstrate HOW-TO use a subquery select statement inside a select statement, suppose we what to find all user that not yet have compile the address (no records exists in the address table): // get an ExpressionBuilder instance, so that you $expr = $this->_em->getExpres...

The hash codes produced by GetHashCode() method for built-in and common C# types from the System namespace are shown below. Boolean 1 if value is true, 0 otherwise. Byte, UInt16, Int32, UInt32, Single Value (if necessary casted to Int32). SByte ((int)m_value ^ (int)m_value << 8); Char...

Generally, it's not a good idea to use a regular expression to parse a complex structure. But it can be done. For instance, you might want to load data into hive table and fields are separated by comma but complex types like array are separated by a "|". Files contain records with all fiel...

Instead of getting a reference to the DOM you can simply change the index of the tab using the selectedIndex attribute on the ion-tabs HTML: <ion-tabs [selectedIndex]="tabIndex" class="tabs-icon-text" primary > <ion-tab tabIcon="list-box" [root]=&qu...

Sometimes it is needful to backtrack after reading. # identify current position in file, in case the first line isn't a comment my $current_pos = tell; while (my $line = readline $fh) { if ($line =~ /$START_OF_COMMENT_LINE/) { push @names, get_name_from_comment($line); ...

You can leave the web server running while you develop your application. When you make a change, use the mvn clean package command to build and update your app. Try it now: Leave the web server running, then edit HelloServlet.java to change Hello, world to something else. Run mvn clean package,...

We can change our toast using SetGravity method. This method takes three parameters: first is gravity of toast on screen and two others set toast offset from the starting position (which is set by the first parameter): //Toast at bottom left corner of screen Toast t = Toast.MakeText(context, mess...

Every Keychain Item is most often represented as a CFDictionary. You can, however, simply use NSDictionary in Objective-C and take advantage of bridging, or in Swift you may use Dictionary and explicitly cast to CFDictionary. You could construct a password with the following dictionary: Swift var...

To construct a query, we need to represent it as a CFDictionary. You may also use NSDictionary in Objective-C or Dictionary in Swift and cast to CFDictionary. We need a class key: Swift var dict = [String : AnyObject]() dict[kSecClass as String] = kSecClassGenericPassword Next, we can specify...

As usual, we first need a CFDictionary to represent the item we want to update. This must contain all of the old values for the item, including the old private data. Then it takes a CFDictionary of any attributes or the data itself that you would like to change. So first, let's construct a class ke...

We need only one thing in order to delete an item from the Keychain: a CFDictionary with attributes describing the items to be deleted. Any items that match the query dictionary will be deleted permanently, so if you are only intending to delete a single item be sure to be specific with your query. ...

#include <ctype.h> #include <stdio.h> typedef struct { size_t space; size_t alnum; size_t punct; } chartypes; chartypes classify(FILE *f) { chartypes types = { 0, 0, 0 }; int ch; while ((ch = fgetc(f)) != EOF) { types.space += !!isspace(ch); types.al...

#include <ctype.h> #include <stddef.h> typedef struct { size_t space; size_t alnum; size_t punct; } chartypes; chartypes classify(const char *s) { chartypes types = { 0, 0, 0 }; const char *p; for (p= s; p != '\0'; p++) { types.space += !!isspace((unsigned ...

For example, we have two environments: CI - Staging and want to add some customizations for each environment. Here I will try to customize server URL, app name. First, we create two targets for 2 environments by duplicating the main target: For each target, we will define a custom macro. Here I ...