class PropelSQLExec extends AbstractPropelTask
Executes all SQL files referenced in the sqldbmap file against their mapped databases.
This task uses an SQL -> Database map in the form of a properties file to insert each SQL file listed into its designated database.
Methods
setSqlDbMap($sqldbmap $sqldbmap)
Set the sqldbmap properties file. |
||
filename |
getSqlDbMap()
Get the sqldbmap properties file. |
|
setBuildConnections(array $buildConnections)
Set the buildtime connection settings. |
||
array |
getBuildConnections()
Get the buildtime connection settings. |
|
array |
getBuildConnection(string $database)
Get the buildtime connection settings for a given database name. |
|
setSrcDir(PhingFile $srcDir)
Set the src directory for the sql files listed in the sqldbmap file. |
||
PhingFile |
getSrcDir()
Get the src directory for the sql files listed in the sqldbmap file. |
|
setUrl(string $url)
Set the DB connection url. |
||
setUserid(string $userId)
Set the user name for the DB connection. |
||
setPassword(string $password)
Set the password for the DB connection. |
||
setAutoCommit(boolean $autocommit)
Set the autocommit flag for the DB connection. |
||
setOnerror(string $action)
Set the action to perform onerror |
||
main()
Load the sql file and then execute it |
Details
at line 74
public
setSqlDbMap($sqldbmap $sqldbmap)
Set the sqldbmap properties file.
at line 84
public filename
getSqlDbMap()
Get the sqldbmap properties file.
at line 94
public
setBuildConnections(array $buildConnections)
Set the buildtime connection settings.
at line 104
public array
getBuildConnections()
Get the buildtime connection settings.
at line 116
public array
getBuildConnection(string $database)
Get the buildtime connection settings for a given database name.
at line 135
public
setSrcDir(PhingFile $srcDir)
Set the src directory for the sql files listed in the sqldbmap file.
at line 145
public PhingFile
getSrcDir()
Get the src directory for the sql files listed in the sqldbmap file.
at line 155
public
setUrl(string $url)
Set the DB connection url.
at line 167
public
setUserid(string $userId)
Set the user name for the DB connection.
at line 179
public
setPassword(string $password)
Set the password for the DB connection.
at line 189
public
setAutoCommit(boolean $autocommit)
Set the autocommit flag for the DB connection.
at line 199
public
setOnerror(string $action)
Set the action to perform onerror
at line 209
public
main()
Load the sql file and then execute it