preloader
How to Copy PostGIS Table Data to Another Table
學習 How to Copy PostGIS Table Data to Another Table

I want to copy data in a table within postgis to another table, so I use following sql statement: INSERT INTO yourtablename (SELECT TO_DATE(name, 'YYYY-MM-DD'), TO_NUMBER(area, '9999999999.999999999'), TO_NUMBER(fd_depth, '9999'), TO_DATE(fdate, 'YYYY-MM-DD'), town_name, address, description, effect_range FROM yourtmptablename); Notice: Before you executing above snippet, please make sure yourtablename has same column names as output of column names from SELECT statement. I have encounter data format problem about “-"(hyphen) for numeric column

read more
Fix Nodejs Graphql Circular Import
學習 Fix Nodejs Graphql Circular Import

Circular import components are common within nodejs and graphql. This article provide a easy way to resolve that warning. The easy solution is adding related imports to limited scope in javascript instead of importing them at file start position. The example scenario contains three parts: User, Role and UserRoleRel. An user has many roles and a role has many user had been taken. The relationship of many-to-many is recorded at

read more
Read Book 2022 | 2022 年我讀過的書
學習 Read Book 2022 | 2022 年我讀過的書

2022 年讀過的書: 灰階思考。(2021 年 9 月購買, 2021 年 12 月 下旬開始讀,2022 年 1 月 6 日看完) podcast 頻道:股癌 的整理內容 講投資心態和理財的原則 被討厭

read more
How to Upload File Content using Angular framework
學習 How to Upload File Content using Angular framework

If you want to upload file content to remote server using Angular, there are roughly two kinds of methods can achieve requirements. First is about raw file content. You can upload raw content with other values of form fields together, and their values will be separated automatically by browsers using Content-Type: multipart/form. myForm: FormGroup = null; fileName: string = ''; /** * constructor of a component */ constructor( private _formBuilder:

read more
Create Mechanism of Role Resource Permission of Nebular and Ngxadmin
學習 Create Mechanism of Role Resource Permission of Nebular and Ngxadmin

Nebular is a UI libary from Akveo company for Angular. It can be customized for meeting your needs and has many components and visual themes. It also has authenticate and security modules. NgxAdmin is an admin dashboard built based on Nebular. NgxAdmin is also customizable. Key tip: I use isGranted() of NbAccessChecker from Nebular’s security package, canLoad and canActivate directive from Angular framework to achieve features inside this article. I

read more
overcome-setup-of-cypress-for-web-single-page-application | 征服 Cypress 用於 web S.P.A. UI 自動化測試之起始設定
學習 overcome-setup-of-cypress-for-web-single-page-application | 征服 Cypress 用於 web S.P.A. UI 自動化測試之起始設定

Modern web systems often require users to login first and then allow those, who are login successfully, start to use. If these systems are built with concept of single page application, it’s good to try Cypress for automatic UI end-to-end testing. The login is first one need to be solved for Cypress testing. Notice: The content of this article has been tested at cypress version 5.6.0, 6.2.0, angular version 6.1.10,

read more

About

Howard Lee, Frontend-engineer with Angular 7+, Typescript, ReactJS, VueJS. Flutter, Dart, PHP, Ruby, JavaScript, HTML, SASS, CSS, Postgres, MySQL, Web Developer. Have a certificate of AWS Solution Architect Associate with verify number: 8FYNL55LCEEQ10W5. You can verify at AWS Certificate site or Credly site Tech lead role Lead 4 colleagues to build products and infrastructure Coordinate schedule of delivering products Senior web frontend developer role Products Form-filling, form-sharing, file-management, repair-managemnt and project-management for construction industry at Suiqui IoT management and EC platform for Liquid Petroleum Gas(LPG) at Wave-In Comm.

Know More

Tag

Social