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:

docs for WebCatalog2 (1997) If Empty ? (1997) pc (1997) Almost a there but..bye bye NetCloak (1997) Webcatalog [blank] Problem (1999) WebCatalog [FoundItems] Problem - AGAIN - (1997) Summing fields (1997) Roundup function? (1997) Summing fields (1997) HTTP header line is too long? (1997) Comments in db? (1997) Timer Values on [redirect] (1998) 2.0 Info (1997) AGAIN: Who's Security? (2000) Multiple ShipTo Addresses (2003) A few questions. . . (1997) WebCat2 - Getting to the browser's username/password data (1997) New Featured Site (1999) Help! Missing [showif] or [hideif] (2000) The last version of webcat (1999)