home / system

Menu
  • GraphQL API
  • Search all tables

tools_source

Table actions
  • GraphQL API for tools_source

Data license: All Rights Reserved · Data source: krisyotam.com · About: Kris Yotam

2 rows where tool_id = 4

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ tool_id filename language content
17 resolve 4 resolve.py py #!/usr/bin/env python3 """resolve — bulk dns resolver""" import socket import sys def resolve(domain: str): for family, type_name in [(socket.AF_INET, "A"), (socket.AF_INET6, "AAAA")]: try: results = socket.getaddrinfo(domain, None, family, socket.SOCK_STREAM) for _, _, _, _, addr in results: print(f"{domain}\t{type_name}\t{addr[0]}") except socket.gaierror: pass def main(): source = open(sys.argv[1]) if len(sys.argv) > 1 else sys.stdin for line in source: domain = line.strip() if domain: resolve(domain) if __name__ == "__main__": main()
18 resolve 4 resolve.sh sh #!/bin/sh # resolve — bulk dns resolver file="${1:--}" while IFS= read -r domain; do [ -z "$domain" ] && continue dig +short A "$domain" 2>/dev/null | while IFS= read -r ip; do printf '%s\tA\t%s\n' "$domain" "$ip" done dig +short AAAA "$domain" 2>/dev/null | while IFS= read -r ip; do printf '%s\tAAAA\t%s\n' "$domain" "$ip" done done < "$file"

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE tools_source (id INTEGER PRIMARY KEY AUTOINCREMENT, tool_id INTEGER NOT NULL, filename TEXT NOT NULL, language TEXT NOT NULL, content TEXT NOT NULL, FOREIGN KEY (tool_id) REFERENCES tools(id) ON DELETE CASCADE, UNIQUE(tool_id, language));
Powered by Datasette · 14.731ms · krisyotam.com