I have a set of large tables with many records each. I’m writing a Python program that SELECTs a large number of records from these tables, based on the value of multiple columns on those records. Essentially, these are going to be lots of queries of the form: Each table has a different set of columns, …
Tag: python
My SQL Python ProgrammingError: 1064 (42000) [closed]
Closed. This question is not reproducible or was caused by typos. It is not currently accepting answers. Want to improve this question? Update the question so it’s on-topic for Stack Overflow. Closed 2 years ago. Improve this question I am trying to store scraped data with scrapy to a sql database but I…
Storing data to SQL not working with my sql connector and scrapy
I am trying to store my scraped data with scrapy to a SQL database but my code does not send anything while no error is mentioned when runned. I am using my sql connector since I don’t manage to install MySQL-python. My SQL database seems to running well and when I run the code the traffic KB/s raise. P…
Subquery django query to get biggest disctint values from objects and return those objects
So I have this query that I need to re-filter to get just the biggest taken_at field’s value from distinct meter id, but I cannot get the django orm’s/sql part to makes this query. <QuerySet [<Reading: [127] meter installation: 29, type: 1, taken: 2019-10-07 16:06:48.101453+00:00 value: 78.0…
TypeError: Params must be in a list, tuple, or Row in Python
I built out a python script the retrieves data from Auth0 and publish it to Ms-sql but im getting errors When I did the print statements, everything printed great. but when i used SQL commands to try to populate my table, it returns this error Any suggestions/insights appreciated! Answer executemany executes …
Extracting unique values with SQL [closed]
I’m new to SQL and would greatly appreciate your help with extracting data from a hive table. The table contains two relevant columns: host and url. The url column has a lot of duplicates and …
Is it possible to create custom “Columns” in SQLAlchemy? is this breaking OOP?
I’m new in SQLAlchemy and I’m trying to understand some concepts. Here is a code example without SQLAlchemy: class Token: def __init__(self, key): # generate token based on a string …
Putting a sql table into python error. Whats wrong?
I would like to know what’s going on with this query. Im not able of put it into a pandas data frame. The error description is “IndexError: tuple index out of range” i = 3 query = (“SELECT COL1, …
For loop in Jinja2 splitting the chars in nested list, instead of returning whole of nested list
My doubts list is [[‘a’,’b’,’This is a sentence’]] My HTML (Jinja) is My Flask is :- x is giving a,b,T,h,i,s,i,s,a,s,e,n,t,e,n,c,e [Each char one iteration] I expected a,b,This is a sentence. [Only one iteration] How do I resolve this? Thanks in advance! Answer You have dum…
Flask SQLAlchemy query join
I have 2 table like this: Then I try to making 2 kinds of query to get data for the relationship models. first, I make it like this: and the second one I use join statement on that: My questions are, what’s the difference in that query while in the second one I use the join statement but the result