Tutorial by Examples: r

This is a bare minimum setup for MySQL servers using InnoDB tables. Using InnoDB, query cache is not required. Reclaim disk space when a table or database is DROPed. If you're using SSDs, flushing is a redundant operation (SDDs are not sequential). default_storage_engine = InnoDB query_cache_type ...

The default encryption aes-128-ecb uses Electronic Codebook (ECB) mode, which is insecure and should never be used. Instead, add the following to your configuration file: block_encryption_mode = aes-256-cbc

Using PowerShell executed from a SharePoint Web Server: $wacoll = get-spwebapplication foreach($wa in $wacoll){ if($wa.IsAdministrationWebApplication -eq $false){ foreach($site in $wa.Sites){ foreach($web in $site.AllWebs){ # your code here ...

When using PowerShell, you can use setx.exe to set environment variables permanently. Start PowerShell Type one of the following: setx ASPNETCORE_ENVIRONMENT "development" setx ASPNETCORE_ENVIRONMENT "staging" Restart PowerShell

Using PostgreSQLnpm module. install dependency from npm npm install pg --save Now you have to create a PostgreSQL connection, which you can later query. Assume you Database_Name = students, Host = localhost and DB_User= postgres var pg = require("pg") var connectionString = &q...

Event fired when player enters a bed: PlayerBedEnterEvent PlayerBedEnterEvent(Player who, Block bed) @EventHandler public void onPlayerBedEnter(PlayerBedEnterEvent e) { Player entered = e.getPlayer(); Block bedEntered = e.getBed(); } Event fired when player leaves a bed: P...

PS> $ErrorActionPreference = "Continue" (1) PS> & console_app.exe *>&1 | % { $_ } (2) PS> & console_app.exe *>&1 | ? { $_ -is [System.Management.Automation.ErrorRecord] } (3) PS> & console_app.exe *>&1 | ? { $_ -is [System.Management.Automati...

Many of us start debugging with simple print(). Let's say we have such a class: class Abc { let a = "aa" let b = "bb" } and we have an instance of Abc as so: let abc = Abc() When we run the print() on the variable, the output is App.Abc while dump() output...

If you want to use connection object for query database you can use this sample code. var queryString = "SELECT name, age FROM students " ; var query = client.query(queryString); query.on("row", (row, result)=> { result.addRow(row); }); query.on("end", func...

To add a resource to the cache you must provide a key and the resource. First make sure that the value is not in the cache already public void addResourceToMemoryCache(String key, Bitmap resource) { if (memoryCache.get(key) == null) memoryCache.put(key, resource); }

To get a resource from the cache simply pass the key of your resource (String in this example) public Bitmap getResourceFromMemoryCache(String key) { memoryCache.get(key); }

Extended version of http://www.riptutorial.com/python/example/25282/argparse--default-help-formatter- that fixed help output. import argparse import sys class CustomHelpFormatter(argparse.HelpFormatter): def _format_action(self, action): if type(action) == argparse._SubParsersActi...

Detailed instructions on getting prestashop-1.6 set up or installed. Start by downloading the zip-file from prestashop.com/download In the zip-folder you'll find a folder called prestashop and an html-file with an installation guide Put the contents of the folder prestashop into the location wh...

lib.currentURL= TEXT lib.currentURL.data = getIndpEnv:TYPO3_REQUEST_URL

This tslint.json example contains a set of configuration to enforce more typings, catch common errors or otherwise confusing constructs that are prone to producing bugs and following more the Coding Guidelines for TypeScript Contributors. To enforce this rules, include tslint in your build process ...

There are important changes in how we use and declare default props and their types. React.createClass In this version, the propTypes property is an Object in which we can declare the type for each prop. The getDefaultProps property is a function that returns an Object to create the initial props....

Custom binding definition function regExReplace(element, valueAccessor, allBindingsAccessor, viewModel, bindingContext) { var observable = valueAccessor(); var textToReplace = allBindingsAccessor().textToReplace || ''; var pattern = allBindingsAccessor().pattern || ''; var flags = all...

To create a node, you first need to have a hub. If you don't have a hub, you can create it like this: java -jar selenium-server-standalone-<version>.jar -role hub Then you're able to create a node: java -jar selenium-server-standalone-<version>.jar -role node -hub http://localhost:4...

This approach will generate one table on the database to represent all the inheritance structure. Example: public abstract class Person { public int Id { get; set; } public string Name { get; set; } public DateTime BirthDate { get; set; } } public class Employee : Person { ...

This approach will generate (n+1) tables on the database to represent all the inheritance structure where n is the number of subclasses. How to: public abstract class Person { public int Id { get; set; } public string Name { get; set; } public DateTime BirthDate { get; set; } } ...