Re: [WebDNA] Re: Need someone to port CakePHP auction site to WebDNA
This WebDNA talk-list message is from 2010
It keeps the original formatting.
numero = 104678
interpreted = N
texte = --Apple-Mail-40--888807939 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=us-ascii Dan I think this would be difficult. We're an agency that does both webdna and cakephp, and from my = experience with both, I would have to say that the project sounds nasty. = Possibly best to walk away from it. Let me explain: CakePHP is what they call a rapid development framework, which means a = lot of things are done by the framework itself. - Data validation - complex SQL build queries - session handling - admin control - view caching - etc etc This means, if they wanted the site to cache, you would have to build a = webdna caching script. Even simple things like bringing results back on = a page would have to change from this // CakePHP style controller $allAuctions =3D $this->Auction->find('all', array('limit'=3D>10, = 'conditions'=3D>'auctionEnds<=3DNOW()')); // CakePHP style view foreach($allAuction as $auctionIndex=3D>$auctionItem){ // user id outputted like this $auctionItem['User']['id']; // auction id outputted like this $auctionItem['Auction']['id'] } to this [!][/!] [SQLConnect = dbType=3DMySQL&host=3D192.168.1.1&database=3DSMSITest&uid=3Dsa&pwd=3Dpass&= conn_var=3Dconn1] [SQLExecute conn_ref=3Dconn1&result_var=3Drs1] select * from auctions AS Auction LEFT JOIN users AS User WHERE = Auction.user_id=3DUser.id AND auctionEnds<=3DNOW() limit 10; [/SQLExecute] [SQLResult result_ref=3Drs1] [founditems] [!][/!] [id] [!][/!] [id] [/founditems] [/SQLResult] And that was any easy example - sometimes cake joins 4 or 5 tables 'in = the background'. As for trying to do this in traditional webdna, I'm not = sure how you would port over all the relational tables into a webdna = style format. Anything's possible, I guess, just so long as you have the = time. I guess the question no-one has asked yet is 'why'. Why are you trying = to port something from cakephp over to webdna? Surely either build an = auction site from scratch or host it in cakephp out of the box?=20 Anyhow, I've just reread your question and it looks like the deadline = has passed anyway. I'll send it anyway, just in case. Good luck, and if = you have any questions, don't hesitate to ask. TC On 1 Feb 2010, at 16:36, Dan Strong wrote: > Any takers? I need to get an estimate out to this potential php to = WebDNA convert by today or tomorrow. >=20 > -Dan Strong > http://www.DanStrong.com >=20 >=20 > On 1/31/2010 10:30 AM, Dan Strong wrote: >> I currently have a request for this... anybody have a WebDNA auction = site written or willing to build one? Please contact off-list. Thanks. >>=20 > --------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > archives: http://mail.webdna.us/list/talk@webdna.us > old archives: http://dev.webdna.us/TalkListArchive/ > Bug Reporting: = http://forum.webdna.us/eucabb.html?page=3Dtopics&category=3D288 --Apple-Mail-40--888807939 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=us-ascii // user = id outputted like this = $auctionItem['User']['id'];
// = auction id outputted like this
= $auctionItem['Auction']['id']
}
= to this
[!]<!-- Webdna Style = -->[/!]
<![CDATA[[SQLConnect = dbType=3DMySQL&host=3D192.168.1.1&database=3DSMSITest&uid=3Dsa&pwd=3Dpass&= conn_var=3Dconn1]]]><![CDATA[<xmp>[SQLExecute = conn_ref=3Dconn1&result_var=3Drs1] select * from auctions AS Auction LEFT JOIN users AS User WHERE = Auction.user_id=3DUser.id AND auctionEnds<=3DNOW() limit 10; [/SQLExecute]]]>
<![CDATA[[SQLResult result_ref=3Drs1]]]><![CDATA[<xmp><span = class=3D"Apple-tab-span" style=3D"white-space:pre"> = </span>[founditems]]]><![CDATA[<span class=3D"Apple-tab-span" = style=3D"white-space:pre"> </span>[!]<!-- user id outputted like = this -->[/!]]]><![CDATA[<span class=3D"Apple-tab-span" = style=3D"white-space:pre"> </span>[id]]]><![CDATA[<span = class=3D"Apple-tab-span" style=3D"white-space:pre"> </span>[!]<!-- = not quite sure what happens when you have conflicting names brought back = -->[/!]]]><![CDATA[<span class=3D"Apple-tab-span" = style=3D"white-space:pre"> </span>[id]]]><![CDATA[<span = class=3D"Apple-tab-span" style=3D"white-space:pre"> = </span>[/founditems]]]><![CDATA[[/SQLResult]]]>
<= br>
And that was any easy example - sometimes cake joins 4 or = 5 tables 'in the background'. As for trying to do this in traditional = webdna, I'm not sure how you would port over all the relational tables = into a webdna style format. Anything's possible, I guess, just so long = as you have the time.
I guess the question = no-one has asked yet is 'why'. Why are you trying to port something from = cakephp over to webdna? Surely either build an auction site from scratch = or host it in cakephp out of the = box?
Anyhow, I've just reread your = question and it looks like the deadline has passed anyway. I'll send it = anyway, just in case. Good luck, and if you have any questions, = don't hesitate to = ask.
TC
<= br>
On 1 Feb 2010, at 16:36, Dan Strong = wrote:
Any takers? I need to get an estimate out to this = potential php to WebDNA convert by today or tomorrow.
-Dan = Strong
http://www.DanStrong.com= On 1/31/2010 10:30 AM, Dan Strong wrote:
I = currently have a request for this... anybody have a WebDNA auction site = written or willing to build one? Please contact off-list. = Thanks.
-------------------------------------------= --------------
This message is sent to you because you are subscribed = to
the mailing list <talk@webdna.us>.
To unsubscribe, E-mail = to: <talk-leave@webdna.us>
archives: = http://mail.webdna.us/list/talk@webdna.us
old archives: = http://dev.webdna.us/TalkListArchive/
Bug Reporting: = http://forum.webdna.us/eucabb.html?page=3Dtopics&category=3D288
= --Apple-Mail-40--888807939--
Associated Messages, from the most recent to the oldest:
--Apple-Mail-40--888807939 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=us-ascii Dan I think this would be difficult. We're an agency that does both webdna and cakephp, and from my = experience with both, I would have to say that the project sounds nasty. = Possibly best to walk away from it. Let me explain: CakePHP is what they call a rapid development framework, which means a = lot of things are done by the framework itself. - Data validation - complex SQL build queries - session handling - admin control - view caching - etc etc This means, if they wanted the site to cache, you would have to build a = webdna caching script. Even simple things like bringing results back on = a page would have to change from this // CakePHP style controller $allAuctions =3D $this->Auction->find('all', array('limit'=3D>10, = 'conditions'=3D>'auctionEnds<=3DNOW()')); // CakePHP style view foreach($allAuction as $auctionIndex=3D>$auctionItem){ // user id outputted like this $auctionItem['User']['id']; // auction id outputted like this $auctionItem['Auction']['id'] } to this
[!][/!] [SQLConnect = dbType=3DMySQL&host=3D192.168.1.1&database=3DSMSITest&uid=3Dsa&pwd=3Dpass&= conn_var=3Dconn1] [SQLExecute conn_ref=3Dconn1&result_var=3Drs1] select * from auctions AS Auction LEFT JOIN users AS User WHERE = Auction.user_id=3DUser.id AND auctionEnds<=3DNOW() limit 10; [/SQLExecute] [SQLResult result_ref=3Drs1]
[founditems] [!][/!] [id]
[!][/!] [id] [/founditems] [/SQLResult] And that was any easy example - sometimes cake joins 4 or 5 tables 'in = the background'. As for trying to do this in traditional webdna, I'm not = sure how you would port over all the relational tables into a webdna = style format. Anything's possible, I guess, just so long as you have the = time. I guess the question no-one has asked yet is 'why'. Why are you trying = to port something from cakephp over to webdna? Surely either build an = auction site from scratch or host it in cakephp out of the box?=20 Anyhow, I've just reread your question and it looks like the deadline = has passed anyway. I'll send it anyway, just in case. Good luck, and if = you have any questions, don't hesitate to ask. TC On 1 Feb 2010, at 16:36, Dan Strong wrote: > Any takers? I need to get an estimate out to this potential php to = WebDNA convert by today or tomorrow. >=20 > -Dan Strong > http://www.DanStrong.com >=20 >=20 > On 1/31/2010 10:30 AM, Dan Strong wrote: >> I currently have a request for this... anybody have a WebDNA auction = site written or willing to build one? Please contact off-list. Thanks. >>=20 > --------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list
. > To unsubscribe, E-mail to: > archives: http://mail.webdna.us/list/talk@webdna.us > old archives: http://dev.webdna.us/TalkListArchive/ > Bug Reporting: = http://forum.webdna.us/eucabb.html?page=3Dtopics&category=3D288 --Apple-Mail-40--888807939 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=us-ascii // user = id outputted like this = $auctionItem['User']['id'];
// = auction id outputted like this
= $auctionItem['Auction']['id']
}
= to this
[!]<!-- Webdna Style = -->[/!]
<![CDATA[[SQLConnect = dbType=3DMySQL&host=3D192.168.1.1&database=3DSMSITest&uid=3Dsa&pwd=3Dpass&= conn_var=3Dconn1]]]><![CDATA[<xmp>[SQLExecute = conn_ref=3Dconn1&result_var=3Drs1] select * from auctions AS Auction LEFT JOIN users AS User WHERE = Auction.user_id=3DUser.id AND auctionEnds<=3DNOW() limit 10; [/SQLExecute]]]>
<![CDATA[[SQLResult result_ref=3Drs1]]]><![CDATA[<xmp><span = class=3D"Apple-tab-span" style=3D"white-space:pre"> = </span><a target="_parent" href="page.dna?numero=93">[founditems]</a>]]><![CDATA[<span class=3D"Apple-tab-span" = style=3D"white-space:pre"> </span><a target="_parent" href="page.dna?numero=250">[!]</a><!-- user id outputted like = this -->[/!]]]><![CDATA[<span class=3D"Apple-tab-span" = style=3D"white-space:pre"> </span>[id]]]><![CDATA[<span = class=3D"Apple-tab-span" style=3D"white-space:pre"> </span><a target="_parent" href="page.dna?numero=250">[!]</a><!-- = not quite sure what happens when you have conflicting names brought back = -->[/!]]]><![CDATA[<span class=3D"Apple-tab-span" = style=3D"white-space:pre"> </span>[id]]]><![CDATA[<span = class=3D"Apple-tab-span" style=3D"white-space:pre"> = </span>[/founditems]]]><![CDATA[[/SQLResult]]]> <= br>
And that was any easy example - sometimes cake joins 4 or = 5 tables 'in the background'. As for trying to do this in traditional = webdna, I'm not sure how you would port over all the relational tables = into a webdna style format. Anything's possible, I guess, just so long = as you have the time.
I guess the question = no-one has asked yet is 'why'. Why are you trying to port something from = cakephp over to webdna? Surely either build an auction site from scratch = or host it in cakephp out of the = box?
Anyhow, I've just reread your = question and it looks like the deadline has passed anyway. I'll send it = anyway, just in case. Good luck, and if you have any questions, = don't hesitate to = ask.
TC
<= br>