python

python

python – Capture the WHERE clause of an SQL query

Question: I need to capture only the where clause of several queries to analyze the filters used. For example: select “DIM_1”.”col1″, “DIM_2”.”col2″ , “DIM_3”.”col3″ , “DIM_4”.”col4″ , “FAT_1”.”col5″ from “FAT_1”, “DIM_1”, “DIM_2”, “DIM_3”, “DIM_4” where “DIM_1”.”col1″ IS NOT NULL AND “DIM_2”.”col2″ LIKE (‘SUCCESS’) AND “DIM_3”.”col3″ BETWEEN 20161213 AND 20161222 AND …

python – Capture the WHERE clause of an SQL query Read More »

python – Where and how should the "password to access WebAPI" be stored in general?

Question: Question: environment Python 3.6 requests module Current status I want to access WebAPI X from my local machine to get information. The specifications of WebAPI X are as follows. Authentication required. To authenticate, run the API for Login. Pass Login ID and Password to API for Login. I use …

python – Where and how should the "password to access WebAPI" be stored in general? Read More »

python – Bypassing the array in depth: the code for counting the number of beds in a garden plot does not pass tests on the site

Question: A rectangular garden plot N meters wide and M meters long is divided into squares with a side of 1 meter. Beds have been dug up in this area. A bed is a collection of squares that satisfies the following conditions: – from any square of this bed you …

python – Bypassing the array in depth: the code for counting the number of beds in a garden plot does not pass tests on the site Read More »

python – Tkinter problem placing icon image.ico

Question: Trying to put an icon in the window with Python's Tkinter, it gives me an error. What's going on? Code: from tkinter import * root = Tk() root.title(“Hola mundo”) root.resizable(1,0) root.iconbitmap(‘imagen.ico’) frame = Frame(root) frame.pack() frame.config(width=480, height=520) root.mainloop() Error: File “C:\Miniconda3\envs\py37\lib\tkinter\__init__.py”, line 1871, in wm_iconbitmap return self.tk.call(‘wm’, ‘iconbitmap’, self._w, …

python – Tkinter problem placing icon image.ico Read More »

Scroll to Top