Re: [Tutor] How to test for the existence of a table in a sqlite3 db?

2017-10-15 Thread Peter Otten
boB Stepp wrote: > I was thinking ahead to a follow-up project, the chess rating db. For > this I had contemplated having separate sqlite3 database files for > each school year instead of adding school year information to a single > database. Then you need to access multiple databases to see the

Re: [Tutor] How to test for the existence of a table in a sqlite3 db?

2017-10-15 Thread Peter Otten
boB Stepp wrote: > On Sun, Oct 15, 2017 at 3:09 AM, Peter Otten <__pete...@web.de> wrote: >> boB Stepp wrote: >> >>> I have not used a "finally" block before. I just had the thought that >>> maybe it would run even if an uncaught exception might occur. I tried >>> to test this thought by generat

Re: [Tutor] How to test for the existence of a table in a sqlite3 db?

2017-10-15 Thread boB Stepp
On Sun, Oct 15, 2017 at 2:56 AM, Peter Otten <__pete...@web.de> wrote: > boB Stepp wrote: >> >> I am puzzled. If one is using version control, then what is the >> advantage of this incremental approach in creating and populating the >> database? Instead, why not just have a single SQL file that

Re: [Tutor] How to test for the existence of a table in a sqlite3 db?

2017-10-15 Thread boB Stepp
On Sun, Oct 15, 2017 at 3:09 AM, Peter Otten <__pete...@web.de> wrote: > boB Stepp wrote: > >> I have not used a "finally" block before. I just had the thought that >> maybe it would run even if an uncaught exception might occur. I tried >> to test this thought by generating a deliberate NameErro

Re: [Tutor] New Item

2017-10-15 Thread Peter Otten
Sydney Shall wrote: > On 28/09/2017 11:46, Peter Otten wrote: >> larrystale...@comcast.net wrote: >> >>> I am very new to Python and appreciate the input as I was able to fully >>> install Python with all needed libraries (i.e., numpy, pandas, etc.). >>> However, I now have an application questio

Re: [Tutor] New Item

2017-10-15 Thread Sydney Shall
On 28/09/2017 11:46, Peter Otten wrote: larrystale...@comcast.net wrote: I am very new to Python and appreciate the input as I was able to fully install Python with all needed libraries (i.e., numpy, pandas, etc.). However, I now have an application question in needed to construct a 2D Histogra

Re: [Tutor] How to test for the existence of a table in a sqlite3 db?

2017-10-15 Thread Peter Otten
boB Stepp wrote: > I have not used a "finally" block before. I just had the thought that > maybe it would run even if an uncaught exception might occur. I tried > to test this thought by generating a deliberate NameError in the "try" > block and added a print to the "finally" clause. I got the

Re: [Tutor] How to test for the existence of a table in a sqlite3 db?

2017-10-15 Thread Peter Otten
boB Stepp wrote: > On Sat, Oct 14, 2017 at 4:45 AM, Peter Otten <__pete...@web.de> wrote: > >> If this is a long term project there will be changes in the schema. >> However, I don't think it is necessary to check for individual tables. >> You typically start with a few tables >> >> create table