Hey sorry for the delay I haven't been on here in a while. I see what you're talking about when I click run sample tests but when I edit the kata I don't see the tdd code that is in the sample tests. I don't think I ever put that code in there to validate this.

When I click validate solution on the edit kata screen it works and it's using the original code for validating it. I tried republishing the kata hoping my validation code would be there but the invalid validation code still remains. Any ideas?

You're absolutely correct. I've fixed this. Sorry about that.

It wasn't quite clear to me that you needed to order by id and the test for that doesn't account for line breaks between words.

I wasn't quite sure why the Eve GetInstance method took an Adam/Human/Male as a parameter. I added an Adam parameter just to get it to pass but I'm not really sure why. Is this just some funny play on Eve originating from the rib of Adam?

Thanks. You're right it would benefit from random data entry which I know how to do I think in the preloaded area. However, to tell you the truth I haven't been able to work with variables in postgresql properly. I use MS SQL but I've been able to adapt most stuff to postgresql but for some reason whenever I try to use a variable in here it gives me grief.

For instance I wasn't going to have the sales reps capped at 3 but I went to store the count to a variable to mod the rank by the count and it didn't like it. I'll definitely look more into the random data entry mode though.

Thanks for the suggestion!

Sounds good I'll check that all out. Thanks a bunch!

Hey RLOG89, I'm trying to make my first kata and it's a SQL kata. I was wondering if you could tell me how you create and populate your tables for use in the kata?

Good kata.

I've never created a kata and I'm trying to put together a sql kata but I'm a little confused on how you create and populate your tables for use in the kata. I was wondering if you might be able to help me out if you don't mind.

Thanks!

The way I understand it, the system is setup where the amount of honor to get your next rank is the equivalent of solving 10 katas of one rank higher than your current rank.

I do C#. In C# there are a total of 3 challenges that are 1 kyu, 5 challenges that are 2 kyu and 7 challenges that are 3 kyu. That means there's no real way to advance in C# without grinding the easy ones.

The incentive to lookup solutions is already there if that's all you care about. However it doesn't make the system any more or less indicative of your skill level by making you grind lesser challenges.

Let's just call a spade a spade. The honor system isn't designed to show your skill level, it's there to make the site more successful by encouraging people to create more challenges, vote on katas and join in on community conversation and that's all.

I thought this kata was good for what it was trying to accomplish.

Matt C,

I'm currently trying to publish my first kata which is a SQL kata. I was wondering if you could help me understand how to publish it as I'm specifically having trouble figuring out how to create and populate my tables for my Kata to work. Any information you could provide would be greatly appreciated.

Thanks!

I'm trying to create a new SQL kata but I'm unsure how to create my tables for it to use.

Is there any documentation or help on how to do this?

There is no mention of order yet it requires a specific order