Identifying a missing primary key

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Identifying missing file dates

Hi Experts, I have written the below script to check the missing files based on the date in the file name from current date to in a given interval of days. In the file names we have dates along with some name. ex:jera_sit_2017-04-25-150325.txt. The below script is working fine if we have only...

2. Shell Programming and Scripting

Shell Script @ Find a key word and If the key word matches then replace next 7 lines only

Hi All, I have a XML file which is looks like as below. <<please see the attachment >> <?xml version="1.0" encoding="UTF-8"?> <esites> <esite> <name>XXX.com</name> <storeId>10001</storeId> <module> ...

3. Solaris

Primary key issue when running Oracle sql file

I got a issue with running the following script below if I remove the inserts and alter table the tables will install just fine but if I try and do the full thing in one go i get the below error dose any one have any ideas on this problem? its got me spinning, thanks. REM REM List of...

4. Shell Programming and Scripting

Identifying Missing File Sequence

Hi, I have a file which contains few columns and the first column has the file names, and I would like to identify the missing file sequence number form the file and would copy to another file. My files has data in below format. APKRISPSIN320131231201319_0983,1,54,125,...

5. Red Hat

Yum - resolving missing dependencies that are not missing

I am trying to install VirtualBox on RHEL 5 but I need the 32 bit version for 32 bit Windows. When I run yum I get the following: sudo yum localinstall /auto/spvtg-it/spvss-migration/Software/VirtualBox-4.3-4.3.2_90405_el6-1.i686.rpm Loaded plugins: fastestmirror Setting up Local Package...

6. SuSE

How to resolve missing missing dependencies with opensuse 11.3 and 12.3?

Hello, This is a programming question as well as a suse question, so let me know if you think I should post this in programming. I have an application that I compiled under opensuse 12.2 using g77-3.3/g++3.3. The program compiles and runs just fine. I gave the application to a colleague who...

7. Programming

MySQL auto_increment, primary key

Hello, I want to create a table in mysql database by loading the local file. I am confused with the auto_increment column (say Run_ID) that I want to set it as primary key. My questions are: 1) Do I need add this Run_ID in my file ready? then this does not make any sense to the auto_increment;...

8. Solaris

Solaris 8 ssh public key authentication issue - Server refused our key

Hi, I've used the following way to set ssh public key authentication and it is working fine on Solaris 10, RedHat Linux and SuSE Linux servers without any problem. But I got error 'Server refused our key' on Solaris 8 system. Solaris 8 uses SSH2 too. Why? Please help. Thanks. ...

9. UNIX for Dummies Questions & Answers

Pressing backspace key simulates enter key

Hi, Whenever i press the backspace key, a new line appears, i.e. it works like a enter key. :confused: Thanks

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)

Programming