Re: [znf-general] PDO_SQLITE

[Jose C. <jo...@co...>]

Tomasz Kuter escribió:
> Jose Corbacho wrote:
>> Hi,
>>
>> I have created DDL and DML files for SQLite3. After make some changes in
>> the News demo, I can said that ZNF works with PDO_SQLITE driver.
> 
> If you created new DDL and DML files, please send them to us, so that we
> could add it to ZNF SVN repository. Have you change any PHP file, or
> just XML database config?

I send you the DDL and DML files for SQLite.
I have done some changes in DAO files. I only check that I can view the
news. I have not tested 100% the ZNF Demo. I wanted to know that ZNF
could works with SQLite without problems, because I want to make a web
app using both SQLite and ZNF.

> 
>> But I have a little bug with the name of DB. In SQLite when you open a DB
>> that it doesn't exist, a new DB is created with this name.
>>
>> This is my DB definition in znf-db-config.xml file
>> <db
>>    default="true"
>>    dbms="sqlite"
>>    username=""
>>    password=""
>>    dbname="news.db"
>>    tableprefix="znf_"/>
> 
> Maybe I miss something, but there is no "hostname" attribute in your
> database configuration.

In SQLite there is not a daemon running in any host, a complete database
is stored in a single disk file. For this reason, you don't need the
hostname attribute.

> 
>> The first time that I launch the ZNF app, the following DB file is created
>> host=;dbname=news.db.
> 
> Sorry, but it is a little hard to understand for me.
> I understand your database name is "news.db" and SQLite create some
> file, when it is accessed first time.
> But is this string "host=;dbname=news.db" database file name?
> 
In SQLite, if you try to open a db file that it doesn't exist, this db
file is created. In this case, ZNF tries to open "host=;dbname=news.db"
but ZNF would be to open news.db file. At this moment,
"host=;dbname=news.db"  is created (a new DB without data)

>> At this moment, I rename my news.db with "host=;dbname=news.db" (without
>> modify znf-db-config.xml file)
> 
> I don't understand what did you change change: database filename?
> I have never used SQLite, so it is a little hard to understand for me.
> 
At this moment, I delete the empty new DB file ("host=;dbname=news.db")
and I rename my real DB file (news.db) with the "host=;dbname=news.db"
name, because ZNF tries to open this file name with my DB definition in
znf-db-config.xml file. I think that there is a little bug when
znf-db-config.xml file is parsed when it is used SQLite.

>> After this, ZNF's demo works.
> 
> Good to hear that :)
> 
> 
> Best regards,
> Tomasz Kuter
> 
Regards,
Jose Corbacho
-- 
      		  ( @ @ )
      ---------oOOo-(_)-oOOo---------
      |                               |
      |         José Corbacho	      |
      |   E-mail: jo...@co...   |
      |                               |
      -----------------Oooo.---------
            .oooO     (   )
            (   )      ) /
             \ (      (_/
              \_)