使用Caddy导入csv文件到cockroachdb

Download Caddy with http.upload module

download here

start caddy http file server

mkdir -p /mnt/cockroach-exports
./caddy -root /mnt/cockroach-exports "upload / {" 'to "/mnt/cockroach-exports"' 'yes_without_tls' "}"

use caddy for crdb import

import table bmsql_config create using 'http://a1:2015/bmsql_config.sql' csv data ('http://a1:2015/config.csv') with temp='http://a1:2015/tmp/';

import table bmsql_warehouse create using 'http://a1:2015/bmsql_warehouse.sql' csv data ('http://a1:2015/warehouse.csv') with temp='http://a1:2015/tmp/';

import table bmsql_district create using 'http://a1:2015/bmsql_district.sql' csv data ('http://a1:2015/district.csv') with temp='http://a1:2015/tmp/';

import table bmsql_customer create using 'http://a1:2015/bmsql_customer.sql' csv data ('http://a1:2015/customer.csv') with temp='http://a1:2015/tmp/';

import table bmsql_history create using 'http://a1:2015/bmsql_history.sql' csv data ('http://a1:2015/cust-hist.csv') with temp='http://a1:2015/tmp/';

import table bmsql_new_order create using 'http://a1:2015/bmsql_new_order.sql' csv data ('http://a1:2015/new-order.csv') with temp='http://a1:2015/tmp/';

import table bmsql_oorder create using 'http://a1:2015/bmsql_oorder.sql' csv data ('http://a1:2015/order.csv') with temp='http://a1:2015/tmp/';

import table bmsql_order_line create using 'http://a1:2015/bmsql_order_line.sql' csv data ('http://a1:2015/order-line-nonull.csv') with temp='http://a1:2015/tmp/';

import table bmsql_item create using 'http://a1:2015/bmsql_item.sql' csv data ('http://a1:2015/item.csv') with temp='http://a1:2015/tmp/';

import table bmsql_stock create using 'http://a1:2015/bmsql_stock.sql' csv data ('http://a1:2015/stock.csv') with temp='http://a1:2015/tmp/';