> Morning all :),
>
> I would like to ask the experts for some advice on how I might tackle
> the problem below... so please let me have your thoughts.
>
> I have currently have a pretty typical dbix::class schema of tables and
> relationships.
>
> Within my schema I have a table of tickets .. basi
Yesterday a colleague new to DBIC ran into a problem with a column
named using a reserved word in MySQL. He worked around it by using a
different column name, but while discussing the issue he asked why
quote_char and name_sep are not set automatically. I don't know the
answer and Googling has left
While deploying a schema to a SQL Server 2005 database today I ran
into this database error:
Msg 1785, Level 16, State 0, Line 1236
Introducing FOREIGN KEY constraint 'tblItemCategory_fk_item_id' on
table 'tblItemCategory' may cause cycles or multiple cascade paths.
Specify ON DELETE NO ACTION or
2009/9/21 Karen Hoofnagle :
> Are you suggesting the code should look like this:
>
> $rs = $c->model('DB::User_Read_Log')->search(
> {
> datetime =>{"between", [\"to_date(?, 'MMDD HH24:MM:SS')"
> =>$start." 00:00:00", \"to_date(?, 'MMDD HH24:MM:SS')" => $end. "
> 00:00:00"]
2009/9/21 Karen Hoofnagle :
> I need to create the following query using DBIx:Class (assume I'm using the
> most recent release of DBIx::Class)
> select * from user_read_log where datetime between to_date(20090101,
> 'MMDD') and to_date(20091001, 'MMDD')
> I've read the section of SQL::Abst
2009/2/10 Peter Rabbitson :
> Bug is fixed, please download an updated tar from the same URL. Problem
> was the inability of win32 to delete currently opened files.
Works for me now, although a few tests still pass unexpectedly, not
sure if that's a problem:
D:\Setup\DBIX-C~1.080>nmake test
Micr
2009/2/9 Peter Rabbitson :
> Both of these `prove` invocations are wrong, as they run the test against
> the currently installed 0.08010 (I can tell by the presence of the
> startup check warning). You either need to supply -Ilib to prove,
> or use the -b option _after_ running `perl Makefile.PL;
2009/2/9 Peter Rabbitson :
> Greetings,
> Please download, test and report back at your convenience:
> http://rabbit.us/diff/DBIx-Class-0.08011.tar.gz
>
D:\Setup\DBIx-Class-0.08011>prove t
Failed TestStat Wstat Total Fail List of Failed
-
The 0.08010 docs in DBIx::Class::ResultSet contain an example for the
"having" attribute that shows parameter values being passed using a
hashref:
having => { 'count(employee)' => { '>=', 100 } }
Meanwhile, in the test suite there are a couple of tests using
"having" (76joins.t in 0.08010 and 77p
2008/8/3 Matt S Trout <[EMAIL PROTECTED]>:
> On Sun, Aug 03, 2008 at 01:13:39PM +0100, Will Hawes wrote:
>> The InflateColumn::DateTime helper currently throws "Invalid date
>> format: " for rows that contain NULL, even if the column info has
>> is_nul
The InflateColumn::DateTime helper currently throws "Invalid date
format: " for rows that contain NULL, even if the column info has
is_nullable => 1. The docs show that either default_value =>
'-00-00' or datetime_undef_if_invalid => 1 could be used to work
around this, but bypassing inflation
On 12/02/2008, Dan Horne <[EMAIL PROTECTED]> wrote:
> Dan Horne said:
> > Hi
> >
> > Is there a simple way of changing the result set Pager? I'd like to use
> > Data::Page::Navigation instead of Data::Page
> >
>
> No takers?
grep shows that Data::Page is only referenced by
DBIx::Class::ResultSet s
On 08/02/2008, Will Smith <[EMAIL PROTECTED]> wrote:
>
> How do I index the search that returns more than a thousand records with
> several parameters? My server runs pretty slow on a search like that.
> In the DBIx::Class::ResultSet, I found there is way to do indexing, but
> it's not very clear
On 27/01/2008, edwrb . <[EMAIL PROTECTED]> wrote:
>
> Hey gang,
>
> I have a UNION query with a right join that I need to implement in
> DBIx::Class.
AFAIK, DBIC can't do that (yet ;):
http://search.cpan.org/dist/DBIx-Class/lib/DBIx/Class/Manual/Cookbook.pod#Arbitrary_SQL_through_a_custom_Result
On 12/10/2007, Jon Schutz <[EMAIL PROTECTED]> wrote:
>
> In my code I have a DBIx::Class query with prefetch that is taking about
> 1.2 seconds to execute. If I remove the prefetch, it takes 0.2 seconds.
> The actual SQL query takes 0.00 seconds with or without the join. The
> number of records i
On 15/09/2007, Jason Kohles <[EMAIL PROTECTED]> wrote:
>
> On Sep 15, 2007, at 10:21 AM, Silent wrote:
>
> > Hi~
> > I am new to dbix-class also SQL, in my test script I want to
> > select from two tables:
> >
> > sqlite> .schema
> > CREATE TABLE author (
> > uid integer primary key,
> > uname
16 matches
Mail list logo