Tutorial by Examples: i

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 PXDBTime attribute is designed to work with a DAC field of the Nullable<DateTime> (DateTime?) type and store only the time part without date inside a DAC field: #region UsrTime public abstract class usrTime : IBqlField { } [PXDBTime(DisplayMask = "t", InputMask = "t&qu...

The PXDBDate attribute and the PXDate attribute are designed to work with a DAC field of the Nullable<DateTime> (DateTime?) type and store date value with an optional time part inside a single field. Wheather PX(DB)DateAttribute should save time in addition to date in a DAC field is defined by...

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

The PXTimeList attribute is designed to work with a DAC field of the Nullable<int> (int?) type and store time span value inside a DAC field as a number of minutes: #region UsrTimeSpan public abstract class usrTimeSpan : IBqlField { } [PXDBInt] [PXTimeList] [PXUIField(DisplayName = &quo...

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

├───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) }

ViewModelBase extends ObservableObject and adds some methods useful for viewmodels. The property IsInDesignMode or IsInDesignModeStatic allows to determine if the code is executed in the design mode (in Visual Studio Design View) or not. The two properties are exactly the same.

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

A reactive can be used to make output depend on another expression. In the example below, the output$text element is dependent on text_reactive, which in turn is dependent on input$user_text. Whenever input$user_text changes, output$text element and text_reactive become invalidated. They are recalcu...

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

reactiveValues can be used to store objects, to which other expressions can take a dependency. In the example below, a reactiveValues object is initialized with value "No text has been submitted yet.". A separate observer is created to update the reactiveValues object whenever the submit ...

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