| blob | 6ad5aa61699934b1f5f37e5247f526de91f58e54 |
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 SqlSharpCli.cs /r:System.Data.dll
13 //
14 // To run with mono:
15 // $ mono SqlSharpCli.exe
16 //
17 // To run with mint:
18 // $ mint SqlSharpCli.exe
19 //
20 // To run batch commands and get the output, do something like:
21 // $ cat commands.txt | mono SqlSharpCli.exe > results.txt
22 //
23 // Author:
24 // Daniel Morgan <danielmorgan@verizon.net>
25 //
26 // (C)Copyright 2002-2004 Daniel Morgan
27 //
43 Html,
44 Xml,
45 CommaSeparatedValues,
46 TabSeparated,
47 Normal
48 }
50 // SQL Sharp - Command Line Interface
53 // provider supports
60 // {OleDb,SqlClient,MySql,Odbc,Oracle,
61 // PostgreSql,SqlLite,Sybase,Tds} however, it
62 // can be set to LOADEXTPROVIDER to load an external provider
64 // filename of assembly
65 // for example: "Mono.Data.MySql"
67 // Connection class
68 // in the provider assembly that implements the IDbConnection
69 // interface. for example: "Mono.Data.MySql.MySqlConnection"
70 Type conType;
88 // DisplayResult - used to Read() display a result set
89 // called by DisplayData()
107 Type theType;
108 //string dataTypeName; // native Database type
127 // spacing
139 }
153 }
158 }
168 // column data
170 rows++;
197 }
212 }
214 StringBuilder sb;
215 DateTime dt;
217 // display date in ISO format
218 // "YYYY-MM-DD HH:MM:SS"
221 // year
228 else
231 // month
234 else
237 // day
240 else
243 // hour
246 else
249 // minute
252 else
255 // second
258 else
262 }
265 }
271 }
275 }
276 }
279 // spacing
284 }
300 }
301 }
302 else
307 }
310 }
312 }
337 }
351 // column data
357 }
361 }
365 }
368 }
370 // DisplayData - used to display any Result Sets
371 // from execution of SQL SELECT Query or Queries
372 // called by DisplayData.
373 // ExecuteSql() only calls this function
374 // for a Query, it does not get
375 // for a Command.
384 // by Default, SqlDataReader has the
385 // first Result set if any
387 ResultSet++;
393 // SQL Query (SELECT)
394 // RecordsAffected -1 and DataTable has a reference
396 }
398 // SQL Command (INSERT, UPDATE, or DELETE)
399 // RecordsAffected >= 0
401 }
403 // SQL Command (not INSERT, UPDATE, nor DELETE)
404 // RecordsAffected -1 and DataTable has a null reference
406 }
408 // get next result set (if anymore is left)
410 }
412 // display the result in a simple way
413 // new ADO.NET providers may have not certain
414 // things implemented yet, such as, TableSchema
415 // support
421 row++;
437 else
440 }
441 }
443 }
448 }
460 }
461 }
462 }
467 ParametersBuilder parmsBuilder =
490 }
495 }
501 }
502 }
503 }
505 }
506 }
508 // ExecuteSql - Execute the SQL Command(s) and/or Query(ies)
519 // set command properties
531 else
536 }
539 // msg = "Error: " + e.Message;
541 //if(reader != null) {
542 // if(reader.IsClosed == false)
543 // reader.Close();
545 //}
546 }
548 // cmd.Dispose();
550 }
551 }
553 // ExecuteSql - Execute the SQL Commands (no SELECTs)
564 // set command properties
575 }
579 }
581 // cmd.Dispose();
583 }
584 }
596 // set command properties
606 }
610 }
612 // cmd.Dispose();
614 }
615 }
623 }
626 }
631 }
640 // set command properties
657 filename);
661 }
664 exexml);
665 }
666 }
669 IDbConnection connection) {
688 }
693 }
696 IDbConnection connection) {
706 }
707 }
710 }
712 // like ShowHelp - but only show at the beginning
713 // only the most important commands are shown
714 // like help and quit
727 }
729 // ShowHelp - show the help - command a user can enter
761 Console.WriteLine(@" \UseSimpleReader (TRUE,FALSE) to use simple reader when displaying results.");
763 }
771 }
773 // ShowDefaults - show defaults for connection variables
782 providerAssembly);
784 providerConnectionClass);
785 }
786 }
794 }
795 }
797 // OpenDataSource - open connection to the data source
818 }
819 }
825 }
833 }
838 }
839 }
841 // CloseDataSource - close the connection to the data source
850 }
854 }
856 }
857 }
859 // ChangeProvider - change the provider string variable
870 @"System.Data.OracleClient, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089",
888 @"Mono.Data.SybaseClient, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=0738eb9f132ed756",
907 @"Mono.Data.SqliteClient, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=0738eb9f132ed756",
944 @"FirebirdSql.Data.Firebird, Version=1.6.3.0, Culture=neutral, PublicKeyToken=e1b4f92304d7b12f",
963 }
967 providerAssembly);
969 providerConnectionClass);
970 }
971 }
972 else
974 }
976 // ChangeConnectionString - change the connection string variable
981 else
983 }
989 }
992 }
997 }
998 }
1004 }
1007 }
1012 }
1013 }
1019 }
1029 }
1035 }
1039 }
1040 }
1046 }
1052 }
1056 }
1057 }
1063 }
1069 else
1072 }
1078 }
1084 else
1086 }
1092 }
1098 else
1100 }
1106 }
1114 }
1120 }
1125 }
1129 }
1130 }
1138 }
1145 }
1155 }
1156 else
1159 }
1163 }
1165 }
1171 }
1175 }
1182 // For example: for the MySQL provider in Mono.Data.MySql
1183 // \LoadExtProvider Mono.Data.MySql Mono.Data.MySql.MySqlConnection
1184 // \ConnectionString dbname=test
1185 // \open
1186 // insert into sometable (tid, tdesc, aint) values ('abc','def',12)
1187 // \exenonquery
1188 // \close
1189 // \quit
1203 }
1206 providerAssembly +
1209 }
1212 providerAssembly +
1215 }
1217 }
1219 // used for outputting message, but if silent is set,
1220 // don't display
1224 }
1226 // used for outputting the header columns of a result
1230 }
1232 // OutputData() - used for outputting data
1233 // if an output filename is set, then the data will
1234 // go to a file; otherwise, it will go to the Console.
1238 else
1240 }
1242 // HandleCommand - handle SqlSharpCli commands entered
1272 // Execute SQL Commands or Queries
1283 }
1285 }
1298 }
1300 }
1313 }
1315 }
1318 // \exexml OUTPUT_FILENAME
1329 }
1331 }
1340 // Load file into SQL buffer: \load FILENAME
1344 // Save SQL buffer to file: \save FILENAME
1349 // Help
1353 // show the defaults for provider and connection strings
1358 // Quit
1363 // reset (clear) the query buffer
1367 // sets internal variable
1368 // \set name value
1372 // deletes internal variable
1373 // \unset name
1382 else
1392 // Error
1395 }
1396 }
1412 }
1420 }
1425 }
1426 }
1427 }
1428 }
1436 }
1442 }
1443 }
1447 }
1450 }
1452 }
1467 }
1477 }
1479 // most likely the end of SQL Command or Query found
1480 // execute the SQL
1488 }
1490 //build.Append("\n");
1494 }
1495 }
1497 // most likely a part of a SQL Command or Query found
1498 // append this part of the SQL
1501 }
1504 }
1505 }
1509 }
1510 }
1516 SquareBrackets // '[]' - delimited named parameter - [name]
1517 }
1541 }
1542 }
1550 }
1555 }
1556 }
1571 else
1573 }
1578 i++;
1585 else
1590 }
1595 numParms ++;
1597 }
1599 i++;
1600 }
1601 i--;
1604 }
1610 else
1615 }
1620 numParms ++;
1622 }
1623 i++;
1624 }
1625 i--;
1626 }
1627 }
1629 // placeholder paramaeter for ?
1632 numParms ++;
1633 }
1634 }
1635 }
1637 }
1648 }
1649 }
1650 }
1656 }
1657 }
1658 }