AWS RDS 跨区域同步
CALL mysql.rds_set_external_master (‘mymasterserver.mydomain.com’, 3306, ‘repl_user’, ‘<password>’, ‘mysql-bin-changelog.000031′, 107, 0);
CALL mysql.rds_start_replication;
redis key 迁移
当slave, migrate 等方法不能用时，直接用dump/restore
redis-cli -h cn-vpc-redis-session.aftjvu.0001.cnn1.cache.amazonaws.com.cn -n 1 keys “*” | while read key ;do redis-cli -h cn-vpc-redis-session.aftjvu.0001.cnn1.cache.amazonaws.com.cn -n 1 –raw dump $key | head -c-1 | redis-cli -n 0 -x restore $key 0 ;done
json 序列化
Json反序列化如下：
|
1
2
3
4
5
6
7
8
9
10
11
12
13
|
#coding: utf-8import jsondict = {'name':'zhangsan', 'age':33, 'address':'红星路'}print('未序列化前的数据类型为:', type(dict))print('为序列化前的数据：', dict)#对dict进行序列化的处理dict_xu = json.dumps(dict,ensure_ascii=False) #添加ensure_ascii=False进行序列化print('序列化后的数据类型为：', type(dict_xu))print('序列化后的数据为：', dict_xu)#对dict_xu进行反序列化处理dict_fan = json.loads(dict_xu)print('反序列化后的数据类型为：', type(dict_fan))print('反序列化后的数据为: ', dict_fan) |
RAP2-delos 添加API参数500错误
原因是
数据库表Properties中的字段priority， 其属性为int(11)
但传入的数据为：1524666729233 (这个值应该是时间戳)
可以将priority的属性调整一下，比如 bigint(50)
GITLAB /var/opt/gitlab/.ssh/authorized_keys 未更新
用户添加public key 后，/var/opt/gitlab/.ssh/authorized_keys 未更新， 重启sidekiq即可！
$ sudo gitlab-ctl kill sidekiq
$ sudo gitlab-ctl start sidekiq
GITLAB 修改DNS
修改文件 “/var/opt/gitlab/gitlab-rails/etc/gitlab.yml”
修改成如下的样子就好了哦。
## GitLab settings
gitlab:
## Web server settings (note: host is the FQDN, do not include http://)
host: gitlab.ops.ac.cn
port: 80
https: false- 1
- 2
- 3
- 4
- 5
- 6
mongoengine 更新
mongoengine 更新
collection.update({‘userid’:int(float(item))},{‘$set’:{‘status’:1}},upsert=False,multi=True)
有兴趣可以研究一下update的四个参数:
第一个为匹配，
第二个为条件（条件上可以大作文章），
第三个为没找到是否插入，
第四个为是否支持多操作
python dict 合并
a = [{"id":"1","name":"test001"},{"id":"2","name":"test002"}]
b = [{"id":"1","score":"9"},{"id":"2","score":"8"}]
list(map(lambda x,y:dict(x,**y),a,b))
django view太大，切分到不同的目录
（新增目录下面一定得有__init__.py, 方法1，需要修改__init__.py, 方法2可以将__init__.py 保持为空）
备注：view 子目录引用model， 可用 from app_name.models import * 方式引用， 记得加上 app_name
方法1：
Remove the views.py file and create a directory named views. Add a __init__.py file inside it and create the separated view files.
|∙∙core/
|∙∙__init__.py
|∙∙admin.py
|∙∙migrations/
|∙∙models.py
|∙∙tests.py
|∙∙urls.py
|∙∙views/
|∙∙__init__.py
|∙∙alpha.py
|∙∙beta.pyviews/__init__.py
This is an important step: import all the modules inside each view file.
from .alpha import *
from .beta import *views/alpha.py
from django.shortcuts import render
def view_a(request):
return render(request, 'view_a.html')
def view_b(request):
return render(request, 'view_b.html')views/beta.py
from django.shortcuts import render
def view_c(request):
return render(request, 'view_c.html')
def view_d(request):
return render(request, 'view_d.html')urls.py
You don’t need to change anything here.
from django.conf.urls import url
import .views
urlpatterns = [
url(r'^aaa$', views.view_a, name='view_a'),
url(r'^bbb$', views.view_b, name='view_b'),
url(r'^ccc$', views.view_c, name='view_c'),
url(r'^ddd$', views.view_d, name='view_d'),
]方法2：
Remove the views.py file and create a directory named views. Add a __init__.py file inside it and create the separated view files.
|∙∙core/
|∙∙__init__.py
|∙∙admin.py
|∙∙migrations/
|∙∙models.py
|∙∙tests.py
|∙∙urls.py
|∙∙views/
|∙∙__init__.py
|∙∙alpha.py
|∙∙beta.pyviews/alpha.py
from django.shortcuts import render
def view_a(request):
return render(request, 'view_a.html')
def view_b(request):
return render(request, 'view_b.html')views/beta.py
from django.shortcuts import render
def view_c(request):
return render(request, 'view_c.html')
def view_d(request):
return render(request, 'view_d.html')urls.py
You don’t need to change anything here.
from django.conf.urls import url
import .views
urlpatterns = [
url(r'^aaa$', views.view_a, name='view_a'),
url(r'^bbb$', views.view_b, name='view_b'),
url(r'^ccc$', views.view_c, name='view_c'),
url(r'^ddd$', views.view_d, name='view_d'),
]