Package txdb is a single transaction based database sql driver. When the connection is opened, it starts a transaction and all operations performed on this sql.DB will be within that transaction. If concurrent actions are performed, the lock is acquired and connection is always released the statements and rows are not holding the connection.Why is it useful. A very basic use case would be if you want to make functional tests you can prepare a test database and within each test you do not have to reload a database. All tests are isolated within transaction and though, performs fast. And you do not have to interface your sql.DB reference in your code, txdb is like a standard sql.Driver.
https://github.com/DATA-DOG/go-txdbTags | sql-driver integration-testing tdd sql testing |
Implementation | Go |
License | BSD |
Platform | Windows MacOS Linux |
sqlmock is a mock library implementing sql/driver. Which has one and only purpose - to simulate any sql driver behavior in tests, without needing a real database connection. It helps to maintain correct TDD workflow.NOTE: in v1.2.0 sqlmock.Rows has changed to struct from interface, if you were using any type references to that interface, you will need to switch it to a pointer struct type. Also, sqlmock.Rows were used to implement driver.Rows interface, which was not required or useful for mocking and was removed. Hope it will not cause issues.
sql-driver mock database tdd testing sqlTST simplifies the task of writing and running test automation for T-SQL code. Written in T-SQL it provides an API similar to those provided by other Unit Testing frameworks. Can produce test reports in XML format. It provides automatic rollback, dataset comparison support, etc.
sql-server tst unit-test unit-testing sql sql-server-2005 tddsqlmap is an open source penetration testing tool that automates the process of detecting and exploiting SQL injection flaws and taking over of database servers. It comes with a powerful detection engine, many niche features for the ultimate penetration tester and a broad range of switches lasting from database fingerprinting, over data fetching from the database, to accessing the underlying file system and executing commands on the operating system via out-of-band connections.
penetration-testing vulnerability-scanner sql-injection pentesting security-testing testing-toolssisUnit is a unit testing framework for SQL Server Integration Services.
ssis unit-testing sql-server ssis-unit-testing testingThe Microsoft Drivers for PHP for SQL Server are PHP extensions that allow for the reading and writing of SQL Server data from within PHP scripts. The SQLSRV extension provides a procedural interface while the PDO_SQLSRV extension implements PDO for accessing data in all editions of SQL Server 2008 R2 and later (including Azure SQL DB). These drivers rely on the Microsoft ODBC Driver for SQL Server to handle the low-level communication with SQL Server.This release contains the SQLSRV and PDO_SQLSRV drivers for PHP 7 with improvements on both drivers and some limitations (see Limitations below for details). Upcoming release(s) will contain more functionality, bug fixes, and more (see Plans below for more details).
microsoft php-extension php-driver microsoft-driver sql-serverMake sure Git is installed on your machine and in your system's PATH.Go MySQL Driver is an implementation of Go's database/sql/driver interface. You only need to import the driver and can use the full database/sql API then.
mysql sql database mysql-driverRun SQL statements in SQL Azure (or SQL Server) and capture performance metrics of your SQL statements (reads, writes, CPU...) against multiple databases. Run your statements in parallel, view performance results side-by-side and export to Excel for further analysis.
performance-analysis performance-testing sql-azure sql-server sql-server-2008 tuningA string of this format can be constructed using the URL type in the net/url package.The sqlserver driver uses normal MS SQL Server syntax and expects parameters in the sql query to be in the form of either @Name or @p1 to @pN (ordinal position).
mssql-driver sqlserver-driver microsoft-sqlserverpq is a pure Go postgres driver for Go's database/sql package.
postgres-driver postgres-client postgresqlA tool for capturing and analyzing data modifications; an audit trail generator with a data modifications viewer. Helps with testing, troubleshooting and exploring application functionality. ASP.NET 3.5 C#, SMO application. Audit and CRUD generators are included.
audit-generator audit-trail-analysis smo sql-server-2008This tool takes a SQL Profiler trace file and generates a unit test that replays the same sequence of database calls found in the trace file. The unit test is designed for Visual Studio Load Test. The code generated is easily modifiable so that data variation can be included.
sql-server load-test sql-tools database performance-testing rangers sqlSQL Operations Studio is a data management tool that enables you to work with SQL Server, Azure SQL DB and SQL DW from Windows, macOS and Linux. Its feature include SQL Server Connection Management with Connection Dialog, Server Groups, Azure Integration and Registered Servers, T-SQL Query Editor with advanced coding features such as autosuggestions, error diagnostics, tooltips, formatting and peek definition, Management Dashboard supporting customizable widgets with drill-through actionable insights and lot more.
database-management dbms database-toolsRedux Saga Test Plan makes testing sagas a breeze. Whether you need to test exact effects and their ordering or just test your saga put's a specific action at some point, Redux Saga Test Plan has you covered. Redux Saga Test Plan aims to embrace both integration testing and unit testing approaches to make testing your sagas easy.
redux-saga testing-sagas testing redux-saga-testing unit-testing integration-testing redux saga test tdd bddgendry is a Go library that helps you operate database. Based on go-sql-driver/mysql, it provides a series of simple but useful tools to prepare parameters for calling methods in standard library database/sql. The name gendry comes from the role in the hottest drama The Game of Throne, in which Gendry is not only the bastardy of the late king Robert Baratheon but also a skilled blacksmith. Like the one in drama,this library also forge something which is called SQL.
SniffAir is an open-source wireless security framework which provides the ability to easily parse passively collected wireless data as well as launch sophisticated wireless attacks. SniffAir takes care of the hassle associated with managing large or multiple pcap files while thoroughly cross-examining and analyzing the traffic, looking for potential security flaws. Along with the prebuilt queries, SniffAir allows users to create custom queries for analyzing the wireless data stored in the backend SQL database. SniffAir is built on the concept of using these queries to extract data for wireless penetration test reports. The data can also be leveraged in setting up sophisticated wireless attacks included in SniffAir as modules. Tested and supported on Kali Linux, Debian and Ubuntu.
testing testing-tool pentesting penetration-testingIn order to start using goqu with your database you need to load an adapter. We have included some adapters by default. Adapters in goqu work the same way as a driver with the database in that they register themselves with goqu once loaded.
sql sql-statement sql-builder database postgresql mysql sqlite sql-query sql-generationThe Microsoft Drivers for PHP for SQL Server Driver are PHP 5 extensions that allow for the reading and writing of Microsoft SQL Server data from within PHP scripts. The extension supports all editions of Microsoft SQL Server beginning with SQL Server 2005.
sql sql-server toolsAzure Data Studio is a data management tool that enables you to work with SQL Server, Azure SQL DB and SQL DW from Windows, macOS and Linux. Go to our download page for more specific instructions.
Package ora implements an Oracle database driver. An Oracle database may be accessed through the database/sql package or through the ora package directly. database/sql offers connection pooling, thread safety, a consistent API to multiple database technologies and a common set of Go types. The ora package offers additional features including pointers, slices, nullable types, numerics of various sizes, Oracle-specific types, Go return type configuration, and Oracle abstractions such as environment, server and session.
This is a golang sql driver, to interact with Go code. currently only select is possible, but the insert/update/delete is in todo list. Also there is an example command line is available for more advanced usage in cmd/goql by running go get -u github.com/fzerorubigd/goql/... the binary is available in your GOBIN directory. you can run query against any installed package in your GOPATH via this tool.
go-ast ast sql meta-programming
We have large collection of open source products. Follow the tags from
Tag Cloud >>
Open source products are scattered around the web. Please provide information
about the open source projects you own / you use.
Add Projects.