From 657cb1b7f6be1610d6888acf18bb77027108ea9e Mon Sep 17 00:00:00 2001 From: Matthew Heon Date: Thu, 9 Nov 2017 15:03:57 -0500 Subject: Fix lingering SQL error Signed-off-by: Matthew Heon --- libpod/sql_state.go | 16 ++++++++-------- libpod/sql_state_internal.go | 6 +++--- 2 files changed, 11 insertions(+), 11 deletions(-) (limited to 'libpod') diff --git a/libpod/sql_state.go b/libpod/sql_state.go index 4754bf71e..424eb81fb 100644 --- a/libpod/sql_state.go +++ b/libpod/sql_state.go @@ -104,10 +104,10 @@ func (s *SQLState) Container(id string) (*Container, error) { containerState.StartedTime, containerState.FinishedTime, containerState.ExitCode - FROM containers - INNER JOIN - containerState ON containers.Id = containerState.Id - WHERE containers.Id=?;` + FROM containers + INNER JOIN + containerState ON containers.Id = containerState.Id + WHERE containers.Id=?;` if !s.valid { return nil, ErrDBClosed @@ -133,10 +133,10 @@ func (s *SQLState) LookupContainer(idOrName string) (*Container, error) { containerState.StartedTime, containerState.FinishedTime, containerState.ExitCode - FROM containers - INNER JOIN - containerState ON containers.Id = containerState.Id - WHERE (containers.Id LIKE ?) OR containers.Name=?;` + FROM containers + INNER JOIN + containerState ON containers.Id = containerState.Id + WHERE (containers.Id LIKE ?) OR containers.Name=?;` if !s.valid { return nil, ErrDBClosed diff --git a/libpod/sql_state_internal.go b/libpod/sql_state_internal.go index 3f5f695bb..da7c708e7 100644 --- a/libpod/sql_state_internal.go +++ b/libpod/sql_state_internal.go @@ -32,7 +32,7 @@ func prepareDB(db *sql.DB) (err error) { // Create a table for unchanging container data const createCtr = ` - CREATE TABLE IF NOT EXIST containers( + CREATE TABLE IF NOT EXISTS containers( Id TEXT NOT NULL PRIMARY KEY, Name TEXT NOT NULL UNIQUE, MountLabel TEXT NOT NULL, @@ -40,7 +40,7 @@ func prepareDB(db *sql.DB) (err error) { Stdin INTEGER NOT NULL, LabelsJSON TEXT NOT NULL, StopSignal INTEGER NOT NULL, - CreatedTime TEXT NOT NULL + CreatedTime TEXT NOT NULL, RootfsImageID TEXT NOT NULL, RootfsImageName TEXT NOT NULL, UseImageConfig INTEGER NOT NULL, @@ -52,7 +52,7 @@ func prepareDB(db *sql.DB) (err error) { // Create a table for changing container state const createCtrState = ` - CREATE TABLE IF NOT EXIST containerState( + CREATE TABLE IF NOT EXISTS containerState( Id TEXT NOT NULL PRIMARY KEY, State INTEGER NOT NULL, ConfigPath TEXT NOT NULL, -- cgit v1.2.3-54-g00ecf