96 releases
0.4.18 | Jan 13, 2023 |
---|---|
0.4.17 | Dec 20, 2022 |
0.4.16 | Nov 10, 2022 |
0.4.12 | Jul 2, 2022 |
0.3.4 | Nov 21, 2020 |
#169 in Database interfaces
329 downloads per month
520KB
7.5K
SLoC
ODBCSV
Query an ODBC data source and output the result as CSV or to insert from CSV into an ODBC data source.
Installation
Several installation options are available.
Download prebuilt binaries
You can download the latest binaries here from the odbc-api
GitHub release: https://github.com/pacman82/odbc-api/releases/latest.
Install using cargo
cargo install odbcsv
Usage
Querying an Microsoft SQL Database and storing the result in a file
odbcsv query \
--output query.csv \
--connection-string "Driver={ODBC Driver 17 for SQL Server};Server=localhost;UID=SA;PWD=My@Test@Password1;" \
"SELECT title, year from Movies"
Specify user and password independently
odbcsv query \
--output query.csv \
--connection-string "Driver={ODBC Driver 17 for SQL Server};Server=localhost;" \
--user "SA" \
--password "My@Test@Password1" \
"SELECT title, year from Movies"
Alternatively you may also specify the ODBC_USER
and ODBC_PASSWORD
environment variable.
Query using data source name
odbcsv query \
--output query.csv \
--dsn my_db \
--password "My@Test@Password1" \
--user "SA" \
"SELECT * FROM Birthdays"
Use parameters in query
odbcsv query \
--output query.csv \
--connection-string "Driver={ODBC Driver 17 for SQL Server};Server=localhost;UID=SA;PWD=My@Test@Password1;" \
"SELECT * FROM Birthdays WHERE year > ? and year < ?" \
1990 2010
Insert data from CSV to database
odbcsv insert \
--input birthdays.csv \
--connection-string "Driver={ODBC Driver 17 for SQL Server};Server=localhost;UID=SA;PWD=My@Test@Password1;" \
Birthdays \
Use --help
to see all options.
Dependencies
~4–12MB
~197K SLoC