Hello guys, I am desperate for some help/ideas.
I am running some code (data analysis) using doltpy from Dolt and it was working before on a previous version of anaconda. I had some issues and I had to update to python 3.8 , latest version of anaconda (in about it says navigator 1.10) and jupyter 6.3.0
I get the following error :
PermissionError Traceback (most recent call last)
<ipython-input-2-60fb9fd8d8f2> in <module>
1 dolt = Dolt('hospital-price-transparency') # dolt folder
2
----> 3 df_hospitals = read_pandas(dolt, 'hospitals') # loading table from the doltt folder
4
5 search = SearchEngine(simple_zipcode=False) # zip code search for median income
C:\ProgramData\Anaconda\envs\jupyter_conda\lib\site-packages\doltpy\cli\read.py in read_pandas(dolt, table, as_of)
26
27 def read_pandas(dolt: Dolt, table: str, as_of: str = None) -> pd.DataFrame:
---> 28 return read_pandas_sql(dolt, get_read_table_asof_query(table, as_of))
C:\ProgramData\Anaconda\envs\jupyter_conda\lib\site-packages\doltpy\cli\read.py in read_pandas_sql(dolt, sql)
22
23 def read_pandas_sql(dolt: Dolt, sql: str) -> pd.DataFrame:
---> 24 return read_table_sql(dolt, sql, result_parser=parse_to_pandas)
25
26
C:\ProgramData\Anaconda\envs\jupyter_conda\lib\site-packages\doltcli\utils.py in read_table_sql(dolt, sql, result_parser)
43 dolt: DoltT, sql: str, result_parser: Optional[Callable[[str], Any]] = None
44 ) -> List[dict]:
---> 45 return dolt.sql(sql, result_format="csv", result_parser=result_parser)
46
47
C:\ProgramData\Anaconda\envs\jupyter_conda\lib\site-packages\doltcli\dolt.py in sql(self, query, result_format, execute, save, message, list_saved, batch, multi_db_dir, result_file, result_parser, **kwargs)
581 with tempfile.NamedTemporaryFile() as f:
582 args.extend(["--result-format", "csv"])
--> 583 output_file = self.execute(args, stdout_to_file=f.name, **kwargs)
584 if not hasattr(result_parser, "__call__"):
585 raise ValueError(
C:\ProgramData\Anaconda\envs\jupyter_conda\lib\site-packages\doltcli\dolt.py in execute(self, args, print_output, stdout_to_file, error)
328 output = repr(e)
329 else:
--> 330 output = _execute(args, self.repo_dir, outfile=stdout_to_file)
331
332 print_output = print_output or self._print_output
C:\ProgramData\Anaconda\envs\jupyter_conda\lib\site-packages\doltcli\dolt.py in _execute(args, cwd, outfile)
77 logger.info(str_args)
78 if outfile:
---> 79 with open(outfile, "w") as f:
80 # _outfile = open(outfile, "w") if outfile else PIPE
81 proc = Popen(args=_args, cwd=cwd, stdout=f, stderr=PIPE)
PermissionError: [Errno 13] Permission denied: 'C:\\Users\\V\\AppData\\Local\\Temp\\tmp6bgk4nte'
I tried reinstalling the anaconda various ways, with administrator rights, etc. Creating a new environments and creating a new temp folder (with granted permission to everything ) in win variables, but it’s all in vain, the error is still there.
I will be massively grateful for suggestions/advice how to fix this (uni project with deadline )