Tag Archive for table

snippets | May 21, 2012
No comments

rename table

ALTER TABLE table_name
RENAME TO new_table_name;

source

Category: Uncategorized | Tags: , ,
snippets | May 20, 2012
No comments

Boolean table

def btab3()
2.times{|a| 2.times{|b| 2.times{|c|
puts "#{a} #{b} #{c} | #{ yield([a,b,c])}"
}}}
end

source

Category: Uncategorized | Tags: ,
snippets | May 16, 2012
No comments

Record Exists function template

CREATE OR REPLACE FUNCTION person_exists(person_id IN VARCHAR2) RETURN BOOLEAN IS
l_count PLS_INTEGER;
BEGIN
SELECT DISTINCT 1
INTO l_count
FROM people
WHERE = person_id;

RETURN TRUE;
EXCEPTION
WHEN no_data_found THEN
RETURN FALSE;
WHEN too_many_rows THEN
RETURN TRUE;
END person_exists;

source

Category: Uncategorized | Tags: ,
snippets | April 12, 2012
No comments

MySQL Table – US States

# usps_states_list.sql
#
# This will create and then populate a MySQL table with a list of the names and
# USPS abbreviations for US states and possessions in existence as of the date
# below.
#
# Usage:
#    mysql -u username -ppassword database_name < usps_states_list.sql
#
# For updates to this file, see <a href="http://27.org/isocountrylist/" >http://27.org/isocountrylist/</a>
# For more about USPS state abbreviations, see <a href="http://www.usps.com/ncsc/lookups/usps_abbreviations.html" >http://www.usps.com/ncsc/lookups/usps_abbreviations.html</a>
#
# Wm. Rhodes <iso_country_list@27.org>
# 1/1/03
#

CREATE TABLE IF NOT EXISTS states (
id INT NOT NULL auto_increment,
name CHAR(40) NOT NULL,
abbrev CHAR(2) NOT NULL,
PRIMARY KEY (id)
);

INSERT INTO states VALUES (NULL, 'Alaska', 'AK');
INSERT INTO states VALUES (NULL, 'Alabama', 'AL');
INSERT INTO states VALUES (NULL, 'American Samoa', 'AS');
INSERT INTO states VALUES (NULL, 'Arizona', 'AZ');
INSERT INTO states VALUES (NULL, 'Arkansas', 'AR');
INSERT INTO states VALUES (NULL, 'California', 'CA');
INSERT INTO states VALUES (NULL, 'Colorado', 'CO');
INSERT INTO states VALUES (NULL, 'Connecticut', 'CT');
INSERT INTO states VALUES (NULL, 'Delaware', 'DE');
INSERT INTO states VALUES (NULL, 'District of Columbia', 'DC');
INSERT INTO states VALUES (NULL, 'Federated States of Micronesia', 'FM');
INSERT INTO states VALUES (NULL, 'Florida', 'FL');
INSERT INTO states VALUES (NULL, 'Georgia', 'GA');
INSERT INTO states VALUES (NULL, 'Guam', 'GU');
INSERT INTO states VALUES (NULL, 'Hawaii', 'HI');
INSERT INTO states VALUES (NULL, 'Idaho', 'ID');
INSERT INTO states VALUES (NULL, 'Illinois', 'IL');
INSERT INTO states VALUES (NULL, 'Indiana', 'IN');
INSERT INTO states VALUES (NULL, 'Iowa', 'IA');
INSERT INTO states VALUES (NULL, 'Kansas', 'KS');
INSERT INTO states VALUES (NULL, 'Kentucky', 'KY');
INSERT INTO states VALUES (NULL, 'Louisiana', 'LA');
INSERT INTO states VALUES (NULL, 'Maine', 'ME');
INSERT INTO states VALUES (NULL, 'Marshall Islands', 'MH');
INSERT INTO states VALUES (NULL, 'Maryland', 'MD');
INSERT INTO states VALUES (NULL, 'Massachusetts', 'MA');
INSERT INTO states VALUES (NULL, 'Michigan', 'MI');
INSERT INTO states VALUES (NULL, 'Minnesota', 'MN');
INSERT INTO states VALUES (NULL, 'Mississippi', 'MS');
INSERT INTO states VALUES (NULL, 'Missouri', 'MO');
INSERT INTO states VALUES (NULL, 'Montana', 'MT');
INSERT INTO states VALUES (NULL, 'Nebraska', 'NE');
INSERT INTO states VALUES (NULL, 'Nevada', 'NV');
INSERT INTO states VALUES (NULL, 'New Hampshire', 'NH');
INSERT INTO states VALUES (NULL, 'New Jersey', 'NJ');
INSERT INTO states VALUES (NULL, 'New Mexico', 'NM');
INSERT INTO states VALUES (NULL, 'New York', 'NY');
INSERT INTO states VALUES (NULL, 'North Carolina', 'NC');
INSERT INTO states VALUES (NULL, 'North Dakota', 'ND');
INSERT INTO states VALUES (NULL, 'Northern Mariana Islands', 'MP');
INSERT INTO states VALUES (NULL, 'Ohio', 'OH');
INSERT INTO states VALUES (NULL, 'Oklahoma', 'OK');
INSERT INTO states VALUES (NULL, 'Oregon', 'OR');
INSERT INTO states VALUES (NULL, 'Palau', 'PW');
INSERT INTO states VALUES (NULL, 'Pennsylvania', 'PA');
INSERT INTO states VALUES (NULL, 'Puerto Rico', 'PR');
INSERT INTO states VALUES (NULL, 'Rhode Island', 'RI');
INSERT INTO states VALUES (NULL, 'South Carolina', 'SC');
INSERT INTO states VALUES (NULL, 'South Dakota', 'SD');
INSERT INTO states VALUES (NULL, 'Tennessee', 'TN');
INSERT INTO states VALUES (NULL, 'Texas', 'TX');
INSERT INTO states VALUES (NULL, 'Utah', 'UT');
INSERT INTO states VALUES (NULL, 'Vermont', 'VT');
INSERT INTO states VALUES (NULL, 'Virgin Islands', 'VI');
INSERT INTO states VALUES (NULL, 'Virginia', 'VA');
INSERT INTO states VALUES (NULL, 'Washington', 'WA');
INSERT INTO states VALUES (NULL, 'West Virginia', 'WV');
INSERT INTO states VALUES (NULL, 'Wisconsin', 'WI');
INSERT INTO states VALUES (NULL, 'Wyoming', 'WY');
INSERT INTO states VALUES (NULL, 'Armed Forces Africa', 'AE');
INSERT INTO states VALUES (NULL, 'Armed Forces Americas (except Canada)', 'AA');
INSERT INTO states VALUES (NULL, 'Armed Forces Canada', 'AE');
INSERT INTO states VALUES (NULL, 'Armed Forces Europe', 'AE');
INSERT INTO states VALUES (NULL, 'Armed Forces Middle East', 'AE');
INSERT INTO states VALUES (NULL, 'Armed Forces Pacific', 'AP');

source

Category: Uncategorized | Tags: , , , ,
snippets | April 12, 2012
No comments

MySQL Table – ISO Country List with Abbreviations

# iso_country_list.sql
#
# This will create and then populate a MySQL table with a list of the names and
# ISO 3166 codes for countries in existence as of the date below.
#
# Usage:
#    mysql -u username -ppassword database_name < ./iso_country_list.sql
#
# For updates to this file, see <a href="http://27.org/isocountrylist/" >http://27.org/isocountrylist/</a>
# For more about ISO 3166, see <a href="http://www.iso.ch/iso/en/prods-services/iso3166ma/02iso-3166-code-lists/list-en1.html" >http://www.iso.ch/iso/en/prods-services/iso3166ma/02iso-3166-code-lists/list-en1.html</a>
#
# Created by getisocountrylist.pl on Sun Nov  2 14:59:20 2003.
# Wm. Rhodes <iso_country_list@27.org>
#

CREATE TABLE IF NOT EXISTS country (
iso CHAR(2) NOT NULL PRIMARY KEY,
name VARCHAR(80) NOT NULL,
printable_name VARCHAR(80) NOT NULL,
iso3 CHAR(3),
numcode SMALLINT
);

INSERT INTO country VALUES ('AF','AFGHANISTAN','Afghanistan','AFG','004');
INSERT INTO country VALUES ('AL','ALBANIA','Albania','ALB','008');
INSERT INTO country VALUES ('DZ','ALGERIA','Algeria','DZA','012');
INSERT INTO country VALUES ('AS','AMERICAN SAMOA','American Samoa','ASM','016');
INSERT INTO country VALUES ('AD','ANDORRA','Andorra','AND','020');
INSERT INTO country VALUES ('AO','ANGOLA','Angola','AGO','024');
INSERT INTO country VALUES ('AI','ANGUILLA','Anguilla','AIA','660');
INSERT INTO country VALUES ('AQ','ANTARCTICA','Antarctica',NULL,NULL);
INSERT INTO country VALUES ('AG','ANTIGUA AND BARBUDA','Antigua and Barbuda','ATG','028');
INSERT INTO country VALUES ('AR','ARGENTINA','Argentina','ARG','032');
INSERT INTO country VALUES ('AM','ARMENIA','Armenia','ARM','051');
INSERT INTO country VALUES ('AW','ARUBA','Aruba','ABW','533');
INSERT INTO country VALUES ('AU','AUSTRALIA','Australia','AUS','036');
INSERT INTO country VALUES ('AT','AUSTRIA','Austria','AUT','040');
INSERT INTO country VALUES ('AZ','AZERBAIJAN','Azerbaijan','AZE','031');
INSERT INTO country VALUES ('BS','BAHAMAS','Bahamas','BHS','044');
INSERT INTO country VALUES ('BH','BAHRAIN','Bahrain','BHR','048');
INSERT INTO country VALUES ('BD','BANGLADESH','Bangladesh','BGD','050');
INSERT INTO country VALUES ('BB','BARBADOS','Barbados','BRB','052');
INSERT INTO country VALUES ('BY','BELARUS','Belarus','BLR','112');
INSERT INTO country VALUES ('BE','BELGIUM','Belgium','BEL','056');
INSERT INTO country VALUES ('BZ','BELIZE','Belize','BLZ','084');
INSERT INTO country VALUES ('BJ','BENIN','Benin','BEN','204');
INSERT INTO country VALUES ('BM','BERMUDA','Bermuda','BMU','060');
INSERT INTO country VALUES ('BT','BHUTAN','Bhutan','BTN','064');
INSERT INTO country VALUES ('BO','BOLIVIA','Bolivia','BOL','068');
INSERT INTO country VALUES ('BA','BOSNIA AND HERZEGOVINA','Bosnia and Herzegovina','BIH','070');
INSERT INTO country VALUES ('BW','BOTSWANA','Botswana','BWA','072');
INSERT INTO country VALUES ('BV','BOUVET ISLAND','Bouvet Island',NULL,NULL);
INSERT INTO country VALUES ('BR','BRAZIL','Brazil','BRA','076');
INSERT INTO country VALUES ('IO','BRITISH INDIAN OCEAN TERRITORY','British Indian Ocean Territory',NULL,NULL);
INSERT INTO country VALUES ('BN','BRUNEI DARUSSALAM','Brunei Darussalam','BRN','096');
INSERT INTO country VALUES ('BG','BULGARIA','Bulgaria','BGR','100');
INSERT INTO country VALUES ('BF','BURKINA FASO','Burkina Faso','BFA','854');
INSERT INTO country VALUES ('BI','BURUNDI','Burundi','BDI','108');
INSERT INTO country VALUES ('KH','CAMBODIA','Cambodia','KHM','116');
INSERT INTO country VALUES ('CM','CAMEROON','Cameroon','CMR','120');
INSERT INTO country VALUES ('CA','CANADA','Canada','CAN','124');
INSERT INTO country VALUES ('CV','CAPE VERDE','Cape Verde','CPV','132');
INSERT INTO country VALUES ('KY','CAYMAN ISLANDS','Cayman Islands','CYM','136');
INSERT INTO country VALUES ('CF','CENTRAL AFRICAN REPUBLIC','Central African Republic','CAF','140');
INSERT INTO country VALUES ('TD','CHAD','Chad','TCD','148');
INSERT INTO country VALUES ('CL','CHILE','Chile','CHL','152');
INSERT INTO country VALUES ('CN','CHINA','China','CHN','156');
INSERT INTO country VALUES ('CX','CHRISTMAS ISLAND','Christmas Island',NULL,NULL);
INSERT INTO country VALUES ('CC','COCOS (KEELING) ISLANDS','Cocos (Keeling) Islands',NULL,NULL);
INSERT INTO country VALUES ('CO','COLOMBIA','Colombia','COL','170');
INSERT INTO country VALUES ('KM','COMOROS','Comoros','COM','174');
INSERT INTO country VALUES ('CG','CONGO','Congo','COG','178');
INSERT INTO country VALUES ('CD','CONGO, THE DEMOCRATIC REPUBLIC OF THE','Congo, the Democratic Republic of the','COD','180');
INSERT INTO country VALUES ('CK','COOK ISLANDS','Cook Islands','COK','184');
INSERT INTO country VALUES ('CR','COSTA RICA','Costa Rica','CRI','188');
INSERT INTO country VALUES ('CI','COTE D'IVOIRE','Cote D'Ivoire','CIV','384');
INSERT INTO country VALUES ('HR','CROATIA','Croatia','HRV','191');
INSERT INTO country VALUES ('CU','CUBA','Cuba','CUB','192');
INSERT INTO country VALUES ('CY','CYPRUS','Cyprus','CYP','196');
INSERT INTO country VALUES ('CZ','CZECH REPUBLIC','Czech Republic','CZE','203');
INSERT INTO country VALUES ('DK','DENMARK','Denmark','DNK','208');
INSERT INTO country VALUES ('DJ','DJIBOUTI','Djibouti','DJI','262');
INSERT INTO country VALUES ('DM','DOMINICA','Dominica','DMA','212');
INSERT INTO country VALUES ('DO','DOMINICAN REPUBLIC','Dominican Republic','DOM','214');
INSERT INTO country VALUES ('EC','ECUADOR','Ecuador','ECU','218');
INSERT INTO country VALUES ('EG','EGYPT','Egypt','EGY','818');
INSERT INTO country VALUES ('SV','EL SALVADOR','El Salvador','SLV','222');
INSERT INTO country VALUES ('GQ','EQUATORIAL GUINEA','Equatorial Guinea','GNQ','226');
INSERT INTO country VALUES ('ER','ERITREA','Eritrea','ERI','232');
INSERT INTO country VALUES ('EE','ESTONIA','Estonia','EST','233');
INSERT INTO country VALUES ('ET','ETHIOPIA','Ethiopia','ETH','231');
INSERT INTO country VALUES ('FK','FALKLAND ISLANDS (MALVINAS)','Falkland Islands (Malvinas)','FLK','238');
INSERT INTO country VALUES ('FO','FAROE ISLANDS','Faroe Islands','FRO','234');
INSERT INTO country VALUES ('FJ','FIJI','Fiji','FJI','242');
INSERT INTO country VALUES ('FI','FINLAND','Finland','FIN','246');
INSERT INTO country VALUES ('FR','FRANCE','France','FRA','250');
INSERT INTO country VALUES ('GF','FRENCH GUIANA','French Guiana','GUF','254');
INSERT INTO country VALUES ('PF','FRENCH POLYNESIA','French Polynesia','PYF','258');
INSERT INTO country VALUES ('TF','FRENCH SOUTHERN TERRITORIES','French Southern Territories',NULL,NULL);
INSERT INTO country VALUES ('GA','GABON','Gabon','GAB','266');
INSERT INTO country VALUES ('GM','GAMBIA','Gambia','GMB','270');
INSERT INTO country VALUES ('GE','GEORGIA','Georgia','GEO','268');
INSERT INTO country VALUES ('DE','GERMANY','Germany','DEU','276');
INSERT INTO country VALUES ('GH','GHANA','Ghana','GHA','288');
INSERT INTO country VALUES ('GI','GIBRALTAR','Gibraltar','GIB','292');
INSERT INTO country VALUES ('GR','GREECE','Greece','GRC','300');
INSERT INTO country VALUES ('GL','GREENLAND','Greenland','GRL','304');
INSERT INTO country VALUES ('GD','GRENADA','Grenada','GRD','308');
INSERT INTO country VALUES ('GP','GUADELOUPE','Guadeloupe','GLP','312');
INSERT INTO country VALUES ('GU','GUAM','Guam','GUM','316');
INSERT INTO country VALUES ('GT','GUATEMALA','Guatemala','GTM','320');
INSERT INTO country VALUES ('GN','GUINEA','Guinea','GIN','324');
INSERT INTO country VALUES ('GW','GUINEA-BISSAU','Guinea-Bissau','GNB','624');
INSERT INTO country VALUES ('GY','GUYANA','Guyana','GUY','328');
INSERT INTO country VALUES ('HT','HAITI','Haiti','HTI','332');
INSERT INTO country VALUES ('HM','HEARD ISLAND AND MCDONALD ISLANDS','Heard Island and Mcdonald Islands',NULL,NULL);
INSERT INTO country VALUES ('VA','HOLY SEE (VATICAN CITY STATE)','Holy See (Vatican City State)','VAT','336');
INSERT INTO country VALUES ('HN','HONDURAS','Honduras','HND','340');
INSERT INTO country VALUES ('HK','HONG KONG','Hong Kong','HKG','344');
INSERT INTO country VALUES ('HU','HUNGARY','Hungary','HUN','348');
INSERT INTO country VALUES ('IS','ICELAND','Iceland','ISL','352');
INSERT INTO country VALUES ('IN','INDIA','India','IND','356');
INSERT INTO country VALUES ('ID','INDONESIA','Indonesia','IDN','360');
INSERT INTO country VALUES ('IR','IRAN, ISLAMIC REPUBLIC OF','Iran, Islamic Republic of','IRN','364');
INSERT INTO country VALUES ('IQ','IRAQ','Iraq','IRQ','368');
INSERT INTO country VALUES ('IE','IRELAND','Ireland','IRL','372');
INSERT INTO country VALUES ('IL','ISRAEL','Israel','ISR','376');
INSERT INTO country VALUES ('IT','ITALY','Italy','ITA','380');
INSERT INTO country VALUES ('JM','JAMAICA','Jamaica','JAM','388');
INSERT INTO country VALUES ('JP','JAPAN','Japan','JPN','392');
INSERT INTO country VALUES ('JO','JORDAN','Jordan','JOR','400');
INSERT INTO country VALUES ('KZ','KAZAKHSTAN','Kazakhstan','KAZ','398');
INSERT INTO country VALUES ('KE','KENYA','Kenya','KEN','404');
INSERT INTO country VALUES ('KI','KIRIBATI','Kiribati','KIR','296');
INSERT INTO country VALUES ('KP','KOREA, DEMOCRATIC PEOPLE'S REPUBLIC OF','Korea, Democratic People's Republic of','PRK','408');
INSERT INTO country VALUES ('KR','KOREA, REPUBLIC OF','Korea, Republic of','KOR','410');
INSERT INTO country VALUES ('KW','KUWAIT','Kuwait','KWT','414');
INSERT INTO country VALUES ('KG','KYRGYZSTAN','Kyrgyzstan','KGZ','417');
INSERT INTO country VALUES ('LA','LAO PEOPLE'S DEMOCRATIC REPUBLIC','Lao People's Democratic Republic','LAO','418');
INSERT INTO country VALUES ('LV','LATVIA','Latvia','LVA','428');
INSERT INTO country VALUES ('LB','LEBANON','Lebanon','LBN','422');
INSERT INTO country VALUES ('LS','LESOTHO','Lesotho','LSO','426');
INSERT INTO country VALUES ('LR','LIBERIA','Liberia','LBR','430');
INSERT INTO country VALUES ('LY','LIBYAN ARAB JAMAHIRIYA','Libyan Arab Jamahiriya','LBY','434');
INSERT INTO country VALUES ('LI','LIECHTENSTEIN','Liechtenstein','LIE','438');
INSERT INTO country VALUES ('LT','LITHUANIA','Lithuania','LTU','440');
INSERT INTO country VALUES ('LU','LUXEMBOURG','Luxembourg','LUX','442');
INSERT INTO country VALUES ('MO','MACAO','Macao','MAC','446');
INSERT INTO country VALUES ('MK','MACEDONIA, THE FORMER YUGOSLAV REPUBLIC OF','Macedonia, the Former Yugoslav Republic of','MKD','807');
INSERT INTO country VALUES ('MG','MADAGASCAR','Madagascar','MDG','450');
INSERT INTO country VALUES ('MW','MALAWI','Malawi','MWI','454');
INSERT INTO country VALUES ('MY','MALAYSIA','Malaysia','MYS','458');
INSERT INTO country VALUES ('MV','MALDIVES','Maldives','MDV','462');
INSERT INTO country VALUES ('ML','MALI','Mali','MLI','466');
INSERT INTO country VALUES ('MT','MALTA','Malta','MLT','470');
INSERT INTO country VALUES ('MH','MARSHALL ISLANDS','Marshall Islands','MHL','584');
INSERT INTO country VALUES ('MQ','MARTINIQUE','Martinique','MTQ','474');
INSERT INTO country VALUES ('MR','MAURITANIA','Mauritania','MRT','478');
INSERT INTO country VALUES ('MU','MAURITIUS','Mauritius','MUS','480');
INSERT INTO country VALUES ('YT','MAYOTTE','Mayotte',NULL,NULL);
INSERT INTO country VALUES ('MX','MEXICO','Mexico','MEX','484');
INSERT INTO country VALUES ('FM','MICRONESIA, FEDERATED STATES OF','Micronesia, Federated States of','FSM','583');
INSERT INTO country VALUES ('MD','MOLDOVA, REPUBLIC OF','Moldova, Republic of','MDA','498');
INSERT INTO country VALUES ('MC','MONACO','Monaco','MCO','492');
INSERT INTO country VALUES ('MN','MONGOLIA','Mongolia','MNG','496');
INSERT INTO country VALUES ('MS','MONTSERRAT','Montserrat','MSR','500');
INSERT INTO country VALUES ('MA','MOROCCO','Morocco','MAR','504');
INSERT INTO country VALUES ('MZ','MOZAMBIQUE','Mozambique','MOZ','508');
INSERT INTO country VALUES ('MM','MYANMAR','Myanmar','MMR','104');
INSERT INTO country VALUES ('NA','NAMIBIA','Namibia','NAM','516');
INSERT INTO country VALUES ('NR','NAURU','Nauru','NRU','520');
INSERT INTO country VALUES ('NP','NEPAL','Nepal','NPL','524');
INSERT INTO country VALUES ('NL','NETHERLANDS','Netherlands','NLD','528');
INSERT INTO country VALUES ('AN','NETHERLANDS ANTILLES','Netherlands Antilles','ANT','530');
INSERT INTO country VALUES ('NC','NEW CALEDONIA','New Caledonia','NCL','540');
INSERT INTO country VALUES ('NZ','NEW ZEALAND','New Zealand','NZL','554');
INSERT INTO country VALUES ('NI','NICARAGUA','Nicaragua','NIC','558');
INSERT INTO country VALUES ('NE','NIGER','Niger','NER','562');
INSERT INTO country VALUES ('NG','NIGERIA','Nigeria','NGA','566');
INSERT INTO country VALUES ('NU','NIUE','Niue','NIU','570');
INSERT INTO country VALUES ('NF','NORFOLK ISLAND','Norfolk Island','NFK','574');
INSERT INTO country VALUES ('MP','NORTHERN MARIANA ISLANDS','Northern Mariana Islands','MNP','580');
INSERT INTO country VALUES ('NO','NORWAY','Norway','NOR','578');
INSERT INTO country VALUES ('OM','OMAN','Oman','OMN','512');
INSERT INTO country VALUES ('PK','PAKISTAN','Pakistan','PAK','586');
INSERT INTO country VALUES ('PW','PALAU','Palau','PLW','585');
INSERT INTO country VALUES ('PS','PALESTINIAN TERRITORY, OCCUPIED','Palestinian Territory, Occupied',NULL,NULL);
INSERT INTO country VALUES ('PA','PANAMA','Panama','PAN','591');
INSERT INTO country VALUES ('PG','PAPUA NEW GUINEA','Papua New Guinea','PNG','598');
INSERT INTO country VALUES ('PY','PARAGUAY','Paraguay','PRY','600');
INSERT INTO country VALUES ('PE','PERU','Peru','PER','604');
INSERT INTO country VALUES ('PH','PHILIPPINES','Philippines','PHL','608');
INSERT INTO country VALUES ('PN','PITCAIRN','Pitcairn','PCN','612');
INSERT INTO country VALUES ('PL','POLAND','Poland','POL','616');
INSERT INTO country VALUES ('PT','PORTUGAL','Portugal','PRT','620');
INSERT INTO country VALUES ('PR','PUERTO RICO','Puerto Rico','PRI','630');
INSERT INTO country VALUES ('QA','QATAR','Qatar','QAT','634');
INSERT INTO country VALUES ('RE','REUNION','Reunion','REU','638');
INSERT INTO country VALUES ('RO','ROMANIA','Romania','ROM','642');
INSERT INTO country VALUES ('RU','RUSSIAN FEDERATION','Russian Federation','RUS','643');
INSERT INTO country VALUES ('RW','RWANDA','Rwanda','RWA','646');
INSERT INTO country VALUES ('SH','SAINT HELENA','Saint Helena','SHN','654');
INSERT INTO country VALUES ('KN','SAINT KITTS AND NEVIS','Saint Kitts and Nevis','KNA','659');
INSERT INTO country VALUES ('LC','SAINT LUCIA','Saint Lucia','LCA','662');
INSERT INTO country VALUES ('PM','SAINT PIERRE AND MIQUELON','Saint Pierre and Miquelon','SPM','666');
INSERT INTO country VALUES ('VC','SAINT VINCENT AND THE GRENADINES','Saint Vincent and the Grenadines','VCT','670');
INSERT INTO country VALUES ('WS','SAMOA','Samoa','WSM','882');
INSERT INTO country VALUES ('SM','SAN MARINO','San Marino','SMR','674');
INSERT INTO country VALUES ('ST','SAO TOME AND PRINCIPE','Sao Tome and Principe','STP','678');
INSERT INTO country VALUES ('SA','SAUDI ARABIA','Saudi Arabia','SAU','682');
INSERT INTO country VALUES ('SN','SENEGAL','Senegal','SEN','686');
INSERT INTO country VALUES ('CS','SERBIA AND MONTENEGRO','Serbia and Montenegro',NULL,NULL);
INSERT INTO country VALUES ('SC','SEYCHELLES','Seychelles','SYC','690');
INSERT INTO country VALUES ('SL','SIERRA LEONE','Sierra Leone','SLE','694');
INSERT INTO country VALUES ('SG','SINGAPORE','Singapore','SGP','702');
INSERT INTO country VALUES ('SK','SLOVAKIA','Slovakia','SVK','703');
INSERT INTO country VALUES ('SI','SLOVENIA','Slovenia','SVN','705');
INSERT INTO country VALUES ('SB','SOLOMON ISLANDS','Solomon Islands','SLB','090');
INSERT INTO country VALUES ('SO','SOMALIA','Somalia','SOM','706');
INSERT INTO country VALUES ('ZA','SOUTH AFRICA','South Africa','ZAF','710');
INSERT INTO country VALUES ('GS','SOUTH GEORGIA AND THE SOUTH SANDWICH ISLANDS','South Georgia and the South Sandwich Islands',NULL,NULL);
INSERT INTO country VALUES ('ES','SPAIN','Spain','ESP','724');
INSERT INTO country VALUES ('LK','SRI LANKA','Sri Lanka','LKA','144');
INSERT INTO country VALUES ('SD','SUDAN','Sudan','SDN','736');
INSERT INTO country VALUES ('SR','SURINAME','Suriname','SUR','740');
INSERT INTO country VALUES ('SJ','SVALBARD AND JAN MAYEN','Svalbard and Jan Mayen','SJM','744');
INSERT INTO country VALUES ('SZ','SWAZILAND','Swaziland','SWZ','748');
INSERT INTO country VALUES ('SE','SWEDEN','Sweden','SWE','752');
INSERT INTO country VALUES ('CH','SWITZERLAND','Switzerland','CHE','756');
INSERT INTO country VALUES ('SY','SYRIAN ARAB REPUBLIC','Syrian Arab Republic','SYR','760');
INSERT INTO country VALUES ('TW','TAIWAN, PROVINCE OF CHINA','Taiwan, Province of China','TWN','158');
INSERT INTO country VALUES ('TJ','TAJIKISTAN','Tajikistan','TJK','762');
INSERT INTO country VALUES ('TZ','TANZANIA, UNITED REPUBLIC OF','Tanzania, United Republic of','TZA','834');
INSERT INTO country VALUES ('TH','THAILAND','Thailand','THA','764');
INSERT INTO country VALUES ('TL','TIMOR-LESTE','Timor-Leste',NULL,NULL);
INSERT INTO country VALUES ('TG','TOGO','Togo','TGO','768');
INSERT INTO country VALUES ('TK','TOKELAU','Tokelau','TKL','772');
INSERT INTO country VALUES ('TO','TONGA','Tonga','TON','776');
INSERT INTO country VALUES ('TT','TRINIDAD AND TOBAGO','Trinidad and Tobago','TTO','780');
INSERT INTO country VALUES ('TN','TUNISIA','Tunisia','TUN','788');
INSERT INTO country VALUES ('TR','TURKEY','Turkey','TUR','792');
INSERT INTO country VALUES ('TM','TURKMENISTAN','Turkmenistan','TKM','795');
INSERT INTO country VALUES ('TC','TURKS AND CAICOS ISLANDS','Turks and Caicos Islands','TCA','796');
INSERT INTO country VALUES ('TV','TUVALU','Tuvalu','TUV','798');
INSERT INTO country VALUES ('UG','UGANDA','Uganda','UGA','800');
INSERT INTO country VALUES ('UA','UKRAINE','Ukraine','UKR','804');
INSERT INTO country VALUES ('AE','UNITED ARAB EMIRATES','United Arab Emirates','ARE','784');
INSERT INTO country VALUES ('GB','UNITED KINGDOM','United Kingdom','GBR','826');
INSERT INTO country VALUES ('US','UNITED STATES','United States','USA','840');
INSERT INTO country VALUES ('UM','UNITED STATES MINOR OUTLYING ISLANDS','United States Minor Outlying Islands',NULL,NULL);
INSERT INTO country VALUES ('UY','URUGUAY','Uruguay','URY','858');
INSERT INTO country VALUES ('UZ','UZBEKISTAN','Uzbekistan','UZB','860');
INSERT INTO country VALUES ('VU','VANUATU','Vanuatu','VUT','548');
INSERT INTO country VALUES ('VE','VENEZUELA','Venezuela','VEN','862');
INSERT INTO country VALUES ('VN','VIET NAM','Viet Nam','VNM','704');
INSERT INTO country VALUES ('VG','VIRGIN ISLANDS, BRITISH','Virgin Islands, British','VGB','092');
INSERT INTO country VALUES ('VI','VIRGIN ISLANDS, U.S.','Virgin Islands, U.s.','VIR','850');
INSERT INTO country VALUES ('WF','WALLIS AND FUTUNA','Wallis and Futuna','WLF','876');
INSERT INTO country VALUES ('EH','WESTERN SAHARA','Western Sahara','ESH','732');
INSERT INTO country VALUES ('YE','YEMEN','Yemen','YEM','887');
INSERT INTO country VALUES ('ZM','ZAMBIA','Zambia','ZMB','894');
INSERT INTO country VALUES ('ZW','ZIMBABWE','Zimbabwe','ZWE','716');

source

Category: Uncategorized | Tags: , , , ,
snippets | March 9, 2012
No comments

Alternate row colors

'************************************************
'
' To use it put the code like this on your loop:
'
' <%counter = counter + 1%>
' <tr bgcolor="<%=Acolor(counter,"#a0a0a0","#e0e0e0")%>">
'    <td>Data</td>
' </tr>
'
' n        is the external counter
' col      is the first color in hex format
' col2     is the second color in hex format, you can leave it empty
'************************************************

function Acolor(n,col,col2)

num = 0
num = n mod 2

if col2 = "" then col2 = "#ffffff"

if num = 0 then
Acolor = col
else
Acolor = col2
end if

end function

source

Category: Uncategorized | Tags: , , , , ,
snippets | March 5, 2012
No comments

MooTools alternate table row colors

.shade-table	{ /* just to remind us we're using this -- we don't want to write over it later! */ }
.odd		{ background:#ccc; padding:3px; }
.even		{ background:#eee; padding:3px; }

window.addEvent('domready', function() {
var count = 0;
$$('table.shade-table tr').each(function(el) {
el.addClass(count++ % 2 == 0 ? 'odd' : 'even');
});
});

<table class="shade-table" border="1" cellpadding="5" cellspacing="2"><tbody>
<tr>
<td>1</td>
<td>1</td>
<td>1</td>
<td>1</td>
</tr>
<tr>
<td>2</td>
<td>2</td>
<td>2</td>
<td>2</td>
</tr>
<tr>
<td>3</td>
<td>3</td>
<td>3</td>
<td>3</td>
</tr>
<tr>
<td>4</td>
<td>4</td>
<td>4</td>
<td>4</td>
</tr>
<tr>
<td>5</td>
<td>5</td>
<td>5</td>
<td>5</td>
</tr>
</tbody></table>

source

Category: Uncategorized | Tags: , , ,
snippets | February 27, 2012
No comments

Simple hash table (associate array) in JavaScript

var Class = {
create: function() {
return function() {
this.initialize.apply(this, arguments);
}
}
}

var AArray = Class.create();

AArray.prototype = {
AA: {},
initialize: function() {
args = this.initialize.arguments;
if(args.length > 0) {
this.add(args[0], args[1]);
}
},
add: function(key, value) { this.AA[key] = value; },
num: function() { return this.AA.length; },
get: function(key) { return this.AA[key]; },
set: function(key, value) { this.add(key, value); },
test: function() {
var aa = '';
var num = this.num();
for(key in this.AA) aa += '[' + key + ']: ' + this.AA[key] + "
";
alert(aa);
}
}

source

Category: Uncategorized | Tags: , , , ,
snippets | February 27, 2012
No comments

Table Collection

class Table {

def colNames = []
def rowNames = []
def cells = [:]
def topLeft = ''

def addCol(colName) {
if (!(colName in colNames)) colNames << colName
}

def addRow(rowName) {
if (!(rowName in rowNames)) rowNames << rowName
}

def get(rowName, colName) {
cells.get( computeKey(rowName, colName) )
}

def put(rowName, colName, value) {
if (!(rowName in rowNames)) rowNames << rowName
if (!(colName in colNames)) colNames << colName
def endValue = value
if (value instanceof Closure) {
endValue = value.call(get(rowName, colName))
}
cells.put(computeKey(rowName, colName), endValue)
}

def fill(value) {
rowNames.each{rowName ->
colNames.each{colName -> put(rowName, colName, value)}
}
}

def fillIfNull(value) {
rowNames.each{rowName ->
colNames.each{colName -> put(rowName, colName){ it ?: value } }
}
}

def getRowCount() {
rowNames.size()
}

def getColCount() {
colNames.size()
}

def toListOfLists(withRowNames=true, withColNames=true) {
def result = withColNames ? [[topLeft, *colNames]] : []
rowNames.each{rowName ->
def row = withRowNames ? [rowName] : []
colNames.each{colName ->
row << get(rowName, colName)
}
result << row
}
result
}

def each(Closure closure) {
rowNames.each{rowName ->
colNames.each{colName ->
closure.call(rowName, colName, get(rowName, colName))
}
}
}

private computeKey(rowName, colName) {
[rowName, colName]
}

}

class TableTests extends GroovyTestCase {

def table = new Table(colNames: ['c1', 'c2'], rowNames: ['r1', 'r2'])

void testHasNullAsDefaultCellValue() {
assertNull table.get('r1', 'c1')
}

void testCountsRows() {
assertEquals 2, table.rowCount
}

void testCountsColumns() {
assertEquals 2, table.colCount
}

void testAddsRow() {
table.addRow('r3')
assertEquals 3, table.rowCount
}

void testAddsColumn() {
table.addCol('c3')
assertEquals 3, table.colCount
}

void testHasUniqueColumnNames() {
table.addCol('c1')
assertEquals(['c1', 'c2'], table.colNames)
}

void testHasUniqueRowNames() {
table.addRow('r1')
assertEquals(['r1', 'r2'], table.rowNames)
}

void testAddsColumnOnDemand() {
table.put('r1', 'c3', '')
assertEquals(['c1', 'c2', 'c3'], table.colNames)
}

void testAddsRowOnDemand() {
table.put('r3', 'c1', '')
assertEquals(['r1', 'r2', 'r3'], table.rowNames)
}

void testHasNullDefaultValueInCells() {
assertNull table.get('r1', 'c1')
}

void testPutsValueInCell() {
table.put('r1', 'c1', 'value')
assertEquals 'value', table.get('r1', 'c1')
}

void testPutsClosureResultInCell() {
table.put('r1', 'c1', 'value')
table.put('r1', 'c1'){ it + '2'}
assertEquals 'value2', table.get('r1', 'c1')
}

void testFillsCells() {
table.fill(1)
assertEquals( [[1, 1], [1, 1]], table.toListOfLists(false, false) )
}

void testFillsNullCells() {
table.put('r1', 'c1', 2)
table.fillIfNull(1)
assertEquals( [[2, 1], [1, 1]], table.toListOfLists(false, false) )
}

void testConvertsContentToListOfLists() {
table.put('r1', 'c1', 'r1c1')
table.put('r1', 'c2', 'r1c2')
table.put('r2', 'c1', 'r2c1')
table.put('r2', 'c2', 'r2c2')
table.topLeft = 'x'
assertEquals( [['x', 'c1', 'c2'], ['r1', 'r1c1', 'r1c2'], ['r2', 'r2c1', 'r2c2']], table.toListOfLists() )
}

void testIteratesOverCells() {
table.fill(1)
def result = []
table.each{rowName, colName, value -> result << [rowName, colName, value]}
assertEquals( [['r1', 'c1', 1], ['r1', 'c2', 1], ['r2', 'c1', 1], ['r2', 'c2', 1]], result)
}

}

source

Category: Uncategorized | Tags: , ,
snippets | February 18, 2012
No comments

Table Management Class

class $1 extends db {
// SQL Table: ${2:tbl_$1}
// Columns: id,$3

function $1 (){

}

public function get$1(){
db::connect();
$query = "SELECT id,$3 FROM $2";
$result = mysql_query($query);

return $result;
}

public function get$1instance($id){
db::connect();
$query = "SELECT id,$3 FROM $2 WHERE id=" . $id;
$result = mysql_query($query);

return $result;
}

public function insert$1($$1details){
db::connect();
$query = "INSERT INTO $2 ($3) VALUES ('"
$$1details[$4] . "'" . $0
")";

mysql_query($query);

return mysql_insert_id();
}

public function delete$1($id){
db::connect();
$query = "DELETE FROM $2 WHERE id = " . $id;

mysql_query($query);

return $id;
}

public function update$1($id,$$1details){
db::connect();
$query = "UPDATE $2 SET
$4 = '" . $$1details[$4] . "'
WHERE id = " . $id;

mysql_query($query);

return $id;
}
}

source

Category: Uncategorized | Tags: , , , , , , ,
« Older Entries