On 10/1/07 1:17 PM, Kurt Hansen wrote:
Hmm...I'm not sure if the lack of response on this question is because
no-one is doing this, it isn't possible within RDBO, my e-mail was last,
or my question was incoherent.
While the incoherence of the message is a definite possibility -- :-),
even
On 9/26/07 6:28 PM, Jonathan Swartz wrote:
I'm curious to know what the motivation was for Rose::DB to handle
ref counting in the first place. Is/was this DBI disconnect-on-
destroy behavior not always reliable?
Rose::DB's involvement in $dbh destruction is so it can run the
pre_disconnect_sql
On 9/13/07, Wiggins d'Anconia [EMAIL PROTECTED] wrote:
$sort_by = join(', ', map { ref $_ ? $$_ : $_ } @$sort_by) if(ref
$sort_by);
In the above any argument that is a reference attempts to dereference a
scalar, which is problematic for obviously anything that is not a
scalar, which in
On 9/7/07, Peter Karman [EMAIL PROTECTED] wrote:
On 09/07/2007 01:03 PM, Graham Barr wrote:
IMO, default value should only be used during create when a value is
not specified by the user. At all other times the method should
return whatever value the object holds.
agreed.
IIRC, I was
On 9/7/07, Graham Barr [EMAIL PROTECTED] wrote:
On Sep 7, 2007, at 1:49 PM, John Siracusa wrote:
I'll provide a global way to turn it on, however. Probably:
Rose::DB::Object::Metadata::Column-default_undef_sets_null(1);
which you can put in your common base class or wherever.
OK
On 9/6/07 10:01 PM, Ask Bjørn Hansen wrote:
We have some columns that are NULL but with a specified default value
(for example 0).
deleted = { type = 'integer', default = '0' },
Sometimes we need to set it to undef/NULL (a valid value), but RDBO
unhelpfully resets that to the
On 9/5/07, Clayton Scott [EMAIL PROTECTED] wrote:
I can get the columns from both tables but not the table name.
Previously when generating forms from table definitions I've gotten
around this by actually loading the FK class. I can't in this case
because the class hasn't been generated yet.
On 9/3/07 12:31 PM, Kurt Hansen wrote:
However, I did not try the connect_options method based on your
inlined into the DSN comment and reading up on the Rose::DB and DBI
docs. The SSL options DO need to be inlined into the DSN
Okay, I'll make the change in SVN when I get a chance.
so I took
On 8/29/07, Michael Lackhoff [EMAIL PROTECTED] wrote:
Did you find some time for DBI::Proxy support, yet?
No, sorry, haven't gotten to it yet.
-John
-
This SF.net email is sponsored by: Splunk Inc.
Still grepping through
On 8/17/07 6:25 PM, Derek Watson wrote:
This is off-topic, but what lies ahead on the road between RDBO 0.7xx and
1.0? Are there specific features you have in mind that will push us further
along, or is it just general maturity (eg. bug fixes and interface updates)?
There are some specific
On 8/15/07 3:11 AM, Michael Lackhoff wrote:
On 14.08.2007 22:43 John Siracusa wrote:
Assuming your have AutoCommit turned off, that's why $obj was not
saved. The rollback rolled back everything done since the last
begin_work().
Well, I didn't switch AutoCommit on or off
Was it on or off
On 8/15/07, Graham Barr [EMAIL PROTECTED] wrote:
On Wed, August 15, 2007 7:54 am, John Siracusa wrote:
The real question is, why is some_helper_that_uses_db() causing a rollback?
Turn on DBI-trace(1) to be sure it actually is, and maybe try to create a
small test case.
the problem
On 8/14/07, George Hartzell [EMAIL PROTECTED] wrote:
The default value of now does work when used in the RDBO perl
module. The problem is that since I'm using RDBO::Loader, the only
way to get that value in there is to use it in the SQL, where it
doesn't do what is intended.
Remember that
On 8/14/07, Michael Lackhoff [EMAIL PROTECTED] wrote:
And to the second alternative, how do I have to setup RDBO with mod_perl
to share a db (and dbh with it) for everything within one
process/request but not across multiple processes?
The simplest way to do this is to leave everything as per
On 8/14/07, Perrin Harkins [EMAIL PROTECTED] wrote:
Note that Apache::DBI also does the automatic rollback for you, but
only if you have AutoCommit off when you connect. If you connect with
AutoCommit on, you have to handle the rollback yourself.
Doesn't Apache::DBI just care that
On 8/14/07, Perrin Harkins [EMAIL PROTECTED] wrote:
On 8/14/07, John Siracusa [EMAIL PROTECTED] wrote:
Doesn't Apache::DBI just care that $dbh-{AutoCommit} is false at the
time it checks in the cleanup handler?
Look further up in the code. It never pushes the handler unless
AutoCommit
On 8/14/07, Perrin Harkins [EMAIL PROTECTED] wrote:
On 8/14/07, John Siracusa [EMAIL PROTECTED] wrote:
I looked for that and didn't see it, and still don't see it.
Sorry, this was actually changed already. I was looking at an older release.
Phew. Because I have stuff going to production
On 8/14/07, Michael Lackhoff [EMAIL PROTECTED] wrote:
$db-begin_work;
my $obj = Products-new(db = $db);
...
$obj-save;
some_helper_that_uses_db(); # rollback here
my $obj2 = Customers-new(db = $db);
...
$obj2-save;
$db-commit;
When I ran this code $obj2 was saved but $obj was rolled
On 8/14/07, Michael Lackhoff [EMAIL PROTECTED] wrote:
On 14.08.2007 20:34 John Siracusa wrote:
On 8/14/07, Michael Lackhoff [EMAIL PROTECTED] wrote:
$db-begin_work;
my $obj = Products-new(db = $db);
...
$obj-save;
some_helper_that_uses_db(); # rollback here
my $obj2 = Customers-new
On 8/11/07, Jonathan Vanasco [EMAIL PROTECTED] wrote:
so let me rephrase this question:
i thought strip() wasn't supposed to remove fkeys/rels ? it seems
to be doing so in .765
http://search.cpan.org/dist/Rose-DB-Object/lib/Rose/DB/Object/Helpers.pm#strip
By default, the db object
On 8/10/07 11:38 AM, news wrote:
I believe it is impossible to use rows() after a single fetch() to
determine whether no not the fetch() returned a row.
The return value from fetch() when defined does:
Yeah, that's much better, thanks. Changed in SVN.
-John
On 8/7/07 5:12 PM, George Hartzell wrote:
If I change Rose::DB::SQLite::validate_datetime_keyword so that it'll
accept 'current_timestamp'
Yeah, I should do that...
then the value gets inserted literally into the table.
it probably also needs to be inlined (i.e., unquoted)
I'd like to be
On 8/8/07 10:55 AM, Philip Dye wrote:
$rv = $sth-rows;
Returns the number of rows affected by the last row affecting
command, or -1 if the number of rows is not known or not available.
In SVN, I changed in from:
if($rows 0)
to
if($rows 0 || $rows == -1)
which
On 8/5/07, Ricardo SIGNES [EMAIL PROTECTED] wrote:
Okay, at this point I looked at the docs and decided to try using with
$group-load(with = 'groups');
@u = $group-users;
is(@u, 1); # hooray!
...except when I was about to cheer about this on IRC, I noticed that I'd said
with =
On 8/4/07, Ricardo SIGNES [EMAIL PROTECTED] wrote:
I can't find this documented, and it seems like a very imporant default to
document, given the obnoxious way in which the database-level defaults for
datetimes and the like can differ.
The first thing to understand is that the default can be
Version 0.765 will be released to CPAN this weekend, barring an
unforeseen events. If you find any remaining show-stopper bugs, speak
up soon! :)
As a reminder, SVN is at:
https://rose.svn.sourceforge.net/svnroot/rose
You will need to check out Rose-DB as well as Rose-DB-Object.
More links
) - John Siracusa [EMAIL PROTECTED]
* Added a value_type attribute to SET columns.
* Added a normalize_get_objects_args() utility method to make
custom Manager methods less cumbersome to implement.
* Setting a BigInt column to undef no longer sets it to zero.
(Reported by Jeffrey
Anyone want to help me clean out spam on the RDBO wiki? I've fallen behind
in doing it again.
http://rose.sourceforge.net/wiki/
The recent changes page is a good place to start:
http://rose.sourceforge.net/wiki/index.php/Special:Recentchanges
I keep looking for an anti-spam solution that
On 4/30/07, Jonathan Vanasco [EMAIL PROTECTED] wrote:
i'd like to see an is not operator
I've added is/is_not operators to QueryBuilder in SVN. Give them a
spin and let me know if they do what you want.
-John
-
This
On 5/25/07, James Masters [EMAIL PROTECTED] wrote:
Table or relationship names can be used in the value of the query
parameter, but the with_objects and require_objects parameters only
accept foreign key and relationship names. I think the error you got
is because you put productlocs in
On 4/2/07, Jonathan Vanasco [EMAIL PROTECTED] wrote:
testing some more, i found out that this happens only on a function
index
ie:
works:
CREATE UNIQUE INDEX email_uidx ON table(email)
breaks:
CREATE UNIQUE INDEX email_uidx ON
On 6/28/07, Philip Dye [EMAIL PROTECTED] wrote:
Here are two classes, the first works as expected the second fails with the
listed error message: [...]
Can't call method Id on unblessed reference at
.../Rose/DB/Object/MakeMethods/Generic.pm line 3470.
This is a Perl issue, not an RDBO
On 6/19/07, John Siracusa [EMAIL PROTECTED] wrote:
On 6/18/07, mla [EMAIL PROTECTED] wrote:
Subselect?
SELECT count(*)
FROM (
SELECT DISTINCT a_id, b_id
FROM a_b_map
WHERE a_id = xxx
) s
That's the solution I went with. It's fixed now in SVN.
-John
On 7/6/07, Michael Reece [EMAIL PROTECTED] wrote:
i've skimmed the docs again and don't see it, but is there an easy
way to generate _iterator methods for one-to-many relationships?
No, but creating one wouldn't be hard. It's basically just the
existing find method, with the get_objects() call
On 7/5/07, Ron Savage [EMAIL PROTECTED] wrote:
Is adding ODBC support to Rose contraindicated (due, perhaps, to something
deep with Rose)?
I know nothing about ODBC and have never used it, so I couldn't tell you...
-John
On 7/5/07, Derek Watson [EMAIL PROTECTED] wrote:
Is there a way to set a RDBO boolean column to NULL? It seems to me
that undef evaluates to FALSE.
$obj-bool_column(undef);
$obj-save;
print $obj-bool_column; # 0
It's a bug, now fixed in SVN. Thanks for the report.
-John
On 6/28/07, Peter Karman [EMAIL PROTECTED] wrote:
I have a column defined like:
complete =
{type = 'epoch', default = '0', not_null = 1, time_zone =
'UTC'},
That works great until I load a record with complete = 0 and then try and save
it without modifying the complete value.
On 7/3/07, James Masters [EMAIL PROTECTED] wrote:
which of course fails with Unknown column 't1.C_sourceyear'.
In SVN, scalar refs are now passed through unmodified when they appear
as sort_by args. So this should work for you in 0.765:
sort_by = [ \q(C_sourceyear) ]
-John
Okay, I've made the change in SVN. RDBO 0.765 will have tN table
aliasing on by default, even for queries that only involve a single
table. The new table_aliases Manager parameter can be used to force
the old behavior.
-John
On 6/30/07 11:45 PM, Michael Lackhoff wrote:
On 30 Jun 2007 at 17:10, John Siracusa wrote:
Tables are only aliased as tN when more than one table is involved in the
query. This more than one count does not include literal subqueries like
yours, however. I'm thinking of changing it in 0.765
On 6/30/07, Michael Lackhoff [EMAIL PROTECTED] wrote:
The subselect I use, relies on the aliasing of 'gruppen' to 't1'. Of
course I can just change the definition to use the original table
name but since I didn't find any mention in the change log, perhaps
this is a bug?
Tables are only
On 6/26/07, Adrian Howard [EMAIL PROTECTED] wrote:
On 25 Jun 2007, at 16:33, John Siracusa wrote:
I'd like to see a small, self-contained,
reproducible test case. If you could post one and describe how you'd
like it to behave and what it actually does instead, that'd be helpful
Attached
On 6/27/07, Philip Dye [EMAIL PROTECTED] wrote:
Should not Rose::DB::Object complain at some point during
setup or perhaps on first use of the class when a listed
primary key column is missing from the list of columns ?
I have a check for this in Metadata.pm:
foreach my $name
On 6/26/07, James Masters [EMAIL PROTECTED] wrote: );
$loader-post_init_hook(
sub {
my $meta = shift;
# For class My::Product, try to load My::Product::Extra
my $extra_pm = $meta-class .'::Extra';
eval require $extra_pm;
});
my @classes
On 6/25/07, Adrian Howard [EMAIL PROTECTED] wrote:
1) I have a single process (mod_perl) with two different RDBO
hierarchies connecting to two different databases from the same MySQL
5 server - each using their own IMA::DB subclasses
Er, IMA::DB?
2) The two databases both have a table with
On 6/25/07, Iļja Ketris [EMAIL PROTECTED] wrote:
I am trying to achieve a simple task of updating many columns in a row from
a hash. %hash = (field1='foo', field2='bar' ...)
While I can pass a hash to the new method
$product = Product-new (%hash);
I don't see a simple way to update a
On 6/23/07, Iļja Ketris [EMAIL PROTECTED] wrote:
What is the proper way of forcing European date parsing for a date or a
timestamp column?
What scope? Just for one column? For a certain data sources? Universally?
-John
On 6/22/07, Svilen Ivanov [EMAIL PROTECTED] wrote:
This serialized columns seem common practice (at least 2-3 devs asked
up till now) but inclusion in RDBO package may be overkill, how about
posting the samples in documentation or in the wiki (I faintly recall
RDBO wiki somewhere)?
There's a
On 6/21/07, Jonathan Swartz [EMAIL PROTECTED] wrote:
Actually, upon reflection, it seems strange to me that column default
values would have any effect on load().
That is, if I do
User-new(some_unique_column = 'some value')-load()
is there any legitimate reason I'd want a default
On 6/19/07, mla [EMAIL PROTECTED] wrote:
Could you expand a bit on that first sentence? What's the purpose of the
SQL abstraction?
It's to provide a structured, mutable representation of SQL, rather
than trying to deal with it as a big, opaque string.
I wouldn't mind using SQL and then just
On 6/19/07, mla [EMAIL PROTECTED] wrote:
The features I'm interested in are:
o Providing a somewhat consistent interface between these ad-hoc
result sets and normal RDBO objects.
o Catching field typos which the accessors/mutators would give you.
(although you could do the
On 6/18/07, mla [EMAIL PROTECTED] wrote:
Subselect?
SELECT count(*)
FROM (
SELECT DISTINCT a_id, b_id
FROM a_b_map
WHERE a_id = xxx
) s
So far, that looks like the best option to me. Can anyone think of
anything better?
-John
On 6/14/07, Derek Watson [EMAIL PROTECTED] wrote:
1. A fatal error is thrown when the object count is zero. I believe
this is happening around line 2749 of MakeMethods::Generic:
$count =
$ft_manager-$ft_count_method(query = [EMAIL PROTECTED], db =
$self-db,
On 6/18/07, Derek Watson [EMAIL PROTECTED] wrote:
Postgres defines the function separately from count(*):
count(expression) number of input values for which the value of
expression is not null
In this case I would write
SELECT COUNT(coalesce(t1.a_id, t1.b_id))
Which would count the
On 6/13/07, Ovid [EMAIL PROTECTED] wrote:
Thanks! Any idea when there might be a new stable release?
End of the month, maybe.
-John
-
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version
On 6/13/07 9:29 PM, Cees Hek wrote:
Could you not just join the locations table twice?
Actually, in the latest version, I don't think you can do that. But I
wonder if I should (re)allow it. Opinions?
-John
-
This
On 6/13/07 10:24 PM, Cees Hek wrote:
Well, joining the same table twice is a valid SQL construct (similar
to doing a self join), and it can be useful in certain situations. So
I would vote to keep it...
Was there a specific reason that it was changed? Or did it just
happen as part of
On 6/11/07, Fred Cox [EMAIL PROTECTED] wrote:
insert() - Invalid default timestamp: '(now() + '21
days'::interval)' at
/usr/local/lib/perl5/site_perl/5.8.8/Rose/DB/Object.pm
line 1106
The column definition looks like this:
tsexpire | timestamp without time zone | not
null default
On 6/11/07 8:46 AM, Ovid wrote:
And when I try to delete the corresponding object in there:
$self-delete_suspended;
diag Dumper($self-suspended);
I still have a Donhost::Server::Dedicated::Suspended object in there.
I thought, maybe I need to save it first:
You do, because the
On 6/11/07 8:46 AM, Ovid wrote:
In my meta setup for one object, I have the following:
relationships = [
suspended = {
class = 'Donhost::Server::Dedicated::Suspended',
column_map = { server = 'server' },
type = 'one to one',
On 6/11/07 1:21 PM, Michael Reece wrote:
however, the error is in $@ and not $map_manager-error, so the
reason for the failure is not reported.
Thanks, I correct the error propagation when I get a chance.
-John
-
This
On 6/10/07, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
some digging found the generated method spending the time merging all the
args together, then didn't use them
Oops :) Patch applied, thanks.
-John
-
This SF.net
On 6/7/07 3:04 AM, Cees Hek wrote:
On 6/7/07, Neal Clark [EMAIL PROTECTED] wrote:
Thank you for the prompt reply. I am not entirely sure I understood
it, and I probably didn't give the right details when I mailed the
list earlier today. If I change my id column from serial to integer
it will
On 6/7/07 11:06 AM, Adrian Howard wrote:
I had expected this:
$o-add_foos( $foo1, $foo2 );
to be the same as:
$o-add_foos( $foo1 );
$o-add_foos( $foo2 );
$o-save;
It's not. The last add is the only one that counts. That may change
someday, but for now that's how it is.
On 6/6/07 9:28 PM, Neal Clark wrote:
so, it this key constraint is being violated because the dropsite
that was just -save'd, which would have had an id of 19, was in fact
not inserted. Yet it does increment my dropsites_id_seq, because
overtime i run this the row that is not present in table
On 6/4/07, Jonathan Vanasco [EMAIL PROTECTED] wrote:
the error message is:
Don't know how to handle comparison values %(value)d at %(file
that called the manager function)s
it would be nice if rose would
a- note the problematic fields ( right now, it just spews 1 value )
b- note the
On 6/5/07, Adrian Howard [EMAIL PROTECTED] wrote:
Is there a non-sourceforge archive of this mailing list anywhere...
sourceforge.net is giving me a 500 every time I try and get at things
that look useful :-)
Yeah, I tend to use this one:
On 6/4/07, Iļja Ketris [EMAIL PROTECTED] wrote:
On 6/4/07, John Siracusa [EMAIL PROTECTED] wrote:
If it's there's a real foreign key constraint in the database, the Loader
make a foreign key in the RDBO class.
How is this possible? SQLite doesn't support foreign keys
It does, sort
On 6/4/07, Jonathan Vanasco [EMAIL PROTECTED] wrote:
is there a convenient way to get a setter for a relationship?
Yes, and it works the same way as for columns. Like columns,
relationships and foreign keys have N named method types created on
their behalf. Examples of method type names are
On 6/4/07, Jonathan Vanasco [EMAIL PROTECTED] wrote:
this might be where my confusion is -- mutator_method_name states
Returns the name of the method used to set the column value.
many items reference column -- but it seems like they work for
fkeys/relationships to. maybe all i needed was a
On 6/3/07 5:20 PM, I?ja Ketris wrote:
I wonder how the module decides about foreign keys over relationships.
If it's there's a real foreign key constraint in the database, the Loader
make a foreign key in the RDBO class.
-John
On 5/30/07 2:31 AM, David Lloyd wrote:
Interestingly, it seems that Rose::DB::Object will attempt to make the
first field that it can lexically see in the meta hash the primary key
IF no primary key is given.
Correct. I think that's documented somewhere, but I can't find it...
Furthermore,
On 5/29/07, James Masters [EMAIL PROTECTED] wrote:
Rose clearly cleverly deals with cascading deletes etc. regardless of
whether foreign keys are used or not. But where foreign keys are in use, if
I delete a parent table, does Rose know not to attempt the cascading delete
itself and just let
On 5/25/07, James Masters [EMAIL PROTECTED] wrote:
When I asked can I put the metadata of a DB column into an HTML Object
somehow and it would automatically create
the appropriate html form element, you said: [...]
So does this mean that the answer is no but instead I can define my own HTML
On 5/24/07, James Masters [EMAIL PROTECTED] wrote:
Query is combined viz:
prodcode = {'like' = %shp%}
productlocs.loccode = {'like' = %mtg%}
Status = {'ne' = P}
with_objects = productlocs
[...]
# category.name and categories.name would work too, since
# table and relationship names are
Does anyone have any good ideas for a namespace for module that augment or
extend RDBO, but that are not part of the official RDBO distribution? The
first thing that springs to my mind is:
Rose::DBx::*
That'd be for both modules that are related to Rose::DB and modules that are
related to
On 5/23/07 12:53 PM, Jonathan Vanasco wrote:
On May 23, 2007, at 9:36 AM, John Siracusa wrote:
Does anyone have any good ideas for a namespace for module that augment or
extend RDBO, but that are not part of the official RDBO distribution? The
first thing that springs to my mind is:
Rose
On 5/23/07 1:49 PM, mla wrote:
I noticed that omitting the override_existing does
not raise an exception; the redefinition is just
ignored.
Is that expected?
Yes, because you'renot overriding an existing sub.
MyApp::DB::Object::Metadata has no existing default_update_changes_only()
On 5/22/07, James Masters [EMAIL PROTECTED] wrote:
This problem has gone away now. I don't understand why but I *think* what
did it was that I indexed (unique) the column concerned in the target MyISAM
table. Do key columns need to be indexed?
RDBO has no idea if your columns are indexed or
On 5/20/07 10:02 AM, Adrian Howard wrote:
On 20 May 2007, at 00:15, John Siracusa wrote:
The quick-start guide I envision [...]
That sounds excellent :-) Thank you.
Don't thank me for envisioning it; save it for when I actually get around to
writing it ;)
-John
On 5/19/07 1:01 PM, Adrian Howard wrote:
A quick start along the lines of Here's a database schema. Here's
RDBO::Loader.. Bish bosh. Job done. Oh yes, when you need some more
flexibility, better validation, etc. here's where to look would be
nice.
The quick-start guide I envision has very
On 5/18/07, Marvin Humphrey [EMAIL PROTECTED] wrote:
On May 18, 2007, at 9:00 AM, John Siracusa wrote:
Since those sections are clearly labeled and there are links to all
the major sections (in the HTML version of the POD, that is), I don't
think it's too onerous for those people that want
On 5/18/07, Jonathan Vanasco [EMAIL PROTECTED] wrote:
John- Maybe you could do a callout for recipes, and then cull the
best into it?
It's on the list, but not at the top just yet. (Even just collecting
and editing recipes takes time.) If someone else wants to head this
up, let me know.
The
On 5/18/07, Derek Watson [EMAIL PROTECTED] wrote:
It's on the list, but not at the top just yet. (Even just collecting
and editing recipes takes time.) If someone else wants to head this
up, let me know.
Is there a Wiki installed somewhere we can start working on in an
ad-hoc fashion?
On 5/17/07, Jonathan Vanasco [EMAIL PROTECTED] wrote:
if you use_key on the primary key, rose doesn't do anything.
Fixed in SVN. Thanks for the report.
-John
-
This SF.net email is sponsored by DB2 Express
Download DB2
On 5/17/07, Derek Watson [EMAIL PROTECTED] wrote:
I have gone down a similar path before,
http://www.mail-archive.com/rose-db-object@lists.sourceforge.net/msg01792.html
Yeah, I was about to post that link. Thanks :)
When you need to manipulate the map records themselves, setup an
Yes, Rose::Object. It had a bug that prevented Rose::DB::Object's new
helpers setup() parameter from working. Rose::DB::Object 0.765 will
require Rose::Object 0.84 or later once it's released, but you should
upgrade to Rose::Object 0.84 right now if you want the helpers setup
param to work with
Can you also post the table definitions? (Simplified, if necessary.)
On 5/17/07 5:19 PM, Wiggins d'Anconia wrote:
'company_branches' stores a one-to-many of companies to their branches.
'user_company_map' stores what I thought would originally be a many-to-many
between the users and the
On 5/16/07 12:51 AM, Jeffrey Horn wrote:
__PACKAGE__-meta-setup(
table = 'foo',
columns = [
foo_id = { type = 'bigint', not_null = 1 },
nullable_int = { type = 'bigint' },
nullable_varchar = { type = 'varchar', length = 10 },
],
On 5/10/07, Peter Karman [EMAIL PROTECTED] wrote:
What I would like to do now is at the same time I create code, also create
stub
POD for each of the columns, fks and relationship methods that are magically
available in each class. Just stubs: the method name, column/fk/relationship
On 5/11/07, Michael Lackhoff [EMAIL PROTECTED] wrote:
I had to change a relationship from a simple ID to ID relationship to
one that also includes a second ID.
Worse still the second ID is not a column in one of the relationship
partners but has to be taken from a record two steps up the
On 5/11/07, Michael Reece [EMAIL PROTECTED] wrote:
1. is there a way to pull that off with 'one to one' type
relationship so i can drop the subroutine?
Not unless you add an is_latest column or something to the table.
2. or is there a way to tack on extra conditions (or custom ordering)
to
(05.04.2007) - John Siracusa [EMAIL PROTECTED]
* Added a find method type to many-to-many relationships.
* Added a count method type to ...-to-many relationships.
* Added support for nested joins.
* The setup() method now supports a helpers shortcut for importing
methods from
On 5/2/07, Ovid [EMAIL PROTECTED] wrote:
This may or may not be of use to anyone. One thing I've done is create
a 'datatype generator' which is shorthand for many data types and it's
legible, too. For example, instead of this:
reason = {
type = 'scalar',
length = 255,
On 5/1/07, Derek Watson [EMAIL PROTECTED] wrote:
I feel like I'm repeating work here -- I've got a similar set of
functions that serialize and restore trees of objects, only I'm doing
this in a very specific way, keeping only what I want from specific
classes (not reusable).
What are the
Sorry for any delays in responding to RDBO issues or email. We just
had a baby (our second) and things will likely be a bit hectic here
for a while... :)
-John
-
This SF.net email is sponsored by DB2 Express
Download DB2
Thanks to all. Incidentally, Rose was one of my name choices for
her, but my wife nixed it :)
-John
-
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control
On 4/24/07 11:50 AM, Ovid wrote:
I have a 'server' object. There's a 'suspension' table which has an optional
single record for each server. If a server is suspended, the table gets a
record of metadata for why the server was suspended. When the server is
unsuspended, we delete said record.
On 4/23/07, Ethan Rowe [EMAIL PROTECTED] wrote:
Table b has an FK to table a. Table b also has an FK to table c. These FK
columns are all NOT NULL constrained.
If that is the case, and if referential integrity is turned on for the
foreign key that links b to c, then you are telling RDBO that
On 4/23/07, Ovid [EMAIL PROTECTED] wrote:
http://tinyurl.com/26hpwz
What's wrong with implementing the scenario described at that URL
exactly as it's explained, by using multi-column foreign keys and a
check constraint on the subtype table(s)?
A simple syntax could be:
distributed_keys =
101 - 200 of 573 matches
Mail list logo