潇湘文轩等到风景都看透，陪我看细水长流MenuSkip to contentHome关于留言本SublimePythonIDE 编码规范提示问题Leave a reply一行列数 : PEP 8 规定为 79 列，这个太苛刻了，如果要拼接url一般都会超。一个函数 : 不要超过 30 行代码, 即可显示在一个屏幕类，可以不使用垂直游标即可看到整个函数。一个类 : 不要超过 200 行代码，不要有超过 10 个方法。一个模块 : 不要超过 500 行。不推荐imp[......]This entry was posted in 个人日志 and tagged python on 2014年04月2日 by 潇湘.selenium + python自动化测试环境搭建Leave a replyThis entry was posted in 个人日志 and tagged python, selenium on 2014年03月17日 by 潇湘.Python openpyxl列宽自适应Leave a replycolumn_widths = []for row in data:for i, cell in enumerate(row):if len(column_widths) > i:if len(cell) > column_widths[i]:column_widths[i] = len(cell)else:column_widths += [len(cell)]for i, column_width in enumerate(column_widths):worksheet.column_dimensions[get_column_letter(i+1)].width = column_width1234567891011column_widths = [] for row in data: for i, cell in enumerate(row): if len(column_widths) > i: if len(cell) > column_widths[i]: column_widths[i] = len(cell) else: column_widths += [len(cell)] for i, column_width in enumerate(column_widths): worksheet.column_dimensions[get_column_letter(i+1)].width = column_widthThis entry was posted in 个人日志 on 2014年03月15日 by 潇湘.解决上传服务器的sqlite数据库文件打开出现错误Error: database disk image is malformedLeave a replyThis entry was posted in 个人日志 and tagged SQLite on 2014年03月15日 by 潇湘.测试PHP空间是否支持SQLITE3Leave a reply测试代码sqlite_support.phpPHP<?php
if (extension_loaded('sqlite')) {
echo 'Support';
}else{
echo 'Not Support';
}
?>
1234567
<?php if (extension_loaded('sqlite')) { echo 'Support'; }else{ echo 'Not Support'; } ?>
PHP
<?php
$db = new SQLite3('mysqlitedb.db');
$results = $db->query('SELECT bar FROM foo');
while ($row = $results->fetchArray()) {
var_dump($row);
}
?>
12345678
<?php $db = new SQLite3('mysqlitedb.db'); $results = $db->query('SELECT bar FROM foo'); while ($row = $results->fetchArray()) { var_dump($row); } ?>
Shell
php -i | grep -i sqlite3
1
php -i | grep -i sqlite3
Shell
sqlite3
SQLite3 support => enabled
SQLite3 module version => 0.7-dev
sqlite3.extension_dir => no value => no value
1234
sqlite3 SQLite3 support => enabled SQLite3 module version => 0.7-dev sqlite3.extension_dir => no value => no value
This entry was posted in 个人日志 and tagged SQLite, SQLite3 on 2014年03月14日 by 潇湘.
windows7 64位 XAMPP python3.3.2 django web环境搭配
Leave a reply
从http://code.google.com/p/modwsgi/wiki/DownloadTheSoftware?tm=2 了解[......]
This entry was posted in 个人日志 on 2014年03月13日 by 潇湘.
windows7下安装python3.3的setuptools工具
Leave a reply
copying setuptools.egg-info\top_level.txt -> build\bdist.win-amd64\egg\EGG-INFO
copying setuptools.egg-info\zip-safe -> build\bdist.win-amd64\egg\EGG-INFO
creating dist
creating 'dist\setuptools-3.1-py3.3.egg' and adding 'build\bdi