User avatar
pathetic piss kitten @kitten@elizabeth.cat
Admin
This user has been bitten by a soft cat

You found my personal account! If you know me from formal or irl spaces, you probably shouldn't look in here. Proceed at your own risk.

27
Clichéd transfem. Poly cuddle slut. Nonsexual little. Frequent meower. Kinky pervert. I pee myself a lot. I reject my own dignity.

I contribute code somewhere, but I forgot where.

I like to be referred to as "kitten" or "little one". You can do that if you want and it'll make me happy but it's not a requirement (also don't use the latter in adult contexts)

formerly @me@elizabeth.cat

"a pervert who lost control over their life"
Location Europe
Birthday 1999-03-02
Pronouns they/them (EN)
Pronouns they/them, although fem terms are also good
User avatar
pathetic piss kitten @kitten@elizabeth.cat
1mo
SQL @queerty yeah, a very circular query neocat_laugh_sweat
User avatar
pathetic piss kitten @kitten@elizabeth.cat
1mo
SQL - Answering quiz @mindpersephone yes

too much actual code in my mind blobcatgiggle
User avatar
pathetic piss kitten @kitten@elizabeth.cat
1mo
SQL spot the issue
SELECT * FROM PostEntity

JOIN ProfileEntity ON PostEntity.authorId = ProfileEntity.profileId
LEFT JOIN PostEntity AS Quote ON PostEntity.quoteId = Quote.postId
LEFT JOIN ProfileEntity AS QuoteProfile ON Quote.authorId = QuoteProfile.profileId
LEFT JOIN PostEntity AS BoostedPost ON PostEntity.boostedPostId = BoostedPost.postId
LEFT JOIN ProfileEntity AS BoostedPostProfile ON BoostedPost.authorId = BoostedPostProfile.profileId

WHERE PostEntity.authorId = :authorId || BoostedPost.authorId = :authorId
ORDER BY PostEntity.createdAt DESC;
User avatar
pathetic piss kitten @kitten@elizabeth.cat
1mo
@luna yeah
User avatar
pathetic piss kitten @kitten@elizabeth.cat
1mo
@luna but don't worry this is ÖBB they also do have segregated toilets in their trains

(.....or so have I been told)
User avatar
pathetic piss kitten @kitten@elizabeth.cat
1mo
@luna there are mixed ones and ladies-only ones
User avatar
pathetic piss kitten @kitten@elizabeth.cat
1mo
lower couchettes only available in the ladies-only compartment, hm
User avatar
pathetic piss kitten @kitten@elizabeth.cat
1mo
kink @lis meow... you know very well where to poke in my mind, Miss...
User avatar
pathetic piss kitten @kitten@elizabeth.cat
1mo
Some of your tickets have overlapping time and date. Please resolve to continue checkout
excuse me? who do you think you are?
User avatar
pathetic piss kitten @kitten@elizabeth.cat
1mo
let your kids go to sleep-away school camps neocat_cry_loud
User avatar
pathetic piss kitten @kitten@elizabeth.cat
1mo
@1 wait

no, it actually does feel right
User avatar
pathetic piss kitten @kitten@elizabeth.cat
1mo
@1 but it doesn't feel right neocat_cry
User avatar
pathetic piss kitten @kitten@elizabeth.cat
1mo
@dpk what language is this blobCat_eyes
User avatar
pathetic piss kitten @kitten@elizabeth.cat
1mo
@mindpersephone this is just for a unit test so that'll do for now
User avatar
pathetic piss kitten @kitten@elizabeth.cat
1mo
like, I know, by checking different depths, that the count is always (2^depth+1)-1

but that feels wrong blobwtfnotlikethis
User avatar
pathetic piss kitten @kitten@elizabeth.cat
1mo
what was the way to count the number of nodes in this kind of structure?
This post has attachments, but this server's configuration prevents them from being displayed here.
User avatar
pathetic piss kitten @kitten@elizabeth.cat
1mo
neocat_pleading
User avatar
pathetic piss kitten @kitten@elizabeth.cat
1mo
fun Post.unwrapPosts(): List<Post> {
	val posts = mutableListOf(this)

	if (quote != null) posts.addAll(quote.unwrapPosts())
	if (boostedPost != null) posts.addAll(boostedPost.unwrapPosts())

	return posts
}


this is going to throw CallStackSizeExceeded at some point
User avatar
pathetic piss kitten @kitten@elizabeth.cat
1mo
fun Post.unwrapQuotes(): List<Post> {
	val quotes = mutableListOf(this)
	var currentQuote = quote
	while (currentQuote != null) {
		quotes.add(0, currentQuote)
		currentQuote = currentQuote.quote
	}
	return quotes
}


what was I thinking?
User avatar
pathetic piss kitten @kitten@elizabeth.cat
1mo
I should buy an ATV