sql: use the options MigrationDir if the argument fs is nil

If case the file-system argument is not provided, the function will
assume that the migration script is stored in the MigrationDir which
defined in ClientOptions.

1 files changed, 7 insertions, 0 deletions

diff --git a/lib/sql/client.go b/lib/sql/client.go
index ac88cb23..3ab7ccef 100644
--- a/lib/sql/client.go
+++ b/lib/sql/client.go
@@ -102,6 +102,13 @@ func (cl *Client) FetchTableNames() (tableNames []string, err error) {
 // SQL file name that has been executed and the timestamp.
 //
 func (cl *Client) Migrate(fs http.FileSystem) (err error) {
+	if fs == nil {
+		if len(cl.MigrationDir) == 0 {
+			return nil
+		}
+		fs = http.Dir(cl.MigrationDir)
+	}
+
 	root, err := fs.Open("/")
 	if err != nil {
 		return fmt.Errorf("Migrate: %w", err)