-
as seen on Stack Overflow
- Search for 'Stack Overflow'
I'm connection to mssql server through pyodbc, via FreeTDS odbc driver, on linux ubuntu 10.04.
Sqlalchemy 0.5 uses DATETIME for sqlalchemy.Date() fields.
Now Sqlalchemy 0.6 uses DATE, but sql server 2000 doesn't have a DATE type. How can I make DATETIME be the default for sqlalchemy.Date() on sqlalchemy…
>>> More
-
as seen on Stack Overflow
- Search for 'Stack Overflow'
I'm running into this little problem that I hope is just a dumb user error. It looks like some sort of a size limit with a query to a SQLite database. I managed to reproduce the issue with an in-memory DB and a simple script shown below. I can make it work by either reducing the number of records…
>>> More
-
as seen on Stack Overflow
- Search for 'Stack Overflow'
I am quite new to SQLAlchemy, or even database programming, maybe my question is too simple.
Now I have two class/table:
class User(Base):
__tablename__ = 'users'
id = Column(Integer, primary_key=True)
name = Column(String(40))
...
class Computer(Base):
__tablename__ = 'comps'
…
>>> More
-
as seen on Stack Overflow
- Search for 'Stack Overflow'
I've set up a single table inheritance, but I need a "default" class to use when
an unknown polymorphic identity is encountered. The database is not in my
control and so the data can be pretty much anything.
A working example setup:
import sqlalchemy as sa
from sqlalchemy import orm
engine = sa…
>>> More
-
as seen on Stack Overflow
- Search for 'Stack Overflow'
I have a large set of values V, some of which are likely to exist in a table T. I would like to insert into the table those which are not yet inserted. So far I have the code:
for value in values:
s = self.conn.execute(mytable.__table__.select(mytable.value == value)).first()
…
>>> More
