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();
Check out the latest blogs from LambdaTest on this topic:
I think that probably most development teams describe themselves as being “agile” and probably most development teams have standups, and meetings called retrospectives.There is also a lot of discussion about “agile”, much written about “agile”, and there are many presentations about “agile”. A question that is often asked is what comes after “agile”? Many testers work in “agile” teams so this question matters to us.
Entering the world of testers, one question started to formulate in my mind: “what is the reason that bugs happen?”.
Companies are using DevOps to quickly respond to changing market dynamics and customer requirements.
Continuous integration is a coding philosophy and set of practices that encourage development teams to make small code changes and check them into a version control repository regularly. Most modern applications necessitate the development of code across multiple platforms and tools, so teams require a consistent mechanism for integrating and validating changes. Continuous integration creates an automated way for developers to build, package, and test their applications. A consistent integration process encourages developers to commit code changes more frequently, resulting in improved collaboration and code quality.
The QA testing profession requires both educational and long-term or experience-based learning. One can learn the basics from certification courses and exams, boot camp courses, and college-level courses where available. However, developing instinctive and practical skills works best when built with work experience.
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.
You could also refer to video tutorials over LambdaTest YouTube channel to get step by step demonstration from industry experts.
Execute automation tests with ensureColumn on a cloud-based Grid of 3000+ real browsers and operating systems for both web and mobile applications.
Test now for FreeGet 100 minutes of automation test minutes FREE!!