[Vtigercrm-developers] Why include a SQL file when we don't use it?

[Sergio A. Kessler]

mike is rigth that the adodb schema has advantages over sql files, but
I also understand fathi problems WRT packaging

maybe something like this can be done:

php generate_sql.php mysql > vtiger-mysql.sql

and eventually:
php generate_sql.php pgsql > vtiger-pgsql.sql

??

so all the sql files are automatically created ?


On 2/21/06, Mike Crowe <mike at mikeandkellycrowe.com> wrote:
> Folks,
>
> I refer you to my post:
> http://forums.vtiger.com/viewtopic.php?t=4535&highlight=
>
> To install from command line:
>         php install.php
> where install.php is:
> <?
> require_once('config.php');
> require_once('connection.php');
> require_once('adodb/adodb.inc.php');
> require_once('adodb/adodb-xmlschema.inc.php');
>
> $conn = ADONewConnection($dbconfig['db_type']);
> $conn->Connect($dbconfig['db_host_name'],$dbconfig['db_user_name'],
> $dbconfig['db_password'],$dbconfig['db_name']);
> $schema = new adoSchema( $conn );
> $schema->SetUpgradeMethod('ALTER');
> $schema->ExecuteInline(true);
> $sql = $schema->ParseSchema( "adodb/DatabaseSchema.xml" );
> ?>
>
> To create the XML file, all it takes is:
> $schema = new adoSchema( $conn );
> $t = $schema->ExtractSchema(true);
> (now write $t to the xml file)
>
> Mike
>
>
> On Tuesday 21 February 2006 6:34 pm, Fathi BOUDRA wrote:
> > > I don't understand half of what you just said but using the adodb xml
> > > file for database creation is one of the only thing this project does
> > > right, please continue to use it.
> > >
> > > The adodb xml file it designed to be cross database compatible, the
> > > only thing it depends on is adodb which is already a requirement,
> > > using it will save you tons of "copy and paste" code "reuse" which
> > > just leads to bugs.
> >
> > more simple that you can understand :
> > can you give me a simple command line that i can use to install database on
> > windows and linux ?
> >
> > something that can replace something like :
> > mysql < file.sql
> > _______________________________________________
> > This vtiger.com email is sponsored by: Zoho Writer. Are you still using
> > your desktop word processor for typing documents? Try the AJAX enabled,
> > collaboration-friendly online word processor, Zoho Writer for FREE instead!
> > http://zohowriter.com/?vt
>
> --
> _____________________________________________________
> Cheers!
>
> Mike Crowe
> Sr. Field Sales Engineer
> ELCOM
>
> 3030 Naomi Dr.
> Clover, SC 29710
> Phone: (803) 831-9050
> Fax: (704) 973-7910
>
> mike.crowe at elcomsales.com
> http://www.elcomsales.com/
> _______________________________________________
> This vtiger.com email is sponsored by: Zoho Writer. Are you still using your desktop word processor for typing documents? Try the AJAX enabled, collaboration-friendly online word processor, Zoho Writer for FREE instead!
> http://zohowriter.com/?vt
>