Beefy Boxes and Bandwidth Generously Provided by pair Networks
"be consistent"

Re^2: SQLite handling of errors through common function

by techman2006 (Beadle)
on Nov 07, 2013 at 08:27 UTC ( #1061533=note: print w/replies, xml ) Need Help??

in reply to Re: SQLite handling of errors through common function
in thread SQLite handling of errors through common function

One more quick thing is there a way to know DBI handler is valid. Say I do a connect call and it went fine. Now at some place in my code I need to perform the operation but before that I want to validate that #dbh is valid. Can we do that?

Also can we have a way to create an schema which comprises of tables like we do in say MySQL etc. I mean to say we have a schema called master which contains tables like tbl1, tbl2 etc.

  • Comment on Re^2: SQLite handling of errors through common function

Replies are listed 'Best First'.
Re^3: SQLite handling of errors through common function
by mje (Curate) on Nov 07, 2013 at 11:04 UTC

    I presume you really mean is the DBI handle I obtained from connect still actively connected to my database. If that is the case see the DBI ping method. As for the second part of your post I've no idea what you are asking. Of course you can create tables in a database.

      Thanks I want to mean the DBI handle which is obtained after connect call.

      For the second point let me try to explain further with an example. Say we want to create an database called EmpRec which will comprises of a set tables e.g. EmpAdd, EmpSal etc. Now when we try to connect first we need to connect to EmpRec database. Below are the set of queries which is fired in MySql

      mysql> CREATE DATABASE EmpRec;

      mysql> USE EmpRec Database changed

      So is something like above is supported in SQLite and if yes how we can do that

        SQLite does not support create database. For different databases you use different files i.e. call connect with a different dbname.

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://1061533]
[Lady_Aleena]: Would you use a module that is almost 150 characters to type with the use and importing all subroutines?
[LanX]: use module :all ?
[Lady_Aleena]: Lax, that would take it down to a little less than 100 characters. The module name is nearly 80 characters long.
Lady_Aleena has fumble fingers today.
[Lady_Aleena]: Sorry for the name typo LanX.

How do I use this? | Other CB clients
Other Users?
Others rifling through the Monastery: (6)
As of 2017-05-24 21:53 GMT
Find Nodes?
    Voting Booth?