bekusib's develop story bekusib's develop story

SQL

• [node] Excel file export

  Programing/javascript 2019. 11. 21. 17:52

  I need to get the excel data which is the result of db query. And I've got it successfully by using 'node-excel-export' module. [Source Code] main.js const exportExcel = require('./excel_export').exportExcel; ... function run() { ... const qData = getLogs();// QUERY exportExcel(qData); ... } run(); excel_export.js const excel = require('node-excel-export'); ... const exportExcel = (dataset) => {..

  Read More
• [sqlite] weekly & month statistics query

  Frontend/react-native 2019. 11. 8. 12:15

  운동 기록 records에서 주간별 볼륨합을 구해서 그래프로 변화를 표현하고자 한다. (I'll calculate weekly & monthly volume sums and represent the changes in graph.) [Weekly] mysql: SELECT DATE_FORMAT(DATE_SUB(today, INTERVAL (DAYOFWEEK(today)-1) DAY), '%Y/%m/%d') as start, DATE_FORMAT(DATE_SUB(today, INTERVAL (DAYOFWEEK(today)-7) DAY), '%Y/%m/%d') as end, DATE_FORMAT(`today`, '%Y%U') AS `date`, sum(volume) as volume FROM records ..

  Read More