I have a list and a tuple ( from sqlite query) and what to check if the items in list are not in the db tuple. If not add to newJobs list links = [“example.com”, “mysite.com”] …
Tag: python
Saleforce retrieving fields from two different objects – (SOQL) Simple Salesforce Python
I am using simpleSalesforce library for python to query SalesForce. I am looking at two different object in SalesForce: Account and Backend (parent-child). The Id in account matches the records of Backend through acc_id I am trying to do this: But I get the response showing: Malformed request – didnR…
How to refactor my python to use a SQL Prepared statement?
Code to accept input from the user and gives a User for a given username. Now it is accepting the input directly into the SQL query but I would like to use it with prepared Statements, how could I do …
datetime.datetime conversion to datetime
I have defined a column in SQL Server as ldate with datetime data type and accepting null values. I’m trying to send data from my local machine using python and pyodbc. I have date like 20-01-2015 in string format. When I try to send data it throws an error: pyodbc.DataError: (‘22007’, ̵…
Primary key constraint gets removed when creating postgres table from pandas dataframe
I am trying to create few tables in Postgres from pandas dataframe but I am kept getting this error. psycopg2.errors.InvalidForeignKey: there is no unique constraint matching given keys for …
Continue executing sql statements if error found python sqlite3
I have a file containing sql commands and I want to execute the commands given in the file and if any command throws any error then ignore the error and execute the next command. Here is a sample file: For eg. if the classroom table doesn’t exists then the drop table command will produce an error and th…
How to add a ranking to a pyspark dataframe
I have a pyspark dataframe with 2 columns – id and count. I want to add a ranking to this by reverse count. So the highest count has rank 1, second highest rank 2, etc. testDF = spark.createDataFrame([(DJS232,437232)], [“id”, “count”]) I first tried using and this worked, ish. It…
How Can My sqllite3 interaction be fixed?
I’m trying to get an admin account to edit a ‘rank’ (basically access level) for one of the profiles in my data-base. The error is: The code that seems to be the problem is: Originally, it was all on one line and it didn’t work, and now I’ve tried it on multiple lines and it stil…
how to join two hive tables with embedded array of struct and array on pyspark
I am trying to join two hive tables on databricks. tab1: The schema of “some_questions” “some_questions” example: tab2: I need to join tab1 and tab2 by “question_id” such that I get a new table I try to join them by pyspark. But, I am not sure how to decompose the array wit…
How to connect to a Azure SQL Server through Python
I’ve come across some trouble accessing my SQL Server through Python. I can get it going when my SQL Server is installed locally, but not when it is online. I have used the following code: Connection to SQL Server but then when I try and run: I get the error: InterfaceError: (‘IM002’, ‘…