Tutorial by Examples: g

var sourceFileName = "NonExistingFile"; try { System.IO.File.Copy(sourceFileName, "DestinationFile"); } catch (Exception e) { var stdErr = Console.Error; stdErr.WriteLine($"Failed to copy '{sourceFileName}': {e.Message}"); }

To get the list of Elixir modules just type h Elixir.[TAB] Pressing [TAB] autocompletes modules and functions names. In this case it lists all modules. To find all functions in a module e.g. List use h List.[TAB]

php -S localhost:80 PHP 7.1.7 Development Server started at Fri Jul 14 15:11:05 2017 Listening on http://localhost:80 Document root is C:\projetos\repgeral Press Ctrl-C to quit. This is the simplest way to start a PHP server that responds to request made to localhost at the port 80. The -S...

This returns a map without the key-value pairs for the keys mentioned in the function argument. It can be used to remove information from existing map. (dissoc {:a 1 :b 2} :a) ;; {:b 2} It can also be used for dissocing multiple keys as: (dissoc {:a 1 :b 2 :c 3} :a :b) ;; {:c 3}

This is ANSI SQL method works in all the RDBMS. Widely used approach. CREATE TABLE AliasNameDemo (id INT,firstname VARCHAR(20),lastname VARCHAR(20)) INSERT INTO AliasNameDemo VALUES (1,'MyFirstName','MyLastName') SELECT FirstName +' '+ LastName As FullName FROM AliasNameDemo

This is my preferred approach. Nothing related to performance just a personal choice. It makes the code to look clean. You can see the resulting column names easily instead of scrolling the code if you have a big expression. CREATE TABLE AliasNameDemo (id INT,firstname VARCHAR(20),lastname VARCHAR(...

This is a weird approach most of the people don't know this even exist. CREATE TABLE AliasNameDemo(id INT,firstname VARCHAR(20),lastname VARCHAR(20)) INSERT INTO AliasNameDemo VALUES (1,'MyFirstName','MyLastName') SELECT * FROM (SELECT firstname + ' ' + lastname FROM A...

This syntax will be similar to using AS keyword. Just we don't have to use AS keyword CREATE TABLE AliasNameDemo (id INT,firstname VARCHAR(20),lastname VARCHAR(20)) INSERT INTO AliasNameDemo VALUES (1,'MyFirstName','MyLastName') SELECT FirstName +' '+ LastName FullName FROM AliasNa...

Tables are most easily included with the DT package, which is an R interface to the JavaScript library DataTables. library(shiny) library(DT) ui <- fluidPage( dataTableOutput('myTable') ) server <- function(input, output, session){ output$myTable <- renderDataTable({ dat...

One can use the command-line launching facility is when one wants to customize some aspects of the way MySQL Workbench operates. MySQL Workbench has the following common command line options: --admin instance - Launch MySQL Workbench and load the server instance specified. --query connection - ...

/app/i18n/<Vendor Namespace>/<language package directory>/composer.json { "name": "<vendor namespance>/<language package directory>", "description": "<language package description>", "version": "100....

Here i will show you how to fetch All parent(configuarble products) A parent product and all of its children.

We will start by making a simple class that gets all our parent(Configurable products) <?php namespace Test\Test\Controller\Test; use Magento\Framework\App\Action\Context; class Products extends \Magento\Framework\App\Action\Action { public function __construct( \...

Here we first fetch our parent product and the we will get all children products that this parent have. <?php namespace Test\Test\Controller\Test; use Magento\Framework\App\Action\Context; class Products extends \Magento\Framework\App\Action\Action { public function __cons...

EPPlus also supports the ability to insert text in a cell using the Insert() method. For example: var file = new FileInfo(filePath); using (var p = new ExcelPackage(file)) { var wb = p.Workbook; var ws = wb.Worksheets.FirstOrDefault() ?? wb.Worksheets.Add("Sheet1"); var...

val re = """\((.*?)\)""".r val str = "(The)(example)(of)(repeating)(pattern)(in)(a)(single)(string)(I)(had)(some)(trouble)(with)(once)" re.findAllMatchIn(str).map(_.group(1)).toList res2: List[String] = List(The, example, of, repeating, pattern, in, a, ...

There are 3 usages of the $ character in a DOSKEY macro. Command separator $T is the equivalent of & in a batch script. One can join commands together like so. DOSKEY test=echo hello $T echo world Command-line arguments Like bash(not batch), we use $ to indicate command-line argument....

class AppDelegate: UIResponder, UIApplicationDelegate { var window: UIWindow? var firstTabNavigationController : UINavigationController! var secondTabNavigationControoller : UINavigationController! var thirdTabNavigationController : UINavigationController! var fourth...

For this, we will use the function aggregate, which can be used as follows: aggregate(formula,function,data) The following code shows various ways of using the aggregate function. CODE: df = data.frame(group=c("Group 1","Group 1","Group 2","Group 2",&quo...

Aggregating with dplyr is easy! You can use the group_by() and the summarize() functions for this. Some examples are given below. CODE: # Aggregating with dplyr library(dplyr) df = data.frame(group=c("Group 1","Group 1","Group 2","Group 2","Group 2&...