This should be easy, but I'm having real problems with it. I'd like
to do the following SQL (this is from MySQL) as a sqa query:
select count(distinct flow.node_id) as nodes, ip.ip_addr,
ip.country, ip.domain, ip.isp, ip.city from flow, ip where flow.src_id =
ip.id group by flow.src_id having nodes > 5 order by nodes desc;
I can't work out how to do the 'having nodes > 5' bit at all. All
help gratefully received!
For info, the tables look like this (with some fields missed out for
clarity):
Tables are pretty straightfoward. Slighty edited, they look like this:
owner_table = Table("node",
Column("id", Integer, primary_key=True),
[more stuff]
)
# location data based on the fields from ip2location
ip_table = Table("ip",
Column('id', Integer, primary_key=True),
Column('ip_addr', String(16), nullable=False, index=True,
unique=True),
Column('isp', Unicode, default=0.0),
Column('domain', Unicode, default=0.0),
Column('country', Unicode, default=None),
Column('city', Unicode, default=None),
)
flow_table = Table("flow",
Column("id", Integer, primary_key=True),
Column("owner_id", Integer, ForeignKey("honeypot.id"),
nullable=False),
Column("ip_proto", Integer, default=6, nullable=False),
Column("src_id", Integer, ForeignKey("ip.id"), nullable=False),
Column("dst_id", Integer, ForeignKey("ip.id"), nullable=False),
)
Then I define the obvious mappers.
Cheers,
Arthur
--
Arthur Clune
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---
