| blob | 5a889c92e74e8c68a6be6dea1cc1ee227609416f |
1 //
2 // SqlSharpCli.cs - main driver for Mono SQL Query Command Line Interface
3 // found in mcs/tools/SqlSharp
4 //
5 // This program is included in Mono and is licenced under the GPL.
6 // http://www.fsf.org/licenses/gpl.html
7 //
8 // For more information about Mono,
9 // visit http://www.mono-project.com/
10 //
11 // To build SqlSharpCli.cs
12 // $ mcs /out:sqlsharp.exe SqlSharpCli.cs /r:System.Data.dll
13 //
14 // To run with mono:
15 // $ mono sqlsharp.exe
16 //
17 // To run batch commands and get the output, do something like:
18 // $ cat commands_example.txt | mono sqlsharp.exe -s > results.txt
19 //
20 // Author:
21 // Daniel Morgan <monodanmorg@yahoo.com>
22 //
23 // (C)Copyright 2002-2004, 2008 Daniel Morgan
24 //
42 Html,
43 Xml,
44 CommaSeparatedValues,
45 TabSeparated,
46 Normal
47 }
49 // SQL Sharp - Command Line Interface
50 public class SqlSharpCli
51 {
52 // provider supports
59 // {OleDb,SqlClient,MySql,Odbc,Oracle,
60 // PostgreSql,SqlLite,Sybase,Tds} however, it
61 // can be set to LOADEXTPROVIDER to load an external provider
63 // filename of assembly
64 // for example: "Mono.Data.MySql"
66 // Connection class
67 // in the provider assembly that implements the IDbConnection
68 // interface. for example: "Mono.Data.MySql.MySqlConnection"
69 Type conType;
90 // DisplayResult - used to Read() display a result set
91 // called by DisplayData()
94 {
109 Type theType;
126 // spacing
164 }
183 }
188 }
192 }
193 }
203 // column data
206 numRows++;
259 }
281 else
289 }
293 }
297 }
318 }
319 }
320 else
325 }
327 }
328 }
332 }
337 }
340 {
350 }
353 }
356 {
377 }
391 // column data
397 }
401 }
405 }
408 }
410 // DisplayData - used to display any Result Sets
411 // from execution of SQL SELECT Query or Queries
412 // called by DisplayData.
413 // ExecuteSql() only calls this function
414 // for a Query, it does not get
415 // for a Command.
417 {
422 // by Default, SqlDataReader has the
423 // first Result set if any
425 ResultSet++;
431 // SQL Query (SELECT)
432 // RecordsAffected -1 and DataTable has a reference
434 }
436 // SQL Command (INSERT, UPDATE, or DELETE)
437 // RecordsAffected >= 0
439 }
441 // SQL Command (not INSERT, UPDATE, nor DELETE)
442 // RecordsAffected -1 and DataTable has a null reference
444 }
446 // get next result set (if anymore is left)
448 }
450 // display the result in a simple way
451 // new ADO.NET providers may have not certain
452 // things implemented yet, such as, TableSchema
453 // support
455 {
459 row++;
475 else
478 }
479 }
481 }
484 {
487 }
499 }
500 }
501 }
504 {
528 }
533 }
539 }
540 }
541 }
543 }
544 }
546 // ExecuteSql - Execute the SQL Command(s) and/or Query(ies)
548 {
556 // set command properties
568 else
573 }
578 }
581 }
582 }
584 // ExecuteSql - Execute the SQL Commands (no SELECTs)
586 {
594 // set command properties
605 }
609 }
612 }
613 }
616 {
624 // set command properties
634 }
638 }
641 }
642 }
645 {
651 }
654 }
658 }
665 // set command properties
676 }
679 }
680 }
683 {
690 }
707 }
711 }
713 }
716 {
725 }
726 }
729 }
731 // like ShowHelp - but only show at the beginning
732 // only the most important commands are shown
733 // like help and quit
735 {
747 }
749 // ShowHelp - show the help - command a user can enter
751 {
787 Console.WriteLine (@" \UseSimpleReader (TRUE,FALSE) to use simple reader when displaying results.");
789 }
792 {
798 }
800 // ShowDefaults - show defaults for connection variables
802 {
808 }
814 }
815 }
823 }
824 }
826 // OpenDataSource - open connection to the data source
828 {
834 }
839 }
861 }
862 }
867 }
879 }
880 }
882 // CloseDataSource - close the connection to the data source
894 }
896 }
897 }
904 }
906 // ChangeProvider - change the provider string variable
912 }
966 }
979 }
981 }
982 else
984 }
987 {
998 @"System.Data.OracleClient, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089",
1016 @"Mono.Data.SybaseClient, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=0738eb9f132ed756",
1044 @"Mono.Data.SqliteClient, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=0738eb9f132ed756",
1081 @"FirebirdSql.Data.Firebird, Version=1.7.1.0, Culture=neutral, PublicKeyToken=0706f5520aae4ff4",
1100 }
1104 providerAssembly);
1106 providerConnectionClass);
1107 }
1108 }
1109 else
1111 }
1113 // ChangeConnectionString - change the connection string variable
1115 {
1118 else
1120 }
1126 }
1129 }
1133 }
1134 }
1137 {
1141 }
1144 }
1148 }
1149 }
1152 {
1156 }
1166 }
1172 }
1175 }
1176 }
1179 {
1183 }
1189 }
1192 }
1193 }
1196 {
1200 }
1206 else
1209 }
1212 {
1216 }
1222 else
1224 }
1227 {
1231 }
1237 else
1239 }
1242 {
1246 }
1254 }
1257 {
1261 }
1268 }
1269 }
1272 {
1278 }
1285 }
1288 {
1296 }
1297 else
1300 }
1303 }
1305 }
1308 {
1312 }
1316 }
1319 {
1324 // For example: for the MySQL provider in Mono.Data.MySql
1325 // \LoadExtProvider Mono.Data.MySql Mono.Data.MySql.MySqlConnection
1326 // \ConnectionString dbname=test
1327 // \open
1328 // insert into sometable (tid, tdesc, aint) values ('abc','def',12)
1329 // \exenonquery
1330 // \close
1331 // \quit
1344 msg = "Error: unable to load the assembly of the provider: " + providerAssembly + " : " + f.Message;
1346 }
1348 msg = "Error: unable to load the assembly of the provider: " + providerAssembly + " : " + e.Message;
1350 }
1352 }
1354 // used for outputting message, but if silent is set,
1355 // don't display
1357 {
1360 }
1362 // used for outputting the header columns of a result
1364 {
1367 }
1369 // OutputData() - used for outputting data
1370 // if an output filename is set, then the data will
1371 // go to a file; otherwise, it will go to the Console.
1373 {
1376 else
1378 }
1380 // HandleCommand - handle SqlSharpCli commands entered
1382 {
1417 // Execute SQL Commands or Queries
1428 }
1430 }
1443 }
1445 }
1458 }
1460 }
1463 // \exexml OUTPUT_FILENAME
1474 }
1476 }
1485 // Load file into SQL buffer: \load FILENAME
1489 // Save SQL buffer to file: \save FILENAME
1494 // Help
1498 // show the defaults for provider and connection strings
1506 // Quit
1511 // reset (clear) the query buffer
1515 // sets internal variable
1516 // \set name value
1520 // deletes internal variable
1521 // \unset name
1530 else
1540 // Error
1543 }
1544 }
1547 {
1551 {
1557 }
1560 }
1563 {
1577 }
1585 }
1590 }
1591 }
1592 }
1593 }
1596 {
1608 }
1612 }
1614 }
1618 }
1621 {
1628 }
1634 }
1635 }
1638 }
1642 }
1644 }
1647 {
1650 }
1653 {
1657 }
1672 }
1685 }
1686 }
1687 }
1689 }
1691 Console.Error.WriteLine("Warning: your provider does not subclass DbConnectionStringBuilder fully.");
1693 }
1697 }
1700 {
1712 }
1722 }
1724 // most likely the end of SQL Command or Query found
1725 // execute the SQL
1733 }
1735 //build.Append ("\n");
1739 }
1740 }
1742 // most likely a part of a SQL Command or Query found
1743 // append this part of the SQL
1746 }
1749 }
1750 }
1754 }
1755 }
1761 SquareBrackets // '[]' - delimited named parameter - [name]
1762 }
1764 public class ParametersBuilder
1765 {
1773 {
1787 }
1788 }
1791 {
1797 }
1802 }
1803 }
1806 {
1816 else
1818 }
1823 i++;
1830 else
1835 }
1840 numParms ++;
1842 }
1844 i++;
1845 }
1846 i--;
1849 }
1855 else
1860 }
1865 numParms ++;
1867 }
1868 i++;
1869 }
1870 i--;
1871 }
1872 }
1874 // placeholder paramaeter for ?
1877 numParms ++;
1878 }
1879 }
1880 }
1882 }
1885 {
1894 }
1895 }
1897 }
1899 public class SqlSharpDriver
1900 {
1902 {
1905 }
1906 }
1907 }