Re: [WebDNA] Wishlist: ignore whitespace in database changes

This WebDNA talk-list message is from

2016


It keeps the original formatting.
numero = 112942
interpreted = N
texte = 529 Over the years I=E2=80=99ve been bending WebDNA to my will. I=E2=80=99ve = more or less successfully implemented the view and controller ideology = of an MVC framework in WebDNA, and am getting ever closer to doing the = work to get data models working in webDNA. It=E2=80=99s so frustrating = in 2016 to not be able to tag a field in a database as unique or numeric = and let the language deal with it for you when you interact with the = database. I recently wasted more time then I care to admit to making = [delete db=3Dsomedb&leIDdata=3D10000] work because i forgot to add = &IDtype=3Dnum to the code. > On Aug 31, 2016, at 9:10 AM, dbrooke@euca.us wrote: >=20 > Hey Brian, glad to see you are still hacking away at WebDNA. :-) >=20 > Of course, this has always been a hack that we WebDNA'ers have = employed to give our eyes some ability to see what is going on with the = code. >=20 > I personally haven't taken the time to do this, but perhaps a custom = function could take care of this. >=20 > Something like (untested): >=20 > Function----------------- > [function name=3Deuca_dbHelper] > [return][grep search=3D > %09&replace=3D%26][param_string][/grep][/return] > [/function] >=20 > Call function------------------------- > [append db=3D^data/dbstats.db&autonumber=3Did][euca_dbHelper > dbpath=3D[url][$path][/url] > dbname=3D[url][$name][/url] > firstseen=3D[$timestamp] > lastseen=3D[$timestamp] > opencount=3D1 > changecount=3D0 > ][/append] >=20 >=20 > Obviously, the values entered in the call are suspect to break this if = they contain tabs or returns.. but maybe URL'ing or something else would = solve that problem. > Let us know if you come up with something that works. >=20 > However, I agree with you that the format similar to: > [append db=3D^data/dbstats.db&autonumber=3Did] > dbpath=3D[url][$path][/url] > dbname=3D[url][$name][/url] > firstseen=3D[$timestamp] > lastseen=3D[$timestamp] > opencount=3D1 > changecount=3D0 > [/append] >=20 >=20 > Would be a nifty addition to WebDNA. >=20 > Donovan >=20 >=20 >=20 >=20 > On 2016-08-30 11:26, Brian Burton wrote: >> While most database record changes (append/replace) are pretty >> simple, some of them can get pretty complex, and the code gets ugly >> fast. >>=20 >> this is actual code I wrote this morning: >>=20 >> [append db=3D^data/dbstats.db&autonumber=3Did][!] >> = [/!]dbpath=3D[$path]&dbname=3D[$name]&firstseen=3D[$timestamp]&lastseen=3D= [$timestamp]&opencount=3D1&changecount=3D0[!] >> = [/!]&Fcv=3D[$fields]&Fpv=3D&Fdh=3D[$fields]&Fdhts=3D[$timestamp]&Fdl=3D[$f= ields]&Fdlts=3D[$timestamp]&Fmh=3D[$fields]&Fmhts=3D[$timestamp][!] >> = [/!]&Rcv=3D[$records]&Rpv=3D&Rdh=3D[$records]&Rdhts=3D[$timestamp]&Rdl=3D[= $records]&Rdlts=3D[$timestamp]&Rmh=3D[$records]&Rmhts=3D[$timestamp][!] >> = [/!]&Mcv=3D[$memory]&Fpv=3D&Mdh=3D[$memory]&Mdhts=3D[$timestamp]&Mdl=3D[$m= emory]&Mdlts=3D[$timestamp]&Mmh=3D[$memory]&Mmhts=3D[$timestamp]][!] >> = [/!]&Dcv=3D[$filesize]&Dpv=3D&Ddh=3D[$filesize]&Ddhts=3D[$timestamp]&Ddl=3D= [$filesize]&Ddlts=3D[$timestamp]&Dmh=3D[$filesize]&Dmhts=3D[$timestamp][!]= >> [/!][/append] >>=20 >> all the comment tags look horrible and are onerous to type and >> occasionally get messed up, which adds time to debug. >> What if we had an ignorewhitespace=3DT modifier for append and = replace >> functions? >>=20 >> [append db=3D^data/dbstats.db&autonumber=3Did&ignorewhitespace=3DT] >> dbpath=3D[$path] >> &dbname=3D[$name] >> &firstseen=3D[$timestamp] >> &lastseen=3D[$timestamp] >> &opencount=3D1 >> &changecount=3D0 >> =E2=80=A6 etc ... >> [/append] >>=20 >> Heck, even the ampersands seem superfluous at that point, but I = don=E2=80=99t >> want to upset the purists. :P >> If one desires to store away line feeds, they could just [url] the >> value being stored (which should done anyway) and problem solved. >>=20 >> Brian B. Burton >>=20 >>=20 >>=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 >> Bug Reporting: support@webdna.us >=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 > Bug Reporting: support@webdna.us --------------------------------------------------------- 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 Bug Reporting: support@webdna.us . Associated Messages, from the most recent to the oldest:

    
  1. Re: [WebDNA] Wishlist: ignore whitespace in database changes (Stuart Tremain 2016)
  2. Re: [WebDNA] Wishlist: ignore whitespace in database changes (Patrick McCormick 2016)
  3. Was: [WebDNA] Wishlist: ignore whitespace in database changes - Now: WebDNA Data Model (dbrooke@euca.us 2016)
  4. [BULK] Re: [WebDNA] Wishlist: ignore whitespace in database changes (Alex McCombie 2016)
  5. Was: [WebDNA] Wishlist: ignore whitespace in database changes - Now: WebDNA Data Model (dbrooke@euca.us 2016)
  6. Re: [WebDNA] Wishlist: ignore whitespace in database changes (christophe.billiottet@webdna.us 2016)
  7. Re: [WebDNA] Wishlist: ignore whitespace in database changes (Stuart Tremain 2016)
  8. Re: [WebDNA] Wishlist: ignore whitespace in database changes (Brian Burton 2016)
  9. Re: [WebDNA] Wishlist: ignore whitespace in database changes (Kenneth Grome 2016)
  10. Re: [WebDNA] Wishlist: ignore whitespace in database changes (christophe.billiottet@webdna.us 2016)
  11. Re: [WebDNA] Wishlist: ignore whitespace in database changes (Brian Burton 2016)
  12. Re: [WebDNA] Wishlist: ignore whitespace in database changes (dbrooke@euca.us 2016)
  13. [WebDNA] Wishlist: ignore whitespace in database changes (Brian Burton 2016)
529 Over the years I=E2=80=99ve been bending WebDNA to my will. I=E2=80=99ve = more or less successfully implemented the view and controller ideology = of an MVC framework in WebDNA, and am getting ever closer to doing the = work to get data models working in webDNA. It=E2=80=99s so frustrating = in 2016 to not be able to tag a field in a database as unique or numeric = and let the language deal with it for you when you interact with the = database. I recently wasted more time then I care to admit to making = [delete db=3Dsomedb&leIDdata=3D10000] work because i forgot to add = &IDtype=3Dnum to the code. > On Aug 31, 2016, at 9:10 AM, dbrooke@euca.us wrote: >=20 > Hey Brian, glad to see you are still hacking away at WebDNA. :-) >=20 > Of course, this has always been a hack that we WebDNA'ers have = employed to give our eyes some ability to see what is going on with the = code. >=20 > I personally haven't taken the time to do this, but perhaps a custom = function could take care of this. >=20 > Something like (untested): >=20 > Function----------------- > [function name=3Deuca_dbHelper] > [return][grep search=3D > %09&replace=3D%26][param_string][/grep][/return] > [/function] >=20 > Call function------------------------- > [append db=3D^data/dbstats.db&autonumber=3Did][euca_dbHelper > dbpath=3D[url][$path][/url] > dbname=3D[url][$name][/url] > firstseen=3D[$timestamp] > lastseen=3D[$timestamp] > opencount=3D1 > changecount=3D0 > ][/append] >=20 >=20 > Obviously, the values entered in the call are suspect to break this if = they contain tabs or returns.. but maybe URL'ing or something else would = solve that problem. > Let us know if you come up with something that works. >=20 > However, I agree with you that the format similar to: > [append db=3D^data/dbstats.db&autonumber=3Did] > dbpath=3D[url][$path][/url] > dbname=3D[url][$name][/url] > firstseen=3D[$timestamp] > lastseen=3D[$timestamp] > opencount=3D1 > changecount=3D0 > [/append] >=20 >=20 > Would be a nifty addition to WebDNA. >=20 > Donovan >=20 >=20 >=20 >=20 > On 2016-08-30 11:26, Brian Burton wrote: >> While most database record changes (append/replace) are pretty >> simple, some of them can get pretty complex, and the code gets ugly >> fast. >>=20 >> this is actual code I wrote this morning: >>=20 >> [append db=3D^data/dbstats.db&autonumber=3Did][!] >> = [/!]dbpath=3D[$path]&dbname=3D[$name]&firstseen=3D[$timestamp]&lastseen=3D= [$timestamp]&opencount=3D1&changecount=3D0[!] >> = [/!]&Fcv=3D[$fields]&Fpv=3D&Fdh=3D[$fields]&Fdhts=3D[$timestamp]&Fdl=3D[$f= ields]&Fdlts=3D[$timestamp]&Fmh=3D[$fields]&Fmhts=3D[$timestamp][!] >> = [/!]&Rcv=3D[$records]&Rpv=3D&Rdh=3D[$records]&Rdhts=3D[$timestamp]&Rdl=3D[= $records]&Rdlts=3D[$timestamp]&Rmh=3D[$records]&Rmhts=3D[$timestamp][!] >> = [/!]&Mcv=3D[$memory]&Fpv=3D&Mdh=3D[$memory]&Mdhts=3D[$timestamp]&Mdl=3D[$m= emory]&Mdlts=3D[$timestamp]&Mmh=3D[$memory]&Mmhts=3D[$timestamp]][!] >> = [/!]&Dcv=3D[$filesize]&Dpv=3D&Ddh=3D[$filesize]&Ddhts=3D[$timestamp]&Ddl=3D= [$filesize]&Ddlts=3D[$timestamp]&Dmh=3D[$filesize]&Dmhts=3D[$timestamp][!]= >> [/!][/append] >>=20 >> all the comment tags look horrible and are onerous to type and >> occasionally get messed up, which adds time to debug. >> What if we had an ignorewhitespace=3DT modifier for append and = replace >> functions? >>=20 >> [append db=3D^data/dbstats.db&autonumber=3Did&ignorewhitespace=3DT] >> dbpath=3D[$path] >> &dbname=3D[$name] >> &firstseen=3D[$timestamp] >> &lastseen=3D[$timestamp] >> &opencount=3D1 >> &changecount=3D0 >> =E2=80=A6 etc ... >> [/append] >>=20 >> Heck, even the ampersands seem superfluous at that point, but I = don=E2=80=99t >> want to upset the purists. :P >> If one desires to store away line feeds, they could just [url] the >> value being stored (which should done anyway) and problem solved. >>=20 >> Brian B. Burton >>=20 >>=20 >>=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 >> Bug Reporting: support@webdna.us >=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 > Bug Reporting: support@webdna.us --------------------------------------------------------- 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 Bug Reporting: support@webdna.us . Brian Burton

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:

Comments in db? (1997) Merging LineItems (2003) easiest way to check for a non-alphanumeric character? (2000) Easter (1998) Associative lookup style? (1997) includes and cart numbers (1997) Calculating Age from DB fields (2003) [WebDNA] drop off not round off (2011) [taxrate] question (1997) Two options to consider (2008) Search results templates (1996) File Upload (1997) Back to Authnet with storebuilder (2003) [tcpconnect] > SSH? (2002) Upgrading old WebCat Database Files (1997) [WebDNA] fastcgi 7+ & [cart]? (2010) Late on Friday.... brain fried (2002) refreshing IE with posted .tmpl (1997) Hiccup ***** (1998) Credit card processing - UK (1997)