Skip to content

Instantly share code, notes, and snippets.

View potados99's full-sized avatar
πŸ˜†
히히

솑병쀀 potados99

πŸ˜†
히히
View GitHub Profile
@potados99
potados99 / package_module_method.sql
Created December 27, 2022 05:50
νŒ¨ν‚€μ§€ λͺ¨λ“ˆ λ©”μ†Œλ“œ ν…œν”Œλ¦Ώ
/**
λ‚΄λΆ€μ—μ„œ μ‚¬μš©λ˜λŠ” νŒ¨ν‚€μ§€ λͺ¨λ“ˆμš© λ©”μ†Œλ“œ ν”„λ‘œμ‹œμ € ν…œν”Œλ¦Ώμž…λ‹ˆλ‹€.
νŠΈλžœμž­μ…˜κ³Ό μ˜ˆμ™Έ μ²˜λ¦¬κΈ°κ°€ μ—†μŠ΅λ‹ˆλ‹€.
ν”„λ‘œμ‹œμ € 이름, μ•„λž˜ 주석과 v_tag, v_summary, v_detail을 μˆ˜μ •ν•œ ν›„ μ‚¬μš©ν•˜μ—¬ μ£Όμ„Έμš”.
*/
create
definer = MES_DHSol@`%` procedure Package_Module_Method(
)
comment '~ν•˜λŠ” ν”„λ‘œμ‹œμ €'
begin
@potados99
potados99 / package_module_function.sql
Created December 27, 2022 05:50
νŒ¨ν‚€μ§€ λͺ¨λ“ˆ ν•¨μˆ˜ ν…œν”Œλ¦Ώ
/**
λ‚΄λΆ€μ—μ„œ μ‚¬μš©λ˜λŠ” νŒ¨ν‚€μ§€ λͺ¨λ“ˆμš© λ©”μ†Œλ“œ ν•¨μˆ˜ ν…œν”Œλ¦Ώμž…λ‹ˆλ‹€.
νŠΈλžœμž­μ…˜κ³Ό μ˜ˆμ™Έ μ²˜λ¦¬κΈ°κ°€ μ—†μŠ΅λ‹ˆλ‹€.
ν•¨μˆ˜ 이름, μ•„λž˜ 주석과 v_tag, v_summary, v_detail을 μˆ˜μ •ν•œ ν›„ μ‚¬μš©ν•˜μ—¬ μ£Όμ„Έμš”.
*/
create
definer = MES_DHSol@`%` function Package_Module_Method(
) returns varchar(32)
comment '~ν•˜λŠ” ν•¨μˆ˜'
begin
@potados99
potados99 / index.js
Last active July 29, 2023 14:37
μž„μ‹œ 데이터 μˆ˜μ§‘κΈ°(collect.potados.com) AWS Lambda κ΅¬ν˜„
const fs = require('fs').promises;
const path = require('path');
const { randomUUID } = require('crypto');
async function getDataSource(channelName) {
const channelNameSanitized = channelName.replace(/\//g, '').replace(/\./g, '').trim();
if (!channelNameSanitized) {
throw new Error(`Invalid channel name: [${channelName}]`);
}
@potados99
potados99 / cloud-config.txt
Last active October 30, 2022 14:46
RMS Cloud Config
Zv65DvZ4uip59etBkYX2eVt5gDWosL2+U7Ll0BdQ41tZv2MrD6pQQ3VzomCiQkJgruU/wAZnG3NY0HJRevAVGttC3dU5+s3km2r6Cf2k4UaN37wKMz7JZIu6wMJ4kqFDW73hIeieTEZW8DZki66cvO++W+fuz9Kajio2k/ZslbSSZ3BkzNp3E12Gb99m9v18rZpROWQ5xMPbnZkLMNW68yMHeNGcWMJuiN++FyRDCSRu3PwTmVZBkWC9pi+n1BYqTacnd3cbboYrWG6M4uFn1p7X28X5seDVKlx3S+t4xbwJJAOIWDG3BNyAuWmTM9tXNShnWhjs/nLgAtHmuEo4Q5FQwMtYVrcNlAd92G9FC605vkZazXvG1q31PmpHKRUOOi25w7jKrl3NzbJsiHyf7Es/VGtKse/26SE/oVOZeI10jL9BAfGzLdFtpwYaVZqT58vo8Ld0YCEaIzZ7dVDQQbg5AAso5U29QE+AxAHZQxYzBn6BBKlde0e0E32uIwBocWZNMtY6y5dHuDLpaZ/gXvYA/23l92mwKcC8rhVfUXVrIIHsA2I5fAhdUKp3atNgdugu+M9o5N1laB8fT1KqwFulbsCrG2v5AuUiuza1XYrQFb2k6JPOgLYOT3nftQqEPyiD4rViXlzbCZ/BzZ/vKUw1EEOFq1WXAo+X6o1EZ8lJwRVCdtZJbVaEdv8iSLTs9qaFPxu/Jkw+vcevINoCFr+R8vGn0OKVM+EjEJpospH7TDHVe7rVeinLbjbmSZQd3QBdqYo8U8K8QQEpqqXUgA/qxGdG11qOGP7lBtX5719QOGJCRIkJpLBaEaWYdW8mkm+ediAI9GhvedTK8TUsqr1FbVkvgpS5W/3K8wYTpfR41xKWbQi0qiH5E3wlI90TDCNM9HMS7Xo1WONJyaAeVQ==
create procedure sp_insert_something(in something varchar(255))
begin
-- ...μƒλž΅...
if something = 'hello' then
insert into things set body = something;
end if;
-- ...μƒλž΅...
end;
@potados99
potados99 / fuck-netfunnel.js
Last active June 20, 2022 02:02
NetFunnel λš«μ–΄λ²„λ¦¬κΈ°
// Modify
(function () {
const originalFunction = window.originalFunction || NetFunnel_getTidChkEnter;
window.originalFunction = originalFunction;
NetFunnel_getTidChkEnter = function (options) {
if (options == null) {
console.error("μ˜΅μ…˜μ΄ μ—†μ–΄??");
return originalFunction(...arguments);
}
@potados99
potados99 / combination.js
Created May 10, 2022 01:37
μžλ°”μŠ€ν¬λ¦½νŠΈλ‘œ λ°°μ—΄ μ‘°ν•© κ΅¬ν•˜κΈ°
function combination(source, howMany = source.length) {
const result = [];
const sourceLength = source.length;
const pow = (workingCombo, currentIndex, remainingCount) => {
for (let i = currentIndex; i < sourceLength; i++) {
const nextWorkingCombo = [...workingCombo, source[i]];
if (remainingCount === 1) {
// 이번 ν˜ΈμΆœμ€ λ§ˆμ§€λ§‰ λ‹¨κ³„μ΄λ‹ˆ,
@potados99
potados99 / poly.py
Last active June 17, 2021 13:48
How to deal with polynomials
def addPoly(a: list, b: list):
index_a = 0
index_b = 0
len_a = len(a)
len_b = len(b)
result = []
while True:
@potados99
potados99 / codepush-ram-bundle-ios.sh
Created May 31, 2021 04:48
Deploy unbundled output to Code Push
#!/bin/bash
mkdir ./CodePush
react-native ram-bundle --platform ios \
--entry-file index.js \
--bundle-output ./CodePush/main.jsbundle \
--assets-dest ./CodePush \
--indexed-ram-bundle \
--dev false
@potados99
potados99 / script.sh
Created April 3, 2021 10:26
Get path of current script
#!/bin/bash
DIR="$(dirname "$(realpath "$0")")"