psycopg, double and single quotes insert

2024/10/11 20:24:46

I ran into problems, while trying to insert to database:

ur_psql.execute("""insert into smth(data, filedate, filedby)"""""" values('%s', NOW(), %s)""" % (data, userid))

where data=""" "5.09,448,1418112000"; d="scan'208" """(a string containing double and single quotes) Any ideas how to insert such string to db ? Thanks

Answer

You can read about it at: http://initd.org/psycopg/docs/usage.html#the-problem-with-the-query-parameters

Simply do not use quotes in SQL and instead of % string Python operator use 2nd parameter of execute() which is data you want to pass to SQL query:

sql = "insert into smth (data, filedate, filedby) values (%s, NOW(), %s)"
ur_psql.execute(sql, (data, userid))
https://en.xdnf.cn/q/69734.html

Related Q&A

How to debug Python 2.7 code with VS Code?

For work I have to use Python 2.7. But when I use the "debug my python file" function in VS Code, I get an error. Even with a simple program, like : print()

Python Sequence of Numbers

Ive decided not to waste my summer and start learning python. I figured Id start learning looping techniques so I wanted to start with a basic list of numbers, aka, write a for loop that will generate…

Object initializer syntax (c#) in python?

I was wondering if there is a quick way to initialise an object in python. For example in c# you can instantiate an object and set the fields/properties like...SomeClass myObject = new SomeClass() { va…

Plotly.io doesnt see the psutil package even though its installed

Im trying to execute the following code:import numpy as np import pandas as pd import matplotlib.pyplot as plt import matplotlib %matplotlib inline import seaborn as snsimport plotly.graph_objects as g…

How to get MultiCells in Pyfpdf Side by side?

I am making a table of about 10 cells with headings in them. They will not fit accross the page unless I use multi_cell option. However I cant figure out How to get a multi_cell side by side. When I ma…

Django: Require Checkbox to be ticked to Submit Form

Im creating a form in Django (using ModelForm). There are many checkboxes, and I want to make it so that one of these must be selected in order to submit the form. I dont mean any one checkbox, but on…

Filtering in django rest framework

In my project I use django rest framework. To filter the results I use django_filters backend. There is my code:models.pyfrom django.db import modelsclass Region(models.Model):name = models.CharField(m…

Efficiency difference between dict.has_key and key in dict in Python [duplicate]

This question already has answers here:Closed 11 years ago.Possible Duplicate:has_key() or in? In Python, therere two ways of deciding whether a key is in a dict:if dict.has_key(key) and if key in di…

python points to global installation even after virtualenv activation

Its a bit weird, I have activated the virtual environment python still points to the global installation.$ which python /usr/bin/python$ source ~/virtualenv/bin/activate (virtualenv)$ which python /usr…

Should I perform both lemmatization and stemming?

Im writing a text classification system in Python. This is what Im doing to canonicalize each token:lem, stem = WordNetLemmatizer(), PorterStemmer() for doc in corpus:for word in doc:lemma = stem.stem(…