Re: [openupload-devel] How can I...

[Leonardo F. C. <leo...@gm...>]

Alessandro,

 nice idea. What's the best way to contribute with my mssql module and
translation?

 I think I've corrected the TXTDB select folder bug in setup scripts (but
file copy is still necessary). Do you want this little code too?

 Sds
 Leonardo

-----------------------------------------
Leonardo F. Cardoso
leonardo.f.cardoso "at" gmail.com
leofcar "at" ig.com.br (Alternativo)
MSN: lfc...@ho...
-----------------------------------------


On Mon, Aug 17, 2009 at 19:18, Alessandro Briosi <ts...@br...> wrote:

> Well, that was my first thought, but reading the documentation, PDO simply
> abstracts the _query, _connect, etc, but not the SQL syntax which is not
> always the same, so probably extending the current classes (mysql, pgsql,
> mssql) to support PDO (maybe even in the base class) would do the trick,
> and have a config option to decide which to use PDO or native methods.
>
> Something like:
>
> class_method_query($sql) {
>
>  if ($this->config['use_pdo']) {
>   $this->PDO->query($sql);
>   <fetch the rows>
>  } else {
>   $result = native_query($sql);
>   <fetch the rows>
>  }
> }
>
> class_method_read() {
>
>  <prepare the sql statement according to the database syntax>
>  $this->class_method_query($sql);
> }
>
> _connect would call the different methods (PDO or native), and so on.
>
> Alessandro
>
> On Mon, 17 Aug 2009 16:25:50 -0300, "Leonardo F. Cardoso"
> <leo...@gm...> wrote:
> > Hi Alessandro,
> >
> >  you mean code a DB class with PDO methods inside (insert, read, readex
> >  etc)
> > ?
> >
> >  Sds
> >  Leonardo
> >
> > On Mon, Aug 17, 2009 at 14:58, Alessandro Briosi <ts...@br...>
> > wrote:
> >
> >> Hi again,
> >> I have checked PDO documentation and it souldn't be that dificult to
> >> implement a PDO version of the modules. Though PDO does not provide SQL
> >> statement abstraction, so it would be probably best to extend the sql
> >> module to use one or the other functions, and not as I sateted before
> >> creating a general PDO module.
> >>
> >> Wrapping the connect, query and exec PDO methods into a couple of
> >> functions and using PDO or not, depending on a config options should be
> >> trivial imho.
> >>
> >> Alessandro
> >>
> >> Alessandro Briosi ha scritto:
> >>  > hi,
> >> >
> >> > Leonardo F. Cardoso ha scritto:
> >> >> Hi there,
> >> >>
> >> >>  thanks for the reply, Alessandro.
> >> >>
> >> >>  I'm working in Brazilian Portuguese translation. Will send it to you
> >> soon.
> >> >>
> >> > great
> >> >
> >> >>  I could code SQL Server port for the 0.4 version. It works!! :-)
> >> >>
> >> > cool ;-P
> >> >
> >> >>  By now, I'm interested in run OpenUpload inside Quercus. Quercus is
> a
> >> >> Java PHP implementation. Unfortunatelly, Quercus doesn't support SQL
> >> >> Server with normal mssql PHP package, the only support is with PDO
> >> >> implementation. In the new database scheme, will be support for PDO?
> >> >>
> >> >
> >> > Well, I have been thinking about it, but am not too sure if I can use
> >> > it.
> >> > One of the features is txtdb, which (Afair) is not supported by PDO,
> so
> >> > probably will stick to project modules for now, which might also
> evolve
> >> > into something simpler (some kind of little wrapper).
> >> > Though I suppose you could also code a PDO version which would support
> >> > multiple backends, but have not much experience with it.
> >> > If needed I might have a look at it (as I'm also interested to do some
> >> > PDO research)
> >> >
> >> > Let me know.
> >> > Alessandro
> >> >
> >> >
> >> >
> >>
>
> ------------------------------------------------------------------------------
> >> > Let Crystal Reports handle the reporting - Free Crystal Reports 2008
> >> 30-Day
> >> > trial. Simplify your report design, integration and deployment - and
> >> focus on
> >> > what you do best, core application coding. Discover what's new with
> >> > Crystal Reports now.  http://p.sf.net/sfu/bobj-july
> >> > _______________________________________________
> >> > Openupload-devel mailing list
> >> > Ope...@li...
> >> > https://lists.sourceforge.net/lists/listinfo/openupload-devel
> >>
> >>
> >>
>
> ------------------------------------------------------------------------------
> >> Let Crystal Reports handle the reporting - Free Crystal Reports 2008
> >> 30-Day
> >> trial. Simplify your report design, integration and deployment - and
> >> focus
> >> on
> >> what you do best, core application coding. Discover what's new with
> >> Crystal Reports now.  http://p.sf.net/sfu/bobj-july
> >> _______________________________________________
> >> Openupload-devel mailing list
> >> Ope...@li...
> >> https://lists.sourceforge.net/lists/listinfo/openupload-devel
> >>
>
>
> ------------------------------------------------------------------------------
> Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
> trial. Simplify your report design, integration and deployment - and focus
> on
> what you do best, core application coding. Discover what's new with
> Crystal Reports now.  http://p.sf.net/sfu/bobj-july
> _______________________________________________
> Openupload-devel mailing list
> Ope...@li...
> https://lists.sourceforge.net/lists/listinfo/openupload-devel
>