[Koha-bugs] [Bug 10963] Simplified creation of MARC21 sample frameworks

[bugzilla-daemon at bugs.koha-community.org]

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10963

--- Comment #26 from Bernardo Gonzalez Kriegel <bgkriegel at gmail.com> ---
Created attachment 23345
  -->
http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=23345&action=edit
Bug 10963 - [10] Simplified creation of MARC21 sample frameworks

This patch revert original hidden values to the
situation before rewriting simple and fast SQL files.

Also adds missing 082 fields and subfields to
fastadd fw!

To test the complete package:
(before applying the patch)

1) Delete biblio fw
delete from marc_subfield_structure; delete from marc_tag_structure; delete
from biblio_framework;

2) Load default and simple fw

3) Search for different hidden values executing this query and save the result
on a file (ej. simple-old)

"update marc_subfield_structure set frameworkcode = 'AAA' where frameworkcode =
''; select * from (select
tagfield,tagsubfield,hidden,group_concat(frameworkcode order by frameworkcode)
as fws from marc_subfield_structure group by
concat(tagfield,tagsubfield,hidden) having fws <>
'AAA,AR,BKS,CF,IR,KT,SER,SR,VR') as a where fws not like  'AAA%';"

4) Delete biblio fw as in 1)

5) Load default and fastadd

6) Search for different hidden values executing this query and save the result
on a file (ej. fast-old)
"update marc_subfield_structure set frameworkcode = 'AAA' where frameworkcode =
''; select * from (select
tagfield,tagsubfield,hidden,group_concat(frameworkcode order by frameworkcode)
as fws from marc_subfield_structure group by
concat(tagfield,tagsubfield,hidden) having fws <> 'AAA,FA') as a where fws not
like  'AAA%';"

7) Apply the patch (it takes some time, it's large)

8) Repeat 1-2-3) but save on a new file (ej. simple-new)

9) Repeat 4-5-6) but save on a new file (ej. fast-new)

10) Check that que we get the same results

diff simple-old simple-new => no lines
diff fast-old fast-new     => no lines

That's all

-- 
You are receiving this mail because:
You are watching all bug changes.