This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
const getPagedUserIDByDateRangeAndWhitelist = `-- name: GetPagedUserIDByDateRangeAndWhitelist :many | |
SELECT user_id | |
FROM main_trx | |
WHERE created_at between ? AND ? | |
AND trx_amount > 0 | |
AND user_id IN (???) LIMIT ? | |
` | |
type GetPagedHPEOvoIdByDateRangeAndWhitelistToExpiryParams struct { | |
CreatedAtStart sql.NullTime |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
func compileInQuery(originalQuery string, argsWithInKeyword [][]interface{}, originalArg interface{}) (string, []interface{}, error) { | |
/** | |
capturing group result: | |
group 0: whole match | |
group 1: ([a-zA-Z_]+\.)?, table name | |
group 2: ([a-zA-Z_]+), column name | |
group 3: (NOT )?, NOT flag | |
*/ | |
regex := regexp.MustCompile(`([a-zA-Z_]+\.)?([a-zA-Z_]+) ([Nn][Oo][Tt] )?[Ii][Nn] \(\?\?\?\)`) | |
match := regex.FindAllStringSubmatch(originalQuery, -1) |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<html> | |
<head> | |
<script src="https://code.jquery.com/jquery-1.11.1.min.js"></script> | |
</head> | |
<body> | |
<div id="target"></div> | |
<script> | |
const malPayload = "<script>alert('1337')<\/script>"; | |
// current code |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
from random import choice | |
from time import time | |
def if_function(char_input): | |
if char_input == "A": | |
return "istimewa" | |
if char_input == "B": | |
return "baik" | |
if char_input == "C": | |
return "cukup" |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
#As part of a data processing pipeline, complete the implementation of the pipeline method: | |
#The method should accept a variable number of functions, and it should return a new function that accepts one parameter arg. | |
#The returned function should call the first function in the pipeline with the parameter arg, and call the second function with the result of the first function. | |
#The returned function should continue calling each function in the pipeline in order, following the same pattern, and return the value from the last function. | |
#For example, pipeline(lambda x: x * 3, lambda x: x + 1, lambda x: x / 2) then calling the returned function with 3 should return 5.0. | |
#https://www.testdome.com/questions/python/pipeline/24245?visibility=1&skillId=9 | |
def pipeline(*funcs): | |
def helper(arg): |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
#Implement the unique_names method. When passed two arrays of names, it will return an array containing the names that appear in either or both arrays. The returned array should have no duplicates. | |
#For example, calling unique_names(['Ava', 'Emma', 'Olivia'], ['Olivia', 'Sophia', 'Emma']) should return an array containing Ava, Emma, Olivia, and Sophia in any order. | |
#https://www.testdome.com/questions/python/merge-names/24231?visibility=1&skillId=9 | |
def unique_names(names1, names2): | |
unique_list = lambda input_var: list(set(input_var)) | |
return unique_list(names1) + [name for name in unique_list(names2) if name not in names1] | |
names1 = ["Ava", "Emma", "Olivia"] |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
--The following data definition defines an organization's employee hierarchy. | |
--An employee is a manager if any other employee has their managerId set to the first employees id. An employee who is a manager may or may not also have a manager. | |
--TABLE employees | |
-- id INTEGER NOT NULL PRIMARY KEY | |
-- managerId INTEGER REFERENCES employees(id) | |
-- name VARCHAR(30) NOT NULL | |
--Write a query that selects the names of employees who are not managers. | |
--https://www.testdome.com/questions/sql/workers/13562?visibility=1&skillId=17 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
--App usage data are kept in the following table: | |
--TABLE sessions | |
-- id INTEGER PRIMARY KEY, | |
-- userId INTEGER NOT NULL, | |
-- duration DECIMAL NOT NULL | |
--Write a query that selects userId and average session duration for each user who has more than one session. | |
--https://www.testdome.com/questions/sql/sessions/14245?visibility=1&skillId=17 | |
select userId, avg(duration) from sessions group by userId having count(1) > 1 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Perjalanan data di dalam rombongan data yang besar | |
Intro: | |
- Datum | |
- Data not datas | |
Pertemuan pertama: | |
- Data engineer | |
- Transformasi data: | |
-- Dimension table, sumbernya dari OLTP. Data ini akan di-update secara berkala ke OLAP melalui ETL. |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
def ez_pattern(n, current=1): | |
if n == current: | |
__ez_pattern_mid(n, current) | |
else: | |
__ez_pattern_top(current, n) | |
ez_pattern(n, current + 1) | |
__ez_pattern_bot(current, n) | |
def __get_mult(printed_char, n): | |
div_printed_char = printed_char // 4 |
NewerOlder