Thread: [openupload-devel] How can I...
Status: Beta
Brought to you by:
tsdogs
|
From: Leonardo F. C. <leo...@gm...> - 2009-08-15 18:24:53
|
Hi All, first post to this list. I'm very interested in this project. Sorry if it was already discussed, but couldn't find in the archives. 1) Is there any work in progress of translation for Portuguese (Brazil)? 2) What's the best way to introduce SQL Server support? I would like to add this 2 features to OpenUpload. Please send me some information. Sorry about the English. From Brazil Leonardo ----------------------------------------- Leonardo F. Cardoso leonardo.f.cardoso "at" gmail.com leofcar "at" ig.com.br (Alternativo) MSN: lfc...@ho... ----------------------------------------- |
|
From: Alessandro B. <ts...@br...> - 2009-08-17 16:45:05
|
Hi Leonardo, Leonardo F. Cardoso ha scritto: > Hi All, > > first post to this list. I'm very interested in this project. perfect :) > > Sorry if it was already discussed, but couldn't find in the archives. > No it wasn't :) > 1) Is there any work in progress of translation for Portuguese (Brazil)? Nope. > > 2) What's the best way to introduce SQL Server support? > I'm in the slow process to create a v0.5 release, which probably will change some code in the sql backends, but it would be pretty easy to port the v0.4 version. I'd suggest you to look at the mysql.inc.php file in lib/modules/db basically you should change the sql syntax to match SQL server's one, and use sql server functions. (it shouldn't be that hard, I might be able to create it and test it, though I have limited time right now) The connection parameters should be the same (afair), so use standard ones. Then you should have at least a sql to create the database tables. and maybe the user (though sql server mainly uses the windows authentication) Don't bother with the setup script right now, as I'll revisit it deeply. Of course you need sql server support in yout php installation :) Let me know if you need further information about this. Greetz. Alessandro |
|
From: Leonardo F. C. <leo...@gm...> - 2009-08-17 17:23:18
|
Hi there, thanks for the reply, Alessandro. I'm working in Brazilian Portuguese translation. Will send it to you soon. I could code SQL Server port for the 0.4 version. It works!! :-) 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? Sds Leonardo On Mon, Aug 17, 2009 at 13:44, Alessandro Briosi <ts...@br...> wrote: > Hi Leonardo, > > Leonardo F. Cardoso ha scritto: > > Hi All, > > > > first post to this list. I'm very interested in this project. > > perfect :) > > > > Sorry if it was already discussed, but couldn't find in the archives. > > > No it wasn't :) > > > 1) Is there any work in progress of translation for Portuguese (Brazil)? > Nope. > > > > > 2) What's the best way to introduce SQL Server support? > > > I'm in the slow process to create a v0.5 release, which probably will > change some code in the sql backends, but it would be pretty easy to > port the v0.4 version. > > I'd suggest you to look at the mysql.inc.php file in lib/modules/db > > basically you should change the sql syntax to match SQL server's one, > and use sql server functions. (it shouldn't be that hard, I might be > able to create it and test it, though I have limited time right now) > > The connection parameters should be the same (afair), so use standard ones. > > Then you should have at least a sql to create the database tables. and > maybe the user (though sql server mainly uses the windows authentication) > Don't bother with the setup script right now, as I'll revisit it deeply. > > Of course you need sql server support in yout php installation :) > > Let me know if you need further information about this. > > Greetz. > 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 > -- ----------------------------------------- Leonardo F. Cardoso leonardo.f.cardoso "at" gmail.com leofcar "at" ig.com.br (Alternativo) MSN: lfc...@ho... ----------------------------------------- |
|
From: Alessandro B. <ts...@br...> - 2009-08-17 17:42:23
|
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 |
|
From: Alessandro B. <ts...@br...> - 2009-08-17 17:58:54
|
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 |
|
From: Leonardo F. C. <leo...@gm...> - 2009-08-17 19:26:09
|
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 > -- ----------------------------------------- Leonardo F. Cardoso leonardo.f.cardoso "at" gmail.com leofcar "at" ig.com.br (Alternativo) MSN: lfc...@ho... ----------------------------------------- |
|
From: Alessandro B. <ts...@br...> - 2009-08-17 22:19:30
|
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
>>
|
|
From: Leonardo F. C. <leo...@gm...> - 2009-08-18 01:01:56
|
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 > |
|
From: Alessandro B. <ts...@br...> - 2009-08-18 07:25:55
|
Leonardo F. Cardoso ha scritto: > Alessandro, > > nice idea. What's the best way to contribute with my mssql module and > translation? > If you can generate a patch that would be nice, of course the mssql code and the translation can also be files... > 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? > sure. > Sds > Leonardo > > ----------------------------------------- > Leonardo F. Cardoso > leonardo.f.cardoso "at" gmail.com <http://gmail.com> > leofcar "at" ig.com.br <http://ig.com.br> (Alternativo) > MSN: lfc...@ho... <mailto:lfc...@ho...> > ----------------------------------------- > > > On Mon, Aug 17, 2009 at 19:18, Alessandro Briosi <ts...@br... > <mailto: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... <mailto: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... <mailto: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... > <mailto: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... > <mailto: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... > <mailto: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 |
|
From: Leonardo F. C. <leo...@gm...> - 2009-08-19 01:38:58
|
Alessandro & All, I've sent my first mssql implementation and Portuguese (BR) translation to the sourceforge site. Please let me know if this will appear in future releases. Sds Leonardo ----------------------------------------- Leonardo F. Cardoso leonardo.f.cardoso "at" gmail.com leofcar "at" ig.com.br (Alternativo) MSN: lfc...@ho... ----------------------------------------- On Tue, Aug 18, 2009 at 04:25, Alessandro Briosi <ts...@br...> wrote: > > Leonardo F. Cardoso ha scritto: > > Alessandro, > > > > nice idea. What's the best way to contribute with my mssql module and > > translation? > > > If you can generate a patch that would be nice, of course the mssql code > and the translation can also be files... > > > 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? > > > sure. > > > Sds > > Leonardo > > > > ----------------------------------------- > > Leonardo F. Cardoso > > leonardo.f.cardoso "at" gmail.com <http://gmail.com> > > leofcar "at" ig.com.br <http://ig.com.br> (Alternativo) > > MSN: lfc...@ho... <mailto:lfc...@ho...> > > ----------------------------------------- > > > > > > On Mon, Aug 17, 2009 at 19:18, Alessandro Briosi <ts...@br... > > <mailto: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... <mailto: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... <mailto: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... > > <mailto: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... > > <mailto: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... > > <mailto: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 > |
|
From: Alessandro B. <ts...@br...> - 2009-08-19 09:46:44
|
thanks. Leonardo F. Cardoso ha scritto: > Alessandro & All, > > I've sent my first mssql implementation and Portuguese (BR) translation > to the sourceforge site. > > Please let me know if this will appear in future releases. > > Sds > Leonardo > > ----------------------------------------- > Leonardo F. Cardoso > leonardo.f.cardoso "at" gmail.com <http://gmail.com> > leofcar "at" ig.com.br <http://ig.com.br> (Alternativo) > MSN: lfc...@ho... <mailto:lfc...@ho...> > ----------------------------------------- > > > On Tue, Aug 18, 2009 at 04:25, Alessandro Briosi <ts...@br... > <mailto:ts...@br...>> wrote: > > > Leonardo F. Cardoso ha scritto: > > Alessandro, > > > > nice idea. What's the best way to contribute with my mssql > module and > > translation? > > > If you can generate a patch that would be nice, of course the mssql code > and the translation can also be files... > > > 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? > > > sure. > > > Sds > > Leonardo > > > > ----------------------------------------- > > Leonardo F. Cardoso > > leonardo.f.cardoso "at" gmail.com <http://gmail.com> > <http://gmail.com> > > leofcar "at" ig.com.br <http://ig.com.br> <http://ig.com.br> > (Alternativo) > > MSN: lfc...@ho... <mailto:lfc...@ho...> > <mailto:lfc...@ho... <mailto:lfc...@ho...>> > > ----------------------------------------- > > > > > > On Mon, Aug 17, 2009 at 19:18, Alessandro Briosi > <ts...@br... <mailto:ts...@br...> > > <mailto:ts...@br... <mailto: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... > <mailto:leo...@gm...> > <mailto:leo...@gm... > <mailto: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... <mailto:ts...@br...> > <mailto:ts...@br... <mailto: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... > <mailto:Ope...@li...> > > <mailto:Ope...@li... > <mailto: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... > <mailto:Ope...@li...> > > <mailto:Ope...@li... > <mailto: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... > <mailto:Ope...@li...> > > <mailto:Ope...@li... > <mailto: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... > <mailto: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... > <mailto: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 |