Changeset 2024

Timestamp:

Feb 17, 2006, 4:59:13 PM (18 years ago)

Author:

Martin Svensson

Message:

Updated testdocument for List columns,Filter and User admin

Location:

trunk

Files:

• doc/test/gui/filter.tex (modified) (3 diffs)
• doc/test/gui/listcolumns.tex (modified) (3 diffs)
• doc/test/gui/listpages.tex (modified) (5 diffs)
• doc/test/gui/newcommands.tex (modified) (2 diffs)
• doc/test/gui/useradmin.tex (modified) (1 diff)
• misc/sql/createdb.mysql.sql (modified) (1 diff)
• src/core/net/sf/basedb/core/HibernateUtil.java (modified) (2 diffs)

trunk/doc/test/gui/filter.tex

@@ -2 +2 @@
 
 \section{Filter}
+\label{sFilter}
 This test is common for all filters. There are more specific testing
 under each chapter that uses these functions.\\
@@ -29 +30 @@
   the filter as a preset.
 \item Call the preset for \userinput{testfilter} and uncheck \checkbox{Overwrite
-exixting} and \checkbox{Public}.
-\item Press \button{Ok}.
+exixting} and \checkbox{Public} and press \button{Ok}.
+\item Try to save the filter once again as the previous step describe
+to see that it isn't possible to overwrite an existing preset if
+\checkbox{Overwrite existing} is unchecked.
 \item Click on \click{Clear filter} in the '-view/presets-' drop-downlist. All
   items in the current list should be showed(no filter).
@@ -36 +39 @@
   and control that the filter gives the right result.
   \item Preform the step 2-6 again, but hide/view some other columns
-  and check \checkbox{Overwrite existing} before the preset is saved.
+  and check \checkbox{Overwrite existing} before the preset is saved
+  to see that it is possible to overwrite a preset.
 \item Click on \click{Manage...} in the drop-downlist.
 \item Load the preset called testfilter by clicking on the preset's

trunk/doc/test/gui/listcolumns.tex

@@ -2 +2 @@
 
 \section{List columns}
+\label{sListColumns}
+These tests are common for all listpages.
 Each test case starts from the Column dialogbox if nothing else is
 said. The dialogbox can be accessed in one of two following ways: with the tab
 \tab{Column...} or by clicking on \click{Other...} in the '-view/preset-'
-drop-downlist.\\This chapter is common for all the pages that have a
-list of some kind and where the columns can be arranged in different ways.
+drop-downlist.
 \subsection{Hide}
 \begin{enumerate}
@@ -15 +16 @@
 \item Mark two column-names(not marked as required) in the
   list of visible columns and move them to the list of hidden
-  columns by pressing the button \button{\lt}.
-\item Press the \button{Ok} to see the result.\\Does the table look
-  like as expected? 
+  columns by pressing the button \button{\rt}.
+\item Press the \button{Ok} to see the result.\\Does the table have
+  look that it was exptected to have? 
 \end{enumerate}
 
 \subsection{Show}
 \begin{enumerate}
-\item Mark two column names in the list of hidden columns
+\item Mark two column names in the list of hidden columns.
 \item Move them to the list of visible columns by pressing the
   button \button{\lt}. Were they added in the buttom of the list?
@@ -32 +33 @@
 Make sure that there are more than three names in the list of visible columns
 \begin{enumerate}
-\item Mark the column-name that's in the bottom of list 'Visible
-  columns'.
-\item Press the button \button{\ut} to move up the column name
-\item Press then \button{Ok}. Is the order of the columns as was
-  expected to be?
+\item Mark the column-name that's in the bottom of list with visible
+  columns.
+\item Press the button \button{\ut} to move up the column name.
+\item Press then \button{Ok}. Is the order of the columns as it was
+  expected?
 \item Open the dialogwindow for Columns again with tab
   \tab{Columns...} and mark the column name that is at the top of the
-  list 'Visible Columns'
+  list with visible columns.
 \item Move down the column-name by pressing the button \button{\dt}
 \item Close the window with \button{Ok} and control that the columns
-  are in the order that they are suppose to be.
+  are in the order that they should.
 \end{enumerate}
 
 \subsection{Presets}
 \begin{enumerate}
-\item Click on \click{All} in the '-view/presets-' drop-downlist.\\The
-  list should contain all the columns.
-\item Click on \click{Required columns} in the same drop-downlist. How
+\item Click on \click{All columns} in the '-view/presets-' drop-downlist in
+  mainwindow.\\The list should contain all the columns.
+\item \label{defaultpreset}Click on \click{Default columns} in the same drop-downlist. How
   does the list react?
-\item Click on \click{Default columns} in the same drop-downlist. How
-  does the list react?
-\item Click on \click{Other...} to open the dialog window for columns. There
-  should only be required column names in the list of visible columns.
+\item Click on \click{Required columns} in the same
+  drop-downlist. Only necessary columns should be visible.
+\item Click on \click{Other...} to open the dialog window for columns
+  in the dropdown list. There should only be required column names in
+  the list of visible columns.
 \item Select one or more names in the list of hidden columns and press
-  then on \button{\lt} to move them to the list of visible items.
-\item Press \button{Save as...} to open a new window where the
+  the button \button{\lt} to move them to the list of visible items.
+\item Press the button \button{Save as...} to open a new window where the
   settings can be saved as a new preset.
 \item Press \button{Ok} to test that it isn't possible to save the
   preset without a name.
-\item Give the preset the name \userinput{TestColPre} and press then
-  \button{Ok}to save the preset.
+\item \label{presetsave}Give the preset the name \userinput{TestColPre} and press then
+  \button{Ok} to save the preset.
 \item Click on \click{Default} in the preset dropdown list. Does the columns
-  agree to which once that were displayed in step 3?
+  agree to which once that were displayed in step \ref{defaultpreset}?
 \item Click on \click{All} in the preset dropdown list. Are all columns
   in the list of visible columns?
-\item Click on the preset that was created/saved step 8. Control that the visible columns are the ones that were set
-  in the preset. Press \button{Ok} to view the result in the list.
+\item Click on the preset that was created/saved in step \ref{presetsave}. Control that
+  the visible columns are the same that were set in the preset. Press
+  \button{Ok} to view the result in the list. 
 \item Open the column dialogwindow with the tab \tab{Columns...}.
-\item Click on \click{TestColPre} in the preset dropdown list
+\item Click on \click{TestColPre} in the preset dropdown list.
 \item Press \button{Delete...} to remove the preset of columns
   settings. Is the deleted preset removed from the dropdown list of

trunk/doc/test/gui/listpages.tex

@@ -2 +2 @@
 
 \section{List pages}
+\label{sListpage}
 These test procedures are common for all pages that contains some kind
 of a list.
@@ -12 +13 @@
   selected in the list.
 \item Check one item from the list and click on \tab{Delete}
-  again.\\If 'Include removed'-checkbox is checked a trash can appears
-  beside the item's checkbox or else the item will disappear from
-  the list?
+  again.\\The item will disappear from the list if the listfilter not
+  is set to show removed items. Is it set to show removed items there
+  will be a trash can  beside the item's checkbox instead.
 \item Click on the tab \tab{Restore} without having any items
   selected.\\There should be a message saying that at least one
   item has to be selected.
-\item Check a list item that is marked as removed(\checkbox{Include removed} has
-  to be checked) and click on \tab{Restore} to restore the deleted
-  item. The trash can should disappear and the item being restored successfully.
+\item Check a list item that is marked as removed(the filter/list must
+  be set to show removed items) and click on \tab{Restore} to restore the
+  deleted item. The trash can should disappear and the item being
+  restored successfully.
 \item Click on \tab{Columns...} This should open a window where the list's
-  columns can be managed. Control that the columns are relative for
+  columns can be managed. Control that the columns are relavant to
   the current list and then close the window.
 \item Click on the tab \tab{Export...} to open a window where the
   list or certain rows/columns of the list can be exported to a
-  file. Control that the information in the window are relative to the
+  file. Control that the information in the window are relavant to the
   current list and then close the window.
 \end{enumerate}
 \subsection{Navigator}
+Set the hits/page so there will be at least 4 list pages.
 \begin{enumerate}
 \item Click on the \click{\rt} to view the next list page. The page
@@ -38 +41 @@
 \item Click on the \click{\tostart} to view the first page with list items.
 \item Test the hits/page with the following values, press 'enter'
-  after each input and control that the number of showed items is right.
+  after each input and control that the number of showed items and
+  pages are right according to how many hits there are totaly.
 \begin{itemize}
 \item value that is bigger then the total number of hits.
@@ -46 +50 @@
 \item \userinput{-3}
 \end{itemize}
-The last to values are invalid but should be handled by the webclient.
+The last two values are invalid but should be handled by the webclient.
 \item Set the hits/page to be less then the total number of hits and
   control that the number of pages is right. Are the page numbers
@@ -64 +68 @@
 \begin{enumerate}
 \item Control that each list items has a link to view/edit the
-  information in a new window.
-\item Click on the link for some of the items and check out how the
-  information is displayed in the new window.
+  information in a separate dialogwindow.
+\item Click on the link for some of the items and check that right
+  information is viewed in the dialogwindow.
+\item Click on \click{Export...} to open the export window.
+\item Set Format to be \radiobox{Tab-separated text file}. Select
+  items to be from \radiobox{All pages} and the the columns to be
+  \click{Current}
+\item Leave the 'Save as' textfield empty and \checkbox{Overwrite
+  existing file} unchecked. 
+\item Press \button{Ok} to download the file and control the contents
+  of the file. It should agree to the items-list in the webclient.
+\item Export the items on \radiobox{Current page} to a
+  \radiobox{Tab-separated text file}. Check \checkbox{Overwrite
+  existing file} and download it by press the \button{Ok} button. Does
+  the file seems to be ok? 
+\item Export to a third file, but these time in \radiobox{XML} format
+  and to the home-directory on BASE2 with only one exported
+  column. Download the file and compare it with the list.
+\item Try to export to a file with no exported columns. Is the result
+  acceptable?
 \end{enumerate}

trunk/doc/test/gui/newcommands.tex

@@ -18 +18 @@
 \newcommand{\la}[1]{$\leftarrow$ }
 \newcommand{\lt}[1]{$\triangleleft$}
-\newcommand{\rt}[1]{$\triangleright$}
+\newcommand{\rt}[1]{$\triangleright$ }
 \newcommand{\ut}[1]{$\bigtriangleup$}
 \newcommand{\dt}[1]{$\bigtriangledown$}
@@ -26 +26 @@
 \newcommand{\toend}[1]{$\triangleright$$\vert$}
 \newcommand{\tostart}[1]{$\vert$$\triangleleft$}
+\newcommand{\seclistcolumns}[1]{chapter~\ref{sListColumns}A }
+\newcommand{\secfilter}[1]{chapter~\ref{sFilter}B }
+\newcommand{\seclistpage}[1]{chapter~\ref{sListpage} }
+\newcommand{\secnewrole}[1]{section~\ref{sssrolenew}~New... }
+\newcommand{\secnewgroup}[1]{section~\ref{sssgroupnew}~New... }
+\newcommand{\secnewuser}[1]{section~\ref{sssusernew}~New... }

trunk/doc/test/gui/useradmin.tex

@@ -7 +7 @@
 
 \subsubsection{New...}
-\begin{enumerate}
-\item Click on the tab \tab{New...} to open the 'New user' window.
-\item Clear all textfields and press \button{Save}. Type the following information:
+\label{sssusernew}
+\begin{itemize}
+\item Expired useraccount
+\begin{enumerate}
+\item Click on the tab \tab{New...} to open the 'Create user' window.
+\item Clear all textfields and press \button{Save}. It shouldn't be
+  possible to save whithout name and login.
+\item Set \textbf{Name:} to \userinput{Test {\AA}\"a\"o} and press
+  \button{Save} to. It shouldn't be possible to save without login.
+\item Give the user following settings:
 \begin{description}
-\item [Name:] \userinput{Test {\AA}\"a\"o}.\\Press \button{Save},
-  it shouldn't be possible to save the usersettings when no login is set.
-\item [Login:]\userinput{testLogin}. 
-\item [External ID:] \userinput{testid}
+\item [Login:]\userinput{explogin}. 
+\item [External ID:] \userinput{expid}
 \item [New password:] \userinput{testpassword}.
 \item [Retype password:] \userinput{TESTPASSWORD}.\\Press
-  \button{Save}, it shouldn't be possible to submit when the retyped password 
-  not is identical with the text in New password. Change then the Retype password
-  to be \userinput{testpassword}.
+  \button{Save} to test that it's not possible to submit when the
+  retyped password not is identical with the text in New
+  password. Change the Retype password to \userinput{testpassword}.
+\item [Quota group:] Select a group quota group if there is any.
+\item [Home directory:] Select \click{-create new from template-}
+\item [Expiration date:] \userinput{1999-01-01}
 \end{description}
-
+\item Press \button{Save}
+\item Open a new web browser window/tab and login to BASE2 as the
+  new user. It shouldn't be possible because of the expired date.
+\item Use the active session to check if there is a home directory for
+  the new user.
+\end{enumerate}
+
+\item User with quota and no home directory
+\begin{enumerate}
+\item Open the window to create a user.
+\item Give the new user following parameters: \\name:
+  \userinput{Quota noHome}\\login: \userinput{QnHD}\\
+  password: \userinput{pw}.
+\item Set quota to \click{Default quota} and quouta group to
+  \click{-none-}.
+\item Select home directory to be \click{-none-} and leave expiration
+  date empty.
+\item Check \checkbox{Multi-user account} and uncheck
+  \checkbox{Disabled}.
+\item Go to \tab{Membership}, press \button{Add groups...}, check the group
+  \checkbox{Users} and press \button{Ok}. The group should be visible
+  in the list.
+\item Press \button{Add role...}, check the role \checkbox{Guest} and press
+  \button{Ok}. The role should be visible in the list.
+\item Press \button{Save} in the buttom of the window.
+\item Open a new web browser window/tab and login to BASE2 as the
+  new user. Try to change the password under \menu{File} \ra
+  \menu{Change password...}, it shouldn't be possible. Check that this
+  login doesn't have a home directory.
+\item Check that the user has been added to the Users-group and
+  Guest-role by viewing the properties for the group/role.
+\end{enumerate}
+
+\item User with unlimited quota and a empty home directory.
+\begin{enumerate}
+\item Click on \tab{New...} to create a new user.
+\item Give the new user following parameters:\\name
+  \userinput{unlQ Emptyhome}\\login \userinput{ulQeHD}\\password
+  \userinput{pw}.
+\item Set quota to \click{Unlimited quota} and quota group to
+  \click{-none-}.
+\item Select home directory to be \click{-create new(empty)-} and
+  leave expiration date empty.
+\item Leave \checkbox{Multi-user account} unchecked and check
+  \checkbox{Disabled}.
+\item Press \button{Save}.
+\item Open the a new web browser window/tab and try login to BASE2 as the
+  new user. It shouldn't be possible because of the disabled option.
+\item Use the active session to uncheck \checkbox{Disabled} for
+  \textit{ulQeHD} and try to login one more time with this login and
+  password, it should be successful. 
+\item Check that the new user has an empty home directory.
+\end{enumerate}
+
+\item User with existing home directory
+\begin{enumerate}
+\item Open the window to create a user.
+\item Give the new user the following parameters: name
+  \userinput{Exist Home}, login \userinput{xhome} and password
+  \userinput{pw}.
+\item Set quota to \click{500 MB total} and quota group to
+  \click{-none-}.
+\item Select home directory to be \click{ulQeHD} or some other
+  existing login from the list of home directories.
+\item Leave expiration date empty and \checkbox{Multi-user account}
+  and \checkbox{Disabled} unchecked.
 \item Go to the tab \tab{Contact Information}.
-\item Write \userinput{thep.lu.se} in the field for email. Press \button{Save}. Is it accepted?
-\item Write an existing email.
-\item Try the \rt a for both 'Address' and 'Description' to get a larger
-  window to edit the information in.
-\item Control that the text in 'Address'/'Description' is the same as
-  the text that was written in the larger window.
-\item Go to the tab \tab{Membership} and add a group and/or a role to the
+\item Type \userinput{base.com} in the field for emailaddress. Press
+  \button{Save}. Is the invalid email-address accepted?\\ Type \userinput{something@base.com} in the email field instead.
+\item Type \userinput{BASE tester} in the organisation field.
+\item Type \userinput{Text in textbox} in the textfield for
+  address. Click on the \rt to open a large window for address.
+  and type \userinput{Text in large window}. Press \button{Ok}. Is the
+  text from the textfield displayed in the large window and does the
+  field get updated when submitting the large window?
+\item Repeat previous step for the description field.
+\item Go to tab \tab{Membership} and add   and/or a role to the
   user.
 \item Press \button{Save} to save the settings for the user.
-\item Logout and login as the user in previous steps and control that
-  the settings and the permissions are right for the account. Check
-  also that the user has got a 'home account' to store the files in.
-\end{enumerate}
+\end{enumerate}
+\end{itemize}
 
 \subsubsection{Userlist}
 \begin{enumerate}
-\item Do the steps under chapter4 \textit{List pages}.
-\item Control that the names also are links to edit the
-  information for the items.
-\item Click on the name of the first item in the list to view the
- information about the user in a seperate window.
-\item Test to edit the values in the fields by doing the steps under
-  \textit{New..} above with start at the second step.
-\end{enumerate}
+\item Select \click{All columns} in the dropdown list '-view/presets-'.
+\item Do the steps in \seclistpage\ before continuing.
+\item View an user's properties by clicking on it's name in the
+  list.
+\item Click on \tab{Edit...}.
+\item Change the values/properties for the users that were created earlier in
+  the test by following the steps in \secnewuser\ . It shouldn't be
+  the same steps that the user were created from.
+\item Check that the properties are updated.
+\item Click on \click{Delete} in the user's property window. Go back to the \click{Users} list and control that the user is deleted.
+\item Set the list to view removed items and open the properties for
+  the user that was removed recently. Click on \click{Restore} to
+  remove the flagg for deletion and then return to the user list.
+\end{enumerate}
+
+\subsubsection{Columns}
+Follow the steps in \seclistcolumns\ and have following information in mind
+when preforming the tests:
+\begin{itemize}
+\item The columns in Users-list are Name, Description, Quota group,
+  Quota, Url,Fax, Phone, Email, Address, Organisation,Multi-user
+  account, Disabled, Expiration date, External ID, System ID and Login .
+\item The required field is Name.
+\item The visible columns in default preset are Name, Description,
+  Login, Expiration date, Email and Description.
+\end{itemize}
 
 \subsubsection{Filter}
-See chapter 5B for testing the filters.\\
-In this build of the program the filter for users is a bit different from
-some of the other filters in BASE2.\\\\
-\textbf{Basic Filter}
-\begin{enumerate}
-\item Select different column names in the Drop-downlist to the left
-  under 'Find' and check how the filterpanel changes.\\Does the page
-  act as expected?
-\item Filter the users on 'Name' with the textstring \userinput{l\%y}.\\The
-  result should be a list with users that first have 'l' and then 'y'
-  in their names(not CASE-sensitve).
-\item Filter the users on 'Expiration date' with the format
-  YYYYMMDD.\\The list should be empty
-\item  Change the format to YYYY-MM-DD and do the search again.\\The
-  listed users should have a 
-expiration date that is equal to the filtered date.
-\end{enumerate}
-\textbf{Advanced Filter}
-\begin{enumerate}
-\item Press the button \button{Configure...} for advanced filter.
-\item Select a column that is supposed to be a part of the filter,
-  set the condition and press then on \button{Add}
-\item Select the radiobuttons \radiobox{And} and add one more
-  column filter.
-\item Save the filter as a preset, by press the button \button{Save
-  As...} and type in a name for the preset,
-\item Create one more preset but check \radiobox{Or} instead of
-  \radiobox{And} when the two filters are combined.
-\item Press \button{Ok} to view the filtered rows. Is the result as
-  expected?
-\item Open the advanced filter again and try to modify a preset, save
-  it in the same name and press then \button{Ok} again.\\Control the result
-  when the preset filter is chosen.
-\item Open the advanced filter once again. Choose a preset to delete
-  and press \button{Delete}. The name of the deleted preset should be ereased
-  from the presets list.
-\end{enumerate}
-
-\subsubsection{Columns}
-See chapter5 for a general testing of the Columns.
-It is only possible to access the Columns dialogwindow through the tab
-\tab{Columns...} at this moment.
-
-\begin{enumerate}
-\item Open the columns dialogwindow by clicking on the tab \tab{Columns}.
-\item Select \click{Name}, it should be marked as required, and try to
-  move it to the list of hidden columns. Is it possible?
-\item Select two column names that not are marked as required in the
-  list of visible columns. Move the items to the list of hiddens
-  columns.
-\item Save the setting as a new preset. Press \button{OK} to show the
-  result.
-\item Go back to \tab{Columns...} and choose the preset 'All'
-  again. Press \button{Ok} and check the result. Are all the columns visible?
-\item Open \tab{Columns...} one more time and choose the preset that was
-  created during previous step. Check that right columns are
-  visible/hidden according to the settings.
-\item Delete the preset by press \button{Delete...}. Is the preset
-  for the columns removed?
-\end{enumerate}
-
-\subsubsection{Export}
-\begin{enumerate}
-\item Click on the tab \tab{Export}.
-\item Download the current page as a XML file to your local
-  computer and control the result.
-\item Export All pages as a text-file to the user account and control
-  the result.
-\end{enumerate}
+Follow the steps in \secfilter\ to test the filters and use the
+following values on the column filters.
+\begin{description}
+\item [Name:] \userinput{r\%} - all users that have a name that starts
+  with a 'R'.
+\item [Description:] \userinput{=} - users that don't have any description.
+\item [Quota group:] \userinput{<>} - users that belongs to quota group
+\item [Quota:] \userinput{<>unlimited quota} - users that don't have
+  unlimited qouta.
+\item [Url:] \userinput{=} - the users with a World-Wide-Web
+  address that ends with 'se'.
+\item [Fax:] \userinput{+46\%} - users with a fax-number that starts
+  with '+46'
+\item [Phone:] \userinput{+46\%} - users with a phone-number that starts
+  with '+46'
+\item [Email:] \userinput{\%lu.se} - users with a email at 'lu.se'
+\item [Address:] \userinput{\%lund\%} - users with 'lund' in there address
+\item [Organisation:] \userinput{=} - users that don't have any
+  organisation registred.
+\item [Multi-user account:] \radiobox{true} - all users account
+  that is set as a multi-user.
+\item [Disabled:] \radiobox{false} - all users that not ar
+\item [Expiration date:] \userinput{<2006-02-23} - lists the usersaccounts
+  that exipered before 2006-02-23
+\item [External ID:] \userinput{}
+\item [System ID:] \userinput{\%net.sf.basedb\%} - lists the
+  useraccounts that are system items in BASE2, \eg{Root account} 
+\item [Login:] \userinput{test\%} - lists user with a login that
+  starts with 'test'.
+\end{description}
+Combine the different filters with each other and check the result.
 
 \subsection{Groups}
 Groups can be accessed through \menu{Administrate} \ra \menu{Groups}
+
 \subsubsection{New..}
-\begin{enumerate}
-\item Click on the tab \tab{New...} to open the 'Create group' window.
-\item Leave the textfield for name empty and try to save the new
-  group. Is it possible?
-\item Click on the \ra to the right of the description textbox to edit
-  the Description in a larger window.
-\item Select a quota for the group.
-\item Add the users that shall belong to this group.
-\item Add other groups that shall be a part of this group.
-\item Press \button{Save} to submit and add the new group to BASE2. 
+\label{sssgroupnew}
+\begin{enumerate}
+\item Click on the tab \tab{New...} to open the 'Create group'
+  dialogwindow and close it with \button{Cancel}. Open the
+  dialogwindow again.
+\item Clear the textfield for name and try to save the new group
+  without a name. It shouldn't be possible?
+\item Give this new group the name \userinput{Testgroup}.
+\item Type \userinput{Text in small window} in the Description textbox.
+\item Click on the \rt d to the right of the description textbox and
+  type \userinput{Text in large window} in the large window. 
+\item Press \button{Ok} and check if the Description text is as expected.
+\item Set Quota to \click{Default quota(10.0MB totalt)}
+\item Change to the tab \tab{Members}.
+\item Press \button{Add user...}, select \checkbox{Root} and press
+  \button{Ok} to add the user and close the window.
+\item Press \button{Add groups...}, select \checkbox{Everyone} and
+  \checkbox{Users} and press \button{Ok} to add the groups and close
+  the window.
+\item Select \click{Everyone} and press \button{Remove} to remove the
+  listed group.
+\item Press \button{Save} and check the user and the group that
+  belongs to this new group.
 \end{enumerate}
 
 \subsubsection{Grouplist}
-Do all the steps in chapter4 for this list.
-\begin{enumerate}
-\item Click on the name of the first item in the list to view the
- information about the group in a seperate window.
-\item Test to edit the values in the fields by doing the steps under
-  \textit{New..}. Start at the second step.
-\end{enumerate}
+\begin{enumerate}
+\item Select \click{All columns} in the dropdown list '-view/presets-'.
+\item Do the steps in \seclistpage\ before continuing.
+\item View a group's properties by clicking on it's name in the
+  list. Make sure that the group not is a system item.
+\item Click on \tab{Edit...}.
+\item Test to change the values in the fields by doing the steps under
+  previous \secnewgroup\ Start at the second step. Finish it
+ by saving the new information and check that the properties are updated.
+\item Click on \click{Delete} in the group's property window. Go back to the \click{Groups} list and control that the group is deleted.
+\item Set the list to view removed items and open the properties for
+  the group that was removed recently. Click on \click{Restore} to
+  remove the flagg for deletion and then return to the group list.
+\end{enumerate}
+
+\subsubsection{Columns}
+Follow the steps in \seclistcolumns\ and have following information in mind
+when preforming the tests:
+\begin{itemize}
+\item The columns in Groups-list are Name, System ID, Quota and Description.
+\item The required field is Name.
+\item The visible columns in default preset are Name and Description.
+\end{itemize}
 
 \subsubsection{Filter}
-Do the steps in chapter 5B for testing the filters.
-
+Follow the steps in \secfilter\ to test the filters and use the
+following values on the column filters.
+\begin{description}
+\item [Name:] \userinput{\%s\%} - at least 2 hits.
+\item [System ID:] \userinput{\%sf\%} - at least 1 hit.
+\item [Quota:] \userinput{\%unlimited\%} - all the groups that have an
+  unlimited quota.
+\item [Description:] \userinput{\%every\%} - at least 2 hits.
+\end{description}
+Combine the different filters with each other and check the result.
+
+\subsection{Roles}
+The roles can be accessed through \menu{Adminstrate} \ra \menu{Roles}
+
+\subsubsection{New..}
+\label{sssrolenew}
+\begin{enumerate}
+\item Click on the tab \tab{New...} to open the 'Create role'
+  dialogwindow and close it with \button{Cancel}. Open the
+  dialogwindow again.
+\item Clear the textfield for name and try to save the new role
+  without a title. It shouldn't be possible?
+\item Give this new role the name \userinput{Testrole}.
+\item Check \checkbox{Share to Everyone} and \checkbox{Act as another
+  user}.
+\item Type \userinput{Text in small window} in the Description textbox.
+\item Click on the \rt d to the right of the description textbox and
+  type \userinput{Text in large window} in the large window. 
+\item Press \button{Ok} and check if the Description text is as expected.
+\item Change to the tab \tab{Permissions}. Set different kind of
+  permissions to the item types and remeber them to be able to test
+  them later.
+\item Change to the tab \tab{Members}.
+\item Press \button{Add user...} and  select a user that shall belong
+  to this role.
+\item Add another user but remove it again with the button
+  \button{Remove}.
+\item Press \button{Save} and check the users that belongs to this new
+  role.
+\end{enumerate}
+
+\subsubsection{Rolelist}
+
+\begin{enumerate}
+\item Select \click{All columns} in the dropdown list '-view/preset-'.
+\item Do the steps in \seclistpage\ before continuing.
+\item View a role's properties by clicking on it's name in the
+  list. Make sure that the role not is a system item.
+\item Click on \tab{Edit...}.
+\item Test to change the values in the fields by doing the steps under
+  previous \secnewrole\ Start at the second step. Finish it
+ by saving the new information and check that the properties are updated.
+\item Click on \click{Delete} in the role's property window. Go back to the \click{Role} list and control that the role is deleted.
+\item Set the list to view removed items and open the properties for
+  the role that was removed recently. Click on \click{Restore} to
+  remove the flagg for deletion and then return to the role list.
+\end{enumerate}
+
+\subsubsection{Filter}
+Follow the steps in \secfilter\ to test the filters and use the
+following values on the column filters.
+\begin{description}
+\item [Name:] \userinput{\%or\%} - at least 2 hits.
+\item [System ID:] \userinput{\%sf\%} - at least 5 hits.
+\item [Description:] \userinput{\%with\%} - at least 3 hits.
+\end{description}
+Change the filter on System ID to be \userinput{\%sf\%a\%a\%} and use
+the other two values above to combine the filters.\\It should give at
+least one hit when all three columns are filtered together.\\The results are based on some default roles that are standard in BASE2.
 \subsubsection{Columns}
-See chapter 5 for a general testing of the Columns.
-\begin{enumerate}
-\item Click on the Tab 'Columns'.
-\item Select one of the columns that are marked as required and try to
-  move it to the list of hidden columns. Is it possible?
-\item Select two column names that not are marked as required in the
-  list of visible columns. Move the items to the list of hiddens
-  columns.
-\item Save the setting as a new preset. Click on `OK' to show the
-  result.
-\item Go back to `Colums...-tab' and choose the preset 'All'
-  again. Click 'OK' and check the result. 
-\item Open 'Columns...' one more time and choose the preset that was
-  created during step 1 and 2. Check that the right columns are
-  selected/hidden.
-\item Delete the preset.
-\end{enumerate}
-
-\subsubsection{Export}
-\begin{enumerate}
-\item Click on the tab 'Export'.
-\item Download the current page as a XML file to your local
-  computer. Download a file a couple of times and change the exported
-  columns.
-\item Open the downloaded files to control the results.
-\item Export All pages to a text-file to the user account and have the
-  exported columns to be default.
-\item Download the exported file to see the result.
-\end{enumerate}
-
-\subsection{Roles}
-
-\subsubsection{New..}
-\begin{enumerate}
-\item Click on the tab 'New...' to open the 'Create role' window.
-\item Leave the textfield for title empty and try to save the new
-  group. Is it possible?
-\item Click on the \ra to the right of the description textbox to edit
-  the Description in a larger window.
-\item Select a quota for the group.
-\item Add the users that shall belong to this group.
-\item Add the groups that shall belong to this group.
-\item Click on 'Save' to submit and add the new group to BASE2. 
-\end{enumerate}
-
-\subsubsection{Grouplist}
-\begin{enumerate}
-\item Click on column title 'Name' to sort the Groups after their
-  names.
-\item Click once again on the same title to reverse the sort
-  order.
-\item Try the same with the other columns.
-\item Click on the name of the first item in the list to view the
- information about the group in a seperate window.
-\item Test to edit the values in the fields by doing the steps under
-  \textit{New..}. Start at the second step.
-\end{enumerate}
-
-\subsubsection{Delete/Restore}
-\begin{enumerate}
-\item Check one or more items in the grouplist.
-\item Click on Delete. The checked items should disappear from the list.
-\item Check 'include removed'. Are the deleted items visible and have
-  a trashcan in the first column?
-\item Check one or more items that is marked as deleted.
-\item Click on 'Restore'. Is the trashcan gone for each of the checked
-  items?
-\end{enumerate}
-
-\subsubsection{Filter}
-See chapter 6 for testing the filters.\\
-In this build of the program the filter for users is a bit different from
-some of the other filters in BASE2.\\\\
-\textbf{Basic Filter}
-\begin{enumerate}
-\item Filter the rows with each column name in the drop-downlist to the
-  left under'Find' and watch how the label is changed depending on
-  wich format the chosen column has.
-\item Filter the users on 'Name' with the textstring 'l\%y'.\\The
-  result should be a list with users that first have 'l' and then 'y'
-  in their names(not CASE-sensitve).
-\item Filter the users on 'Expiration date' with the format
-  YYYYMMDD.\\The list should be empty
-\item  Change the format to YYYY-MM-DD and do the search again.\\The
-  listed users should have a expiration date that is equal to the
-  filtered date.
-\item Type in a date as it suppose to be. Change the filtered
-  column(with out preforming the filter on the Expiration date) to be
-  'Name' and type an existing username and press enter. Is the result
-  as expected?
-\end{enumerate}
-\textbf{Advanced Filter}
-\begin{enumerate}
-\item Click on 'Configure...' for advanced filter.
-\item Select a column that is supposed to be a part of the filter,
-  set the condition and click then on 'Add'
-\item Select one of the radiobuttons 'And' or 'Or' and add one more
-  column filter.
-\item Save the filter as a preset, by clicking on 'Save As...' and the
-  preset in a new name.
-\item Click on 'Ok' to view the filtered rows. Is the result as
-  expected?
-\item Open the advanced filter again and try to modify a preset, save
-  it in the same name and press then 'Ok' again.\\Control the result
-  when the preset filter is chosen.
-\item Open the advanced filter once again, this time delete one preset
-  and click then on 'Ok'. The deleted preset should be ereased
-  from the list of presets.
-\end{enumerate}
-
-\subsubsection{Columns}
-See chapter 5 for a general testing of the Columns.
-\begin{enumerate}
-\item Click on the Tab 'Columns'.
-\item Select one of the columns that are marked as required and try to
-  move it to the list of hidden columns. Is it possible?
-\item Select two column names that not are marked as required in the
-  list of visible columns. Move the items to the list of hiddens
-  columns.
-\item Save the setting as a new preset. Click on `OK' to show the
-  result.
-\item Go back to `Colums...-tab' and choose the preset 'All'
-  again. Click 'OK' and check the result. 
-\item Open 'Columns...' one more time and choose the preset that was
-  created during step 1 and 2. Check that the right columns are
-  selected/hidden.
-\item Delete the preset.
-\end{enumerate}
-
-\subsubsection{Export}
-\begin{enumerate}
-\item Click on the tab 'Export'.
-\item Download the current page as a XML file to your local
-  computer. Download a file a couple of times and change the exported
-  columns.
-\item Open the downloaded files to control the results.
-\item Export All pages to a text-file to the user account and have the
-  exported columns to be default.
-\item Download the exported file to see the result.
-\end{enumerate}
+Follow the steps in \seclistcolumns\ and have following information in mind
+when preforming the tests:
+\begin{itemize}
+\item The columns in Role-list are Name, System ID and Description.
+\item The required field is Name.
+\item The visible columns in default preset are Name and Description.
+\end{itemize}
 
 \subsection{Quota}

trunk/misc/sql/createdb.mysql.sql

@@ -47 +47 @@
 GRANT ALL ON `base2`.* TO 'base2user'@'localhost' IDENTIFIED BY 'password';
 GRANT ALL ON `base2dynamic`.* TO 'base2user'@'localhost';
+
+/*For MySql 5.0 only
+SET PASSWORD FOR 'base2user'@'localhost' = OLD_PASSWORD('password');
+FLUSH PRIVILEGES;*/

trunk/src/core/net/sf/basedb/core/HibernateUtil.java

@@ -43 +43 @@
 import java.sql.SQLException;
 import java.net.URL;
+import java.net.URLDecoder;
 
 import org.jdom.Document;
@@ -91 +92 @@
     Log core events.
   */
-  private static final org.apache.log4j.Logger log = 
+  private static final org.apache.log4j.Logger log =
     org.apache.log4j.LogManager.getLogger("net.sf.basedb.core");