[Tutor] (sqlite3) Testing if a table has been created.

[Joel Goldstick]

On Tue, Apr 5, 2011 at 9:59 PM, michael scott <jigenbakuda at yahoo.com> wrote:

> Hello guys,
>
> Since sqlite gives an error if you try to create a table that's already
> there, how do I test if a table is already present?
>
>
> for example in
>
> def database(info):
>     import sqlite3
>
>     connection = sqlite3.connect("test.db")
>     cursor = connection.cursor()
>     if table not in test.db: #with this being my test that I'm not sure how
> to implement
>         cursor.execute(""" CREATE TABLE stuff (id INTEGER PRIMARY KEY, name
> TEXT)""")
>     cursor.execute("""INSERT INTO stuff VALUES (null, ?)""",(info))
>     cursor.commit()
>     cursor.close()
>     connection.close()
>
>
> How would I properly test  if table not in test.db: ? Is it something as
> simple as having a method of cursor check it for me, or should I just create
> my table in the beginning of my code(outside of this function) and leave it
> out of the function all together, so I can just have my function focusing on
> inserting data?
>
> Uhm, in the immediate example I'm using, this is a function, thats inside
> of a function used by a tkinter button, a save button if you will. So I want
> it to save whatever is in the entry widget to the database. Keeping this in
> mind, am I going about it the wrong way? Should I be trying to save a
> different way?
>
>
>
>
>
>
> ----
> What is it about you... that intrigues me so?
>
>
> _______________________________________________
> Tutor maillist  -  Tutor at python.org
> To unsubscribe or change subscription options:
> http://mail.python.org/mailman/listinfo/tutor
>
>
Is this really a python tutor question?  Oh, well, try this:
http://lmgtfy.com/?q=sqlite+test+if+table+exists


-- 
Joel Goldstick
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.python.org/pipermail/tutor/attachments/20110406/944fe847/attachment-0001.html>