# -*- coding: iso-8859-1 -*-

#. // _ba_ConstSdbc.py

#. // Constantes pour sBase.
def ba_ConstSdbc():

   #. // https://wiki.openoffice.org/wiki/Base/Data_Types

   #. // https://www.openoffice.org/api/docs/common/ref/com/sun/star/sdbc/DataType.html
   #. // Type des champs des tables.
   ARRAY         = 2003
   BIGINT        =   -5
   BINARY        =   -2
   BIT           =   -7
   BLOB          = 2004
   BOOLEAN       =   16
   CHAR          =    1
   CLOB          = 2005
   DATE          =   91
   DECIMAL       =    3
   DISTINCT      = 2001
   DOUBLE        =    8
   FLOAT         =    6
   INTEGER       =    4
   LONGVARCHAR   =   -1
   LONGVARBINARY =   -4
   NUMERIC       =    2
   OBJECT        = 2000
   OTHER         = 1111
   REAL          =    7
   REF           = 2006
   SMALLINT      =    5
   SQLNULL       =    0
   STRUCT        = 2002
   TIME          =   92
   TIMESTAMP     =   93
   TINYINT       =   -6
   VARBINARY     =   -3
   VARCHAR       =   12

   #. // https://www.openoffice.org/api/docs/common/ref/com/sun/star/sdbc/ColumnValue.html
   #. // Les colonnes acceptent-t'elles les valeurs nulles ?
   NO_NULLS         = 0
   NULLABLE         = 1
   NULLABLE_UNKNOWN = 2

   return locals()

'''
Dernière modification : 2022-02-20

[todo] Voir s'il y en d'autres.

[Exemple]

import sys
sys.path.append( "modules" )

from _ba_ConstSdbc import ba_ConstSdbc # // Constantes pour sBase.

ct = ba_ConstSdbc()
print()
print( "ct[ 'DATE' ] =", ct[ 'DATE' ] )

[/Exemple]
'''