Hi there, I'm new to gino, I'm trying to understand the load() to make relationships.
Let's say I have something like this:
class Board(db.Model):
id = db.Column(
db.Integer,
primary_key=True,
index=True,
)
topic_id = db.Column(
db.Integer,
db.ForeignKey('topic.id'),
nullable=False,
)
class User(db.Model):
id = db.Column(
db.Integer,
primary_key=True,
index=True,
)
nickname = db.Column(
db.String(15),
nullable=False,
default='',
)
board_id = db.Column(
db.Integer,
db.ForeignKey('board.id'),
nullable=False,
)
class UserCard(db.Model):"
id = db.Column(
sa.Integer,
primary_key=True,
index=True,
)
user_id = db.Column(
db.Integer,
db.ForeignKey('user.id'),
nullable=False,
)
class Topic(db.Model):
id = db.Column(
sa.Integer,
primary_key=True,
index=True,
)
title = db.Column(
db.String(40),
nullable=False,
default='',
)Is there a way to "load" the board with all the relations? I'm not sure how to do that, thanks!
Board.distinct().load(topic=Topic, cards=UserCard.load(user=User)) to get boards
def cards(self, card): self._cards.append(card) under Board class
4 replies
def cards(self, card): self._cards.append(card) under user and def participants(self, participant): self._participants.append(participant) under board? My query looks like this:board = await UserCard.outerjoin(
User,
).outerjoin(
Board,
).outerjoin(
Topic,
).select().where(
Board.id == board_id,
).gino.load(
Board.distinct().load(
topic=Topic,
cards=UserCard.load(
user=User)
)).all()SELECT DISTINCT participant.loop_id FROM participant
WHERE (participant.loop_id not in (SELECT DISTINCT participant.loop_id FROM participant WHERE participant.account_id = ?));
2 replies
Hi folks! I'm having trouble with a Gino WHERE...IN query, perhaps you can point out what I'm doing wrong. The code used to be
query = ORMAsset.query
if asset_type is not None:
query = query.where(ORMAsset.asset_type == asset_type)
which works fine (asset_type is a string). But I want to make asset_type possibly a list, so I changed this toquery = ORMAsset.query
if asset_type is not None:
if type(asset_type) == List:
query = query.where(ORMAsset.asset_type.in_(asset_type))
else:
query = query.where(ORMAsset.asset_type == asset_type)
Gino doesn't like this, throwing asyncpg.exceptions.DataError: invalid input for query argument $3: [<AssetType.raster_tile_set: 'Raster til... (expected str, got list)
Any idea why this is failing? Apologies for the formatting, I'm trying to make it better.
2 replies
i'm basically trying to traduce this sql statement into gino:
SELECT DISTINCT participant.loop_id FROM participant WHERE (participant.loop_id not in (SELECT DISTINCT participant.loop_id FROM participant WHERE participant.account_id = ?));
You can do this or define the column with the foreign key with Column(..., ondelete="CASCADE") when defining your schema. Otherwise you may have to just use query and delete
options(db.defer('location')) in gino (ref docs)?
Figured I could exclude a field using select method of the model, i.e:
cols = [c.name for c in MyModel.__table__.c if c.name != 'large_field']
MyModel.select(*cols).where(MyModel.field != None).gino.all()Would adding it to the docs be a good idea? Is the a better way to deal with deferring fields?
7 replies