2022年 11月 7日

python 在线编译器

 
  1. import os, sys, subprocess, time
  2.  
  3.  
  4. class AdvanceQuery(object):
  5.     def __init__(self):
  6.         self.TempFile = "media/advance_query"
  7.         # 文件名
  8.         self.FileNum = int(time.time() * 1000)
  9.         # python编译器位置
  10.         self.EXEC = sys.executable
  11.  
  12.     # 获取python版本
  13.     def get_version(self):
  14.         v = sys.version_info
  15.         version = "python %s.%s" % (v.major, v.minor)
  16.         return version
  17.  
  18.     # 获得py文件名
  19.     def get_pyname(self):
  20.         return '%d' % self.FileNum
  21.  
  22.     # 接收代码写入文件
  23.     def write_file(self, pyname, code):
  24.         if not os.path.exists(self.TempFile):
  25.             os.mkdir(self.TempFile)
  26.         fpath = os.path.join(self.TempFile, '%s.py' % pyname)
  27.         with open(fpath, 'w', encoding='utf-8') as f:
  28.             f.write(code)
  29.         # print('file path: %s' % fpath)
  30.         return fpath
  31.  
  32.     # 编码
  33.     def decode(self, s):
  34.         try:
  35.             return s.decode('utf-8')
  36.         except UnicodeDecodeError:
  37.             return s.decode('gbk')
  38.  
  39.     def query_main(self, code):
  40.         r = dict()
  41.         r["version"] = self.get_version()
  42.         pyname = self.get_pyname()
  43.         fpath = self.write_file(pyname, code)
  44.         try:
  45.             # subprocess.check_output 是 父进程等待子进程完成，返回子进程向标准输出的输出结果
  46.             # stderr是标准输出的类型
  47.             """subprocess.check_output(args, *, stdin=None, stderr=None, shell=False, universal_newlines=False)
  48.             父进程直接创建子进程执行程序，以字符串的形式返回子进程的输出。"""
  49.             outdata = self.decode(subprocess.check_output([self.EXEC, fpath], stderr=subprocess.STDOUT, timeout=5))
  50.         except subprocess.CalledProcessError as e:
  51.             # e.output是错误信息标准输出
  52.             # 错误返回的数据
  53.             r["code"] = 'Error'
  54.             r["output"] = self.decode(e.output)
  55.             return r
  56.         else:
  57.             # 成功返回的数据
  58.             r['output'] = outdata
  59.             r["code"] = "Success"
  60.             return r
  61.         finally:
  62.             # 删除文件(其实不用删除临时文件会自动删除)
  63.             try:
  64.                 os.remove(fpath)
  65.             except Exception as e:
  66.                 exit(1)
  67.  
  68.     # 显示csv列表
  69.     def csv_list(self):
  70.         path = os.getcwd()
  71.         alist = []
  72.         for i in os.listdir(os.path.join(path, "csv")):
  73.             # print(os.path.join(path, "csv"))
  74.             if i.split(".")[1] == "csv":
  75.                 alist.append(i)
  76.         data = {"csv_list": alist}
  77.         return data
  78.  
  79.     # 根据csv返回相应语句显示
  80.     def show_statement(self, st):
  81.         if st:
  82.             data = 'import pandas as pd\ndp = pd.read_csv("csv/%s")' % st
  83.             return data