On 21/05/10 11:46, Alexander Hartmaier wrote:
Hi Chris,
Am Freitag, den 21.05.2010, 11:33 +0200 schrieb Chris Cole:
Hi ALex,
On 21/05/10 09:36, Alexander Hartmaier wrote:
DDL queries executed by your model at runtime sounds like a VERY bad
idea!
Your app db user shouldn't even be allowed to execute those.
Why?
Security reasons? If your app server is hacked its possible to use the
db user to harm your database.
Oh, right. This is a locked down server that is only accessible from
within the building. The database is being used for research purposes
with no sensitive data, so hacking is not a real problem.
Plus, the people with the nous to be able to connect to the DB in this
building I can count on the fingers of one and a bit hands ;)
I'm using Oracle with partitioned tables (one per month for historical
data) as well and the database itself cares about creating the partition
for the next month in advance.
What for are you using the partitions?
The table itself holds information of matches to genomic DNA from
sequencing experiments. We do this for several different organisms and
experiments and the table will get pretty large (currently 92M rows).
The partitions are used to separate data mappings into different
experiments.
Would this be better done via a trigger?
A trigger sounds like a much better idea!
OK. I'll look it.
Ta.
Cheers,
Chris
--
Best regards, Alex
Am Mittwoch, den 12.05.2010, 10:07 +0200 schrieb Chris Cole:
On Tue, 11 May 2010 21:52:47 +0100, Rob Kinyon<[email protected]>
wrote:
On Tue, May 11, 2010 at 16:01, Chris Cole<[email protected]>
wrote:
Gives this error:
Warning - transaction failed and rolling back:
DBIx::Class::Schema::txn_do(): Can't locate object method "do" via
package
"DBIx::Class::Storage::DBI::Oracle::Generic" at
/homes/ccole/projects/workspace/NGSdb/load_drs_data.pl line 176.
Any ideas why $dbh-do() is failing?
Maybe reading the documentation instead of relying purely on my advice
would be a good plan.
If you'd put a caveat, maybe I would have looked harder. I did search for
the docs, but couldn't find them.
http://search.cpan.org/~frew/DBIx-Class-0.08121/lib/DBIx/Class/Storage/DBI.pm#dbh_do
$storage->dbh_do( sub {
my ($storage, $dbh, @args) = @_;
....
}, @args );
Thanks.
--
Best regards, Alex
*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*
T-Systems Austria GesmbH Rennweg 97-99, 1030 Wien
Handelsgericht Wien, FN 79340b
*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*
Notice: This e-mail contains information that is confidential and may be
privileged.
If you are not the intended recipient, please notify the sender and then
delete this e-mail immediately.
*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*
_______________________________________________
List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class
IRC: irc.perl.org#dbix-class
SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/
Searchable Archive: http://www.grokbase.com/group/[email protected]
--
Dr Chris Cole
Senior Bioinformatics Research Officer
School of Life Sciences Research
University of Dundee
Dow Street
Dundee
DD1 5EH
Scotland, UK
url: http://network.nature.com/profile/drchriscole
e-mail: [email protected]
Tel: +44 (0)1382 388 721
The University of Dundee is a registered Scottish charity, No: SC015096
_______________________________________________
List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class
IRC: irc.perl.org#dbix-class
SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/
Searchable Archive: http://www.grokbase.com/group/[email protected]
