-
-
Save rkeplin/14d7c86a653f5ce3f7fe to your computer and use it in GitHub Desktop.
Phalcon 2.0 Bug?
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <?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' | |
| ); | |
| } | |
| } |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| [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 |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <?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' | |
| ); | |
| } | |
| } |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <?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"; | |
| } | |
| } | |
| } |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Have you tried changing
to this:
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: