Re: [Modeling-users] SQLite adaptor (buglets)

[Mario R. <ma...@ru...>]

hi,


1. Changing to adaptorName='SQLite' in the pymodel_StoreEmployees.py,  
gives:

% mdl_validate_model.py -v pymodel_StoreEmployees.py
Loading the model...
Done.
Validating...
Done.
Object: Model StoreEmployees
----------------------------
  * Warning(s):
    - adaptorName 'SQLite' is not one of the framework's, maybe one of  
yours
%


2. When running with SQLite, an admin-connection-dict should not be  
required?

% mdl_generate_DB_schema.py -C pymodel_StoreEmployees.py
Error: option -C requires --admin-connection-dict
%


3. Supplying an admin-dsn:

% mdl_generate_DB_schema.py --admin-dsn  
localhost:StoreEmployees:dummy:dummy -C pymodel_StoreEmployees.py
Create Database FAILED
Reason:
exceptions.NameError
global name 'cnx' is not defined
   File "/usr/bin/mdl_generate_DB_schema.py", line 85, in  
databaseSchemaWithOptions
      
adaptor.createDatabaseWithAdministrativeConnectionDictionary(administrat 
iveConnectionDictionary, createUser)
   File  
"/usr/lib/python2.2/site-packages/Modeling/DatabaseAdaptors/ 
AbstractDBAPI2AdaptorLayer/AbstractDBAPI2Adaptor.py", line 129, in  
createDatabaseWithAdministrativeConnectionDictionary
     cnx,  
cur=self.dbAPI_gimmeCnxAndCursorForDBAdmin(administrativeConnectionDicti 
onary)
   File  
"/usr/lib/python2.2/site-packages/Modeling/DatabaseAdaptors/ 
SQLiteAdaptorLayer/SQLiteAdaptor.py", line 85, in  
dbAPI_gimmeCnxAndCursorForDBAdmin
     cnx.autocommit()

hgjh
%


Cheers, mario