beginor

CREATE SEQUENCE public.global_id_seq;
ALTER SEQUENCE public.global_id_seq OWNER TO postgres;

CREATE OR REPLACE FUNCTION public.id_generator()
    RETURNS bigint
    LANGUAGE 'plpgsql'
AS $BODY$
DECLARE
    our_epoch bigint := 1314220021721;
    seq_id bigint;

beginor

Ubuntu 16.04 软件路由

服务器配置

操作系统 Ubuntu 16.04 LTS， 双网卡作软件路由

外网网卡配置

网络经光纤猫之后， 连接外网网卡， 名称 enp8s0 ， 动态获取 ip 地址；

beginor

DO $$
DECLARE
  st_time TIMESTAMP WITH TIME ZONE := '2016-03-01';
  p RECORD;
BEGIN
  RAISE INFO 'stat time is: % :', st_time;
  FOR p IN
    SELECT
      r.id, r.water_source_code, r.water_source_name
    FROM public.water_source_month_report r

beginor

/**
 * Cesium type definitions
 * For use with Cesium v1.37.0
 * Created by Aigars Zeiza <https://github.com/Zuzon>
 * Modified by Harry Nicholls <[email protected]>
 * Updated for v1.37.0 by James Bromwell <https://github.com/Thw0rted>
 */
declare module "cesium"{

    type RenderState = any;

beginor

MERGE into dbo.water_quality_data_his AS target
USING dbo.water_quality_data_his_temp AS source
ON (target.id = source.id)
    WHEN MATCHED
        THEN UPDATE SET
        target.[id] = source.[id],
        target.[point_id] = source.[point_id],
        target.[item_id] = source.[item_id],
        target.[item_name] = source.[item_name],
        target.[item_unit] = source.[item_unit],

beginor

# update hosts
echo "Start update hosts"
echo "Create a new host file"
touch hosts
echo "Done!"
echo "Update AD block hosts ..."
curl https://raw.githubusercontent.com/vokins/yhosts/master/hosts >> hosts
echo "Done!"
echo "Update Google hosts ..."
curl https://raw.githubusercontent.com/sy618/hosts/master/p >> hosts

beginor

exports.fetch = function(load) {
    var name = load.name;
    return new Promise(function(resolve) {
        var dojoName = convertToDojoModule(name);
        window.require([dojoName], function(mod) {
            SystemJS.register(dojoName, [], function (exp, idObj) {
                return {
                    setters: [],
                    execute: function() {
                        exp("default", mod);

beginor

# EditorConfig
# Top-most EditorConfig file
root = true
# * for all files
[*]
charset = utf-8
indent_style = space
indent_size = 4
tab_width = 4
end_of_line = lf

beginor

import * as uglifyJs from 'uglify-js';
import * as path from 'path';
import * as fs from 'fs';

var p = path.resolve(__dirname, 'jsapi/esri/nls/zh-cn/jsapi.js');
console.log(p);

fs.readFile(p, { encoding: 'utf-8' }, (ex, data) => {
    //console.log(data);
    var result = uglifyJs.parse(data, {});

beginor

using System;
using System.Collections.Generic;
using System.IO;
using System.Linq;
using System.Security.Cryptography;
using System.Text;
using System.Threading.Tasks;

namespace CMCloud.SaaS
{