search

zim32 / mysql.dart

MySQL client for Dart written in Dart
BSD 3-Clause "New" or "Revised" License
67 stars 18 forks source link

Feature/unix socket connection support #32

Closed hotdang-ca closed 2 years ago

hotdang-ca commented 2 years ago

Adds MySQL Unix Socket connection support.

Includes test:

λ dart run test/mysql_client_socket.dart
00:00 +0: (setUpAll)

!!!!!!!!!!!!!!!!!!!!!
Warning this test will execute real queries to database on Socket: InternetAddress('/tmp/mysql.sock', Unix), port: 3306, dbname: testdb. Continue? y/n
!!!!!!!!!!!!!!!!!!!!!
y
00:01 +0: testing bad connection

00:01 +1: testing insert

00:01 +2: testing select

00:01 +3: testing error is thrown if syntax error

00:01 +4: testing error is thrown if null passed for not-null column

00:01 +5: testing error is thrown if syntax error in prepared stmt

00:01 +6: testing delete

00:01 +7: testing transaction

00:01 +8: testing select after transaction

00:01 +9: testing double transaction

00:01 +10: testing error is thrown if prevent double transaction

00:01 +11: testing missing param

00:01 +12: testing prepared statement

00:01 +13: testing string encoding in prepared statements

00:01 +14: testing prepared stmt select

00:01 +15: testing empty result set

00:01 +16: testing empty result for prepared statement

00:01 +17: testing multiple statements

00:01 +18: stress test: insert 5000 rows

Inserting 5000 rows...

00:05 +19: (tearDownAll)

00:05 +19: All tests passed!
zim32 commented 2 years ago

Good idea. I will check this next few days. Thanks for contribution