Tagged Questions
2
votes
1answer
16 views
SQLAlchemy with single table inheritance expunge error
I'm having an issue with python SQLAlchemy single table inheritance.
Model:
class User(Base):
__tablename__ = 'user'
userID = Column(String(64), primary_key=True)
name = ...
2
votes
1answer
26 views
query from sqlalchemy returns AttributeError: 'NoneType' object
from pox.core import core
import pox.openflow.libopenflow_01 as of
import re
import datetime
from sqlalchemy import create_engine, ForeignKey
from sqlalchemy import Column, Date, Integer, String
from ...
0
votes
1answer
23 views
error in sqlalchemy after replacing count query with exists query
class SourcetoPort(Base):
""""""
__tablename__ = 'source_to_port'
id = Column(Integer, primary_key=True)
port_no = Column(Integer)
src_address = Column(String,index=True)
...
0
votes
0answers
33 views
SQLAlchemy error MySQL server has gone away
Error OperationalError: (OperationalError) (2006, 'MySQL server has gone away') i'm already received this error when i coded project on Flask, but i cant understand why i get this error.
I have code ...
1
vote
1answer
14 views
get attribute names of class python/ get column names of query
I want to have the column names of my sqlalchemy query
but I do not find how I can do this.
I tried a few ways
first way I have tried was to make a new class, because the names had to be different ...
0
votes
1answer
27 views
sqlalchemy create_engine() if the db already exists
from pox.core import core
import pox.openflow.libopenflow_01 as of
import re
import datetime
from sqlalchemy import create_engine, ForeignKey
from sqlalchemy import Column, Date, Integer, String
from ...
0
votes
1answer
25 views
querying data from sqlalchemy database
engine = create_engine('sqlite:///nwtopology.db', echo=False)
Base = declarative_base()
class SourcetoPort(Base):
""""""
__tablename__ = 'source_to_port'
id = Column(Integer, ...
0
votes
1answer
12 views
How to generate this query in sqlalchemy?
this query used to_char abd group_by
select to_char(date_published, 'yyyymm') yo from blog group by yo;
i have try
In [3]: year_field = db.func.extract('year', ArticleModel.date_published)
In ...
0
votes
0answers
26 views
How to maintain part of data in one table using flask-admin view?
I have a table "Label" with columns :
id | name | type
The type column get 3 values:"Category","Tags","MAT", so that this one table contains three type of data.
Now, I want to only maintain the ...
1
vote
1answer
29 views
SQLAlchemy + Requests Asynchronous Pattern
I am currently working on an application where a client makes some call to a web services, some small amount of processing is done on the JSON data returned, and then that is stored in a database. I ...
0
votes
1answer
34 views
SqlAlchemy look-ahead caching?
Edit: Main Topic:
Is there a way I can force SqlAlchemy to pre-populate the session as far as it can? Syncronize as much state from the database as possible (there will be no DB updates at this ...
0
votes
1answer
16 views
Connecting to a firebird superserver on windows using sqlalchemy
I am trying to connect to a firebird super server.I have the fdb package installed.
I am trying
from sqlalchemy import create_engine
engine = create_engine ('localhost:c:\fdbb\school.fdb')
I get ...
0
votes
0answers
15 views
Accessing Postgres Namespaces from SQLAlchemy
Is it possible to create Postgresql namespaces for sets of tables from SQLAlchemy?
2
votes
3answers
33 views
How to check whether SQLAlchemy session is dirty or not
I have a SQLAlchemy Session object and would like to know whether it is dirty or not. The exact question what I would like to (metaphorically) ask the Session is: "If at this point I issue a commit() ...
0
votes
0answers
22 views
Structuring a SQLAlchemy CRUD Application
I've been writing my first application of a fair size (~ 4000 lines) and my first application that uses a database for persistence. It uses Python + SQLAlchemy. I've been struggling with the structure ...
