I’m using OrionSDK and I have a python query that keeps returning this error: mismatched input ‘Orion’ expecting ‘FROM’ . Here is the query. Not sure what can be causing this. Thanks in Advance! ”’…
Tag: python
Python problem with adding table to Database with sql
Hi, I’m trying to create a function that will take a table in insert(add) to the database. My Code : this is the old code when i didn’t create a function: Answer You seem to have put table_name under quotations in your to_sql function. Also, you seem to be tackling the issue of data model creation and mainten…
SQL iterate UPDATE from python list
Do you guys know how to UPDATE a database from a python list without using cur.executemany? Using cur.executemany I have problems in API calls or something. What is another way to solve this below? Thank you! I know below is crazy ugly, but I did that. Answer Not an answer but I don’t want to edit your …
SQL Query rounding issue
I am using pyodbc to fetch total quantity of a product based on a certain criteria called “Strength”. The “Strength” column also has string value for some records, so it is a varchar column. The user enters details like brand, product type, product line, date range, minimum quantity (i…
How to fix traffic session table doesn’t exists error?
When I try to execute my code,I am getting this error? How could I resolve this issue? Answer I don’t know if you wrote this POST request or if it is a library or something. Could you please provide more info about it? As the error describes, it seems that: Make sure this table exists and it is availabl…
How to shorten mysql join query to avoid manual typing of each row?
I have a table that gets new rows for eg. I’d add more than 100 features like phone_number, username to the processed_donors to this table very soon.IS it possible to simplify this json_object(****) so It’s not an evergrowing list? Some way to use pandas+python, select * etc? Answer I think you co…
Order by match on multiple columns (and with mutiple conditions)
My issue is I want to order by match on a specific search string. This is the logic: If the title, author or isbn are the same as search, show these books first If the title, author or isbn are the like %search, show these books second If the title, author or isbn are the like search%, show these books
How to reproduce the behavior of SQL NVARCHAR in Python when generating a SHA-512 hash?
I have the following SQL query SELECT CONVERT(VARCHAR(254), HASHBYTES(‘SHA2_512’, CONVERT(NVARCHAR(24), ‘2020-05-27 00:00:00.000’, 127)), 2) that generates the hash value …
Django Sql ERROR 1064 when accessing table
I cannot access one of the tables in my database. I can’t even delete the table by myself, so I am not sure what to do. Here is the error: ERROR 1064 (42000): You have an error in your SQL syntax; …
pyscopg2: Is it possible to dynamically add %s in loop
I am trying to create a method in python insert records into a table passing in a list of column names, and an associated list of records. I was able to set it up where the column names populated dynamically via a for loop, but I can’t figure out how to do the same thing with values because the psycopg2…