On 14 Jun 2013, at 13:52, Wolfgang Kinkeldei wolfg...@kinkeldei.de wrote:
Hi,
Am 14.06.2013 um 13:31 schrieb Dave Howorth:
My brain is feeling fried and is failing to solve a simple puzzle.
Using the standard table 'artist' which has a primary key 'artistid'.
And the other table
On 22 Jan 2011, at 18:05, Peter Gordon wrote:
I would like to be able to see the equivalent sql/bind values that are
being sent to the database, just to ensure that everything is working
properly and for debugging purposes.
I can add my own log statements to _dbh_execute in
If you want the function to be called once and don't want to use -dbh-do the
other option is to create a resultset for this. See:
http://search.cpan.org/~frew/DBIx-Class-0.08123/lib/DBIx/Class/Manual/Cookbook.pod#Arbitrary_SQL_through_a_custom_ResultSource
Just doing __PACKAGE__-table(materials.user); works for us here.
I'm not quite sure how the materials is getting stripped off. Although to be
fair we are only on v0.08112
-ash
On 7 Jul 2010, at 11:22, Peter Shangov wrote:
Hi,
I have the following schema class to access the 'user' table
On 18 Mar 2010, at 11:29, Андрей Костенко wrote:
What about moosifyng DBIx::Class? Class::Accessor::Grouped is the
slowest part of DBIx::Class. And with moose DBIx::Class will be more
usable/extensible?
Where's your figures showing that this is the case? Most of the time the
slowest part is
Stuart Dodds stu...@doddsweb.co.uk wrote:
Is it possible to do a search on a field where it is not equal to a list
of values.
For example, the sql I would like to produce is as follows:
WHERE id NOT IN (?,?,?)
however doing:
-search({
id = { '!=', \...@id_list }
});
doesn't do the right
On 8 May 2009, at 10:09, Oleg Pronin wrote:
Hello.
DBIx::Class::ResultSourceHandle has storable hooks to correctly
store row object and restore it.
However after restore, trying to update such an object will fail:
Can't call method update on an undefined value at /usr/local/lib/
On Tue, 5 May 2009 04:58:06 -0700 (PDT), Morgon Hed morgon...@yahoo.com
wrote:
You're going to need 08100+ for that method.
Thanks.
Any idea about when this will be become available on CPAN ?
It's was released on Apr 19, and there have been 2 maintenance releases
since.
-ash
On 1 Mar 2009, at 19:02, Peter Rabbitson wrote:
W Snyder wrote:
One of my DBIx::Class table classes has:
__PACKAGE__-table(adjacents);
__PACKAGE__-add_columns(
child_id = { ... },
parent_id = { ... },
);
__PACKAGE__-set_primary_key(child_id);
On 30 Jan 2009, at 08:56, Carl Franks wrote:
2009/1/29 Ash Berlin ash_c...@firemirror.com:
On 29 Jan 2009, at 22:03, Carl Franks wrote:
Is it okay to use $result_source-column_info('name')-
{_inflate_info}
to test whether a column is inflatable / deflatable?
It seems a bit too reliant
On 29 Jan 2009, at 22:03, Carl Franks wrote:
Is it okay to use $result_source-column_info('name')-{_inflate_info}
to test whether a column is inflatable / deflatable?
It seems a bit too reliant on internals, to me.
Or should there be a has_inflatable_column('name') method?
(and is that what
On 16 Jan 2009, at 11:44, Peter Rabbitson wrote:
on...@houseofdesign.de wrote:
Patches to lib/SQL/Translator/Producer/SQLite.pm welcome :P
Again, as file, previous mail had some additional line breaks
Patch seems reasonable. Please provide a diff including tests against
current
On 16 Jan 2009, at 16:35, Oleg Pronin wrote:
The patch does not change the functionality of 'remove_columns',
just bugfix, so i suppose no additional tests are required, are they?
[snip]
The reason for a test is to make sure that the bug doesn't get re-
introduced.
On 19 Dec 2008, at 19:34, Fernan Aguero wrote:
Hi,
I'd like to fetch data from DBIC in the form of a hash (i.e. indexed
by a key, say a PK) instead of in the form of an array, which is the
native structure of a DBIC RS.
In plain DBI, I can do it using selectall_hashref, and specifying the
On 15 Dec 2008, at 12:13, Adam Witney wrote:
Hi,
I am new to DBIx::Class, but have so far been impressed with how
easy it is to use, so thanks to those that have developed and
continue to develop it.
I wanted to know, is there a way of adding a method to a class that
performs a
On 16 Dec 2008, at 00:31, Toby Corkindale wrote:
Adam Witney wrote:
I am new to DBIx::Class, but have so far been impressed with how
easy it is to use, so thanks to those that have developed and
continue to develop it.
I wanted to know, is there a way of adding a method to a class
On 10 Dec 2008, at 00:03, Paul Makepeace wrote:
For reasons I'm not clear on our MySQL / DBIC / Catalyst set-up has
lately started dropping utf8-ness. I had a dig around and there seem
to be a few solutions.
Matt's talk http://www.shadowcat.co.uk/catalyst/-talks/oscon/crucible.xul
suggests,
On 3 Nov 2008, at 12:28, Ash Berlin wrote:
Yeah, I think the best plan of attack is to move as much out of
DBIC::SQL::A as possible, and then bump the dep on DBIC to SQL::A
1.50. If you are going to make changes to DBIC, can you please so on
a branch (assuming you have commit access
On 3 Nov 2008, at 11:46, BUCHMULLER Norbert wrote:
On Fri, 31 Oct 2008 23:48:56 +0100 Peter Rabbitson
[EMAIL PROTECTED] wrote:
There is a mostly-working-1.x-rc at
http://dev.catalyst.perl.org/repos/bast/SQL-Abstract/1.x/branches/1.50_RC
.
Patches should be made against it afaik, although
On 15 Oct 2008, at 14:25, Brandi wrote:
2)
I have some computation that might cause the connection to MySQL to
timeout. How can I reestablish a connection in my script, or in other
words disconnect and reconnect again at a later time in my script?
Default timeout is 30s, and having a web
On 11 Oct 2008, at 22:43, Lee Goddard wrote:
I do not often find myself using DBIx::Class, so please forgive any
naivety or silliness in my question, but I would appreciate your help.
my $o = $schema-resultset( $field )-find_or_create(
value = $val
);
The above code has been working
On 25 Sep 2008, at 17:19, Marc Mims wrote:
* Marc Mims [EMAIL PROTECTED] [080925 08:48]:
All tests pass with the patch applied.
I did, indeed, mirsead the code. Here's a version that returns the
correct $full_name and join condition.
Interesting. that would mean that the tests don't
On 14 Jul 2008, at 15:59, Jason Gottshall wrote:
Robert Loomans wrote:
Henry Drinkwater wrote:
Hi,
I am trying to create a might_have join condition in DBIx::Class
where I want to add a value comparison as well as having matching
values in the foreign and self columns. To give an
On 9 Jul 2008, at 09:41, luke saunders wrote:
On Wed, Jul 9, 2008 at 1:22 AM, Ash Berlin [EMAIL PROTECTED]
wrote:
On 9 Jul 2008, at 01:13, luke saunders wrote:
Yeah, I've just added a change to Versioned.pm which should strip
those BEGIN/COMMIT statements out. Ideally we'd have SQLT
On 8 Jul 2008, at 04:49, Christopher Laco wrote:
Christopher Laco wrote:
I thought this would be easy. Apparently I'm stupid.
I have a schema, which has a $VERSION. I've loaded the Versioned
component and created two scripts. The first script simply calls
$schema-create_ddl_dir with the
On 8 Jul 2008, at 15:57, Christopher H. Laco wrote:
Just now that I've changed my perspective, I see many pointy corners.
Pointy corners are the future man. Web 3.0.
-ash -- reaching tangential escape velocity since 16:17.
___
List:
On 7 Jul 2008, at 09:13, Tobias Kremer wrote:
On server startup I'd like to fetch the complete data of one table
and store it
somewhere to allow faster retrieval of it later on. For this, I have
added an
attribute to my DBIC schema class which is set during server startup
with the
result
On 3 Jul 2008, at 12:57, Oleg Pronin wrote:
DBIx::Class::Cursor::Cached is too slow for production use. It
caches only data from DB making it impossible so store virtual data
in objects and after fetching data from cache it has to construct a
row object which is a expensive action for CPU,
On 19 Jun 2008, at 22:32, Jeremy Koch wrote:
I am having trouble getting the results of a fairly complex query
returned in
a D::C::ResultSet object. Following the example found in the
D::C::Manual:Cookbook
Arbitrary SQL through a custom ResultSource doesn't work out for
my query.
On 11 Jun 2008, at 13:26, Jess Robinson wrote:
On Mon, 12 May 2008, Jacek Grzebyta wrote:
Hi guys,
I am a new in the DBIx subject so sorry for my query. It might be
'stupid'
for someone.
I found in the documentaton about resultset-set_cache get_cache
but i can
not find how to use it.
On 6 Jun 2008, at 15:36, Juan Camacho wrote:
I would really like to use the new schema version functionality, but
ran into a problem when the schema is generated for MySQL. The
generated SQL contain CONSTRAINT clauses that cause an error. Is
there a way to completely disable them?
On 29 May 2008, at 07:59, Ali M. wrote:
Sorry for the delay :|
PS C:\strawberry\cpan\build cd DBIx-Class-0.08010-pRyFQc
PS C:\strawberry\cpan\build\DBIx-Class-0.08010-pRyFQc prove -lv
t/81transactions.t
t/81transactions..
1..67
ok 1 - can't call txn_do without storage
ok 2 - $coderef
On 29 May 2008, at 11:47, Jens Thoms Toerring wrote:
On Thu, May 29, 2008 at 11:25:33AM +0100, Matt S Trout wrote:
On Fri, May 16, 2008 at 03:03:47PM -0300, Jose Fonseca wrote:
I propose then this gets documented on some future revision, because
discard_changes does not sound like something
On 16 May 2008, at 14:56, Matt S Trout wrote:
On Thu, May 15, 2008 at 10:53:20AM -0700, Ryan D Johnson wrote:
The specific problem with the old naming code was that it was
unstable. I might have a constraint foo today which tomorrow the sqlt
layer decided to name foo_2 (because there's a new
On 16 May 2008, at 18:24, Jose Fonseca wrote:
To reiterate, if scalar-ref update() behaved like that, we'd be
protecting users from doing things like this:
$cd-update({ last_played = \'NOW()' });
print $cd-last_played;
The word protect is, in my opinion, not the right one here. It's
On 15 May 2008, at 13:28, luke saunders wrote:
The change shown here:
http://dev.catalyst.perl.org/svnweb/bast/diff/DBIx-Class/0.08/trunk/lib/SQL/Translator/Parser/DBIx/Class.pm?rev1=4247;rev2=4248
Is causing many constraint add/drops in our schema diff such as:
ALTER TABLE table_name DROP
On 15 May 2008, at 14:08, luke saunders wrote:
What were these cases? Is that not just a bug with the unique symbol
generator in the producer?
I'm not sure of the exact cause any more, but I think it was to do
with multi-col unique constraints and FKs - i.e. if you have a unique
across
On 15 May 2008, at 21:04, Marc Mims wrote:
* Jose Fonseca [EMAIL PROTECTED] [080515 12:30]:
I raised the issue here as a sort of RFC on whether DBIC should
reload-on-write from the RDBMS automatically when updated with a
scalar
ref(literal SQL command). It seems reasonable that it should,
On 8 May 2008, at 10:42, Paul Makepeace wrote:
On Thu, May 1, 2008 at 11:31 AM, Paul Makepeace [EMAIL PROTECTED]
wrote:
I'm seeing something exceedingly odd: copying data causing a
premature
return from the controller, like a detach(),
foreach my $table (@chart_related_tables) {
On 14 Mar 2008, at 19:36, Mark Trostler wrote:
the quote() function is quite lame in my experience - for raw SQL I
use:
# get rid of any backshlased single quotes
$value =~ s/\\'/'/g;
# Fixup regular single quotes
$value =~ s/'/', char(39), '/g;
# Get rid of question marks
On 11 Mar 2008, at 16:39, Matt Lawrence wrote:
I found some time last night to work on this. I put the tests in a
new file t/as_sql.t, they are pretty basic: just calling each new
method once and checking the output is as expected
There are now 2 cursor methods that are proxied from the
On 26 Feb 2008, at 11:34, Alex Povolotsky wrote:
Ash Berlin wrote:
On 26 Feb 2008, at 11:23, Alex Povolotsky wrote:
Hello!
I'm using (with Catalyst and TT) some simple code to count related
data
[% FOREACH loc IN llist -%]
li[% loc.name %] : (a href=[% Catalyst.uri_for(edit/
$loc.lid
.
What I know is that I really need that object in Apache's session
memory and not let it be recreated each time from disk(or dbh).
Why might I ask? Not doubting you - it just helps to have someone else
check your logic.
Regards,
Ze
On Feb 15, 2008 6:20 PM, Ash Berlin [EMAIL PROTECTED
the same problem that Bernhard Graf had in Sept. 2007
and caught up with this discussion:
Ash Berlin Wrote:
I wrote the ResultSourceHandle stuff, and I never could come up
with a good way of specifying what schema to use in thawing the data.
Quick question: why is the schema column
On 13 Feb 2008, at 10:39, Matt S Trout wrote:
On Tue, Feb 12, 2008 at 03:36:58PM +0900, Matt Rosin wrote:
I am not a PG expert unfortunately. But as a user would like to note
8.3 has many new cool things, including a new XML data type (old xml2
method will be deprecated). Much developer candy
On 5 Feb 2008, at 17:20, luke saunders wrote:
I have factored out some custom fixture code into what is hopefully a
module useful to others - DBIx::Class::Fixtures. If you have any
interest in using fixtures for your test suites or dev databases
please give this module a quick review so that
On Jan 16, 2008, at 9:02 AM, Zbigniew Lukasiak wrote:
Hi all
This is a continuation of the patch for ResultSet::find_or_new
thread - but it's also a subject on it's own.
It is my understanding that:
$schema-resultset(Artist)-find({name = 'Random Girl Band'}, {key
= 'primary'});
should
On Jan 10, 2008, at 3:08 AM, [EMAIL PROTECTED] wrote:
Actually, I think that the bottleneck in my case here is the time it
takes to perform database queries. I haven't tried
DBIx::Class::Cursor::Cached yet, but looking at the posts, it seems
more appropriate for me than
Not a comment on the bug, just on manner in which it was reported.
1) Nopastes expire eventually
2) You dont have any tests.
Please re-create your patch to include (failing) test cases, and then
attach it/append to the mail.
Ash
On 7 Dec 2007, at 23:15, James Kiser wrote:
I came across
Randy Moore wrote:
Hi all,
I've just started using inflate_column to inflate a date in a MySQL
table into a DateTime object. It works well, as long as the the date is
valid in the database. But, I've got a case where my date is
'-00-00 00:00:00' until the object gets verified.
Hartmaier Alexander wrote:
Zero time sql!
Sounds like a Whoracle feature for version 12!
Or the next big thing for Damian Conway after his this year's YAPC::EU talk...
-Alex
Zero time was last years (or further back.) This year was negative time.
Or does that make it last year's was
Mark Ethan Trostler wrote:
It'd be nice if there was a link from the Resultset page to all the
useful '*_related' functions in Relationship::Base (where they're sort
of hidden). I'm always looking on the Resultset page for them...
thanks!
Mark
And similarly from Row to things like
52 matches
Mail list logo