Allow Table name prefixed with underscore Replace the original symfony/lib/plugins/sfPropelPlugin/lib/addon/sfPropelDatabaseSchema.class.php: public function getChildren($hash) { foreach ($hash as $key => $value) { // ignore special children (starting with _) if ($key[0] == '_') { unset($hash[$key]); } } return $hash; } with: public function getChildren($hash) { foreach ($hash as $key => $value) { // ignore special children… [Read more…]
MySQL Workbench provides DBAs and developers an integrated tools environment for: Database Design & Modeling SQL Development (replacing MySQL Query Browser) Database Administration (replacing MySQL Administrator) There are numerous MySQL Workbench plugin to export the MySQL schema into Propel, one is found here. This plugin export the schema into Propel xml schema. For a symfony… [Read more…]
To implement Web Service in symfony, ckWebServicePlugin can offer integration of symfony module as web service. The instruction detail can be found at http://www.symfony-project.org/plugins/ckWebServicePlugin/3_0_0?tab=plugin_readme. But, to make the plugin installation work, you need additional files: ckWsdlGenerator ckWsdlGenerator can be checked out from http://svn.symfony-project.com/plugins/ckWebServicePlugin/branches/ckWsdlGenerator and must be placed under [project]/plugins/ckWebServicePlugin/lib/vendor/. Addendum Addendum can be checked out… [Read more…]
VARBINARY or LONGVARBINARY column should be mapped as blob column. But in Propel 1.3 they are mapped wrong. The setter for the column will not work when the column is saved, the column is treated as string instead of resource. The column value will be something like Resource id #nn. See this ticket. You can… [Read more…]
sfAccessLoggerPlugin introduces a way of logging your site visits. To accomplish this logging, the others plugin is needed: sfGuardPlugin for User management. sfPropelUuidBehaviorPlugin for generating Universally Unique Identifier (UUID). sfRemoteIPPlugin, an extract of function found in sfPropelAuditPlugin by Sacha Telgenhof Oude Koehorst to detect the remote IP Address. sfBrowscapPlugin, a simple symfony wrapper for phpbrowscap… [Read more…]
Sometimes, the table we’re using force us to use multiple primary keys as shown in the schema below (config/schema.yml): connection: propel defaultIdMethod: native package: lib.model classes: State: tableName: state columns: id: { type: varchar, size: 2, primaryKey: true } country_id: { type: varchar, size: 2, primaryKey: true } name: { type: varchar, size: 50, index:… [Read more…]
In a shared hosting environment, you may not have a full access to the server. Everything has already been installed. But a least they provide a secure shell (SSH). I have successfully deploy a syfmony 1.2 application in a shared hosting, surely with a hacking. PDO Hack Symfony 1.2 at least need PHP 5.2.4 and… [Read more…]
Symfony has a file based configuration, and with sfDbConfigPlugin, it can handle a database based configuration. sfDbConfigPlugin provide the following feature: sfDbConfig class sfDbConfig class provide a counterpart methods of sfConfig class: sfDbConfig::set('MYSETTING::TEST', 'test value'); // set the value sfDbConfig::get('MYSETTING::TEST', 'default'); // get the value, return 'default' if not defined $exist = sfDbConfig::has('MYSETTING::TEST'); // check… [Read more…]
Our application development has been finished, now the time we put the application alive on the web. On shared hosting, directory structure for a html files has already been specified according to the server. First step, is to figure out what it looks like and where to put html files. Below is a sample: root/… [Read more…]
Eveybody like symfony 1.1 form, but there are several fatures of symfony 1.0 forms which are not yet available under symfony 1.1. The missing widgets in symfony 1.1 which all peoples should have, are rich textarea, rich input date time, and so on. Looking up at the form helper code, I decided to make it… [Read more…]
December 21, 2010
0