dbi_sql_test Namespace Reference

Classes
class	TestObj

Functions
def	process ()

Variables
	app = Flask(__name__)
	db = SQLAlchemy(app)

Function Documentation

process()

def dbi_sql_test.process

(

)

Definition at line 26 of file dbi_sql_test.py.

def process():
  app.config['SQLALCHEMY_DATABASE_URI'] = "sqlite:///:memory:"
  db.create_all()
  
  obj1 = TestObj()
  obj1.id = 1
  obj1.val = 10

  obj2 = TestObj()
  obj2.id = 2
  obj2.val = 20
  
  db.session.add(obj1)
  db.session.add(obj2)
  db.session.commit()

  #taskInSlotNumber = len(row_dbi.db.session.query(type(TestObj)).filter_by(rTime<rightBorderMs, state=PLANED).all())
  
  from sqlalchemy import func
  num = db.session.query(TestObj.val).group_by(TestObj.val).having(func.count(TestObj.val) < 9).all()
  print num

Variable Documentation

app

dbi_sql_test.app = Flask(__name__)

Definition at line 17 of file dbi_sql_test.py.

db

dbi_sql_test.db = SQLAlchemy(app)

Definition at line 18 of file dbi_sql_test.py.