Simple SQL table fuzzing

Fixes #18 The seed variable can be passed as a command line argument, if it is not passed the default behavior is to set the seed as 0 which will also maintain backward compatibility.

Feature request from reddit:

Does it support and understand constraints when given multiple tables? And does it handle FK? Eg; If my T2 has a FK to T1 and i fuzz them in the correct order will the tool figure it out?

So make the tool understand constrains even if the one table passed and add the feature to handle more tables with comma separated.

Currently the MySQL driver reads the table details with the DESCRIBE SQL command. It would be much cleaner if it would use the information_schema.tables just like the Postgres driver does.

Feature idea from reddit:

Is it possible to set a random seed to get reproducible random data? This would be useful for unit testing to get the same data on each run.

So the main goal of the ticket is make it possible to reproduce certain fuzzing scenarios for unit-tests. This can be done by the change of the seeding mechanism.

CodeSee is a code visibility platform.

This change updates the CodeSee workflow file to the latest version for security, maintenance, and support improvements (see changelog below).

That workflow file:

• runs CodeSee's code analysis on every PR push and merge
• uploads that analysis to CodeSee.
• It does not transmit your code.

The code analysis is used to generate maps and insights about this codebase.

CodeSee workflow changelog:

• Improved security: Updates permission to be read-only.
• Improved future maintenance: Replaces the body of the workflow with a single github action: codesee-action. This makes it significantly easier for CodeSee to introduce future improvements and fixes without requiring another PR like this.
• Improved Python support: The action now properly supports Python 3.11, and will continue to support new Python versions as they are released.

sqlfuzz expects a table to be completely clean, so if a table already contains some data it then fails:

2021/04/24 15:08:26 Error 1062: Duplicate entry '1' for key 'PRIMARY'

In my case, i can't have a completely empty table/database due to various constrains, but I do want to add e.g. 100k new records.

SHOW CREATE TABLE table spits out AUTO_INCREMENT=XX so XX should be the starting point instead of 1.

Getting an error like

2021/04/24 14:58:51 Error 1452: Cannot add or update a child row: a foreign key constraint fails (`db`.`table`, CONSTRAINT `FK_something` FOREIGN KEY (`column_from_table`) REFERENCES `other_table` (`id`) ON DELETE CASCADE ON UPDATE CASCADE)

sqlfuzz complains with unknown field type when it stumbles upon a column defined as FLOAT which doesn't have explicit length defined.

I also suspect that it has problems when it's actually defined. For example, I get this error on a table having DECIMAL(25,6):

panic: strconv.Atoi: parsing "6unsigned": invalid syntax

goroutine 25 [running]:
github.com/PumpkinSeed/sqlfuzz/drivers.length(0xc000144e60, 0x16, 0x13b1150, 0x7, 0xc00012d15a, 0x1, 0x1)
	/Users/loow/gopath/src/github.com/PumpkinSeed/sqlfuzz/drivers/helpers.go:24 +0x4b7
github.com/PumpkinSeed/sqlfuzz/drivers.MySQL.MapField(0x7ffeefbffaa3, 0x8, 0x7ffeefbffaaf, 0x6, 0x7ffeefbffab9, 0x15, 0x7ffeefbffad2, 0x9, 0x7ffeefbffadf, 0x4, ...)
	/Users/loow/gopath/src/github.com/PumpkinSeed/sqlfuzz/drivers/mysql.go:128 +0x9d3
github.com/PumpkinSeed/sqlfuzz/pkg/action.generateData(0x1457160, 0xc00012b620, 0xc000144e40, 0x15, 0xc000144e60, 0x16, 0xc00012ce79, 0x3, 0x0, 0x0, ...)
	/Users/loow/gopath/src/github.com/PumpkinSeed/sqlfuzz/pkg/action/action.go:117 +0x79
github.com/PumpkinSeed/sqlfuzz/pkg/action.SQLInsertInput.singleInsert(0xc0001548c0, 0x0, 0x13aac01, 0x101)
	/Users/loow/gopath/src/github.com/PumpkinSeed/sqlfuzz/pkg/action/action.go:107 +0x338
github.com/PumpkinSeed/sqlfuzz/pkg/action.SQLInsertInput.Insert(0xc0001548c0, 0x0, 0x7ffeefbffa01, 0x8)
	/Users/loow/gopath/src/github.com/PumpkinSeed/sqlfuzz/pkg/action/action.go:42 +0xb8
github.com/PumpkinSeed/sqlfuzz/pkg/fuzzer.worker(0xc0001025a0, 0xc00012d130, 0x7ffeefbffaa3, 0x8, 0x7ffeefbffaaf, 0x6, 0x7ffeefbffab9, 0x15, 0x7ffeefbffad2, 0x9, ...)
	/Users/loow/gopath/src/github.com/PumpkinSeed/sqlfuzz/pkg/fuzzer/runner.go:50 +0x145
created by github.com/PumpkinSeed/sqlfuzz/pkg/fuzzer.runHelper
	/Users/loow/gopath/src/github.com/PumpkinSeed/sqlfuzz/pkg/fuzzer/runner.go:28 +0x138