blob: 93ee985f5e3238a4dfd9b75301d04f8812144462 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
|
* Tweet list
* skin footer
* language selector
* sidebars in posts and pages
* import images to /image/ dir
https://alexwlchan.net/2019/11/saving-a-copy-of-a-tweet-by-typing-twurl/
page_translations:
id | page_id | locale | title | abstract | body | created_at | updated_at
pages:
id | node_id | revision | created_at | updated_at | published_at | user_id | template_name | editor_id
nodes:
id | slug | unique_name | created_at | updated_at | lft | rgt | parent_id | head_id | draft_id | locking_user_id | staged_slug | staged_parent_id
users = select * from users
tags = select * from tags
taggings = select * from taggings
nodes = select * from nodes
for node in nodes:
pages = select * from pages where node_id = node.id
for page in pages:
tag_ids = select tag_id from taggings where taggable_id = page.id
tags = select name from tags where id in tag_ids
translations = select * from page_translations where page_id = page.id
|
