Unlock 30% off on Manual Testing Annual Plans this Holiday Season.

Copied to Clipboard!

How to use ensureColumn method of Location class

Best Cucumber Common Library code snippet using Location.ensureColumn

2019-06-06 09-00-00.php

Source:2019-06-06 09-00-00.php

2$sql = rex_sql::factory();3$sql->setQuery('SET FOREIGN_KEY_CHECKS = 0');4try {5    rex_sql_table::get('rex_prj_country')6        ->ensureColumn(new rex_sql_column('id', 'int(11)', false, null, 'auto_increment'))7        ->ensureColumn(new rex_sql_column('name_1', 'text', false, null, null))8        ->ensureColumn(new rex_sql_column('name_2', 'text', false, null, null))9        ->ensureColumn(new rex_sql_column('name_3', 'text', false, null, null))10        ->ensureColumn(new rex_sql_column('name_4', 'text', false, null, null))11        ->ensureColumn(new rex_sql_column('prio', 'int(11)', false, null, null))12        ->ensureColumn(new rex_sql_column('status', 'text', false, null, null))13        ->ensureColumn(new rex_sql_column('iso2', 'text', false, null, null))14        ->ensureColumn(new rex_sql_column('iso3', 'text', false, null, null))15        ->setPrimaryKey(['id'])16        ->ensure();17    rex_sql_table::get('rex_shop_category')18        ->ensureColumn(new rex_sql_column('id', 'int(10) unsigned', false, null, 'auto_increment'))19        ->ensureColumn(new rex_sql_column('name_1', 'varchar(191)', false, null, null))20        ->ensureColumn(new rex_sql_column('text_1', 'text', false, null, null))21        ->ensureColumn(new rex_sql_column('name_2', 'varchar(191)', false, null, null))22        ->ensureColumn(new rex_sql_column('text_2', 'text', false, null, null))23        ->ensureColumn(new rex_sql_column('name_3', 'varchar(191)', false, null, null))24        ->ensureColumn(new rex_sql_column('text_3', 'text', false, null, null))25        ->ensureColumn(new rex_sql_column('parent_id', 'text', false, null, null))26        ->ensureColumn(new rex_sql_column('subcategories', 'text', false, null, null))27        ->ensureColumn(new rex_sql_column('status', 'int(11)', false, null, null))28        ->ensureColumn(new rex_sql_column('prio', 'int(11)', false, null, null))29        ->ensureColumn(new rex_sql_column('createdate', 'datetime', false, null, null))30        ->ensureColumn(new rex_sql_column('updatedate', 'datetime', false, null, null))31        ->setPrimaryKey(['id'])32        ->ensure();33    rex_sql_table::get('rex_shop_coupon')34        ->ensureColumn(new rex_sql_column('id', 'int(10) unsigned', false, null, 'auto_increment'))35        ->ensureColumn(new rex_sql_column('name_1', 'varchar(191)', false, null, null))36        ->ensureColumn(new rex_sql_column('name_2', 'varchar(191)', false, null, null))37        ->ensureColumn(new rex_sql_column('name_3', 'varchar(191)', false, null, null))38        ->ensureColumn(new rex_sql_column('name_4', 'varchar(191)', false, null, null))39        ->ensureColumn(new rex_sql_column('given_away', 'tinyint(1)', false, null, null))40        ->ensureColumn(new rex_sql_column('start_time', 'date', false, null, null))41        ->ensureColumn(new rex_sql_column('discount_value', 'decimal(10,2)', true, null, null))42        ->ensureColumn(new rex_sql_column('discount_percent', 'decimal(4,1)', true, null, null))43        ->ensureColumn(new rex_sql_column('prefix', 'varchar(191)', false, null, null))44        ->ensureColumn(new rex_sql_column('code', 'text', false, null, null))45        ->ensureColumn(new rex_sql_column('orders', 'text', false, null, null))46        ->ensureColumn(new rex_sql_column('createdate', 'datetime', false, null, null))47        ->ensureColumn(new rex_sql_column('updatedate', 'datetime', false, null, null))48        ->setPrimaryKey(['id'])49        ->ensure();50    rex_sql_table::get('rex_shop_customer')51        ->ensureColumn(new rex_sql_column('id', 'int(10) unsigned', false, null, 'auto_increment'))52        ->ensureColumn(new rex_sql_column('lang_id', 'text', false, null, null))53        ->ensureColumn(new rex_sql_column('ctype', 'text', false, null, null))54        ->ensureColumn(new rex_sql_column('company_name', 'text', false, null, null))55        ->ensureColumn(new rex_sql_column('firstname', 'varchar(191)', false, null, null))56        ->ensureColumn(new rex_sql_column('lastname', 'varchar(191)', false, null, null))57        ->ensureColumn(new rex_sql_column('email', 'varchar(191)', false, null, null))58        ->ensureColumn(new rex_sql_column('password', 'varchar(191)', false, null, null))59        ->ensureColumn(new rex_sql_column('password_hash', 'text', false, null, null))60        ->ensureColumn(new rex_sql_column('fiscal_code', 'varchar(191)', false, null, null))61        ->ensureColumn(new rex_sql_column('vat_num', 'text', false, null, null))62        ->ensureColumn(new rex_sql_column('lastlogin', 'datetime', false, null, null))63        ->ensureColumn(new rex_sql_column('status', 'text', false, null, null))64        ->ensureColumn(new rex_sql_column('updatedate', 'datetime', false, null, null))65        ->ensureColumn(new rex_sql_column('created', 'datetime', false, null, null))66        ->setPrimaryKey(['id'])67        ->ensure();68    rex_sql_table::get('rex_shop_customer_address')69        ->ensureColumn(new rex_sql_column('id', 'int(10) unsigned', false, null, 'auto_increment'))70        ->ensureColumn(new rex_sql_column('customer_id', 'text', false, null, null))71        ->ensureColumn(new rex_sql_column('company_name', 'varchar(191)', false, null, null))72        ->ensureColumn(new rex_sql_column('firstname', 'varchar(191)', false, null, null))73        ->ensureColumn(new rex_sql_column('lastname', 'varchar(191)', false, null, null))74        ->ensureColumn(new rex_sql_column('street', 'varchar(191)', false, null, null))75        ->ensureColumn(new rex_sql_column('street_additional', 'varchar(191)', false, null, null))76        ->ensureColumn(new rex_sql_column('location', 'varchar(191)', false, null, null))77        ->ensureColumn(new rex_sql_column('province', 'varchar(191)', false, null, null))78        ->ensureColumn(new rex_sql_column('postal', 'varchar(191)', false, null, null))79        ->ensureColumn(new rex_sql_column('country', 'text', false, null, null))80        ->ensureColumn(new rex_sql_column('status', 'int(11)', false, null, null))81        ->ensureColumn(new rex_sql_column('createdate', 'datetime', false, null, null))82        ->ensureColumn(new rex_sql_column('updatedate', 'datetime', false, null, null))83        ->setPrimaryKey(['id'])84        ->ensure();85    rex_sql_table::get('rex_shop_discount_group')86        ->ensureColumn(new rex_sql_column('id', 'int(10) unsigned', false, null, 'auto_increment'))87        ->ensureColumn(new rex_sql_column('name_1', 'varchar(191)', false, null, null))88        ->ensureColumn(new rex_sql_column('name_2', 'varchar(191)', false, null, null))89        ->ensureColumn(new rex_sql_column('name_3', 'varchar(191)', false, null, null))90        ->ensureColumn(new rex_sql_column('name_4', 'varchar(191)', false, null, null))91        ->ensureColumn(new rex_sql_column('ctype', 'text', false, null, null))92        ->ensureColumn(new rex_sql_column('price', 'decimal(10,2)', true, null, null))93        ->ensureColumn(new rex_sql_column('amount', 'int(11)', true, null, null))94        ->ensureColumn(new rex_sql_column('discount_percent', 'int(11)', true, null, null))95        ->ensureColumn(new rex_sql_column('discount_value', 'decimal(10,2)', true, null, null))96        ->ensureColumn(new rex_sql_column('free_shipping', 'tinyint(1)', false, null, null))97        ->ensureColumn(new rex_sql_column('status', 'int(11)', false, null, null))98        ->ensureColumn(new rex_sql_column('prio', 'int(11)', false, null, null))99        ->ensureColumn(new rex_sql_column('createdate', 'datetime', false, null, null))100        ->ensureColumn(new rex_sql_column('updatedate', 'datetime', false, null, null))101        ->setPrimaryKey(['id'])102        ->ensure();103    rex_sql_table::get('rex_shop_feature')104        ->ensureColumn(new rex_sql_column('id', 'int(10) unsigned', false, null, 'auto_increment'))105        ->ensureColumn(new rex_sql_column('name_1', 'varchar(191)', false, null, null))106        ->ensureColumn(new rex_sql_column('name_2', 'varchar(191)', false, null, null))107        ->ensureColumn(new rex_sql_column('name_3', 'varchar(191)', false, null, null))108        ->ensureColumn(new rex_sql_column('name_4', 'varchar(191)', false, null, null))109        ->ensureColumn(new rex_sql_column('key', 'varchar(191)', false, null, null))110        ->ensureColumn(new rex_sql_column('status', 'int(11)', false, null, null))111        ->ensureColumn(new rex_sql_column('prio', 'int(11)', false, null, null))112        ->ensureColumn(new rex_sql_column('createdate', 'datetime', false, null, null))113        ->ensureColumn(new rex_sql_column('updatedate', 'datetime', false, null, null))114        ->setPrimaryKey(['id'])115        ->ensure();116    rex_sql_table::get('rex_shop_feature_values')117        ->ensureColumn(new rex_sql_column('id', 'int(10) unsigned', false, null, 'auto_increment'))118        ->ensureColumn(new rex_sql_column('name_1', 'varchar(191)', false, null, null))119        ->ensureColumn(new rex_sql_column('name_2', 'varchar(191)', false, null, null))120        ->ensureColumn(new rex_sql_column('name_3', 'varchar(191)', false, null, null))121        ->ensureColumn(new rex_sql_column('name_4', 'varchar(191)', false, null, null))122        ->ensureColumn(new rex_sql_column('feature_id', 'text', false, null, null))123        ->ensureColumn(new rex_sql_column('key', 'varchar(191)', false, null, null))124        ->ensureColumn(new rex_sql_column('status', 'int(11)', false, null, null))125        ->ensureColumn(new rex_sql_column('prio', 'int(11)', false, null, null))126        ->ensureColumn(new rex_sql_column('createdate', 'datetime', false, null, null))127        ->ensureColumn(new rex_sql_column('updatedate', 'datetime', false, null, null))128        ->setPrimaryKey(['id'])129        ->ensure();130    rex_sql_table::get('rex_shop_order')131        ->ensureColumn(new rex_sql_column('id', 'int(10) unsigned', false, null, 'auto_increment'))132        ->ensureColumn(new rex_sql_column('customer_id', 'text', false, null, null))133        ->ensureColumn(new rex_sql_column('invoice_num', 'text', false, null, null))134        ->ensureColumn(new rex_sql_column('ref_order_id', 'text', false, null, null))135        ->ensureColumn(new rex_sql_column('status', 'text', false, null, null))136        ->ensureColumn(new rex_sql_column('initial_total', 'decimal(10,2)', true, null, null))137        ->ensureColumn(new rex_sql_column('brut_prices', 'text', false, null, null))138        ->ensureColumn(new rex_sql_column('taxes', 'text', false, null, null))139        ->ensureColumn(new rex_sql_column('net_prices', 'text', false, null, null))140        ->ensureColumn(new rex_sql_column('shipping_costs', 'decimal(10,2)', true, null, null))141        ->ensureColumn(new rex_sql_column('discount', 'decimal(10,2)', true, null, null))142        ->ensureColumn(new rex_sql_column('manual_discount', 'decimal(10,2)', true, null, null))143        ->ensureColumn(new rex_sql_column('total', 'decimal(10,2)', true, null, null))144        ->ensureColumn(new rex_sql_column('quantity', 'int(11)', true, null, null))145        ->ensureColumn(new rex_sql_column('promotions', 'text', false, null, null))146        ->ensureColumn(new rex_sql_column('customer_data', 'text', false, null, null))147        ->ensureColumn(new rex_sql_column('invoice_address', 'text', false, null, null))148        ->ensureColumn(new rex_sql_column('shipping_address', 'text', false, null, null))149        ->ensureColumn(new rex_sql_column('payment', 'text', false, null, null))150        ->ensureColumn(new rex_sql_column('shipping', 'text', false, null, null))151        ->ensureColumn(new rex_sql_column('shipping_key', 'varchar(191)', false, null, null))152        ->ensureColumn(new rex_sql_column('extras', 'text', false, null, null))153        ->ensureColumn(new rex_sql_column('ip_address', 'varchar(191)', false, null, null))154        ->ensureColumn(new rex_sql_column('notes', 'text', false, null, null))155        ->ensureColumn(new rex_sql_column('createdate', 'datetime', false, null, null))156        ->ensureColumn(new rex_sql_column('updatedate', 'datetime', false, null, null))157        ->setPrimaryKey(['id'])158        ->ensure();159    rex_sql_table::get('rex_shop_order_products')160        ->ensureColumn(new rex_sql_column('id', 'int(10) unsigned', false, null, 'auto_increment'))161        ->ensureColumn(new rex_sql_column('order_id', 'text', false, null, null))162        ->ensureColumn(new rex_sql_column('product_id', 'text', false, null, null))163        ->ensureColumn(new rex_sql_column('code', 'varchar(191)', false, null, null))164        ->ensureColumn(new rex_sql_column('cart_quantity', 'int(11)', true, null, null))165        ->ensureColumn(new rex_sql_column('data', 'text', false, null, null))166        ->ensureColumn(new rex_sql_column('shipping_key', 'varchar(191)', false, null, null))167        ->ensureColumn(new rex_sql_column('createdate', 'datetime', false, null, null))168        ->ensureColumn(new rex_sql_column('updatedate', 'datetime', false, null, null))169        ->setPrimaryKey(['id'])170        ->ensure();171    rex_sql_table::get('rex_shop_package')172        ->ensureColumn(new rex_sql_column('id', 'int(10) unsigned', false, null, 'auto_increment'))173        ->ensureColumn(new rex_sql_column('name_1', 'varchar(191)', false, null, null))174        ->ensureColumn(new rex_sql_column('description_1', 'text', false, null, null))175        ->ensureColumn(new rex_sql_column('name_2', 'varchar(191)', false, null, null))176        ->ensureColumn(new rex_sql_column('description_2', 'text', false, null, null))177        ->ensureColumn(new rex_sql_column('name_3', 'varchar(191)', false, null, null))178        ->ensureColumn(new rex_sql_column('description_3', 'text', false, null, null))179        ->ensureColumn(new rex_sql_column('name_4', 'varchar(191)', false, null, null))180        ->ensureColumn(new rex_sql_column('description_4', 'text', false, null, null))181        ->ensureColumn(new rex_sql_column('products', 'text', false, null, null))182        ->ensureColumn(new rex_sql_column('code', 'varchar(191)', false, null, null))183        ->ensureColumn(new rex_sql_column('status', 'int(11)', false, null, null))184        ->ensureColumn(new rex_sql_column('prio', 'int(11)', false, null, null))185        ->ensureColumn(new rex_sql_column('createdate', 'datetime', false, null, null))186        ->ensureColumn(new rex_sql_column('updatedate', 'datetime', false, null, null))187        ->setPrimaryKey(['id'])188        ->ensure();189    rex_sql_table::get('rex_shop_product')190        ->ensureColumn(new rex_sql_column('id', 'int(10) unsigned', false, null, 'auto_increment'))191        ->ensureColumn(new rex_sql_column('name_1', 'varchar(191)', false, null, null))192        ->ensureColumn(new rex_sql_column('subtitle_1', 'varchar(191)', false, null, null))193        ->ensureColumn(new rex_sql_column('short_description_1', 'text', false, null, null))194        ->ensureColumn(new rex_sql_column('description_1', 'text', false, null, null))195        ->ensureColumn(new rex_sql_column('name_2', 'varchar(191)', false, null, null))196        ->ensureColumn(new rex_sql_column('subtitle_2', 'varchar(191)', false, null, null))197        ->ensureColumn(new rex_sql_column('short_description_2', 'text', false, null, null))198        ->ensureColumn(new rex_sql_column('description_2', 'text', false, null, null))199        ->ensureColumn(new rex_sql_column('name_3', 'varchar(191)', false, null, null))200        ->ensureColumn(new rex_sql_column('subtitle_3', 'varchar(191)', false, null, null))201        ->ensureColumn(new rex_sql_column('short_description_3', 'text', false, null, null))202        ->ensureColumn(new rex_sql_column('description_3', 'text', false, null, null))203        ->ensureColumn(new rex_sql_column('name_4', 'varchar(191)', false, null, null))204        ->ensureColumn(new rex_sql_column('subtitle_4', 'varchar(191)', false, null, null))205        ->ensureColumn(new rex_sql_column('short_description_4', 'text', false, null, null))206        ->ensureColumn(new rex_sql_column('description_4', 'text', false, null, null))207        ->ensureColumn(new rex_sql_column('type', 'text', false, null, null))208        ->ensureColumn(new rex_sql_column('hashtag', 'varchar(191)', false, null, null))209        ->ensureColumn(new rex_sql_column('video', 'varchar(191)', false, null, null))210        ->ensureColumn(new rex_sql_column('code', 'varchar(191)', false, null, null))211        ->ensureColumn(new rex_sql_column('category', 'text', false, null, null))212        ->ensureColumn(new rex_sql_column('optionals', 'text', false, null, null))213        ->ensureColumn(new rex_sql_column('category_id', 'text', false, null, null))214        ->ensureColumn(new rex_sql_column('images', 'text', false, null, null))215        ->ensureColumn(new rex_sql_column('inventory', 'text', false, null, null))216        ->ensureColumn(new rex_sql_column('amount', 'varchar(191)', false, null, null))217        ->ensureColumn(new rex_sql_column('b2b_sale_amount', 'varchar(191)', false, null, null))218        ->ensureColumn(new rex_sql_column('price', 'varchar(191)', false, null, null))219        ->ensureColumn(new rex_sql_column('reduced_price', 'varchar(191)', false, null, null))220        ->ensureColumn(new rex_sql_column('tax', 'text', false, null, null))221        ->ensureColumn(new rex_sql_column('length', 'text', false, null, null))222        ->ensureColumn(new rex_sql_column('width', 'text', false, null, null))223        ->ensureColumn(new rex_sql_column('height', 'text', false, null, null))224        ->ensureColumn(new rex_sql_column('weight', 'text', false, null, null))225        ->ensureColumn(new rex_sql_column('features', 'text', false, null, null))226        ->ensureColumn(new rex_sql_column('related_products', 'text', false, null, null))227        ->ensureColumn(new rex_sql_column('status', 'text', false, null, null))228        ->ensureColumn(new rex_sql_column('prio', 'int(11)', false, null, null))229        ->ensureColumn(new rex_sql_column('createdate', 'datetime', false, null, null))230        ->ensureColumn(new rex_sql_column('updatedate', 'datetime', false, null, null))231        ->setPrimaryKey(['id'])232        ->ensure();233    rex_sql_table::get('rex_shop_product_has_category')234        ->ensureColumn(new rex_sql_column('id', 'int(10) unsigned', false, null, 'auto_increment'))235        ->ensureColumn(new rex_sql_column('product_id', 'text', false, null, null))236        ->ensureColumn(new rex_sql_column('category_id', 'text', false, null, null))237        ->ensureColumn(new rex_sql_column('prio', 'int(11)', false, null, null))238        ->ensureColumn(new rex_sql_column('createdate', 'datetime', false, null, null))239        ->ensureColumn(new rex_sql_column('updatedate', 'datetime', false, null, null))240        ->setPrimaryKey(['id'])241        ->ensure();242    rex_sql_table::get('rex_shop_product_has_feature')243        ->ensureColumn(new rex_sql_column('id', 'int(10) unsigned', false, null, 'auto_increment'))244        ->ensureColumn(new rex_sql_column('type', 'text', false, null, null))245        ->ensureColumn(new rex_sql_column('name_1', 'varchar(191)', false, null, null))246        ->ensureColumn(new rex_sql_column('material_1', 'varchar(191)', false, null, null))247        ->ensureColumn(new rex_sql_column('name_2', 'varchar(191)', false, null, null))248        ->ensureColumn(new rex_sql_column('material_2', 'varchar(191)', false, null, null))249        ->ensureColumn(new rex_sql_column('name_3', 'varchar(191)', false, null, null))250        ->ensureColumn(new rex_sql_column('material_3', 'varchar(191)', false, null, null))251        ->ensureColumn(new rex_sql_column('product_id', 'text', false, null, null))252        ->ensureColumn(new rex_sql_column('variant_key', 'varchar(191)', false, null, null))253        ->ensureColumn(new rex_sql_column('code', 'varchar(191)', false, null, null))254        ->ensureColumn(new rex_sql_column('amount', 'int(11)', true, null, null))255        ->ensureColumn(new rex_sql_column('price', 'decimal(10,2)', true, null, null))256        ->ensureColumn(new rex_sql_column('images', 'text', false, null, null))257        ->ensureColumn(new rex_sql_column('material_image', 'text', false, null, null))258        ->ensureColumn(new rex_sql_column('prio', 'int(11)', false, null, null))259        ->ensureColumn(new rex_sql_column('createdate', 'datetime', false, null, null))260        ->ensureColumn(new rex_sql_column('updatedate', 'datetime', false, null, null))261        ->setPrimaryKey(['id'])262        ->ensure();263    rex_sql_table::get('rex_shop_session')264        ->ensureColumn(new rex_sql_column('id', 'int(10) unsigned', false, null, 'auto_increment'))265        ->ensureColumn(new rex_sql_column('customer_id', 'text', false, null, null))266        ->ensureColumn(new rex_sql_column('session_id', 'varchar(191)', false, null, null))267        ->ensureColumn(new rex_sql_column('last_url', 'text', false, null, null))268        ->ensureColumn(new rex_sql_column('cart_items', 'text', false, null, null))269        ->ensureColumn(new rex_sql_column('last_cart_update', 'datetime', false, null, null))270        ->ensureColumn(new rex_sql_column('createdate', 'datetime', false, null, null))271        ->ensureColumn(new rex_sql_column('lastupdate', 'datetime', false, null, null))272        ->setPrimaryKey(['id'])273        ->ensure();274    rex_sql_table::get('rex_shop_tax')275        ->ensureColumn(new rex_sql_column('id', 'int(10) unsigned', false, null, 'auto_increment'))276        ->ensureColumn(new rex_sql_column('updatedate', 'datetime', false, null, null))277        ->ensureColumn(new rex_sql_column('createdate', 'datetime', false, null, null))278        ->ensureColumn(new rex_sql_column('prio', 'int(11)', false, null, null))279        ->ensureColumn(new rex_sql_column('status', 'int(11)', false, null, null))280        ->ensureColumn(new rex_sql_column('tax', 'int(11)', true, null, null))281        ->setPrimaryKey(['id'])282        ->ensure();283    rex_sql_table::get('rex_yform_field')284        ->ensureColumn(new rex_sql_column('scale', 'text', false, null, null), 'not_required')285        ->ensureColumn(new rex_sql_column('options', 'text', false, null, null), 'scale')286        ->ensureColumn(new rex_sql_column('default', 'text', false, null, null), 'options')287        ->ensureColumn(new rex_sql_column('no_db', 'text', false, null, null), 'default')288        ->ensureColumn(new rex_sql_column('type', 'text', false, null, null), 'no_db')289        ->ensureColumn(new rex_sql_column('message', 'text', false, null, null), 'type')290        ->ensureColumn(new rex_sql_column('empty_value', 'text', false, null, null), 'message')291        ->ensureColumn(new rex_sql_column('notice', 'text', false, null, null), 'empty_value')292        ->ensureColumn(new rex_sql_column('format', 'text', false, null, null), 'notice')293        ->ensureColumn(new rex_sql_column('only_empty', 'text', false, null, null), 'format')294        ->ensureColumn(new rex_sql_column('fields', 'text', false, null, null), 'only_empty')295        ->ensureColumn(new rex_sql_column('table', 'text', false, null, null), 'fields')296        ->ensureColumn(new rex_sql_column('field', 'text', false, null, null), 'table')297        ->ensureColumn(new rex_sql_column('empty_option', 'text', false, null, null), 'field')298        ->ensureColumn(new rex_sql_column('widget', 'text', false, null, null), 'empty_option')299        ->ensureColumn(new rex_sql_column('attributes', 'text', false, null, null), 'widget')300        ->ensureColumn(new rex_sql_column('preview', 'text', false, null, null), 'attributes')301        ->ensureColumn(new rex_sql_column('multiple', 'text', false, null, null), 'preview')302        ->ensureColumn(new rex_sql_column('values', 'text', false, null, null), 'multiple')303        ->ensureColumn(new rex_sql_column('relation_table', 'text', false, null, null), 'values')304        ->ensureColumn(new rex_sql_column('function', 'text', false, null, null), 'relation_table')305        ->ensureColumn(new rex_sql_column('salt', 'text', false, null, null), 'function')306        ->ensureColumn(new rex_sql_column('filter', 'text', false, null, null), 'salt')307        ->ensureColumn(new rex_sql_column('current_date', 'text', false, null, null), 'filter')308        ->ensureColumn(new rex_sql_column('html', 'text', false, null, null), 'current_date')309        ->ensureColumn(new rex_sql_column('show_value', 'text', false, null, null), 'html')310        ->ensureColumn(new rex_sql_column('params', 'text', false, null, null), 'show_value')311        ->ensureColumn(new rex_sql_column('rules', 'text', false, null, null), 'params')312        ->ensureColumn(new rex_sql_column('precision', 'text', false, null, null), 'rules')313        ->ensureColumn(new rex_sql_column('choices', 'text', false, null, null), 'precision')314        ->ensureColumn(new rex_sql_column('expanded', 'text', false, null, null), 'choices')315        ->ensureColumn(new rex_sql_column('unit', 'text', false, null, null), 'expanded')316        ->ensureColumn(new rex_sql_column('validate_type', 'text', false, null, null), 'unit')317        ->alter();318    $sql->setQuery(<<<'SQL'319        INSERT INTO `rex_yform_field` (`table_name`, `prio`, `type_id`, `type_name`, `db_type`, `list_hidden`, `search`, `name`, `label`, `not_required`, `scale`, `options`, `default`, `no_db`, `type`, `message`, `empty_value`, `notice`, `format`, `only_empty`, `fields`, `table`, `field`, `empty_option`, `widget`, `attributes`, `preview`, `multiple`, `values`, `relation_table`, `function`, `salt`, `filter`, `current_date`, `html`, `show_value`, `params`, `rules`, `precision`, `choices`, `expanded`, `unit`, `validate_type`)320        VALUES321            ('rex_shop_category', 1, 'value', 'tab_start', 'none', 0, 0, 'tab_start', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),322            ('rex_shop_category', 2, 'value', 'text', 'varchar(191)', 0, 1, 'name_1', 'Bezeichnung', '', '', '', '', 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),323            ('rex_shop_category', 3, 'value', 'textarea', 'text', 1, 0, 'text_1', 'Beschreibung', '', '', '', '', 0, '', '', '', '', '', '', '', '', '', '', '', '{\"class\":\"tinyMCEEditor\"}', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),324            ('rex_shop_category', 4, 'value', 'tab_break', 'none', 0, 0, 'tab_break_1', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),325            ('rex_shop_category', 5, 'value', 'text', 'varchar(191)', 1, 1, 'name_2', 'Bezeichnung', '', '', '', '', 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),326            ('rex_shop_category', 6, 'value', 'textarea', 'text', 1, 0, 'text_2', 'Beschreibung', '', '', '', '', 0, '', '', '', '', '', '', '', '', '', '', '', '{\"class\":\"tinyMCEEditor\"}', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),327            ('rex_shop_category', 7, 'value', 'tab_break', 'none', 0, 0, 'tab_break_2', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),328            ('rex_shop_category', 8, 'value', 'text', 'varchar(191)', 1, 0, 'name_3', 'Bezeichnung', '', '', '', '', 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),329            ('rex_shop_category', 9, 'value', 'textarea', 'text', 1, 0, 'text_3', 'Beschreibung', '', '', '', '', 0, '', '', '', '', '', '', '', '', '', '', '', '{\"class\":\"tinyMCEEditor\"}', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),330            ('rex_shop_category', 10, 'value', 'tab_end', 'none', 0, 0, 'tab_end', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),...

install.php

Source:install.php

1<?php2\rex_sql_table::get(\rex::getTable('d2u_courses_location_categories'))3	->ensureColumn(new rex_sql_column('location_category_id', 'INT(11) unsigned', false, null, 'auto_increment'))4	->setPrimaryKey('location_category_id')5	->ensureColumn(new \rex_sql_column('name', 'VARCHAR(255)', true))6    ->ensureColumn(new \rex_sql_column('picture', 'VARCHAR(255)', true))7    ->ensureColumn(new \rex_sql_column('zoom_level', 'INT(10)', true))8    ->ensureColumn(new \rex_sql_column('updatedate', 'DATETIME'))9    ->ensure();10\rex_sql_table::get(\rex::getTable('d2u_courses_locations'))11	->ensureColumn(new rex_sql_column('location_id', 'INT(11) unsigned', false, null, 'auto_increment'))12	->setPrimaryKey('location_id')13	->ensureColumn(new \rex_sql_column('name', 'VARCHAR(255)', true))14	->ensureColumn(new \rex_sql_column('latitude', 'DECIMAL(14,10)', true, 0))15	->ensureColumn(new \rex_sql_column('longitude', 'DECIMAL(14,10)', true, 0))16	->ensureColumn(new \rex_sql_column('street', 'VARCHAR(255)', true))17	->ensureColumn(new \rex_sql_column('zip_code', 'VARCHAR(10)', true))18	->ensureColumn(new \rex_sql_column('city', 'VARCHAR(255)', true))19	->ensureColumn(new \rex_sql_column('country_code', 'VARCHAR(3)', true))20    ->ensureColumn(new \rex_sql_column('picture', 'VARCHAR(255)', true))21    ->ensureColumn(new \rex_sql_column('site_plan', 'VARCHAR(255)', true))22    ->ensureColumn(new \rex_sql_column('location_category_id', 'INT(11)', true))23    ->ensureColumn(new \rex_sql_column('redaxo_users', 'TEXT', true))24    ->ensureColumn(new \rex_sql_column('updatedate', 'DATETIME'))25    ->ensure();26rex_sql_table::get(rex::getTable('d2u_courses_courses'))27	->ensureColumn(new \rex_sql_column('location_id', 'INT(11)', true, null))28	->ensureColumn(new \rex_sql_column('room', 'VARCHAR(255)', true, null))29	->alter();30// START create views for url addon31$sql = rex_sql::factory();32// Online locations (changes need to be done here and addon pages/settings.php)33$sql->setQuery('CREATE OR REPLACE VIEW '. rex::getTablePrefix() .'d2u_courses_url_locations AS34	SELECT locations.location_id, locations.name, locations.name AS seo_title, locations.picture, courses.updatedate, locations.location_category_id35	FROM '. rex::getTablePrefix() .'d2u_courses_courses AS courses36	LEFT JOIN '. rex::getTablePrefix() .'d2u_courses_locations AS locations37		ON courses.location_id = locations.location_id38	WHERE courses.online_status = "online"39		AND ('. d2u_courses_frontend_helper::getShowTimeWhere() .')40		AND courses.updatedate = (41			SELECT MAX(courses_max.updatedate) FROM '. rex::getTablePrefix() .'d2u_courses_courses AS courses_max42			WHERE locations.location_id = courses_max.location_id AND courses_max.online_status = "online" AND ('. d2u_courses_frontend_helper::getShowTimeWhere() .')...

ensureColumn

Using AI Code Generation

1require_once 'Location.php';2$loc = new Location();3$loc->ensureColumn('city', 'varchar(32)');4$loc->ensureColumn('state', 'varchar(32)');5$loc->ensureColumn('zip', 'varchar(32)');6$loc->ensureColumn('country', 'varchar(32)');7$loc->ensureColumn('lat', 'varchar(32)');8$loc->ensureColumn('lng', 'varchar(32)');9public function geocode($address) {10    $response = file_get_contents($url);11    if ($json['status'] == 'OK') {12        $this->city = $json['results'][0]['address_components'][2]['long_name'];13        $this->state = $json['results'][0]['address_components'][4]['short_name'];14        $this->zip = $json['results'][0]['address_components'][6]['long_name'];15        $this->country = $json['results'][0]['address_components'][5]['long_name'];16        $this->lat = $json['results'][0]['geometry']['location']['lat'];17        $this->lng = $json['results'][0]['geometry']['location']['lng'];18        return TRUE;19    } else {20        return FALSE;21    }22}23public function reverseGeocode($lat, $lng) {24    $response = file_get_contents($url);25    if ($json['status'] == 'OK') {

ensureColumn

Using AI Code Generation

1require_once 'Location.php';2$location = new Location();3$location->ensureColumn('column_name', 'column_type');4require_once 'Location.php';5$location = new Location();6$location->ensureColumn('column_name', 'column_type');7class Location {8    public function ensureColumn($columnName, $columnType) {9    }10}11class DbConnection {12    public function getConnection() {13    }14}15class DbConnection {16    public function getConnection() {17    }18}19class DbConnection {20    public function getConnection() {21    }22}23class DbConnection {24    public function getConnection() {25    }26}27class DbConnection {28    public function getConnection() {29    }30}31class DbConnection {

ensureColumn

Using AI Code Generation

1require_once 'Location.php';2$location = new Location();3$location->ensureColumn("name", "varchar(255)", "NOT NULL", "''", "after id");4require_once 'Location.php';5$location = new Location();6$location->ensureColumn("name", "varchar(255)", "NOT NULL", "''", "after id");7$location->ensureColumn("name", "varchar(255)", "NOT NULL", "''", "after id");8require_once 'Location.php';9$location = new Location();10$location->ensureColumn("name", "varchar(255)", "NOT NULL", "''", "after id");11$location->ensureColumn("name", "varchar(255)", "NOT NULL", "''", "after id");12$location->ensureColumn("name", "varchar(255)", "NOT NULL", "''", "after id");13require_once 'Location.php';14$location = new Location();15$location->ensureColumn("name", "varchar(255)", "NOT NULL", "''", "after id");16$location->ensureColumn("name", "varchar(255)", "NOT NULL", "''", "after id");17$location->ensureColumn("name", "varchar(255)", "NOT NULL", "''", "after id");18$location->ensureColumn("name", "varchar(255)", "NOT NULL", "''", "after id");19require_once 'Location.php';20$location = new Location();21$location->ensureColumn("name", "varchar(255)", "NOT NULL", "''", "after id");22$location->ensureColumn("name", "varchar(255)", "NOT NULL", "''", "after id");23$location->ensureColumn("name", "varchar(255)", "NOT NULL", "''", "after id");24$location->ensureColumn("name", "varchar(255)", "NOT NULL", "''", "after id");25$location->ensureColumn("name", "varchar(255)", "NOT NULL", "''", "after id");

ensureColumn

Using AI Code Generation

1$location = new Location();2$location->ensureColumn('column_name', 'column_type');3$location = new Location();4$location->addColumn('column_name', 'column_type');5$location = new Location();6$location->removeColumn('column_name');7$location = new Location();8$location->dropTable();9$location = new Location();10$location->renameColumn('old_column_name', 'new_column_name');11$location = new Location();12$location->renameTable('new_table_name');13$location = new Location();14$location->changeColumn('column_name', 'new_column_type');15$location = new Location();16$location->truncateTable();

ensureColumn

Using AI Code Generation

1$column = new Location();2$column->ensureColumn('column_name');3$column = new Location();4$column->ensureColumn('column_name');5$column = new Location();6$column->ensureColumn('column_name');7$column = new Location();8$column->ensureColumn('column_name');9$column = new Location();10$column->ensureColumn('column_name');11$column = new Location();12$column->ensureColumn('column_name');13$column = new Location();14$column->ensureColumn('column_name');15$column = new Location();16$column->ensureColumn('column_name');17$column = new Location();18$column->ensureColumn('column_name');19$column = new Location();

Automation Testing Tutorials

Learn to execute automation testing from scratch with LambdaTest Learning Hub. Right from setting up the prerequisites to run your first automation test, to following best practices and diving deeper into advanced test scenarios. LambdaTest Learning Hubs compile a list of step-by-step guides to help you be proficient with different test automation frameworks i.e. Selenium, Cypress, TestNG etc.