Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.lang.python > #57858

Re: Try-except for flow control in reading Sqlite

Show key headers only | View raw

On Sun, 27 Oct 2013 20:43:07 -0700 (PDT), Victor Hooi
<victorhooi@gmail.com> declaimed the following:

>Hi,
>
>I'd like to double-check something regarding using try-except for controlling flow.
>
>I have a script that needs to lookup things in a SQLite database.
>
>If the SQLite database file doesn't exist, I'd like to create an empty database, and then setup the schema.
>
>Is it acceptable to use try-except in order to achieve this? E.g.:
>
>    try:
>        # Try to open up the SQLite file, and lookup the required entries
>    except OSError:
>        # Open an empty SQLite file, and create the schema
>
>
	In my experience, SQLite will /create/ an empty database file if the
specified name does not exit. So just executing the connect() call is all
that is needed. After all, checking for data IN the database will either
return something or fail at that point in which case you can now populate
the schema.

-=-=-=-=-=-
>>> import sqlite3 as db
>>> con = db.connect("anUnknown.db")
>>> cur = con.cursor()
>>> rst = cur.execute("pragma table_info('aTable')")
>>> rst
<sqlite3.Cursor object at 0x0000000004725C00>
>>> for ln in rst:
... 	print ln
... 	
>>> for ln in cur:
... 	print ln
... 	
>>> rst = cur.execute("create table aTable ( junk varchar )")
>>> con.commit()
>>> rst = cur.execute("pragma table_info('aTable')")
>>> for ln in rst:
... 	print ln
... 
(0, u'junk', u'varchar', 0, None, 0)
>>> 


	No try/except needed -- just an a conditional testing the length of the
result returned by the pragma instruction on the table you expect to find
in the database.
-- 
	Wulfraed                 Dennis Lee Bieber         AF6VN
    wlfraed@ix.netcom.com    HTTP://wlfraed.home.netcom.com/

Back to comp.lang.python | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

Thread

Try-except for flow control in reading Sqlite Victor Hooi <victorhooi@gmail.com> - 2013-10-27 20:43 -0700
  Re: Try-except for flow control in reading Sqlite Steven D'Aprano <steve@pearwood.info> - 2013-10-28 06:18 +0000
    Re: Try-except for flow control in reading Sqlite Antoon Pardon <antoon.pardon@rece.vub.ac.be> - 2013-10-28 10:48 +0100
  Re: Try-except for flow control in reading Sqlite Chris Angelico <rosuav@gmail.com> - 2013-10-28 17:36 +1100
    Re: Try-except for flow control in reading Sqlite Victor Hooi <victorhooi@gmail.com> - 2013-10-27 23:57 -0700
      Re: Try-except for flow control in reading Sqlite Chris Angelico <rosuav@gmail.com> - 2013-10-28 18:01 +1100
        Re: Try-except for flow control in reading Sqlite Steven D'Aprano <steve@pearwood.info> - 2013-10-28 07:19 +0000
      Re: Try-except for flow control in reading Sqlite Chris Angelico <rosuav@gmail.com> - 2013-10-28 18:02 +1100
  Re: Try-except for flow control in reading Sqlite Burak Arslan <burak.arslan@arskom.com.tr> - 2013-10-28 10:17 +0200
  Re: Try-except for flow control in reading Sqlite Dennis Lee Bieber <wlfraed@ix.netcom.com> - 2013-10-28 19:43 -0400
    Re: Try-except for flow control in reading Sqlite Victor Hooi <victorhooi@gmail.com> - 2013-10-31 16:08 -0700
      Re: Try-except for flow control in reading Sqlite Dennis Lee Bieber <wlfraed@ix.netcom.com> - 2013-10-31 22:45 -0400

csiph-web