由于项目需要,在Shell中操作sqlite数据库,简单记录下:
services_networkkpi 表结构之前已经建立好,所以,直接使用Step1: 拼接插入sql字符串
table_sql="insert into services_networkkpi(name, category_id, web_open_time, dns_resolve_time, dns_cache_rate,tcp_time,
document_loading_time,document_num,page_loading_time,
document_size,css_each_file_total_time,css_total_time,
css_num,css_size,primary_file_loading_time,
main_resouce_loading_time,js_total_time,js_num,js_size,
img_total_time,img_num,img_size)"
value_sql="values(\"$name\", $category_id, $web_open_time, $dns_resolve_time, \"$dns_cache_rate\",$tcp_time,
$document_loading_time,$document_num,$page_loading_time,
\"$document_size\",$css_each_file_total_time,$css_total_time,
$css_num,\"$css_size\",$primary_file_loading_time,
$main_resouce_loading_time,$js_total_time,$js_num,\"$js_size\",
$img_total_time,$img_num,\"$img_size\");"
sql=`echo "$table_sql $value_sql"`
echo $sql
Step2: 指定操作数据的路径
dbpath="my.db3"
export sqlitedb="sqlite3 $dbpath"
$sqlitedb <<EOF
$sql
.quit
EOF