45 liens privés
Thanks !
Here for Oracle SQL :
create table continents (
code varchar2(2) not null,
name varchar2(255),
primary key (code)
);
set scan off;
insert into continents values ('AF', 'Africa');
insert into continents values ('AS', 'Asia');
insert into continents values ('EU', 'Europe');
insert into continents values ('NA', 'North America');
insert into continents values ('SA', 'South America');
insert into continents values ('OC', 'Oceania');
insert into continents values ('AN', 'Antarctica');
commit;
create table countries (
code varchar2(2) not null,
name varchar2(255) not null,
full_name varchar2(255) not null,
iso3 varchar2(3) not null,
nbr varchar2(3),
continent_code varchar2(2),
primary key (code),
foreign key(continent_code) references continents(code)
);
set scan off;
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('AF', 'AS', 'Afghanistan', 'AFG', '004', 'Islamic Republic of Afghanistan');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('AX', 'EU', 'Åland Islands', 'ALA', '248', 'Åland Islands');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('AL', 'EU', 'Albania', 'ALB', '008', 'Republic of Albania');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('DZ', 'AF', 'Algeria', 'DZA', '012', 'People''s Democratic Republic of Algeria');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('AS', 'OC', 'American Samoa', 'ASM', '016', 'American Samoa');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('AD', 'EU', 'Andorra', 'AND', '020', 'Principality of Andorra');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('AO', 'AF', 'Angola', 'AGO', '024', 'Republic of Angola');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('AI', 'NA', 'Anguilla', 'AIA', '660', 'Anguilla');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('AQ', 'AN', 'Antarctica', 'ATA', '010', 'Antarctica (the territory South of 60 deg S)');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('AG', 'NA', 'Antigua and Barbuda', 'ATG', '028', 'Antigua and Barbuda');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('AR', 'SA', 'Argentina', 'ARG', '032', 'Argentine Republic');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('AM', 'AS', 'Armenia', 'ARM', '051', 'Republic of Armenia');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('AW', 'NA', 'Aruba', 'ABW', '533', 'Aruba');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('AU', 'OC', 'Australia', 'AUS', '036', 'Commonwealth of Australia');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('AT', 'EU', 'Austria', 'AUT', '040', 'Republic of Austria');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('AZ', 'AS', 'Azerbaijan', 'AZE', '031', 'Republic of Azerbaijan');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('BS', 'NA', 'Bahamas', 'BHS', '044', 'Commonwealth of the Bahamas');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('BH', 'AS', 'Bahrain', 'BHR', '048', 'Kingdom of Bahrain');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('BD', 'AS', 'Bangladesh', 'BGD', '050', 'People''s Republic of Bangladesh');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('BB', 'NA', 'Barbados', 'BRB', '052', 'Barbados');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('BY', 'EU', 'Belarus', 'BLR', '112', 'Republic of Belarus');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('BE', 'EU', 'Belgium', 'BEL', '056', 'Kingdom of Belgium');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('BZ', 'NA', 'Belize', 'BLZ', '084', 'Belize');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('BJ', 'AF', 'Benin', 'BEN', '204', 'Republic of Benin');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('BM', 'NA', 'Bermuda', 'BMU', '060', 'Bermuda');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('BT', 'AS', 'Bhutan', 'BTN', '064', 'Kingdom of Bhutan');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('BO', 'SA', 'Bolivia', 'BOL', '068', 'Plurinational State of Bolivia');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('BQ', 'NA', 'Bonaire, Sint Eustatius and Saba', 'BES', '535', 'Bonaire, Sint Eustatius and Saba');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('BA', 'EU', 'Bosnia and Herzegovina', 'BIH', '070', 'Bosnia and Herzegovina');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('BW', 'AF', 'Botswana', 'BWA', '072', 'Republic of Botswana');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('BV', 'AN', 'Bouvet Island (Bouvetøya)', 'BVT', '074', 'Bouvet Island (Bouvetøya)');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('BR', 'SA', 'Brazil', 'BRA', '076', 'Federative Republic of Brazil');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('IO', 'AS', 'British Indian Ocean Territory (Chagos Archipelago)', 'IOT', '086', 'British Indian Ocean Territory (Chagos Archipelago)');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('VG', 'NA', 'British Virgin Islands', 'VGB', '092', 'British Virgin Islands');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('BN', 'AS', 'Brunei Darussalam', 'BRN', '096', 'Brunei Darussalam');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('BG', 'EU', 'Bulgaria', 'BGR', '100', 'Republic of Bulgaria');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('BF', 'AF', 'Burkina Faso', 'BFA', '854', 'Burkina Faso');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('BI', 'AF', 'Burundi', 'BDI', '108', 'Republic of Burundi');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('KH', 'AS', 'Cambodia', 'KHM', '116', 'Kingdom of Cambodia');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('CM', 'AF', 'Cameroon', 'CMR', '120', 'Republic of Cameroon');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('CA', 'NA', 'Canada', 'CAN', '124', 'Canada');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('CV', 'AF', 'Cabo Verde', 'CPV', '132', 'Republic of Cabo Verde');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('KY', 'NA', 'Cayman Islands', 'CYM', '136', 'Cayman Islands');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('CF', 'AF', 'Central African Republic', 'CAF', '140', 'Central African Republic');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('TD', 'AF', 'Chad', 'TCD', '148', 'Republic of Chad');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('CL', 'SA', 'Chile', 'CHL', '152', 'Republic of Chile');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('CN', 'AS', 'China', 'CHN', '156', 'People''s Republic of China');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('CX', 'AS', 'Christmas Island', 'CXR', '162', 'Christmas Island');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('CC', 'AS', 'Cocos (Keeling) Islands', 'CCK', '166', 'Cocos (Keeling) Islands');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('CO', 'SA', 'Colombia', 'COL', '170', 'Republic of Colombia');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('KM', 'AF', 'Comoros', 'COM', '174', 'Union of the Comoros');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('CD', 'AF', 'Congo', 'COD', '180', 'Democratic Republic of the Congo');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('CG', 'AF', 'Congo', 'COG', '178', 'Republic of the Congo');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('CK', 'OC', 'Cook Islands', 'COK', '184', 'Cook Islands');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('CR', 'NA', 'Costa Rica', 'CRI', '188', 'Republic of Costa Rica');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('CI', 'AF', 'Cote d''Ivoire', 'CIV', '384', 'Republic of Cote d''Ivoire');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('HR', 'EU', 'Croatia', 'HRV', '191', 'Republic of Croatia');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('CU', 'NA', 'Cuba', 'CUB', '192', 'Republic of Cuba');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('CW', 'NA', 'Curaçao', 'CUW', '531', 'Curaçao');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('CY', 'AS', 'Cyprus', 'CYP', '196', 'Republic of Cyprus');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('CZ', 'EU', 'Czechia', 'CZE', '203', 'Czech Republic');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('DK', 'EU', 'Denmark', 'DNK', '208', 'Kingdom of Denmark');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('DJ', 'AF', 'Djibouti', 'DJI', '262', 'Republic of Djibouti');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('DM', 'NA', 'Dominica', 'DMA', '212', 'Commonwealth of Dominica');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('DO', 'NA', 'Dominican Republic', 'DOM', '214', 'Dominican Republic');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('EC', 'SA', 'Ecuador', 'ECU', '218', 'Republic of Ecuador');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('EG', 'AF', 'Egypt', 'EGY', '818', 'Arab Republic of Egypt');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('SV', 'NA', 'El Salvador', 'SLV', '222', 'Republic of El Salvador');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('GQ', 'AF', 'Equatorial Guinea', 'GNQ', '226', 'Republic of Equatorial Guinea');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('ER', 'AF', 'Eritrea', 'ERI', '232', 'State of Eritrea');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('EE', 'EU', 'Estonia', 'EST', '233', 'Republic of Estonia');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('ET', 'AF', 'Ethiopia', 'ETH', '231', 'Federal Democratic Republic of Ethiopia');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('FO', 'EU', 'Faroe Islands', 'FRO', '234', 'Faroe Islands');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('FK', 'SA', 'Falkland Islands (Malvinas)', 'FLK', '238', 'Falkland Islands (Malvinas)');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('FJ', 'OC', 'Fiji', 'FJI', '242', 'Republic of Fiji');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('FI', 'EU', 'Finland', 'FIN', '246', 'Republic of Finland');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('FR', 'EU', 'France', 'FRA', '250', 'French Republic');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('GF', 'SA', 'French Guiana', 'GUF', '254', 'French Guiana');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('PF', 'OC', 'French Polynesia', 'PYF', '258', 'French Polynesia');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('TF', 'AN', 'French Southern Territories', 'ATF', '260', 'French Southern Territories');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('GA', 'AF', 'Gabon', 'GAB', '266', 'Gabonese Republic');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('GM', 'AF', 'Gambia', 'GMB', '270', 'Republic of the Gambia');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('GE', 'AS', 'Georgia', 'GEO', '268', 'Georgia');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('DE', 'EU', 'Germany', 'DEU', '276', 'Federal Republic of Germany');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('GH', 'AF', 'Ghana', 'GHA', '288', 'Republic of Ghana');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('GI', 'EU', 'Gibraltar', 'GIB', '292', 'Gibraltar');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('GR', 'EU', 'Greece', 'GRC', '300', 'Hellenic Republic of Greece');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('GL', 'NA', 'Greenland', 'GRL', '304', 'Greenland');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('GD', 'NA', 'Grenada', 'GRD', '308', 'Grenada');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('GP', 'NA', 'Guadeloupe', 'GLP', '312', 'Guadeloupe');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('GU', 'OC', 'Guam', 'GUM', '316', 'Guam');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('GT', 'NA', 'Guatemala', 'GTM', '320', 'Republic of Guatemala');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('GG', 'EU', 'Guernsey', 'GGY', '831', 'Bailiwick of Guernsey');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('GN', 'AF', 'Guinea', 'GIN', '324', 'Republic of Guinea');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('GW', 'AF', 'Guinea-Bissau', 'GNB', '624', 'Republic of Guinea-Bissau');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('GY', 'SA', 'Guyana', 'GUY', '328', 'Co-operative Republic of Guyana');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('HT', 'NA', 'Haiti', 'HTI', '332', 'Republic of Haiti');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('HM', 'AN', 'Heard Island and McDonald Islands', 'HMD', '334', 'Heard Island and McDonald Islands');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('VA', 'EU', 'Holy See (Vatican City State)', 'VAT', '336', 'Holy See (Vatican City State)');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('HN', 'NA', 'Honduras', 'HND', '340', 'Republic of Honduras');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('HK', 'AS', 'Hong Kong', 'HKG', '344', 'Hong Kong Special Administrative Region of China');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('HU', 'EU', 'Hungary', 'HUN', '348', 'Hungary');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('IS', 'EU', 'Iceland', 'ISL', '352', 'Iceland');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('IN', 'AS', 'India', 'IND', '356', 'Republic of India');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('ID', 'AS', 'Indonesia', 'IDN', '360', 'Republic of Indonesia');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('IR', 'AS', 'Iran', 'IRN', '364', 'Islamic Republic of Iran');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('IQ', 'AS', 'Iraq', 'IRQ', '368', 'Republic of Iraq');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('IE', 'EU', 'Ireland', 'IRL', '372', 'Ireland');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('IM', 'EU', 'Isle of Man', 'IMN', '833', 'Isle of Man');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('IL', 'AS', 'Israel', 'ISR', '376', 'State of Israel');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('IT', 'EU', 'Italy', 'ITA', '380', 'Republic of Italy');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('JM', 'NA', 'Jamaica', 'JAM', '388', 'Jamaica');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('JP', 'AS', 'Japan', 'JPN', '392', 'Japan');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('JE', 'EU', 'Jersey', 'JEY', '832', 'Bailiwick of Jersey');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('JO', 'AS', 'Jordan', 'JOR', '400', 'Hashemite Kingdom of Jordan');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('KZ', 'AS', 'Kazakhstan', 'KAZ', '398', 'Republic of Kazakhstan');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('KE', 'AF', 'Kenya', 'KEN', '404', 'Republic of Kenya');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('KI', 'OC', 'Kiribati', 'KIR', '296', 'Republic of Kiribati');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('KP', 'AS', 'Korea', 'PRK', '408', 'Democratic People''s Republic of Korea');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('KR', 'AS', 'Korea', 'KOR', '410', 'Republic of Korea');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('KW', 'AS', 'Kuwait', 'KWT', '414', 'State of Kuwait');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('KG', 'AS', 'Kyrgyz Republic', 'KGZ', '417', 'Kyrgyz Republic');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('LA', 'AS', 'Lao People''s Democratic Republic', 'LAO', '418', 'Lao People''s Democratic Republic');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('LV', 'EU', 'Latvia', 'LVA', '428', 'Republic of Latvia');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('LB', 'AS', 'Lebanon', 'LBN', '422', 'Lebanese Republic');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('LS', 'AF', 'Lesotho', 'LSO', '426', 'Kingdom of Lesotho');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('LR', 'AF', 'Liberia', 'LBR', '430', 'Republic of Liberia');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('LY', 'AF', 'Libya', 'LBY', '434', 'State of Libya');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('LI', 'EU', 'Liechtenstein', 'LIE', '438', 'Principality of Liechtenstein');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('LT', 'EU', 'Lithuania', 'LTU', '440', 'Republic of Lithuania');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('LU', 'EU', 'Luxembourg', 'LUX', '442', 'Grand Duchy of Luxembourg');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('MO', 'AS', 'Macao', 'MAC', '446', 'Macao Special Administrative Region of China');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('MG', 'AF', 'Madagascar', 'MDG', '450', 'Republic of Madagascar');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('MW', 'AF', 'Malawi', 'MWI', '454', 'Republic of Malawi');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('MY', 'AS', 'Malaysia', 'MYS', '458', 'Malaysia');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('MV', 'AS', 'Maldives', 'MDV', '462', 'Republic of Maldives');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('ML', 'AF', 'Mali', 'MLI', '466', 'Republic of Mali');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('MT', 'EU', 'Malta', 'MLT', '470', 'Republic of Malta');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('MH', 'OC', 'Marshall Islands', 'MHL', '584', 'Republic of the Marshall Islands');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('MQ', 'NA', 'Martinique', 'MTQ', '474', 'Martinique');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('MR', 'AF', 'Mauritania', 'MRT', '478', 'Islamic Republic of Mauritania');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('MU', 'AF', 'Mauritius', 'MUS', '480', 'Republic of Mauritius');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('YT', 'AF', 'Mayotte', 'MYT', '175', 'Mayotte');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('MX', 'NA', 'Mexico', 'MEX', '484', 'United Mexican States');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('FM', 'OC', 'Micronesia', 'FSM', '583', 'Federated States of Micronesia');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('MD', 'EU', 'Moldova', 'MDA', '498', 'Republic of Moldova');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('MC', 'EU', 'Monaco', 'MCO', '492', 'Principality of Monaco');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('MN', 'AS', 'Mongolia', 'MNG', '496', 'Mongolia');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('ME', 'EU', 'Montenegro', 'MNE', '499', 'Montenegro');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('MS', 'NA', 'Montserrat', 'MSR', '500', 'Montserrat');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('MA', 'AF', 'Morocco', 'MAR', '504', 'Kingdom of Morocco');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('MZ', 'AF', 'Mozambique', 'MOZ', '508', 'Republic of Mozambique');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('MM', 'AS', 'Myanmar', 'MMR', '104', 'Republic of the Union of Myanmar');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('NA', 'AF', 'Namibia', 'NAM', '516', 'Republic of Namibia');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('NR', 'OC', 'Nauru', 'NRU', '520', 'Republic of Nauru');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('NP', 'AS', 'Nepal', 'NPL', '524', 'Nepal');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('NL', 'EU', 'Netherlands', 'NLD', '528', 'Kingdom of the Netherlands');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('NC', 'OC', 'New Caledonia', 'NCL', '540', 'New Caledonia');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('NZ', 'OC', 'New Zealand', 'NZL', '554', 'New Zealand');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('NI', 'NA', 'Nicaragua', 'NIC', '558', 'Republic of Nicaragua');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('NE', 'AF', 'Niger', 'NER', '562', 'Republic of Niger');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('NG', 'AF', 'Nigeria', 'NGA', '566', 'Federal Republic of Nigeria');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('NU', 'OC', 'Niue', 'NIU', '570', 'Niue');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('NF', 'OC', 'Norfolk Island', 'NFK', '574', 'Norfolk Island');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('MK', 'EU', 'North Macedonia', 'MKD', '807', 'Republic of North Macedonia');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('MP', 'OC', 'Northern Mariana Islands', 'MNP', '580', 'Commonwealth of the Northern Mariana Islands');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('NO', 'EU', 'Norway', 'NOR', '578', 'Kingdom of Norway');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('OM', 'AS', 'Oman', 'OMN', '512', 'Sultanate of Oman');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('PK', 'AS', 'Pakistan', 'PAK', '586', 'Islamic Republic of Pakistan');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('PW', 'OC', 'Palau', 'PLW', '585', 'Republic of Palau');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('PS', 'AS', 'Palestine', 'PSE', '275', 'State of Palestine');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('PA', 'NA', 'Panama', 'PAN', '591', 'Republic of Panama');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('PG', 'OC', 'Papua New Guinea', 'PNG', '598', 'Independent State of Papua New Guinea');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('PY', 'SA', 'Paraguay', 'PRY', '600', 'Republic of Paraguay');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('PE', 'SA', 'Peru', 'PER', '604', 'Republic of Peru');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('PH', 'AS', 'Philippines', 'PHL', '608', 'Republic of the Philippines');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('PN', 'OC', 'Pitcairn Islands', 'PCN', '612', 'Pitcairn Islands');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('PL', 'EU', 'Poland', 'POL', '616', 'Republic of Poland');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('PT', 'EU', 'Portugal', 'PRT', '620', 'Portuguese Republic');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('PR', 'NA', 'Puerto Rico', 'PRI', '630', 'Commonwealth of Puerto Rico');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('QA', 'AS', 'Qatar', 'QAT', '634', 'State of Qatar');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('RE', 'AF', 'Réunion', 'REU', '638', 'Réunion');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('RO', 'EU', 'Romania', 'ROU', '642', 'Romania');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('RU', 'EU', 'Russian Federation', 'RUS', '643', 'Russian Federation');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('RW', 'AF', 'Rwanda', 'RWA', '646', 'Republic of Rwanda');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('BL', 'NA', 'Saint Barthélemy', 'BLM', '652', 'Saint Barthélemy');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('SH', 'AF', 'Saint Helena, Ascension and Tristan da Cunha', 'SHN', '654', 'Saint Helena, Ascension and Tristan da Cunha');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('KN', 'NA', 'Saint Kitts and Nevis', 'KNA', '659', 'Federation of Saint Kitts and Nevis');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('LC', 'NA', 'Saint Lucia', 'LCA', '662', 'Saint Lucia');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('MF', 'NA', 'Saint Martin', 'MAF', '663', 'Saint Martin (French part)');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('PM', 'NA', 'Saint Pierre and Miquelon', 'SPM', '666', 'Saint Pierre and Miquelon');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('VC', 'NA', 'Saint Vincent and the Grenadines', 'VCT', '670', 'Saint Vincent and the Grenadines');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('WS', 'OC', 'Samoa', 'WSM', '882', 'Independent State of Samoa');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('SM', 'EU', 'San Marino', 'SMR', '674', 'Republic of San Marino');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('ST', 'AF', 'Sao Tome and Principe', 'STP', '678', 'Democratic Republic of Sao Tome and Principe');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('SA', 'AS', 'Saudi Arabia', 'SAU', '682', 'Kingdom of Saudi Arabia');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('SN', 'AF', 'Senegal', 'SEN', '686', 'Republic of Senegal');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('RS', 'EU', 'Serbia', 'SRB', '688', 'Republic of Serbia');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('SC', 'AF', 'Seychelles', 'SYC', '690', 'Republic of Seychelles');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('SL', 'AF', 'Sierra Leone', 'SLE', '694', 'Republic of Sierra Leone');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('SG', 'AS', 'Singapore', 'SGP', '702', 'Republic of Singapore');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('SX', 'NA', 'Sint Maarten (Dutch part)', 'SXM', '534', 'Sint Maarten (Dutch part)');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('SK', 'EU', 'Slovakia (Slovak Republic)', 'SVK', '703', 'Slovakia (Slovak Republic)');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('SI', 'EU', 'Slovenia', 'SVN', '705', 'Republic of Slovenia');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('SB', 'OC', 'Solomon Islands', 'SLB', '090', 'Solomon Islands');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('SO', 'AF', 'Somalia', 'SOM', '706', 'Federal Republic of Somalia');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('ZA', 'AF', 'South Africa', 'ZAF', '710', 'Republic of South Africa');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('GS', 'AN', 'South Georgia and the South Sandwich Islands', 'SGS', '239', 'South Georgia and the South Sandwich Islands');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('SS', 'AF', 'South Sudan', 'SSD', '728', 'Republic of South Sudan');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('ES', 'EU', 'Spain', 'ESP', '724', 'Kingdom of Spain');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('LK', 'AS', 'Sri Lanka', 'LKA', '144', 'Democratic Socialist Republic of Sri Lanka');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('SD', 'AF', 'Sudan', 'SDN', '729', 'Republic of Sudan');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('SR', 'SA', 'Suriname', 'SUR', '740', 'Republic of Suriname');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('SJ', 'EU', 'Svalbard & Jan Mayen Islands', 'SJM', '744', 'Svalbard & Jan Mayen Islands');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('SZ', 'AF', 'Eswatini', 'SWZ', '748', 'Kingdom of Eswatini');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('SE', 'EU', 'Sweden', 'SWE', '752', 'Kingdom of Sweden');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('CH', 'EU', 'Switzerland', 'CHE', '756', 'Swiss Confederation');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('SY', 'AS', 'Syrian Arab Republic', 'SYR', '760', 'Syrian Arab Republic');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('TW', 'AS', 'Taiwan', 'TWN', '158', 'Taiwan, Province of China');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('TJ', 'AS', 'Tajikistan', 'TJK', '762', 'Republic of Tajikistan');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('TZ', 'AF', 'Tanzania', 'TZA', '834', 'United Republic of Tanzania');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('TH', 'AS', 'Thailand', 'THA', '764', 'Kingdom of Thailand');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('TL', 'AS', 'Timor-Leste', 'TLS', '626', 'Democratic Republic of Timor-Leste');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('TG', 'AF', 'Togo', 'TGO', '768', 'Togolese Republic');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('TK', 'OC', 'Tokelau', 'TKL', '772', 'Tokelau');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('TO', 'OC', 'Tonga', 'TON', '776', 'Kingdom of Tonga');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('TT', 'NA', 'Trinidad and Tobago', 'TTO', '780', 'Republic of Trinidad and Tobago');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('TN', 'AF', 'Tunisia', 'TUN', '788', 'Tunisian Republic');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('TR', 'AS', 'Türkiye', 'TUR', '792', 'Republic of Türkiye');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('TM', 'AS', 'Turkmenistan', 'TKM', '795', 'Turkmenistan');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('TC', 'NA', 'Turks and Caicos Islands', 'TCA', '796', 'Turks and Caicos Islands');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('TV', 'OC', 'Tuvalu', 'TUV', '798', 'Tuvalu');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('UG', 'AF', 'Uganda', 'UGA', '800', 'Republic of Uganda');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('UA', 'EU', 'Ukraine', 'UKR', '804', 'Ukraine');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('AE', 'AS', 'United Arab Emirates', 'ARE', '784', 'United Arab Emirates');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('GB', 'EU', 'United Kingdom of Great Britain and Northern Ireland', 'GBR', '826', 'United Kingdom of Great Britain & Northern Ireland');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('US', 'NA', 'United States of America', 'USA', '840', 'United States of America');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('UM', 'OC', 'United States Minor Outlying Islands', 'UMI', '581', 'United States Minor Outlying Islands');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('VI', 'NA', 'United States Virgin Islands', 'VIR', '850', 'United States Virgin Islands');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('UY', 'SA', 'Uruguay', 'URY', '858', 'Eastern Republic of Uruguay');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('UZ', 'AS', 'Uzbekistan', 'UZB', '860', 'Republic of Uzbekistan');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('VU', 'OC', 'Vanuatu', 'VUT', '548', 'Republic of Vanuatu');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('VE', 'SA', 'Venezuela', 'VEN', '862', 'Bolivarian Republic of Venezuela');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('VN', 'AS', 'Vietnam', 'VNM', '704', 'Socialist Republic of Vietnam');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('WF', 'OC', 'Wallis and Futuna', 'WLF', '876', 'Wallis and Futuna');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('EH', 'AF', 'Western Sahara', 'ESH', '732', 'Western Sahara');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('YE', 'AS', 'Yemen', 'YEM', '887', 'Yemen');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('ZM', 'AF', 'Zambia', 'ZMB', '894', 'Republic of Zambia');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('ZW', 'AF', 'Zimbabwe', 'ZWE', '716', 'Republic of Zimbabwe');
commit;
type: custom:auto-entities
card:
type: entities
filter:
template: |-
{% set SENSOR = 'device_tracker.life360_papa' -%}
{%- for attr in states[SENSOR].attributes -%}
{{
{
'type': 'attribute',
'entity': SENSOR,
'attribute': attr,
'name': attr
}
}},
{%- endfor %}
Activer à la mano le mode userspace de systemd pour certains utilisateurs
[admcsav@frsu0462 ~]$ cat /etc/sysctl.d/97-oracle-hugepages.conf
vm.nr_hugepages=10310
[admcsav@frsu0462 ~]$ cat /etc/default/grub
GRUB_TIMEOUT=5
GRUB_DISTRIBUTOR="$(sed 's, release .*$,,g' /etc/system-release)"
GRUB_DEFAULT=saved
GRUB_DISABLE_SUBMENU=true
GRUB_TERMINAL_OUTPUT="console"
GRUB_CMDLINE_LINUX="crashkernel=auto spectre_v2=retpoline rd.lvm.lv=sysvg/root rd.lvm.lv=sysvg/swap rd.lvm.lv=sysvg/usr rhgb quiet numa=off transparent_hugepage=never"
GRUB_DISABLE_RECOVERY="true"
Pour la partie : « vm.nr_hugepages=10310 »
Le nombre est déterminé par le script dispo ici :
https://oracle-base.com/articles/linux/configuring-huge-pages-for-oracle-on-linux-64
(attention, le DBA indique de ne SURTOUT pas utiliser grubby comme indiqué dans cette doc)
\n# [ $LOGNAME@\h:$PWD [\t] [ohvers SID:${ORACLE_SID:-"no sid"}] ]\n#
Il y a aussi l’astuce pour voir si un ID Parrot est enregistré ( test sur un seul)
dans services Rfplayer mettre dans « device_adresss » l’identité et sa cde, si ok voir log
ici Mode YAML
en Mode UI
Log en TXT
Log en XML
Si la cde ou l'ID n'existe pas ici (OFF)
le log ne remonte pas d’info derriere « /reqNum> »Log en XML avec un faut ID ou cde
En supplément la fonction Apprentissage du Parrot depuis HA
Dans l’outil de développement ‹ services › du GCE RFPlayer: send_command
Vous pouvez faire en mode YAML (plus simple)
il faut → automatic_add: false
il faut-> protocol: '' <----cela n’est pas possible en mode UI
dans la partie " command: " c’est là que nous entrons
la commande à enregistrée avec son ID
sa fonction
et le message de rappel de sa fonction si besoin (reminder) maxi 30 caracteres entre crochet [message] POSSIBLE QUE DE A1 à B16Exemple pour moi apprendre une commande ON, pour Mettre en fonction ma pompe, dans l’ID « B10 »
j’ai mis trop de caracteres dans le message d’info donc sera tronqué (Pompe Puit ON_ALL 0125C5CE - 1)
Exemple en mode YAML
service: rfplayer.send_command
data:
automatic_add: false
command: PARROTLEARN B10 ON [Pompe Puit ON_ALL 0125C5CE - 1232171904]
protocol: ''
image
image1156×308 16.2 KB
Si appuie sur APPELER LE SERVICE le RFPLAYER passe en attente d’envoie de code ( il faut être assez prés 50cm /1 m suivant la puissance de l’émetteur)
Info de Ziblue mode Parrot apprentissage
Il vous reste a initier cette commande PARROT dans HA qui produira un switch.parrot_« x »
Rappel méthode
Donc dans la page intégration du RFPLAYER on doit retrouver notre switch.parrot_b10 ( j’ai déjà renommer et mis icône)
switch.parrot_b10
Si on a un ON et un OFF ( en mode Parrot) on peut passé aussi par « /config/switch.yaml »
et ajouter un switch avec les commandes ON et OFF
- platform: template
switches:
pompepuit:
friendly_name: 'Pompe Puit ON OFF Rfplayer'
turn_on:
service: rfplayer.send_command
data:
command: 'ON'
protocol: PARROT
automatic_add: false
device_address: B10
turn_off:
service: rfplayer.send_command
data:
command: 'OFF'
protocol: PARROT
automatic_add: false
device_address: B1
On devrait retrouver après redémarrage notre identité dans une carte bouton cela donne :
image
image897×534 26.2 KB
image
@+DÕ¿ÕM
sudo apt-get update 2>&1 | sed -ne 's?^.*NO_PUBKEY ??p' | xargs -r -- sudo apt-key adv --keyserver keyserver.ubuntu.com --recv-keys
docker run --rm -v some_volume:/volume -v /tmp:/backup alpine tar -cjf /backup/some_archive.tar.bz2 -C /volume ./
And to restore it, just run:
docker run --rm -v some_volume:/volume -v /tmp:/backup alpine sh -c "rm -rf /volume/ /volume/..? /volume/.[!.]* ; tar -C /volume/ -xjf /backup/some_archive.tar.bz2"
PeopleSoft FSCM PUM Installation
sh psft-dpk-setup.sh --silent --response_file=/tmp/response.txt --customization_file=/tmp/psft_customizations.yaml
PeopleSoft PUM Database response file: response.txt
install_type=FRESH [or PUM]
psft_base_dir=/u02/fsc040
user_home_dir=/home/
db_type=DEMO
db_platform=ORACLE
db_name=EP92U040
db_service_name=EP92U040
db_port=1521
connect_id=people
connect_pwd=people
opr_id=VP1
opr_pwd=VP1
admin_pwd=Tiger123
access_id=SYSADM
access_pwd=SYSADM
weblogic_admin_pwd=Tiger123
webprofile_user_id=PTWEBSERVER
webprofile_user_pwd=PTWEBSERVER
gw_user_id=administrator
gw_user_pwd=Tiger123
gw_keystore_pwd=Tiger123
YAML File: psft_customizations.yaml
db_name: EP92U040
db_user: VP1
db_user_pwd: VP1
db_connect_id: people
db_connect_pwd: people
change_password: false
access_id: SYSADM
access_pwd: SYSADM
db_admin_pwd: Tiger123
domain_user: "%{hiera('psft_runtime_user_name')}"
ps_config_home: "%{hiera('user_home_dir')}/%{hiera('domain_user')}/psft/pt/8.58"
appserver_template: small
appserver_domain_name: EP92U040
prcs_domain_name: EP92U040
prcs_domain_id: "PRCS%{::rand}"
report_node_name: "%{hiera('prcs_domain_id')}"
pia_domain_name: peoplesoft
pia_site_name: ps
pia_http_port: 8022
pia_https_port: 8455
jolt_port: 9055
wsl_port: 8001
db_port: 1521
pia_gateway_user: administrator
pia_gateway_user_pwd: Tiger123
pia_gateway_keystore_pwd: Tiger123
domain_conn_pwd: Tiger123
peoplesoft_base: /u02/fsc040
dpk_location: "%{hiera('peoplesoft_base')}/dpk"
archive_location: "%{hiera('dpk_location')}/archives"
pt_location: "%{hiera('peoplesoft_base')}/pt"
db_location: "%{hiera('peoplesoft_base')}/db"
psft_runtime_group_name: psft
psft_app_install_group_name: appinst
oracle_install_group_name: oinstall
oracle_runtime_group_name: dba
groups:
psft_runtime_group:
name: "%{hiera('psft_runtime_group_name')}"
app_install_group:
name: "%{hiera('psft_app_install_group_name')}"
oracle_install_group:
name: "%{hiera('oracle_install_group_name')}"
remove: false
oracle_runtime_group:
name: "%{hiera('oracle_runtime_group_name')}"
remove: false
psft_user_pwd: 0radmin
oracle_user_pwd: oracle
user_home_dir: /u02
psft_install_user_name: psadm11
psft_runtime_user_name: psadm22
psft_app_install_user_name: psadm33
oracle_user_name: oracle22
psft_es_user_name: esadm11
psft_es_esadmin_name: esadmin
psft_es_espeople_name: people
setup_samba: false
setup_sysctl: false
setup_services: true
alter session set NLS_TERRITORY='FRANCE';
alter session set NLS_LENGTH_SEMANTICS='CHAR';
alter session set NLS_NUMERIC_CHARACTERS='.,';
alter session set NLS_DATE_FORMAT='DD/MM/YYYY';
alter session set NLS_TIMESTAMP_FORMAT='DD/MM/YYYY HH24:MI:SS';
set feedback off
set sqlformat insert
-- set sqlformat csv
spool /path/to/your/file.sql
select * from t;
spool off
set feedback on