Archived:How to use quotation in SQL in PySymbian
Aquivado: Este artigo foi arquivado, pois o conteúdo não é mais considerado relevante para se criar soluções comerciais atuais. Se você achar que este artigo ainda é importante, inclua o template {{ForArchiveReview|escreva a sua justificativa}}.
All PySymbian articles have been archived. PySymbian is no longer maintained by Nokia and is not guaranteed to work on more recent Symbian devices. It is not possible to submit apps to Nokia Store.
All PySymbian articles have been archived. PySymbian is no longer maintained by Nokia and is not guaranteed to work on more recent Symbian devices. It is not possible to submit apps to Nokia Store.
Article Metadata
It's not always easy to remember how to use quotation in Symbian SQL database. Here's a simple reminder.
- date/time need to be quoted with # and formatted with e32db.format_time
- int/float need no quotation
- string need to be quoted with single quote and repeat the quote if it happen to be inside.
- binary can't be used. You may need to encode it (eg. base64)
Here's a simple example :
import e32db, time
timestamp = time.time()
distance = 10.5
comment = "I'm fine, thanks!"
# for date/time, int/float, and string respectively
sql = "INSERT INTO events VALUES (#%s#, %d, '%s')" %\
(e32db.format_time(timestamp),
distance,
comment.replace("'", "''") )
(no comments yet)