Перенос данных из custom таблицы в таблицу site_content

19 march 2018, 13:51

При переносе данных с сайта с отличным движком можно перенести контентную часть через такой простенький запрос.

INSERT INTO modx_site_content(id, type, contentType, pagetitle, longtitle, description, alias, link_attributes, published, pub_date, unpub_date, parent, isfolder, introtext, content, richtext, template, menuindex,    searchable, cacheable, createdby, createdon, editedby, editedon, deleted, deletedon, deletedby, publishedon, publishedby, menutitle, donthit, privateweb, privatemgr, content_dispo, hidemenu, class_key, context_key, content_type, uri, uri_override, hide_children_in_tree, show_in_tree, properties) SELECT '', 'document', 'text/html', pagetitle, longtitle, description, alias, '', 1, 0, 0, 8630, 0, introtext, content, 1, 4, 0, 1, 1, 1, 1521462907, 0, 0, 0,   0, 0, 1521462907, 1, '', 0, 0, 0,   0, 1, 'modDocument', 'web', 1, '', 0, 0, 1, NULL FROM s_brands;
А таким образом мы из нашей кастомной таблицы со структурой [prefix]_site_content добавляем данные непосредственно в рабочую таблицу, у меня она называется EboVURqBNd_site_content:
INSERT INTO EboVURqBNd_site_content (id, type, contentType, pagetitle, longtitle, description, alias, link_attributes, published, pub_date, unpub_date, parent, isfolder, introtext, content, richtext, template, menuindex,    searchable, cacheable, createdby, createdon, editedby, editedon, deleted, deletedon, deletedby, publishedon, publishedby, menutitle, donthit, privateweb, privatemgr, content_dispo, hidemenu, class_key, context_key, content_type, uri, uri_override, hide_children_in_tree, show_in_tree, properties) SELECT '', type, contentType, pagetitle, longtitle, description, alias, link_attributes, published, pub_date, unpub_date, parent, isfolder, introtext, content, richtext, template, menuindex, searchable, cacheable, createdby, createdon, editedby, editedon, deleted, deletedon, deletedby, publishedon, publishedby, menutitle, donthit, privateweb, privatemgr, content_dispo, hidemenu, class_key, context_key, content_type, uri, uri_override, hide_children_in_tree, show_in_tree, properties FROM modx_site_content;

MODX.ONE
2    2297    0
+3

Comments ()

    You need to login to create comments.