Wikimedia Developer Support

Can this be done in Cargo (or Semantic)?

Forgive me, this is a crosspost from r/mediawiki.

I’m trying to build a database for the theatre community in my area, sort of an IBDB, but just for Northeast Florida. (Or IMDB, if you’re not a theatre nerd.)

I want to be able to put in a list of the cast and crew members of each show’s page, and then query that list on the actor’s page.

In other words:

Show 1

Actor Character
John Smith James
Jack Doe Leonard
Bob Johnson Montgomery

Show 2

Actor Character
Jane Doe Samantha
Jennifer Smith Carrie
Bob Johnson Mr. Large

And this page would be a query:

Bob Johnson

Show Character
Show 1 Montgomery
Show 2 Mr. Large

I’ve tried to do this with Cargo, but I had to create a template that generated a table for each member of the cast. It looks like this…

Show 1

Actor Character
John Smith James

Show 1

Actor Character
Jack Doe Leonard

Show 1

Actor Character
Bob Johnson Montgomery

In my opinion, it looks dumb having that many tables on the page instead of just one table that submits all of the rows. I know how I would do this with PHP and MySQL, but apparently Cargo can only store one line in the table at a time.

I haven’t tried Semantic yet, but I wanted to ask before I dived into it.

Is it possible to submit multiple rows to Cargo at one time, or if not, is it possible to format the cargo_store template into a table with multiple rows?

If Cargo cannot do the job, is Semantic capable of it?

If you want to see what I’m working on specifically, I have it started at jaxplays.com. Right now all of the pages are manually entered. There’s no queries pulling any information.

A good show page example is A Funny Thing Happened on the Way to the Forum ,

and a good person’s page is Michael Lipp.

1 Like