django上传数据(3)
六、Model.objects.bulk_create() 更快更方便12345678910111213141516171819#!/usr/bin/env pythonimport osos.environ.setdefault("DJANGO_SETTINGS_MODULE", "mys
·
六、Model.objects.bulk_create() 更快更方便
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
|
#!/usr/bin/env
import
os
os.environ.setdefault(
"DJANGO_SETTINGS_MODULE"
,
"mysite.settings"
)
def
from
import
Blog
f
open
(
'oldblog.txt'
)
BlogList
for
line
in
f:
title,content
split
(
'****'
)
blog
BlogList.append(blog)
f.close()
Blog.objects.bulk_create(BlogList)
if
__name__
"__main__"
:
main()
print(
'Done!'
)
|
由于Blog.objects.create()每保存一条就执行一次SQL,而bulk_create()是执行一条SQL存入多条数据,做会快很多!当然用列表解析代替 for 循环会更快!!
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
|
#!/usr/bin/env
import
os
os.environ.setdefault(
"DJANGO_SETTINGS_MODULE"
,
"mysite.settings"
)
def
from
import
Blog
f
open
(
'oldblog.txt'
)
BlogList
for
line
in
f:
parts
split
(
'****'
)
BlogList.append(Blog(title=parts[0],
f.close()
#
#
Blog.objects.bulk_create(BlogList)
if
__name__
"__main__"
:
main()
print(
'Done!'
)
|
更多推荐
已为社区贡献3条内容
所有评论(0)