Create accountLogin

Recent searches

No recent searches

Search options

Only available when logged in.
shakedown.social is one of the many independent Mastodon servers you can use to participate in the fediverse.
A community for live music fans with roots in the jam scene. Shakedown Social is run by a team of volunteers (led by @clifff and @sethadam1) and funded by donations.

Administered by:

Server stats:

246
active users

shakedown.social: AboutStatusProfiles directoryPrivacy policy

Mastodon: AboutGet the appKeyboard shortcutsView source codev4.3.7

#sqlalchemy

0 posts0 participants0 posts today
James Bennett<p>I have a <a href="https://infosec.exchange/tags/Python" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Python</span></a> codebase using <a href="https://infosec.exchange/tags/sqlalchemy" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>sqlalchemy</span></a> Core -- *NOT* ORM -- for its data layer, and I'm currently not happy with the way it's doing data for testing. Who has a pattern for this that they actually like?</p><p>I already have ephemeral per-test-function isolation of the database, so that's taken care of.</p><p>If this were ORM I'd just use something like factory-boy, but the fact that it's Core and doesn't really map neatly to objects the way ORM stuff does rules that out. I think ideally what I'd like is some sort of declarative JSON file format or whatever that lets me provide a mapping of table names to lists of rows to insert into them, and then a pytest fixture that lets me say "load that JSON file for this test". Has anyone written something like that? Do I get to go write my own?</p>
Dr John A Stevenson<p>I am feeling extremely pleased with myself to have had some code accepted into <a href="https://fosstodon.org/tags/SQLAlchemy" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>SQLAlchemy</span></a>!</p><p>It's just a few lines to let unique constraint detection on <a href="https://fosstodon.org/tags/SQLite" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>SQLite</span></a> handle tabs, but I've been using SQLAlchemy for years, and it's in lots other <a href="https://fosstodon.org/tags/python" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>python</span></a> libraries like <a href="https://fosstodon.org/tags/pandas" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>pandas</span></a>. It's exciting that now some of the code is mine!</p><p>For non-programmers, I think this is how it must have felt to have played 2nd triangle in the orchestra doing the backing on the Beatles' Eleanor Rigby.</p><p><a href="https://github.com/sqlalchemy/sqlalchemy/pull/11759" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">github.com/sqlalchemy/sqlalche</span><span class="invisible">my/pull/11759</span></a></p>
Richard Hughes<p>Does anyone know how to make <a href="https://mastodon.social/tags/SQLAlchemy" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>SQLAlchemy</span></a> queries slightly less verbose? e.g. "SELECT firmware.filename AS firmware_filename, firmware.version_display AS firmware_version_display..." could be a lot shorter. Amazon <a href="https://mastodon.social/tags/RDS" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>RDS</span></a> truncates the query to 4096 characters....</p>
Rob Hafner :verified_bi:<p>I've got a sneak peak of my latest open source project: Paracelsus.</p><p>Long story short, I got sick of manually making database diagrams for SQLAlchemy. The data is all there, so why not generate the diagrams directly?</p><p>Paracelsus (named after the alchemist who wrote about mermaids) will read your database models and create diagrams in either Mermaid or Dot format. It can also be used to inject diagrams in markdown files as code blocks.</p><p><a href="https://hachyderm.io/tags/python" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>python</span></a> <a href="https://hachyderm.io/tags/sqlalchemy" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>sqlalchemy</span></a> <a href="https://hachyderm.io/tags/opensource" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>opensource</span></a></p><p><a href="https://github.com/tedivm/paracelsus" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="">github.com/tedivm/paracelsus</span><span class="invisible"></span></a></p>
Brian :python: :flask: :html5:<p>In Python (specifically, SQLAlchemy if possible) what's the best way to get a list of results from a relationship into a dict?</p><p>I have:</p><p>[{'id':1, 'parent':1, 'score':2}, {'id':2, 'parent':2, 'score':3}, {'id':3, 'parent':1, 'score':3},...] </p><p>And I'd like:</p><p>[{'parent':1, 'scores': [2, 3], 'parent':2, 'scores': [3],...]</p><p>The records are against a user, so already filtering for the relevant rows.</p><p>I went in circles today and I can't seem to find the right procedure. Any tips?</p><p><a href="https://fosstodon.org/tags/python" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>python</span></a> <a href="https://fosstodon.org/tags/sqlalchemy" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>sqlalchemy</span></a></p>
ExploreLive feeds
About