Eric Dalquist wrote:
I'd like to make some changes to the import/export scripts as outlined
here: http://www.ja-sig.org/issues/browse/UP-1897
The base idea is that currently importing a .user without also importing
a corresponding .layout results in an entry in UP_USER that cannot log
in since the user's profile is imported as well even though the profile
may require a layout.
The change is moving the <profile> information from the .user files into
the .layout files. This would result in a .user that can be imported and
function even if that user has no layout. Entities exported from 2.6
will still function as the 2.6 format import scripts are not touched by
the change.
As we discussed last week, I feel these changes are desirable and would
be happy to see them make it, all else being equal.
Looking at the .patch file, I see a lot of "LEFT JOIN" expressions in
the SQL statements -- are you confident that these will run on all the
common RDBMS platforms?
I'm not a SQL guru, and I can't remember which vendors support and don't
support specific syntax. I mostly just try to keep the SQL simple in
uPortal.
Can anyone chime in on the subject of "LEFT JOIN" on the following DB
flavors, either all of them or individually?
- hsqldb
- postgresql
- oracle
- *MS SQL Server*
- mysql
drew wills
--
Andrew Wills
UNICON, Inc.
Office: (480) 558-2476
http://code.google.com/p/cernunnos/
--
Join your friends and colleagues at JA-SIG 2008 - "Higher Education Solutions: The
Community Source Way!"
April 27th - 30th, 2008 in St. Paul, Minnesota USA
Featuring CAS, DSpace, Fedora, Fluid, Internet2, Kuali, Sakai, uPortal, and
more!
Information/Registration at:
http://www.ja-sig.org/conferences/08spring/index.html
Subscribe to the conference blog, The Community Source Way
http://jasig2008.blogspot.com, for news and updates about the event.
Join the Conference networking site at http://ja-sigspring08.crowdvine.com/
You are currently subscribed to [email protected] as: [EMAIL
PROTECTED]
To unsubscribe, change settings or access archives, see
http://www.ja-sig.org/wiki/display/JSG/uportal-dev
