Yarko and Massimo, both of you are right of course: I did not use any
DAL or ORM before web2py and sometimes I feel lost without my
traditional sql statements. To say it all, I would not be perfectly
persuaded that we need a DAL in place of a traditional SQL if I had
not seen what additional advantages you have (validation ecc) with
web2py through DAL.
What I really meant to say (but I did not realize that before Yarko
post !) is that I would like to have DAL-DB2 support through an odbc
driver and not through a native db2 python driver. I do not know if
what I just said is nonsense and I have not browsed sql.py yet but my
thought is:
I suppose DAL is a layer built over a particular database python API:
sqlite=pysqlite, mysql=mysqldb ecc
If this is true, why not have DAL support for an ODBC API like pyodbc?
This way you can have a basic support for several RDBMS in one shot.
By the way this could be an easy way to connect to MS Access databases
which are very popular in Windows.
Any way I am available to test any web2py to DB2 support both through
pyodbc or pydb2. Let me know and thank you
carlo
On 22 Feb, 21:57, Yarko Tymciurak <yark...@gmail.com> wrote:
> yes - there are two things you are talking about here, Carlo -
> How do I connect to the DB server so it will listen to me? That you have
> answered with pyodbc.connect();
>
> And what will you say to it? --- Simply, with web2py your choices are
> literally two, but practically one:
>
> - you can write all the DB2 SQL commands yourself directly from within
> web2py:
>
> db.executesql('my commands');
>
> This is OK if you are doing one or two special tests to see if you're on
> DB2, and issue special commands,
> but if you write an app this way you will not have all the web2py behaviors
> (e.g. form generation, validation); in other words you will make too much
> work for yourself.
>
> The DAL description for a DB is not that complex, and offers you many
> advantages. Massimo (I think) would write the basics for you, if you will
> test. I think this is what you want / need. It's not too much work.
>
> Have a look at gluon/sql.py: SQL_DIALECTS to see what we're talking about.
> Not too bad, really.
>
> I think you do want this. Once you have it you will be happy.
>
> Regards,
> Yarko
>
> On Sun, Feb 22, 2009 at 2:20 PM, mdipierro <mdipie...@cs.depaul.edu> wrote:
>
> > Even if you use odbc, don't you you still need to generate SQL
> > statements in the DB2 SQL dialects?
>
> > Massimo
>
> > On Feb 22, 2:01 pm, carlo <syseng...@gmail.com> wrote:
> > > massimo, I do not need native db2 support I always had access via odbc
> > > ( I like pyodbc ), I was just wondering how I can have a connection
> > > through a DSN (very common in windows environment) instead of using
> > > the usual connection string. I found something in one thread here but
> > > nothing official in the book.
> > > As I said in my app I had:
>
> > > db400=pyodbc.connect("DSN=myAS400;UID=myUID;PWD=myPWD")
>
> > > I need a DAL equivalent.
>
> > > Said that, if you need to test a new web2py db2 support, I am
> > > available as I have a vpn to my client's AS400 .
>
> > > carlo
>
> > > On 22 Feb, 17:34, mdipierro <mdipie...@cs.depaul.edu> wrote:
>
> > > > We do not have DB2 support but if you are available to run some tests
> > > > we can have that in a couple of days.
> > > > I will email you a new sql.py for you to test later today.
>
> > > > Massimo
>
> > > > On Feb 22, 9:47 am, carlo <syseng...@gmail.com> wrote:
>
> > > > > I am going to port an application developed in Karrigell to web2py:
> > > > > RDBMS was DB2 on as400.
>
> > > > > In my actual version I connected through DSN and pyodbc this way:
>
> > > > > db400=pyodbc.connect("DSN=myAS400;UID=myUID;PWD=myPWD")
>
> > > > > How can I get a DSN connection through SQLDB? thank you
>
> > > > > carlo
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"web2py Web Framework" group.
To post to this group, send email to web2py@googlegroups.com
To unsubscribe from this group, send email to
web2py+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/web2py?hl=en
-~----------~----~----~----~------~----~------~--~---
