[ Index ]
 

Code source de Symfony 1.0.0

Accédez au Source d'autres logiciels libresSoutenez Angelica Josefina !

title

Body

[fermer]

/lib/vendor/propel-generator/classes/propel/phing/ -> PropelSQLExec.php (sommaire)

(pas de description)

Poids: 682 lignes (21 kb)
Inclus ou requis:0 fois
Référencé: 0 fois
Nécessite: 0 fichiers

Définit 2 classes

PropelSQLExec:: (21 méthodes):
  setSqlDbMap()
  getSqlDbMap()
  setSrcDir()
  getSrcDir()
  addText()
  setDriver()
  setUrl()
  setUserid()
  setPassword()
  setAutoCommit()
  setDelimiter()
  setDelimiterType()
  setPrint()
  setShowheaders()
  setOutput()
  setOnerror()
  main()
  insertDatabaseSqlFiles()
  runStatements()
  execSQL()
  printResults()

PropelSQLExecTransaction:: (4 méthodes):
  __construct()
  setSrc()
  addText()
  runTransaction()


Classe: PropelSQLExec  - X-Ref

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.

setSqlDbMap($sqldbmap)   X-Ref
Set the sqldbmap properties file.

param: sqldbmap filename for the sqldbmap

getSqlDbMap()   X-Ref
Get the sqldbmap properties file.

return: filename for the sqldbmap

setSrcDir(PhingFile $srcDir)   X-Ref
Set the src directory for the sql files listed in the sqldbmap file.

param: PhingFile $srcDir sql source directory

getSrcDir()   X-Ref
Get the src directory for the sql files listed in the sqldbmap file.

return: PhingFile SQL Source directory

addText($sql)   X-Ref
Set the sql command to execute

param: sql sql command to execute

setDriver($driver)   X-Ref
Set the Creole driver to be used.

param: string $driver driver class name

setUrl($url)   X-Ref
Set the DB connection url.

param: string $url connection url

setUserid($userId)   X-Ref
Set the user name for the DB connection.

param: string $userId database user

setPassword($password)   X-Ref
Set the password for the DB connection.

param: string $password database password

setAutoCommit($autocommit)   X-Ref
Set the autocommit flag for the DB connection.

param: boolean $autocommit the autocommit flag

setDelimiter($delimiter)   X-Ref
Set the statement delimiter.

<p>For example, set this to "go" and delimitertype to "ROW" for
Sybase ASE or MS SQL Server.</p>

param: string $delimiter

setDelimiterType($delimiterType)   X-Ref
Set the Delimiter type for this sql task. The delimiter type takes two
values - normal and row. Normal means that any occurence of the delimiter
terminate the SQL command whereas with row, only a line containing just
the delimiter is recognized as the end of the command.

param: string $delimiterType

setPrint($print)   X-Ref
Set the print flag.

param: boolean $print

setShowheaders($showheaders)   X-Ref
Set the showheaders flag.

param: boolean $showheaders

setOutput(PhingFile $output)   X-Ref
Set the output file.

param: PhingFile $output

setOnerror($action)   X-Ref
Set the action to perform onerror

param: string $action

main()   X-Ref
Load the sql file and then execute it


insertDatabaseSqlFiles($url, $database, $transactions)   X-Ref
Take the base url, the target database and insert a set of SQL
files into the target database.

param: string $url
param: string $database
param: array $transactions

runStatements(Reader $reader, $out = null)   X-Ref
Read the statements from the .sql file and execute them.
Lines starting with '//', '--' or 'REM ' are ignored.

Developer note:  must be public in order to be called from
sudo-"inner" class PropelSQLExecTransaction.

param: Reader $reader
param: $out Optional output stream.

execSQL($sql, $out = null)   X-Ref
Exec the sql statement.

param: sql
param: out

printResults($out = null)   X-Ref
print any results in the statement.

param: out

Classe: PropelSQLExecTransaction  - X-Ref

"Inner" class that contains the definition of a new transaction element.
Transactions allow several files or blocks of statements
to be executed using the same Creole connection and commit
operation in between.

__construct($parent)   X-Ref
Pas de description

setSrc(PhingFile $src)   X-Ref
Pas de description

addText($sql)   X-Ref
Pas de description

runTransaction($out = null)   X-Ref




Généré le : Fri Mar 16 22:42:14 2007 par Balluche grâce à PHPXref 0.7