python
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 »
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 »
Question: How can I generate a list of all combinations of digits in a four digit number? The first digit can contain 0. There are 4 digits, each can contain a number from 0 to 9. As I understand it, this is 10^4 . How can this be implemented? Answer: …
python – How can I generate a list of all combinations of digits in a four digit number? Read More »
Question: Question: Is there a way to compile a program written in Python 3 into an executable binary? Instead of just compiling to bytecode (* .pyc), I want to translate it into machine language so that a third party can run the program without installing his Python implementation. It would …
How to compile a Python program into an executable binary? Read More »
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 …
Question: The problem is that I have a list "l" from which I want to select a random item several times without repeating it, and I don't know how to do it. Any suggestion? import random l = [“a”, “b”, “c”, “d”] sel1 = random.choice(l) So far so good, but …
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, …
Question: I am doing this exercise, and it always throws me the last question (Today I rest). I don't understand what I'm doing wrong, surely something very simple (but, that's when the answer is found). Create a program that asks from the keyboard if there is "chocolate" first and if …
Question: how do i make a function to determine the smallest string in a list ignoring spaces? For example, when typing: menor_elemento([“joão”, ” a “, “arrozz”]) the output should return "a" (no spaces) as it is the shortest string (ignoring spaces). Here is the code I tried: def menor_nome(nome): m …
Question: It is necessary to receive all ever entered users on Windows. The Public folder should not be in the list. This construction doesn't work: – name: TEST find 4 win block: – win_find: paths: C:\Users\ file_type: directory excludes: Public register: win_find_out – debug: msg: “{{ win_find_out.files }}” There is …
