Last active
February 29, 2016 22:23
-
-
Save jraddaoui/c5cc0d0ecd06d7f4c25e to your computer and use it in GitHub Desktop.
Accession creation with fix.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 96 Connect root@localhost on atom_2 | |
| 96 Query SET NAMES 'utf8' | |
| 96 Query SELECT COUNT(*) FROM `setting` WHERE setting.NAME='plugins' | |
| 96 Query SELECT setting.NAME, setting.SCOPE, setting.EDITABLE, setting.DELETEABLE, setting.SOURCE_CULTURE, setting.ID, setting.SERIAL_NUMBER FROM `setting` WHERE setting.NAME='plugins' | |
| 96 Query SELECT setting_i18n.VALUE, setting_i18n.ID, setting_i18n.CULTURE FROM `setting_i18n` WHERE setting_i18n.ID='1' | |
| 96 Query SELECT COUNT(*) FROM `user`, `actor`, `object` WHERE user.ID='115215' AND actor.ID=object.ID AND user.ID=actor.ID | |
| 96 Query SELECT object.CLASS_NAME, object.CREATED_AT, object.UPDATED_AT, object.ID, object.SERIAL_NUMBER, actor.ID, actor.CORPORATE_BODY_IDENTIFIERS, actor.ENTITY_TYPE_ID, actor.DESCRIPTION_STATUS_ID, actor.DESCRIPTION_DETAIL_ID, actor.DESCRIPTION_IDENTIFIER, actor.SOURCE_STANDARD, actor.PARENT_ID, actor.LFT, actor.RGT, actor.SOURCE_CULTURE, user.ID, user.USERNAME, user.EMAIL, user.SHA1_PASSWORD, user.SALT, user.ACTIVE FROM `object`, `actor`, `user` WHERE user.ID='115215' AND actor.ID=object.ID AND user.ID=actor.ID | |
| 96 Query START TRANSACTION | |
| 96 Query SELECT COUNT(*) FROM `term`, `object` WHERE term.ID=169 AND term.ID=object.ID | |
| 96 Query SELECT object.CLASS_NAME, object.CREATED_AT, object.UPDATED_AT, object.ID, object.SERIAL_NUMBER, term.ID, term.TAXONOMY_ID, term.CODE, term.PARENT_ID, term.LFT, term.RGT, term.SOURCE_CULTURE FROM `object`, `term` WHERE term.ID=169 AND term.ID=object.ID | |
| 96 Query SELECT term_i18n.NAME, term_i18n.ID, term_i18n.CULTURE FROM `term_i18n` WHERE term_i18n.ID='169' | |
| 96 Query SELECT slug.SLUG | |
| FROM slug | |
| WHERE '169' = slug.OBJECT_ID | |
| 96 Query SELECT slug.SLUG | |
| FROM slug | |
| WHERE NULL = slug.OBJECT_ID | |
| 96 Query SELECT COUNT(*) FROM `term`, `object` WHERE term.ID=111 AND term.ID=object.ID | |
| 96 Query SELECT object.CLASS_NAME, object.CREATED_AT, object.UPDATED_AT, object.ID, object.SERIAL_NUMBER, term.ID, term.TAXONOMY_ID, term.CODE, term.PARENT_ID, term.LFT, term.RGT, term.SOURCE_CULTURE FROM `object`, `term` WHERE term.ID=111 AND term.ID=object.ID | |
| 96 Query SELECT COUNT(*) FROM `term`, `object` WHERE term.ID=118 AND term.ID=object.ID | |
| 96 Query SELECT object.CLASS_NAME, object.CREATED_AT, object.UPDATED_AT, object.ID, object.SERIAL_NUMBER, term.ID, term.TAXONOMY_ID, term.CODE, term.PARENT_ID, term.LFT, term.RGT, term.SOURCE_CULTURE FROM `object`, `term` WHERE term.ID=118 AND term.ID=object.ID | |
| 96 Query SELECT term_i18n.NAME, term_i18n.ID, term_i18n.CULTURE FROM `term_i18n` WHERE term_i18n.ID='111' | |
| 96 Query SELECT slug.SLUG | |
| FROM slug | |
| WHERE '111' = slug.OBJECT_ID | |
| 96 Query SELECT term_i18n.NAME, term_i18n.ID, term_i18n.CULTURE FROM `term_i18n` WHERE term_i18n.ID='118' | |
| 96 Query SELECT slug.SLUG | |
| FROM slug | |
| WHERE '118' = slug.OBJECT_ID | |
| 96 Query SELECT COUNT(*) FROM `term`, `object` WHERE term.ID IS NULL AND term.ID=object.ID | |
| 96 Query SELECT object.CLASS_NAME, object.CREATED_AT, object.UPDATED_AT, object.ID, object.SERIAL_NUMBER, term.ID, term.TAXONOMY_ID, term.CODE, term.PARENT_ID, term.LFT, term.RGT, term.SOURCE_CULTURE FROM `object`, `term` WHERE term.TAXONOMY_ID=63 AND term.ID=object.ID | |
| 96 Query SELECT term_i18n.NAME, term_i18n.ID, term_i18n.CULTURE FROM `term_i18n` WHERE term_i18n.ID='287' | |
| 96 Query SELECT slug.SLUG | |
| FROM slug | |
| WHERE '287' = slug.OBJECT_ID | |
| 96 Query SELECT term_i18n.NAME, term_i18n.ID, term_i18n.CULTURE FROM `term_i18n` WHERE term_i18n.ID='288' | |
| 96 Query SELECT slug.SLUG | |
| FROM slug | |
| WHERE '288' = slug.OBJECT_ID | |
| 96 Query SELECT term_i18n.NAME, term_i18n.ID, term_i18n.CULTURE FROM `term_i18n` WHERE term_i18n.ID='289' | |
| 96 Query SELECT slug.SLUG | |
| FROM slug | |
| WHERE '289' = slug.OBJECT_ID | |
| 96 Query SELECT term_i18n.NAME, term_i18n.ID, term_i18n.CULTURE FROM `term_i18n` WHERE term_i18n.ID='290' | |
| 96 Query SELECT slug.SLUG | |
| FROM slug | |
| WHERE '290' = slug.OBJECT_ID | |
| 96 Query SELECT object.CLASS_NAME, object.CREATED_AT, object.UPDATED_AT, object.ID, object.SERIAL_NUMBER, relation.ID, relation.SUBJECT_ID, relation.OBJECT_ID, relation.TYPE_ID, relation.START_DATE, relation.END_DATE, relation.SOURCE_CULTURE FROM `object`, `relation` WHERE relation.OBJECT_ID IS NULL AND relation.TYPE_ID=111 AND relation.ID=object.ID | |
| 96 Query SELECT setting.NAME, setting.SCOPE, setting.EDITABLE, setting.DELETEABLE, setting.SOURCE_CULTURE, setting.ID, setting.SERIAL_NUMBER FROM `setting` WHERE setting.NAME='accession_counter' LIMIT 1 | |
| 96 Query SELECT setting_i18n.VALUE, setting_i18n.ID, setting_i18n.CULTURE FROM `setting_i18n` WHERE setting_i18n.ID='43' | |
| 96 Query SELECT object.CLASS_NAME, object.CREATED_AT, object.UPDATED_AT, object.ID, object.SERIAL_NUMBER, relation.ID, relation.SUBJECT_ID, relation.OBJECT_ID, relation.TYPE_ID, relation.START_DATE, relation.END_DATE, relation.SOURCE_CULTURE FROM `object`, `relation` WHERE relation.OBJECT_ID IS NULL AND relation.TYPE_ID=167 AND relation.ID=object.ID | |
| 96 Query SELECT COUNT(*) FROM `term`, `object` WHERE term.ID IS NULL AND term.ID=object.ID | |
| 96 Query SELECT object.CLASS_NAME, object.CREATED_AT, object.UPDATED_AT, object.ID, object.SERIAL_NUMBER, term.ID, term.TAXONOMY_ID, term.CODE, term.PARENT_ID, term.LFT, term.RGT, term.SOURCE_CULTURE FROM `object`, `term` WHERE term.TAXONOMY_ID=62 AND term.ID=object.ID | |
| 96 Query SELECT term_i18n.NAME, term_i18n.ID, term_i18n.CULTURE FROM `term_i18n` WHERE term_i18n.ID='285' | |
| 96 Query SELECT slug.SLUG | |
| FROM slug | |
| WHERE '285' = slug.OBJECT_ID | |
| 96 Query SELECT term_i18n.NAME, term_i18n.ID, term_i18n.CULTURE FROM `term_i18n` WHERE term_i18n.ID='286' | |
| 96 Query SELECT slug.SLUG | |
| FROM slug | |
| WHERE '286' = slug.OBJECT_ID | |
| 96 Query SELECT COUNT(*) FROM `term`, `object` WHERE term.ID IS NULL AND term.ID=object.ID | |
| 96 Query SELECT object.CLASS_NAME, object.CREATED_AT, object.UPDATED_AT, object.ID, object.SERIAL_NUMBER, term.ID, term.TAXONOMY_ID, term.CODE, term.PARENT_ID, term.LFT, term.RGT, term.SOURCE_CULTURE FROM `object`, `term` WHERE term.TAXONOMY_ID=64 AND term.ID=object.ID | |
| 96 Query SELECT term_i18n.NAME, term_i18n.ID, term_i18n.CULTURE FROM `term_i18n` WHERE term_i18n.ID='291' | |
| 96 Query SELECT slug.SLUG | |
| FROM slug | |
| WHERE '291' = slug.OBJECT_ID | |
| 96 Query SELECT term_i18n.NAME, term_i18n.ID, term_i18n.CULTURE FROM `term_i18n` WHERE term_i18n.ID='292' | |
| 96 Query SELECT slug.SLUG | |
| FROM slug | |
| WHERE '292' = slug.OBJECT_ID | |
| 96 Query SELECT term_i18n.NAME, term_i18n.ID, term_i18n.CULTURE FROM `term_i18n` WHERE term_i18n.ID='293' | |
| 96 Query SELECT slug.SLUG | |
| FROM slug | |
| WHERE '293' = slug.OBJECT_ID | |
| 96 Query SELECT COUNT(*) FROM `term`, `object` WHERE term.ID IS NULL AND term.ID=object.ID | |
| 96 Query SELECT object.CLASS_NAME, object.CREATED_AT, object.UPDATED_AT, object.ID, object.SERIAL_NUMBER, term.ID, term.TAXONOMY_ID, term.CODE, term.PARENT_ID, term.LFT, term.RGT, term.SOURCE_CULTURE FROM `object`, `term` WHERE term.TAXONOMY_ID=65 AND term.ID=object.ID | |
| 96 Query SELECT term_i18n.NAME, term_i18n.ID, term_i18n.CULTURE FROM `term_i18n` WHERE term_i18n.ID='294' | |
| 96 Query SELECT slug.SLUG | |
| FROM slug | |
| WHERE '294' = slug.OBJECT_ID | |
| 96 Query SELECT term_i18n.NAME, term_i18n.ID, term_i18n.CULTURE FROM `term_i18n` WHERE term_i18n.ID='295' | |
| 96 Query SELECT slug.SLUG | |
| FROM slug | |
| WHERE '295' = slug.OBJECT_ID | |
| 96 Query SELECT term_i18n.NAME, term_i18n.ID, term_i18n.CULTURE FROM `term_i18n` WHERE term_i18n.ID='296' | |
| 96 Query SELECT slug.SLUG | |
| FROM slug | |
| WHERE '296' = slug.OBJECT_ID | |
| 96 Query SELECT object.CLASS_NAME, object.CREATED_AT, object.UPDATED_AT, object.ID, object.SERIAL_NUMBER, event.ID, event.START_DATE, event.START_TIME, event.END_DATE, event.END_TIME, event.TYPE_ID, event.OBJECT_ID, event.ACTOR_ID, event.SOURCE_CULTURE FROM `object` CROSS JOIN `event` LEFT JOIN event_i18n ON (event.ID=event_i18n.ID AND event.SOURCE_CULTURE=event_i18n.CULTURE) WHERE event.OBJECT_ID IS NULL AND ((event.END_DATE IS NOT NULL OR event.START_DATE IS NOT NULL ) OR event_i18n.DATE IS NOT NULL ) AND event.ID=object.ID ORDER BY event.START_DATE DESC | |
| 96 Query SELECT setting.NAME, setting.SCOPE, setting.EDITABLE, setting.DELETEABLE, setting.SOURCE_CULTURE, setting.ID, setting.SERIAL_NUMBER FROM `setting` WHERE setting.NAME='accession_counter' LIMIT 1 | |
| 96 Query UPDATE setting_i18n SET `VALUE`='9', `ID`='43' WHERE setting_i18n.ID='43' AND setting_i18n.CULTURE='en' | |
| 96 Query INSERT INTO object (`CLASS_NAME`,`CREATED_AT`,`UPDATED_AT`) VALUES ('QubitAccession','2016-02-29 13:46:03','2016-02-29 13:46:03') | |
| 96 Query INSERT INTO accession (`ID`,`DATE`,`IDENTIFIER`,`CREATED_AT`,`UPDATED_AT`,`SOURCE_CULTURE`) VALUES ('2001246','2016-02-29','2016-02-29/9','2016-02-29 13:46:03','2016-02-29 13:46:03','en') | |
| 96 Query INSERT INTO slug (slug.OBJECT_ID, slug.SLUG) | |
| VALUES ('2001246', '2016-02-29-9') | |
| 96 Query SELECT object.CLASS_NAME, object.CREATED_AT, object.UPDATED_AT, object.ID, object.SERIAL_NUMBER, object_term_relation.ID, object_term_relation.OBJECT_ID, object_term_relation.TERM_ID, object_term_relation.START_DATE, object_term_relation.END_DATE FROM `object`, `object_term_relation` WHERE object_term_relation.OBJECT_ID='2001246' AND object_term_relation.ID=object.ID | |
| 96 Query SELECT note.OBJECT_ID, note.TYPE_ID, note.SCOPE, note.USER_ID, note.SOURCE_CULTURE, note.ID, note.SERIAL_NUMBER FROM `note` WHERE note.OBJECT_ID='2001246' | |
| 96 Query SELECT property.OBJECT_ID, property.SCOPE, property.NAME, property.SOURCE_CULTURE, property.ID, property.SERIAL_NUMBER FROM `property` WHERE property.OBJECT_ID='2001246' | |
| 96 Query SELECT other_name.OBJECT_ID, other_name.TYPE_ID, other_name.START_DATE, other_name.END_DATE, other_name.SOURCE_CULTURE, other_name.ID, other_name.SERIAL_NUMBER FROM `other_name` WHERE other_name.OBJECT_ID='2001246' | |
| 96 Query INSERT INTO accession_i18n (`LOCATION_INFORMATION`,`SOURCE_OF_ACQUISITION`,`ID`,`CULTURE`) VALUES ('test','test','2001246','en') | |
| 96 Query SELECT object.CLASS_NAME, object.CREATED_AT, object.UPDATED_AT, object.ID, object.SERIAL_NUMBER, event.ID, event.START_DATE, event.START_TIME, event.END_DATE, event.END_TIME, event.TYPE_ID, event.OBJECT_ID, event.ACTOR_ID, event.SOURCE_CULTURE FROM `object`, `event` WHERE event.OBJECT_ID='2001246' AND event.ID=object.ID | |
| 96 Query SELECT slug.SLUG | |
| FROM slug | |
| WHERE '2001246' = slug.OBJECT_ID | |
| 96 Query SELECT setting.NAME, setting.SCOPE, setting.EDITABLE, setting.DELETEABLE, setting.SOURCE_CULTURE, setting.ID, setting.SERIAL_NUMBER FROM `setting` WHERE setting.SCOPE='i18n_languages' | |
| 96 Query SELECT setting_i18n.VALUE, setting_i18n.ID, setting_i18n.CULTURE FROM `setting_i18n` WHERE setting_i18n.ID='27' | |
| 96 Query SELECT setting_i18n.VALUE, setting_i18n.ID, setting_i18n.CULTURE FROM `setting_i18n` WHERE setting_i18n.ID='28' | |
| 96 Query SELECT setting_i18n.VALUE, setting_i18n.ID, setting_i18n.CULTURE FROM `setting_i18n` WHERE setting_i18n.ID='29' | |
| 96 Query SELECT setting_i18n.VALUE, setting_i18n.ID, setting_i18n.CULTURE FROM `setting_i18n` WHERE setting_i18n.ID='30' | |
| 96 Query SELECT setting_i18n.VALUE, setting_i18n.ID, setting_i18n.CULTURE FROM `setting_i18n` WHERE setting_i18n.ID='31' | |
| 96 Query SELECT * FROM accession_i18n WHERE id = '2001246' ORDER BY culture ASC | |
| 96 Query SELECT object.CLASS_NAME, object.CREATED_AT, object.UPDATED_AT, object.ID, object.SERIAL_NUMBER, relation.ID, relation.SUBJECT_ID, relation.OBJECT_ID, relation.TYPE_ID, relation.START_DATE, relation.END_DATE, relation.SOURCE_CULTURE FROM `object`, `relation` WHERE relation.SUBJECT_ID='2001246' AND relation.TYPE_ID=169 AND relation.ID=object.ID | |
| 96 Query SELECT object.CLASS_NAME, object.CREATED_AT, object.UPDATED_AT, object.ID, object.SERIAL_NUMBER, relation.ID, relation.SUBJECT_ID, relation.OBJECT_ID, relation.TYPE_ID, relation.START_DATE, relation.END_DATE, relation.SOURCE_CULTURE FROM `object`, `relation` WHERE relation.OBJECT_ID='2001246' AND relation.TYPE_ID=111 AND relation.ID=object.ID | |
| 96 Query commit | |
| 96 Quit |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment