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 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

[!]<!-- Webdna Style = -->[/!]
[SQLConnect = dbType=3DMySQL&host=3D192.168.1.1&database=3DSMSITest&uid=3Dsa&pwd=3Dpass&= conn_var=3Dconn1]<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]
[SQLResult result_ref=3Drs1]<xmp><span = class=3D"Apple-tab-span" style=3D"white-space:pre">= </span>[founditems]<span class=3D"Apple-tab-span" = style=3D"white-space:pre"></span>[!]<!-- user id outputted like = this -->[/!]<span class=3D"Apple-tab-span" = style=3D"white-space:pre"></span>[id]<span = class=3D"Apple-tab-span" style=3D"white-space:pre"></span>[!]<!-- = not quite sure what happens when you have conflicting names brought back = -->[/!]<span class=3D"Apple-tab-span" = style=3D"white-space:pre"></span>[id]<span = class=3D"Apple-tab-span" style=3D"white-space:pre">= </span>[/founditems][/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:

    
  1. [WebDNA] Need someone to port CakePHP auction site to WebDNA (Dan Strong 2010)
--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 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

[!]<!-- Webdna Style = -->[/!]
[SQLConnect = dbType=3DMySQL&host=3D192.168.1.1&database=3DSMSITest&uid=3Dsa&pwd=3Dpass&= conn_var=3Dconn1]<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]
[SQLResult result_ref=3Drs1]<xmp><span = class=3D"Apple-tab-span" style=3D"white-space:pre">= </span><a target="_parent" href="page.dna?numero=93">[founditems]</a><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 -->[/!]<span class=3D"Apple-tab-span" = style=3D"white-space:pre"></span>[id]<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 = -->[/!]<span class=3D"Apple-tab-span" = style=3D"white-space:pre"></span>[id]<span = class=3D"Apple-tab-span" style=3D"white-space:pre">= </span>[/founditems][/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-- Toby Cox

DOWNLOAD WEBDNA NOW!

Top Articles:

Talk List

The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...

Related Readings:

WebCat2b13MacPlugIn - [include] doesn't allow creator (1997) MacFinder -- a new WebDNA web site (1998) Location of Browser Info.txt file (1997) Searching multiple fields (1997) PCS Frames (1997) hiding return characters (2000) Searching a database... (2003) Cleaning up all the shopping carts (2000) using showpage and showcart commands (1996) Searching for all records (1998) Multiple prices (1997) Problems with ^ could be solved with [REPLACE CHARACTERS] (1997) Searching for all records (1998) Date Sorting (1997) Weird Math and SV (1997) Still having problems with Authen (1997) slow site (2003) Hidden or Forbidden? (1998) ShowIf helper? (1998) WebCat2final1 crashes (1997)