Hi All,
I'm using SQLAlchemy to access a legacy MSSQL database. I'm using the
autoload feature to load the schema from the database.
In this example I'd like to read data out of the column named "1st_period"
in the database. The following query shows the SQL I'd need. But trying
to access a property named "1st_period" yields a SyntaxError
Thanks,
Rob
SELECT TOP 10 [1st_period] FROM Students;
class Student(Model):
__table__ = Table("Students", metadata, autoload=True, autoload_with=engine)
@property
def first_period(self):
return self.1st_period
--
SQLAlchemy -
The Python SQL Toolkit and Object Relational Mapper
http://www.sqlalchemy.org/
To post example code, please provide an MCVE: Minimal, Complete, and Verifiable
Example. See http://stackoverflow.com/help/mcve for a full description.
---
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/sqlalchemy/CAHUdipkSOfZhBGfXpiOu5nV1XKtbw8ML8%3DSQ40EbXO97oyoR2w%40mail.gmail.com.
