Url.sql 1.1 KB

1234567891011121314151617181920212223242526272829
  1. /* syntax version 1 */
  2. SELECT
  3. value,
  4. Url::Parse(value) AS parse,
  5. Url::GetSignificantDomain(value) AS significant_domain,
  6. Url::GetSignificantDomain(value, AsList("tl")) AS tl_is_significant,
  7. Url::GetTLD(value) AS tld,
  8. Url::PunycodeToHostName(value) AS punycode,
  9. Url::Encode(value) AS encode,
  10. Url::Decode(value) AS decode,
  11. Url::GetCGIParam(value, "foo") AS param,
  12. Url::CutQueryStringAndFragment(value) AS cut_qs_and_fragment,
  13. Url::CutWWW(Url::GetHost(value)) AS cut_www,
  14. Url::CutWWW2(Url::GetHost(value)) AS cut_www2,
  15. Url::GetHost(value) as host,
  16. Url::GetHostPort(value) as host_port,
  17. Url::GetSchemeHost(value) AS scheme_host,
  18. Url::GetSchemeHostPort(value) AS scheme_host_port,
  19. Url::CutScheme(value) AS cut_scheme,
  20. Url::GetTail(value) AS tail,
  21. Url::GetPath(value) AS path,
  22. Url::GetFragment(value) AS fragment,
  23. Url::GetPort(value) AS port,
  24. Url::GetDomain(value, 0) as domain0,
  25. Url::GetDomain(value, 1) as domain1,
  26. Url::GetDomain(value, 3) as domain3,
  27. Url::GetDomainLevel(value) as domain_level,
  28. Url::Normalize(value) as norm
  29. FROM Input;