This script was made by Steven Checo
- You need to run the following code once, before create the stored procedure
sp_configure 'show advanced options', 1;
GO
RECONFIGURE;
| //Sorting algorithms if i need it one day | |
| function SortWith() {}; | |
| //Sorting Algorithm: The Cocktail Shaker Sort | |
| // Complexity: O(n^2) | |
| SortWith.cocktail = function (arr) { | |
| for (var i = 0; i < arr.length / 2; ++i) { | |
| var swap = false; | |
| for (var j = i; j < arr.length - i - 1; ++j) { |
| /*jshint esversion: 6*/ | |
| const tabula = require('tabula-js'); | |
| const path = require('path'); | |
| const fs = require('fs'); | |
| let location = path.join(__dirname, '/test.pdf'); | |
| let resultFile = path.join(__dirname, '/output.csv'); | |
| let cmd = tabula(location,{area: "146.52,36.135,549.45,755.865", pages: "2"}) | |
| .extractCsv((err, data) => { | |
| let output = []; |
| const loop = (() => { | |
| const recur = (callback, count, i=0) => { | |
| if (i == count-1) return callback(i); | |
| callback(i); | |
| return recur(callback, count, i+1); | |
| }; | |
| return (callback, count) => { | |
| if (count > 0) return recur(callback, count); | |
| }; | |
| })(); |
| import React, { useLayoutEffect } from 'react' | |
| const useDidMount = (f) => { | |
| const [mounted, setState] = useState(false) | |
| useLayoutEffect(() => { | |
| setState((!mounted) ? true : false) | |
| f() | |
| }) | |
This script was made by Steven Checo
sp_configure 'show advanced options', 1;
GO
RECONFIGURE;