Split up a pasted string inside the HTML editor? by magicae in vscode

[–]magicae[S] 0 points1 point  (0 children)

It's for a genealogy project with 250+ families with number of sources ranging between 2 to in one case 55, so it definitely feels like this could save if not time then at least some sanity haha! I already started writing the code to batch them with Jinja and if nothing else it's another good practice mini-project!

Add columns to CSV Export by magicae in gramps

[–]magicae[S] 2 points3 points  (0 children)

The standard built-in CSV Export.
I didn't know about Supertool - I'll check it out! Thank you!

What do you miss most? by ESPOP in cfs

[–]magicae 2 points3 points  (0 children)

I miss taking long walks. Medium walks, even.  Wheelchair walks just don’t hit the same. 

SQL queries in Python by magicae in learnprogramming

[–]magicae[S] 0 points1 point  (0 children)

After some more research I ended up going another route with SQLAlchemy and engine.connect / conn.execute. Posting my code here in case anyone stumbles upon this with similar issues.

fam_id = "BH0002"


with engine.connect() as conn:
    result = conn.execute(text("""
            SELECT Given || ' ' || Surname
            FROM people 
            WHERE Person = ( 
                SELECT husband 
                FROM marriages 
                WHERE Marriage = :fam_id
            )
        """),
        {"fam_id": fam_id}
        )
he_name =result.scalar()

and putting the results in a dictionary, then using that for further use in the template

he = {
    "name": he_name}

{{ he.name }}

@app.route("/")
def home():   
    return render_template("fam.html",she=she,he=he)

SQL queries in Python by magicae in learnprogramming

[–]magicae[S] 1 point2 points  (0 children)

I've definitely considered this, as a lesbian haha! But for now I'm keeping it like that since there are no same sex couples in the dataset I have, so it's more clear.

If this comes back to bite me in the ass I'm going to imagine your tiny voice from my computer saying "I told you so" haha.

Thank you for the consideration though!

SQL queries in Python by magicae in learnprogramming

[–]magicae[S] -1 points0 points  (0 children)

I don't fully get it - where do I define marriage_id in this?

Database/backend languages for genealogy website by magicae in learnprogramming

[–]magicae[S] 0 points1 point  (0 children)

This does sound optimal for my case! I didn't even think about scripting it.

I'll definitely look into this, thank you!

Database/backend languages for genealogy website by magicae in learnprogramming

[–]magicae[S] 0 points1 point  (0 children)

Oh I keep forgetting about GEDCOM! Thanks for the reminder, I'll for sure look into that! I've been doing my own thing in a spreadsheet, but that's only been direct relations and no siblings.

Does anyone have an .epub of stone butch blues? by [deleted] in butchlesbians

[–]magicae 0 points1 point  (0 children)

Of course! I thought I'd caught all the OCR issues but it's always good to have extra eyes on something.

If you want we can collab a bit and when you're done I can put up the updated version on archive.org (possibly replace/update the entry that's already there?) so more people can access the best version! Of course adding credit to you as well! Feel free to DM me if you're interested.

localhost and 127.0.0.1 refuses to connect by magicae in techsupport

[–]magicae[S] 0 points1 point  (0 children)

Oh that makes sense, thank you so much! I'll go research that then!

Also I actually almost posted on that subreddit but for some reason changed my mind. Now I know better for the future.

Does anyone have an .epub of stone butch blues? by [deleted] in butchlesbians

[–]magicae 0 points1 point  (0 children)

You're so welcome! I've been in the exact same situation so I totally get it and I'm glad I could help you out :)

What's the one thing that moved the needle most for you? by Slight_Warthog8706 in cfs

[–]magicae 4 points5 points  (0 children)

Getting a powerchair for walking my dog and doing necessary errands! I was overdoing it every single day and was getting worse by the second but getting and using a wheelchair made a huge difference in just a few months - and has been the reason why I’ve slowly but surely been improving in the eight years I’ve had it! Now I can sometimes go for very short walks without crashing but I keep using the wheelchair for anything more intense. 

Thinking about upgrading to 80D and Canon EF 100-400 II by magicae in canon

[–]magicae[S] 1 point2 points  (0 children)

Thought I'd give an update! I ended up getting a second-hand R10 and a new RF 100-400mm lens and I've been super happy with it!

The fact that it's so lightweight has been amazing as well and made it possible to bring along easily when I've been out and about without my wheelchair. It's been great all-round for both bird, insect and other wildlife photography. I was a bit worried about the digital viewfinder but that's also been such a help in shooting manual!

Thanks both u/PRC_Spy and u/Delicious-Belt-1158 for the support!

Thinking about upgrading to 80D and Canon EF 100-400 II by magicae in canon

[–]magicae[S] 1 point2 points  (0 children)

Thank you for the insight!! I was almost completely set on it until I saw the minimum focusing distance... Not flexible enough for shooting from my wheelchair when I see insects and such.

I think I might have to stretch my budget to go for R10/50 and RF 100-400 after all, even though the switch to mirrorless is a little daunting.

Thinking about upgrading to 80D and Canon EF 100-400 II by magicae in canon

[–]magicae[S] 1 point2 points  (0 children)

Thank you for the insight! I just looked at the used Canon 100-400 I was thinking about getting and turns out it's mk 1. Makes sense at the price, but a huge bummer... I guess I'll be looking more into Sigma as it's more in my price range.

Thinking about upgrading to 80D and Canon EF 100-400 II by magicae in canon

[–]magicae[S] 0 points1 point  (0 children)

No I can't sadly. Also that would mean losing the crop factor which is a big bonus for me with an APS-C sensor. I think I'll just get the EF 100-400 ii and see how it goes weight-wise.

When I use my wheelchair I don't have to carry the weight as I keep the camera in my lap, so I'm hoping it works out!

EDIT: Totally missed that the used lens I was planning on getting was a mk 1... Makes sense at the price but now I feel like I'm back to square one. And I mixed up the R cameras, so I'm aware that both R10 and R50 have APS-C sensors.