Skip to content

Instantly share code, notes, and snippets.

@rkeplin
Last active August 29, 2015 14:19
Show Gist options
  • Select an option

  • Save rkeplin/14d7c86a653f5ce3f7fe to your computer and use it in GitHub Desktop.

Select an option

Save rkeplin/14d7c86a653f5ce3f7fe to your computer and use it in GitHub Desktop.
Phalcon 2.0 Bug?
<?php
use Phalcon\Mvc\Model;
/**
* Address
*/
class Address extends Model
{
/**
* @var integer
*/
protected $id;
/**
* @var string
*/
protected $streetAddress;
/**
* @var string
*/
protected $streetAddress2;
/**
* @var string
*/
protected $poBox;
/**
* @var string
*/
protected $city;
/**
* @var string
*/
protected $state;
/**
* @var integer
*/
protected $zip;
/**
* @var integer
*/
protected $zipPlus4;
/**
* @return int
*/
public function getId()
{
return (int) $this->id;
}
/**
* @param int $id
*/
public function setId($id)
{
$this->id = $id;
}
/**
* @return string
*/
public function getStreetAddress()
{
return (string) $this->streetAddress;
}
/**
* @param string $streetAddress
*/
public function setStreetAddress($streetAddress)
{
$this->streetAddress = $streetAddress;
}
/**
* @return string
*/
public function getStreetAddress2()
{
return (string) $this->streetAddress2;
}
/**
* @param string $streetAddress2
*/
public function setStreetAddress2($streetAddress2)
{
$this->streetAddress2 = $streetAddress2;
}
/**
* @return string
*/
public function getPoBox()
{
return (string) $this->poBox;
}
/**
* @param string $poBox
*/
public function setPoBox($poBox)
{
$this->poBox = $poBox;
}
/**
* @return string
*/
public function getCity()
{
return (string) $this->city;
}
/**
* @param string $city
*/
public function setCity($city)
{
$this->city = $city;
}
/**
* @return string
*/
public function getState()
{
return (string) $this->state;
}
/**
* @param string $state
*/
public function setState($state)
{
$this->state = $state;
}
/**
* @return int
*/
public function getZip()
{
return str_pad((int) $this->zip, 5, '0', STR_PAD_LEFT);
}
/**
* @param int $zip
*/
public function setZip($zip)
{
$this->zip = str_pad((int) $zip, 5, '0', STR_PAD_LEFT);
}
/**
* @return int
*/
public function getZipPlus4()
{
return str_pad((int) $this->zipPlus4, 4, '0', STR_PAD_LEFT);
}
/**
* @param int $zipPlus4
*/
public function setZipPlus4($zipPlus4)
{
$this->zipPlus4 = str_pad((int) $zipPlus4, 4, '0', STR_PAD_LEFT);
}
/**
* Get the source table
*
* @return string
*/
public function getSource()
{
return 'addresses';
}
/**
* Independent Column Mapping.
*
* @return array
*/
public function columnMap()
{
return array(
'id' => 'id',
'streetAddress' => 'streetAddress',
'streetAddress2' => 'streetAddress2',
'poBox' => 'poBox',
'city' => 'city',
'state' => 'state',
'zip' => 'zip',
'zipPlus4' => 'zipPlus4'
);
}
}
[root@localhost build]# ./install
find . -name \*.gcno -o -name \*.gcda | xargs rm -f
find . -name \*.lo -o -name \*.o | xargs rm -f
find . -name \*.la -o -name \*.a | xargs rm -f
find . -name \*.so | xargs rm -f
find . -name .libs -a -type d|xargs rm -rf
rm -f libphp.la modules/* libs/*
Cleaning..
Configuring for:
PHP Api Version: 20100412
Zend Module Api No: 20100525
Zend Extension Api No: 220100525
checking for grep that handles long lines and -e... /usr/bin/grep
checking for egrep... /usr/bin/grep -E
checking for a sed that does not truncate output... /usr/bin/sed
checking whether the C compiler works... yes
checking for C compiler default output file name... a.out
checking for suffix of executables...
checking whether we are cross compiling... no
checking for suffix of object files... o
checking whether we are using the GNU C compiler... yes
checking whether gcc accepts -g... yes
checking for gcc option to accept ISO C89... none needed
checking how to run the C preprocessor... gcc -E
checking for icc... no
checking for suncc... no
checking whether gcc and cc understand -c and -o together... yes
checking for system library directory... lib
checking if compiler supports -R... no
checking if compiler supports -Wl,-rpath,... yes
checking build system type... x86_64-unknown-linux-gnu
checking host system type... x86_64-unknown-linux-gnu
checking target system type... x86_64-unknown-linux-gnu
checking for PHP prefix... /usr
checking for PHP includes... -I/usr/include/php -I/usr/include/php/main -I/usr/include/php/TSRM -I/usr/include/php/Zend -I/usr/include/php/ext -I/usr/include/php/ext/date/lib
checking for PHP extension directory... /usr/lib64/php/modules
checking for PHP installed headers prefix... /usr/include/php
checking if debug is enabled... no
checking if zts is enabled... no
checking for re2c... no
configure: WARNING: You will need re2c 0.13.4 or later if you want to regenerate PHP parsers.
checking for gawk... gawk
checking whether to enable phalcon... yes, shared
checking whether HAVE_BUNDLED_PCRE is declared... no
checking whether HAVE_JSON is declared... yes
checking for ext/json/php_json.h... yes
checking how to print strings... printf
checking for a sed that does not truncate output... (cached) /usr/bin/sed
checking for fgrep... /usr/bin/grep -F
checking for ld used by gcc... /usr/bin/ld
checking if the linker (/usr/bin/ld) is GNU ld... yes
checking for BSD- or MS-compatible name lister (nm)... /usr/bin/nm -B
checking the name lister (/usr/bin/nm -B) interface... BSD nm
checking whether ln -s works... yes
checking the maximum length of command line arguments... 1572864
checking whether the shell understands some XSI constructs... yes
checking whether the shell understands "+="... yes
checking how to convert x86_64-unknown-linux-gnu file names to x86_64-unknown-linux-gnu format... func_convert_file_noop
checking how to convert x86_64-unknown-linux-gnu file names to toolchain format... func_convert_file_noop
checking for /usr/bin/ld option to reload object files... -r
checking for objdump... objdump
checking how to recognize dependent libraries... pass_all
checking for dlltool... no
checking how to associate runtime and link libraries... printf %s\n
checking for ar... ar
checking for archiver @FILE support... @
checking for strip... strip
checking for ranlib... ranlib
checking for gawk... (cached) gawk
checking command to parse /usr/bin/nm -B output from gcc object... ok
checking for sysroot... no
checking for mt... no
checking if : is a manifest tool... no
checking for ANSI C header files... yes
checking for sys/types.h... yes
checking for sys/stat.h... yes
checking for stdlib.h... yes
checking for string.h... yes
checking for memory.h... yes
checking for strings.h... yes
checking for inttypes.h... yes
checking for stdint.h... yes
checking for unistd.h... yes
checking for dlfcn.h... yes
checking for objdir... .libs
checking if gcc supports -fno-rtti -fno-exceptions... no
checking for gcc option to produce PIC... -fPIC -DPIC
checking if gcc PIC flag -fPIC -DPIC works... yes
checking if gcc static flag -static works... no
checking if gcc supports -c -o file.o... yes
checking if gcc supports -c -o file.o... (cached) yes
checking whether the gcc linker (/usr/bin/ld -m elf_x86_64) supports shared libraries... yes
checking whether -lc should be explicitly linked in... no
checking dynamic linker characteristics... GNU/Linux ld.so
checking how to hardcode library paths into programs... immediate
checking whether stripping libraries is possible... yes
checking if libtool supports shared libraries... yes
checking whether to build shared libraries... yes
checking whether to build static libraries... no
configure: creating ./config.status
config.status: creating config.h
config.status: executing libtool commands
/bin/sh /usr/local/src/cphalcon/build/64bits/libtool --mode=compile gcc -I. -I/usr/local/src/cphalcon/build/64bits -DPHP_ATOM_INC -I/usr/local/src/cphalcon/build/64bits/include -I/usr/local/src/cphalcon/build/64bits/main -I/ usr/local/src/cphalcon/build/64bits -I/usr/include/php -I/usr/include/php/main -I/usr/include/php/TSRM -I/usr/include/php/Zend -I/usr/include/php/ext -I/usr/include/php/ext/date/lib -DPHALCON_RELEASE -DHAVE_CONFIG_H -march= native -mtune=native -O2 -finline-functions -fomit-frame-pointer -fvisibility=hidden -c /usr/local/src/cphalcon/build/64bits/phalcon.zep.c -o phalcon.lo
libtool: compile: gcc -I. -I/usr/local/src/cphalcon/build/64bits -DPHP_ATOM_INC -I/usr/local/src/cphalcon/build/64bits/include -I/usr/local/src/cphalcon/build/64bits/main -I/usr/local/src/cphalcon/build/64bits -I/usr/include /php -I/usr/include/php/main -I/usr/include/php/TSRM -I/usr/include/php/Zend -I/usr/include/php/ext -I/usr/include/php/ext/date/lib -DPHALCON_RELEASE -DHAVE_CONFIG_H -march=native -mtune=native -O2 -finline-functions -fomit-f rame-pointer -fvisibility=hidden -c /usr/local/src/cphalcon/build/64bits/phalcon.zep.c -fPIC -DPIC -o .libs/phalcon.o
/bin/sh /usr/local/src/cphalcon/build/64bits/libtool --mode=link gcc -DPHP_ATOM_INC -I/usr/local/src/cphalcon/build/64bits/include -I/usr/local/src/cphalcon/build/64bits/main -I/usr/local/src/cphalcon/build/64bits -I/usr/incl ude/php -I/usr/include/php/main -I/usr/include/php/TSRM -I/usr/include/php/Zend -I/usr/include/php/ext -I/usr/include/php/ext/date/lib -DPHALCON_RELEASE -DHAVE_CONFIG_H -march=native -mtune=native -O2 -finline-functions -fo mit-frame-pointer -fvisibility=hidden -o phalcon.la -export-dynamic -avoid-version -prefer-pic -module -rpath /usr/local/src/cphalcon/build/64bits/modules phalcon.lo
libtool: link: gcc -shared -fPIC -DPIC .libs/phalcon.o -march=native -mtune=native -O2 -Wl,-soname -Wl,phalcon.so -o .libs/phalcon.so
libtool: link: ( cd ".libs" && rm -f "phalcon.la" && ln -s "../phalcon.la" "phalcon.la" )
/bin/sh /usr/local/src/cphalcon/build/64bits/libtool --mode=install cp ./phalcon.la /usr/local/src/cphalcon/build/64bits/modules
libtool: install: cp ./.libs/phalcon.so /usr/local/src/cphalcon/build/64bits/modules/phalcon.so
libtool: install: cp ./.libs/phalcon.lai /usr/local/src/cphalcon/build/64bits/modules/phalcon.la
libtool: finish: PATH="/usr/local/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/home/vagrant/.local/bin:/home/vagrant/bin:/sbin" ldconfig -n /usr/local/src/cphalcon/build/64bits/modules
----------------------------------------------------------------------
Libraries have been installed in:
/usr/local/src/cphalcon/build/64bits/modules
If you ever happen to want to link against installed libraries
in a given directory, LIBDIR, you must either use libtool, and
specify the full pathname of the library, or use the `-LLIBDIR'
flag during linking and do at least one of the following:
- add LIBDIR to the `LD_LIBRARY_PATH' environment variable
during execution
- add LIBDIR to the `LD_RUN_PATH' environment variable
during linking
- use the `-Wl,-rpath -Wl,LIBDIR' linker flag
- have your system administrator add LIBDIR to `/etc/ld.so.conf'
See any operating system documentation about shared libraries for
more information, such as the ld(1) and ld.so(8) manual pages.
----------------------------------------------------------------------
Build complete.
Don't forget to run 'make test'.
Installing shared extensions: /usr/lib64/php/modules/
Installing header files: /usr/include/php/
Thanks for compiling Phalcon!
Build succeed: Please restart your web server to complete the installation
[root@localhost build]# service httpd restart
Redirecting to /bin/systemctl restart httpd.service
<?php
use Phalcon\Mvc\Model;
/**
* Office
*/
class Office extends Model
{
/**
* @var integer
*/
protected $id;
/**
* @var integer
*/
protected $companyId;
/**
* @var integer
*/
protected $regionId;
/**
* @var integer
*/
protected $addressId;
/**
* @var string
*/
protected $fax;
/**
* @var string
*/
protected $phone;
/**
* @return int
*/
public function getId()
{
return (int) $this->id;
}
/**
* @param int $id
*/
public function setId($id)
{
$this->id = $id;
}
/**
* @return int
*/
public function getCompanyId()
{
return (int) $this->companyId;
}
/**
* @param int $companyId
*/
public function setCompanyId($companyId)
{
$this->companyId = $companyId;
}
/**
* @return int
*/
public function getRegionId()
{
return (int) $this->regionId;
}
/**
* @param int $regionId
*/
public function setRegionId($regionId)
{
$this->regionId = $regionId;
}
/**
* @return int
*/
public function getAddressId()
{
return (string) $this->addressId;
}
/**
* @param int $addressId
*/
public function setAddressId($addressId)
{
$this->addressId = $addressId;
}
/**
* @return string
*/
public function getFax()
{
return (string) $this->fax;
}
/**
* @param string $fax
*/
public function setFax($fax)
{
$this->fax = $fax;
}
/**
* @return string
*/
public function getPhone()
{
return (string) $this->phone;
}
/**
* @param string $phone
*/
public function setPhone($phone)
{
$this->phone = $phone;
}
/**
* Get the source table
*
* @return string
*/
public function getSource()
{
return 'offices';
}
/**
* Independent Column Mapping.
*
* @return array
*/
public function columnMap()
{
return array(
'id' => 'id',
'companyId' => 'companyId',
'regionId' => 'regionId',
'addressId' => 'addressId',
'phone' => 'phone',
'fax' => 'fax'
);
}
}
<?php
use Phalcon\Mvc\Controller;
/**
* TestController
*/
class TestController extends Controller
{
public function indexAction()
{
// Query #1
$row = $this->modelsManager->createBuilder()
->columns('Office.*')
->from('Office')
->where('Office.id = 1')
->getQuery()
->getSingleResult();
if($row) {
echo get_class($row); // Prints always
} else {
echo "nope #1";
}
echo "<br>";
// Query #2
$row = $this->modelsManager->createBuilder()
->columns('Office.*, Address.*')
->from('Office')
->join('Address', 'Office.addressId = Address.id')
->where('Office.id = 1')
->getQuery()
->getSingleResult();
if($row) {
echo get_class($row); // Prints sometimes when Query #1 is commented out
} else {
echo "nope #2"; // Prints always when Query #1 executes
}
echo '<br>';
// Query #3
$phql = 'SELECT Office.*, Address.* FROM Office INNER JOIN Address ON Office.addressId = Address.id WHERE Office.id = 1';
$row = $this->modelsManager->executeQuery($phql);
if($row) {
echo get_class($row); // Prints always
} else {
echo "nope #3";
}
}
}
@ocrdeveloper

Copy link
Copy Markdown

Have you tried changing

->columns('Office., Address.')

to this:

->columns(['Office.', 'Address.'])

In the Query Builder Docs the examples show a string being used as the paramter only when a single column parameter (including "*") is requested. When multiple column parameters are requested, it uses an array of columns.

Examples:

// 'SELECT * FROM Robots';
$phql = $builder->columns('*')
                ->from('Robots');

// 'SELECT id FROM Robots';
$builder->columns('id')
        ->from('Robots');

// 'SELECT id, name FROM Robots';
$builder->columns(array('id', 'name'))
        ->from('Robots');

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment