CODEWITHSUNDEEP
scala
James
James

Reputation: 59

How to input parameters when running bash command with Scala

Could someone give me an advice how to run command as below in scala ?

Process("/usr/bin/mysql -u username -h mydb.host.rds.amazonaws.com -D dbname -p < /data/import.sql").!

So far I can't find a workable way to run. Thanks.

Upvotes: 1

Views: 133

Answers (2)

Carl
Carl

Reputation: 866

import scala.language.postfixOps
import java.io.File
import scala.sys.process._

Seq("/usr/bin/mysql", "-u", "username", "-h", "mydb.host.rds.amazonaws.com", "-D", "dbname", "-p") #< new File ("/data/import.sql") !

Upvotes: 1

Bob Dalgleish
Bob Dalgleish

Reputation: 8227

Use ProcessBuilder to run your command.

val p = ProcessBuilder("/usr/bin/mysql", "-u", "username", "-h", "mydb.host.rds.amazonaws.com", "-D", "dbname", "-p")
p.setRedirectInput(File("/data/import.sql")
p.start()

Upvotes: 1

Related Questions