How do you deal with circular imports ? about flask-restplus-server-example HOT 6 CLOSED

Yes this is what I've been up these last minutes.
Many thanks. I resolved it with this solution plus :

	@aggregated('claims', db.Column(db.Integer))
	def unpaid_sum(self):
		return db.func.sum(Claim.amount)

from flask-restplus-server-example.

I am not completely sure I got your question, but here are some ideas:

1. You can pass a string as a first argument to the db.relationship (instead of the class object)
2. The general approach to workaround circular dependency is to import inside a function.

from flask-restplus-server-example.

@askz And what about @frol's advice about providing related model as string without importing it? Didn't it help?

patient = db.relationship(
    'Patient',
    backref=db.backref('claims', cascade="delete, delete-orphan")
)

@frol should it work?

from flask-restplus-server-example.

Hi!

In the example of @aggregated models are in the same file.

I'd try something like this http://docs.sqlalchemy.org/en/latest/orm/query.html#sqlalchemy.orm.query.Query.count in the query.

Probably @frol could suggest something more useful.

from flask-restplus-server-example.

Thanks for the quick answers.

Sorry for the missing examples.
Here it is :

@aggregated('unpaid_consultations', db.Column(db.Integer))
	def unpaid_consultations_count(self):
		return db.func.count(Patient.unpaid_consultations)
	
	unpaid_consultations = db.relationship(
		'Claim',
		primaryjoin=
				'and_(Claim.patient_id == Patient.id, Claim.invoice_id.is_(None))',
		viewonly=True
	)

This is actually working really fine.

I would like to be able to have maybe aggregate like this :

	@aggregated('unpaid_consultations', db.Column(db.Integer))
	def unpaid_sum(self):
		return db.func.sum('amount').label('unpaid_sum')

To return the sum of the amount column select by the above relationship...
I know I'm mixing things here but this is for the example.

(I know this isn't related to this project directly, I appreciate your help!)

from flask-restplus-server-example.

In fact my query is something like :

 SELECT SUM(amount) FROM claim WHERE patient_id = %d AND invoice_id IS NOT NULL;

from flask-restplus-server-example.