Playmaker Action Requests: Table Exists? Column Exists? Etc.

[westingtyler]

Playmaker Action Requests:

I thought these actions already existed, but I went looking for them in the Action Browser, and maybe I'm thinking of a different package that has something similar.



Table Exists?
Would check to see if a Table exists with name string X, in the selected SQL file.

Column Exists?

Would check if a Column named X exists in the selected table in the selected SQL file.

Row Containing String X Exists?

Would check to see if ANY row has (starts with?) an entry with an exact string specified. For example, I want to check if the table contains a row whose leftmost entry is "Jeff" exactly.



SimpleSQL is awesome.

[echo17]

Sounds like reasonable requests. I have updated the Playmaker actions with SimpleSQL_TableExists and SimpleSQL_ColumnExists here: link

You can already handle the third request using the SimpleSQL_Query_SingleRow action and a query something like:

SELECT WeaponName FROM Weapon WHERE WeaponName LIKE 'St%'

Note that the LIKE and % is a wildcard combination and will allow you to match anything after it. You can use it in different ways like:

LIKE 'Jeff%' (matches Jeff at the beginning of the field)
LIKE '%Jeff' (matches Jeff at the end of the field)
LIKE '%Jeff%' (matches Jeff anywhere in the field)

[westingtyler]

Thanks! I'm really excited to use them. SimpleSQL is the best thing ever.

[echo17]

I'm glad you like it! Thanks for the kind words.