Hi Massimo
FYI: Some issues to note as you are rewriting the DAL:
1. For mssql connections, I want to write:
db = SQLDB('mssql://dlypka:p...@word1@localhost/TMoMilestones')
The '@' delimiter is a problem for me because '@' is a legal, often
used character in SQL Server passwords
So please at least change the regular expression in sql.py line 768 to
allow enclosing the password in perhaps square brackets
So for example, it would allow
db = SQLDB('mssql://dlypka: [p...@word1]@localhost/TMoMilestones')
The re at line 768 is
re.compile('^(?P<user>[^:@]+)(\:(?P<passwd>[...@]*))?
@(?P<host>[^\:/]+)(\:(?P<port>[0-9]+))?/(?P<db>.+)$'
).match(self._uri[skip:])
2. Please change sql.py to use pymssql rather than pyodbc
pymssql Version 1.0.2 was released on 2009-04-28. It has major bug
fixes and works well now.
I got it from here http://pymssql.sourceforge.net/
I suggest changing sql.py line 791:
# self._pool_connection(lambda : pyodbc.connect(cnxn))
self._pool_connection(lambda : pymssql.connect(cnxn)
3. Please provide a way to specify options such as trusted=True
For example, I need to call it this way:
self._pool_connection(lambda : pymssql.connect
(host='',trusted=True,database=db))
Thank you.
- Dave Lypka.
On May 30, 12:43 am, mdipierro <mdipie...@cs.depaul.edu> wrote:
> Yes, it will be backward compatible unless you used internal and
> undocumented features of the DAL (like importing SQLSet or subclassing
> SQLRows). it will also expose a new alternative cleaner syntax (for
> example you will be asked to use Field instead of SQLField but
> SQLField works too as alias of Field).
>
> I will explain more when done.
>
> Massimo
>
> On May 29, 8:29 pm, cesmiga <cesm...@gmail.com> wrote:
>
>
>
> > Massimo,
>
> > Will the new DAL be backwards compatible with the existing DAL? The
> > reason I ask is because I have been using "WWW SQL Designer" and hope
> > to continue using it with the new DAL.
>
> > Thank you,
> > Christopher
>
> > mdipierro wrote:
> > > I am finishing a rewrite of the new DAL. It may be done in one week or
> > > two but I could use some help.
> > > I can explain exactly what to do. I need people to write and run tests
> > > for the supported backends.
>
> > > It will be beackward compatible and have some new features including
> > > dealing with tables that do not have the 'id' field, realnames
> > > different than virtualnames for tables and columns, a certain degree
> > > of fail safety when multiple databases present, and be very modular
> > > and extensible (to add new engines and new fields and add methods to
> > > handle the fields values). It is also be smaller and I think faster
> > > than the old one.
>
> > > Yes, this is possible and already have it working for sqlite.
>
> > > Let me know if you can help. I need a serious commitment and proven
> > > expertise on this list.
>
> > > Massimo
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
