Changeset 10162:fa36353462d4 in orange
- Timestamp:
- 02/11/12 11:56:24 (16 months ago)
- Branch:
- default
- File:
-
- 1 edited
-
docs/reference/rst/Orange.data.sql.rst (modified) (3 diffs)
Legend:
- Unmodified
- Added
- Removed
-
docs/reference/rst/Orange.data.sql.rst
r10088 r10162 5 5 The :class:`sql` module provides access to relational databases from Orange. 6 6 It currently supports: 7 7 8 - `MySql <http://www.mysql.com/>`_ through `MySQL for Python <http://sourceforge.net/projects/mysql-python/>`_, 8 9 - `Postgres <http://www.postgresql.org>`_ through `Psycopg <http://initd.org/psycopg/>`_, … … 20 21 - postgres://host:5432/database 21 22 22 **Attribute Names and Types** 23 Attribute Names and Types 24 ------------------------- 23 25 24 26 Rows returned by an SQL query have to be converted into Orange examples. … … 27 29 28 30 - STRING and DATETIME attributes are converted to Orange strings. 29 - The features listed in ``discrete_names`` are converted to Orange discrete features. 31 32 - The features listed in ``discrete_names`` are converted to Orange 33 discrete features. 34 30 35 - Other features are converted to continuous Orange features. 31 - The attribute in ``class_name`` is set as the class features. If no ``class_name`` is set, the column with the32 name "class" in the returned SQL query is set as the class attribute. If no such column exists, the last33 column is set as the class features.34 36 35 .. note:: When reading ``sqlite`` data table into :class:`Orange.data.Table` all columns are casted into :class:`Orange.feature.String`. 37 - The attribute in ``class_name`` is set as the class features. If no 38 ``class_name`` is set, the column with the name "class" in the 39 returned SQL query is set as the class attribute. If no such column 40 exists, the last column is set as the class features. 41 42 .. note:: When reading ``sqlite`` data table into :class:`Orange.data.Table` all columns are cast into :class:`Orange.feature.String`. 36 43 37 44 **Examples**
Note: See TracChangeset
for help on using the changeset viewer.
