Path: csiph.com!usenet.pasdenom.info!weretis.net!feeder4.news.weretis.net!feeds.phibee-telecom.net!newsfeed.xs4all.nl!newsfeed1.news.xs4all.nl!xs4all!newsgate.cistron.nl!newsgate.news.xs4all.nl!post.news.xs4all.nl!not-for-mail
To: python-list@python.org
From: Dennis Lee Bieber <wlfraed@ix.netcom.com>
Subject: Re: Is there an easy way to control indents in Python
Date: Mon, 20 Oct 2014 21:13:00 -0400
Organization: IISS Elusive Unicorn
References: <m1m9ut$v8f$1@ger.gmane.org> <mailman.14893.1413401464.18130.python-list@python.org> <b474caf0-d910-4f59-86d8-006d316e858b@googlegroups.com> <54424691$0$12978$c3e8da3$5496439d@news.astraweb.com> <bd24df51-bdee-4ccc-82f7-28bf6dbd8bf5@googlegroups.com> <CALwzid=oS6H-ETtTPsRPawas-Gkj=7hkTWcwLmE8vZ7NdR5R+g@mail.gmail.com> <CALwzidmvwEfnsHExNdzDY8bs5YZ12QX_-rx3Ur+Hpz6Cg+WGdQ@mail.gmail.com> <CAAp0bGvHZd66Dw4Z5wriDiMS4Xm50rKjNu+K7_L9scyMdXjWXw@mail.gmail.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 8bit
Precedence: list
Newsgroups: comp.lang.python
Message-ID: <mailman.15020.1413853991.18130.python-list@python.org>
Lines: 86
NNTP-Posting-Host: 2001:888:2000:d::a6
Xref: csiph.com comp.lang.python:79360

On Mon, 20 Oct 2014 17:04:09 -0200, Juan Christian
<juan0christian@gmail.com> declaimed the following:

>Ok, new code using ?:
>
>import sqlite3
>
>db = sqlite3.connect('db.sqlite')
>
>
>def create_db():

	Misnamed function... the "database" was created (if it didn't exist)
when you did the .connect() call. Here you are defining the schema of a
table.

>    db.execute('''
>    CREATE TABLE TOPICS(
>    ID INT PRIMARY KEY NOT NULL,
>    URL VARCHAR NOT NULL,
>    AUTHOR VARCHAR NOT NULL,
>    MESSAGE VARCHAR NOT NULL
>    );
>    ''')
>
	Stylistic point -- I never use the connection.execute() form; as
documented:

execute(sql[, parameters])

    This is a nonstandard shortcut that creates an intermediate cursor
object by calling the cursor method, then calls the cursor’s execute method
with the parameters given.

	More portable to create an actual cursor

	cur = db.cursor()

and then

	cur.execute(...)


>
>def insert_db(_id, url, author, message):
>    db.execute("INSERT INTO TOPICS (ID, URL, AUTHOR, MESSAGE) VALUES (?, ?,
>?, ?)", (_id, url, author, message))
>    db.commit()
>
>
>def get_db(_id):
>cursor = db.execute("SELECT ID, URL, AUTHOR, MESSAGE FROM TOPICS WHERE ID =
>?", (_id))

	Presuming the adapter is expecting a tuple of parameters, you haven't
provided one. Try with

	..., (_id,) )

It is the comma, not the () that make a tuple.
	

>    cursor = db.execute("SELECT ID, URL, AUTHOR, MESSAGE FROM TOPICS WHERE
>ID = ?", (_id))
>ValueError: parameters are of unsupported type
>

	{see prior comment}

>-------------
>
>And the second time, again, I get
>
>Traceback (most recent call last):
>  File ".\sql.py", line 28, in <module>
>    create_db()
>  File ".\sql.py", line 14, in create_db
>    ''')
>sqlite3.OperationalError: table TOPICS already exists

	Well, sure... If it failed on the "select" statement you had already
executed (and commited) the table create and the insert of one row.
-- 
	Wulfraed                 Dennis Lee Bieber         AF6VN
    wlfraed@ix.netcom.com    HTTP://wlfraed.home.netcom.com/