Difference between revisions of "Talk:OmegaWiki"
Jump to navigation
Jump to search
m |
m |
||
| Line 1: | Line 1: | ||
Example of translation es-pt with PoS: |
Example of translation es-pt with PoS: |
||
== |
|||
<pre> |
<pre> |
||
mysql> |
mysql> |
||
| Line 17: | Line 18: | ||
</pre> |
</pre> |
||
The output: |
|||
... |
... |
||
| id | expression | lang | '''PoS''' | |
| id | expression | lang | '''PoS''' | |
||
| Line 58: | Line 60: | ||
| 639396 | tussenwerpsel | es | |
| 639396 | tussenwerpsel | es | |
||
+-----------+--------------------+---------------+ |
+-----------+--------------------+---------------+ |
||
--[[User:Ebenimeli|Enrique]] 17:23, 30 July 2007 (BST) |
|||
Latest revision as of 16:23, 30 July 2007
Example of translation es-pt with PoS:
==
mysql> select t.defined_meaning_id as id, e.spelling as expression, l.wikimedia_key as lang, oav.option_id from uw_defined_meaning as dm, uw_expression_ns as e, uw_syntrans as t, language as l, uw_option_attribute_values as oav, uw_option_attribute_options as oao where t.expression_id=e.expression_id and l.language_id=e.language_id and (l.wikimedia_key='es' or l.wikimedia_key='pt') and dm.defined_meaning_id = t.defined_meaning_id and t.syntrans_sid = oav.object_id order by t.defined_meaning_id ASC, l.wikimedia_key ASC
The output:
... | id | expression | lang | PoS | ... | 696046 | cuadrangular | es | 410505 | | 696046 | quadrangular | pt | 435971 | ...
mysql> select option_id,spelling,l.wikimedia_key from uw_option_attribute_options,uw_defined_meaning,uw_expression_ns, language as l where attribute_id = '409106' and uw_option_attribute_options.language_id = l.language_id and (l.wikimedia_key='es' or l.wikimedia_key='pt') and uw_defined_meaning.defined_meaning_id = option_mid and uw_expression_ns.expression_id = uw_defined_meaning.expression_id;
+-----------+--------------------+---------------+ | option_id | spelling | wikimedia_key | +-----------+--------------------+---------------+ | 410497 | verb | es | | 410503 | noun | es | | 410504 | adverb | es | | 410505 | adjective | es | | 413808 | contraction | es | | 413809 | contraction | pt | | 435968 | noun | pt | | 435971 | adjective | pt | | 435974 | verb | pt | | 436004 | bepaald lidwoord | pt | | 436005 | onbepaald lidwoord | pt | | 436011 | preposition | pt | | 629277 | adverb | pt | | 639365 | article | es | | 639375 | pronoun | es | | 639390 | preposition | es | | 639393 | voegwoord | es | | 639396 | tussenwerpsel | es | +-----------+--------------------+---------------+
--Enrique 17:23, 30 July 2007 (BST)
