Page Menu
Home
c4science
Search
Configure Global Search
Log In
Files
F81062730
invenio_2013_03_20_idxINDEX_synonym_kb.py
No One
Temporary
Actions
Download File
Edit File
Delete File
View Transforms
Subscribe
Mute Notifications
Award Token
Subscribers
None
File Metadata
Details
File Info
Storage
Attached
Created
Wed, Sep 4, 01:00
Size
2 KB
Mime Type
text/x-python
Expires
Fri, Sep 6, 01:00 (2 d)
Engine
blob
Format
Raw Data
Handle
20511080
Attached To
R3600 invenio-infoscience
invenio_2013_03_20_idxINDEX_synonym_kb.py
View Options
# -*- coding: utf-8 -*-
##
## This file is part of Invenio.
## Copyright (C) 2012, 2013 CERN.
##
## Invenio is free software; you can redistribute it and/or
## modify it under the terms of the GNU General Public License as
## published by the Free Software Foundation; either version 2 of the
## License, or (at your option) any later version.
##
## Invenio is distributed in the hope that it will be useful, but
## WITHOUT ANY WARRANTY; without even the implied warranty of
## MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
## General Public License for more details.
##
## You should have received a copy of the GNU General Public License
## along with Invenio; if not, write to the Free Software Foundation, Inc.,
## 59 Temple Place, Suite 330, Boston, MA 02111-1307, USA.
from
invenio.dbquery
import
run_sql
depends_on
=
[
'invenio_2012_10_29_idxINDEX_new_indexer_column'
]
def
info
():
return
"Introduces new column for idxINDEX table: synonym_kbrs"
def
do_upgrade
():
#first step: change tables
stmt
=
run_sql
(
'SHOW CREATE TABLE idxINDEX'
)[
0
][
1
]
if
'`synonym_kbrs` varchar(255)'
not
in
stmt
:
run_sql
(
"ALTER TABLE idxINDEX ADD COLUMN synonym_kbrs varchar(255) NOT NULL default '' AFTER indexer"
)
#second step: fill tables
run_sql
(
"UPDATE idxINDEX SET synonym_kbrs='INDEX-SYNONYM-TITLE,exact' WHERE name IN ('global','title')"
)
#third step: check invenio.conf
from
invenio.config
import
CFG_BIBINDEX_SYNONYM_KBRS
from
invenio.bibindex_engine_utils
import
get_index_id_from_index_name
if
CFG_BIBINDEX_SYNONYM_KBRS
:
for
index
in
CFG_BIBINDEX_SYNONYM_KBRS
:
index_id
=
get_index_id_from_index_name
(
index
)
synonym
=
","
.
join
(
CFG_BIBINDEX_SYNONYM_KBRS
[
index
])
query
=
"UPDATE idxINDEX SET synonym_kbrs='
%s
' WHERE id=
%s
"
%
(
synonym
,
index_id
)
run_sql
(
query
)
def
estimate
():
return
1
def
pre_upgrade
():
pass
def
post_upgrade
():
print
'NOTE: please double check your new index synonym settings in BibIndex Admin Interface.'
Event Timeline
Log In to Comment