I’m using Python and trying to compare two tables in SQL and match them by partial country names. So far I’ve gotten country names that match exactly. I’m running into an issue trying to get partial …
Tag: python
Multithreading for queries in SQL Database
Suppose I have a database, for example, for messenger. My app is collecting messages and stores them in my database. It doesn’t matter what type of database it is (i want to know how it is usually embodied and does my database support it, and are there other databases that do if it doesn’t), but i…
SQLAlchemy – How to count distinct on multiple columns
I have this query: I’ve tried to recreate it with SQLAlchemy this way: But this translates to this: Which does not call the count function inline but wraps the select distinct into a subquery. My question is: What are the different ways with SQLAlchemy to count a distinct select on multiple columns and …
psycopg2 not escaping quotation from tuple arguments? Using sql.SQL to format arguments
I’m trying to dynamically create a table in postgres with psycopg2. It seems when the arguments are passed, pyscopg2 is not escaping quotations and understanding my query. Code looks like this: The error I’m getting: What print(create_table_str.as_string(conn)) outputs: Edit to show modified answe…
How to replace IN in an SQL query containing a lot of parameters with Postgresql?
I am trying to retrieve information from a database using a Python tuple containing a set of ids (between 1000 and 10000 ids), but my query uses the IN statement and is subsequently very slow. and then I query the database using PostgreSQL to charge the result in a Pandas dataframe: I know that IN is not very…
Storing date value into sqlite table in python3 stores integer value
I’m stuck with this bug and on how to solve it. Background: I have built a ‘Paycheck’ table in SQLite that has a date attribute, net pay attribute, and a gross pay attribute. I have set the date attribute to a date datatype in SQLite, and set the net and gross attribute to an integer datatyp…
Moving all rows with a certain index into a single row
I have a table with as structure like the following, with an unknown number of rows with each group index. Group || PropertyA || PropertyB || PropertyC ============================================ …
‘KeyError’ while filling an SQL table with CSV data
I’m currently working on a project that’s requires wrangling OSM data (Udacity Course), and adding it to an SQLite dataset ready for queries. I’m currently trying to add a ‘.csv’ file to an exisiting SQL table with the following function: However each time I try to execute it get…
Trying to insert a python input command into my SQL query
So this is what I’m trying to do I just want to know if there’s a way to link the date input command to my SQL query so that anyone that runs the code can enter a date and get the info for only that specific date. (super-duper noob here) Answer To get the date for the input to commend
PonyORM Database Table Dynamic Definition
As far as I know from the research I’ve made, the typical way of defining a table using PonyORM in Python is like the following: from pony.orm import * db = Database() # Database connection … class …