Skip to content

Instantly share code, notes, and snippets.

View jaganadhg's full-sized avatar
🎯
Focusing

Jaganadh Gopinadhan jaganadhg

🎯
Focusing
View GitHub Profile
@jaganadhg
jaganadhg / TDstat.sql
Last active June 2, 2023 19:22
TDstat.sql
SELECT DatabaseName, TableName, SUM(ReadCount) AS TotalReadCount
FROM IDW_STATS_V.IDW_TABLE_USAGE_DETAILS
GROUP BY DatabaseName, TableName
ORDER BY TotalReadCount DESC;
HELP COLUMN IDW_STATS_V.IDW_TABLE_USAGE_DETAILS.*;
SELECT DatabaseName, TableName, SUM(AccessCount) AS TotalAccessCount
sample = {
"menu": {
"id": "file",
"value": "File",
"popup": {
"menuitem": [{
"value": "New",
"onclick": "CreateDoc()"
}, {
"value": "Open",

A large hotel reservation company wants to build the next generation hotel reservation and management system specifically tailored to high-end resorts and spas where guests can view and reserve specific rooms.

Users: Guests (hundreds), hotel staff (less than 20)

Requirements:

Registration can be made via web, mobile, phone call, or walk-in. Guests have the ability to either book a type of room (standard, deluxe, or suite) or choose a specific room to stay in by viewing pictures of each room and its location in the hotel.

@jaganadhg
jaganadhg / research.md
Created April 8, 2022 21:06
Research Papers Cited Me
@jaganadhg
jaganadhg / codex_sum.csv
Created August 13, 2021 08:19
Code_data
Codex Assists (Count) Minimum Number of Problems Attempted Maximum Number of Problems Attempted Time Taken to Complete (Minimum) Time Taken to Complete (Maximum) Count of Participants
0 5 5 71 81 5
1 5 5 81 89 3
2 5 5 48 86 4
3 5 5 37 37 1
4 5 5 36 87 7
5 5 5 53 86 3
6 5 5 50 83 5
7 5 5 44 90 5
8 5 5 24 87 9
@jaganadhg
jaganadhg / codexsun.md
Created August 13, 2021 08:15
Codex Summary

======================= ====================================== ====================================== ================================== ================================== ======================= Codex Assists (Count) Minimum Number of Problems Attempted Maximum Number of Problems Attempted Time Taken to Complete (Minimum) Time Taken to Complete (Maximum) Count of Participants
======================= ====================================== ====================================== ================================== ================================== ======================= 0 5 5 71 81 5
1 5 5 81 89 3
2

@jaganadhg
jaganadhg / spm2.py
Created May 14, 2021 19:42
spsm_sol2
import re
sample_strm = "a%3b%2c:4d:5"
def split_sort_smart(input_str):
base_list = re.split(r'(\w+%\d+|\w+:\d+)',input_str)
split_pattern = '|'.join(map(re.escape,['%',':']))
base_list = [l for l in base_list if len(l) > 0]
@jaganadhg
jaganadhg / spm.py
Created May 14, 2021 18:59
Sp magic
import re
sample_str = "a%3,b%2,c:4,d:5"
def spit_sort(inp_str, delims = ['%',':']):
base_list = inp_str.split(",")
split_pattern = '|'.join(map(re.escape,delims))
print(split_pattern)
@jaganadhg
jaganadhg / gip.py
Last active May 14, 2021 18:01
gip
import itertools
base_ip = "1.1.1.1"
ip_max = 3
def gen_ip_smart(base_ip : str) -> list:
ip_elem = base_ip.split(".")
ip_elem = list(map(int,ip_elem))