RE: Why isn't LIMIT functionality included in CDBI?

[prev] [thread] [next] [Date index for 2004/05/25]

This is a multi-part message in MIME format.

------=_NextPart_000_0011_01C441E6.FE3D24C0
Content-Type: text/plain;
	charset="US-ASCII"
Content-Transfer-Encoding: 7bit

I must have missed the discussion on adding LIMIT/OFFSET to AS or
SQL::Abstract... Or I might not have start down that path myself.

I've posted a beginning at perlmonks
http://www.perlmonks.org/index.pl?node_id=356028.  I've e-mailed
Tatsuhiko Miyagawa to see if he's amenable to a patch I'm working on to
allow for extensions/plugins to AbstractSearch - so it would be easier
to subclass rather then doing a bulk copy of his code.  My first pass at
this is using a callback, but I'm open to anything that works well.

I'm attaching what I have so far, including a
Class::DBI::Plugin::Aggregates discussed here:
http://www.perlmonks.org/index.pl?node_id=354690 and here:
http://www.perlmonks.org/index.pl?node_id=354794(no pod yet).
Comments/criticism are welcome either here on the list or on PM.   It's
not quite production ready, but it's functional. Once I have it somewhat
stable (not tweaking things anymore) I'll make a full CPAN distribution
out of them, and a real patch to AbstractSearch.

Thanks.

--Jim 

> -----Original Message-----
> From: Edward J. Sabol [mailto:sabol@xxxxxxxx.xxxx.xxxx.xxx] 
> Sent: Friday, May 21, 2004 7:29 PM
> To: karjala_lists@xxxxxxx.xxx
> Cc: cdbi-talk@xxxxxx.xxxxx.xxx
> Subject: Re: Why isn't LIMIT functionality included in CDBI?
> 
> 
> > Why isn't LIMIT functionality included in CDBI?
> 
> LIMIT is not part of the SQL standard. If it's supported 
> anywhere, it should
> be in a database-specific module since it's database-specific SQL.
> 
> > Perhaps it should be implemented somewhere in Class::DBI::mysql?
> 
> There's been some discussion of that and also some discussion 
> of extending
> CDBI::AbstractSearch and SQL::Abstract to support LIMIT. Feel 
> free to take a
> crack at it. I'm sure other MySQL users would appreciate it.
> 

------=_NextPart_000_0011_01C441E6.FE3D24C0
Content-Type: application/octet-stream;
	name="cdbi.tar.gz"
Content-Transfer-Encoding: base64
Content-Disposition: attachment;
	filename="cdbi.tar.gz"

H4sIAK7iskAAA+0Za1PjRnK/Rr+iw7Ere8sY28BSZxYHA95d7mDhMHu5q5BTjaWxraCH0YwwDvH9
9uue0csBDLkFkqp4vkia6ef0Y7pHex4TYvXVs45abb22ubGBz1qt3qjNPJPxql6rbTQam/V64x3O
1+sb6+uvNp5XLD1iIVmELMe8NxfuoXWt1CY+1zYbjfpTivicY0/Zf3/34Bl94LH2XycPWKf5eqO+
vrGw/wuM3P4nXjxwg+dwg8fafw0B62u0hfW1tc2F/V9i3LJ/ezCI+IBJLqoj/2l41NC47zCf32P/
tfq7xP71TbQ8+QnO1NZe1Z6G/fzxJ7f/iNkXbMBB+UGziY7QbGpPaDZzV9gyjFhwEDJybbml3q9Y
JOByXFr+Z+e0e3D8GXY6/zo5Pj0rbxnZ1DbUqrU6IvsT2HF4n8WetHwuh6EjcPFyvAp2GAcSfDcA
n10DuxogEwdWESfil7Ebcehcj8JI8mjLeOv69IqY52/S2WZTT24ZCX9cLYGpyFp26FnjIY+4WUHy
I7iBZau6pKeWYHpbpnKiaPcfh6h+D/VlpK/RDyNAHZbbHz8idU0qtkvLVvkuKlCGGwOgZDPP41H5
h9qPKy3BpSUuvZKHWEilnIux3YKlbuews3cGyze4NC29FmX4cHp8BJZ11t497FgWvBZLZWNqGCLu
6S3T2CiGxQYD/VESQ7cvK1p3s2K+NSs7JGABKduQeYg5EpplDjiuzgCz63nA7LoIjIaeA4yrRWD0
iDnAuJoCK+gcQlkBlOFGUShDdA2Fs5VN2+T1OB3xfgrzyy/JWw7VjwMbbiPz61EEd8xr3uiGiqqF
5i/Dd/oFstFEXXYsmOZoTMoI7kKrz6DFAbpbjhVGDo8IS+GXFdB34HCPS67nVlo3CsjqTablnICi
4PbRnRU/pQy/BLO71z5sn5rkw8nsNizrl6nC4Z5QaN+W9MYQkvYcYIFToPTWLCeRoEdGTe36Sqvv
Bg55ZOwHJbVWNqAw0BClQ1fIZvOLdL1ms+9GQqoQXmkx2+ZChIpPIltGVlMUt4il65YdheyitKTx
XAFBKIGBRoOwnwAulfUmT/VOZdRZUDIxkC2zqtSvmkmGKQOK44QFfdMEtsei0VY2S1/NZiqDdkAx
DGPPAcxkHvc55sM0WyzfEI9p4s6YKarVajmTLPcChMWNnclaK62Aj0uvtVukkKXl0TBigldgp4e7
XyZrIO5KS0eUdt1K4lXlQpyoLJ2bjjagkIa0+SoJ8TJlO4/b0rpiXkkzQn/DjcSj4Pc+7xZjduT1
X+o4Xc4ie/iUfcDj+7939UZD1X8bWEUt6v8XGPfa/2TwUvX/u/rmWtr/b9Tr2v6b2P8v6v/nH3fV
/7OegP3A4Gvq/8ZX1fLIQSgx9ElzT4FOUz08esC8Xw9zK6kPPdd3pRX2+3jKFktEdXhZVA3dKuno
DFMrd5R7um5T49aaYgUPlWcKqlibZcWdlvGh6k5B3V3b4acbcCeVZKYc01Pb4AaypD/KSMDDwkr1
NskMVXLtw0Mzr2CWi1tV3YYlODw4OjhLCC4Vq6ZZGRJ1ZoTIVFRS6K/yPF7HHz50O2cpYsotqf2L
rlIwbVrmv2ihfpOgpGaibrCH0TZVPj/jhVszJWb3y0nntNks6pJXZkk5p4spw7I6n/ctyzC2h5w5
dfjcPuoYxtxY/ggrkE4Wot4UFFMwduVwNrgy2t1/fz4+6R50ybJZ1thvNo9i4dqkAQXhg2kkx/WZ
GxAa3Q34RAP3JaNHJWRB/cQfWCSxIaA6+Acwj3/+eYJ9vfl37nkTE36sJECYz2UsCOgGzG+3CSSM
pcMkd0yYElRZyaH4uuIRbG8ex/gh1pq5Jph2ZKDa/4h7BAT7ne7eUk4uCdAWNGoVSAOlBbUUYkqK
JNYh1NODkzNMuw84wIB6HlawFIzUfQ9g8zvwYm7MmJ/iMiwCr2gf4deSB8INA0F46NrhGPphZOhU
QI1gEqhMALbTV66DGQD1PQmFHEQcG4hqJvtR5+zT8T461hfhBgOQQxTQD53Y48AcRyBdIk9L6Q2L
EmoSxthxMYm9G4lH9MIrbIbX8cWV3J/JBmTxrHsp2vh1dq6csQtOOzNkYkhKiRG33f4Evv/UOe0Q
D3TwKnQ5h8P3M3vUIs0VmhGOJO1J9V5255pf5fw1RbLI+SqumFFwMbD5b+NvpPwh5Q8zytxJFrfW
JWDmwWXMo4lBArm9mG5+58QxhTnafMgx2nOM5q3Nf2sYu+9TN28ZRjuK2KQgCTbafRf9nmgxiU7l
edDjRN0hKfW9BrJBFBF7UiCCoSyuhK0SdRUfLaOLmZVFGaaOGsIMYr+HRJBTxG0kKPAp4yjQnkgQ
2jRVox1MsKBB54cQp4kvC2AVj71VN5PMDgNUUGomuIw+qPwc91HNGYogNuIDHvCIYl4JqeM2k1Ip
6+Dx7eOZiFbHsPFZMMkkJANduCOgeMyVrwIcCOMuCXocbY/FD6fwSEWBu0TZpsPHUKpqJXPrYX7j
mJeFyLFnkwByxrfYlmFUMUhpG9kXrIXrMgo9pQ7Zx01o2hFX3AE+0GXNNaMbjoqBGHRYmO3P+yZq
ISSmATKTeXxqkmmSC9UKQTWz+xfB7gsmTKheOKATpJUQLabG9hdML6eG8Tfmo1ifuOdD570nWz/9
NMT3HdyGasDl+4FsVWGXkUZhgBo5uKuTJkanFPHQvQjhyJ2wARszje0nXzu92LsI+FgQkQ5R0QlS
hD4HZDCCfhT6hu303BXJvAs69zwylocnSgW4CkfMnxOl6Jnrw26M8YHvXddHQb53PTu8pqUQLbcb
jh0eYM6gHOm5vYhFE8rn/QjTggj7cozbvkWpUZko4o4rEiuDq/x1la6yQwczgIETVDDqMBO4O4BF
uC8oZZ/wyEMEwb1+nqe7nQ60D7vHhnH4/v4E0apAcVl9/ipdGdt2LBdXQX+EcV///2TN/6sH+/+N
Bq6l/X9jraH6f/r/u+j/n3883P9/Te+/8QK9/x+u8XvSPzR/SSohzPEOH2GVQOdpBTCho0VUZYIG
xKSPR3Loj5h0ex7PWm8t8Zs3ePLiMSBmuU3L1Ih/k8l3l0TTOT9BsJbCc/6KW3S+0d+Kwi+Qb2b/
fXwz76dHgMbAk4ioFPuMFjnQX2sv/LMjQYHt/4JY/c+5eKuKb3yurrpb+ZWG3s87WnuqjZR33Fqh
e5S94/2OCfmfqZvbcCut0nkm97kSPO360z3QRWxmjFt2+LXe6W3Bb70s+J0uChaXBI+4JPh/ev+v
6vsX3fqiW/+abv1P330u+sgH+shFo7gYi7EYi/GS43/z3KZGADQAAA==

------=_NextPart_000_0011_01C441E6.FE3D24C0--