/
db_create.py
170 lines (122 loc) · 4.35 KB
/
db_create.py
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
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
#-*- coding: utf-8 -*-
from logpot.auth.models import User
from logpot.entry.models import Entry, Category, Tag
from logpot.app import app
from logpot.ext import db
from logpot.admin.entry import renderMarkdown
import os
import shutil
def init_db():
db.create_all()
def drop_all(app):
db.drop_all()
upload_dir = app.config['UPLOAD_DIRECTORY']
log_dir = app.config['LOG_DIRECTORY']
basedir = os.path.abspath(os.path.dirname(__file__))
config_file = os.path.join(basedir, 'logpot', 'config.yml')
if os.path.exists(upload_dir):
shutil.rmtree(upload_dir)
if os.path.exists(log_dir):
shutil.rmtree(log_dir)
if os.path.exists(config_file):
os.remove(config_file)
def init_admin_user(name, email, password):
password = User.generate_password_hash(password)
u = User(name=name, email=email, password=password)
db.session.add(u)
db.session.commit()
db.session.remove()
def init_category():
c = Category(name='Python')
db.session.add(c)
db.session.commit()
db.session.remove()
def init_tag():
t = Tag(name='Flask')
db.session.add(t)
db.session.commit()
db.session.remove()
def init_entry():
u = User.query.get(1)
c = Category.query.get(1)
t = Tag.query.get(1)
s = 'example'
md_body = (
example_markdown()
)
body = renderMarkdown(s, md_body)
entries01 = Entry(
title=u'Example article',
summary=u'Curabitur blandit tempus porttitor. Maecenas sed diam eget risus varius blandit sit amet non magna.',
md_body=md_body,
body=body,
slug=s,
category_id=c.id,
user_id=u.id,
is_published=True)
entries01.tags.append(t)
db.session.add(entries01)
db.session.commit()
db.session.remove()
def example_markdown():
return """
# Headline
Curabitur blandit tempus porttitor. Maecenas sed diam eget risus varius blandit sit amet non magna. Donec sed odio dui. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Maecenas sed diam eget risus varius blandit sit amet non magna. Morbi leo risus, porta ac consectetur ac, vestibulum at eros.
## Headline2
Cras justo odio, dapibus ac facilisis in, egestas eget quam. Etiam porta sem malesuada magna mollis euismod. Maecenas faucibus mollis interdum. Vestibulum id ligula porta felis euismod semper.
### Headline3
Etiam porta sem malesuada magna mollis euismod. Integer posuere erat a ante venenatis dapibus posuere velit aliquet. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Praesent commodo cursus magna, vel scelerisque nisl consectetur et. Maecenas faucibus mollis interdum. Nullam quis risus eget urna mollis ornare vel eu leo.
#### Headline4
Fusce dapibus, tellus ac cursus commodo, tortor mauris condimentum nibh, ut fermentum massa justo sit amet risus. Integer posuere erat a ante venenatis dapibus posuere velit aliquet.
##### Headline5
Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Fusce dapibus, tellus ac cursus commodo, tortor mauris condimentum nibh, ut fermentum massa justo sit amet risus.
###### Headline6
Maecenas sed diam eget risus varius blandit sit amet non magna. Etiam porta sem malesuada magna mollis euismod.
### Another Elements
Leave 2 spaces at the end of a line to do a
line break.
Text attributes *italic*, **bold**,`monospace`, <del>strikethrough</del>.
Unordered list:
- Red
- Green
- Blue
Numbered list:
1. apples
1. oranges
1. pears
Definition list:
<dl>
<dt>Coffee</dt><dd>Black hot drink</dd>
<dt>Milk</dt><dd>White cold drink</dd>
</dl>
```python
def fib(n):
a, b = 0, 1
while a < n:
print(a, end=' ')
a, b = b, a+b
print()
fib(1000)
```
<!-- dummy comment line for breaking list -->
> This is a blockquote with two paragraphs. Lorem ipsum dolor sit amet,
> consectetuer adipiscing elit. Aliquam hendrerit mi posuere lectus.
> Vestibulum enim wisi, viverra nec, fringilla in, laoreet vitae, risus.
>
> Donec sit amet nisl. Aliquam semper ipsum sit amet velit. Suspendisse
> id sem consectetuer libero luctus adipiscing.
[Wikipedia](https://www.wikipedia.org/ "Link Title")
[Google][a]
[Yahoo][1]
* * *
horizontal rule
***
horizontal rule
*****
horizontal rule
- - -
horizontal rule
---------------------------------------
[a]: http://google.co.jp "Link Title"
[1]: http://www.yahoo.co.jp "Link Title"
"""