Imaginus.org

VoDaoDb |

VoDaoDb

Purpose: Productivity, Efficiency, OOP Design Practice, Flex for AIR Desktop Practice, More Fun

Tools: Adobe Flex 4.6 for AIR Desktop (ActionScript 3, MXML), PHP, MySQL, Flash Builder 4.6, MySQL Workbench, Lita

Summary: A desktop application used to “read” a MySQL database and generate an object oriented framework based on the database schema using best-practices & design patterns.

Created several reusable Flex components that are duplicated several times in the application.
Created a PHP class that receives user authentication data from the application, queries database schema accessible by the authentication data provided. Returns an error response or the database schema to the application in a JSON structure.
Uses the returned data to allowing the user to select a database, inspect all table & column data.
On selection the user is prompted to provide data for a package structure & coding style preferences.
The data is used to generate PHP, ActionScript 3, MXML, XHTML, & Javascript: Value Objects, Data Access Objects, Item Renderers, Database Singletons, Object repositories, Factory classes, Typed Iterable Collections, etc. (as per language).
Generated classes & objects are fully documented using JavaDoc style comments.
The generated class & method names are “self-commenting”
E.g.$selector = new UserSelector(); $selector->select()->username("LIKE", "%ob%")->orWith()->pwd("LIKE", "%ecret%")->andWith() ->userId(">", 3)->andWith()->userId("<", 19)->orderBy("`user_id`", "ASC")->limit(0, 15); /*Generates: “SELECT * FROM `user` WHERE `user`.`username` LIKE '%ob%' OR `user`.`pwd` LIKE '%ecret%' AND `user`.`user_id` > 3 AND `user`.`user_id` < 19 ORDER BY `user_id` ASC LIMIT 0, 15”*/ $resultCollection = $selector->fetch();//Returns a UserCollection() object that implements PHP's built in iterator interface & therefore can be used just like an array.

So, in the case of the SocialEngine 4 Db used in the slides above (with 121 tables), I generated 488+242+855 = 1,585 fully Doc commented object-oriented classes that implement best practices & ≈5 design patterns. All classes have consistent structure, method & property names -- all in a matter of 2 minutes.

Averaging ≈300+ lines each, that's 1,585 * 300 = 475,500+ lines of code & comments I didn't have to type, but can immediately use!

Apart for the “individual” classes, all table classes have interfaces for shared methods that are implemented in abstract base classes. In addition, all the table classes define a Base{TableNameType} class and an empty child class that extends it. This allows regeneration & replacement of the base classes if the Db is modified, while the child classes can implement custom methods and remain untouched (unless a property name is changed so that the method needs updating to reflect the change).

So long as you understand, and design, 3NF+ (Third Normal Form or better) databases, manipulating your Db data is actually fun using these classes (especially using an IDE that's good at parsing code & comments for code completion / hinting [I designed it that way ㋡ ß) ]).

VoDaoDb PHP Code Examples

Please keep in mind that, though I did not manually “write” these classes, I did design and build the Flex / AIR desktop application, PHP, & ActionScript classes that query & model the database and then use the schema to generate , format, and write the files to disk.

Patterns & architecture were mostly inspired by Matt Zandstra's book: “PHP Objects, Patterns, & Practices”

DbExchange.class.php - The “Exchange” VO Repository

1	<?php
2	//namespace org/imaginus/pogopogoSe4/php/vodaodb/
3
4
5	/////// YOU CAN PUT CUSTOM CODE HERE AT YOUR OWN RISK!
6	/////// BUT BE WARY OF OVERWRITING THIS FILE IF YOU DO!
7
8
9	/************************************************
10	* Generated by VoDaoDb Wed Jul 3 18:14:00 GMT-0400 2013
11	* @author Todd Mullen, <AnEmail@gmail.com>)
12	* @copyright Do whatever you want except sell my work as yours, or reverse engineer it so you can make changes and then sell that as yours.
13	* @license @see copyright
14	* @filesource VoDaoDb v0.9 - Imaginus.org
15	*
16	*****************
17	* Project: pogopogoSe4
18	* Parent: imaginus.org
19	* //No class comments
20	************************************************/
21
22
23	if ( 0 > version_compare( PHP_VERSION, '5' ) ) {
24	die( 'This file was generated for PHP 5' );
25	}
26
27
28
29
30	/**
31	* DbExchange acts as a warehouse for Value Objects. It tracks raw row data & created instances.
32	* It also keeps track of the VOs' states so that all new INSERTs, UPDATEs, &/or DELETEs can be performed at the end of execution rather than throughout.
33	* It is a singleton class, so if/when a VO is pulled from the db or instantiated,
34	* DbExchange will retain a reference to it and prevent fetching or instantiating the same object twice.
35	*
36	* @access public
37	* @author Todd Mullen - ???, <AnEmail@gmail.com>
38	*/
39	class DbExchange {
40
41
42	// --- ATTRIBUTES ---
43
44
45
46	// --- TABLE & VIEW NAME CONSTANTS ---
47	const DEV_DATA = "dev_data";
48	const E4_ACTIVITY_ACTIONS = "E4_activity_actions";
49	const E4_ACTIVITY_ACTIONSETTINGS = "E4_activity_actionsettings";
50	const E4_ACTIVITY_ACTIONTYPES = "E4_activity_actiontypes";
51	const E4_ACTIVITY_ATTACHMENTS = "E4_activity_attachments";
52	const E4_ACTIVITY_COMMENTS = "E4_activity_comments";
53	const E4_ACTIVITY_LIKES = "E4_activity_likes";
54	const E4_ACTIVITY_NOTIFICATIONS = "E4_activity_notifications";
55	const E4_ACTIVITY_NOTIFICATIONSETTINGS = "E4_activity_notificationsettings";
56	const E4_ACTIVITY_NOTIFICATIONTYPES = "E4_activity_notificationtypes";
57	const E4_ACTIVITY_STREAM = "E4_activity_stream";
58	const E4_ALBUM_ALBUMS = "E4_album_albums";
59	const E4_ALBUM_CATEGORIES = "E4_album_categories";
60	const E4_ALBUM_PHOTOS = "E4_album_photos";
61	const E4_ANNOUNCEMENT_ANNOUNCEMENTS = "E4_announcement_announcements";
62	const E4_AUTHORIZATION_ALLOW = "E4_authorization_allow";
63	const E4_AUTHORIZATION_LEVELS = "E4_authorization_levels";
64	const E4_AUTHORIZATION_PERMISSIONS = "E4_authorization_permissions";
65	const E4_BLOG_BLOGS = "E4_blog_blogs";
66	const E4_BLOG_CATEGORIES = "E4_blog_categories";
67	const E4_BLOG_SUBSCRIPTIONS = "E4_blog_subscriptions";
68	const E4_CHAT_BANS = "E4_chat_bans";
69	const E4_CHAT_EVENTS = "E4_chat_events";
70	const E4_CHAT_MESSAGES = "E4_chat_messages";
71	const E4_CHAT_ROOMS = "E4_chat_rooms";
72	const E4_CHAT_ROOMUSERS = "E4_chat_roomusers";
73	const E4_CHAT_USERS = "E4_chat_users";
74	const E4_CHAT_WHISPERS = "E4_chat_whispers";
75	const E4_CORE_ADCAMPAIGNS = "E4_core_adcampaigns";
76	const E4_CORE_ADPHOTOS = "E4_core_adphotos";
77	const E4_CORE_ADS = "E4_core_ads";
78	const E4_CORE_AUTH = "E4_core_auth";
79	const E4_CORE_BANNEDEMAILS = "E4_core_bannedemails";
80	const E4_CORE_BANNEDIPS = "E4_core_bannedips";
81	const E4_CORE_BANNEDUSERNAMES = "E4_core_bannedusernames";
82	const E4_CORE_BANNEDWORDS = "E4_core_bannedwords";
83	const E4_CORE_COMMENTS = "E4_core_comments";
84	const E4_CORE_CONTENT = "E4_core_content";
85	const E4_CORE_GEOTAGS = "E4_core_geotags";
86	const E4_CORE_JOBS = "E4_core_jobs";
87	const E4_CORE_JOBTYPES = "E4_core_jobtypes";
88	const E4_CORE_LANGUAGES = "E4_core_languages";
89	const E4_CORE_LIKES = "E4_core_likes";
90	const E4_CORE_LINKS = "E4_core_links";
91	const E4_CORE_LISTITEMS = "E4_core_listitems";
92	const E4_CORE_LISTS = "E4_core_lists";
93	const E4_CORE_LOG = "E4_core_log";
94	const E4_CORE_MAIL = "E4_core_mail";
95	const E4_CORE_MAILRECIPIENTS = "E4_core_mailrecipients";
96	const E4_CORE_MAILTEMPLATES = "E4_core_mailtemplates";
97	const E4_CORE_MENUITEMS = "E4_core_menuitems";
98	const E4_CORE_MENUS = "E4_core_menus";
99	const E4_CORE_MIGRATIONS = "E4_core_migrations";
100	const E4_CORE_MODULES = "E4_core_modules";
101	const E4_CORE_NODES = "E4_core_nodes";
102	const E4_CORE_PAGES = "E4_core_pages";
103	const E4_CORE_PROCESSES = "E4_core_processes";
104	const E4_CORE_REFERRERS = "E4_core_referrers";
105	const E4_CORE_REPORTS = "E4_core_reports";
106	const E4_CORE_ROUTES = "E4_core_routes";
107	const E4_CORE_SEARCH = "E4_core_search";
108	const E4_CORE_SERVICEPROVIDERS = "E4_core_serviceproviders";
109	const E4_CORE_SERVICES = "E4_core_services";
110	const E4_CORE_SERVICETYPES = "E4_core_servicetypes";
111	const E4_CORE_SESSION = "E4_core_session";
112	const E4_CORE_SETTINGS = "E4_core_settings";
113	const E4_CORE_STATISTICS = "E4_core_statistics";
114	const E4_CORE_STATUS = "E4_core_status";
115	const E4_CORE_STYLES = "E4_core_styles";
116	const E4_CORE_TAGMAPS = "E4_core_tagmaps";
117	const E4_CORE_TAGS = "E4_core_tags";
118	const E4_CORE_TASKS = "E4_core_tasks";
119	const E4_CORE_THEMES = "E4_core_themes";
120	const E4_INVITES = "E4_invites";
121	const E4_MESSAGES_CONVERSATIONS = "E4_messages_conversations";
122	const E4_MESSAGES_MESSAGES = "E4_messages_messages";
123	const E4_MESSAGES_RECIPIENTS = "E4_messages_recipients";
124	const E4_NETWORK_MEMBERSHIP = "E4_network_membership";
125	const E4_NETWORK_NETWORKS = "E4_network_networks";
126	const E4_PAYMENT_GATEWAYS = "E4_payment_gateways";
127	const E4_PAYMENT_ORDERS = "E4_payment_orders";
128	const E4_PAYMENT_PACKAGES = "E4_payment_packages";
129	const E4_PAYMENT_PRODUCTS = "E4_payment_products";
130	const E4_PAYMENT_SUBSCRIPTIONS = "E4_payment_subscriptions";
131	const E4_PAYMENT_TRANSACTIONS = "E4_payment_transactions";
132	const E4_SEAOCORE_LOCATIONS = "E4_seaocore_locations";
133	const E4_SEAOCORE_SEARCHFORMSETTING = "E4_seaocore_searchformsetting";
134	const E4_SEAOCORE_TABS = "E4_seaocore_tabs";
135	const E4_SEAOCORES = "E4_seaocores";
136	const E4_SITELIKE_MIXSETTINGS = "E4_sitelike_mixsettings";
137	const E4_SITELIKE_MYSETTINGS = "E4_sitelike_mysettings";
138	const E4_SITELIKE_SETTINGS = "E4_sitelike_settings";
139	const E4_SITESLIDESHOW_IMAGES = "E4_siteslideshow_images";
140	const E4_SITESLIDESHOWS = "E4_siteslideshows";
141	const E4_STORAGE_CHUNKS = "E4_storage_chunks";
142	const E4_STORAGE_FILES = "E4_storage_files";
143	const E4_STORAGE_MIRRORS = "E4_storage_mirrors";
144	const E4_STORAGE_SERVICES = "E4_storage_services";
145	const E4_STORAGE_SERVICETYPES = "E4_storage_servicetypes";
146	const E4_USER_BLOCK = "E4_user_block";
147	const E4_USER_FACEBOOK = "E4_user_facebook";
148	const E4_USER_FIELDS_MAPS = "E4_user_fields_maps";
149	const E4_USER_FIELDS_META = "E4_user_fields_meta";
150	const E4_USER_FIELDS_OPTIONS = "E4_user_fields_options";
151	const E4_USER_FIELDS_SEARCH = "E4_user_fields_search";
152	const E4_USER_FIELDS_VALUES = "E4_user_fields_values";
153	const E4_USER_FORGOT = "E4_user_forgot";
154	const E4_USER_JANRAIN = "E4_user_janrain";
155	const E4_USER_LISTITEMS = "E4_user_listitems";
156	const E4_USER_LISTS = "E4_user_lists";
157	const E4_USER_LOGINS = "E4_user_logins";
158	const E4_USER_MEMBERSHIP = "E4_user_membership";
159	const E4_USER_ONLINE = "E4_user_online";
160	const E4_USER_SETTINGS = "E4_user_settings";
161	const E4_USER_SIGNUP = "E4_user_signup";
162	const E4_USER_TWITTER = "E4_user_twitter";
163	const E4_USER_VERIFY = "E4_user_verify";
164	const E4_USERS = "E4_users";
165	const E4_VIDEO_CATEGORIES = "E4_video_categories";
166	const E4_VIDEO_RATINGS = "E4_video_ratings";
167	const E4_VIDEO_VIDEOS = "E4_video_videos";
168
169
170
171	/**
172	* Static variable that holds the single instance of ValueObjects::Store().
173	* Private so that it cannot be accessed directly.
174	* Access via the static instance() method which creates the actual instance
175	* it hasn't already ben created.
176	*
177	* @access private
178	* @var DbExchange
179	*/
180	private static $_instance = null;
181
182
183	/**
184	* Holds a copy of all value objects that have been instantiated.
185	* //TODO: Refactor this as a multidimensional array with aryNew, aryClean,
186	* and aryDeleted as its four children. Rather than shuffling objects
187	* arrays, change the "status" entry for each DO.
188	*
189	* @access private
190	* @var array
191	*/
192	private $_aryAll = array();
193
194
195	/**
196	* Holds a copy of all domain objects that are marked for Db `INSERT`
197	*
198	* @access private
199	* @var array
200	*/
201	private $_aryNew = array();
202
203
204	/**
205	* Holds a copy of all domain objects that do not need require any Db activity
206	*
207	* @access private
208	* @var array
209	*/
210	private $_aryClean = array();
211
212
213	/**
214	* Holds a copy of all domain objects that are marked for Db `UPDATE`
215	*
216	* @access private
217	* @var array
218	*/
219	private $_aryDirty = array();
220
221
222	/**
223	* Holds a copy of all domain objects that are marked for Db `DELETE`
224	*
225	* @access private
226	* @var array
227	*/
228	private $_aryDeleted = array();
229
230
231	// --- OPERATIONS --- //
232
233
234	/**
235	* Static accessor method for acquiring the DbExchange singleton
236	*
237	* @access public
238	* @author Todd Mullen - ???, <AnEmail@gmail.com>
239	* @return DbExchange
240	*/
241	static public function Store() {
242	if( empty( self::$_instance ) ) {
243	self::$_instance = new self();
244	}
245	return self::$_instance;
246	}//End Store()
247
248
249	/**
250	* The constructor is private to prevent creating a second / different copy of DbExchange
251	* @access private
252	* @author Todd Mullen - ???, <AnEmail@gmail.com>
253	* @return void
254	*/
255	private function __construct() {
256	//Nothing to do here
257	}//End __construct()
258
259
260	/**
261	* Pushes a new $vo into $aryAll and $aryNew ( if not already set )
262	*
263	* @access public
264	* @author Todd Mullen - ???, <AnEmail@gmail.com>
265	* @param AbstractValueObject $vo
266	* @return void
267	*/
268	public function addNew( AbstractValueObject $vo ) {
269	if( $vo->isView ){return;}
270	echo "<b>" . __METHOD__ . "()</b><br/>";
271	//if( !in_array( $vo, $this->_aryAll, true ) ) {
272	//$this->_aryAll[] = $vo;
273	//echo "Added to aryAll: $vo<br />";
274	//}
275	//if( !in_array( $vo, $this->_aryNew, true ) ) {
276	$this->_aryNew[] = $vo;
277	echo "Marked As New: $vo<br />";
278	//}
279	echo "<br/>";
280	}//End addNew()
281
282
283	/**
284	* Pushes $vo into $aryAll if not already set
285	* Relocates $vo to $aryClean if it is in $aryNew (to be INSERTed), $aryDirty (to be UPDATEd), or $aryDeleted (to be DELETEd)
286	*
287	* @access public
288	* @author Todd Mullen - ???, <AnEmail@gmail.com>
289	* @param AbstractValueObject $vo
290	* @return void
291	*/
292	public function addClean( AbstractValueObject $vo ) {
293	echo "<b>" . __METHOD__ . "()</b><br/>";
294	$key = $vo->globalKeyStr();//$this->globalKey( $vo );
295	if( !in_array( $vo, $this->_aryAll, true ) ) {
296	$this->_aryAll[$key] = $vo;
297	echo "Added to aryAll: $vo.<br />";
298	}
299	if( !in_array( $vo, $this->_aryClean, true ) ) {
300	$this->_aryClean[$key] = $vo;
301	echo "Added to aryClean: $vo.<br />";
302	}
303	//Filter the new objects
304	//echo "Trim aryNew. ";
305	//$this->_aryNew =
306	//$this->trimDoFromAry( $this->_aryNew, $vo );
307	//Filter the dirty objects
308	echo "Trim aryDirty. ";
309	//$this->_aryDirty =
310	//$this->trimDoFromAry( $this->_aryDirty, $vo );
311	//Filter the deleted objects
312	echo "Trim aryDeleted. ";
313	//$this->_aryDeleted =
314	//$this->trimDoFromAry( $this->_aryDeleted, $vo );
315	echo "Trimming aryDeleted and aryDirty<br/>";
316	unset( $this->_aryDirty[$key], $this->_aryDeleted[$key] );
317	echo "Marked As Clean: $vo<br/>";
318	}//End addClean()
319
320
321	/**
322	* Pushes $vo into $aryAll if not already set
323	* Relocates $vo to $aryDirty if it is in $aryNew, $aryClean, or $aryDeleted
324	*
325	* @access public
326	* @author Todd Mullen - ???, <AnEmail@gmail.com>
327	* @param AbstractValueObject $vo
328	* @return void
329	*/
330	public function addDirty( AbstractValueObject $vo ) {
331	if( $vo->isView ){return;}
332	echo "<b>" . __METHOD__ . "()</b><br/>";
333	$key = $vo->globalKeyStr();//$this->globalKey( $vo );
334	if( !in_array( $vo, $this->_aryAll, true ) ) {
335	$this->_aryAll[$key] = $vo;
336	echo "Added to aryAll: $vo.<br />";
337	}
338	if( !in_array( $vo, $this->_aryDirty, true ) ) {
339	$this->_aryDirty[$key] = $vo;
340	echo "Added to aryDirty: $vo.<br />";
341	}
342	//$key = $this->globalKey( $vo );
343	echo "Trimming aryNew, aryClean, and aryDeleted<br/>";
344	unset( $this->_aryNew[$key], $this->_aryClean[$key], $this->_aryDeleted[$key] );
345	//Filter the new objects
346	//echo "Trim aryNew. ";
347	//$this->_aryNew =
348	//$this->trimDoFromAry( $this->_aryNew, $vo );
349	//Filter the clean objects
350	//echo "Trim aryClean. ";
351	//$this->_aryClean =
352	//$this->trimDoFromAry( $this->_aryClean, $vo );
353	//Filter the deleted objects
354	//echo "Trim aryDeleted. ";
355	//$this->_aryDeleted =
356	//$this->trimDoFromAry( $this->_aryDeleted, $vo );
357	echo "Marked As Dirty: $vo<br/>";
358	}//End addDirty()
359
360
361	/**
362	* Pushes $vo into $aryAll if not already set
363	* Relocates $vo if it is in $aryNew, $aryDirty, or $aryClean
364	*
365	* @access public
366	* @author Todd Mullen - ???, <AnEmail@gmail.com>
367	* @param AbstractValueObject $vo
368	* @return null
369	*/
370	public function addDeleted( AbstractValueObject $vo ) {
371	if( $vo->isView ){return;}
372	echo "<b>" . __METHOD__ . "()</b><br/>";
373	$key = $vo->globalKeyStr();//$this->globalKey( $vo );
374	if( !in_array( $vo, $this->_aryAll, true ) ) {
375	$this->_aryAll[$key] = $vo;
376	echo "Added to aryAll: $vo.<br />";
377	}
378	if( !in_array( $vo, $this->_aryDeleted, true ) ) {
379	$this->_aryDeleted[$key] = $vo;
380	echo "Added to aryDeleted: $vo.<br />";
381	}
382	// $key = $this->globalKey( $vo );
383	echo "Trimming aryNew, aryClean, and aryDirty<br/>";
384	unset( $this->_aryNew[$key], $this->_aryClean[$key], $this->_aryDirty[$key] );
385	//Filter the new objects
386	//echo "Trim aryNew.";
387	//$this->_aryNew =
388	//$this->trimDoFromAry( $this->_aryNew, $vo );
389	//Filter the clean objects
390	//echo "Trim aryClean.";
391	//$this->_aryClean =
392	//$this->trimDoFromAry( $this->_aryClean, $vo );
393	//Filter the deleted objects
394	//echo "Trim aryDirty.";
395	//$this->_aryDirty =
396	//$this->trimDoFromAry( $this->_aryDirty, $vo );
397	echo "Marked As Deleted: $vo<br/>";
398	}//End addDeleted()
399
400
401	/**
402	* Executes all INSERT, UPDATE, & DELETE operations by calling
403	* commitInserts(), commitUpdates(), & commitDeletes() sequentially.
404	*
405	* @access public
406	* @author Todd Mullen - ???, <AnEmail@gmail.com>
407	* @return bool Returns true if all operations perform successfully, false otherwise.
408	*/
409	public function commitAll() {
410	echo "<b>" . __METHOD__ . "()</b>...<br/>";
411	if( !$this->commitInserts() ) {
412	echo "Inserts failed<br />";
413	return false;
414	}
415	if( !$this->commitUpdates() ) {
416	echo "Updates failed<br />";
417	return false;
418	}
419	if( !$this->commitDeletes() ) {
420	echo "Deletes failed<br />";
421	return false;
422	}
423	echo "Commited all database synchronizations.<br />";
424	return true;
425	}//End commitAll()
426
427
428	/**
429	* Executes all INSERT operations.
430	*
431	* @access public
432	* @author Todd Mullen - ???, <AnEmail@gmail.com>
433	* @return bool
434	*/
435	public function commitInserts() {
436	$errAry = array();
437	$ttl = count( $this->_aryNew );
438	echo "Inserting ( " . $ttl . " ) VO objects...<br/>";
439	for ( $i = 1; $i < $ttl + 1; $i++ ){ // as $vo ) {
440	/* @var $vo AbstractValueObject */
441	$vo = array_shift( $this->_aryNew );
442	echo "<hr/>Removed New #$i : $vo<br/>";
443	//unset( $this->_aryNew[$i] );
444	//This is to prevent the indexes from getting out of whack when the objects are removed.
445	//if( count( $this->_aryNew ) == 0 ){$this->_aryNew = array();}
446	if( $vo->map()->insert( $vo ) ) {
447	$this->addClean( $vo );
448	} else {
449	$this->_aryNew[$i . "xErr"] = $vo;
450	$errAry[] = "Failed Insert: " . $vo->getKeyStr();
451	}
452	}
453	if( count( $errAry ) != 0 ) {
454	echo "Insert Errors: <hr />" . print_r( $errAry, true ) . "<hr />";
455	return false;
456	}
457	return true;
458	}//End commitInserts()
459
460
461	/**
462	* Executes all UPDATE operations.
463	*
464	* @access public
465	* @author Todd Mullen - ???, <AnEmail@gmail.com>
466	* @return bool
467	*/
468	public function commitUpdates() {
469	$errAry = array();
470	echo "Updating ( ". count( $this->_aryDirty ) ." ) VO objects...<br/>";
471	foreach ( $this->_aryDirty as $vo ) {
472	/* @var $vo AbstractValueObject */
473	if( $vo->map()->update( $vo ) ) {
474	$this->addClean( $vo );
475	} else {
476	$errAry[] = "Failed Insert: " . $vo->getKeyStr();
477	}
478	}
479	if( count( $errAry ) != 0 ) {
480	echo "Update Errors: <hr />" . print_r( $errAry, true ) . "<hr />";
481	return false;
482	}
483	return true;
484	}//End commitUpdates()
485
486
487	/**
488	* Executes all DELETE operations.
489	*
490	* @access public
491	* @author Todd Mullen - ???, <AnEmail@gmail.com>
492	* @return bool
493	*/
494	public function commitDeletes() {
495	$errAry = array();
496	echo "Deleting ( ". count( $this->_aryDeleted ) ." ) VO objects...<br/>";
497	foreach ( $this->_aryDeleted as $vo ) {
498	/* @var $vo AbstractValueObject */
499	if( $vo->map()->delete( $vo ) ) {
500	//Remove the $vo from the watcher arrays
501	echo "Trim aryAll & aryDeleted<br/>";
502	//$this->_aryAll =
503	$key = $this->globalKey( $vo );
504	unset( $this->_aryAll[$key], $this->_aryDeleted[$key] );
505	//$this->trimDoFromAry( $this->_aryAll, $vo );
506	//echo "Trim from aryDeleted: ";
507	//$this->_aryDeleted =
508	//$this->trimDoFromAry( $this->_aryDeleted, $vo );
509	unset( $key, $vo );
510	} else {
511	$errAry[] = "Failed Delete: " . $vo->getKeyStr();
512	}
513	}
514	if( count( $errAry ) != 0 ) {
515	echo "Delete Errors: <hr />" . print_r( $errAry, true ) . "<hr />";
516	return false;
517	}
518	return true;
519	}//End commitDeletes()
520
521
522	/**
523	* Empties all objects from all arrays.
524	*/
525	public function removeAll() {
526	echo __METHOD__ . " Removing all object references.<br/>";
527	$this->_aryAll = $this->_aryClean = $this->_aryDeleted = $this->_aryDirty = $this->_aryNew = array();
528	}//End removeAll()
529
530
531	/**
532	* DbExchange::has() accepts a class name and a key string and uses them to determine if it has the data that corresponds to that instance/row.
533	*
534	*
535	* @access public
536	* @author Todd Mullen - ???, <AnEmail@gmail.com>
537	* @param string classname
538	* @param mixed id - An int or string
539	* @return mixed AbstractValueObject \|\| null
540	*/
541	public function has( $classname, $voKeyStr ) {
542	$key = $classname . $voKeyStr;
543	echo "<b>" . __METHOD__ . "()</b> Looking for '$key'<br/>";
544	if( isset ( $this->_aryAll[$key] ) ) {
545	return $this->_aryAll[$key];
546	}
547	return null;
548	}//End has()
549
550
551	/**
552	* Returns a unique identifier for each concrete domain object by concatenating
553	* the object's classname with it's table primary key string.
554	*
555	* @access private
556	* @author Todd Mullen - ???, <AnEmail@gmail.com>
557	* @param AbstractValueObject $vo
558	* @return string
559	*/
560	private function globalKey( AbstractValueObject $vo ) {
561	$key = get_class( $vo ) . "." . $vo->getKeyStr();
562	return $key;
563	}//End globalKey()
564
565
566	// --- Utility Methods ---
567
568
569	public function Summary() {
570	return "<code><div><h3>".__METHOD__."</h3>"
571	. $this->dumpClean() . $this->dumpNew() . $this->dumpDirty() . $this->dumpDeleted(). $this->dumpAllAry()
572	. "</div></code>";
573	}//End Summary()
574
575
576	public function dumpAllAry() {
577	return "<div> ( " . count( $this->_aryAll ) . " ) <b>All VOs</b>:" . $this->dumpAry( $this->_aryAll ) . "</div>";
578	}//End dumpAllAry()
579
580
581	public function dumpNew() {
582	return "<div> ( " . count( $this->_aryNew ) . " ) <b>New VOs</b>:" . $this->dumpAry( $this->_aryNew ) . "</div>";
583	}//End dumpNew()
584
585
586	public function dumpClean() {
587	return "<div> ( " . count( $this->_aryClean ) . " ) <b>Clean VOs</b>:" . $this->dumpAry( $this->_aryClean ) . "</div>";
588	}//End dumpClean()
589
590
591	public function dumpDirty() {
592	return "<div> ( " . count( $this->_aryDirty ) . " ) <b>Dirty VOs</b>:" . $this->dumpAry( $this->_aryDirty ) . "</div>";
593	}//End dumpDirty()
594
595
596	public function dumpDeleted() {
597	return "<div> ( " . count( $this->_aryDeleted ) . " ) <b>Deleted VOs</b>:" . $this->dumpAry( $this->_aryDeleted ) . "</div>";
598	}//End dumpDeleted()
599
600
601	protected function dumpAry( $ary ) {
602	if( count( $ary ) == 0 ){ return " <i>Empty</i>";}
603	$str = "<br />";
604	foreach ( $ary as $key => $value ) {
605	$str .= "Key '$key': $value<br />";
606	}
607	//. implode( "<br />", $ary );
608	return $str;
609	}//End dumpAry()
610
611
612	public function __toString() {
613	return self::Store()->Summary();
614	}//End __toString()
615
616
617	public function __clone() {
618	throw new Exception( __CLASS__ . ' cannot be cloned or duplicated.' );
619	}//End __clone()
620
621
622	}//End DbExchange Class
623	?>

AbstractTableMap.class.php - Abstract Shared DAO Implementation

1	<?php
2	//namespace org/imaginus/pogopogoSe4/php/vodaodb/maps/
3
4
5	/////// YOU CAN PUT CUSTOM CODE HERE AT YOUR OWN RISK!
6	/////// PUT CUSTOM CODE FOR ALL Maps TO INHERIT,
7	/////// BUT IF YOU DO, BE WARY OF OVERWRITING THIS FILE / RE-GENERATING THE MAPS!
8
9
10	/************************************************
11	* Generated by VoDaoDb Wed Jul 3 18:13:59 GMT-0400 2013
12	* @author Todd Mullen, <AnEmail@gmail.com>)
13	* @copyright Do whatever you want except sell my work as yours, or reverse engineer it so you can make changes and then sell that as yours.
14	* @license @see copyright
15	* @filesource VoDaoDb v0.9 - Imaginus.org
16	*
17	*****************
18	* Project: pogopogoSe4
19	* Parent: imaginus.org
20	* //No class comments
21	************************************************/
22
23
24	if ( 0 > version_compare( PHP_VERSION, '5' ) ) {
25	die( 'This file was generated for PHP 5' );
26	}
27
28
29	/**
30	* AbstractValueObject defines properties and implements methods that are shared by all concrete Value Objects.
31	*
32	* @author Todd Mullen - ???, <AnEmail@gmail.com>
33	*/
34	require_once dirname( __FILE__ ) . '/../../vos/base/AbstractValueObject.class.php';
35
36
37	/**
38	* include Db
39	*
40	* @author Todd Mullen - ???, <AnEmail@gmail.com>
41	*/
42	require_once dirname( __FILE__ ) . '/../../DbPogopogoSe4.class.php';
43
44
45	/**
46	* AbstractMap is an abstract class that implements common functionality for all Map classes.
47	* The core features of Maps are the getById( id ), getAll(), insert( VO ).
48	* This class implements the built in PHP 'Iterator' interface which allows you to use Maps in foreach() loops.
49	* In addition to providing type checking, the Map allows 'lazy instantiation' in that an array of raw object data ( as returned by a mysql query )
50	* can be given to it and the actual creation will be deffered until the object is actually used ( if it even is before the proces exits ).
51	* This helps to keep system resources from being used unnecessarily.
52	*/
53	abstract class AbstractTableMap {
54	/////// AbstractMap Properties ///////
55
56	/**
57	*
58	* @var
59	*/
60	protected $_mysqli;
61
62
63	/**
64	* The name of the table that the concrete instance was designed to work with.
65	*
66	* @access protected
67	* @var string
68	*/
69	protected $_targetTablename = '';
70
71
72	/**
73	* The name of the concrete child class built to handle the table row data ( which extends AbstractValueObject )
74	*
75	* @access protected
76	* @var string
77	*/
78	protected $_targetClassname = '';
79
80
81	/**
82	* The name of the concrete child collection class built to handle the sets of DOs ( which extends AbstractCollection )
83	*
84	* @access protected
85	* @var string
86	*/
87	protected $_targetCollection = '';
88
89
90
91
92	/**
93	* The base SQL used to SELECT rows from the table. Used to build custom queries.
94	* E.g. SELECT * FROM `table`
95	* @note All the other pre-defined queries are prepared statements, but this is simple an SQL string.
96	*
97	* @access protected
98	* @var string
99	*/
100	protected $_selectSQL;
101	/**
102	* The mysqli prepared statement used to SELECT all rows.
103	*
104	* @access protected
105	* @var mysqli_stmt
106	*/
107	protected $_selectAllStmt;
108	/**
109	* The mysqli prepared statement used to SELECT a single row.
110	*
111	* @access protected
112	* @var mysqli_stmt
113	*/
114	protected $_selectByIdStmt;
115	/**
116	* The mysqli prepared statement used to INSERT a single row
117	*
118	* @access protected
119	* @var mysqli_stmt
120	*/
121	protected $_insertStmt;
122	/**
123	* The mysqli prepared statement used to UPDATE a single row
124	*
125	* @access protected
126	* @var mysqli_stmt
127	*/
128	protected $_updateStmt;
129	/**
130	* The mysqli prepared statement used to DELETE a single row
131	*
132	* @access protected
133	* @var mysqli_stmt
134	*/
135	protected $_deleteStmt;
136	/////// End AbstractMap Properties ///////
137
138
139
140	// --- OPERATIONS ---
141
142
143	public function __construct() {
144	$this->mysqli = &DbPogopogoSe4::mysqli();
145	}//End __construct()
146
147
148	// --- ABSTRACT OPERATIONS ---
149
150
151	/**
152	* Called by AbstractValueObject::getVO()
153	* This abstract method must be implemented by all concrete children.
154	* Builds & initializes an instance of the specific VO type using the values in $fields.
155	*
156	* @abstract
157	* @access protected
158	* @author Todd Mullen - ???, <AnEmail@gmail.com>
159	* @param array $fieldAry
160	* @return AbstractValueObject
161	*/
162	abstract protected function getInstance( array $fieldAry );
163
164
165	/**
166	* The inverse function of AbstractMap::getInstance()
167	* Converts a VO back into an associative array.
168	* Implemented by each concrete class. This method knows the properties present in th VO and builds an associative array from them.
169	* This method is required by AbstractCollection::push( $vo ) in order to keep the "raw" and "object" arrays in sync with eachother.
170	*
171	* @param AbstractValueObject $vo - The Value Object that should be converted back in to an associative array.
172	* @return array A raw associative array of VO property values.
173	*/
174	abstract public function voToArray( AbstractValueObject $vo );
175
176
177	/**
178	* Returns the specific collection type used for the specific VO type.
179	*
180	* @abstract
181	* @access protected
182	* @author Todd Mullen - ???, <AnEmail@gmail.com>
183	* @param array $rawAry An array of raw table row associative arrays to prepopulate the collection with.
184	* @param array $voAry An array of already instantiated VOs to prepopulate the collection with.
185	* @return AbstractValueObject
186	abstract protected function getCollection( $rawAry = array(), $voAry = array() );
187	*/
188
189
190	/**
191	* Called by AbstractValueObject::insert() to insert $vo.
192	* Defined in the concrete child classes to parse the given VO values and INSERT a new row into the target table.
193	*
194	* @abstract
195	* @access protected
196	* @author Todd Mullen - ???, <AnEmail@gmail.com>
197	* @param AbstractValueObject $vo
198	* @return bool
199	*/
200	abstract protected function insertNow( $vo );
201
202
203	/**
204	* Called by AbstractValueObject::update() to update $vo.
205	* Defined in the concrete child classes to parse the given VO values and UPDATE a row in the target table.
206	*
207	* @abstract
208	* @access protected
209	* @author Todd Mullen - ???, <AnEmail@gmail.com>
210	* @param AbstractValueObject $vo
211	* @return bool
212	*/
213	abstract protected function updateNow( $vo );
214
215
216	/**
217	* Called by AbstractValueObject::delete() to delete $vo.
218	* Defined in the concrete child classes to DELETE the given VO from the target table.
219	*
220	* @abstract
221	* @access protected
222	* @author Todd Mullen - ???, <AnEmail@gmail.com>
223	* @param AbstractValueObject $vo
224	* @return bool
225	*/
226	abstract protected function deleteNow( $vo );
227
228
229	/**
230	* Called by AbstractMap::findByKey() to fetch the row from the database if it isn't already stored in the DbExchange instance.
231	*
232	* @abstract
233	* @access protected
234	* @author Todd Mullen - ???, <AnEmail@gmail.com>
235	* @param array $voKeyAry The associative key array that contains the correct coumn names and their desired values.
236	* @return AbstractValueObject
237	*/
238	abstract public function findByKeyNow( $voKeyAry );
239
240
241	/**
242	* Implement this method to accept "n" key parameters.
243	* This method will take the key's given and provide a convenience method for building a
244	* uniformly named array for the concrete classes' primary key.
245	*
246	* @abstract
247	* @access protected
248	* @author Todd Mullen - ???, <AnEmail@gmail.com>
249	* @param string key1 the first key string
250	* @return array An associative array of tableKeyNames=>values
251	*/
252	abstract public function getKeyAry( $key1 );
253
254
255	/**
256	* Accepts an AbstractValueObject and extracts the string representation of the VOs primary table key.
257	* This method is implemented by concrete child classes that are aware of the specific table's key names & structure.
258	* And called by AbstractTableMap::getKeyStr()
259	*
260	* @abstract
261	* @access protected
262	* @author Todd Mullen - ???, <AnEmail@gmail.com>
263	* @param AbstractValueObject vo The VO the key string is desired for
264	* @return string A uniformly formatted string representation of the VO's primary key
265	*/
266	abstract protected function getKeyStrNow( $vo );
267
268
269	// --- END ABSTRACT METHOD DECLARATIONS --- //
270
271
272
273
274	/// --- SHARED OPERATIONS --- //
275
276
277	/**
278	* Type checks $vo, if it is of the correct type, then the concrete instance is called to build a unique primary key string from it.
279	* Accepts an AbstractValueObject and extracts the string representation of the VOs primary table key
280	*
281	* @access public
282	* @author Todd Mullen - ???, <AnEmail@gmail.com>
283	* @see AbstractMap::getKeyStrNow()
284	* @param AbstractValueObject vo The VO the key string is desired for
285	* @return string A uniformly formatted string representation of the VO's primary key
286	*/
287	public function getKeyStr( AbstractValueObject $vo ) {
288	if( $this->typeMatch( $vo ) ) {
289	return $this->getKeyStrNow( $vo );
290	}
291	throw new Exception( "Cannot format key string for this vo '$vo' because it is not an instance of '$this->_targetClassname' " );
292	}//End getKeyStr()
293
294
295	/**
296	* Constructs a unique string that represents the object across tables by prepending the class name to the objects key string.
297	* This allows objects with the same primary key to remain distinct.
298	* E.g. If a user and an image both have P.K. = 1, it's obvious that "VoUser-1" != "VoImage-1"
299	*
300	* @access public
301	* @author Todd Mullen - ???, <AnEmail@gmail.com>
302	* @param AbstractValueObject $vo
303	* @return string A string that represents the VO by class namd and primary key.
304	*/
305	public function globalKeyStr( AbstractValueObject $vo ) {
306	return get_class( $vo ) . "-" . $this->getKeyStr( $vo );
307	}//End globalKeyStr()
308
309
310	/**
311	* Verifies the type of $vo against the concrete child's targetClassname
312	*
313	* @param AbstractValueObject $vo
314	* @return bool
315	*/
316	public function typeMatch( $vo ) {
317	return get_class( $vo ) == $this->_targetClassname;
318	}//End typeMatch()
319
320
321	/**
322	* Returns all rows of a table
323	*
324	* @access public
325	* @author Todd Mullen - ???, <AnEmail@gmail.com>
326	* @return AbstractCollection
327	*/
328	public function getAll() {
329	$r = $this->mysqli->query( $this->_selectAllSQL );
330	$rawAry = array();
331	while( $row = $r->fetch_assoc() ) {
332	$rawAry[] = $row;
333	}
334	return $this->getCollection( $rawAry );
335	}//End getAll()
336
337
338	/**
339	* Accepts a primary key value for the VO class and queries the database using the _selectByIdStmt to perform the query.
340	*
341	* @see $this->_selectByIdStmt
342	* @access public
343	* @author Todd Mullen - ???, <AnEmail@gmail.com>
344	* @param int $id - The primary key to query for.
345	* @return AbstractValueObject
346	*/
347	public function getById( $id ) {
348	echo "Querying $this->_targetTablename for primary key = '$id'<br/>";
349	$this->_selectByIdStmt->bind_param( "i", $id );
350	$this->_selectByIdStmt->execute();
351	///* @var $result mysqli_result
352	$result = $this->_selectByIdStmt->fetch();
353	if( $result->num_rows ){
354	$vo = $this->getVO( $result->fetch_assoc() );
355	$vo->markClean();
356	$this->_selectByIdStmt->free_result();
357	unset ( $result );
358	return $vo;
359	}
360	return null;
361	}//End findById()
362
363
364	/**
365	* Delegates to the abstract function getInstance which is implemented by the specific child implementation to build the correct VO type.
366	* Passes $fieldAry along to initialize the new instance.
367	*
368	* @access public
369	* @author Todd Mullen - ???, <AnEmail@gmail.com>
370	* @param array fieldAry
371	* @return AbstractValueObject
372	*/
373	public function getVO( $fieldAry ) {
374	echo "<b>" . __METHOD__ . "()</b> delegating to concrete class....<br/>";
375	return $this->getInstance( $fieldAry );
376	}//End getVO()
377
378
379	/**
380	* Instantiates a new "$this->_targetCollection" passin $rawAry and $voAry along to initialize the new collection.
381	*
382	* @access public
383	* @author Todd Mullen - ???, <AnEmail@gmail.com>
384	* @param array $rawAry [optional] - An array of associative arrays that contain the column=>value properties for the VOs contained.
385	* @param array $voAry [optional] - An array of Value Objects that have already been instantiated.
386	* @return AbstractCollection
387	*/
388	public function getCollection( $rawAry = array(), $voAry = array() ) {
389	return new $this->_targetCollection( $rawAry, $voAry );
390	}//End getCollection()
391
392
393	/**
394	* Checks that VO is of the correct type and delegates to the concrete implementation of insertNow() if it is the correct type.
395	* Returns true on success, false otherwise
396	*
397	* @access public
398	* @author Todd Mullen - ???, <AnEmail@gmail.com>
399	* @param AbstractValueObject vo
400	* @return bool
401	*/
402	public function insert( AbstractValueObject $vo ) {
403	if( $this->typeMatch( $vo ) ) {
404	return $this->insertNow( $vo );
405	}
406	throw new Exception( "Cannot INSERT '$vo' because it is not an instance of '$this->_targetClassname' " );
407	}//End insert()
408
409
410	/**
411	* Checks that VO is of the correct type and delegates to the concrete implementation of updateNow() if it is the correct type.
412	* Returns true on success, false otherwise
413	*
414	* @access public
415	* @author Todd Mullen - ???, <AnEmail@gmail.com>
416	* @param AbstractValueObject vo
417	* @return bool
418	*/
419	public function update( AbstractValueObject $vo ) {
420	if( $this->typeMatch( $vo ) ) {
421	return $this->updateNow( $vo );
422	}
423	throw new Exception( "Cannot UPDATE '$vo' because it is not an instance of '$this->_targetClassname' " );
424	}//End update()
425
426
427	/**
428	* Checks that VO is of the correct type and delegates to the concrete implementation of deleteNow() if it is the correct type.
429	* Returns true on success, false otherwise
430	*
431	* @access public
432	* @author Todd Mullen - ???, <AnEmail@gmail.com>
433	* @param AbstractValueObject $vo
434	* @return bool
435	*/
436	public function delete( AbstractValueObject $vo ) {
437	if( $this->typeMatch( $vo ) ) {
438	return $this->deleteNow( $vo );
439	}
440	throw new Exception( "Cannot DELETE '$vo' because it is not an instance of '$this->_targetClassname' " );
441	}//End delete()
442
443
444	/**
445	* Accepts an array of table keys used to identify a particular row.
446	* If a VO instance matching the criteria is found in the DbExchange, it is returned.
447	* If a matching VO is not found, then the array of table keys is passed to the concrete implementation to load it from the database targetTable.
448	*
449	* @param array $voKeyAry
450	* @return AbstractValueObject _targetClassname
451	*/
452	public function findByKey( $voKeyAry ) {
453	$oldDo = DbExchange::Store()->has( $this->_targetClassname, $voKeyAry );
454	if( $oldDo instanceof $this->_targetClassname ) {
455	return $oldDo;
456	}
457	return $this->findByKeyNow( $voKeyAry );
458	}//End findByKey()
459
460
461	}//End AbstractMap
462	?>

BaseDaoEngine4ActivityActions.class.php - Parent DAO

1	<?php
2	//namespace org/imaginus/pogopogoSe4/php/vodaodb/maps/
3
4
5	/////// DO NOT PUT CUSTOM CODE HERE!
6	/////// PUT CUSTOM CODE FOR `E4_activity_actions` Maps IN DaoE4ActivityActions.
7
8
9	/************************************************
10	* Generated by VoDaoDb Wed Jul 3 18:13:59 GMT-0400 2013
11	* @author Todd Mullen, <AnEmail@gmail.com>)
12	* @copyright Do whatever you want except sell my work as yours, or reverse engineer it so you can make changes and then sell that as yours.
13	* @license @see copyright
14	* @filesource VoDaoDb v0.9 - Imaginus.org
15	*
16	*****************
17	* Project: pogopogoSe4
18	* Parent: imaginus.org
19	* //No class comments
20	************************************************/
21
22
23	if ( 0 > version_compare( PHP_VERSION, '5' ) ) {
24	die( 'This file was generated for PHP 5' );
25	}//End
26
27
28	require_once 'AbstractTableMap.class.php';
29	/**
30	* Concrete Value Objects hold properties, getters, & setters that are specific
31	* table columns.
32	*
33	* @author Todd Mullen - ???, <AnEmail@gmail.com>
34	*/
35	require_once dirname( __FILE__ ) . '/../../vos/base/AbstractValueObject.class.php';
36
37	require_once dirname( __FILE__ ) . '/../../vos/VoE4ActivityActions.class.php';
38
39	require_once dirname( __FILE__ ) . '/../../collections/CollectionOfE4ActivityActionss.class.php';
40	class BaseDaoE4ActivityActions
41	extends AbstractTableMap {
42	/**
43	* __construct() sets all the required properties defined in the 'AbstractTableMap' superclass
44	*
45	* @access public
46	* @author Todd Mullen - ???, <AnEmail@gmail.com>
47	* @return void
48	*/
49	public function __construct() {
50	parent::__construct();
51	$this->_targetClassname = "VoE4ActivityActions";
52	$this->_targetTablename = "`E4_activity_actions`";
53	$this->_targetCollection = "CollectionOfE4ActivityActionss";
54
55	$this->_mysqli = DbPogopogoSe4::mysqli();
56	$this->_selectAllSQL = "SELECT * FROM `E4_activity_actions`";
57	$this->_selectAllStmt = $this->_mysqli->prepare( "SELECT * FROM `E4_activity_actions`" );
58	$this->_selectByIdStmt = $this->_mysqli->prepare( "SELECT * FROM `E4_activity_actions` WHERE `action_id` = ?" );
59	$this->_insertStmt = $this->_mysqli->prepare( "INSERT INTO `E4_activity_actions`
60	( attachment_count, body, comment_count, date, like_count, object_id, object_type, params, subject_id, subject_type, type )
61	values ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )" );
62	$this->_updateStmt = $this->_mysqli->prepare( "UPDATE `E4_activity_actions`
63	SET `action_id` = ?, `attachment_count` = ?, `body` = ?, `comment_count` = ?, `date` = ?, `like_count` = ?, `object_id` = ?, `object_type` = ?, `params` = ?, `subject_id` = ?, `subject_type` = ?, `type` = ?
64	WHERE `action_id` = ?" );
65	$this->_deleteStmt = $this->_mysqli->prepare( "DELETE FROM `E4_activity_actions`
66	WHERE `action_id` = ?" );
67	}//End __construct()
68
69
70	/////// AbstractMap Method Overrides ///////
71
72	/**
73	* Returns the UserVO instance found by $voKeyAry[action_id]
74	*
75	* @access public
76	* @author Todd Mullen - ???, <AnEmail@gmail.com>
77	* @param array $voKeyAry Must contain 'action_id' = ( int(11) unsigned )
78	* @return UserVO
79	*/
80	public function findByKeyNow( $voKeyAry ) {
81	echo '<b>'.__METHOD__.'()</b> using: '. print_r( $voKeyAry, true ) .'<br/>';
82	if( isset ( $voKeyAry['action_id'] ) ) {
83	$this->_selectByIdStmt->bind_param( 's', $voKeyAry['action_id'] );
84	$sql = sprintf( $this->_selectByIdStmt, $voKeyAry['action_id'] );
85	$result = $this->_mysqli->query( $sql );
86	/* @var $result mysqli_result */
87	if( $result->num_rows == 0 ) {
88	echo '<b>'.__METHOD__.'()</b> No user found.<br/>';
89	return null;
90	}
91	$userFound = $this->getInstance( $result->fetch_assoc() );
92	return $userFound;
93	}
94	throw new Exception( "Cannot select user. Invalid key array " . print_r( $voKeyAry, true ) . " given." );
95	}//End findByKeyNow()
96
97
98	/**
99	* Returns an array with the `E4_activity_actions` table primary key `action_id` set to $actionId.
100	* @param int $userId
101	* @return array
102	*/
103	public function getKeyAry( $actionId ){
104	return array( 'action_id'=>$actionId );
105	}
106
107
108	protected function getKeyStrNow( $voVoE4ActivityActions ){
109	return $voVoE4ActivityActions->getActionId();
110	}
111
112
113	/**
114	* Accepts an associative array of property names => values, creates a new VoE4ActivityActions object.
115	* Calls VoE4ActivityActions::initAllValues() passing $fieldAry into it to set the instance's values.
116	* DOES NOT verify the validity of the column names or values contained in $fieldAry.
117	*
118	*
119	* @access protected
120	* @author Todd Mullen - ???, <AnEmail@gmail.com>
121	* @param array $fieldAry array( 'action_id' => $voVoE4ActivityActions->getActionId(), 'attachment_count' => $voVoE4ActivityActions->getAttachmentCount(), 'body' => $voVoE4ActivityActions->getBody(), 'comment_count' => $voVoE4ActivityActions->getCommentCount(), 'date' => $voVoE4ActivityActions->getDate(), 'like_count' => $voVoE4ActivityActions->getLikeCount(), 'object_id' => $voVoE4ActivityActions->getObjectId(), 'object_type' => $voVoE4ActivityActions->getObjectType(), 'params' => $voVoE4ActivityActions->getParams(), 'subject_id' => $voVoE4ActivityActions->getSubjectId(), 'subject_type' => $voVoE4ActivityActions->getSubjectType(), 'type' => $voVoE4ActivityActions->getType(), );
122	* @see VoE4ActivityActions::initAllValues()
123	* @return VoE4ActivityActions
124	*/
125	protected function getInstance( array $fieldAry ) {
126	echo "<b>" . __METHOD__ . "()</b> Creating new $this->_targetClassname and calling initAllValues()<br/>";
127	/* @var $u VoE4ActivityActions */
128	$u = new $this->_targetClassname();
129	$u->initAllValues( $fieldAry );
130	return $u;
131	}//End getInstance()
132
133
134	/**
135	* Returns an associative array of object property name => values
136	* This is the inverse of BaseDaoDevice::getInstance()
137	* This method is required by AbstractCollection::push( $voVoE4ActivityActions ) in order to keep the "raw" and "object" arrays in sync with eachother.
138	*
139	* @param VoE4ActivityActions $voVoE4ActivityActions The VoE4ActivityActions to parse into an associative array.
140	* @return array array( 'action_id' => $voVoE4ActivityActions->getActionId(), 'attachment_count' => $voVoE4ActivityActions->getAttachmentCount(), 'body' => $voVoE4ActivityActions->getBody(), 'comment_count' => $voVoE4ActivityActions->getCommentCount(), 'date' => $voVoE4ActivityActions->getDate(), 'like_count' => $voVoE4ActivityActions->getLikeCount(), 'object_id' => $voVoE4ActivityActions->getObjectId(), 'object_type' => $voVoE4ActivityActions->getObjectType(), 'params' => $voVoE4ActivityActions->getParams(), 'subject_id' => $voVoE4ActivityActions->getSubjectId(), 'subject_type' => $voVoE4ActivityActions->getSubjectType(), 'type' => $voVoE4ActivityActions->getType(), );
141	*/
142	public function voToArray( AbstractValueObject $voVoE4ActivityActions ) {
143	if( !$this->typeMatch( $voVoE4ActivityActions ) ) {
144	throw new Exception( "Wrong type given. Cannot convert $voVoE4ActivityActions to array, it is not a '$this->_targetClassname' " );
145	}//End
146	echo "<b>" . __METHOD__ . "()</b> converting {$voVoE4ActivityActions->globalKeyStr()} back to an associative array<br/>";
147	return array( 'action_id' => $voVoE4ActivityActions->getActionId(), 'attachment_count' => $voVoE4ActivityActions->getAttachmentCount(), 'body' => $voVoE4ActivityActions->getBody(), 'comment_count' => $voVoE4ActivityActions->getCommentCount(), 'date' => $voVoE4ActivityActions->getDate(), 'like_count' => $voVoE4ActivityActions->getLikeCount(), 'object_id' => $voVoE4ActivityActions->getObjectId(), 'object_type' => $voVoE4ActivityActions->getObjectType(), 'params' => $voVoE4ActivityActions->getParams(), 'subject_id' => $voVoE4ActivityActions->getSubjectId(), 'subject_type' => $voVoE4ActivityActions->getSubjectType(), 'type' => $voVoE4ActivityActions->getType(), );
148	}//End voToArray()
149
150
151	/**
152	* Accepts an associative array of property names => values, creates a new DaoE4ActivityActions object and calls
153	* DaoE4ActivityActions::init() passing $fields into it to set the instance values.
154	*
155	* @access protected
156	* @author Todd Mullen - ???, <AnEmail@gmail.com>
157	* @param array $rawAry Associative array of property names=>values E.g. - A MySQLi result
158	* @param array $voVoE4ActivityActionsAry Array of VoE4ActivityActions instances
159	* @see DaoE4ActivityActions::init()
160	* @return DaoE4ActivityActions
161	*/
162	public function getCollection( $rawAry = array(), $voVoE4ActivityActionsAry = array() ) {
163	$u = new $this->_targetCollection( $rawAry, $voVoE4ActivityActionsAry );
164	return $u;
165	}//End getCollection()
166
167
168	/**
169	* Implements the insertNow method from DaoE4ActivityActions to use the values that are specific to the `E4_activity_actions` table.
170	* Adds $voVoE4ActivityActions to the `E4_activity_actions` table & sets the `action_id` to the last insert id.
171	*
172	* @access protected
173	* @author Todd Mullen - ???, <AnEmail@gmail.com>
174	* @param VoE4ActivityActions $voVoE4ActivityActions
175	* @return bool
176	*/
177	public function insertNow( $voVoE4ActivityActions ) {
178	if( !$this->typeMatch( $voVoE4ActivityActions ) ) {
179	throw new Exception( "Type error \$voVoE4ActivityActions given is not a '$this->_targetClassname'. Given '" . get_class( $voVoE4ActivityActions ) . "' instead." );
180	}//End
181	$this->_insertStmt->bind_param( 'sssssssssss', $voVoE4ActivityActions->getAttachmentCount(), $voVoE4ActivityActions->getBody(), $voVoE4ActivityActions->getCommentCount(), $voVoE4ActivityActions->getDate(), $voVoE4ActivityActions->getLikeCount(), $voVoE4ActivityActions->getObjectId(), $voVoE4ActivityActions->getObjectType(), $voVoE4ActivityActions->getParams(), $voVoE4ActivityActions->getSubjectId(), $voVoE4ActivityActions->getSubjectType(), $voVoE4ActivityActions->getType() );
182	echo "<b>" . __METHOD__ . "()</b><br/> Inserting $voVoE4ActivityActions in $this->_targetTablename<br />";
183	if( $this->_insertStmt->execute() ) {
184	echo "<b>" . __METHOD__ . "()</b> Insert successful<br />Setting new actionId...<br/>";
185	$voVoE4ActivityActions->setactionId( $this->_insertStmt->insert_id );
186	return true;
187	}//End
188	echo "<b>" . __METHOD__ . "()</b> <b>Insert failed:</b> ".$this->_insertStmt->error;
189	return false;
190	}//End insertNow()
191
192
193	/**
194	* Implements DaoE4ActivityActions::updateNow() to use the values that are specific to the `E4_activity_actions` table.
195	* Synchronizes the database values for $voVoE4ActivityActions. UPDATEs `E4_activity_actions`.`action_id` = $voVoE4ActivityActions->getActionId()
196	* Called by DaoE4ActivityActions::update()
197	*
198	*
199	* @access protected
200	* @author Todd Mullen - ???, <AnEmail@gmail.com>
201	* @param VoE4ActivityActions $voVoE4ActivityActions The concrete DaoE4ActivityActions DomainObject to update ( using it's current values )
202	* @return bool
203	*/
204	public function updateNow( $voVoE4ActivityActions ) {
205	if( !$this->typeMatch( $voVoE4ActivityActions ) ) {
206	throw new Exception( "Type error \$voVoE4ActivityActions given is not a '$this->_targetClassname'. Given '" . get_class( $voVoE4ActivityActions ) . "' instead." );
207	}//End
208	$this->_updateStmt->bind_param( 'sssssssssssss', $voVoE4ActivityActions->getActionId(), $voVoE4ActivityActions->getAttachmentCount(), $voVoE4ActivityActions->getBody(), $voVoE4ActivityActions->getCommentCount(), $voVoE4ActivityActions->getDate(), $voVoE4ActivityActions->getLikeCount(), $voVoE4ActivityActions->getObjectId(), $voVoE4ActivityActions->getObjectType(), $voVoE4ActivityActions->getParams(), $voVoE4ActivityActions->getSubjectId(), $voVoE4ActivityActions->getSubjectType(), $voVoE4ActivityActions->getType(), $voVoE4ActivityActions->getActionId() );
209	//echo "<hr/><b>" . __METHOD__ . "()</b> <b>Updating:</b> " . $voVoE4ActivityActions . "<br />";
210	if( $this->_updateStmt->execute() ) {
211	echo "<b>" . __METHOD__ . "()</b> <b>Updated:</b> " . $voVoE4ActivityActions . "<br />";
212	return true;
213	}//End
214	echo "<b>" . __METHOD__ . "()</b> <b>Update failed:</b> ".$this->_updateStmt->error;
215	return false;
216	}//End updateNow()
217
218
219	/**
220	* Implements the deleteNow method from DaoE4ActivityActions to use the values that are specific to the `E4_activity_actions` table.
221	* Deletes the `E4_activity_actions` row WHERE `action_id` = $voVoE4ActivityActions->getActionId()
222	*
223	* @access protected
224	* @author Todd Mullen - ???, <AnEmail@gmail.com>
225	* @param VoE4ActivityActions $voVoE4ActivityActions
226	* @return null
227	*/
228	public function deleteNow( $voVoE4ActivityActions ) {
229	if( !$this->typeMatch( $voVoE4ActivityActions ) ) {
230	throw new Exception( "Type error \$voVoE4ActivityActions given is not a '$this->_targetClassname'. Given $voVoE4ActivityActions instead." );
231	}//End
232	$this->_deleteStmt->bind_param( 's', $voVoE4ActivityActions->getActionId() );
233	//echo "<b>" . __METHOD__ . "()</b> <b>Deleting:</b> $voVoE4ActivityActions<br />";
234	if( $this->_deleteStmt->execute() ) {
235	echo "<b>" . __METHOD__ . "()</b> <b>Deleted:</b> $voVoE4ActivityActions<br />";
236	return true;
237	}//End
238	echo "<b>" . __METHOD__ . "()</b> <b>Delete failed:</b> ".$this->_deleteStmt->error;
239	return false;
240	}//End deleteNow()
241	/**
242	* __destruct() is called just before an instance is garbage collected.
243	* This method simply closes the prepared statements to ensure that the related resources are also released.
244	*
245	* @access protected
246	* @author Todd Mullen - ???, <AnEmail@gmail.com>
247	* @param VoE4ActivityActions $voVoE4ActivityActions
248	* @return null
249	*/
250	public function __destruct() {
251	$this->_insertStmt->close();
252	$this->_updateStmt->close();
253	$this->_deleteStmt->close();
254	}//End __destruct()
255	/////// End AbstractMap Method Overrides ///////
256
257	}//End BaseDaoE4ActivityActions
258	?>

DaoEngine4ActivityActions.class.php - Child DAO

1	<?php
2	//namespace org/imaginus/pogopogoSe4/php/vodaodb/maps/
3
4
5	/////// PUT CUSTOM CODE FOR `E4_activity_actions` VOs Maps IN THIS CLASS.
6
7
8	/************************************************
9	* Generated by VoDaoDb Wed Jul 3 18:13:59 GMT-0400 2013
10	* @author Todd Mullen, <AnEmail@gmail.com>)
11	* @copyright Do whatever you want except sell my work as yours, or reverse engineer it so you can make changes and then sell that as yours.
12	* @license @see copyright
13	* @filesource VoDaoDb v0.9 - Imaginus.org
14	*
15	*****************
16	* Project: pogopogoSe4
17	* Parent: imaginus.org
18	* //No class comments
19	************************************************/
20	require_once 'base/BaseDaoE4ActivityActions.class.php';
21	class DaoE4ActivityActions
22	extends BaseDaoE4ActivityActions {
23
24
25	/**
26	* __construct() sets all the required properties defined in the 'AbstractTableMap' superclass by calling parent::__construct()
27	*
28	* @access public
29	* @author Todd Mullen - ???, <AnEmail@gmail.com>
30	* @return void
31	*/
32	public function __construct() {
33	parent::__construct();
34	}//End __construct()
35
36
37	/**
38	* Template method for custom queries
39	*
40	* @access public
41	* @author Todd Mullen - ???, <AnEmail@gmail.com>
42	* @return CollectionOfE4ActivityActionss
43	public function getByX( $value ) {
44	$stmt = $this->_mysqli->prepare( "SELECT * FROM `E4_activity_actions` WHERE `E4_activity_actions`.`` = ?" );
45	$stmt->bind_param( 's', $value );
46	$stmt->bind_result( $row );
47	$rawAry = array();
48	if( $stmt->execute() ) {
49	while( $row = $stmt->fetch_assoc() ) {
50	$rawAry[] = $row;
51	}//End while()
52	}
53	return $this->getCollection( $rawAry );
54	}//End getByX()
55	*/
56	}//End DaoE4ActivityActions
57	?>

AbstractIdentity.class.php - Abstract Shared “Identity Map” Implementation

1	<?php
2	//namespace org/imaginus/pogopogoSe4/php/vodaodb/identities/
3
4
5	/////// YOU CAN PUT CUSTOM CODE HERE AT YOUR OWN RISK!
6	/////// PUT CUSTOM CODE FOR ALL SELECTORS TO INHERIT,
7	/////// BUT BE WARY OF OVERWRITING THIS FILE IF YOU DO AND THEN RE-GENERATE THE SELECTORS!
8
9
10	/************************************************
11	* Generated by VoDaoDb Wed Jul 3 18:13:58 GMT-0400 2013
12	* @author Todd Mullen, <AnEmail@gmail.com>)
13	* @copyright Do whatever you want except sell my work as yours, or reverse engineer it so you can make changes and then sell that as yours.
14	* @license @see copyright
15	* @filesource VoDaoDb v0.9 - Imaginus.org
16	*
17	*****************
18	* Project: pogopogoSe4
19	* Parent: imaginus.org
20	* //No class comments
21	************************************************/
22
23
24	/**
25	* AbstractIdentity provides shared methods used to build queries for selecting a row, or multiple rows, from a table that match the given criteria.
26	*
27	* @abstract
28	* @access public
29	* @author Todd Mullen - ???, <AnEmail@gmail.com>
30	*/
31	abstract class AbstractIdentity {
32
33
34	/* user defined includes */
35
36
37	/* user defined constants */
38
39
40	// --- ATTRIBUTES ---
41
42
43	/**
44	* Name of the table that the concrete selector is built to work with.
45	*
46	* @access protected
47	* @author Todd Mullen - ???, <AnEmail@gmail.com>
48	* @var string
49	*/
50	protected $tableName;
51
52
53	/**
54	* Array of WHERE clause comparisons.
55	* Built by calling instance selector methods.
56	* Used to build the SQL WHERE clause
57	*
58	* @access protected
59	* @author Todd Mullen - ???, <AnEmail@gmail.com>
60	* @var array $comps
61	*/
62	protected $comps = array();
63
64
65	/**
66	* Holds custom defined "SELECT columns" that you would like MySQL to return in the result set.
67	* E.g. CHAR_LENGTH( `column` ) AS `length` adds a faux column named "length" to the result set and is equal to the chracter length of the `column` value
68	* @var array $customCols
69	*/
70	protected $customCols = array();
71
72
73	/**
74	* The number of results to LIMIT the query result set to.
75	*
76	* @access protected
77	* @author Todd Mullen - ???, <AnEmail@gmail.com>
78	* @var string $limit
79	*/
80	protected $limit = "";
81
82
83	/**
84	* The ORDER BY clause to use on the result set.
85	*
86	* @access protected
87	* @author Todd Mullen - ???, <AnEmail@gmail.com>
88	* @var string $order
89	*/
90	protected $order = "";
91
92
93	/**
94	*
95	*
96	* @access protected
97	* @author Todd Mullen - ???, <AnEmail@gmail.com>
98	* @var string $group
99	*/
100	protected $group = "";
101
102
103	/**
104	* Name of the concrete map that the concrete selector is built to work with.
105	*
106	* @access protected
107	* @author Todd Mullen - ???, <AnEmail@gmail.com>
108	* @var string $map
109	*/
110	protected $map = '';
111	// --- OPERATIONS ---
112
113
114	/**
115	* Returns the concrete map that works with the the specific table's DomainObject type
116	*
117	* @access public
118	* @author Todd Mullen - ???, <AnEmail@gmail.com>
119	* @return AbstractMapper
120	*/
121	abstract protected function getMap();
122
123
124
125
126	/**
127	* Resets the comparison array and returns "$this"
128	* If "$this" is "new" then it's simply used as a "syntactical" method so the method calls read more like English.
129	* @return AbstractIdentity
130	*/
131	public function select() {
132	$this->reset();
133	return $this;
134	}//End select()
135
136
137	/**
138	* Resets the comparisons array, limit clause, grouping clause, & order clause for the instance.
139	*
140	* @access public
141	* @author Todd Mullen - ???, <AnEmail@gmail.com>
142	* @return AbstractIdentity
143	*/
144	public function reset() {
145	$this->group = $this->limit = $this->order = "";
146	$this->comps = $this->customCols = array();
147	return $this;
148	}//End reset()
149
150
151	/**
152	* Returns the name of the table that $this is is designed to work with.
153	*
154	* @access public
155	* @author Todd Mullen - ???, <AnEmail@gmail.com>
156	* @return AbstractIdentity
157	*/
158	public function tableName() {
159	return $this->tableName;
160	}//End tableName()
161
162
163	/**
164	* Short description of method sqlWhereClause
165	*
166	* @access public
167	* @author Todd Mullen - ???, <AnEmail@gmail.com>
168	* @return string
169	*/
170	public function sqlWhereClause() {
171	return " WHERE " . implode( " ", $this->comps );
172	}//End sqlWhereClause()
173
174
175	/**
176	* Returns the GROUP BY portion of the SQL query.
177	*
178	* @access public
179	* @author Todd Mullen - ???, <AnEmail@gmail.com>
180	* @return string E.g. "GROUP BY `col`"
181	*/
182	public function sqlGroupByClause() {
183	return $this->group;
184	}//End sqlGroupByClause()
185
186
187	/**
188	*
189	* @param string $col The column to group by.
190	* @return AbstractIdentity
191	*/
192	public function groupBy( $col ) {
193	$this->group = " GROUP BY $this->tableName.`$col` ";
194	return $this;
195	}//End groupBy()
196
197
198	/**
199	* Returns the ORDER BY portion of the SQL query.
200	*
201	* @access public
202	* @author Todd Mullen - ???, <AnEmail@gmail.com>
203	* @return string E.g. "ORDER BY `column` ASC"
204	*/
205	public function sqlOrderByClause() {
206	return $this->order;
207	}//End sqlOrderByClause()
208
209
210	/**
211	*
212	* @param string $col The column to order by
213	* @param string $dir The direction to order by "ASC" or "DESC"
214	* @return AbstractIdentity
215	*/
216	public function orderBy( $col, $dir ) {
217	$this->order = " ORDER BY $col $dir";
218	return $this;
219	}//End orderBy()
220
221
222	/**
223	* Adds a custom clause into the select query.
224	* @param type $clause
225	* @return AbstractIdentity
226	*/
227	public function customClause( $clause ) {
228	$this->comps[] = $clause;
229	return $this;
230	}//End customClause()
231
232
233	public function customColumn( $definition ) {
234	$this->customCols[] = $definition;
235	}//End customColumn()
236
237
238	/**
239	* Returns the LIMIT portion of the SQL query.
240	*
241	* @access public
242	* @author Todd Mullen - ???, <AnEmail@gmail.com>
243	* @return string "LIMIT {int}"
244	*/
245	public function sqlLimitClause() {
246	return $this->limit;
247	}//End sqlLimitClause()
248
249
250	/**
251	*
252	* @param int $num The number of rows to limit the selection to.
253	* @return AbstractIdentity
254	*/
255	public function limit( $start = 0, $num = 1 ) {
256	$this->limit = " LIMIT $start, $num ";
257	return $this;
258	}//End limit()
259
260
261	/**
262	* Adds an conjunct ( AND ) to the WHERE clause.
263	*
264	* @access public
265	* @author Todd Mullen - ???, <AnEmail@gmail.com>
266	* @return AbstractIdentity
267	*/
268	public function andWith() {
269	$this->comps[] = " AND ";
270	}//End andWith()
271
272
273	/**
274	* Adds an disjunct ( OR ) to the WHERE clause.
275	*
276	* @access public
277	* @author Todd Mullen - ???, <AnEmail@gmail.com>
278	* @return AbstractIdentity
279	*/
280	public function orWith() {
281	$this->comps[] = " OR ";
282	return $this;
283	}//End orWith()
284
285
286	/**
287	* Adds an IN construct to the WHERE clause.
288	* The options for IN should be enumerated in $ary
289	* E.g. $ary = array( 1, 2, 's' ) yields "`tablename`.`column` IN ( 1, 2, 's' )"
290	*
291	* @access public
292	* @author Todd Mullen - ???, <AnEmail@gmail.com>
293	* @param string $col The name of the column that should be used for the comparison.
294	* @param array $ary Array of acceptable values for the column.
295	* @return AbstractIdentity
296	*/
297	public function inThis( $col, $ary ) {
298	$this->comps[] = "`$this->tableName`.`$col` IN ( " . implode( ", ", $ary ) . " )";
299	return $this;
300	}//End inThis()
301
302
303	/**
304	* Short description of method isValid
305	*
306	* @access public
307	* @author Todd Mullen - ???, <AnEmail@gmail.com>
308	* @return bool
309	*/
310	public function isValid() {
311	return count( $this->comps ) > 0;
312	}//End isValid()
313
314
315
316
317	} /* end of abstract class AbstractIdentity */
318
319
320	?>

BaseIdentityForEngine4ActivityActions.class.php - Parent “Activity Actions Identity Map”

1	<?php
2	//namespace org/imaginus/pogopogoSe4/php/vodaodb/identities/
3
4
5	/////// DO NOT PUT CUSTOM CODE HERE!
6	/////// PUT CUSTOM CODE FOR `E4_activity_actions` IN THE IdentityForE4ActivityActions CLASS.
7
8
9	/************************************************
10	* Generated by VoDaoDb Wed Jul 3 18:13:58 GMT-0400 2013
11	* @author Todd Mullen, <AnEmail@gmail.com>)
12	* @copyright Do whatever you want except sell my work as yours, or reverse engineer it so you can make changes and then sell that as yours.
13	* @license @see copyright
14	* @filesource VoDaoDb v0.9 - Imaginus.org
15	*
16	*****************
17	* Project: pogopogoSe4
18	* Parent: imaginus.org
19	* //No class comments
20	************************************************/
21	require_once 'AbstractIdentity.class.php';
22	class BaseIdentityForE4ActivityActions
23	extends AbstractIdentity {
24
25
26	/**
27	* Creates a new instance with the option to immidiately choose a primary key `action_id` value to use for SELECTion.
28	*
29	* @access public
30	* @author Todd Mullen - ???, <AnEmail@gmail.com>
31	* @param mixed $actionId [optional] - The `E4_activity_actions` primary key value to set initially.
32	* @return mixed
33	*/
34	public function __construct( $actionId = null ) {
35	$this->tableName = "`E4_activity_actions`";
36	if( !is_null( $actionId ) ){
37	$this->actionId( '=', $actionId );
38	}
39	}//End __construct()
40
41
42	/**
43	* Resets the comparison array and returns "$this"
44	* If "$this" is "new" then it's simply used as a "syntactical" method so the method calls read more like English.
45	* This method override of AbstractIdentity is simply so that UserSelector is returned and hinted rather than AbstractIdentity.
46	* @return IdentityForE4ActivityActions
47	*/
48	public function select(){
49	parent::select();
50	return $this;
51	}//End
52
53
54	/**
55	* Adds a custom clause into the select query.
56	* This method override of AbstractIdentity is simply so that UserSelector is returned and hinted rather than AbstractIdentity.
57	* @param type $clause
58	* @return AbstractIdentity
59	*/
60	public function customClause( $clause ){
61	parent::custom( $clause );
62	return $this;
63	}//End
64
65
66	/**
67	* Used to define a faux column( s ) to be returned in the result set.
68	* This method override of AbstractIdentity is simply so that UserSelector is returned and hinted rather than AbstractIdentity.
69	* @param string $definition
70	* @return IdentityForE4ActivityActions
71	*/
72	public function customColumn( $definition ) {
73	parent::customColumn( $definition );
74	return $this;
75	}//End
76
77
78	/**
79	* Returns the concrete map for VoE4ActivityActions
80	*
81	* @access public
82	* @author Todd Mullen - ???, <AnEmail@gmail.com>
83	* @return DaoE4ActivityActions
84	*/
85	protected function getMap() {
86	if( empty( $this->map ) ){
87	$this->map = new DaoE4ActivityActions;
88	}
89	return $this->map;
90	}//End
91
92
93	public function getCollection( $rawAry = array() ) {
94	return new CollectionOfE4ActivityActionss( $rawAry );
95	}//End
96
97
98	/**
99	* Compares `action_id` to $val using $comp
100	* @param string $comp The comparison to use. E.g.: =, <, >, LIKE
101	* @param mixed $val int(11) unsigned
102	* @return IdentityForE4ActivityActions
103	*/
104	public function actionId( $comp, $val ){
105	$this->comps[] = "$this->tableName.`action_id` $comp $val";
106	return $this;
107	}//End actionId
108
109
110	/**
111	* Compares `attachment_count` to $val using $comp
112	* @param string $comp The comparison to use. E.g.: =, <, >, LIKE
113	* @param mixed $val smallint(3) unsigned
114	* @return IdentityForE4ActivityActions
115	*/
116	public function attachmentCount( $comp, $val ){
117	$this->comps[] = "$this->tableName.`attachment_count` $comp $val";
118	return $this;
119	}//End attachmentCount
120
121
122	/**
123	* Compares `body` to $val using $comp
124	* @param string $comp The comparison to use. E.g.: =, <, >, LIKE
125	* @param mixed $val text
126	* @return IdentityForE4ActivityActions
127	*/
128	public function body( $comp, $val ){
129	$this->comps[] = "$this->tableName.`body` $comp $val";
130	return $this;
131	}//End body
132
133
134	/**
135	* Compares `comment_count` to $val using $comp
136	* @param string $comp The comparison to use. E.g.: =, <, >, LIKE
137	* @param mixed $val mediumint(5) unsigned
138	* @return IdentityForE4ActivityActions
139	*/
140	public function commentCount( $comp, $val ){
141	$this->comps[] = "$this->tableName.`comment_count` $comp $val";
142	return $this;
143	}//End commentCount
144
145
146	/**
147	* Compares `date` to $val using $comp
148	* @param string $comp The comparison to use. E.g.: =, <, >, LIKE
149	* @param mixed $val datetime
150	* @return IdentityForE4ActivityActions
151	*/
152	public function date( $comp, $val ){
153	$this->comps[] = "$this->tableName.`date` $comp $val";
154	return $this;
155	}//End date
156
157
158	/**
159	* Compares `like_count` to $val using $comp
160	* @param string $comp The comparison to use. E.g.: =, <, >, LIKE
161	* @param mixed $val mediumint(5) unsigned
162	* @return IdentityForE4ActivityActions
163	*/
164	public function likeCount( $comp, $val ){
165	$this->comps[] = "$this->tableName.`like_count` $comp $val";
166	return $this;
167	}//End likeCount
168
169
170	/**
171	* Compares `object_id` to $val using $comp
172	* @param string $comp The comparison to use. E.g.: =, <, >, LIKE
173	* @param mixed $val int(11) unsigned
174	* @return IdentityForE4ActivityActions
175	*/
176	public function objectId( $comp, $val ){
177	$this->comps[] = "$this->tableName.`object_id` $comp $val";
178	return $this;
179	}//End objectId
180
181
182	/**
183	* Compares `object_type` to $val using $comp
184	* @param string $comp The comparison to use. E.g.: =, <, >, LIKE
185	* @param mixed $val varchar(24)
186	* @return IdentityForE4ActivityActions
187	*/
188	public function objectType( $comp, $val ){
189	$this->comps[] = "$this->tableName.`object_type` $comp $val";
190	return $this;
191	}//End objectType
192
193
194	/**
195	* Compares `params` to $val using $comp
196	* @param string $comp The comparison to use. E.g.: =, <, >, LIKE
197	* @param mixed $val text
198	* @return IdentityForE4ActivityActions
199	*/
200	public function params( $comp, $val ){
201	$this->comps[] = "$this->tableName.`params` $comp $val";
202	return $this;
203	}//End params
204
205
206	/**
207	* Compares `subject_id` to $val using $comp
208	* @param string $comp The comparison to use. E.g.: =, <, >, LIKE
209	* @param mixed $val int(11) unsigned
210	* @return IdentityForE4ActivityActions
211	*/
212	public function subjectId( $comp, $val ){
213	$this->comps[] = "$this->tableName.`subject_id` $comp $val";
214	return $this;
215	}//End subjectId
216
217
218	/**
219	* Compares `subject_type` to $val using $comp
220	* @param string $comp The comparison to use. E.g.: =, <, >, LIKE
221	* @param mixed $val varchar(24)
222	* @return IdentityForE4ActivityActions
223	*/
224	public function subjectType( $comp, $val ){
225	$this->comps[] = "$this->tableName.`subject_type` $comp $val";
226	return $this;
227	}//End subjectType
228
229
230	/**
231	* Compares `type` to $val using $comp
232	* @param string $comp The comparison to use. E.g.: =, <, >, LIKE
233	* @param mixed $val varchar(32)
234	* @return IdentityForE4ActivityActions
235	*/
236	public function type( $comp, $val ){
237	$this->comps[] = "$this->tableName.`type` $comp $val";
238	return $this;
239	}//End type
240
241
242	// --- Override common methods to return $this ( rather than the parent ) ---
243
244
245	/**
246	* @return IdentityForE4ActivityActions
247	*/
248	public function andWith() {
249	parent::andWith();
250	return $this;
251	}//End
252
253
254	/**
255	* @return IdentityForE4ActivityActions
256	*/
257	public function orWith() {
258	parent::orWith();
259	return $this;
260	}//End
261
262
263	/**
264	* Adds a custom list of allowed values for a column ("IN clause") to the query to be executed.
265	* @param array $ary An array that contains the allowed values for the SQL query.
266	* E.g. inThis( array( 'dog', 2, 'hair' ) will add `column` IN ( "dog", 2, "hair" ) to the query.
267	* @return IdentityForE4ActivityActions
268	*/
269	public function inThis( $ary ) {
270	parent::inThis( $ary );
271	return $this;
272	}//End
273
274
275	/**
276	* Sets the GROUP BY clause using $col
277	* @param string $col The name of the column to group the results with.
278	* @return IdentityForE4ActivityActions
279	*/
280	public function groupBy( $col ) {
281	parent::groupBy( $col );
282	return $this;
283	}//End
284
285
286	/**
287	* Builds a SELECT query from the set criteria and retrieves the table rows that match.
288	* Returns A COLLECTION of concrete objects EVEN if there's only one matching row.
289	*
290	* @access public
291	* @author Todd Mullen - ???, <AnEmail@gmail.com>
292	* @return AbstractCollection
293	*/
294	//Finish moving the load methods from the maps to the Identities.
295	public function fetch() {
296	$fauxCols = $this->customCols ? ", " . implode( ", ", $this->customCols ) : "";
297	$sql = "SELECT *$fauxCols FROM "
298	. $this->tableName
299	. $this->sqlWhereClause()
300	. $this->sqlOrderByClause()
301	. $this->sqlGroupByClause()
302	. $this->sqlLimitClause();
303	echo "<b>" . __METHOD__ . "()</b> using query: “" . $sql . "”<br />";
304	/* @var $result mysqli_result */
305	$result = DbPogopogoSe4::mysqli()->query( $sql );
306	$rawAry = array();
307	if( $result ) {
308	while( $row = $result->fetch_assoc() ) {
309	if( empty( $row['body'] ) ) {
310	$row['body'] = "";
311	}
312	if( empty( $row['params'] ) ) {
313	$row['params'] = "";
314	}
315	$rawAry[] = $row;
316	}
317	$result->close();
318	} else {
319	$sqlError = DbPogopogoSe4::mysqli()->error;
320	if( $sqlError ) {
321	throw new Exception( $sqlError );
322	}
323	}
324	return $this->getMap()->getCollection( $rawAry );
325	}//End fetch()
326
327
328	/**
329	* @return IdentityForE4ActivityActions
330	*/
331	public function limit( $start = 0, $num = 1 ) {
332	parent::limit( $start, $num );
333	return $this;
334	}//End
335
336
337	public function __toString() {
338	return __CLASS__ . " current "where" clause: “" . $this->sqlWhereClause() . "”";
339	}//End
340	/////// AbstractIdentity Method Overrides ///////
341
342	/////// End AbstractIdentity Method Overrides ///////
343
344	}//End BaseIdentityForE4ActivityActions
345	?>

IdentityForEngine4ActivityActions.class.php - Child “Activity Actions Identity Map”

1	<?php
2	//namespace org/imaginus/pogopogoSe4/php/vodaodb/identities/
3
4
5	/////// PUT CUSTOM CODE FOR `E4_activity_actions` VO Selectors IN THIS CLASS.
6
7
8	/************************************************
9	* Generated by VoDaoDb Wed Jul 3 18:13:58 GMT-0400 2013
10	* @author Todd Mullen, <AnEmail@gmail.com>)
11	* @copyright Do whatever you want except sell my work as yours, or reverse engineer it so you can make changes and then sell that as yours.
12	* @license @see copyright
13	* @filesource VoDaoDb v0.9 - Imaginus.org
14	*
15	*****************
16	* Project: pogopogoSe4
17	* Parent: imaginus.org
18	* //No class comments
19	************************************************/
20	require_once 'base/BaseIdentityForE4ActivityActions.class.php';
21	class IdentityForE4ActivityActions
22	extends BaseIdentityForE4ActivityActions {
23
24
25	/**
26	* __construct() sets all the required properties defined in the 'AbstractIdentity' superclass
27	*
28	* @access public
29	* @author Todd Mullen - ???, <AnEmail@gmail.com>
30	* @return void
31	*/
32	public function __construct() {
33	parent::__construct();
34	}//End __construct()
35
36
37	}//End IdentityForE4ActivityActions
38	?>

AbstractCollection.class.php - Abstract Shared Collection Implementation

1	<?php
2	//namespace org/imaginus/pogopogoSe4/php/vodaodb/collections/
3
4
5	/////// YOU CAN PUT CUSTOM CODE HERE AT YOUR OWN RISK!
6	/////// PUT CUSTOM CODE ALL COLLECTIONS TO INHERIT, N/////// BUT BE WARY OF OVERWRITING THIS FILE IF YOU DO AND THEN RE-GENERATE THE COLLECTIONS!
7
8
9	/************************************************
10	* Generated by VoDaoDb Wed Jul 3 18:14:00 GMT-0400 2013
11	* @author Todd Mullen, <AnEmail@gmail.com>)
12	* @copyright Do whatever you want except sell my work as yours, or reverse engineer it so you can make changes and then sell that as yours.
13	* @license @see copyright
14	* @filesource VoDaoDb v0.9 - Imaginus.org
15	*
16	*****************
17	* Project: pogopogoSe4
18	* Parent: imaginus.org
19	* //No class comments
20	************************************************/
21	/**
22	* AbstractCollection is an abstract class that implements common functionality for all Collection classes.
23	* The core features of Collections is the ability to mimic strongly typed arrays.
24	* This class implements the built in PHP 'Iterator' interface which allows you to use Collections in foreach() loops.
25	* In addition to providing type checking, the collection allows 'lazy instantiation' in that an array of raw object data ( as returned by a mysql query )
26	* can be given to it and the actual creation will be deffered until the object is actually used ( if it even is before the proces exits ).
27	* This helps to keep system resources from being used unnecessarily.
28	*/
29	abstract class AbstractCollection
30	implements Iterator {
31
32
33	/////// AbstractCollection Properties ///////
34
35	/**
36	* The name of the class that the collection is designed to store.
37	*
38	* @access protected
39	* @var string
40	*/
41	protected $_targetClassname = '';
42
43
44	/**
45	* The class name of the target class' AbstractDbTableMap
46	*
47	* @access protected
48	* @var string
49	*/
50	protected $_targetDbMap = null;
51
52
53	/**
54	* Contains arrays of database table row data.
55	* Each array corresponds to a single table row and is used to create a VO to represent that row.
56	*
57	* @access protected
58	* @var array
59	*/
60	protected $_raw = array();
61
62
63	/**
64	* An array of VOs that have already been created from the raw data contained in $this->_raw
65	*
66	* @access protected
67	* @var array
68	*/
69	protected $_objects = array();
70
71
72	/**
73	* The total number of potential objects the collection contains.
74	*
75	* @access protected
76	* @var int
77	*/
78	protected $_total = 0;
79
80
81	/**
82	* The current index of the collection when in a foreach loop.
83	*
84	* @access protected
85	* @var int
86	*/
87	protected $_pointer = 0;
88
89
90	/**
91	* Used to switch the direction that the colection is iterated over.
92	*
93	* @access protected
94	* @var bool
95	*/
96	protected $_reversed = false;
97
98
99	// --- OPERATIONS ---
100
101
102	/**
103	* If $rawAry is given, the array is used to build the collection's objects.
104	* If $voAry contains valid VOs for the collection, they are pushed into the collection.
105	* If $voAry contains other data or VOs of the wrong type, a type exception will be thrown.
106	*
107	* @access public
108	* @author Todd Mullen - ???, <AnEmail@gmail.com>
109	* @param array $rawAry[optional] An associative array of raw instance values for the collection.
110	*/
111	public function __construct( $rawAry = array(), $voAry = array() ) {
112	$this->_raw = $rawAry;
113	$this->_total = count( $rawAry );
114	if( $voAry ) {
115	foreach ( $voAry as $vo ) {
116	$this->push( $vo );
117	}
118	}
119	}//End __construct()
120
121
122	/**
123	* Returns the Value/Domain Object class name that the specific concrete collection
124	* is built to work with/typed to.
125	*
126	* @access public
127	* @author Todd Mullen - ???, <AnEmail@gmail.com>
128	* @return string
129	*/
130	public function targetClass() {
131	if( !$this->_targetClassname ) {
132	throw new Exception( "Target class name has not been set." );
133	}
134	return $this->_targetClassname;
135	}//End targetClass()
136
137
138	/**
139	* Compares the type of $vo with _targetClassname.
140	* Returns true if they match, false otherwise.
141	*
142	* @access public
143	* @author Todd Mullen - ???, <AnEmail@gmail.com>
144	* @param AbstractValueObject $vo The concrete DomainObject that is to be checked.
145	* @return bool True on match, false otherwise.
146	*/
147	public function typeMatch( $vo ) {
148	return get_class( $vo ) == $this->_targetClassname;
149	}//End typeMatch()
150
151
152	// --- PHP Iterator interface methods ---
153
154
155	/**
156	* Built in Iterator method.
157	* Resets the current pointer position to "the beginning" of the collection
158	* $this->_pointer = if( !$this->_reversed ){0} else {$this->_total - 1};
159	*
160	* @access public
161	* @author Todd Mullen - ???, <AnEmail@gmail.com>
162	* @return void
163	*/
164	public function rewind() {
165	//echo "<b>" . __METHOD__ . "()</b><br/>";
166	$this->_pointer = !$this->_reversed ? 0 : $this->_total - 1;
167	}//End rewind()
168
169
170	/**
171	* Built in Iterator method.
172	* Returns the AbstractValueObject at the current pointer position.
173	*
174	* @access public
175	* @author Todd Mullen - ???, <AnEmail@gmail.com>
176	* @return AbstractValueObject
177	*/
178	public function current() {
179	//echo "<b>" . __METHOD__ . "()</b> getting #$this->_pointer<br/>";
180	return $this->getRow( $this->_pointer );
181	}//End current()
182
183
184	/**
185	* Built in Iterator method.
186	* Returns the current pointer position.
187	*
188	* @access public
189	* @author Todd Mullen - ???, <AnEmail@gmail.com>
190	* @return int
191	*/
192	public function key() {
193	//echo "<b>" . __METHOD__ . "()</b><br/>";
194	return $this->_pointer;
195	}//End key()
196
197
198	/**
199	* Built in Iterator method.
200	* Advances the pointer by one.
201	* ( Increments if not reversed, decrements otherwise )
202	*
203	* @access public
204	* @author Todd Mullen - ???, <AnEmail@gmail.com>
205	* @return void
206	*/
207	public function next() {
208	//echo "<b>" . __METHOD__ . "()</b><br/>";
209	$this->_pointer += $this->_reversed ? -1 : 1;
210	}//End next()
211
212
213	/**
214	* Built in Iterator method.
215	* Returns true if the pointer position refers to a potential object ( row data in the raw array ).
216	*
217	* @access public
218	* @author Todd Mullen - ???, <AnEmail@gmail.com>
219	* @return bool
220	*/
221	public function valid() {
222	//echo "<b>" . __METHOD__ . "()</b><br/>";
223	$valid = (bool) isset( $this->_raw[$this->_pointer] );
224	echo "<b>" . __METHOD__ . "()</b> validating #$this->_pointer ( Result: $valid )<br/>";
225	return $valid;
226	}//End valid()
227
228
229	// --- End PHP Iterator interface methods ---
230
231
232	/**
233	* notifyAccess ...
234	*
235	* @access protected
236	* @author Todd Mullen - ???, <AnEmail@gmail.com>
237	* @return void
238	*/
239	protected function notifyAccess() {
240	//Deliberately empty
241	}//End notifyAccess()
242
243
244	/**
245	* Returns the object located at position $idx.
246	* Remember that collections are zero indexed and valid indexes ar 0 < $idx < ( total - 1 )
247	*
248	* @access public
249	* @author Todd Mullen - ???, <AnEmail@gmail.com>
250	* @param int $idx The collection index to return.
251	* @return AbstractValueObject
252	*/
253	public function getRow( $idx ) {
254	echo "<b>" . __METHOD__ . "()</b><br />";
255	$this->notifyAccess();
256	if( $idx > $this->_total \|\| $idx < 0 ) {
257	echo "Index ( $idx ) not valid! Total: ".$this->_total."<br />";
258	return null;
259	}//End
260	if( isset( $this->_objects[$idx] ) ) {
261	echo "Returning already built {$this->targetClass()} #$idx<br />";
262	return $this->_objects[$idx];
263	}
264	if( isset( $this->_raw[$idx] ) ) {
265	echo "Building and returning {$this->targetClass()} #$idx<br />";
266	$map = new $this->_targetDbMap();
267	$this->_objects[$idx] = $map->getVO( $this->_raw[$idx] );
268	unset( $map );
269	return $this->_objects[$idx];
270	}//End
271	}//End getRow()
272
273
274	/**
275	* Removes and returns the object at $idx.
276	* If $idx is not given, the "last" object in the collection is returned.
277	*
278	* @param int $idx[optional] The desired collection index to be returned. Default = "last"
279	* @return AbstractValueObject
280	*/
281	public function pop( $idx = null ) {
282	if( $idx < 0 \|\| $idx > $this->_total - 1 ) {
283	throw new Exception( "Invalid index. Cannot return index: $idx." );
284	}//End
285	$popIdx = is_null( $idx ) ? ( $this->_total - 1 ) : $idx;
286	$lastIdx = $this->_total - 1;
287	echo "<b>" . __METHOD__ . "()</b> getting index: $popIdx of {0 - $lastIdx} <br />";
288	$vo = $this->getRow( $popIdx );
289	echo "<b>" . __METHOD__ . "()</b> Unsetting $vo<br/>";
290	$this->remove( $popIdx );
291	return $vo;
292	}//End pop()
293
294
295	/**
296	* Removes and returns the first object in the collection.
297	*
298	* @access public
299	* @author Todd Mullen - ???, <AnEmail@gmail.com>
300	* @return AbstractValueObject
301	*/
302	public function shift() {
303	$first = $this->getRow( 0 );
304	$this->remove( 0 );
305	echo "<b>" . __METHOD__ . "()</b><br/>Returning: $first<br/>";
306	return $first;
307	}//End shift()
308
309
310	/**
311	* Returns a random object from the collection's objects.
312	* If $num is supplied then #$num random objects are returned in an array.
313	* Does NOT remove the instance from the collection
314	*
315	* @access public
316	* @author Todd Mullen - ???, <AnEmail@gmail.com>
317	* @param int num The maximum number of elements desired. ( Always fulfilled unless $this->_objects doesn't have that many objects. )
318	* @return AbstractCollection
319	*/
320	public function random( $num = 1 ) {
321	//Get an array of random valid indexes ( with count == $num ) to return from $this->_objects
322	$idxAry = array_rand( $this->_raw, $num );
323	if( $num == 1 ) {
324	return $this->getRow( $idxAry );
325	}//End
326	$coll = new $this();
327	foreach ( $idxAry as $idx ) {//Build a new array with just those indexes
328	$coll->push( $this->getRow( $idx ) );
329	}//End
330	return $coll;
331	}//End random()
332
333
334	/**
335	* Returns a new collection of raw object data using the "$funcName" function to filter the raw data by.
336	* $funcName( $object ) must return true if $object is to be included in the filtered results and false otherwise.
337	*
338	* @access public
339	* @author Todd Mullen - ???, <AnEmail@gmail.com>
340	* @param string funcName
341	* @return AbstractCollection
342	*/
343	public function filterRawWith( $funcName ) {
344	if( !function_exists( $funcName ) ) {
345	throw new Exception( __METHOD__ . " “$funcName()” is not defined." );
346	}//End
347	$voAry = array();
348	foreach ( $this->_raw as $idx => $valueAry ) {
349	echo "<b>" . __METHOD__ . "()</b><br/>...checking: " . print_r( $valueAry, true ) . " with $funcName()<br/>";
350	if( $funcName( $valueAry ) ) {
351	$voAry[] = $valueAry;
352	}//End
353	}//End
354	$newCollection = new $this( $voAry );
355	return $newCollection;
356	}//End filterRawWith()
357
358
359	/**
360	*
361	* @param type $funcName
362	* @return AbstractCollection
363	*/
364	public function filterVOsWith( $funcName ) {
365	if( !function_exists( $funcName ) ) {
366	throw new Exception( __METHOD__ . " “$funcName()” is not defined." );
367	}//End
368	$newCollection = new $this();
369	for ( $i = 0; $i < count( $this->_raw ); $i++ ) {
370	$vo = $this->getRow( $i );
371	echo "<b>" . __METHOD__ . "()</b><br/>...checking UserVO.{$vo->getUserId()} with $funcName()<br/>";
372	if( $funcName( $vo ) ) {
373	$newCollection->push( $vo );
374	}//End
375	}//End
376	return $newCollection;
377	}//End filterVOsWith()
378
379
380	/**
381	* Verifies the class type then adds another domain object to the end of the collection then increments the total.
382	* Note: DOES NOT check if the VO is already present. This allows you to push a VO into the collection multiple times if desired,
383	* but it also means you are responsible for the duplication.
384	*
385	* @access public
386	* @author Todd Mullen - ???, <AnEmail@gmail.com>
387	* @param AbstractValueObject do
388	* @return void
389	*/
390	public function push( AbstractValueObject $vo ) {
391	if( !$this->typeMatch( $vo ) ) {
392	throw new Exception( "Cannot add do to this collection it is not a '" . $this->_targetClassname . "' instance." );
393	}//End
394	echo "<b>" . __METHOD__ . "()</b> adding {$vo->globalKeyStr()} to the collection<br/>";
395	$this->notifyAccess();
396	$this->_raw[ $this->_total ] = $vo->toArray();
397	$this->_objects[ $this->_total ] = $vo;
398	$this->_total++;
399	}//End push()
400
401
402	/**
403	* Reverses the direction that the collection will be iterated through in loops.
404	* last -> first
405	*
406	* @access public
407	* @author Todd Mullen - ???, <AnEmail@gmail.com>
408	* @param bool
409	* @return void
410	*/
411	public function reverse() {
412	$this->_reversed = true;
413	}//End reverse()
414
415
416	/**
417	* Sets the direction that the collection will be iterated through in loops to move forward.
418	* first -> last
419	*
420	* @access public
421	* @author Todd Mullen - ???, <AnEmail@gmail.com>
422	* @param bool
423	* @return void
424	*/
425	public function forward() {
426	$this->_reversed = false;
427	}//End forward()
428
429
430	/**
431	* Accepts an indexed array of objects and rebuilds it minus the object set at $idx.
432	* This method must be used to remove objects because indexed arrays don't automatically
433	* renumber themselves when elements are removed. So, the array must be rebuilt to re-nuber them.
434	*
435	* @access private
436	* @author Todd Mullen - ???, <AnEmail@gmail.com>
437	* @param array $ogAry The original array of AbstractValueObjects that $removedDo should be removed from.
438	* @param int $idx The index to be removed.
439	* @return array The original array ( $ogAry ) minus $removedDo ( if it was present ).
440	*/
441	public function remove( $idx ) {
442	echo "Removing the object at index #$idx from the collection.<br/>";
443	$ary = array();
444	foreach ( $this->_objects as $theIdx => $obj ) {
445	if( $idx != $theIdx ) {$ary[] = $obj;}
446	}//End
447	$this->_objects = $ary;
448	$ary = array();
449	foreach ( $this->_raw as $theIdx => $obj ) {
450	if( $idx != $theIdx ) {$ary[] = $obj;}
451	}//End
452	$this->_raw = $ary;
453	$this->_total--;
454	echo "New Collection Total: $this->_total<br/>";
455	unset( $ary );
456	}//End remove()
457
458
459	/**
460	* Empties both the raw and object arrays to empty and rewinds the collection.
461	* DOES NOT alter its "reversed" status.
462	* The collection will continue to iterate in the same manner as before calling removeAll().
463	*
464	* @access public
465	* @author Todd Mullen - ???, <AnEmail@gmail.com>
466	* @return void
467	*/
468	public function removeAll() {
469	echo "<b>" . __METHOD__ . "()</b> Emptying collection data...<br/>";
470	unset( $this->_raw, $this->_objects );
471	$this->_raw = $this->_objects = array();
472	$this->rewind();
473	}//End removeAll()
474
475
476	/**
477	* Empties the collection and replaces the raw VO data with $rawAry.
478	*
479	* @access public
480	* @author Todd Mullen - ???, <AnEmail@gmail.com>
481	* @param array $rawAry An array of raw VO data arrays
482	* @return void
483	*/
484	public function replaceRaw( array $rawAry ) {
485	echo "<b>" . __METHOD__ . "()</b> replacing collection data with raw array data: <br/>" . print_r( $rawAry, true );
486	$this->removeAll();
487	$this->_raw = $rawAry;
488	}//End replaceRaw()
489
490
491	/**
492	* Empties the collection and replaces its data with the VOs in $voAry by calling push() on each VO.
493	* If $voAry contains an element that is not a VO, or is not the correct type for the VO,
494	* an exception will be thrown by the push() method.
495	*
496	* @access public
497	* @author Todd Mullen - ???, <AnEmail@gmail.com>
498	* @see AbstractCollection::push()
499	* @param array $voAry An array of appropriate VO objects
500	* @return void
501	*/
502	public function replaceVOs( array $voAry ) {
503	echo "<b>" . __METHOD__ . "()</b> replacing collection data with VO data <br/>";
504	$this->removeAll();
505	foreach( $voAry as $vo ) {
506	echo "Adding: $vo<br/>";
507	$this->push( $vo );
508	}//End
509	}//End replaceVOs()
510
511
512	/**
513	* Returns the total number of potential ( raw ) objects in the collection.
514	* @access public
515	* @author Todd Mullen - ???, <AnEmail@gmail.com>
516	* @return int
517	*/
518	public function count() {
519	return count( $this->_raw );
520	}//End count()
521
522
523	/**
524	* "Magic method" called when echo or print is called on the collection.
525	* @access public
526	* @author Todd Mullen - ???, <AnEmail@gmail.com>
527	* @return string
528	*/
529	public function __toString() {
530	//echo "Using: $this->_raw, $this->_objects<br/>";
531	return "<div><b>" . __METHOD__ . "()</b><br />Raw VO Data ( Total = " . count( $this->_raw )
532	. " ):<br />" . $this->aryDump( $this->_raw, "Raw" )
533	. "Built $this->_targetClassname Objects ( Total = " . count( $this->_objects ) . " of " . count( $this->_raw )
534	. " ):<br />" . $this->aryDump( $this->_objects, "VO" ) . "</div>";
535	}//End __toString()
536
537
538	/**
539	* Simply a convenience method used by __toString() to format the contents of the collection.
540	* @param array $ary The array to be formatted as a string.
541	* @param string $label The label to use before each element's "index: formatted string."
542	* @return string
543	*/
544	protected function aryDump( $ary, $label ) {
545	$str = "";
546	foreach ( $ary as $k => $value ) {
547	$voStr = is_array( $value ) ? print_r( $value, true ) : $value;
548	$str .= "$label $k: " . $voStr ."<br />";
549	}//End
550	return $str;
551	}//End aryDump()
552	}//End AbstractCollection
553	?>

CollectionOfEngine4ActivityActionsettingss.class.php - “Activity Actions” Collection

1	<?php
2	//namespace org/imaginus/pogopogoSe4/php/vodaodb/collections/
3
4
5	/////// PUT CUSTOM CODE FOR `E4_activity_actionsettings` VOs Collections IN THIS CLASS.
6
7
8	/************************************************
9	* Generated by VoDaoDb Wed Jul 3 18:14:00 GMT-0400 2013
10	* @author Todd Mullen, <AnEmail@gmail.com>)
11	* @copyright Do whatever you want except sell my work as yours, or reverse engineer it so you can make changes and then sell that as yours.
12	* @license @see copyright
13	* @filesource VoDaoDb v0.9 - Imaginus.org
14	*
15	*****************
16	* Project: pogopogoSe4
17	* Parent: imaginus.org
18	* //No class comments
19	************************************************/
20	require_once 'AbstractCollection.class.php';
21	class CollectionOfE4ActivityActionsettingss
22	extends AbstractCollection {
23
24
25	public function __construct( $rawAry = array(), $voAry = array() ) {
26	$this->_targetClassname = "VoE4ActivityActionsettings";
27	$this->_targetDbMap = "DaoE4ActivityActionsettings";
28	parent::__construct( $rawAry, $voAry );
29	}//End __construct()
30
31
32	}//End CollectionOfE4ActivityActionsettingss
33	?>

IValueObject.iface.php - The PHP Value Object Interface

1	<?php
2	//namespace org/imaginus/pogopogoSe4/php/vodaodb/vos/
3
4
5	/////// This class declares the IValueObject interface.
6	///// The generated VOs implement IValueObject to facilitate polymorphism.
7
8
9	/************************************************
10	* Generated by VoDaoDb Wed Jul 3 18:14:00 GMT-0400 2013
11	* @author Todd Mullen, <AnEmail@gmail.com>)
12	* @copyright Do whatever you want except sell my work as yours, or reverse engineer it so you can make changes and then sell that as yours.
13	* @license @see copyright
14	* @filesource VoDaoDb v0.9 - Imaginus.org
15	*
16	*****************
17	* Project: pogopogoSe4
18	* Parent: imaginus.org
19	* //No class comments
20	************************************************/
21
22
23	if ( 0 > version_compare( PHP_VERSION, '5' ) ) {
24	die( 'This file was generated for PHP 5' );
25	}
26
27
28	//--- ID Methods ---//
29	interface IValueObject {
30	public function globalKeyStr();
31	public function primaryKeyAry();
32	public function sqlKeyStr();
33	//--- Utility Methods ---//
34	public function initAllValues( array $propAry );
35	public function map();
36	public function isFromDb();
37	public function __clone();
38	public function __toString();
39	public function toArray();
40	//--- VO State/Unit of Work Methods ---//
41	public function markNew();
42	public function markClean();
43	public function markDirty();
44	public function markDeleted();
45	//--- Db Access Methods ---//
46	public function insertNow();
47	public function updateNow();
48	public function deleteNow();
49	}//End IValueObject
50	?>

AbstractValueObject.class.php - Abstract Value Object Class

1	<?php
2	//namespace org/imaginus/pogopogoSe4/php/vodaodb/vos/
3
4
5	/////// YOU CAN PUT CUSTOM CODE HERE AT YOUR OWN RISK!
6	/////// PUT CUSTOM CODE FOR ALL SELECTORS TO INHERIT,
7	/////// BUT BE WARY OF OVERWRITING THIS FILE IF YOU DO AND THEN RE-GENERATE THE SELECTORS!
8
9
10	/************************************************
11	* Generated by VoDaoDb Wed Jul 3 18:14:00 GMT-0400 2013
12	* @author Todd Mullen, <AnEmail@gmail.com>)
13	* @copyright Do whatever you want except sell my work as yours, or reverse engineer it so you can make changes and then sell that as yours.
14	* @license @see copyright
15	* @filesource VoDaoDb v0.9 - Imaginus.org
16	*
17	*****************
18	* Project: pogopogoSe4
19	* Parent: imaginus.org
20	* //No class comments
21	************************************************/
22
23
24	/**
25	* Include the IValueObject interface
26	*
27	* @author Todd Mullen - ???, <AnEmail@gmail.com>
28	*/
29	require_once 'IValueObject.iface.php';
30
31
32	/**
33	* Include the DbExchange::Store() for the Unit of Work methods: markNew(), markClean(), markDeleted(), & markDirty()
34	*
35	* @author Todd Mullen - ???, <AnEmail@gmail.com>
36	*/
37	require_once dirname(__FILE__) . '/../../DbExchange.class.php';
38
39
40	/**
41	* AbstractValueObject provides shared methods used to monitor VO instantiation and database synchronization.
42	* These methods are shared by all concrete Value Objects.
43	*
44	* @abstract
45	* @access public
46	* @author Todd Mullen - ???, <AnEmail@gmail.com>
47	*/
48	abstract class AbstractValueObject
49	implements IValueObject {
50
51
52	/**
53	* Boolean value specifying if the VO is based on a Db VIEW
54	* @var bool $isView
55	*/
56	protected $isView;
57
58
59	/**
60	* An instance of the specific table DAO
61	* @var $map
62	*/
63	protected $_map;
64
65
66	public function __construct() {
67	//Nothing to do here
68	}//End __construct()
69
70
71	// --- ABSTRACT OPERATIONS ---//
72
73
74	/**
75	* Accepts $valAry ( associative array ) of propertyNames=>values specific to the concrete ValueObject.
76	* It checks $valAry for each instance property and sets it, if it exists in the array.
77	* Implemented by concrete child classes that know their own property names.
78	* Unknown array keys are ignored.
79	*
80	* @abstract
81	* @access public
82	* @author Todd Mullen - ???, <AnEmail@gmail.com>
83	* @param array $valAry The asociative array of property=>value pairs to be set on/in an instance.
84	* @return void
85	abstract public function initAllValues( $valAry );
86	*/
87
88
89	/**
90	* Override this method to prevent inappropriate duplication of the object.
91	* E.g. $this->_user_id = -1 ( to prevent a clone from ovewriting the original's values in the Db table).
92	*
93	* @abstract
94	* @access public
95	* @author Todd Mullen - ???, <AnEmail@gmail.com>
96	* @return AbstractValueObject Returns the concrete VO with any unique properties removed.
97	abstract public function __clone();
98	*/
99
100
101	/**
102	* Returns a string that describes the concrete class instance.
103	* Called automatically when an instance is used in a string context.
104	* E.g. "( UserVO) { Key: 325, user_id: 325, username: 'UsernameNow14', pwd: 'NewPwdNow88' } "
105	*
106	* @abstract
107	* @access public
108	* @author Todd Mullen - ???, <AnEmail@gmail.com>
109	* @return string A human readible description of the VO instance.
110	abstract public function __toString();
111	*/
112
113
114	// --- END ABSTRACT OPERATIONS --- //
115
116
117	// --- SHARED OPERATIONS --- //
118
119
120	// --- Table Map Delegates --- //
121	/**
122	* Delegates to the concrete DbTableMap to construct a unique key string based on the object's primary key in it's Db table.
123	*
124	* @access public
125	* @author Todd Mullen - ???, <AnEmail@gmail.com>
126	* @return string
127	*/
128	public function getKeyStr() {
129	return $this->map()->getKeyStr( $this);
130	}//End getKeyStr()
131
132
133	/**
134	* Delegates to the concrete DbTableMap to construct a unique key string based on the VO class name
135	* and the object's primary key in it's Db table. This prevents ID conflicts between tables.
136	*
137	* @access public
138	* @author Todd Mullen - ???, <AnEmail@gmail.com>
139	* @return string
140	*/
141	public function globalKeyStr() {
142	return $this->map()->globalKeyStr( $this);
143	}//End globalKeyStr()
144
145
146	/**
147	* Delegates to the concrete DbTableMap to construct an associative array of property names=>values.
148	* This method essentially reverses the init() method.
149	* This was created so that Collection classes could accept built VOs being added and keep an accurate tally of its contained objects.
150	*
151	* @access public
152	* @author Todd Mullen - ???, <AnEmail@gmail.com>
153	* @return string
154	*/
155	public function toArray() {
156	echo "<b>" . __METHOD__ . "()</b> converting $this to an associative array...<br/>";
157	return $this->map()->voToArray( $this);
158	}//End toArray()
159	/**
160	* Calls map::insertNow() to insert the object immediately.
161	* @return bool True on success false otherwise.
162	*/
163	public function insertNow() {
164	echo "<b>" . __METHOD__ . "()</b> delegating to concrete map...<br/>";
165	return $this->map()->insertNow( $this);
166	}//End insertNow()
167
168
169	/**
170	* Calls map::updateNow() to update the object immediately.
171	* @return bool True on success false otherwise.
172	*/
173	public function updateNow() {
174	echo "<b>" . __METHOD__ . "()</b> delegating to concrete map...<br/>";
175	return $this->map()->updateNow( $this);
176	}//End updateNow()
177
178
179	/**
180	* Calls map::deleteNow() to delete the object immediately.
181	* @return bool True on success false otherwise.
182	*/
183	public function deleteNow() {
184	echo "<b>" . __METHOD__ . "()</b> delegating to concrete map...<br/>";
185	return $this->map()->deleteNow( $this);
186	}//End deleteNow()
187
188
189	// --- End Table Map Delegates --- //
190
191
192	// --- Unit of Work / DbExchange Method Callers --- //
193
194
195	/**
196	* Registers the instance with the DbExchange::Store() singleton as being a new instance
197	* that needs database insertion ( INSERT).
198	*
199	* @access public
200	* @author Todd Mullen - ???, <AnEmail@gmail.com>
201	* @return void
202	*/
203	public function markNew() {
204	echo "<b>" . __METHOD__ . "()</b> <br/>";
205	DbExchange::Store()->addNew( $this);
206	}//End markNew()
207
208
209	/**
210	* Registers the instance with the DbExchange::Store() singleton as being
211	* in sync with the database values ( void).
212	*
213	* @access public
214	* @author Todd Mullen - ???, <AnEmail@gmail.com>
215	* @return void
216	*/
217	public function markClean() {
218	echo "<b>" . __METHOD__ . "()</b> <br/>";
219	DbExchange::Store()->addClean( $this);
220	}//End markClean()
221
222
223	/**
224	* Registers the instance with the DbExchange::Store() singleton as requiring
225	* synchronization ( UPDATE).
226	*
227	* @access public
228	* @author Todd Mullen - ???, <AnEmail@gmail.com>
229	* @return void
230	*/
231	public function markDirty() {
232	echo "<b>" . __METHOD__ . "()</b> <br/>";
233	DbExchange::Store()->addDirty( $this);
234	}//End markDirty()
235
236
237	/**
238	* Registers the instance with the DbExchange::Store() singleton as requiring
239	* deletion ( DELETE)
240	*
241	* @access public
242	* @author Todd Mullen - ???, <AnEmail@gmail.com>
243	* @return void
244	*/
245	public function markDeleted() {
246	echo "<b>" . __METHOD__ . "()</b> <br/>";
247	DbExchange::Store()->addDeleted( $this);
248	}//End markDeleted()
249
250
251	// --- End Unit of Work / DbExchange Method Callers --- //
252
253
254	} /* end of abstract class AbstractValueObject */
255
256
257	?>

BaseVoEngine4ActivityActions.class.php - Parent “Activity Actions VO”

1	<?php
2	//namespace org/imaginus/pogopogoSe4/php/vodaodb/vos/
3
4
5	/////// DO NOT PUT CUSTOM CODE HERE!
6	/////// PUT CUSTOM CODE FOR THE `E4_activity_actions` TABLE IN VoE4ActivityActions.
7
8
9	/************************************************
10	* Generated by VoDaoDb Wed Jul 3 18:14:00 GMT-0400 2013
11	* @author Todd Mullen, <AnEmail@gmail.com>)
12	* @copyright Do whatever you want except sell my work as yours, or reverse engineer it so you can make changes and then sell that as yours.
13	* @license @see copyright
14	* @filesource VoDaoDb v0.9 - Imaginus.org
15	*
16	*****************
17	* Project: pogopogoSe4
18	* Parent: imaginus.org
19	* //No class comments
20	************************************************/
21	/**
22	* AbstractValueObject defines properties and implements methods that are shared by all concrete Value Objects
23	*
24	* @author Todd Mullen - ???, <AnEmail@gmail.com>
25	*/
26	require_once 'AbstractValueObject.class.php';
27	/**
28	* Include the table specific map class for VoE4ActivityActions to be used in/by the parent AbstractValueObject map methods.
29	*
30	* @author Todd Mullen - ???, <AnEmail@gmail.com>
31	*/
32	require_once dirname(__FILE__) . '/../../maps/DaoE4ActivityActions.class.php';
33
34
35	/**
36	* BaseVoE4ActivityActions holds all the properties, getters, & setters of the `E4_activity_actions` table in addition to VoDaoDb methods for interacting with the other classes generated for `E4_activity_actions`.
37	* Place any custom properties & methods in VoE4ActivityActions. This provides a layer of abstraction between the database specific code and your domain specific code.
38	* If you modify the database, you can regenerate all the VoDaoDb classes and replace only the "Base" & abstract classes to reflect the new schema.
39	* This will prevent overwriting your custom code, although depending on its nature; it may need to be refactored to work with the new schema.
40	* This class is declared abstract so that __toString() & __clone() can be implemented to reflect the final concrete child class.
41	*
42	* @abstract
43	* @author Todd Mullen - ???, <AnEmail@gmail.com>
44	*/
45	abstract class BaseVoE4ActivityActions
46	extends AbstractValueObject {
47
48
49	/////// `E4_activity_actions` COLUMN NAME CONSTANTS ///////
50
51	const ACTION_ID = "action_id";
52	const ATTACHMENT_COUNT = "attachment_count";
53	const BODY = "body";
54	const COMMENT_COUNT = "comment_count";
55	const DATE = "date";
56	const LIKE_COUNT = "like_count";
57	const OBJECT_ID = "object_id";
58	const OBJECT_TYPE = "object_type";
59	const PARAMS = "params";
60	const SUBJECT_ID = "subject_id";
61	const SUBJECT_TYPE = "subject_type";
62	const TYPE = "type";
63	/////// `E4_activity_actions` Row/Column Properties ///////
64
65	/**
66	* Table.Column: `E4_activity_actions`.`action_id`
67	* @TableComment:
68	* @Key: Primary key or part of a multi-column primary key
69	* @Type int(11) unsigned
70	* @TableDefault null
71	* @Nullable: false
72	* @Extra: auto_increment
73	*/
74	protected $_actionId;//No table default
75
76
77	/**
78	* Table.Column: `E4_activity_actions`.`attachment_count`
79	* @TableComment:
80	* @Key: Column is not indexed or is only indexed as a column in a multi-column, non-unique index.
81	* @Type smallint(3) unsigned
82	* @TableDefault 0
83	* @Nullable: false
84	* @Extra:
85	*/
86	protected $_attachmentCount = 0;//Table default
87
88
89	/**
90	* Table.Column: `E4_activity_actions`.`body`
91	* @TableComment:
92	* @Key: Column is not indexed or is only indexed as a column in a multi-column, non-unique index.
93	* @Type text
94	* @TableDefault null
95	* @Nullable: true
96	* @Extra:
97	*/
98	protected $_body;//No table default
99
100
101	/**
102	* Table.Column: `E4_activity_actions`.`comment_count`
103	* @TableComment:
104	* @Key: Column is not indexed or is only indexed as a column in a multi-column, non-unique index.
105	* @Type mediumint(5) unsigned
106	* @TableDefault 0
107	* @Nullable: false
108	* @Extra:
109	*/
110	protected $_commentCount = 0;//Table default
111
112
113	/**
114	* Table.Column: `E4_activity_actions`.`date`
115	* @TableComment:
116	* @Key: Column is not indexed or is only indexed as a column in a multi-column, non-unique index.
117	* @Type datetime
118	* @TableDefault null
119	* @Nullable: false
120	* @Extra:
121	*/
122	protected $_date;//No table default
123
124
125	/**
126	* Table.Column: `E4_activity_actions`.`like_count`
127	* @TableComment:
128	* @Key: Column is not indexed or is only indexed as a column in a multi-column, non-unique index.
129	* @Type mediumint(5) unsigned
130	* @TableDefault 0
131	* @Nullable: false
132	* @Extra:
133	*/
134	protected $_likeCount = 0;//Table default
135
136
137	/**
138	* Table.Column: `E4_activity_actions`.`object_id`
139	* @TableComment:
140	* @Key: Column is not indexed or is only indexed as a column in a multi-column, non-unique index.
141	* @Type int(11) unsigned
142	* @TableDefault null
143	* @Nullable: false
144	* @Extra:
145	*/
146	protected $_objectId;//No table default
147
148
149	/**
150	* Table.Column: `E4_activity_actions`.`object_type`
151	* @TableComment:
152	* @Key: First, or only, column of a non-unique index
153	* @Type varchar(24)
154	* @TableDefault null
155	* @Nullable: false
156	* @Extra:
157	*/
158	protected $_objectType;//No table default
159
160
161	/**
162	* Table.Column: `E4_activity_actions`.`params`
163	* @TableComment:
164	* @Key: Column is not indexed or is only indexed as a column in a multi-column, non-unique index.
165	* @Type text
166	* @TableDefault null
167	* @Nullable: true
168	* @Extra:
169	*/
170	protected $_params;//No table default
171
172
173	/**
174	* Table.Column: `E4_activity_actions`.`subject_id`
175	* @TableComment:
176	* @Key: Column is not indexed or is only indexed as a column in a multi-column, non-unique index.
177	* @Type int(11) unsigned
178	* @TableDefault null
179	* @Nullable: false
180	* @Extra:
181	*/
182	protected $_subjectId;//No table default
183
184
185	/**
186	* Table.Column: `E4_activity_actions`.`subject_type`
187	* @TableComment:
188	* @Key: First, or only, column of a non-unique index
189	* @Type varchar(24)
190	* @TableDefault null
191	* @Nullable: false
192	* @Extra:
193	*/
194	protected $_subjectType;//No table default
195
196
197	/**
198	* Table.Column: `E4_activity_actions`.`type`
199	* @TableComment:
200	* @Key: Column is not indexed or is only indexed as a column in a multi-column, non-unique index.
201	* @Type varchar(32)
202	* @TableDefault null
203	* @Nullable: false
204	* @Extra:
205	*/
206	protected $_type;//No table default
207
208
209	/////// End `E4_activity_actions` Row/Column Properties ///////
210
211
212	/**
213	* This VO is based on a Db VIEW.
214	* It cannot be INSERTed, UPDATEed, DELETEd, etc.
215	*/
216	public function __construct() {
217	parent::__construct();
218	}//End __construct
219
220
221	/////// VoDaoDb Properties & Methods ///////
222
223
224
225	/**
226	* Sets ALL instance row properties for a/an E4_activity_actions row.
227	* All the following properties must be set or an Exception will be thrown.
228	* E.g. - array( 'actionId' => value, 'attachmentCount' => value, 'body' => value, 'commentCount' => value, 'date' => value, 'likeCount' => value, 'objectId' => value, 'objectType' => value, 'params' => value, 'subjectId' => value, 'subjectType' => value, 'type' => value
229	*
230	* @param $propAry - The associative array of property=>values
231	*/
232	public function initAllValues( array $propAry ) {
233	if( !( isset( $propAry['action_id'] ) && isset( $propAry['attachment_count'] ) && isset( $propAry['body'] ) && isset( $propAry['comment_count'] ) && isset( $propAry['date'] ) && isset( $propAry['like_count'] ) && isset( $propAry['object_id'] ) && isset( $propAry['object_type'] ) && isset( $propAry['params'] ) && isset( $propAry['subject_id'] ) && isset( $propAry['subject_type'] ) && isset( $propAry['type'] ) ) ) {
234	throw new Exception( __METHOD__ . "() requires the given array to have all values present: array( 'actionId' => value, 'attachmentCount' => value, 'body' => value, 'commentCount' => value, 'date' => value, 'likeCount' => value, 'objectId' => value, 'objectType' => value, 'params' => value, 'subjectId' => value, 'subjectType' => value, 'type' => value, Given: " . print_r( $propAry, true ) );
235	}
236	$this->_actionId = $propAry['action_id'];
237	$this->_attachmentCount = $propAry['attachment_count'];
238	$this->_body = $propAry['body'];
239	$this->_commentCount = $propAry['comment_count'];
240	$this->_date = $propAry['date'];
241	$this->_likeCount = $propAry['like_count'];
242	$this->_objectId = $propAry['object_id'];
243	$this->_objectType = $propAry['object_type'];
244	$this->_params = $propAry['params'];
245	$this->_subjectId = $propAry['subject_id'];
246	$this->_subjectType = $propAry['subject_type'];
247	$this->_type = $propAry['type'];
248	}//End initAllValues
249
250
251
252
253
254	/**
255	* Whether or not the VO instance was loaded from the `E4_activity_actions` table.
256	*
257	* @var $fromDb bool
258	*/
259	protected $fromDb = false;
260	/**
261	* True or false indicating whether the instance was originally loaded from the `E4_activity_actions` table.
262	* A value of true hints that the SQL should be an `UPDATE` on save.
263	* If false, save should be performed via `INSERT`
264	* @param bool $bool[optional] Default: null, If not null, it is cast as a boolean and the $fromDb property is updated.
265	* @return $isFromDb bool
266	*/
267	public function isFromDb( $bool = null ) {
268	if( !is_null( $bool ) ) {
269	$this->fromDb = (bool) $bool;
270	return;
271	}
272	return $this->fromDb;
273	}//End isFromDb()
274
275
276
277	/**
278	* Returns the SQL primary key string for the instance ( *IF8 it is fromDb ).
279	*
280	* @return string An empty string OR the SQL string that identifies the row associated with the instance.
281	*/
282	public function sqlKeyStr() {
283	if( $this->fromDb ) {
284	return "`E4_activity_actions`.`action_id` = '$this->_actionId'";
285	}
286	return '';
287	}//End sqlKeyStr()
288
289
290
291	/**
292	* The global domain key of the table row as a string.
293	* E.g. E4_activity_actions-2-1-3 ( Three column primary key )
294	*
295	* @var string
296	*/
297	protected $globalKey = null;
298	/**
299	* Returns the global key for the instance.
300	* E.g. E4_activity_actions-2-1-3 ( Three column primary key )
301	*
302	* @return string $this->gKey The E4_activity_actions plus a hyphenated primary key:
303	*/
304	public function globalKeyStr() {
305	if( !$this->globalKey ) {
306	$this->globalKey = "E4_activity_actions";
307	$this->globalKey .= "-" . $this->_actionId;//Index type: int(11) unsigned - PRI, Primary key or part of a multi-column primary key
308	$this->globalKey .= "-" . $this->_objectType;//Index type: varchar(24) - MUL, First, or only, column of a non-unique index
309	$this->globalKey .= "-" . $this->_subjectType;//Index type: varchar(24) - MUL, First, or only, column of a non-unique index
310	}
311	return $this->globalKey;
312	}//End globalKeyStr()
313
314
315
316	/**
317	* The primary key of the table row as an associative array of column names and row values.
318	* E.g. $primaryKey = array( 'actionId' => value )
319	*
320	* @var array
321	*/
322	protected $primaryKey = null;
323	/**
324	* Returns the primary key of the table row as an associative array of column names and row values.
325	* E.g. $this->primaryKey = array( 'actionId' => value, 'objectType' => value, 'subjectType' => value )
326	*
327	* @return array $primaryKey The E4_activity_actions primary key:
328	*/
329	public function primaryKeyAry() {
330	if( !$this->primaryKey ) {
331	$this->primaryKey['actionId'] = $this->_actionId;//Index type: int(11) unsigned - PRI, Primary key or part of a multi-column primary key
332	$this->primaryKey['objectType'] = $this->_objectType;//Index type: varchar(24) - MUL, First, or only, column of a non-unique index
333	$this->primaryKey['subjectType'] = $this->_subjectType;//Index type: varchar(24) - MUL, First, or only, column of a non-unique index
334	}
335	return $this->primaryKey;
336	}//End primaryKeyAry()
337	/////// End VoDaoDb Properties & Methods ///////
338
339
340	///////////// Accessors /////////////
341
342
343	/////// Setters ///////
344
345	/**
346	* Sets the property for: `E4_activity_actions`.`action_id`
347	*
348	*
349	* @param $actionId int(11) unsigned
350	* @return BaseVoE4ActivityActions
351	*/
352	public function setActionId( $actionId ) {
353	$this->_actionId = $actionId;
354	return $this;
355	}//End setActionId
356
357
358	/**
359	* Sets the property for: `E4_activity_actions`.`attachment_count`
360	*
361	*
362	* @param $attachmentCount smallint(3) unsigned
363	* @return BaseVoE4ActivityActions
364	*/
365	public function setAttachmentCount( $attachmentCount ) {
366	$this->_attachmentCount = $attachmentCount;
367	return $this;
368	}//End setAttachmentCount
369
370
371	/**
372	* Sets the property for: `E4_activity_actions`.`body`
373	*
374	*
375	* @param $body text
376	* @return BaseVoE4ActivityActions
377	*/
378	public function setBody( $body ) {
379	$this->_body = $body;
380	return $this;
381	}//End setBody
382
383
384	/**
385	* Sets the property for: `E4_activity_actions`.`comment_count`
386	*
387	*
388	* @param $commentCount mediumint(5) unsigned
389	* @return BaseVoE4ActivityActions
390	*/
391	public function setCommentCount( $commentCount ) {
392	$this->_commentCount = $commentCount;
393	return $this;
394	}//End setCommentCount
395
396
397	/**
398	* Sets the property for: `E4_activity_actions`.`date`
399	*
400	*
401	* @param $date datetime
402	* @return BaseVoE4ActivityActions
403	*/
404	public function setDate( $date ) {
405	$this->_date = $date;
406	return $this;
407	}//End setDate
408
409
410	/**
411	* Sets the property for: `E4_activity_actions`.`like_count`
412	*
413	*
414	* @param $likeCount mediumint(5) unsigned
415	* @return BaseVoE4ActivityActions
416	*/
417	public function setLikeCount( $likeCount ) {
418	$this->_likeCount = $likeCount;
419	return $this;
420	}//End setLikeCount
421
422
423	/**
424	* Sets the property for: `E4_activity_actions`.`object_id`
425	*
426	*
427	* @param $objectId int(11) unsigned
428	* @return BaseVoE4ActivityActions
429	*/
430	public function setObjectId( $objectId ) {
431	$this->_objectId = $objectId;
432	return $this;
433	}//End setObjectId
434
435
436	/**
437	* Sets the property for: `E4_activity_actions`.`object_type`
438	*
439	*
440	* @param $objectType varchar(24)
441	* @return BaseVoE4ActivityActions
442	*/
443	public function setObjectType( $objectType ) {
444	$this->_objectType = $objectType;
445	return $this;
446	}//End setObjectType
447
448
449	/**
450	* Sets the property for: `E4_activity_actions`.`params`
451	*
452	*
453	* @param $params text
454	* @return BaseVoE4ActivityActions
455	*/
456	public function setParams( $params ) {
457	$this->_params = $params;
458	return $this;
459	}//End setParams
460
461
462	/**
463	* Sets the property for: `E4_activity_actions`.`subject_id`
464	*
465	*
466	* @param $subjectId int(11) unsigned
467	* @return BaseVoE4ActivityActions
468	*/
469	public function setSubjectId( $subjectId ) {
470	$this->_subjectId = $subjectId;
471	return $this;
472	}//End setSubjectId
473
474
475	/**
476	* Sets the property for: `E4_activity_actions`.`subject_type`
477	*
478	*
479	* @param $subjectType varchar(24)
480	* @return BaseVoE4ActivityActions
481	*/
482	public function setSubjectType( $subjectType ) {
483	$this->_subjectType = $subjectType;
484	return $this;
485	}//End setSubjectType
486
487
488	/**
489	* Sets the property for: `E4_activity_actions`.`type`
490	*
491	*
492	* @param $type varchar(32)
493	* @return BaseVoE4ActivityActions
494	*/
495	public function setType( $type ) {
496	$this->_type = $type;
497	return $this;
498	}//End setType
499
500
501	/////// End Setters ///////
502
503
504	/////// Getters ///////
505
506
507
508	/**
509	* Returns property: `E4_activity_actions`.`action_id`
510	*
511	* @return $actionId int(11) unsigned
512	*/
513	public function getActionId() {
514	return $this->_actionId;
515	}//End getActionId
516
517
518	/**
519	* Returns property: `E4_activity_actions`.`attachment_count`
520	*
521	* @return $attachmentCount smallint(3) unsigned
522	*/
523	public function getAttachmentCount() {
524	return $this->_attachmentCount;
525	}//End getAttachmentCount
526
527
528	/**
529	* Returns property: `E4_activity_actions`.`body`
530	*
531	* @return $body text
532	*/
533	public function getBody() {
534	return $this->_body;
535	}//End getBody
536
537
538	/**
539	* Returns property: `E4_activity_actions`.`comment_count`
540	*
541	* @return $commentCount mediumint(5) unsigned
542	*/
543	public function getCommentCount() {
544	return $this->_commentCount;
545	}//End getCommentCount
546
547
548	/**
549	* Returns property: `E4_activity_actions`.`date`
550	*
551	* @return $date datetime
552	*/
553	public function getDate() {
554	return $this->_date;
555	}//End getDate
556
557
558	/**
559	* Returns property: `E4_activity_actions`.`like_count`
560	*
561	* @return $likeCount mediumint(5) unsigned
562	*/
563	public function getLikeCount() {
564	return $this->_likeCount;
565	}//End getLikeCount
566
567
568	/**
569	* Returns property: `E4_activity_actions`.`object_id`
570	*
571	* @return $objectId int(11) unsigned
572	*/
573	public function getObjectId() {
574	return $this->_objectId;
575	}//End getObjectId
576
577
578	/**
579	* Returns property: `E4_activity_actions`.`object_type`
580	*
581	* @return $objectType varchar(24)
582	*/
583	public function getObjectType() {
584	return $this->_objectType;
585	}//End getObjectType
586
587
588	/**
589	* Returns property: `E4_activity_actions`.`params`
590	*
591	* @return $params text
592	*/
593	public function getParams() {
594	return $this->_params;
595	}//End getParams
596
597
598	/**
599	* Returns property: `E4_activity_actions`.`subject_id`
600	*
601	* @return $subjectId int(11) unsigned
602	*/
603	public function getSubjectId() {
604	return $this->_subjectId;
605	}//End getSubjectId
606
607
608	/**
609	* Returns property: `E4_activity_actions`.`subject_type`
610	*
611	* @return $subjectType varchar(24)
612	*/
613	public function getSubjectType() {
614	return $this->_subjectType;
615	}//End getSubjectType
616
617
618	/**
619	* Returns property: `E4_activity_actions`.`type`
620	*
621	* @return $type varchar(32)
622	*/
623	public function getType() {
624	return $this->_type;
625	}//End getType
626
627
628	/////// End Getters ///////
629
630
631	///////////// End Accessors /////////////
632	}//End BaseVoE4ActivityActions
633	?>

VoEngine4ActivityActions.class.php - Child “Activity Actions VO”

1	<?php
2	//namespace org/imaginus/pogopogoSe4/php/vodaodb/vos/
3
4	require_once 'base/BaseVoE4ActivityActions.class.php';
5
6
7	require_once dirname( __FILE__ ) . '/../maps/DaoE4ActivityActions.class.php';
8
9
10	/////// PUT CUSTOM CODE FOR `E4_activity_actions` VOs IN THIS CLASS.
11
12
13	/************************************************
14	* Generated by VoDaoDb Wed Jul 3 18:14:00 GMT-0400 2013
15	* @author Todd Mullen, <AnEmail@gmail.com>)
16	* @copyright Do whatever you want except sell my work as yours, or reverse engineer it so you can make changes and then sell that as yours.
17	* @license @see copyright
18	* @filesource VoDaoDb v0.9 - Imaginus.org
19	*
20	*****************
21	* Project: pogopogoSe4
22	* Parent: imaginus.org
23	* //No class comments
24	************************************************/
25	class VoE4ActivityActions
26	extends BaseVoE4ActivityActions {
27
28
29
30	public function __construct() {
31	parent::__construct();
32	}//End __construct
33
34
35
36
37	/**
38	* Returns an instance of the DaoE4ActivityActions class which know how to "map" the VO's properties to the `E4_activity_actions` table columns.
39	* Responsibility is left to the concrete child so that code completion/hinting will hint the correct concrete type.
40	*
41	* @abstract
42	* @access public
43	* @author Todd Mullen - ???, <AnEmail@gmail.com>
44	* @return DaoE4ActivityActions Returns the concrete map for the concrete VoE4ActivityActions
45	*/
46	public function map() {
47	if( !$this->_map ) {
48	$this->_map = new DaoE4ActivityActions();
49	}
50	return $this->_map;
51
52	}//End map()
53
54
55	// --- MAGIC METHODS --- //
56
57
58	/**
59	* Returns a string that describes the VoE4ActivityActions
60	* Called automatically when an instance is used in a string context.
61	* E.g. "( VoE4ActivityActions ) array( actionId: value1, attachmentCount: value2, body: value3, commentCount: value4, date: value5, likeCount: value6, objectId: value7, objectType: value8, params: value9, subjectId: value10, subjectType: value11, type: value12, "
62	*
63	* @access public
64	* @author Todd Mullen - ???, <AnEmail@gmail.com>
65	* @return string A human readible description of the VO instance.
66	*/
67	public function __toString() {
68	return "( " . __CLASS__ . " ) { Key: {$this->getKeyStr()}, action_id: $this->_actionId, attachment_count: $this->_attachmentCount, body: $this->_body, comment_count: $this->_commentCount, date: $this->_date, like_count: $this->_likeCount, object_id: $this->_objectId, object_type: $this->_objectType, params: $this->_params, subject_id: $this->_subjectId, subject_type: $this->_subjectType, type: $this->_type }";
69	}//End __toString()
70
71
72	/**
73	* If the VoE4ActivityActions is cloned, this method is automatically called on the clone.
74	* Resets $this->_actionId to -1.
75	*
76	* @access public
77	* @author Todd Mullen - ???, <AnEmail@gmail.com>
78	* @return void
79	*/
80	public function __clone() {
81	$this->_actionId = -1;
82	}//End __clone()
83
84	}//End VoE4ActivityActions
85	?>

1	/***********************
2	* Project : Resume Js MVC Example
3	* Document : model.js
4	* Created : June 7, 2013, 8:07:57 AM
5	* Author : Todd Mullen, <AnEmail@gmail.com>)
6	* Description :
7	* The Javascript Model for the example Js MVC implementation
8	* This would typically be named something more fitting for what it represents, like "HtmlDiv"
9	***********************/
10	var EgModel = ( function (){
11	var height = 100;
12	var width = 100;
13
14	return {
15	height: height
16	, width: width
17	}
18	} );
19
20

1	<!--
2	/***********************
3	* Project : Resume Js MVC Example
4	* File : egView.html
5	* Created : June 7, 2013, 10:00:39 AM
6	* @author : Todd Mullen <AnEmail@gmail.com>
7	* The HTML markup for the Js MVC Example 'View' component
8	* **********************/
9	-->
10	<div class="egMVC">
11	<label for="tiHeight">Height:
12	<input id="tiHeight" value="100" type="text" />
13	</label>
14	<label for="tiWidth">Width:
15	<input id="tiWidth" value="100" type="text" />
16	</label>
17	<div class="divBox"> </div>
18	<button id="btnSave">Save</button>
19	</div>

Contents

Todd J. Mullen

OBJECTIVE:

LANGUAGES & TECHNOLOGIES:

WORK EXPERIENCE:

Web & Hybrid Mobile Application Developer

Proficient In:

Previous Online Test Scores (Click to Open) SHL ProveIt

SHL: PHP 5.3

SHL: Web Development Concepts

SHL: Web Design Concepts

SHL: JavaScript 1.5 Fundamentals

SHL: Linux Programming (General)

TRC - Technology Research Corporation© TRC © Southwire © part of Southwire LLC 2015©

| 2/15 – 12/15 |

(NDA Sequestered)

| 10/14 – 12/14 |

SavvyCard | 5/14 – 7/14 | SavvyCard

KableLink | 2/14 – 2/14 (Two Week contract) | KableLink

Health Plan Services (HPS) | 7/13 – 9/13 | HealthPlan Services

Kryptologos | 5/12 – 1/14 | KryptoLogos.com

I cannot speak for it's present state.
Last I saw it was in disrepair.

Ashland University – International Student Services | 4/12 – 6/12 |

ISS

Inowe | 5/09 – 4/11 | Inowe.me

Click To Check | 7/08 – 4/09 | Click To Check

This project was abandoned by the client. The link
points to a recreation of the original & is not maintained.

Peaceheart Foundation | 8/07 – 11/08 |

The recreation of the original
is not currently available.

PERSONAL PROJECTS:

My Router |

a(x,y,z,t) App (“Accelerometer App”) |

VoDaoDb |

VoDaoDb

MynD Flex CA (Cellular Automata) | MynD Flex

Example of My Javascript MVC Approach

SOFTWARE / TOOLS:

EDUCATION:

Ashland University | Ashland, Ohio, August 2001 - May 2006

Houston Area Joint Apprenticeship Training Committee | Houston, Texas, September 1998 - July 2001

OTHER SKILLS:

MEMBERSHIPS / AFFILIATIONS:

HONORS & AWARDS

HIGHLIGHTS:

INTERESTS:

1	/***********************
2	* Project : Resume Js MVC Example
3	* Document : egController.js
4	* Created : June 7, 2013, 8:07:57 AM
5	* Author : Todd Mullen, <AnEmail@gmail.com>)
6	* Description :
7	* The Javascript controller for the example Js MVC widget implementation
8	***********************/
9	var EgMVC = (function(model){
10	var data = model;
11	//Define constraints
12	var MAX_HEIGHT = 260;
13	var MAX_WIDTH = 470;
14	//Create handles to work with DOM elements
15	var tiHeight = $("#tiHeight");
16	var tiWidth = $("#tiWidth");
17	var divBox = $(".egMVC .divBox");
18	var btnSave = $(".egMVC button");
19
20	var init = function(){
21	//Assign event handlers
22	tiHeight.keyup(handleChangeHeight);
23	tiWidth.keyup(handleChangeWidth);
24	btnSave.click(save);
25
26	tiHeight.trigger("keyup");
27	tiWidth.trigger("keyup");
28	}
29
30	//Declare event handlers
31	var handleChangeHeight = function(){
32	var newHeight = tiHeight.val().replace("px","");
33	if( newHeight < 0 \|\| newHeight > MAX_HEIGHT ){
34	alert("Height is out of range. (0 to " + MAX_HEIGHT + "px)");
35	tiHeight.val( data.height );
36	return;
37	}
38	data.height = newHeight;
39	divBox.delay(100).animate({
40	height: data.height
41	});
42	}
43
44	var handleChangeWidth = function(){
45	var newWidth = tiWidth.val().replace("px","");
46	if( newWidth < 0 \|\| newWidth > MAX_WIDTH ){
47	alert("Width is out of range. (0 to " + MAX_WIDTH + "px)");
48	tiWidth.val( data.width );
49	return;
50	}
51	data.width = newWidth
52	divBox.delay(100).animate({
53	width: data.width
54	});
55	}
56
57	var handleSave = function(result){
58	alert("Save results:\n" + result);
59	}
60
61	var save = function(){
62	$.post(
63	"http://resume.imaginus.org/code/js/"
64	,data
65	,handleSave
66	,"text"
67	)
68	}
69
70	//Trigger the initialization of the widget (this can be done multiple other ways)
71	init();
72
73	//Return a public interface
74	return{
75	data : data
76	,tiHeight : tiHeight
77	,tiWidth : tiWidth
78	,divBox : divBox
79	,save : save
80	}
81	});
82
83

1	/***********************
2	* Project : Resume Js MVC Example
3	* Document : egMVC.css
4	* Created : June 7, 2013, 8:09:55 AM
5	* Author : Todd Mullen <AnEmail@gmail.com>
6	* Description :
7	* Styles for the example Javascript MVC implementation.
8	***********************/
9
10	.egMVC{
11	width: 500px; height: 370px;
12	border: 2px outset lightsteelblue;
13	padding: 10px; margin: auto;
14	}
15	.egMVC label{
16	display: block;
17	}
18	.egMVC .divBox{
19	height: 100px; width: 100px;
20	background-color: lightyellow;
21	border: 1px outset lavender;
22	margin: 10px;
23	}
24

Contents

Todd J. Mullen

OBJECTIVE:

LANGUAGES & TECHNOLOGIES:

WORK EXPERIENCE:

Web & Hybrid Mobile Application Developer

Proficient In:

Previous Online Test Scores (Click to Open) SHL ProveIt

SHL: PHP 5.3

SHL: Web Development Concepts

SHL: Web Design Concepts

SHL: JavaScript 1.5 Fundamentals

SHL: Linux Programming (General)

TRC - Technology Research Corporation© TRC © Southwire © part of Southwire LLC 2015© | 2/15 – 12/15 |

(NDA Sequestered) | 10/14 – 12/14 |

SavvyCard | 5/14 – 7/14 | SavvyCard

KableLink | 2/14 – 2/14 (Two Week contract) | KableLink

Health Plan Services (HPS) | 7/13 – 9/13 | HealthPlan Services

Kryptologos | 5/12 – 1/14 | KryptoLogos.com I cannot speak for it's present state. Last I saw it was in disrepair.

Ashland University – International Student Services | 4/12 – 6/12 | ISS

Inowe | 5/09 – 4/11 | Inowe.me

Click To Check | 7/08 – 4/09 | Click To Check This project was abandoned by the client. The link points to a recreation of the original & is not maintained.

Peaceheart Foundation | 8/07 – 11/08 | The recreation of the originalis not currently available.

PERSONAL PROJECTS:

My Router |

a(x,y,z,t) App (“Accelerometer App”) |

VoDaoDb | VoDaoDb

MynD Flex CA (Cellular Automata) | MynD Flex

Imaginus.org

Example of My Javascript MVC Approach

SOFTWARE / TOOLS:

EDUCATION:

Ashland University | Ashland, Ohio, August 2001 - May 2006

Houston Area Joint Apprenticeship Training Committee | Houston, Texas, September 1998 - July 2001

OTHER SKILLS:

MEMBERSHIPS / AFFILIATIONS:

HONORS & AWARDS

HIGHLIGHTS:

INTERESTS:

TRC - Technology Research Corporation© TRC © Southwire © part of Southwire LLC 2015©

| 2/15 – 12/15 |

(NDA Sequestered)

| 10/14 – 12/14 |

Kryptologos | 5/12 – 1/14 | KryptoLogos.com

I cannot speak for it's present state.
Last I saw it was in disrepair.

Ashland University – International Student Services | 4/12 – 6/12 |

ISS

Click To Check | 7/08 – 4/09 | Click To Check

This project was abandoned by the client. The link
points to a recreation of the original & is not maintained.

Peaceheart Foundation | 8/07 – 11/08 |

The recreation of the original
is not currently available.

VoDaoDb |

VoDaoDb