[sqlalchemy] Query problem with chars acute or grave
I'am using SA 0.3.11 with MySql 5.0 through MySQLdb latest stable version and I don't get results when searching string with chars acute or grave like è, é, à. I haven't found flags on SA or MySQLdb for support exotic chars, I have miss something ? --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups sqlalchemy group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~--~~~~--~~--~--~---
[sqlalchemy] Re: Connecting to a Microsoft Access Database
On Oct 16, 11:13 pm, Eddie [EMAIL PROTECTED] wrote: Having problems all day connecting and tried various apps just in case... is there anyway I could get someone to zip and host this really quick? Error * PROPFIND request failed on '/sqlalchemy/trunk' PROPFIND of '/ sqlalchemy/trunk': could not connect to server (http:// svn.sqlalchemy.org) Connect you through a proxy server ? --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups sqlalchemy group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~--~~~~--~~--~--~---
[sqlalchemy] Check object existence into a session
How I can chek if a orm class is in a session ? --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups sqlalchemy group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~--~~~~--~~--~--~---
[sqlalchemy] Re: Connecting to a Microsoft Access Database
On Oct 13, 2:13 am, Eddie [EMAIL PROTECTED] wrote:
engine = create_engine('mssql://VMCPDB', echo=True)
I think thi line is the error. Like previous post you should use access://
URI not tested:
engine = create_engine('access://VMCPDB', echo=True)
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups
sqlalchemy group.
To post to this group, send email to sqlalchemy@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~--~~~~--~~--~--~---
[sqlalchemy] Field with constant
If I would make a select with a field set to a constant like this: SELECT 1 AS field FROM foo how is the select()'s field definition ? I'v tried with: select([1], from_obj=[foo]) but field has no name. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups sqlalchemy group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~--~~~~--~~--~--~---
[sqlalchemy] Re: Problem on autoload with MS-SQL
Patch applied now and wokr like is expected. Thanks --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups sqlalchemy group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~--~~~~--~~--~--~---
[sqlalchemy] Copy Select object
What is the best way for create a clone of Select object except for columns list ? --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups sqlalchemy group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~--~~~~--~~--~--~---
[sqlalchemy] Re: Sqlalchemy and py2exe...
On 29 Mag, 18:07, pdamoc [EMAIL PROTECTED] wrote: Hello, I've tried packing an app I've made with py2exe and run into trouble... first it was an EGG issue, I've fixed that installing everything as a directory next came the sqlite issue... I simply cannot get it to work after I build the .exe I keep getting: Traceback (most recent call last): File patch.py, line 53, in module File model.pyc, line 87, in __init__ File model.pyc, line 56, in createDB File sqlalchemy\schema.pyc, line 1190, in __init__ File sqlalchemy\schema.pyc, line 1095, in __init__ File sqlalchemy\schema.pyc, line 1114, in connect File sqlalchemy\engine\__init__.pyc, line 154, in create_engine File sqlalchemy\engine\strategies.pyc, line 44, in create File sqlalchemy\engine\url.pyc, line 92, in get_dialect ImportError: unknown database 'sqlite' The app works fine when I start it as a script. any idea is welcomed! Tell py2exe to load sqlite database from sqlalchemy. This setup.py show how: #!/usr/bin/env python from distutils.core import setup import glob import py2exe def main(): setup( windows=[dict( script='myapp.py', icon_resources=[(1, myicon.ico)] )], options=dict( py2exe=dict( compressed=1, optimize=2, packages=['sqlalchemy.databases.sqlite', 'other package'] ) ) ) if __name__ == '__main__': main() --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups sqlalchemy group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~--~~~~--~~--~--~---
[sqlalchemy] Problem on autoload with MS-SQL
With this code I get an error first time I autoload a table:
from sqlalchemy import *
import pydobc
engine = create_engine('mssql://user:[EMAIL PROTECTED]/db', module=pyodbc)
meta = BoundMetaData(engine)
Table('table_x', meta, autoload=True) # Get error first time
Table('table_x', meta, autoload=True) # No error
Table('table_y', meta, autoload=True) # Get error first time
Table('table_y', meta, autoload=True) # No error
Follow traceback for my case:
Traceback (most recent call last):
File D:\lavoro\aesse periferiche\intermezzo\devel\test.py, line 7,
in ?
Table('table_x', meta, autoload=True)
File c:\python\Lib\site-packages\sqlalchemy\schema.py, line 166,
in __call__
metadata.get_engine().reflecttable(table)
File c:\python\Lib\site-packages\sqlalchemy\engine\base.py, line
798, in ref
lecttable
self.dialect.reflecttable(conn, table)
File c:\python\Lib\site-packages\sqlalchemy\databases\mssql.py,
line 492, in
reflecttable
coltype = self.ischema_names[type]
KeyError: u'timestamp'
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups
sqlalchemy group.
To post to this group, send email to sqlalchemy@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~--~~~~--~~--~--~---
[sqlalchemy] Remove columns from Select object
I have a sqlalchemy.sql.Select object where I want to remove some columns and execute the result. I've tried with remove method of columns property but when execute() is called the ResultProxy contains all the original columns. Is the right way to remove columns or exist another method ? --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups sqlalchemy group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~--~~~~--~~--~--~---
