Guest User

Untitled

a guest
Feb 18th, 2019
96
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.83 KB | None | 0 0
  1. EXECUTE sp_execute_external_script
  2. @language =N'Python',
  3. @script=N'
  4. print(''hello world'')
  5. ';
  6.  
  7. EXEC sp_execute_external_script
  8. @language = N'Python',
  9. @script = N'
  10. import pip
  11. import pandas as pd
  12. installed_packages = pip.get_installed_distributions()
  13. installed_packages_list = sorted(["%s==%s" % (i.key, i.version)
  14. for i in installed_packages])
  15. df = pd.DataFrame(installed_packages_list)
  16. OutputDataSet = df
  17. '
  18. WITH RESULT SETS (( PackageVersion nvarchar (150) ))
  19.  
  20. EXECUTE sp_execute_external_script
  21. @language =N'Python',
  22. @script=N'
  23. import sys
  24. import codecs
  25. import requests
  26.  
  27. tmp = ''7805729430''
  28. headers = {
  29. ''Content-Type'': ''application/json'',
  30. ''Accept'': ''application/json'',
  31. ''Authorization'': ''Token _token_'',
  32. }
  33.  
  34. data = ''{ "query": '' + tmp + ''}''
  35.  
  36. response = requests.post(''url'', headers=headers, data=data)
  37. ';
Add Comment
Please, Sign In to add comment