BlockUrl.sql 991 B

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