{"id":37,"date":"2010-02-27T19:46:37","date_gmt":"2010-02-27T18:46:37","guid":{"rendered":"http:\/\/4amics.com\/x.perez\/?p=37"},"modified":"2010-03-01T09:12:33","modified_gmt":"2010-03-01T08:12:33","slug":"lquerybu-light-query-business-units","status":"publish","type":"post","link":"https:\/\/www.4amics.com\/x.perez\/2010\/02\/lquerybu-light-query-business-units\/","title":{"rendered":"LQueryBU – Light Query Business Units"},"content":{"rendered":"

Many frameworks comes with its CRUD, Scaffolding, AdoDB, but it’s slow in programming it, and hard to mantain. I have developed my own DB class, it isn’t a wrapper, its an interface between Models (MVC concept),\u00a0 and DB wrappers.<\/p>\n

Performs SQL and PHP business units, all together, designed to avoid large DAOs, to increase preformance, better visibility and clarity, and improvement of development time.<\/p>\n

The unit files may also contain PHP or SQL actions to execute PRE-QUERY, POST-QUERY and POST-RECORD, and PHP or SQL actions for successfull or unsuccessfull queries.<\/p>\n

– Format pre-query variables, as conditions, limit, decoding, etc..
\n– Format post-query records, encoding, attaching subqueries, attaching functionalities, etc…
\n– Post query actions, successfull or unsuccessfull, SQL and PHP actions, suporting transactionality
\n– Autoformatting capabilities, titles, sizes, numbers, dates…<\/p>\n

You can download and try, it comes with manual and some examples.<\/p>\n

Example of getCities Unit:<\/p>\n

\"\"<\/a><\/p>\n

Example of easy results formatter:<\/p>\n

\"\"<\/a><\/p>\n

Download from : LQueryBU in GoogleCode<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

Many frameworks comes with its CRUD, Scaffolding, AdoDB, but it’s slow in programming it, and hard to mantain. I have developed my own DB class, it isn’t a wrapper, its an interface between Models (MVC concept),\u00a0 and DB wrappers. Performs SQL and PHP business units, all together, designed to avoid large DAOs, to increase preformance, […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3,12,11],"tags":[],"class_list":["post-37","post","type-post","status-publish","format-standard","hentry","category-developer","category-mysql","category-php"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.4amics.com\/x.perez\/wp-json\/wp\/v2\/posts\/37","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.4amics.com\/x.perez\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.4amics.com\/x.perez\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.4amics.com\/x.perez\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.4amics.com\/x.perez\/wp-json\/wp\/v2\/comments?post=37"}],"version-history":[{"count":8,"href":"https:\/\/www.4amics.com\/x.perez\/wp-json\/wp\/v2\/posts\/37\/revisions"}],"predecessor-version":[{"id":49,"href":"https:\/\/www.4amics.com\/x.perez\/wp-json\/wp\/v2\/posts\/37\/revisions\/49"}],"wp:attachment":[{"href":"https:\/\/www.4amics.com\/x.perez\/wp-json\/wp\/v2\/media?parent=37"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.4amics.com\/x.perez\/wp-json\/wp\/v2\/categories?post=37"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.4amics.com\/x.perez\/wp-json\/wp\/v2\/tags?post=37"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}