[John Siracusa] Re: [RDBO] Quick Rose-y way to get value of Now() from the database

[John Siracusa] Re: [RDBO] Quick Rose-y way to get value of Now() from the database

[Ted Zlatanov]

[-- Attachment #1: Type: text/plain, Size: 2877 bytes --]

I'm not sure if this is a Gnus or TC or Emacs bug, since I don't know
much about message-mode.  I use Trivial Cite, and
on followup to the attached message I get the following error.  Does
anyone know?

Thanks
Ted

Debugger entered--Lisp error: (error "Invalid search bound (wrong side of point)")
  re-search-forward("\\([.?!][]\"'\xd0c9\x5397d)}]*\\($\\| $\\|	\\|  \\)\\|[\xd0a3\xd0a5\xd0a9\xd0aa\x90a3\x91ae\x91bf\x91a1\x250a4\x250a5\x250a9\x250aa\x190a4\x190a5\x190a9\x190aa]+\\)[ 	\n]*$" #<marker (moves after insertion) at 688 in *wide reply to John Siracusa*> t)
  fill-delete-newlines(691 #<marker (moves after insertion) at 688 in *wide reply to John Siracusa*> left nil nil)
  fill-region-as-paragraph(688 591 nil nil)
  fill-region(543 591)
  (let ((start-marker ...) (fill-prefix)) (insert (funcall tc-make-attribution)) (fill-region (marker-position start-marker) (point)) (setq start (point)))
  (if tc-make-attribution (let (... ...) (insert ...) (fill-region ... ...) (setq start ...)))
  (let ((start ...)) (setq tc-strings-list nil) (undo-boundary) (tc-fix-final-newline) (tc-parse-headers) (if tc-make-attribution (let ... ... ... ...)) (tc-remove-trailing-whitespace) (if tc-remove-signature (tc-do-remove-sig)) (tc-remove-trailing-whitespace) (if tc-max-lines (save-excursion ... ... ... ... ...)) (if tc-cite-marks (setq tc-cite-marks ...) (if tc-guess-cite-marks ... ...)) (setq tc-cite-marks (escape-char-range tc-cite-marks)) (tc-indent-citation) (if tc-normalize-cite-marks (tc-cleanup-cite-marks start ...)) (if tc-fill-column (tc-fill-cited-text start ...)) (setq tc-cite-marks nil) (tc-fix-signature-undo))
  (save-excursion (if (< ... ...) (exchange-point-and-mark)) (let (...) (setq tc-strings-list nil) (undo-boundary) (tc-fix-final-newline) (tc-parse-headers) (if tc-make-attribution ...) (tc-remove-trailing-whitespace) (if tc-remove-signature ...) (tc-remove-trailing-whitespace) (if tc-max-lines ...) (if tc-cite-marks ... ...) (setq tc-cite-marks ...) (tc-indent-citation) (if tc-normalize-cite-marks ...) (if tc-fill-column ...) (setq tc-cite-marks nil) (tc-fix-signature-undo)))
  trivial-cite()
  ad-Orig-message-yank-original(nil)
  message-yank-original()
  gnus-inews-yank-articles((11924))
  gnus-post-news(nil "nnimap+blockstar.com:INBOX.poop" [11924 "Re: [RDBO] Quick Rose-y way to get value of Now() from the database" "John Siracusa <siracusa@mindspring.com>" "Fri, 29 Dec 2006 21:06:39 -0500" "<C1BB33DF.6CC52%siracusa@mindspring.com>" "<39C0CB79-8AB0-4DE1-B5B3-CBC1CAAE4733@2xlp.com>" 4643 36 "dhcp-65-162.kendall.corp.akamai.com INBOX.poop:11924" ((X-CRM114-Status . "Good  ( pR: 44.4147 )") (To . "Rose-DB-Object <rose-db-object@lists.sourceforge.net>"))] "*Article*" (11924) nil nil)
  gnus-summary-followup((11924) nil)
  gnus-summary-followup-with-original(nil)
  call-interactively(gnus-summary-followup-with-original)



[-- Attachment #2: Type: message/rfc822, Size: 2873 bytes --]

From: John Siracusa <siracusa@mindspring.com>
To: Rose-DB-Object <rose-db-object@lists.sourceforge.net>
Subject: Re: [RDBO] Quick Rose-y way to get value of Now() from the database
Date: Fri, 29 Dec 2006 21:06:39 -0500
Message-ID: <C1BB33DF.6CC52%siracusa@mindspring.com>

On 12/29/06 8:57 PM, Jonathan Vanasco wrote:
> On Dec 29, 2006, at 7:53 PM, John Siracusa wrote:
>> If you jut want the value of now() in isolation, plain DBI is the  way to go.
>> (Wrap the code in a function or class method somewhere to hide the  gory DBI
>> details.)
>> 
> the problem I see is that you can run into issues where NOW() is  transaction
> specific -- like in Postgres

That's not a problem, so long as you do what you have to do anyway: share a
single db connection among all pieces of code within a particular
transaction.  The function or class method to get the current value of now()
should take a db or $dbh argument to allow this.

> you could also try creating a new rose::db::object class of sql
> helper items with 'result' as the only column-- then give it a
> manager class and have functions select your 'result' into the
> 'result' field.

It's pretty easy to make a degenerate RDBO class and Manager to do this kind
of thing, but it seems pretty "unclean" to me, and not worthwhile.

-John



-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys - and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Rose-db-object mailing list
Rose-db-object@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/rose-db-object