Adam Kennedy > ORDB-AU-Census2006-0.01 > ORDB::AU::Census2006::BcpCdB39

Download:
ORDB-AU-Census2006-0.01.tar.gz

Annotate this POD

View/Report Bugs
Source  

NAME ^

ORDB::AU::Census2006::BcpCdB39 - ORDB::AU::Census2006 class for the bcp_cd_b39 table

SYNOPSIS ^

  TO BE COMPLETED

DESCRIPTION ^

TO BE COMPLETED

METHODS ^

select

  # Get all objects in list context
  my @list = ORDB::AU::Census2006::BcpCdB39->select;
  
  # Get a subset of objects in scalar context
  my $array_ref = ORDB::AU::Census2006::BcpCdB39->select(
      'where  > ? order by ',
      1000,
  );

The select method executes a typical SQL SELECT query on the bcp_cd_b39 table.

It takes an optional argument of a SQL phrase to be added after the FROM bcp_cd_b39 section of the query, followed by variables to be bound to the placeholders in the SQL phrase. Any SQL that is compatible with SQLite can be used in the parameter.

Returns a list of ORDB::AU::Census2006::BcpCdB39 objects when called in list context, or a reference to an ARRAY of ORDB::AU::Census2006::BcpCdB39 objects when called in scalar context.

Throws an exception on error, typically directly from the DBI layer.

count

  # How many objects are in the table
  my $rows = ORDB::AU::Census2006::BcpCdB39->count;
  
  # How many objects 
  my $small = ORDB::AU::Census2006::BcpCdB39->count(
      'where  > ?',
      1000,
  );

The count method executes a SELECT COUNT(*) query on the bcp_cd_b39 table.

It takes an optional argument of a SQL phrase to be added after the FROM bcp_cd_b39 section of the query, followed by variables to be bound to the placeholders in the SQL phrase. Any SQL that is compatible with SQLite can be used in the parameter.

Returns the number of objects that match the condition.

Throws an exception on error, typically directly from the DBI layer.

ACCESSORS ^

REMAINING ACCESSORS TO BE COMPLETED

SQL ^

The bcp_cd_b39 table was originally created with the following SQL command.

  CREATE TABLE bcp_cd_b39 (
      region_id REAL NOT NULL,
      b4961 BLOB NOT NULL,
      b4962 BLOB NOT NULL,
      b4963 BLOB NOT NULL,
      b4964 BLOB NOT NULL,
      b4965 BLOB NOT NULL,
      b4966 BLOB NOT NULL,
      b4967 BLOB NOT NULL,
      b4968 BLOB NOT NULL,
      b4969 BLOB NOT NULL,
      b4970 BLOB NOT NULL,
      b4971 BLOB NOT NULL,
      b4972 BLOB NOT NULL,
      b4973 BLOB NOT NULL,
      b4974 BLOB NOT NULL,
      b4975 BLOB NOT NULL,
      b4976 BLOB NOT NULL,
      b4977 BLOB NOT NULL,
      b4978 BLOB NOT NULL,
      b4979 BLOB NOT NULL,
      b4980 BLOB NOT NULL,
      b4981 BLOB NOT NULL,
      b4982 BLOB NOT NULL,
      b4983 BLOB NOT NULL,
      b4984 BLOB NOT NULL,
      b4985 BLOB NOT NULL,
      b4986 BLOB NOT NULL,
      b4987 BLOB NOT NULL,
      b4988 BLOB NOT NULL,
      b4989 BLOB NOT NULL,
      b4990 BLOB NOT NULL,
      b4991 BLOB NOT NULL,
      b4992 BLOB NOT NULL,
      b4993 BLOB NOT NULL,
      b4994 BLOB NOT NULL,
      b4995 BLOB NOT NULL,
      b4996 BLOB NOT NULL,
      b4997 BLOB NOT NULL,
      b4998 BLOB NOT NULL,
      b4999 BLOB NOT NULL,
      b5000 BLOB NOT NULL,
      b5001 BLOB NOT NULL,
      b5002 BLOB NOT NULL,
      b5003 BLOB NOT NULL,
      b5004 BLOB NOT NULL,
      b5005 BLOB NOT NULL,
      b5006 BLOB NOT NULL,
      b5007 BLOB NOT NULL,
      b5008 BLOB NOT NULL,
      b5009 BLOB NOT NULL,
      b5010 BLOB NOT NULL,
      b5011 BLOB NOT NULL,
      b5012 BLOB NOT NULL,
      b5013 BLOB NOT NULL,
      b5014 BLOB NOT NULL,
      b5015 BLOB NOT NULL,
      b5016 BLOB NOT NULL,
      b5017 BLOB NOT NULL,
      b5018 BLOB NOT NULL,
      b5019 BLOB NOT NULL,
      b5020 BLOB NOT NULL,
      b5021 BLOB NOT NULL,
      b5022 BLOB NOT NULL,
      b5023 BLOB NOT NULL,
      b5024 BLOB NOT NULL,
      b5025 BLOB NOT NULL,
      b5026 BLOB NOT NULL,
      b5027 BLOB NOT NULL,
      b5028 BLOB NOT NULL,
      b5029 BLOB NOT NULL,
      b5030 BLOB NOT NULL,
      b5031 BLOB NOT NULL,
      b5032 BLOB NOT NULL,
      b5033 BLOB NOT NULL,
      b5034 BLOB NOT NULL,
      b5035 BLOB NOT NULL,
      b5036 BLOB NOT NULL,
      b5037 BLOB NOT NULL,
      b5038 BLOB NOT NULL,
      b5039 BLOB NOT NULL,
      b5040 BLOB NOT NULL,
      b5041 BLOB NOT NULL,
      b5042 BLOB NOT NULL,
      b5043 BLOB NOT NULL,
      b5044 BLOB NOT NULL,
      b5045 BLOB NOT NULL,
      b5046 BLOB NOT NULL,
      b5047 BLOB NOT NULL,
      b5048 BLOB NOT NULL,
      b5049 BLOB NOT NULL,
      b5050 BLOB NOT NULL,
      b5051 BLOB NOT NULL,
      b5052 BLOB NOT NULL,
      b5053 BLOB NOT NULL,
      b5054 BLOB NOT NULL,
      b5055 BLOB NOT NULL,
      b5056 BLOB NOT NULL,
      b5057 BLOB NOT NULL,
      b5058 BLOB NOT NULL,
      b5059 BLOB NOT NULL,
      b5060 BLOB NOT NULL,
      b5061 BLOB NOT NULL,
      b5062 BLOB NOT NULL,
      b5063 BLOB NOT NULL,
      b5064 BLOB NOT NULL,
      b5065 BLOB NOT NULL,
      b5066 BLOB NOT NULL,
      b5067 BLOB NOT NULL,
      b5068 BLOB NOT NULL,
      b5069 BLOB NOT NULL,
      b5070 BLOB NOT NULL,
      b5071 BLOB NOT NULL,
      b5072 BLOB NOT NULL,
      b5073 BLOB NOT NULL,
      b5074 BLOB NOT NULL,
      b5075 BLOB NOT NULL,
      b5076 BLOB NOT NULL,
      b5077 BLOB NOT NULL,
      b5078 BLOB NOT NULL,
      b5079 BLOB NOT NULL,
      b5080 BLOB NOT NULL,
      b5081 BLOB NOT NULL,
      b5082 BLOB NOT NULL,
      b5083 BLOB NOT NULL,
      b5084 BLOB NOT NULL,
      b5085 BLOB NOT NULL,
      b5086 BLOB NOT NULL,
      b5087 BLOB NOT NULL,
      b5088 BLOB NOT NULL,
      b5089 BLOB NOT NULL,
      b5090 BLOB NOT NULL,
      b5091 BLOB NOT NULL,
      b5092 BLOB NOT NULL,
      b5093 BLOB NOT NULL,
      b5094 BLOB NOT NULL,
      b5095 BLOB NOT NULL,
      b5096 BLOB NOT NULL,
      b5097 BLOB NOT NULL,
      b5098 BLOB NOT NULL,
      b5099 BLOB NOT NULL,
      b5100 BLOB NOT NULL,
      b5101 BLOB NOT NULL,
      b5102 BLOB NOT NULL,
      b5103 BLOB NOT NULL,
      b5104 BLOB NOT NULL,
      b5105 BLOB NOT NULL,
      b5106 BLOB NOT NULL,
      b5107 BLOB NOT NULL,
      b5108 BLOB NOT NULL,
      b5109 BLOB NOT NULL,
      b5110 BLOB NOT NULL,
      b5111 BLOB NOT NULL,
      b5112 BLOB NOT NULL,
      b5113 BLOB NOT NULL,
      b5114 BLOB NOT NULL,
      b5115 BLOB NOT NULL,
      b5116 BLOB NOT NULL,
      b5117 BLOB NOT NULL,
      b5118 BLOB NOT NULL,
      b5119 BLOB NOT NULL,
      b5120 BLOB NOT NULL,
      b5121 BLOB NOT NULL,
      b5122 BLOB NOT NULL,
      b5123 BLOB NOT NULL,
      b5124 BLOB NOT NULL,
      b5125 BLOB NOT NULL,
      b5126 BLOB NOT NULL,
      b5127 BLOB NOT NULL,
      b5128 BLOB NOT NULL,
      b5129 BLOB NOT NULL,
      b5130 BLOB NOT NULL,
      b5131 BLOB NOT NULL,
      b5132 BLOB NOT NULL,
      b5133 BLOB NOT NULL,
      b5134 BLOB NOT NULL,
      b5135 BLOB NOT NULL,
      b5136 BLOB NOT NULL,
      b5137 BLOB NOT NULL,
      b5138 BLOB NOT NULL,
      b5139 BLOB NOT NULL,
      b5140 BLOB NOT NULL,
      b5141 BLOB NOT NULL,
      b5142 BLOB NOT NULL,
      b5143 BLOB NOT NULL,
      b5144 BLOB NOT NULL,
      b5145 BLOB NOT NULL,
      b5146 BLOB NOT NULL,
      b5147 BLOB NOT NULL,
      b5148 BLOB NOT NULL,
      b5149 BLOB NOT NULL,
      b5150 BLOB NOT NULL,
      b5151 BLOB NOT NULL,
      b5152 BLOB NOT NULL,
      b5153 BLOB NOT NULL,
      b5154 BLOB NOT NULL,
      b5155 BLOB NOT NULL,
      b5156 BLOB NOT NULL,
      b5157 BLOB NOT NULL,
      b5158 BLOB NOT NULL,
      b5159 BLOB NOT NULL,
      b5160 BLOB NOT NULL,
      b5161 BLOB NOT NULL,
      b5162 BLOB NOT NULL,
      b5163 BLOB NOT NULL,
      b5164 BLOB NOT NULL,
      b5165 BLOB NOT NULL,
      b5166 BLOB NOT NULL,
      b5167 BLOB NOT NULL,
      b5168 BLOB NOT NULL,
      b5169 BLOB NOT NULL,
      b5170 BLOB NOT NULL,
      b5171 BLOB NOT NULL,
      b5172 BLOB NOT NULL,
      b5173 BLOB NOT NULL,
      b5174 BLOB NOT NULL,
      b5175 BLOB NOT NULL,
      b5176 BLOB NOT NULL,
      b5177 BLOB NOT NULL,
      b5178 BLOB NOT NULL,
      b5179 BLOB NOT NULL,
      b5180 BLOB NOT NULL,
      b5181 BLOB NOT NULL,
      b5182 BLOB NOT NULL,
      b5183 BLOB NOT NULL,
      b5184 BLOB NOT NULL,
      b5185 BLOB NOT NULL,
      b5186 BLOB NOT NULL,
      b5187 BLOB NOT NULL,
      b5188 BLOB NOT NULL,
      b5189 BLOB NOT NULL,
      b5190 BLOB NOT NULL,
      b5191 BLOB NOT NULL,
      b5192 BLOB NOT NULL,
      b5193 BLOB NOT NULL,
      b5194 BLOB NOT NULL,
      b5195 BLOB NOT NULL,
      b5196 BLOB NOT NULL,
      b5197 BLOB NOT NULL,
      b5198 BLOB NOT NULL,
      b5199 BLOB NOT NULL,
      b5200 BLOB NOT NULL,
      b5201 BLOB NOT NULL,
      b5202 BLOB NOT NULL,
      b5203 BLOB NOT NULL,
      b5204 BLOB NOT NULL,
      b5205 BLOB NOT NULL,
      b5206 BLOB NOT NULL,
      b5207 BLOB NOT NULL,
      b5208 BLOB NOT NULL,
      b5209 BLOB NOT NULL,
      b5210 BLOB NOT NULL,
      b5211 BLOB NOT NULL,
      b5212 BLOB NOT NULL,
      b5213 BLOB NOT NULL,
      b5214 BLOB NOT NULL,
      b5215 BLOB NOT NULL,
      b5216 BLOB NOT NULL,
      b5217 BLOB NOT NULL,
      b5218 BLOB NOT NULL,
      b5219 BLOB NOT NULL,
      b5220 BLOB NOT NULL,
      b5221 BLOB NOT NULL,
      b5222 BLOB NOT NULL,
      b5223 BLOB NOT NULL,
      b5224 BLOB NOT NULL,
      b5225 BLOB NOT NULL,
      b5226 BLOB NOT NULL,
      b5227 BLOB NOT NULL,
      b5228 BLOB NOT NULL,
      b5229 BLOB NOT NULL,
      b5230 BLOB NOT NULL,
      b5231 BLOB NOT NULL,
      b5232 BLOB NOT NULL,
      b5233 BLOB NOT NULL,
      b5234 BLOB NOT NULL,
      b5235 BLOB NOT NULL,
      b5236 BLOB NOT NULL,
      b5237 BLOB NOT NULL,
      b5238 BLOB NOT NULL,
      b5239 BLOB NOT NULL,
      b5240 BLOB NOT NULL,
      b5241 BLOB NOT NULL,
      b5242 BLOB NOT NULL,
      b5243 BLOB NOT NULL,
      b5244 BLOB NOT NULL,
      b5245 BLOB NOT NULL,
      b5246 BLOB NOT NULL,
      b5247 BLOB NOT NULL,
      b5248 BLOB NOT NULL,
      b5249 BLOB NOT NULL,
      b5250 BLOB NOT NULL,
      b5251 BLOB NOT NULL,
      b5252 BLOB NOT NULL,
      b5253 BLOB NOT NULL,
      b5254 BLOB NOT NULL,
      b5255 BLOB NOT NULL,
      b5256 BLOB NOT NULL,
      b5257 BLOB NOT NULL
  )

SUPPORT ^

ORDB::AU::Census2006::BcpCdB39 is part of the ORDB::AU::Census2006 API.

See the documentation for ORDB::AU::Census2006 for more information.

COPYRIGHT ^

Copyright 2009 Adam Kennedy.

This program is free software; you can redistribute it and/or modify it under the same terms as Perl itself.

The full text of the license can be found in the LICENSE file included with this module.

syntax highlighting: