Tutorial by Examples: n

php -S localhost:80 -t project/public router.php PHP 7.1.7 Development Server started at Fri Jul 14 15:22:25 2017 Listening on http://localhost:80 Document root is /home/project/public Press Ctrl-C to quit.

The PXDBDateAndTime attribute and the PXDateAndTime attribute are designed to work with a DAC field of the Nullable<DateTime> (DateTime?) type and store both date and time value parts inside a single field: #region UsrDateAndTime public abstract class usrDateAndTimeAttribute : IBqlField { }...

The PXDBTimeSpan attribute is designed to work with a DAC field of the Nullable<int> (int?) type and store time value inside a DAC field as the number of minutes passed since midnight: #region UsrTimeInt public abstract class usrTimeInt : IBqlField { } [PXDBTimeSpan(DisplayMask = "t...

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

HTML <p>This is a nice </p> <p>I like </p> <ul> <li>List item 1</li> <li>List item 2</li> <li>List item 3</li> </ul> <button id="btn-1">Append text</button> <button id="btn-2&quot...

├───models │ ├───user.model.js ├───routes │ ├───user.route.js ├───services │ ├───user.service.js ├───controllers │ ├───user.controller.js For modular code structure the logic should be divided into these directories and files. Models - The schema definition of the Model Rou...

user.model.js var mongoose = require('mongoose') const UserSchema = new mongoose.Schema({ name: String }) const User = mongoose.model('User', UserSchema) module.exports = User; user.routes.js var express = require('express'); var router = express.Router(); var UserController...

If the promise doesn't return anything, the async task can be completed using await. try{ await User.findByIdAndUpdate(user._id, { $push: { tokens: token } }).exec() }catch(e){ handleError(e) }

1. For Loop: CountriesName = ["India", "Canada", "America", "Iraq"] for country in CountriesName puts country end 2. Each Iterator: Same set of work can be done with each loop which we did with for loop. CountriesName = ["India", "C...

The RelayCommand implements the ICommand interface and can therefore be used to bind to Commands in XAML (as the Command property of the Button element) The constructor takes two arguments; the first is an Action which will be executed if ICommand.Execute is called (e.g. the user clicks on the butt...

The RelayCommand<T> is similar to the RelayCommand, but allows to directly pass an object to the command. It implements the ICommand interface and can therefore be used to bind to Commands in XAML (e.g. as the Command property of the Button element). You can then use the CommandParameter prope...

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

eventReactives are similar to reactives, they are constructed as follows: eventReactive( event { code to run }) eventReactives are not dependent on all reactive expressions in their body ('code to run' in the snippet above). Instead, they are only dependent on the expressions specified in the ...

An observeEvent object can be used to trigger a piece of code when a certain event occurs. It is constructed as: observeEvent( event { code to run }) The observeEvent will only be dependent on the 'event' section in the small piece of code above. It will not be dependent on anything in the 'co...

Valgrind is GPLv2-licensed collection of dynamic analysis tools, which uses binary instrumentation (dynamic recompilation). Six tools are included to detect memory management (Memcheck) and threading errors (Helgrind and DRD), to generate call-graph and profile programs (with optional cache and bran...

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