[IronPython] Database Engine for Django on IronPython

[Markus Törnqvist]

On Fri, Oct 23, 2009 at 12:41:21PM -0600, Vernon Cole wrote:
>Okay, it's officially on top of my to-do list. I try to dedicate an hour or
>two each day to open source projects, so this will keep me busy for a
>while.  

If there's anything I can do to help, just ask :)

>The big thing will be paramstyle format convertion.  MS-SQL uses
>qmark.  I am told that django wants pyformat.  Somebody *please* correct me
>if that is wrong.   ( I don't actually USE django yet, but I want to learn.
>Is starting from inside out a bad thing?)

The tutorial wouldn't probably take a long time, even if you just skimmed
through it, but it might not be beneficial here :)

I found this
http://docstore.mik.ua/orelly/other/python/0596001886_pythonian-chp-11-sect-4.html

format I think is more to what's used, but I also think this depends more
on the backend than Django...

See Django-1.0/django/db/backends/sqlite3/base.py

class SQLiteCursorWrapper(Database.Cursor):
    """
    Django uses "format" style placeholders, but pysqlite2 uses "qmark" style.
    This fixes it -- but note that if you want to use a literal "%s" in a query,
    you'll need to use "%%s".
    """

Dunno if that's helpful, or relevant, for you?

Also:
I got this exception Keyword not supported: 'provider'

Any hints on where it came from?

File "C:\Program Files\IronPython 2.6\lib\site-packages\django\db\models\manager.py" in get
  117.         return self.get_query_set().get(*args, **kwargs)
File "C:\Program Files\IronPython 2.6\lib\site-packages\django\db\models\query.py" in get
  317.         num = len(clone)
File "C:\Program Files\IronPython 2.6\lib\site-packages\django\db\models\query.py" in __len__
  173.                 self._result_cache = list(self.iterator())
File "C:\Program Files\IronPython 2.6\lib\site-packages\django\db\models\query.py" in iterator
  288.         for row in self.query.results_iter():
File "C:\Program Files\IronPython 2.6\lib\site-packages\django\db\models\sql\query.py" in results_iter
  205.         for rows in self.execute_sql(MULTI):
File "C:\Program Files\IronPython 2.6\lib\site-packages\django\db\models\sql\query.py" in execute_sql
  1819.         cursor = self.connection.cursor()
File "C:\Program Files\IronPython 2.6\lib\site-packages\django\db\backends\__init__.py" in cursor
  56.         cursor = self._cursor(settings)
File "C:\Program Files\IronPython 2.6\lib\site-packages\kludgemssql\base.py" in _cursor
  97.             self.connection = Database.connect(make_connection_string(settings))
File "C:\Program Files\IronPython 2.6\lib\site-packages\kludgemssql\dbapi.py" in connect
  8.     return generic_connect("System.Data", "System.Data.SqlClient.SqlConnection", connstr)
File "C:\Program Files\IronPython 2.6\lib\site-packages\kludgemssql\adonet2dbapi\generic.py" in connect
  41.     connection = connector(data)
File "C:\Program Files\IronPython 2.6\lib\site-packages\django\utils\functional.py" in __getattr__
  274.         return getattr(self._wrapped, name)
File "C:\Program Files\IronPython 2.6\lib\site-packages\django\utils\functional.py" in __getattr__
  274.         return getattr(self._wrapped, name)

Exception Type: ValueError at /
Exception Value: Keyword not supported: 'provider'.

Thanks!

-- 
mjt