Tutorial by Examples: p

Handling request/response

The syntactic sugar Most of the getting started examples of ExpressJs include this piece of code var express = require('express'); var app = express(); ... app.listen(1337); Well, app.listen is just a shortcut for: var express = require('express'); var app = express(); var http = require(...

express • How does ExpressJs work

Split (reshape) CSV strings in columns into multiple rows, having one element per row

import pandas as pd df = pd.DataFrame([{'var1': 'a,b,c', 'var2': 1, 'var3': 'XX'}, {'var1': 'd,e,f,x,y', 'var2': 2, 'var3': 'ZZ'}]) print(df) reshaped = \ (df.set_index(df.columns.drop('var1',1).tolist()) .var1.str.split(',', expand=True) .stack() .reset_ind...

pandas • Reshaping and pivoting

MyCompareFileDialog.h

#ifndef MYCOMPAREFILEDIALOG_H #define MYCOMPAREFILEDIALOG_H #include <QtWidgets/QDialog> class MyCompareFileDialog : public QDialog { Q_OBJECT public: MyCompareFileDialog(QWidget *parent = 0); ~MyCompareFileDialog(); }; #endif // MYCOMPAREFILEDIALOG_H

Qt • QDialogs

MyCompareFileDialogDialog.cpp

#include "MyCompareFileDialog.h" #include <QLabel> MyCompareFileDialog::MyCompareFileDialog(QWidget *parent) : QDialog(parent) { setWindowTitle("Compare Files"); setWindowFlags(Qt::Dialog); setWindowModality(Qt::WindowModal); resize(300, 100); ...

Qt • QDialogs

MainWindow.cpp

#include "mainwindow.h" #include "ui_mainwindow.h" #include "mycomparefiledialog.h" MainWindow::MainWindow(QWidget *parent) : QMainWindow(parent), ui(new Ui::MainWindow) { ui->setupUi(this); myDialog = new MyCompareFileDialog(this); ...

Qt • QDialogs

main.cpp

#include "mainwindow.h" #include <QApplication> int main(int argc, char *argv[]) { QApplication a(argc, argv); MainWindow w; w.show(); return a.exec(); }

Qt • QDialogs

import / export

import SELECT a,b,c INTO OUTFILE 'result.txt' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\n' FROM table; Export LOAD DATA INFILE 'result.txt' INTO TABLE table;

MySQL • LOAD DATA INFILE

Create Immutable version of DateTime from Mutable prior PHP 5.6

To create \DateTimeImmutable in PHP 5.6+ use: \DateTimeImmutable::createFromMutable($concrete); Prior PHP 5.6 you can use: \DateTimeImmutable::createFromFormat(\DateTime::ISO8601, $mutable->format(\DateTime::ISO8601), $mutable->getTimezone());

PHP • Datetime Class

Convert simple JSON object to simple string

var JSONObject = { stringProp: 'stringProp', booleanProp: false, intProp: 8 } var JSONString = JSON.stringify(JSONObject); console.log(JSONString); /* output * {"stringProp":"stringProp","booleanProp":false,"intProp":8} */

JSON • Stringify - Convert JSON to string

Stringify with white-space

var JSONObject = { stringProp: 'stringProp', booleanProp: false, intProp: 8 } var JSONString = JSON.stringify(JSONObject, null, 2); console.log(JSONString); /* output: * { * "stringProp": "stringProp", * "booleanProp": false, * "...

JSON • Stringify - Convert JSON to string

Loading XML data into simplexml

Loading from string Use simplexml_load_string to create a SimpleXMLElement from a string: $xmlString = "<?xml version='1.0' encoding='UTF-8'?>"; $xml = simplexml_load_string($xmlString) or die("Error: Cannot create object"); Note that or not || must be used here becau...

PHP • SimpleXML

Broadcast Hash Join in Spark

A broadcast join copies the small data to the worker nodes which leads to a highly efficient and super-fast join. When we are joining two datasets and one of the datasets is much smaller than the other (e.g when the small dataset can fit into memory), then we should use a Broadcast Hash Join. The f...

apache-spark • Joins

The Client Script

The Client Script is one of the more commonly used, and complex, script types available to you. As its name implies, the Client Script runs in the browser, i.e. on the client side. It is the only script type that runs on the client side; all others will execute on the server side of NetSuite. The p...