Extension:External Data/fr

conteneur

wfLoadExtension( 'ExternalData' );

{{#get_web_data:
 url=data source URL
 |format={CSV|CSV with header|GFF|JSON|XML|HTML|text}
 |delimiter=delimiter
 |regex=regular expression
 |data=local_variable_name1=external_variable_name1, etc.
 |filters=external_variable_name1=filter_value1, etc.
 |use xpath
 |use jsonpath
 |json offset=number of characters
 |post data=additional data
 |cache seconds=number of seconds
 |use stale cache
 |suppress error
}}

<fruit type="Apple"><color>red</color></fruit>

<fruits>
  <fruit type="Apple"><color>red</color></fruit>
  <fruit type="Kiwi"><color>brown</color></fruit>
</fruits>

$edgCacheTable = 'ed_url_cache';

CREATE TABLE IF NOT EXISTS `ed_url_cache`

CREATE TABLE IF NOT EXISTS `YourPrefixed_url_cache`

$edgCacheExpireTime = 7 * 24 * 60 * 60;

$edgAlwaysAllowStaleCache = false;

$edgStringReplacements['WORLDDATA_KEY'] = '123abcd';

$edgAllowExternalDataFrom = 'http://example.org';

$edgAllowExternalDataFrom = array('http://example.org', 'http://example2.com');

$edgAllowSSL = false;

$edgHTTPOptions['sslVerifyCert'] = true;

{{#get_soap_data:
 url=data source URL
 |request=the function used to request data
 |requestData=parameter1=value1, etc.
 |response=the function used to retrieve data
 |data=local_variable_name1=external_variable_name1, etc.
 |suppress error
}}

 {{#get_file_data:
  file=''file ID''
  |directory=''directory ID''
  |file name=''file name''
  |format={CSV|CSV with header|GFF|JSON|XML|HTML|text}
  |data=''local_variable_name1''=''external_variable_name1'', etc.
  |filters=''external_variable_name1''=''filter_value1'', etc.
  |use xpath
  |delimiter=''delimiter''
  |regex=''regular expression''
  |cache seconds=''number of seconds''
  |suppress error
 }}

$edgFilePath['ID'] = "local file path";

$edgDirectoryPath['ID'] = "local directory path";

$edgDirectoryPath['Our test results'] = '/home/genomelab/data/TestResults/;

{{#get_file_data:
 directory=Our test results
 |file name=JanuaryData.csv
 |format=CSV
 |data=Test date=Date,Study size=Study size,Researchers=Researchers,Result details=Notes
}}

 {{#get_file_data: directory = classes
  | file name = *.php
  | format = text
  | regex = /^\s*(?<abstract>abstract)?\s*class\s+(?<class>\w+)(\s+extends\s*(?<extends>\w+))?/m
  | data = file=__file,abstract=abstract,class=class,base=extends
  }}

$edgDBServer['ID'] = "server URL";
$edgDBServerType['ID'] = "DB type";
$edgDBName['ID'] = "DB name";
$edgDBUser['ID'] = "username";
$edgDBPass['ID'] = "password";

$edgDBServer['employee-db'] = "127.0.0.1";
$edgDBServerType['employee-db'] = "mysql";
$edgDBName['employee-db'] = "employeesDatabase";
$edgDBUser['employee-db'] = "guest";
$edgDBPass['employee-db'] = "p@ssw0rd";

$edgDBFlags['id'] = "MediaWiki DB flags";
$edgDBTablePrefix['id'] = "table prefix";

$edgDBFlags['employee-db'] = DBO_NOBUFFER & DBO_TRX;
$edgDBTablePrefix['employee-db'] = "emp_";

yum install php55-php-pgsql

$edgDBServerType['ID'] = "postgres";

$edgDBServerType['ID'] = "sqlite";
$edgDBDirectory['ID'] = "/directory/to/DB/file";
$edgDBName['ID'] = "Name of file, without .sqlite";

$wgMainCacheType = CACHE_MEMCACHED;
$edgMemCachedMongoDBSeconds = ''number of seconds'';

{{#get_db_data:
 db=database ID
 |from=from clause
 |where=where clause
 |limit=limit
 |order by=order by clause
 |group by=group by clause
 |data=data mappings
 |suppress error
}}

{{#get_db_data:
 db=employee-db
 |from=tblPersonalInfo
 |where=employeeID='{{{id}}}'
 |limit=50
 |order by=employeeName ASC
 |data=dbemail=employeeEmail,name=employeeName
}}

$edgDBServer	['rfam2']	= 'mysql-rfam-public.ebi.ac.uk:4497';
$edgDBServerType['rfam2']	= 'mysql';
$edgDBName		['rfam2']	= 'Rfam';
$edgDBUser		['rfam2']	= 'rfamro';
$edgDBPass		['rfam2']	= '';
$edgDBPrepared	['rfam2']	= <<<'SQL'
SELECT fr.rfam_acc, fr.rfamseq_acc, fr.seq_start, fr.seq_end
FROM full_region fr, rfamseq rf, taxonomy tx
WHERE rf.ncbi_id = tx.ncbi_id
AND fr.rfamseq_acc = rf.rfamseq_acc
AND tx.ncbi_id = ? -- the only parameter to the query.
AND is_significant = 1 -- exclude low-scoring matches from the same clan
LIMIT 20;
SQL;

{{#get_db_data:db = rfam2
 | parameters=10116 <!-- this parameter is used to substitute question marks in the prepared statement -->
 | data=account=rfam_acc,sec=rfamseq_acc,start=seq_start,end=seq_end
}}

$edgDBServer	['rfam3']	= 'mysql-rfam-public.ebi.ac.uk:4497';
$edgDBServerType['rfam3']	= 'mysql';
$edgDBName		['rfam3']	= 'Rfam';
$edgDBUser		['rfam3']	= 'rfamro';
$edgDBPass		['rfam3']	= '';
$edgDBPrepared	['rfam3']	= [
	'sequences' => <<<'SEQ'
SELECT fr.rfam_acc, fr.rfamseq_acc, fr.seq_start, fr.seq_end
FROM full_region fr, rfamseq rf, taxonomy tx
WHERE rf.ncbi_id = tx.ncbi_id
AND fr.rfamseq_acc = rf.rfamseq_acc
AND tx.ncbi_id = ? -- the only parameter to the query.
AND is_significant = 1 -- exclude low-scoring matches from the same clan
SEQ,
	'sno' => <<<'SNO'
SELECT fr.rfam_acc, fr.rfamseq_acc, fr.seq_start, fr.seq_end, f.type
FROM full_region fr, rfamseq rf, taxonomy tx, family f
WHERE
rf.ncbi_id = tx.ncbi_id
AND f.rfam_acc = fr.rfam_acc
AND fr.rfamseq_acc = rf.rfamseq_acc
AND tx.tax_string LIKE ? -- the only parameter to the query.
AND f.type LIKE '%snoRNA%'
AND is_significant = 1 -- exclude low-scoring matches from the same clan
SNO];

{{#get_db_data: db = rfam3
 | query=sequences <!-- this parameter is used to choose one of the prepared statements -->
 | parameters=10116 <!-- this parameter is used to substitute question marks in prepared statement -->
 | data=account=rfam_acc,sec=rfamseq_acc,start=seq_start,end=seq_end
}}

$edgLDAPServer['domain'] = "myldapserver.com";
$edgLDAPBaseDN['domain'] = "[basedn]";
$edgLDAPUser['domain'] = "myDomainUser";
$edgLDAPPass['domain'] = "myDomainPassword";

$edgLDAPServer['foobar'] = "foobar.com";
$edgLDAPBaseDN['foobar'] = "OU=Users,dc=foobar,dc=com";
$edgLDAPUser['foobar'] = "u12345";
$edgLDAPPass['foobar'] = "mypassword";

{{#get_ldap_data:
 domain=domain
 |filter=LDAP filter
 |data=data mappings
}}

{{#get_ldap_data:
 domain=foobar
 |filter=(sAMAccountName={{{id}}})
 |data=email=mail,title=title,company=company,department=department
}}

// 'lilypond' will be the name under which this program can be invoked by {{#get_program_data:}}.
$edgExeName             ['lilypond']    = 'LilyPond'; // (optional) the name of the program for Special:Version.
$edgExeUrl              ['lilypond']    = 'http://lilypond.org/'; // (optional) program home page for Special:Version.
$edgExeVersionCommand   ['lilypond']    = 'lilypond -v'; // (optional) Shell comand that will return program version for Special:Version. The results are cached.
$edgExeVersion          ['lilypond']    = 'GNU LilyPond 2.20.0'; // (optional) Explicitly set program version for Special:Version. Use only if $edgExeVersionCommand is not an option.
$edgExeLimits           ['lilypond']    = [ 'memory' => 0, 'time' => 0, 'walltime' => 0, 'filesize' => 0 ]; // (optional) Limits override for the program. Use with caution.
$edgExeEnvironment      ['lilypond']    = ['KEY' => 'value']; // (optional) Environment variables for the program. Parameters will be substitued in the values as well as in the shell command itself.
$edgExeCommand          ['lilypond']    = 'lilypond -dbackend=svg -dpaper-size="$size$" -dsafe -dcrop -o $tmp$ -'; // The shell command that receives user input as stdin and outputs its result as stdout (or into a temporary file). $size$ will be replaced with the value of the size argument to the parser function.
$edgExeParams           ['lilypond']    = ['size' => 'a4']; // Parameters to the parser function with their default values. If there is a numeric key, then the value is the name of a required parameter.
$edgExeParamFilters     ['lilypond']    = ['size' => '/^\w+$/']; // Callables and regular expressions that are used to validate parameter values. Should be as restrictive as possible.
$edgExeInput            ['lilypond']    = 'notes'; // Name of the parser function parameter that will be sent to program's standard input.
$edgExePreprocess       ['lilypond']    = null; // (optional) A callable used to preprocess the standard input for the program. There is one pre-defined function: EDConnectorExe::wikilinks4dot().
$edgExeTempFile         ['lilypond']    = '$tmp$.cropped.svg'; // (optional) Name of the temporary file used instead of standard output (not recommended).
$edgExeIgnoreWarnings   ['lilypond']    = true; // (optional) Ignore warnings that a program may send to stderr.
$edgExePostprocess      ['lilypond']    = null; // (optional) A callable used to postprocess programs' standrd output. There is one pre-defined function EDConnectorExe::innerXML().
$edgExeTags             ['lilypond']    = 'score'; // (optional) Bind the program to this tag to emulate the behaviour of some MediaWiki extensions.

{{#get_program_data: program = lilypond
 | size = a8landscape
 | notes = \paper {
  indent = 0\mm
  line-width = 110\mm
  oddHeaderMarkup = ""
  evenHeaderMarkup = ""
  oddFooterMarkup = ""
  evenFooterMarkup = ""
 }
 \relative c' { f d f a d f e d cis a cis e a g f e }
 | format = text
 | data = xml=__text
 }}

// apt-cache show
$edgExeCommand      ['apt-cache show']  = 'apt-cache show $package$';
$edgExeParams       ['apt-cache show']  = ['package'];
$edgExeParamFilters ['apt-cache show']  = ['package' => '/^[\w-]+$/'];

{{#get_program_data:
    program = apt-cache show
  | package = graphviz-doc
  | data = key=1,value=2
  | format = CSV
  | delimiter = :
 }}
 {| class="wikitable"
 ! Key !! Value {{#for_external_table:<nowiki/>
 {{!}}-
 {{!}} {{{key}}} {{!}}{{!}} {{{value}}}
 }}
 |}

$edgCacheTable = ...;
$edgCacheExpireTime = ...;
$edgAlwaysAllowStaleCache = ...;

{{#get_web_data:url=http://discoursedb.org/GermanyCSV.txt
    |format=csv with header|data=bordered countries=Borders,population=Population,area=Area,capital=Capital}}

* Germany borders the following countries:
{{#arraymap:{{#external_value:bordered countries}}|,|x|[[x]]}}.
* Germany has population {{#external_value:population}}.
* Germany has area {{#external_value:area}}.
* Its capital is {{#external_value:capital}}.
"357,050 km²","Austria,Belgium,Czech Republic,Denmark,France,Luxembourg,Netherlands,Poland,Switzerland",Berlin,"82,411,001"

$edgExternalValueVerbose = false;

{| class="wikitable"
! Name
! Borders
! Population
! Area {{#for_external_table:<nowiki/>
{{!}}-
{{!}} {{{name}}}
{{!}} {{{borders}}}
{{!}} {{{population}}}
{{!}} {{{area}}}
}}
|}

{{#for_external_table: http://www.google.com/search?q={{{term.urlencode}}} }}
{{#for_external_table: http://www.google.com/search?q={{urlencode:{{{term}}}}} }}
{{#get_web_data:url=https://discoursedb.org/AfricaCSV.txt
  |format=CSV with header
  |data=Country name=Country,Countries bordered=borders,Population=population,Area=area
}}
{| class="wikitable"
! Name
! Borders
! Population
! Area
{{#display_external_table:template=Country info row}}
|}

|-
|{{{Country name}}}
|{{{Countries bordered}}}
|{{{Population}}}
|{{{Area}}}

{{#store_external_table:Is fruit in
|Has name={{{name}}}
|Has color={{{color}}}
|Has shape={{{shape}}}
}}

mw.ext.externalData.getWebData

mw.ext.externalData.getFileData

mw.ext.externalData.getDbData

mw.ext.externalData.getSoapData

mw.ext.externalData.getLdapData

mw.ext.externalData.getProgramData

mw.ext.externaldata.getWebData {
    url = "https://discoursedb.org/wiki/Special:GetData/Fruits_data"
  , data = "name=Name,color=Color,shape=Shape"
  , format = "CSV with header"
}

mw.ext.externaldata.getWebData {
    url = 'https://discoursedb.org/wiki/Special:GetData/Fruits_data'
  , data = {name = 'Name', color = 'Color', shape = 'Shape'}
  , format = 'CSV with header'
}

table#1 {
 table#2 {
   ["color"] = "Red",
   ["name"] = "Apple",
   ["shape"] = "Round",
 },
 table#3 {
   ["color"] = "Yellow",
   ["name"] = "Banana",
   ["shape"] = "Oblong",
 },
 table#4 {
   ["color"] = "Orange",
   ["name"] = "Orange",
   ["shape"] = "Round",
 },
 table#5 {
   ["color"] = "Yellow",
   ["name"] = "Pear",
   ["shape"] = "Pear-shaped",
 },

}, nil
$wgHTTPTimeout = 60;

External Data État de la version : stable
Implémentation	Fonction d'analyseur , Page spéciale
Description	Permet d'utiliser et d'afficher les valeurs extraites de différentes sources : URL externes, pages wiki locales et fichiers locaux (au format CSV, GFF, JSON, XML, HTML ou autres), tables de base de données et serveurs LDAP.
Auteur(s)	Yaron Koren, Alex Mashin and others
Dernière version	2.4.1 (juin 2021)
Politique de compatibilité	Le master conserve la compatibilité arrière.
MediaWiki	1.28+
Modifie la base de données	Oui
Licence	Licence publique générale GNU v2.0 ou supérieur
Téléchargement	Télécharger l'extension Git ^[?]: Télécharger la branche master de Git parcourir le dépôt (GitHub) historique des validations (commits) contributeurs du dépôt (GitHub) relecture du code See here
Exemple	A page containing information retrieved from an external CSV file
Paramètres $edgDBTablePrefix $edgExeCommand $edgCacheExpireTime $edgSecrets $edgExeEnvironment $edgExeUrl $edgHTTPOptions $edgAllowSSL $edgExeLimits $edgDBPass $edgDBServer $edgDBServerType $edgDirectoryPath $edgLDAPUser $edgStringReplacements $edgTryEncodings $edgExeUseStaleCache $edgExternalValueVerbose $edgParsers $edgConnectors $edgExeName $edgExeTags $edgExeVersionCommand $edgExeTempFile $edgExeVersion $edgDBFlags $edgExeCacheSeconds $edgLDAPPass $edgDBUser $edgDBPrepared $edgDBDirectory $edgExePreprocess $edgExeIgnoreWarnings $edgDBName $edgAlwaysAllowStaleCache $edgExeInput $edgExeParamFilters $edgExeParams $edgExePostprocess $edgLDAPServer $edgFilePath $edgDBTypes $edgLDAPBaseDN
Accroches utilisées ParserFirstCallInit ScribuntoExternalLibraries SoftwareInfo
Accroches fournies ExternalDataBeforeWebCall
Traduire l’extension External Data sur translatewiki.net
Vérifier la matrice des utilisations et des versions.
Problèmes	Tâches ouvertes · Signaler un bogue

Lua function	Corresponding parser function
mw.ext.externalData.getWebData	`{{#get_web_data:}}`
mw.ext.externalData.getFileData	`{{#get_file_data:}}`
mw.ext.externalData.getDbData	`{{#get_db_data:}}`
mw.ext.externalData.getSoapData	`{{#get_soap_data:}}`
mw.ext.externalData.getLdapData	`{{#get_ldap_data:}}`
mw.ext.externalData.getProgramData	`{{#get_program_data:}}`

Extension:External Data/fr

Fonctions d'analyse

Téléchargement

Installation

Auteurs

Récupération des données

#get_web_data - CSV, GFF, JSON, XML, HTML

Obtention de données à partir d'un fichier texte non API

Mise en cache des données

Chaîne de remplacement dans les URL

Liste d'autorisation pour les URL

HTTP options

Utilisation de XPath

Utilisation de JSONPath

Utilisation de sélecteurs de style CSS

#get_soap_data - données Web via SOAP

#get_file_data - retrieve files on the local server

#get_db_data - récupère des données à partir d'une base de données

Configuration

Support for database systems

Postgres

SQLite

Oracle

MongoDB

Usage

Prepared statements

#get_ldap_data - retrieve data from LDAP directory

Configuration

Usage

#get_program_data - retrieve data returned by a program run server-side

Displaying data

Displaying individual values

Displaying a table of values

#for_external_table

#display_external_table

Clearing data

Storing data

Semantic MediaWiki

Cargo

Scribunto/Lua

Common problems

Version history

Contributing

Bugs and feature requests

Translating

Footnotes