|
43.
|
|
|
Enhanced SQL query language supporting pipes.
|
|
|
|
Language SQL amerliorer qui supporte les pipes
|
|
Translated and reviewed by
Djellel E. Difallah
|
|
|
|
Located in
../boots/lib/lingos/piped_sql.py:47
|
|
44.
|
|
|
PipedSQL is an enhanced SQL-like query language for Boots, allowing data to be redirected through pipes. Normal SQL queries can be run in PipedSQL without modification, with the option of piping the results to a chain of PipedSQL objects.
![](/@@/translation-newline)
Example: SELECT * FROM table | csv_out("result.csv")
|
|
|
represents a line break.
Start a new line in the equivalent position in the translation.
|
|
|
|
PipedSQL est une extension du langage SQL pour Boots, qui permet de rediriger les resultats a travers des pipes. Les requettes SQL simple peuvent s'executer dans PipeSQL sans aucune modification, avec l'option de diriger les resultats vers une chaine d'objets PipedSQL. ![](/@@/translation-newline)
Exemple: SELECT * FROM table | csv_out("resultat.csv")
|
|
Translated and reviewed by
Djellel E. Difallah
|
|
|
|
Located in
../boots/lib/lingos/piped_sql.py:48
|
|
45.
|
|
|
PipedSQL Objects
|
|
|
|
Objet PipedSQL
|
|
Translated and reviewed by
Djellel E. Difallah
|
|
|
|
Located in
../boots/lib/lingos/piped_sql.py:52
|
|
46.
|
|
|
Objects to pipe to in PipedSQL.
|
|
|
|
Objets à diriger vers en PipedSQL.
|
|
Translated and reviewed by
David .
|
|
|
|
Located in
../boots/lib/lingos/piped_sql.py:52
|
|
47.
|
|
|
Outputs piped data to a CSV file.
|
|
|
|
Sorties canalisée des données vers un fichier CSV.
|
|
Translated and reviewed by
David .
|
|
|
|
Located in
../boots/lib/lingos/piped_sql.py:54
|
|
48.
|
|
|
Comma separated value data output. Takes one argument, a file path to write to.
|
|
|
|
Sortie de données de valeur, séparées par des virgules. Prend un argument, un chemin de fichier à écrire.
|
|
Translated and reviewed by
David .
|
|
|
|
Located in
../boots/lib/lingos/piped_sql.py:56
|
|
49.
|
|
|
Returns only indicated text.
|
|
|
|
Le retour indiquaient seulement le texte.
|
|
Translated and reviewed by
David .
|
|
|
|
Located in
../boots/lib/lingos/piped_sql.py:59
|
|
50.
|
|
|
Takes two arguments. Filters out all text that does not match the first argument. The second argument is an optional name of a column to filter.
|
|
|
|
Prend deux arguments. Filtres à tout texte qui ne correspond pas au premier argument. Le deuxième argument est un nom facultatif d'une colonne à filtrer.
|
|
Translated and reviewed by
David .
|
|
|
|
Located in
../boots/lib/lingos/piped_sql.py:61
|
|
51.
|
|
|
Inputs piped data from a CSV file.
|
|
|
|
Intrants canalisations des données d'un fichier CSV.
|
|
Translated and reviewed by
David .
|
|
|
|
Located in
../boots/lib/lingos/piped_sql.py:64
|
|
52.
|
|
|
Comma separated value data input. Takes one argument, a file path to read from.
|
|
|
|
Les entrées de données valeur séparés par des virgules. Prend un argument, un chemin de fichier à lire.
|
|
Translated and reviewed by
David .
|
|
|
|
Located in
../boots/lib/lingos/piped_sql.py:66
|