views:

296

answers:

0

hi,

I phpandstuff have a wonderful tut on setting up the doctrine ORM and CodeIgniter, my question is setting it up with SQLite got me kinda confused, SQLite does not require a dsn like all the others so where all that is required what do I do? And for the defaults that are set with MySQL for example:

[code] Doctrine_Manager::getInstance()->setAttribute( Doctrine::ATTR_AUTO_ACCESSOR_OVERRIDE, true);

// this sets all table columns to notnull and unsigned (for ints) by default Doctrine_Manager::getInstance()->setAttribute( Doctrine::ATTR_DEFAULT_COLUMN_OPTIONS, array('notnull' => true, 'unsigned' => true));

// set the default primary key to be named 'id', integer, 4 bytes Doctrine_Manager::getInstance()->setAttribute( Doctrine::ATTR_DEFAULT_IDENTIFIER_OPTIONS, array('name' => 'id', 'type' => 'integer', 'length' => 4)); [/code] do i have to use these defaults? Some of the SQL supported by those Client/Server RDBMS's are not supported by SQLite so any thoughts on this matter??!!

Thanks a mil guys.

E.