Just added new widget into html() with name “simple_table”.
Aim of this widget – display key=value data in pretty way with minimal frictions.
More cocs here:
http://yfix.net/docs/html/simple_table
Sample of usage:
https://github.com/yfix/yf/blob/master/.dev/samples/classes/test_html.class.php#L99
Example:
table(db()->from('user')->where('active','1'))
->text('name')
->text('email')
->btn_edit()
->btn_delete()
;I want to share new built-in feature from yf framework:
It allows to easily display placeholder image with desired dimensions.
There are several methods to do this:
1. Calling url from any place will display image with width 200px and height 50px:
http://project.dev/dynamic/placeholder/200×50
2. From withing project php code calling helper method will return html “img” tag with data/image with width 200px and height 50px:
module(‘dynamic’)->placeholder_img(array(‘width’ => 200, ‘height’ => 50));
Today I’ve added to db utils ability to create table similar to Laravel:
db()->utils()->create_table($name, function($table_helper) {
$table_helper
->small_int('actor_id', array('length' => 5, 'unsigned' => true, 'nullable' => false, 'auto_inc' => true))
->string('first_name', array('length' => 45, 'nullable' => false))
->string('last_name', array('length' => 45, 'nullable' => false))
->primary('actor_id')
->index('last_name', 'idx_actor_last_name')
->option('engine', 'InnoDB')
->option('charset', 'utf8')
;
});
Full list of supported column types as methods is here:
https://github.com/yfix/yf/blob/master/classes/db/yf_db_utils_helper_create_table.class.php
You can take look at the tests here:
https://github.com/yfix/yf/blob/master/.dev/tests/functional/db/class_db_real_utils_mysql.Test.php#L312
New useful feature done inside validation class – validation rules now supports multiple fields in rule key. This usually needed to set same rulesets for several fields to validate.
Example:
$rules = array(
'test1' => array('min_length:2', 'max_length:12'),
'test2,test3' => array('min_length:2', 'max_length:12'),
'test1,test2,test3 ' => array('is_unique:user.login|between:1,10|chars:a,b,c,d|regex:[a-z0-9]+'),
);
As usual, such new complex feature comes with unit tests:
https://github.com/yfix/yf/blob/master/.dev/tests/unit/class_validate.Test.php#L1189
Also, now spaces are trimmed in keys, as can be seen inside unit tests.
Recently I’ve completed YF db migrations functionality.
Source located here:
https://github.com/yfix/yf/blob/master/classes/db/yf_db_migrator.class.php
There are console helpers:
yf db:migrate compare
yf db:migrate generate
yf db:migrate create
yf db:migrate apply
yf db:migrate list
yf db:migrate dump
General commands:
* compare – will output differencies between current project db structure and expected php_sql db structure, stored in files inside framework and project. Computes differencies in:
tables, columns, indexes, foreign keys. Report about missing or new items and about changed items too.
* generate – will output internal migration commands, not writing anything to disk, useful to figure out how created migration can look like
* create – create new migration file into disk, based on compare result. Usually store file into APP_PATH/share/db/migrations/%new_migration_file%.php.
This method useful to store changes into database for future applying on other hosts.
* apply – apply selected migration into project database. Useful for applying database changes in controlled and repeatable manner.
* list – list available migrations to apply
* dump – dump current database structure into disk into sql_php files.
I’ve added function wildcard_compare($wildcard, $string) into YF framework, which uses php built-in fnmatch() function, which is fast and not using regexps.
There is support for these patterns:
“*” – no or any number of symbols
“?” – exactly one symbol
“[abc]” – one of symbols passed inside square brackets
YF function wildcard_compare() differs from native fnmatch(): it can accept array of wildcards and if any of them matched – then overall return true.
Examples:
wildcard_compare('regex are * useful', 'regex are always useful')
Function source:
https://github.com/yfix/yf/blob/master/share/functions/yf_common_funcs.php#L397
Unit tests (also examples):
https://github.com/yfix/yf/blob/master/.dev/tests/unit/functions/function_wildcard_compare.Test.php
YF built-in template engine update:
if_func feature was upgraded today by providing ability to pass several variables instead of one.
This allows to create more complex conditions inside templates without need of additional actions.
Also, it is possible to change inner mulitple condition by adding “_or”, “_and” to function name.
This new addition also works will all other “if_func” features:
* custom functions
* negating of each comparison
* function shortcuts (“ok”, “not_ok”, “empty”, “isset”, etc)
* validation class usage
Lets go to examples:
// Imagine this kind of array:
$data = array(
'name1' => '',
'name2' => 'something',
'name3' => '',
'name4' => 'other',
'name5' => '',
'name6' => 'gggggg'
);
// and inside templates you can do now:
------------
{if_not_ok(name1,name3)}good{/if}
{if_not_ok(name1,name2)}bad{else}good{/if}
{if_or_ok(name1,name2)}good{/if}
{if_and_empty(name1,name3,name5)}good{/if} {if_and_not_empty(name2,name4,name6)}ok{/if}
{if_not_isset(name777,name888,name999)}good{/if}
As usual, there were added unit tests for this new feature:
https://github.com/yfix/yf/blob/master/.dev/tests/tpl/tpl_driver_yf_core.Test.php#L400
Say welcome to the new requested feature for templating engine: “foreach_exec”.
It is combination of the “foreach” iterator tag and “execute” class method calling tag.
It works by executing given argument as execute input and then iterates over result array.
As you can understand, called method should return array.
Aim of this tag is to leverage wrapping code amount and speed optimization to avoid
extra big arrays passing into templates by $replace array members.
Examples:
imagine result of the called method _class('unittest2')->_callme2 == array('k1' => 'v1', 'k2' => 'v2');
and now template code:
{foreach_exec(unittest2,_callme2)} _{_key}={_val}_ {/foreach_exec}
{foreach_exec(@object,_callme2)} _{_key}={_val}_ {/foreach_exec}
{foreach_exec(unittest2,_callme2)} _{_key}={_val}_ {elseforeach} no rows {/foreach_exec}
It is now possible to use magick @object (means $_GET[‘object’]) and @action (means $_GET[‘action’])
inside these template tags: {execute()}, {exec_cached()}, {exec_last()}, {foreach_exec()}.
Examples:
{execute(@object,some_method)}
{execute(@object,@action)}
{execute(@object,@action,k1=v2;k2=v2)}
{exec_cached(@object,some_method)}
{exec_cached(@object,@action)}
{exec_cached(@object,@action,k1=v2;k2=v2)}
{exec_last(@object,some_method)}
{exec_last(@object,@action)}
{exec_last(@object,@action,k1=v2;k2=v2)}
{foreach_exec(@object,some_method)} {_key}={_val} {/foreach_exec}
{foreach_exec(@object,@action)} {_key}={_val} {/foreach_exec}
{foreach_exec(@object,@action,k1=v2;k2=v2)} {_key}={_val} {/foreach_exec}
