04-04-2017
You can normally define a few things to help you, such as unique constraints and defining the column as not accepting nulls.
It then depends on your loader if it pushes in the records it can and reports the anomalies, or if it just fails altogether at the start or with partial data loaded.
Robin
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
please give the difference between AIX shell scripting and Unix shell scripting. (2 Replies)
Discussion started by: haroonec
2 Replies
2. UNIX for Dummies Questions & Answers
Dear Champs,
Can anybody help me out to write a shell script , which will check whether the process is running , if running then divide the process into 2 so that next var it can take process parallel .
Let
ps -ef | grep a.sh => shows running
note a.sh will take a process of next... (0 Replies)
Discussion started by: manas_ranjan
0 Replies
3. Solaris
Hi,
I have a script which will check the fiel existence, the lines are as below
if !(test -d ./data) then
mkdir data
fi
In the first line error occurs as below
generatelicense.sh: syntax error at line 2: `!' unexpected
Where as this script works fine in linux OS.
How to solve... (2 Replies)
Discussion started by: krevathi1912
2 Replies
4. Shell Programming and Scripting
I am trying to write a script to get all the html files under a source directory and and for each html file, run a program with html file as an argument. This program generates an output which I need to save as htmlfilename.txt ( right now i was trying to print it on the command line)
... (11 Replies)
Discussion started by: sapient
11 Replies
5. Shell Programming and Scripting
I've got the following data in a file - basically hundred of passes.
Pass Id : PASSID1
Pass Name : 7 day pass 10 Gb
Pass Group : uk
Short Name : pmbbrh2
type : restrict
Validity ... (7 Replies)
Discussion started by: jeffersno1
7 Replies
6. Shell Programming and Scripting
Hi, I'm new to C Shell programming. I'm trying to check if a sym link exists on remote server if not send email. I'm not having much luck. Can anyone help?
Here is what I have written but it doesn't work. It tells me that my variable was not defined. Here is part of the script, the second... (0 Replies)
Discussion started by: CDi
0 Replies
7. Shell Programming and Scripting
Here is the contents of an input file.
A,1,2,3,4
10,aaa,bbb,ccc,ddd
11,eee,fff,ggg,hhh
12,iii,jjj,lll,mmm
13,nnn,ooo,ppp
I wanted the output to be
A
10 1 aaa
10 2 bbb
10 3 ccc
10 4 ddd
11 1 eee
11 2 fff
11 3 ggg
11 4 hhh .....
and so on How to do it in ksh... (9 Replies)
Discussion started by: ksatish89
9 Replies
8. Shell Programming and Scripting
I have two input files 1)datafile 2)metadata file.
I have a metadata file like:
field1datatypeformat1number2string3dateyy-mm-dd
I have a data file like:
1234abc12-8-16 xyz234512-9-163456acd14-08-12
In the first row there is no correction as everything is inline with the metadata.... (3 Replies)
Discussion started by: bikky6
3 Replies
9. Shell Programming and Scripting
Hi friends
please help me on below,
i have 5 files like below
file1 is
x 10
y 20
z 15
file2 is
x 100
z 245
file3 is
y 78
z 23
file4 is
x 100 (3 Replies)
Discussion started by: siva kumar
3 Replies
10. Shell Programming and Scripting
Hi ,
I have written a shell script to call a java program say load_id.sh .This sh script indeed is executed implicitly in other sh script which calls 2 more sh scripts one by one. I need to check if the load_id.sh (which calls java program) is executed successfully only then continue with... (1 Reply)
Discussion started by: preema
1 Replies
LEARN ABOUT DEBIAN
html::formfu::constraint::dbic::unique
HTML::FormFu::Constraint::DBIC::Unique(3pm) User Contributed Perl Documentation HTML::FormFu::Constraint::DBIC::Unique(3pm)
NAME
HTML::FormFu::Constraint::DBIC::Unique - unique constraint for HTML::FormFu::Model::DBIC
SYNOPSIS
$form->stash->{schema} = $dbic_schema; # DBIC schema
$form->element('text')
->name('email')
->constraint('DBIC::Unique')
->resultset('User')
;
$form->stash->{context} = $c; # Catalyst context
$form->element('text')
->name('email')
->constraint('DBIC::Unique')
->model('DBIC::User')
;
$form->element('text')
->name('user')
->constraint('DBIC::Unique')
->model('DBIC')
->resultset('User')
;
or in a config file:
---
elements:
- type: text
name: email
constraints:
- Required
- type: DBIC::Unique
model: DBIC::User
- type: text
name: user
constraints:
- Required
- type: DBIC::Unique
model: DBIC::User
column: username
DESCRIPTION
Checks if the input value exists in a DBIC ResultSet.
METHODS
model
Arguments: $string # a Catalyst model name like 'DBIC::User'
resultset
Arguments: $string # a DBIC resultset name like 'User'
self_stash_key
reference to a key in the form stash. if this key exists, the constraint will check if the id matches the one of this element, so that you
can use your own name.
id_field
Use this key to define reference field which consist of primary key of resultset. If the field exists (and $self_stash_key not defined),
the constraint will check if the id matches the primary key of row object:
---
elements:
- type: Hidden
name: id
constraints:
- Required
- type: Text
name: value
label: Value
constraints:
- Required
- type: DBIC::Unique
resultset: ControlledVocab
id_field: id
others
Use this key to manage unique compound database keys which consist of more than one column. For example, if a database key consists of
'category' and 'value', use a config file such as this:
---
elements:
- type: Text
name: category
label: Category
constraints:
- Required
- type: Text
name: value
label: Value
constraints:
- Required
- type: DBIC::Unique
resultset: ControlledVocab
others: category
method_name
Name of a method which will be called on the resultset. The method is passed two argument; the value of the field, and the primary key
value (usually `id`) of the record in the form stash (as defined by self_stash_key). An example config might be:
---
elements:
- type: text
name: user
constraints:
- Required
- type: DBIC::Unique
model: DBIC::User
method_name: is_username_available
SEE ALSO
Is a sub-class of, and inherits methods from HTML::FormFu::Constraint
HTML::FormFu::FormFu
AUTHOR
Jonas Alves "jgda@cpan.org"
LICENSE
This library is free software, you can redistribute it and/or modify it under the same terms as Perl itself.
perl v5.12.4 2011-07-16 HTML::FormFu::Constraint::DBIC::Unique(3pm)