execute sqlite commands within dockerfile

Question

This dockerfile is working correctly. But how do I execute commands within dockerfile?

FROM alpine 
RUN apk add --update sqlite && rm -rf /var/cache/apk/*
RUN apk add --update wget && rm -rf /var/cache/apk/*
RUN wget --no-check-certificate https://cdn.rawgit.com/times/data/master/sunday_times_panama_data.zip
RUN unzip sunday_times_panama_data.zip

But the next part needs to be executed at sqlite prompt. How do I declare this part?

# sqlite commands:
sqlite3 sundayTimesPanamaPapers.sqlite
.mode csv
CREATE TABLE panama(company_url TEXT,company_name TEXT,officer_position_es TEXT,officer_position_en TEXT,officer_name TEXT,inc_date TEXT,dissolved_date TEXT,updated_date TEXT,company_type TEXT,mf_link TEXT);
.import sunday_times_panama_data.csv panama

nodesource.com/blog/dockerizing-your-nodejs-applications

Anisha Salunkhe
– Anisha Salunkhe

2016-04-25 06:22:11 +00:00
Commented Apr 25, 2016 at 6:22 — Anisha Salunkhe
– Anisha Salunkhe, Commented Apr 25, 2016 at 6:22

shantanuo · Accepted Answer · 2016-07-04 07:14:13Z

1

I can save the commands to a file and then execute the file in a dockerfile like this...

ADD sqlite_commands.sql /
RUN sqlite3 panama.sqlite < /sqlite_commands.sql

answered Jul 4, 2016 at 7:14

shantanuo

32.6k91 gold badges268 silver badges437 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Alexander Batischev · Accepted Answer · 2016-04-28 08:13:41Z

0

Just feed it the commands using a pipe:

RUN echo '.mode csv\nCREATE TABLE panama(company_url TEXT,company_name TEXT,officer_position_es TEXT,officer_position_en TEXT,officer_name TEXT,inc_date TEXT,dissolved_date TEXT,updated_date TEXT,company_type TEXT,mf_link TEXT);\n.import sunday_times_panama_data.csv panama' | sqlite3 sundayTimesPanamaPapers.sqlite

answered Apr 28, 2016 at 8:13

Alexander Batischev

8308 silver badges18 bronze badges

Collectives™ on Stack Overflow

execute sqlite commands within dockerfile

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related