Changeset View
Changeset View
Standalone View
Standalone View
src/drivers/postgresql/PostgresqlDriver.cpp
Show First 20 Lines • Show All 51 Lines • ▼ Show 20 Line(s) | 42 | //! @todo enable this when KDb supports multiple: beh->features = MultipleTransactions | CursorForward | CursorBackward; | |||
---|---|---|---|---|---|
52 | beh->CLOSING_QUOTATION_MARK_BEGIN_FOR_IDENTIFIER = '"'; | 52 | beh->CLOSING_QUOTATION_MARK_BEGIN_FOR_IDENTIFIER = '"'; | ||
53 | beh->LIKE_OPERATOR = QLatin1String("ILIKE"); | 53 | beh->LIKE_OPERATOR = QLatin1String("ILIKE"); | ||
54 | // Use SQL compliant TRUE or FALSE as described | 54 | // Use SQL compliant TRUE or FALSE as described | ||
55 | // at http://www.postgresql.org/docs/8.0/interactive/datatype-boolean.html | 55 | // at http://www.postgresql.org/docs/8.0/interactive/datatype-boolean.html | ||
56 | // 1 or 0 does not work. | 56 | // 1 or 0 does not work. | ||
57 | beh->BOOLEAN_TRUE_LITERAL = QLatin1String("TRUE"); | 57 | beh->BOOLEAN_TRUE_LITERAL = QLatin1String("TRUE"); | ||
58 | beh->BOOLEAN_FALSE_LITERAL = QLatin1String("FALSE"); | 58 | beh->BOOLEAN_FALSE_LITERAL = QLatin1String("FALSE"); | ||
59 | beh->USE_TEMPORARY_DATABASE_FOR_CONNECTION_IF_NEEDED = true; | 59 | beh->USE_TEMPORARY_DATABASE_FOR_CONNECTION_IF_NEEDED = true; | ||
60 | beh->GET_TABLE_NAMES_SQL = KDbEscapedString( | ||||
61 | "SELECT table_name FROM information_schema.tables WHERE " | ||||
62 | "table_type='BASE TABLE' AND table_schema NOT IN ('pg_catalog', 'information_schema')"); | ||||
60 | 63 | | |||
61 | initDriverSpecificKeywords(m_keywords); | 64 | initDriverSpecificKeywords(m_keywords); | ||
62 | initPgsqlToKDbMap(); | 65 | initPgsqlToKDbMap(); | ||
63 | 66 | | |||
64 | //predefined properties | 67 | //predefined properties | ||
65 | //http://www.postgresql.org/docs/9.5/static/libpq-misc.html#LIBPQ-PQLIBVERSION | 68 | //http://www.postgresql.org/docs/9.5/static/libpq-misc.html#LIBPQ-PQLIBVERSION | ||
66 | //! @todo use QLibrary to resolve PQlibVersion | 69 | //! @todo use QLibrary to resolve PQlibVersion | ||
67 | beh->properties.insert("client_library_version", PQlibVersion()); | 70 | beh->properties.insert("client_library_version", PQlibVersion()); | ||
▲ Show 20 Lines • Show All 140 Lines • Show Last 20 Lines |