Tag: python

Comparing substrings in two columns across tables in sqlite

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 …

Multithreading for queries in SQL Database

database multithreading postgresql python sql

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 in my case it is

SQLAlchemy – How to count distinct on multiple columns

mysql orm python sql sqlalchemy

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 what are they translating into? Is there

psycopg2 not escaping quotation from tuple arguments? Using sql.SQL to format arguments

postgresql psycopg2 python sql

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 answer that works with no string concatenation Thanks to Adrian for the help Answer sql.Identifier is for SQL

How to replace IN in an SQL query containing a lot of parameters with Postgresql?

postgresql python sql

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 efficient with

Storing date value into sqlite table in python3 stores integer value

python sql sqlite

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 datatype. The problem: I’m experiencing

Moving all rows with a certain index into a single row

pandas python sql sql-server

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

python sql sqlite

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 the following error: I’m bewildered as to why i’m getting this

Trying to insert a python input command into my SQL query

input pandas python sql

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

database oop ponyorm python sql

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 …