List of methods for script, to have updated list use
./cake.sh dbadmin help
- rebuildIndex: rebuild search texts index
- checkLangStatus: update lang texts 'status' using master object status
Usage: checkLangStatus -lang
- buildHashMedia: insert 'hash_file' for media file.
Usage: buildHashMedia [-all]
- -all rebuild all 'hash_file'
- setImageDimensions: get images size and update db
Usage: setImageDimensions [-all]
- -all set dimension for all images, otherwise only for image with dimensions no defined in db
- updateVideoThumb: update video thumbnail from external provider
Usage: updateVideoThumb [-id]
- -all update all video, otherwise only video with no thumbnail defined in db
- annotate: add comment/editor notes to object
Usage: annotate [-id ] [-type ]
-id object id to annotate
-type 'editor_note' or 'comment'
- orphans: searche and remove orphaned objects (not in tree)
Usage: orphans -type
- -type model type like 'section' or 'document'
- importCsv: import objects from csv file
Usage: importCsv -f -type
- -f csv file path
- -type model type like 'document' or 'event' to import
- updateStreamFields: update name (if empty), mime_type (if empty), size and hash_file fields of streams table
- checkConsistency: check objects for consistency on database
- updateTreeRoot: update area_id field in trees table
- checkDbNames: check database table/column names
Usage: checkDbNames [-schema]
- -schema use schema file - otherwise read directly from db (default)
- cleanup: remove old items from log/job tables
Usage: cleanup -days
- -days number of days to preserve from today in cleanup
- updateCategoryName: update all categories and tags unique name
-objectType update categories for a specific object type (for example: document)
- importXml: import BE objects from XML (in a section)
Usage: importXml -f [-s ]
- -f xml file path
- -s section id to import
- exportXml: export BE objects to XML
Usage: importXml -o -t
- -o xml output file path
- -t object type: document, short_news, event,.....
