Re: [phpBT-dev] createdb with dynamic tablenames

[Ben C. <php...@be...>]

This is a great idea.  Let me move the schema files into a subdir to get started on this.  I agree the sed script should be separate from the configure script.  Once I move the schema files, could you create the shell script in the next few days so we could include it in this release?

On Fri, Sep 07, 2001 at 01:57:41PM +0200, Patrick Mairif wrote:
> now, that it's possible to tell phpbt to use other tablenames createdb.sql
> still creates hard coded names. to make this part dynamic we need some
> kind of template for createdb.sql, for example createdb.sql.template,
> which contains entries like
> 
>   DROP TABLE IF EXISTS TBL_OS;
>   CREATE TABLE TBL_OS (
> 
> Those enrtries like TBL_OS have to be replaced by real tablenames.
> Therefor I could create a shell-script like the following
> 
>   PREFIX="phpbt_"
> 
>   cat createdb.sql.template | sed "
>     s/TBL_OS/${PREFIX}os/g
>     s/TBL_BUG/${PREFIX}bug/g
>   " > createdb.sql
> 
> this script can be modified to use an argument as prefix and can be used
> in configure.
> 
> it could be a function, but I would like to have a script independent
> from configure to create the createdb.sql.
> 
> what do you think?
> 
> Should this go in this release or the next?
> 
> --
> http://home.nikocity.de/mairif
> http://www.caravan-network.de
> 
> 
> _______________________________________________
> phpbt-dev mailing list
> php...@li...
> https://lists.sourceforge.net/lists/listinfo/phpbt-dev