public function inserir(Categoria $categoria)
{
//Objetivo deste metodo é inserir um objeto no banco, fazendo-o ter persistencia.
//utilizaremos a abstracao do SQL da classe TsqlInstruction
//1. Foreach dos atributos . PRa cada existencia de atributo é um valor a ser adicionado.
$instrucao = new TSqlInsert();
$instrucao->setEntity("categoria");
if ($categoria->getId() != null) {
$instrucao->setRowData("id", $categoria->getId());
}
if ($categoria->getNome() != null) {
$instrucao->setRowData("nome", $categoria->getNome());
}
if ($categoria->getDescricao() != null) {
$instrucao->setRowData("descricao", $categoria->getDescricao());
}
echo $instrucao->getInstruction();
if ($this->Conexao->query($instrucao->getInstruction())) {
return true;
} else {
return false;
}
}
/**
* Declares an association between this object and a Categoria object.
*
* @param Categoria $v
* @return Pelicula The current object (for fluent API support)
* @throws PropelException
*/
public function setCategoria(Categoria $v = null)
{
if ($v === null) {
$this->setCategoriaId(NULL);
} else {
$this->setCategoriaId($v->getId());
}
$this->aCategoria = $v;
// Add binding for other direction of this n:n relationship.
// If this object has already been added to the Categoria object, it will not be re-added.
if ($v !== null) {
$v->addPelicula($this);
}
return $this;
}
/**
* Exclude object from result
*
* @param Categoria $categoria Object to remove from the list of results
*
* @return CategoriaQuery The current query, for fluid interface
*/
public function prune($categoria = null)
{
if ($categoria) {
$this->addUsingAlias(CategoriaPeer::ID, $categoria->getId(), Criteria::NOT_EQUAL);
}
return $this;
}
/**
* Filter the query by a related Categoria object
*
* @param Categoria|PropelCollection $categoria The related object(s) to use as filter
* @param string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL
*
* @return PeliculaQuery The current query, for fluid interface
*/
public function filterByCategoria($categoria, $comparison = null)
{
if ($categoria instanceof Categoria) {
return $this->addUsingAlias(PeliculaPeer::CATEGORIA_ID, $categoria->getId(), $comparison);
} elseif ($categoria instanceof PropelCollection) {
if (null === $comparison) {
$comparison = Criteria::IN;
}
return $this->addUsingAlias(PeliculaPeer::CATEGORIA_ID, $categoria->toKeyValue('PrimaryKey', 'Id'), $comparison);
} else {
throw new PropelException('filterByCategoria() only accepts arguments of type Categoria or PropelCollection');
}
}