mdbtools-dev Mailing List for MDB Tools (Page 71)

SourceForge Headquarters 225 Broadway Suite 1600 San Diego, CA 92101 +1 (858) 422-6466

Carl,

Sorry not to respond sooner, I've taken what you have here but structured it
a little bit different.  there is a new file backend.c that takes care of
setting up the datatypes table and such which can be registered using a
GHashTable.  That way, an application can register its own backend to export
to without it being predefined by us. Now, of course there are some builtin
ones.

Anyway, to do this, I introduced two new functions mdb_init() and mdb_exit()

mdb_init() needs to be called to initialize the library (must be called
prior to any other mdb calls).  mdb_exit() is the corresponding function for
when the program is done with libmdb.  Note on threads: mdb_init() and
mdb_register_backend() need to be called in a synchronized manner (for
instance in the main thread before creating subthreads).

I've changed all the files in the util/ directory, but if you have any
programs using libmdb, they'll have to have mdb_init() added at the top.

Brian

On Mon, 27 Mar 2000, Carl Seutter wrote:

> I started to look at modifying util/schema.c to provide the ability to
> generate different schemas.  Here are the recommended changes:
> 
> include/mdbtools.h
> 
> enum {
>  USE_ACCESS_TYPES = 0,
>         USE_ORACLE_TYPES = 1,
>         USE_SYBASE_TYPES = 2,
>         USE_SQLSERVER_TYPES = 3,
>         USE_INFORMIX_TYPES = 4
> };
> /*
>  * column data types
>  *    these must be in the same order as the
>  *    types defined above
>  *
>  */
> static char *column_types[5][16] = {
>    /*    Access data types */
>         {"Unknown 0x00",
>          "Boolean",
>          "Byte",
>          "Integer",
>          "Long Integer",
>          "Currency",
>          "Single",
>          "Double",
>          "DateTime (Short)",
>          "Unknown 0x09",
>          "Text",
>          "OLE",
>          "Memo/Hyperlink",
>          "Unknown 0x0d",
>          "Unknown 0x0e",
>   "Replication ID"},
>    /*    Oracle data types */
>         {"Oracle_Unknown 0x00",
>          "CHAR",
>          "NUMBER",
>          "NUMBER",
>          "NUMBER",
>          "NUMBER",
>          "NUMBER",
>          "NUMBER",
>          "DATE",
>          "Oracle_Unknown 0x09",
>          "VARCHAR2",
>          "BLOB",
>          "BLOB",
>          "Oracle_Unknown 0x0d",
>          "Oracle_Unknown 0x0e",
>   "NUMBER"},
>    /*    Sybase data types */
>         {"Sybase_Unknown 0x00",
>          "Sybase_Boolean",
>          "Sybase_Byte",
>          "Sybase_Integer",
>          "Sybase_Long Integer",
>          "Sybase_Currency",
>          "Sybase_Single",
>          "Sybase_Double",
>          "Sybase_DateTime (Short)",
>          "Sybase_Unknown 0x09",
>          "Sybase_Text",
>          "Sybase_OLE",
>          "Sybase_Memo/Hyperlink",
>          "Sybase_Unknown 0x0d",
>          "Sybase_Unknown 0x0e",
>   "Sybase_Replication ID"},
>    /*    SQL Server data types */
>         {"SQLserver_Unknown 0x00",
>          "SQLserver_Boolean",
>          "SQLserver_Byte",
>          "SQLserver_Integer",
>          "SQLserver_Long Integer",
>          "SQLserver_Currency",
>          "SQLserver_Single",
>          "SQLserver_Double",
>          "SQLserver_DateTime (Short)",
>          "SQLserver_Unknown 0x09",
>          "SQLserver_Text",
>          "SQLserver_OLE",
>          "SQLserver_Memo/Hyperlink",
>          "SQLserver_Unknown 0x0d",
>          "SQLserver_Unknown 0x0e",
>          "SQLserver_Replication ID"},
>    /*    Informix data types */
>         {"Informix_Unknown 0x00",
>          "Informix_Boolean",
>          "Informix_Byte",
>          "Informix_Integer",
>          "Informix_Long Integer",
>          "Informix_Currency",
>          "Informix_Single",
>          "Informix_Double",
>          "Informix_DateTime (Short)",
>          "Informix_Unknown 0x09",
>          "Informix_Text",
>          "Informix_OLE",
>          "Informix_Memo/Hyperlink",
>          "Informix_Unknown 0x0d",
>          "Informix_Unknown 0x0e",
>          "Informix_Replication ID"}
> };
> 
> By moving these defines to the header file, the array's don't have to be
> re-created each time the function mdb_get_coltype_string located in
> libmdb/table.c is called.  Also for a maintanable environment wouldn't
> it be easier if all the column definitions are together along with the
> supported databases to generate for?
> 
> 
> libmdb/table.c:
>    1) change char *mdb_get_coltype_string(int col_type) to   char
> *mdb_get_coltype_string(int col_type, int db_type)
>    2) in mdb_get_coltype_string change
>             return column_types[col_type]; to
>             return column_types[db_type][col_type];
>    3) in mdb_table_dump change
>           mdb_get_coltype_string(col->col_type) to
>           mdb_get_coltype_string(col->col_type,USE_ACCESS_TYPES)
> 
> util/schema.c
>     1) change int i, j,k; to
>             int i, j, k, schema_type;
>     2) change if (argc <2) et al to
>                if (argc < 3) {
>                   fprintf (stderr, "Usage: %s <file>
> <schema>\n",argv[0]);
>                   fprintf (stderr, "  valid values for schema are:
> oracle, sybase, sqlserver, access, informix\n");
>                   fprintf (stderr, "  the default is access\n");
>                   exit (1);
>                 }
>     3) add the following code before the open database
>              if (strcasecmp(argv[2],"oracle") == 0)
>                    schema_type = USE_ORACLE_TYPES;
>              else if (strcasecmp(argv[2],"sybase") == 0)
>                    schema_type = USE_SYBASE_TYPES;
>               else if (strcasecmp(argv[2],"sqlserver") == 0)
>                    schema_type = USE_SQLSERVER_TYPES;
>                else if (strcasecmp(argv[2],"informix") == 0)
>                    schema_type = USE_INFORMIX_TYPES;
>                else
>                    schema_type = USE_ACCESS_TYPES;
>      4) change the call to mdb_get_coltype_string from
>              mdb_get_coltype_string (col->col_type) to
> mdb_get_coltype_string (col->col_type,schema_type)
>       5)   added this inside the if (col-> col_size !=0) and before the
> fprintf
>                if (schema_type == USE_ORACLE_TYPES && col->col_type ==
> MDB_SDATETIME)
>                       schema_type = schema_type;
>                     else
> 
> 
> _______________________________________________
> mdbtools-dev mailing list
> mdb...@li...
> http://lists.sourceforge.net/mailman/listinfo/mdbtools-dev
> 

2000	Jan	Feb (1)	Mar (53)	Apr (28)	May (5)	Jun (7)	Jul (16)	Aug (15)	Sep (10)	Oct (1)	Nov	Dec (1)
2001	Jan (9)	Feb (7)	Mar (1)	Apr (7)	May (6)	Jun	Jul (15)	Aug (10)	Sep (2)	Oct (12)	Nov (3)	Dec (2)
2002	Jan (2)	Feb (12)	Mar (33)	Apr (30)	May (5)	Jun (18)	Jul (18)	Aug (47)	Sep (8)	Oct (7)	Nov (8)	Dec (13)
2003	Jan (48)	Feb (8)	Mar (10)	Apr (30)	May (6)	Jun (8)	Jul (19)	Aug (36)	Sep (19)	Oct (16)	Nov (11)	Dec (17)
2004	Jan (11)	Feb (22)	Mar (52)	Apr (45)	May (18)	Jun (72)	Jul (14)	Aug (31)	Sep (19)	Oct (27)	Nov (19)	Dec (25)
2005	Jan (16)	Feb (46)	Mar (50)	Apr (3)	May (21)	Jun (3)	Jul (24)	Aug (33)	Sep (25)	Oct (23)	Nov (30)	Dec (20)
2006	Jan (12)	Feb (11)	Mar (8)	Apr (15)	May (27)	Jun (15)	Jul (19)	Aug (5)	Sep (9)	Oct (1)	Nov (2)	Dec (3)
2007	Jan	Feb (3)	Mar (18)	Apr (5)	May (9)	Jun	Jul (10)	Aug (3)	Sep (8)	Oct (1)	Nov (7)	Dec (9)
2008	Jan (2)	Feb	Mar (10)	Apr (4)	May	Jun (5)	Jul (9)	Aug	Sep (1)	Oct	Nov	Dec (8)
2009	Jan	Feb	Mar	Apr	May (1)	Jun	Jul	Aug	Sep	Oct (11)	Nov (1)	Dec (20)
2010	Jan	Feb (2)	Mar	Apr (7)	May	Jun (23)	Jul (3)	Aug (6)	Sep (1)	Oct (4)	Nov (1)	Dec
2011	Jan (1)	Feb (26)	Mar (25)	Apr (11)	May (5)	Jun (5)	Jul (2)	Aug (39)	Sep (12)	Oct (6)	Nov	Dec
2012	Jan (19)	Feb (5)	Mar	Apr	May	Jun (7)	Jul	Aug (8)	Sep	Oct (3)	Nov (2)	Dec (3)
2013	Jan (6)	Feb	Mar (1)	Apr	May (7)	Jun (5)	Jul (2)	Aug	Sep (1)	Oct (2)	Nov	Dec
2014	Jan (4)	Feb	Mar (2)	Apr	May	Jun	Jul	Aug (1)	Sep	Oct	Nov	Dec
2015	Jan	Feb	Mar	Apr	May (1)	Jun	Jul	Aug	Sep	Oct	Nov	Dec (1)
2016	Jan (5)	Feb	Mar (1)	Apr (1)	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec
2017	Jan	Feb (1)	Mar	Apr	May	Jun (2)	Jul	Aug	Sep	Oct	Nov	Dec
2018	Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov (1)	Dec