So I have a shell script which returns me the week number using an SQL query : This query returns 1. (Starting at 1st Jan) Python code: I have tried the following however it returns 52 rather than 1 : Week starting from Mon-Sun Is there another way in which I can get the week number of year based on
Tag: sql
Inserting rows from df to MS Access Error “number of query values and destination fields are not the same”
I have a dataframe called df2 which has the following columns: I count this as 8 columns. I have saved the column names into cols: Again, I’m seeing 8 columns. And, in Access I have a table that has these columns (none of which are assigned as a primary key, for now): which is 8 columns. I tried to exec…
how to do a subquery or filter in a condition met by a previous query correctly
Im using python, flask and sqlalchemy have the query below: Now let’s assume that i want to search for the condition Foo1.id != 2 but still make sure that i meet the condition of the query above, what would be the best way to achieve that (i am trying to learn how to do subquery or filter in another que…
Convert nested list to JSON using Python
I’m using the following SQL query to get data for every month in a given year: When I’m returning this via Python, I’m getting the following result: Also, there are n everywhere in the result. I need the result in JSON format, but I can’t get it right. How can I do it? Answer If l is t…
How can I access a SQL file while using python?
Right now I’m using Microsoft SQL Community to start a database, but for some reason I can’t command the server to do something that I want, is there any to use the library sqlite3 or pyodc to print a value that I want on the console? PYTHON: SQL: Answer sqlite3 talks to SQLite databases. If you w…
Table get locked when called an SQL Server SP from pyodbc Python [closed]
Closed. This question needs details or clarity. It is not currently accepting answers. Want to improve this question? Add details and clarify the problem by editing this post. Closed 1 year ago. Improve this question Table get locked when called an SQL Server SP from pyodbc Python I have a table I made for te…
dedup records(window function pandas)
Hi I am looking to dedup my records ordered by cancel date so I will only be interested in the most recent record. sample data id cancel_date type_of_fruit 1 2021-03-02 apple 1 2021-01-01 apple 2 2021-02-01 orange expected output id cancel_date type_of_fruit 1 2021-03-02 apple 2 2021-02-01 orange I wrote the …
How to validate request body in FastAPI?
I understand that if the incoming request body misses certain required keys, FastAPI will automatically raise 422 unserviceable entity error. However, is there a way to check the incoming request body by myself in the code and raise a 400 bad request if if misses required names? For example, say I have this m…
Trouble With SQL Query in Python
Hello I’m getting an error: near “join”: syntax error. Is there an obvious issue with this that I’m not picking up on? I’ve changed names in the query but I’ve gone over and checked for spelling errors already. Answer In SQL, the order of clauses is SELECT, FROM, JOIN, WHER…
Runtime Error: Incomplete output while executing buy function for cs50 finance
While all the checks work, (empty symbol, invalid number of shares…), the function fails to actually purchase the stocks. It returns an internal server error. Following is the log output: File “/usr/local/lib/python3.9/site-packages/cs50/sql.py”, line 71, in _execute raise RuntimeError(exc.o…