= Views =

Die folgenden Views sind notwendig:

{{{
create view title_mss as SELECT a.titleid, a.fulltitle, a.shorttitle, a.arabictitle, a.aunum, a.fulltitle_normal, m.city, m.library, m.collection, m.msnum,m.msid
   FROM titles a
   LEFT JOIN mss m ON a.titleid = m.titleid;
}}}

{{{
create view author_title_mss as SELECT a.aunum, b.titleid, b.fulltitle, b.shorttitle, b.arabictitle, b.fulltitle_normal, b.city, b.library, b.collection, b.msnum,b.msid
   FROM authors a
   LEFT JOIN title_mss b ON a.aunum = b.aunum;

}}}
{{{
create view alias_and_name as
 SELECT authors.aunum, authors.fullname, authors.fullname_normal
   FROM authors
UNION 
 SELECT aliases.aunum, aliases.alias AS fullname, aliases.alias_normal AS fullname_normal
   FROM aliases;
}}}

= How to update the database? =

    * Als erstes müssen alle Tabellen, die upgedated werden sollen, in der sql Datenbank trunciert werden. (sollte in das Zope eingebaut werden.)
     {{{
       z.B. TRUNCATE titles
     }}}
    * Dann müssen die XML Exporte aus der Access-Datenbank auf den Server von ismi kopiert werden, z.b. in /tmp/ismi
    * Über einen Browser können, die Tabellen dann upgedatet werden:

    {{{
http://ismi/islamicMS/islamicMS/database/importXMLFileAccess?table=titles&container=TITLES&filename=/tmp/ismi/titles.xml
http://ismi/islamicMS/islamicMS/database/importXMLFileAccess?table=authors&container=Authors&filename=/tmp/ismi/authors.xml
http://ismi/islamicMS/islamicMS/database/importXMLFileAccess?table=aliases&container=Aliases&filename=/tmp/ismi/aliases.xml
http://ismi/islamicMS/islamicMS/database/importXMLFileAccess?table=city&container=City&filename=/tmp/ismi/city.xml
http://ismi/islamicMS/islamicMS/database/importXMLFileAccess?table=collection&container=Collection&filename=/tmp/ismi/collection.xml
http://ismi/islamicMS/islamicMS/database/importXMLFileAccess?table=commentary&container=commentary&filename=/tmp/ismi/commentary.xml
http://ismi/islamicMS/islamicMS/database/importXMLFileAccess?table=library&container=Library&filename=/tmp/ismi/library.xml
http://ismi/islamicMS/islamicMS/database/importXMLFileAccess?table=institutions&container=Institutions&filename=/tmp/ismi/institutions.xml
http://ismi/islamicMS/islamicMS/database/importXMLFileAccess?table=mss&container=MSS&filename=/tmp/ismi/mss.xml
http://ismi/islamicMS/islamicMS/database/importXMLFileAccess?table=arabicpassages&container=ArabicPassages&filename=/tmp/ismi/arabicpassages.xml
}}}

    * Scließlich müssen die normalisierten Felder in titles, authors und alias erzeugt werden:
    {{{
http://ismi.mpiwg-berlin.mpg.de/database/normalizeField?table=titles&fieldname=fulltitle
http://ismi.mpiwg-berlin.mpg.de/database/normalizeField?table=authors&fieldname=fullname
http://ismi.mpiwg-berlin.mpg.de/database/normalizeField?table=aliases&fieldname=alias
}}}