Database.Persist.Migration.Utils.Sql

Defines helper functions for writing SQL queries.

Documentation

commas :: Text -> [Text]

Split the given line by commas, ignoring commas within parentheses.

commas "a,b,c" == ["a", "b", "c"]
commas "a,b,c (d,e),z" == ["a", "b", "c (d,e)", "z"]
commas "a,b,c (d,e,(f,g)),z" == ["a", "b", "c (d,e,(f,g))", "z"]

uncommas :: [Text] -> Text

Join the given Text with commas separating each item.

quote :: Text -> Text

Quote the given Text.

interpolate :: Text -> [PersistValue] -> Text

Interpolate the given values into the SQL string.