IvoFilot.nl: Blog

SQL

2014-06-07

Toggling a database flag field in CakePHP

7051

Page 1 of 1

Biography

Ivo Filot is a theoretical chemist originating from the Netherlands. He finished his Ph.D. in 2015 at the Eindhoven University of Technology under the supervision of Prof. Emiel Hensen and Prof. Rutger van Santen. His research involves the elucidation of the complex Fischer-Tropsch reaction mechanism employing density functional theory and microkinetic modeling. Currently, he is employed as a university researcher at the Eindhoven University of Technology.

History
+
Request History
4 previous requests available
====
Session
+
Session
- 0(null)
====
Request
+
Request

Cake Params
- plugin(null)
- controllerposts
- actionfindByTag
- named(empty)
- pass(array)
  014
- paging(array)
  Post(array)
  page1
  current1
  count1
  prevPage(false)
  nextPage(false)
  pageCount1
  order(array)
  Post.createdDESC
  limit24
  options(array)
  order(array)
  Post.createdDESC
  paramTypenamed
  queryScope(null)
Post data

No post data.

Query string

No querystring data.

Cookie

To view Cookies, add CookieComponent to Controller

Current Route
- keys(array)
  0controller
  1action
- options(array)
  defaultRoute(true)
- defaults(array)
  plugin(null)
- template/:controller/:action/*
====

Sql Log

Sql Logs

default

Total Time: 5 ms
Total Queries: 6 queries

Query	Affected	Num. rows	Took (ms)	Actions
SELECT COUNT(*) AS `count` FROM `ivofilot_nl`.`tags` AS `Tag` WHERE `Tag`.`id` = 14	1	1	0
SELECT `Post`.`id`, `Post`.`title`, `Post`.`content`, `Post`.`watched`, `Post`.`active`, `Post`.`created`, `Post`.`modified` FROM `ivofilot_nl`.`posts` AS `Post` inner JOIN `ivofilot_nl`.`posts_tags` AS `PostsTag` ON (`Post`.`id` = `PostsTag`.`post_id`) inner JOIN `ivofilot_nl`.`tags` AS `Tag` ON (`PostsTag`.`tag_id` = `Tag`.`id`) WHERE `Tag`.`id` = 14 AND `Post`.`active` = '1' ORDER BY `Post`.`created` DESC LIMIT 24	1	1	1
SELECT `Comment`.`email`, `Comment`.`comment`, `Comment`.`id`, `Comment`.`post_id`, `Comment`.`created` FROM `ivofilot_nl`.`comments` AS `Comment` WHERE `Comment`.`post_id` = (14)	0	0	2	maybe slow
SELECT `Tag`.`id`, `Tag`.`name`, `Tag`.`icon`, `Tag`.`color`, `PostsTag`.`post_id`, `PostsTag`.`tag_id` FROM `ivofilot_nl`.`tags` AS `Tag` JOIN `ivofilot_nl`.`posts_tags` AS `PostsTag` ON (`PostsTag`.`post_id` = 14 AND `PostsTag`.`tag_id` = `Tag`.`id`)	2	2	1	maybe slow
SELECT `Tag`.`id`, `Tag`.`name`, `Tag`.`icon`, `Tag`.`color` FROM `ivofilot_nl`.`tags` AS `Tag` WHERE `Tag`.`id` = 14 LIMIT 1	1	1	0
SELECT `Post`.`id`, `Post`.`title`, `Post`.`content`, `Post`.`watched`, `Post`.`active`, `Post`.`created`, `Post`.`modified`, `PostsTag`.`post_id`, `PostsTag`.`tag_id` FROM `ivofilot_nl`.`posts` AS `Post` JOIN `ivofilot_nl`.`posts_tags` AS `PostsTag` ON (`PostsTag`.`tag_id` = 14 AND `PostsTag`.`post_id` = `Post`.`id`)	1	1	1

Query Explain:

Click an "Explain" link above, to see the query explanation.

====

Timer

Memory

Peak Memory Use 4.18 MB

Message	Memory use
Component initialization	791 KB
Controller action start	837 KB
Controller render start	1.29 MB
View render complete	1.48 MB

Timers

Total Request Time: 864 (ms)

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	83.20
Event: Controller.initialize	0.15
Event: Controller.startup	13.59
Controller action	674.62
Event: Controller.beforeRender	53.95
» Processing toolbar data	53.87
Rendering View	8.67
» Event: View.beforeRender	0.04
» Rendering APP/View/Posts/find_by_tag.ctp	1.63
» » Rendering APP/View/Elements/post.posts.ctp	0.64
» Event: View.afterRender	0.01
» Event: View.beforeLayout	0.01
» Rendering APP/View/Layouts/default.ctp	6.54
» » Rendering APP/View/Elements/navbar.ctp	6.16
» » Rendering APP/View/Elements/footer.ctp	0.10
» » » Rendering APP/View/Elements/biography.ctp	0.03
Event: View.afterLayout	0.00

====

Log
+

Logs

There were no log entries made this request

====
Variables
+
View Variables
- tag(array)
  Tag(array)
  id14
  nameSQL
  iconfa fa-cube
  colorinfo
  Post(array)
  0(array)
  id14
  titleToggling a database flag field in CakePHP
  contentSometimes we have to make a data model that involves various flags to indicate different statuses for an object. For example, a Post can have attributes like *active* or *comments_allowed* which can have either the value 0 (off) or 1 (on). Often we wish to toggle these values; how do this in an elegant fashion? (scroll to the bottom for the one-liner) We could grab the value: <pre> <code class="php"> $post = $this->Post->read(null, $id); if($post['Post']['active'] == 1) { $post['Post']['active'] = 0; } else { $post['Post']['active'] = 1; } $this->Post->save($post); </code> </pre> More elegant would be to use a ternary operator like so: <pre> <code class="php"> $post = $this->Post->read(null, $id); $post['Post']['active'] = $post['Post']['active'] == 1 ? 0 : 1; $this->Post->save($post); </code> </pre> But in principle, we do not even need to grab the old value from the database to toggle the value: <pre> <code class="php"> $post = $this->Post->query("UPDATE `posts` SET `active`= IF(`active`=1, 0, 1) WHERE `id`='$id'"); </code> </pre> We can even get rid of the if statement: <pre> <code class="php"> $post = $this->Post->query("UPDATE `posts` SET `active`= 1 - `active` WHERE `id`='$id'"); </code> </pre> And there you go, a simple one-liner.
  watched7051
  active(true)
  created2014-06-07 02:40:34
  modified2015-06-30 17:37:49
- posts(array)
  0(array)
  Post(array)
  id14
  titleToggling a database flag field in CakePHP
  contentSometimes we have to make a data model that involves various flags to indicate different statuses for an object. For example, a Post can have attributes like *active* or *comments_allowed* which can have either the value 0 (off) or 1 (on). Often we wish to toggle these values; how do this in an elegant fashion? (scroll to the bottom for the one-liner) We could grab the value: <pre> <code class="php"> $post = $this->Post->read(null, $id); if($post['Post']['active'] == 1) { $post['Post']['active'] = 0; } else { $post['Post']['active'] = 1; } $this->Post->save($post); </code> </pre> More elegant would be to use a ternary operator like so: <pre> <code class="php"> $post = $this->Post->read(null, $id); $post['Post']['active'] = $post['Post']['active'] == 1 ? 0 : 1; $this->Post->save($post); </code> </pre> But in principle, we do not even need to grab the old value from the database to toggle the value: <pre> <code class="php"> $post = $this->Post->query("UPDATE `posts` SET `active`= IF(`active`=1, 0, 1) WHERE `id`='$id'"); </code> </pre> We can even get rid of the if statement: <pre> <code class="php"> $post = $this->Post->query("UPDATE `posts` SET `active`= 1 - `active` WHERE `id`='$id'"); </code> </pre> And there you go, a simple one-liner.
  watched7051
  active(true)
  created2014-06-07 02:40:34
  modified2015-06-30 17:37:49
  Comment(empty)
  Tag(array)
  0(array)
  id14
  nameSQL
  iconfa fa-cube
  colorinfo
  1(array)
  id6
  nameCakePHP
  iconpictonic-prog-cakephp
  colorprimary
- title_for_layoutBlog
- meta_descriptionThis is the personal website of Ivo Filot. Ivo Filot is a theoretical chemist originating from the Netherlands.
- meta_keywordsIvo Filot, Personal website, Fischer-Tropsch, Microkinetic Modeling
- $request->data(empty)
- $this->validationErrors(array)
  Tag(empty)
  Post(empty)
  Comment(empty)
  PostsTag(empty)
- Loaded Helpers(array)
  0Auth
  1Navbar
  2Download
  3Flag
  4Markdown
  5Number
  6SimpleGraph
  7Paginator
  8DebugTimer
  9Toolbar
  10Html
  11Session
  12HtmlToolbar
  13Form
====

Environment

App Constants

Constant	Value
CONFIG	/customers/e/2/e/ivofilot.nl/httpd.www/app/Config/

CakePHP Constants

Constant	Value
APP	/customers/e/2/e/ivofilot.nl/httpd.www/app/
APP_DIR	app
APPLIBS	/customers/e/2/e/ivofilot.nl/httpd.www/app/Lib/
CACHE	/customers/e/2/e/ivofilot.nl/httpd.www/app/tmp/cache/
CAKE	/customers/e/2/e/ivofilot.nl/httpd.www/lib/Cake/
CAKE_CORE_INCLUDE_PATH	/customers/e/2/e/ivofilot.nl/httpd.www/lib
CORE_PATH	/customers/e/2/e/ivofilot.nl/httpd.www/lib/
CAKE_VERSION	2.10.13
CSS	/customers/e/2/e/ivofilot.nl/httpd.www/app/webroot/css/
CSS_URL	css/
DS	/
FULL_BASE_URL	https://ivofilot.nl
IMAGES	/customers/e/2/e/ivofilot.nl/httpd.www/app/webroot/img/
IMAGES_URL	img/
JS	/customers/e/2/e/ivofilot.nl/httpd.www/app/webroot/js/
JS_URL	js/
LOGS	/customers/e/2/e/ivofilot.nl/httpd.www/app/tmp/logs/
ROOT	/customers/e/2/e/ivofilot.nl/httpd.www
TESTS	/customers/e/2/e/ivofilot.nl/httpd.www/app/Test/
TMP	/customers/e/2/e/ivofilot.nl/httpd.www/app/tmp/
VENDORS	/customers/e/2/e/ivofilot.nl/httpd.www/vendors/
WEBROOT_DIR	webroot
WWW_ROOT	/customers/e/2/e/ivofilot.nl/httpd.www/app/webroot/

PHP Environment

Environment Variable	Value
Php Version	7.4.16
Onecom Domain Name	ivofilot.nl
Onecom Domain Root	/customers/e/2/e/ivofilot.nl/
Onecom Memorylimit	1073741824
Onecom Cpu Shares	1024
Onecom Exec	latest
Onecom Dir Layout Ver	0
Content Length	0
Http Connection	close
Script Name	/app/webroot/index.php
Request Uri	/posts/findByTag/14
Query String
Request Method	GET
Server Protocol	HTTP/1.1
Gateway Interface	CGI/1.1
Redirect Url	/app/webroot/posts/findByTag/14
Remote Port	55536
Script Filename	/customers/e/2/e/ivofilot.nl/httpd.www/app/webroot/index.php
Server Admin	support@one.com
Context Document Root	/var/www
Context Prefix
Request Scheme	https
Remote Addr	100.25.42.117
Server Port	80
Server Addr	10.27.35.20
Server Name	ivofilot.nl
Server Software	Apache
Server Signature
Path	/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin
Http X Varnish	407571560
Http Accept Encoding	gzip
Http X Onecom Host	ivofilot.nl
Http X Onecom Brand	one.com
Http X Forwarded Proto	https
Http X Onecom Forwarded Proto	https
Http X Forwarded For	100.25.42.117
Http Host	ivofilot.nl
Http Accept Language	en-US,en;q=0.5
Http Accept	text/html,application/xhtml+xml,application/xml;q=0.9,/;q=0.8
Http User Agent	CCBot/2.0 (https://commoncrawl.org/faq/)
Env Vcv Env Addons Id	one.com
Env Vcv Token Url	https://wpapi.one.com/api/v1.0/plugins/visualcomposer/activate
Onecom One Photo Url	https://onephoto.one.com/domain_discover
Onecom Wp Addons Api	https://wpapi.one.com
Onecom Webshop Host	webshop2.cst.webpod8-cph3.one.com
Https	on
Onecom Tmpdir	/customers/e/2/e/ivofilot.nl//tmp
Domain Name	ivofilot.nl
Onecom Document Root	/customers/e/2/e/ivofilot.nl/httpd.www
Document Root	/customers/e/2/e/ivofilot.nl/httpd.www
Redirect Status	200
Redirect Env Vcv Env Addons Id	one.com
Redirect Env Vcv Token Url	https://wpapi.one.com/api/v1.0/plugins/visualcomposer/activate
Redirect Onecom One Photo Url	https://onephoto.one.com/domain_discover
Redirect Onecom Wp Addons Api	https://wpapi.one.com
Redirect Onecom Webshop Host	webshop2.cst.webpod8-cph3.one.com
Redirect Https	on
Redirect Onecom Cpu Shares	1024
Redirect Onecom Memorylimit	1073741824
Redirect Onecom Exec	latest
Redirect Onecom Dir Layout Ver	0
Redirect Onecom Tmpdir	/customers/e/2/e/ivofilot.nl//tmp
Redirect Onecom Domain Root	/customers/e/2/e/ivofilot.nl/
Redirect Onecom Domain Name	ivofilot.nl
Redirect Domain Name	ivofilot.nl
Redirect Onecom Document Root	/customers/e/2/e/ivofilot.nl/httpd.www
Redirect Document Root	/customers/e/2/e/ivofilot.nl/httpd.www
Redirect Redirect Status	200
Redirect Redirect Env Vcv Env Addons Id	one.com
Redirect Redirect Env Vcv Token Url	https://wpapi.one.com/api/v1.0/plugins/visualcomposer/activate
Redirect Redirect Onecom One Photo Url	https://onephoto.one.com/domain_discover
Redirect Redirect Onecom Wp Addons Api	https://wpapi.one.com
Redirect Redirect Onecom Webshop Host	webshop2.cst.webpod8-cph3.one.com
Redirect Redirect Https	on
Redirect Redirect Onecom Cpu Shares	1024
Redirect Redirect Onecom Memorylimit	1073741824
Redirect Redirect Onecom Exec	latest
Redirect Redirect Onecom Dir Layout Ver	0
Redirect Redirect Onecom Tmpdir	/customers/e/2/e/ivofilot.nl//tmp
Redirect Redirect Onecom Domain Root	/customers/e/2/e/ivofilot.nl/
Redirect Redirect Onecom Domain Name	ivofilot.nl
Redirect Redirect Domain Name	ivofilot.nl
Redirect Redirect Onecom Document Root	/customers/e/2/e/ivofilot.nl/httpd.www
Redirect Redirect Document Root	/customers/e/2/e/ivofilot.nl/httpd.www
Fcgi Role	RESPONDER
Php Self	/app/webroot/index.php
Request Time Float	1619012129.209
Request Time	1619012129

====

Include
+
Included Files

Include Paths
- 0/customers/e/2/e/ivofilot.nl/httpd.www/lib
- 2/usr/share/php
- 3-> /customers/e/2/e/ivofilot.nl/httpd.www/lib/Cake/
Included Files
- core(array)
  Behavior(array)
  0CORE/Model/Behavior/TreeBehavior.php
  Cache(array)
  0CORE/Cache/Cache.php
  1CORE/Cache/Engine/FileEngine.php
  2CORE/Cache/CacheEngine.php
  Component(array)
  0CORE/Controller/Component/SessionComponent.php
  1CORE/Controller/Component/AuthComponent.php
  2CORE/Controller/Component/Auth/FormAuthenticate.php
  3CORE/Controller/Component/Auth/BaseAuthenticate.php
  4CORE/Controller/Component/PaginatorComponent.php
  Config(array)
  0CORE/Config/routes.php
  1CORE/Config/config.php
  Controller(array)
  0CORE/Controller/Controller.php
  1CORE/Controller/ComponentCollection.php
  2CORE/Controller/Component.php
  Datasource(array)
  0CORE/Model/Datasource/CakeSession.php
  1CORE/Model/Datasource/Database/Mysql.php
  2CORE/Model/Datasource/DboSource.php
  3CORE/Model/Datasource/DataSource.php
  Error(array)
  0CORE/Error/exceptions.php
  1CORE/Error/ErrorHandler.php
  I18n(array)
  0CORE/I18n/I18n.php
  1CORE/I18n/L10n.php
  Log(array)
  0CORE/Log/CakeLog.php
  1CORE/Log/LogEngineCollection.php
  2CORE/Log/Engine/FileLog.php
  3CORE/Log/Engine/BaseLog.php
  4CORE/Log/CakeLogInterface.php
  Model(array)
  0CORE/Model/Model.php
  1CORE/Model/BehaviorCollection.php
  2CORE/Model/ConnectionManager.php
  3CORE/Model/ModelBehavior.php
  Network(array)
  0CORE/Network/CakeRequest.php
  1CORE/Network/CakeResponse.php
  Other(array)
  0CORE/bootstrap.php
  1CORE/basics.php
  2CORE/Core/App.php
  3CORE/Core/Configure.php
  4CORE/Core/CakePlugin.php
  5CORE/Event/CakeEventListener.php
  6CORE/Event/CakeEvent.php
  7CORE/Event/CakeEventManager.php
  8CORE/Core/CakeObject.php
  Routing(array)
  0CORE/Routing/Dispatcher.php
  1CORE/Routing/Filter/AssetDispatcher.php
  2CORE/Routing/DispatcherFilter.php
  3CORE/Routing/Filter/CacheDispatcher.php
  4CORE/Routing/Router.php
  5CORE/Routing/Route/CakeRoute.php
  6CORE/Routing/Route/PluginShortRoute.php
  Utility(array)
  0CORE/Utility/Hash.php
  1CORE/Utility/Inflector.php
  2CORE/Utility/ObjectCollection.php
  3CORE/Utility/Debugger.php
  4CORE/Utility/CakeText.php
  5CORE/Utility/ClassRegistry.php
  View(array)
  0CORE/View/HelperCollection.php
- app(array)
  Config(array)
  0APP/Config/core.php
  1APP/Config/bootstrap.php
  2APP/Config/routes.php
  3APP/Config/database.php
  Controller(array)
  0APP/Controller/PostsController.php
  1APP/Controller/AppController.php
  Model(array)
  0APP/Model/Tag.php
  1APP/Model/AppModel.php
  2APP/Model/Post.php
  3APP/Model/Comment.php
  Other(array)
  0APP/webroot/index.php
- plugins(array)
  DebugKit(array)
  Component(array)
  0DebugKit/Controller/Component/ToolbarComponent.php
  Plugin(array)
  0DebugKit/Lib/DebugMemory.php
  1DebugKit/Lib/Panel/HistoryPanel.php
  2DebugKit/Lib/DebugPanel.php
  3DebugKit/Lib/Panel/SessionPanel.php
  4DebugKit/Lib/Panel/RequestPanel.php
  5DebugKit/Lib/Panel/SqlLogPanel.php
  6DebugKit/Lib/Panel/TimerPanel.php
  7DebugKit/Lib/Panel/LogPanel.php
  8DebugKit/Lib/Log/Engine/DebugKitLog.php
  9DebugKit/Lib/Panel/VariablesPanel.php
  10DebugKit/Lib/Panel/EnvironmentPanel.php
  11DebugKit/Lib/Panel/IncludePanel.php
  12DebugKit/Lib/DebugTimer.php
  Markdown(array)
  Config(array)
  0Markdown/Config/bootstrap.php
  Plugin(array)
  0Markdown/Lib/Error/MarkdownExceptions.php
====

SQL

Questions or Comments?

Biography

Request History

Session

Request

Cake Params

Post data

Query string

Cookie

Current Route

Sql Logs

default

Total Time: 5 ms Total Queries: 6 queries

Query Explain:

Memory

Timers

Logs

View Variables

App Constants

CakePHP Constants

PHP Environment

Included Files

Include Paths

Included Files

Total Time: 5 ms
Total Queries: 6 queries