100+ results for '/sql'

Not the results you expected?

signup.spec(jasmine).js (https://gitlab.com/x33n/generator-angular-fullstack) JavaScript · 64 lines

3 var config = browser.params;<% if (filters.mongooseModels) { %>

4 var UserModel = require(config.serverConfig.root + '/server/api/user/user.model');<% } %><% if (filters.sequelizeModels) { %>

5 var UserModel = require(config.serverConfig.root + '/server/sqldb').User;<% } %>

6

7 describe('Signup View', function() {

CleanSpec.mk (https://gitlab.com/brian0218/rk3288_r-box_android4.4.2_sdk) Makefile · 50 lines

20 #

21 # E.g.:

22 # $(call add-clean-step, touch -c external/sqlite/sqlite3.h)

23 # $(call add-clean-step, rm -rf $(PRODUCT_OUT)/obj/STATIC_LIBRARIES/libz_intermediates)

24 #

DataObjectBase.class.php (https://github.com/md-tech/openemr.git) PHP · 97 lines

1 <?php

2 require (dirname(__FILE__) . "/../sql.inc");

3

4 class DataObjectBase {

CleanSpec.mk (https://bitbucket.org/aways/android_libcore.git) Makefile · 50 lines

21 #

22 # E.g.:

23 # $(call add-clean-step, touch -c external/sqlite/sqlite3.h)

24 # $(call add-clean-step, rm -rf $(OUT)/obj/STATIC_LIBRARIES/libz_intermediates)

25 #

sql-database-point-in-time-restore-portal.md (https://gitlab.com/yeah568/azure-content) Markdown · 53 lines

36 4. At the top of your database's blade, select **Restore**:

37

38 ![Restore an Azure SQL database](./media/sql-database-point-in-time-restore-portal/restore.png)

39

40 5. Specify a database name, point in time and then click Ok:

41

42 ![Restore an Azure SQL database](./media/sql-database-point-in-time-restore-portal/restore-details.png)

43

44

coverage_calculator_test.php (https://github.com/GunioRobot/eglooframework.git) PHP · 65 lines

5 function skip() {

6 $this->skipIf(

7 !file_exists('DB/sqlite.php'),

8 'The Coverage extension needs to have PEAR installed');

9 }

SqlMigrationSchemaOperation.cs (https://github.com/fitzchak/ravendb.git) C# · 62 lines

41 public override HttpRequestMessage CreateRequest(JsonOperationContext ctx, ServerNode node, out string url)

42 {

43 url = $"{node.Url}/databases/{node.Database}/admin/sql-migration/schema?{nameof(ConnectionStringName)}={ConnectionStringName}";

44

45 var request = new HttpRequestMessage

createtableSQL.wsdl (https://bitbucket.org/pymma/openesb-components.git) Web Services Description Language · 39 lines

1 <?xml version="1.0" encoding="UTF-8"?>

2 <definitions name="createtableSQL" targetNamespace="http://com.sun.jbi/sqlse/sqlseengine" xmlns:tns="http://com.sun.jbi/sqlse/sqlseengine" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:plink="http://docs.oasis-open.org/wsbpel/2.0/plnktype" xmlns:soap="http://schemas.xmlsoap.org/wsdl/soap/" xmlns:slnk="http://schemas.xmlsoap.org/ws/2002/07/service-link/" xmlns="http://schemas.xmlsoap.org/wsdl/">

3 <types>

4 <xsd:schema elementFormDefault="qualified" targetNamespace="http://com.sun.jbi/sqlse/sqlseengine" xmlns:xsd="http://www.w3.org/2001/XMLSchema">

glance-registry.conf.erb (https://github.com/blackantcloud/openstack-chef.git) Ruby HTML · 59 lines

24 # SQLAlchemy connection string for the reference implementation

25 # registry server. Any valid SQLAlchemy connection string is fine.

26 # See: http://www.sqlalchemy.org/docs/05/reference/sqlalchemy/connections.html#sqlalchemy.create_engine

27 sql_connection = <%= @sql_connection %>

28

Makefile (https://github.com/sanyaade/sqlitejdbc.git) Makefile · 67 lines

3 # No auto-goop. Just try typing 'make'. You should get two interesting files:

4 # build/TARGET_OS/LIBNAME

5 # build/sqlitejdbc-vXXX-native.jar

6 #

7 # To combine these, type:

30 cd build && jar cf $(sqlitejdbc)-native.jar $(java_classlist)

31

32 build/$(target)/$(LIBNAME): build/$(sqlite)-$(target)/sqlite3.o build/org/sqlite/NativeDB.class

33 @mkdir -p build/$(target)

34 $(JAVAH) -classpath build -jni -o build/NativeDB.h org.sqlite.NativeDB

35 $(CC) $(CFLAGS) -c -o build/$(target)/NativeDB.o \

36 src/org/sqlite/NativeDB.c

37 $(CC) $(CFLAGS) $(LINKFLAGS) -o build/$(target)/$(LIBNAME) \

38 build/$(target)/NativeDB.o build/$(sqlite)-$(target)/*.o

42 @mkdir -p build/$(sqlite)-$*

43 unzip -qo dl/$(sqlite)-amal.zip -d build/$(sqlite)-$*

44 perl -pi -e "s/sqlite3_api;/sqlite3_api = 0;/g" \

45 build/$(sqlite)-$*/sqlite3ext.h

index.js (https://gitlab.com/harsh_0/demo) JavaScript · 103 lines

9 mongodb: '@keyv/mongo',

10 mongo: '@keyv/mongo',

11 sqlite: '@keyv/sqlite',

12 postgresql: '@keyv/postgres',

13 postgres: '@keyv/postgres',

sqlite_adapter_rb.html (https://github.com/kchasel/microscopy.git) HTML · 108 lines

52 <tr class="top-aligned-row">

53 <td><strong>Path:</strong></td>

54 <td>vendor/rails/activerecord/lib/active_record/connection_adapters/sqlite_adapter.rb

55 </td>

56 </tr>

sqlite3_adapter_rb.html (https://github.com/kchasel/microscopy.git) HTML · 108 lines

52 <tr class="top-aligned-row">

53 <td><strong>Path:</strong></td>

54 <td>vendor/rails/activerecord/lib/active_record/connection_adapters/sqlite3_adapter.rb

55 </td>

56 </tr>

74

75 <div class="name-list">

76 active_record/connection_adapters/sqlite_adapter&nbsp;&nbsp;

77 </div>

78 </div>

statement.ipp (https://gitlab.com/storedmirrors/minix) C++ Header · 52 lines

30 #define UTILS_SQLITE_STATEMENT_IPP

31

32 #include "utils/sqlite/statement.hpp"

33

34

sql-database-restore-deleted-database-portal.md (https://gitlab.com/apachipa/azure-content) Markdown · 58 lines

33 3. Navigate to the server with the deleted database you want to restore and select the server

34 4. Scroll down to the **operations** section of your server blade and select **Deleted databases**:

35 ![Restore an Azure SQL database](./media/sql-database-restore-deleted-database-portal/restore-deleted-trashbin.png)

36 5. Select the deleted database you want to restore.

37 6. Specify a database name, and click Ok:

38

39 ![Restore an Azure SQL database](./media/sql-database-restore-deleted-database-portal/restore-deleted.png)

40

41 ## Next steps

sql.php (https://github.com/elinw/joomla-cms.git) PHP · 97 lines

10 if (!class_exists('JFormFieldSql'))

11 {

12 require_once JPATH_LIBRARIES . '/joomla/form/fields/sql.php';

13 }

14

Rakefile (https://github.com/SQLDroid/SQLDroid.git) Rakefile · 70 lines

1 require 'fileutils'

2 require File.expand_path 'lib/sqldroid/version', File.dirname(__FILE__)

3 require 'rake/clean'

4

18 JAR = "sqldroid-#{SQLDroid::MAVEN_VERSION}.jar"

19 JAR_IN_TARGET = "#{TARGET_DIR}/#{JAR}"

20 LIB_DIR = File.expand_path 'lib/sqldroid'

21 JAR_IN_GEM = "#{LIB_DIR}/#{JAR}"

22 GEM_BASE_FILE = "sqldroid-#{SQLDroid::VERSION}-java.gem"

25

26 CLEAN.include('target')

27 CLOBBER.include('target', 'lib/sqldroid/sqldroid-*.jar')

28

29 desc 'Generate the binary and source jars'

35

36 file JAR_IN_GEM => JAR_IN_TARGET do

37 FileUtils.rm_rf Dir["#{LIB_DIR}/sqldroid-*.jar"]

38 FileUtils.cp JAR_IN_TARGET, JAR_IN_GEM

39 end

workfile.rb (https://github.com/asarrafi/MoSync.git) Ruby · 67 lines

7 @SOURCES = [".", "./thread", "./Skinning", "../../base", "../../base/thread", "../../../../intlibs/hashmap"]

8 @IGNORED_FILES = ["Image.cpp", "audio.cpp"]

9 common_includes = [".", "../../base", "../../../../intlibs/sqlite"]

10 common_libraries = ["SDL", "SDLmain", "SDL_ttf"]

11 @SPECIFIC_CFLAGS = {"SDL_prim.c" => " -Wno-float-equal -Wno-unreachable-code",

pessimistic.rb (https://github.com/bublanina/masterlanguage.git) Ruby · 56 lines

42 # Database-specific information on row locking:

43 # MySQL: http://dev.mysql.com/doc/refman/5.1/en/innodb-locking-reads.html

44 # PostgreSQL: http://www.postgresql.org/docs/8.1/interactive/sql-select.html#SQL-FOR-UPDATE-SHARE

45 module Pessimistic

46 # Obtain a row lock on this record. Reloads the record to obtain the requested

upgrade-3.4.0.1.0-3.4.0.2.0.sql (https://github.com/cognovis/project-open.git) SQL · 91 lines

1 -- upgrade-3.4.0.1.0-3.4.0.2.0.sql

2

3 SELECT acs_log__debug('/packages/intranet-timesheet2-invoices/sql/postgresql/upgrade/upgrade-3.4.0.1.0-3.4.0.2.0.sql','');

4

5

statement.html (https://github.com/Tekki/sql-ledger.git) HTML · 125 lines

14 </h4>

15 </td>

16 <th><img src=http://www.sql-ledger.org/images/sql-ledger.png border=0 width=80 height=58></th>

17 <td align=right>

18 <h4>

Makefile (https://github.com/johnnywalker/freebsd-ports.git) Makefile · 72 lines

34 src/activeqt src/gui src/multimedia src/network src/opengl \

35 src/openvg src/phonon src/qt3support src/s60installs \

36 src/s60main src/script src/scripttools src/sql src/svg \

37 src/testlib src/tools src/winmain src/xmlpatterns \

38 src/3rdparty/clucene src/3rdparty/freetype \

RoadNetworkCreator.cpp (https://github.com/martin-kolinek/OpenStreetNav.git) C++ · 76 lines

7

8 #include "RoadNetworkCreator.h"

9 #include "../sqllib/sqllib.h"

10 #include "../util/groupingiterator.h"

11 #include "AllWayLister.h"

driver_rb.html (https://github.com/drnic/instantrails.git) HTML · 108 lines

52 <tr class="top-aligned-row">

53 <td><strong>Path:</strong></td>

54 <td>lib/sqlite3/driver/native/driver.rb

55 </td>

56 </tr>

driver_rb.html (https://github.com/drnic/instantrails.git) HTML · 108 lines

52 <tr class="top-aligned-row">

53 <td><strong>Path:</strong></td>

54 <td>lib/sqlite3/driver/dl/driver.rb

55 </td>

56 </tr>

default.rb (https://github.com/kalos/chef-cookbooks.git) Ruby · 89 lines

76

77 if (@node[:proftpd][:sql] == "on")

78 template "#{node[:proftpd][:dir]}/#{node[:proftpd][:dir_extra_conf]}/sql.conf" do

79 source "sql.conf.erb"

80 mode 0644

database_util.cc (https://gitlab.com/0072016/Facebook-SDK-) C++ · 77 lines

8 #include "ipc/ipc_sync_message_filter.h"

9 #include "third_party/WebKit/public/platform/WebString.h"

10 #include "third_party/sqlite/sqlite3.h"

11

12 using blink::Platform;

package.html (https://github.com/Evervolv/android_frameworks_base.git) HTML · 54 lines

13

14 <p>The Android SDK and Android emulators both include the

15 <a href="{@docRoot}studio/command-line/sqlite3.html">sqlite3</a> command-line

16 database tool. On your development machine, run the tool from the

17 <code>platform-tools/</code> folder of your SDK. On the emulator, run the tool

sqlite_database_tasks_rb.html (https://github.com/jparker/api-doc-mirror.git) HTML · 98 lines

27

28 <li>

29 .bundle/gems/activerecord-4.2.5.1/lib/active_record/tasks/sqlite_database_tasks.rb

30

31 </li>

sqlite_database_tasks_rb.html (https://github.com/jparker/api-doc-mirror.git) HTML · 98 lines

27

28 <li>

29 .bundle/gems/activerecord-4.1.8/lib/active_record/tasks/sqlite_database_tasks.rb

30

31 </li>

sql-masterdetail-masterdetail-pro.html (https://github.com/Fale/qtmoko.git) HTML · 38 lines

26

27 # install

28 target.path = $$[QT_INSTALL_EXAMPLES]/sql/masterdetail

29 sources.files = $$SOURCES *.h $$RESOURCES $$FORMS masterdetail.pro *.xml images

30 sources.path = $$[QT_INSTALL_EXAMPLES]/sql/masterdetail

M000057.html (https://github.com/wholly/rockstar-rails-stack.git) HTML · 26 lines

11 </head>

12 <body class="standalone-code">

13 <pre><span class="ruby-comment cmt"># File lib/sqlite3/driver/dl/driver.rb, line 101</span>

14 <span class="ruby-keyword kw">def</span> <span class="ruby-identifier">result_text</span>( <span class="ruby-identifier">func</span>, <span class="ruby-identifier">text</span>, <span class="ruby-identifier">utf16</span>=<span class="ruby-keyword kw">false</span> )

15 <span class="ruby-identifier">method</span> = <span class="ruby-keyword kw">case</span> <span class="ruby-identifier">utf16</span>

innodb_misc_patch.patch (https://github.com/knielsen/gentoo-mysql-extra.git) Patch · 64 lines

41

42 /* Note that if the search mode was GE or G, then the cursor

43 diff -ru mysql-5.0.84_p_orig/sql/ha_innodb.cc mysql-5.0.84/sql/ha_innodb.cc

44 --- mysql-5.0.84_p_orig/sql/ha_innodb.cc 2009-08-27 16:06:21.000000000 +0900

45 +++ mysql-5.0.84/sql/ha_innodb.cc 2009-08-28 09:33:38.000000000 +0900

46 @@ -394,6 +394,18 @@

47 }

qsqldrivercreatorbase-members.html (https://github.com/muromec/qtopia-ezx.git) HTML · 27 lines

3 PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "DTD/xhtml1-strict.dtd">

4 <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">

5 <!-- /home/test1/tmp/qtopia/qt//qtopia-core-opensource-src-4.3.6/src/sql/kernel/qsqldatabase.cpp -->

6 <head>

7 <title>Qt 4.3: List of All Members for QSqlDriverCreatorBase</title>

redumpall.sh (https://github.com/GunioRobot/ezpublish.git) Shell · 326 lines

1 #!/bin/bash

2

3 . ./bin/shell/sqlcommon.sh

4 . ./bin/shell/common.sh

5

184

185 echo "Handling `ez_color_em MySQL` schema"

186 ./bin/shell/sqlredump.sh --mysql $PARAM_EZ_MYSQL_ALL $PAUSE --sql-schema-file="$TEMP_MYSQL_SCHEMA_FILE" --sql-schema-only "$DBNAME" "$KERNEL_GENERIC_SCHEMA_FILE" "$MYSQL_SCHEMA_UPDATES"

187

188 if [ $? -ne 0 ]; then

201

202 echo "Handling `ez_color_em PostgreSQL` schema"

203 ./bin/shell/sqlredump.sh --postgresql $PARAM_EZ_POSTGRESQL_ALL $PAUSE --sql-schema-file="$TEMP_POSTGRESQL_SCHEMA_FILE" --sql-schema-only --setval-file=$KERNEL_POSTGRESQL_SETVAL_FILE "$DBNAME" "$KERNEL_GENERIC_SCHEMA_FILE" "$POSTGRESQL_SCHEMA_UPDATES"

204 if [ $? -ne 0 ]; then

205 echo "Failed re-dumping SQL file `ez_color_file $KERNEL_POSTGRESQL_SCHEMA_FILE`"

DesignationDA.cs (https://bitbucket.org/saadaziz/cold-storage-management-vertex.git) C# · 265 lines

47 SqlConnection con = null;

48 SqlCommand com = null;

49 //SqlTransaction trans = null;

50

51 try

82 SqlConnection con = null;

83 SqlCommand com = null;

84 //SqlTransaction trans = null;

85

86 try

ModelParser.cs (https://RSSReportRetriever.svn.codeplex.com/svn) C# · 70 lines

13 public bool LoadSMDL(string smdl)

14 {

15 myNamespaceMgr.AddNamespace("ds", "http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling");

16

17 doc.LoadXml(smdl);

PageHeaderFooterType.cs (https://gtamereport.svn.codeplex.com/svn) C# · 76 lines

12 [System.CodeDom.Compiler.GeneratedCode("xsd", "2.0.50727.42")]

13 [System.ComponentModel.DesignerCategory("code")]

14 [System.Xml.Serialization.XmlType(Namespace = "http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition")]

15 public class PageHeaderFooterType

16 {

ColumnType.html (https://github.com/toy/rb.git) HTML · 94 lines

22 <ul class="files">

23

24 <li><a href="../../../files/lib/sqlite3/constants_rb.html">lib/sqlite3/constants.rb</a></li>

25

26 </ul>

poco-1.3.5_RH-old-SQLite.patch (git://github.com/repoforge/rpms.git) Patch · 52 lines ✨ Summary

The patch code updates SQLite API compatibility, adding a new macro SQLITE_LOCKED_SHAREDCACHE to make the build compatible with more recent versions of SQLite. It also removes an unused function call and modifies another function to use the newer SQLite API. The changes aim to improve compatibility and fix potential issues with older SQLite versions.

1 diff -up poco-1.3.5-all/Data/SQLite/include/Poco/Data/SQLite/SQLite.h.old-sqlite poco-1.3.5-all/Data/SQLite/include/Poco/Data/SQLite/SQLite.h

2 --- poco-1.3.5-all/Data/SQLite/include/Poco/Data/SQLite/SQLite.h.old-sqlite 2010-04-06 14:39:21.000000000 +0200

3 +++ poco-1.3.5-all/Data/SQLite/include/Poco/Data/SQLite/SQLite.h 2010-04-06 14:40:44.000000000 +0200

4 @@ -66,6 +66,11 @@

5 #define SQLite_API

14 //

15 // Automatically link Data library.

16 diff -up poco-1.3.5-all/Data/SQLite/src/Connector.cpp.old-sqlite poco-1.3.5-all/Data/SQLite/src/Connector.cpp

17 --- poco-1.3.5-all/Data/SQLite/src/Connector.cpp.old-sqlite 2010-04-06 14:34:27.000000000 +0200

37 }

38

39 diff -up poco-1.3.5-all/Data/SQLite/src/SQLiteStatementImpl.cpp.old-sqlite poco-1.3.5-all/Data/SQLite/src/SQLiteStatementImpl.cpp

40 --- poco-1.3.5-all/Data/SQLite/src/SQLiteStatementImpl.cpp.old-sqlite 2009-05-12 20:22:14.000000000 +0200

49 {

50 if (pStmt)

51 diff -up poco-1.3.5-all/Data/SQLite/src/Utility.cpp.old-sqlite poco-1.3.5-all/Data/SQLite/src/Utility.cpp

52

pdao.go (https://github.com/eolinker/goku-api-gateway.git) Go · 116 lines

2

3 import (

4 "database/sql"

5 "sync"

6 )

setup_configure_db.inc (http://flumpshop.googlecode.com/svn/trunk/) Pascal · 57 lines

30 global $dbConn, $configure_log;

31 $current_version++;

32 while (file_exists(dirname(__FILE__)."/../sql/DBUpgrade_v".$current_version.".sql")) {

33 $configure_log .= "Running DBUpgrade (v$current_version...)<br />";

34 $qry = implode("",file(dirname(__FILE__)."/../sql/DBUpgrade_v".$current_version.".sql"));

47 } else {

48 $configure_log .= 'No previous installation found. Preparing database.<br />';

49 $dbConn->multi_query(file_get_contents(dirname(__FILE__)."/../sql/install.sql"),true);

50 $configure_log .= 'Database installed. Running upgrades.<br />';

51 DBUpgrade(1);

53

54 $configure_log .= 'Database upgraded. Resetting values.<br />';

55 $dbConn->multi_query(file_get_contents(dirname(__FILE__)."/../sql/reset.sql"),true);

56

57 $configure_log .= 'Database ready.<br />';

cpu_info.cpp (https://github.com/facebook/osquery.git) C++ · 65 lines

11 #include <osquery/core/tables.h>

12 #include <osquery/logger/logger.h>

13 #include <osquery/sql/sql.h>

14

15 #include <osquery/utils/conversions/tryto.h>

UserTest.php (https://bitbucket.org/resourcemode/smodels.git) PHP · 269 lines

24 public function setUp() {

25 AllTests::truncateTables();

26 AllTests::executeSQLFile('C:/wamp/www/smodels/smodels/sql/test/user.sql');

27 }

28

date_sumup.rb (https://github.com/answer/ans-model-helpers.git) Ruby · 162 lines

1 # vi: set fileencoding=utf-8

2

3 require "ans-model-helpers/shared_examples/sql"

4

5 shared_examples_for "Ans::Model::Helpers::DateSumup" do

Emptying_an_index.md (https://github.com/manticoresoftware/manticoresearch.git) Markdown · 125 lines

34

35 ```http

36 POST /sql -d "mode=raw&query=truncate table products"

37 ```

38

92

93 ```http

94 POST /sql -d "mode=raw&query=truncate table products with reconfigure"

95 ```

96

sql-statement-show-analyze-status.md (https://github.com/pingcap/docs.git) Markdown · 53 lines

2 title: SHOW ANALYZE STATUS

3 summary: An overview of the usage of SHOW ANALYZE STATUS for the TiDB database。

4 aliases: ['/docs/dev/sql-statements/sql-statement-show-analyze-status/']

5 ---

6

13 **ShowStmt:**

14

15 ![ShowStmt](/media/sqlgram/ShowStmt.png)

16

17 **ShowTargetFilterable:**

18

19 ![ShowTargetFilterable](/media/sqlgram/ShowTargetFilterable.png)

20

21 ## Examples

Creating_a_replication_cluster.md (https://github.com/manticoresoftware/manticoresearch.git) Markdown · 64 lines

21

22 ```json

23 POST /sql -d "mode=raw&query=

24 CREATE CLUSTER posts

25 "

26 POST /sql -d "mode=raw&query=

27 CREATE CLUSTER click_query '/var/data/click_query/' as path

28 "

29 POST /sql -d "mode=raw&query=

30 CREATE CLUSTER click_query '/var/data/click_query/' as path, 'clicks_mirror1:9312,clicks_mirror2:9312,clicks_mirror3:9312' as nodes

31 "

sql-statement-drop-user.md (https://github.com/pingcap/docs.git) Markdown · 73 lines

2 title: DROP USER | TiDB SQL Statement Reference

3 summary: An overview of the usage of DROP USER for the TiDB database.

4 aliases: ['/docs/dev/sql-statements/sql-statement-drop-user/','/docs/dev/reference/sql/statements/drop-user/']

5 ---

6

14 **DropUserStmt:**

15

16 ![DropUserStmt](/media/sqlgram/DropUserStmt.png)

17

18 **Username:**

68 ## See also

69

70 * [CREATE USER](/sql-statements/sql-statement-create-user.md)

71 * [ALTER USER](/sql-statements/sql-statement-alter-user.md)

72 * [SHOW CREATE USER](/sql-statements/sql-statement-show-create-user.md)

73 * [Privilege Management](/privilege-management.md)

74

sql-statement-insert.md (https://github.com/pingcap/docs.git) Markdown · 112 lines

2 title: INSERT | TiDB SQL Statement Reference

3 summary: An overview of the usage of INSERT for the TiDB database.

4 aliases: ['/docs/dev/sql-statements/sql-statement-insert/','/docs/dev/reference/sql/statements/insert/']

5 ---

6

33 **TableName:**

34

35 ![TableName](/media/sqlgram/TableName.png)

36

37 **PartitionNameListOpt:**

109 * [DELETE](/sql-statements/sql-statement-delete.md)

110 * [SELECT](/sql-statements/sql-statement-select.md)

111 * [UPDATE](/sql-statements/sql-statement-update.md)

112 * [REPLACE](/sql-statements/sql-statement-replace.md)

113

upload_to_bq.py (https://github.com/gtoonstra/etl-with-airflow.git) Python · 73 lines

34 schedule_interval="@daily",

35 dagrun_timeout=timedelta(minutes=60),

36 template_searchpath='/usr/local/airflow/sql',

37 default_args=args,

38 max_active_runs=1)

106.c (https://github.com/1N3/PrivEsc.git) C · 103 lines

40 #define ALG_MASK 0xfffffff4

41 #define ADDR 1000

42 #define DB2LICM "/home/db2inst1/sqllib/adm/db2licm"

43

44 #define DFL_ALG 4

READme.md (https://github.com/oracle/oracle-db-tools.git) Markdown · 53 lines

12 Required: [Download ORDS](http://www.oracle.com/technetwork/developer-tools/rest-data-services/downloads/index.html)

13

14 Required: [Download SQLDev](http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html)

15

16 Required: Install ORDS, configure for an Oracle Database (11gR2 or higher), REST enable a schema.

IsWiXNamespaces.cs (https://iswix.svn.codeplex.com/svn) C# · 62 lines

52 _extensions.Add("netfx", "http://schemas.microsoft.com/wix/NetFxExtension");

53 _extensions.Add("ps", "http://schemas.microsoft.com/wix/PSExtension");

54 _extensions.Add("sql", "http://schemas.microsoft.com/wix/SqlExtension");

55 _extensions.Add("util", "http://schemas.microsoft.com/wix/UtilExtension");

56 _extensions.Add("vs", "http://schemas.microsoft.com/wix/VSExtension");

appveyor.yml (https://github.com/Qihoo360/XSQL.git) YAML · 63 lines

30 - dev/appveyor-install-dependencies.ps1

31 - R/

32 - sql/core/src/main/scala/org/apache/spark/sql/api/r/

33 - core/src/main/scala/org/apache/spark/api/r/

34 - mllib/src/main/scala/org/apache/spark/ml/r/

gmDemographics-Data.de.sql (git://pkgs.fedoraproject.org/gnumed-server) SQL · 61 lines

1 -- GNUmed

2 -- $Source: /home/ncq/Projekte/cvs2git/vcs-mirror/gnumed/gnumed/server/sql/country.specific/de/gmDemographics-Data.de.sql,v $

3 -- $Revision: 1.6 $

4

translator.rb (https://github.com/IFTTT/polo.git) Ruby · 84 lines

1 require "polo/sql_translator"

2 require "polo/configuration"

3

druid_adapter.rb (https://github.com/ankane/blazer.git) Ruby · 67 lines

18 }

19

20 uri = URI.parse("#{settings["url"]}/druid/v2/sql/")

21 http = Net::HTTP.new(uri.host, uri.port)

22 http.read_timeout = timeout

Makefile.in (https://bitbucket.org/killerpenguinassassins/open_distrib_devel.git) Autoconf · 462 lines

37 ../html/SMTPD_PROXY_README.html \

38 ../html/SOHO_README.html \

39 ../html/SQLITE_README.html \

40 ../html/STANDARD_CONFIGURATION_README.html \

41 ../html/STRESS_README.html \

77 ../README_FILES/SMTPD_POLICY_README ../README_FILES/SMTPD_PROXY_README \

78 ../README_FILES/SOHO_README \

79 ../README_FILES/SQLITE_README \

80 ../README_FILES/STANDARD_CONFIGURATION_README \

81 ../README_FILES/STRESS_README \

254 $(MAKESOHO) | $(POSTLINK) >$@

255

256 ../html/SQLITE_README.html: SQLITE_README.html

257 $(POSTLINK) $? >$@

258

database.go (https://github.com/go-shiori/shiori.git) Go · 82 lines

2

3 import (

4 "database/sql"

5

6 "github.com/go-shiori/shiori/internal/model"

BezNazwy1.cpp (https://bitbucket.org/ujseproject2013/se2013.git) C++ · 247 lines

15 char pguser[] = "postgres";

16 char pgpass[] = "postgres";

17 char szkielet[] = "../sql/szkielet_bazy.sql";

18 char widoki[] = "../sql/widoki.sql";

19 char tigerry[] = "../sql/wyzwalacze.sql";

20 char funkcje[] = "../sql/funkcje.sql";

21 char dane[] = "../sql/dane_poczatkowe.sql";

22

23 /* ************************************************************************* */

handler.py (https://github.com/tuwid/darkc0de-old-stuff.git) Python · 71 lines

4 $Id: handler.py 186 2008-11-15 23:41:31Z inquisb $

5

6 This file is part of the sqlmap project, http://sqlmap.sourceforge.net.

7

8 Copyright (c) 2006-2008 Bernardo Damele A. G. <bernardo.damele@gmail.com>

user.go (https://github.com/facebookincubator/ent.git) Go · 83 lines

11 "strings"

12

13 "github.com/facebook/ent/dialect/sql"

14 "github.com/facebook/ent/examples/entcpkg/ent/user"

15 )

imc_info_disclosure.py (https://github.com/reverse-shell/routersploit.git) Python · 69 lines

24 def __init__(self):

25 self.paths = [

26 "/imc/reportscript/sqlserver/deploypara.properties",

27 "/rpt/reportscript/sqlserver/deploypara.properties",

sql_authorization.h (https://github.com/mysql/mysql-server.git) C Header · 51 lines

30 #include "lex_string.h"

31 #include "mysql/components/services/mysql_mutex_bits.h"

32 #include "sql/auth/sql_auth_cache.h"

33

34 class String;

auto_thd.h (https://github.com/mysql/mysql-server.git) C Header · 69 lines

28 #include "my_compiler.h"

29 #include "sql/error_handler.h"

30 #include "sql/sql_error.h"

31

32 /**

SQLExpressionsFactory.java (git://pkgs.fedoraproject.org/eclipse-dtp) Java · 69 lines

66 SQLExpressionsPackage getSQLExpressionsPackage();

67

68 } //SQLExpressionsFactory

69

youtube.sh (https://github.com/kboghdady/youTube_ads_4_pi-hole.git) Shell · 58 lines

45

46 # this in case you have an old blocked domain the the database

47 while read ignoredDns ; do /usr/bin/sqlite3 /etc/pihole/gravity.db "delete from domainlist where domain like '%$ignoredDns%' " ; done < ignore.list

48

49 ## adding it to the blacklist in Pihole V5

54

55 #### only disable if you don't like to share your youtube logs to be be added to my list

56 sharedlogs=`sudo /usr/bin/sqlite3 /etc/pihole/pihole-FTL.db "select domain from queries where domain like '%googlevideo.com'" |uniq -d |tr '\n' ','`

57 curl -sL "https://docs.google.com/forms/d/e/1FAIpQLSd_j3lQs_B7S3Hz3aA3IkwYMF4my0DnBMZFAn3e9grZo61VFQ/formResponse?usp=pp_url&entry.275594062=$sharedlogs"

58

extHostRequireInterceptor.ts (https://github.com/Microsoft/sqlopsstudio.git) TypeScript · 50 lines

9 import { ExtensionIdentifier, IExtensionDescription } from 'vs/platform/extensions/common/extensions';

10 import * as azdata from 'azdata';

11 import { IAzdataExtensionApiFactory } from 'sql/workbench/api/common/sqlExtHost.api.impl';

12 import { INodeModuleFactory } from 'vs/workbench/api/common/extHostRequireInterceptor';

13 import { ILogService } from 'vs/platform/log/common/log';

cmake_install.cmake (https://github.com/Meituan-Dianping/SQLAdvisor.git) CMake · 49 lines

1 # Install script for directory: /home/longxuegang/dba_public_scripts_tools/sqlparser/sql/share

2

3 # Set the install prefix

34

35 IF(NOT CMAKE_INSTALL_COMPONENT OR "${CMAKE_INSTALL_COMPONENT}" STREQUAL "Server")

36 FILE(INSTALL DESTINATION "${CMAKE_INSTALL_PREFIX}/share" TYPE DIRECTORY FILES "/home/longxuegang/dba_public_scripts_tools/sqlparser/sql/share/english")

37 ENDIF(NOT CMAKE_INSTALL_COMPONENT OR "${CMAKE_INSTALL_COMPONENT}" STREQUAL "Server")

38

39 IF(NOT CMAKE_INSTALL_COMPONENT OR "${CMAKE_INSTALL_COMPONENT}" STREQUAL "Server")

40 FILE(INSTALL DESTINATION "${CMAKE_INSTALL_PREFIX}/share" TYPE DIRECTORY FILES "/home/longxuegang/dba_public_scripts_tools/sqlparser/sql/share/charsets" REGEX "/languages\\.html$" EXCLUDE)

41 ENDIF(NOT CMAKE_INSTALL_COMPONENT OR "${CMAKE_INSTALL_COMPONENT}" STREQUAL "Server")

42

43 IF(NOT CMAKE_INSTALL_COMPONENT OR "${CMAKE_INSTALL_COMPONENT}" STREQUAL "Server")

44 FILE(INSTALL DESTINATION "${CMAKE_INSTALL_PREFIX}/share" TYPE FILE FILES

45 "/home/longxuegang/dba_public_scripts_tools/sqlparser/sql/share/errmsg-utf8.txt"

46 "/home/longxuegang/dba_public_scripts_tools/sqlparser/sql/share/dictionary.txt"

provision.sh (https://github.com/sql-machine-learning/sqlflow.git) Shell · 58 lines

30 <br/> \n\

31 <div> \n\

32 <a href="https://sql-machine-learning.github.io/sqlflow/">GitHub</a> \n\

33 <span>\&emsp;|\&emsp;</span> \n\

34 <a href="https://github.com/sql-machine-learning/sqlflow/wiki/Contact-us">Contact Us</a> \n\

log-checking.ts (https://github.com/grouparoo/grouparoo.git) TypeScript · 77 lines

5 import { afterData, beforeData, getConfig } from "../utils/data";

6 process.env.GROUPAROO_INJECTED_PLUGINS = JSON.stringify({

7 "@grouparoo/sqlite": { path: path.join(__dirname, "..", "..") },

8 });

9

?????????????????.sql (https://EasyFramework.svn.codeplex.com/svn) SQL · 89 lines

22 BEGIN

23 rec_book.Name :='??';

24 rec_book.Info :='?PL/SQL??;';

25 DBMS_OUTPUT.PUT_LINE(rec_book.Name||' ' ||rec_book.Info);

26 END;

58

59 /*

60 ?????????????????????????????????????????????????PL/SQL?????????VARRAY?

61

62 ??VARRY?????????

odbc-calling-odbc-api-functions-directly.md (https://github.com/MicrosoftDocs/cpp-docs.git) Markdown · 32 lines

24 - Deallocate storage when you finish.

25

26 For more information about these steps, see the [ODBC Programmer's Reference](/sql/odbc/reference/odbc-programmer-s-reference).

27

28 In addition to these steps, you need to take extra steps to check function return values, ensure that your program is not waiting for an asynchronous call to finish, and so on. You can simplify these last steps by using the AFX_SQL_ASYNC and AFX_SQL_SYNC macros. For more information, see [MFC macros and globals](../../mfc/reference/mfc-macros-and-globals.md).

db_saver.cpp (http://urtconnector.googlecode.com/svn/trunk/) C++ · 97 lines

4 #include <exception>

5 #include <common/qt_syslog.h>

6 #include <database/sqlite_database.h>

7

8 #include "manager.h"

tbl_select.php (https://bitbucket.org/hrayrpapikyan/stahlbaum.git) PHP · 72 lines

16 require_once 'libraries/mysql_charsets.inc.php';

17 require_once 'libraries/TableSearch.class.php';

18 require_once 'libraries/sql.lib.php';

19

20 $response = PMA_Response::getInstance();

enabledbase.go (https://github.com/yunionio/onecloud.git) Go · 89 lines

20 "yunion.io/x/pkg/errors"

21 "yunion.io/x/pkg/tristate"

22 "yunion.io/x/sqlchemy"

23

24 "yunion.io/x/onecloud/pkg/apis"

views.py (https://bitbucket.org/biideal/pyramid_debugtoolbar.git) Python · 195 lines

137 @view_config(

138 route_name='debugtoolbar.sql_select',

139 renderer='pyramid_debugtoolbar.panels:templates/sqlalchemy_select.dbtmako',

140 permission=NO_PERMISSION_REQUIRED,

141 custom_predicates=(valid_host, valid_request)

165 @view_config(

166 route_name='debugtoolbar.sql_explain',

167 renderer='pyramid_debugtoolbar.panels:templates/sqlalchemy_explain.dbtmako',

168 permission=NO_PERMISSION_REQUIRED,

169 custom_predicates=(valid_host, valid_request)

LayoutManagerProxy.java (https://github.com/SwiftJava/SwiftJava.git) Java · 64 lines

1

2 /// generated by: genswift.java 'java/lang|java/util|java/sql|java/awt|javax/swing' ///

3

4 /// interface java.awt.LayoutManager ///

FileDialogProxy.java (https://github.com/SwiftJava/SwiftJava.git) Java · 78 lines

1

2 /// generated by: genswift.java 'java/lang|java/util|java/sql|java/awt|javax/swing' ///

3

4 /// class java.awt.FileDialog ///

appweb-solaris.sh (https://github.com/ni-webtech/appweb-4.git) Shell · 204 lines

63 rm -rf ${CONFIG}/inc/sqlite3.h

64 cp -r src/deps/sqlite/sqlite3.h ${CONFIG}/inc/sqlite3.h

65

66 ${CC} -c -o ${CONFIG}/obj/sqlite3.o -fPIC ${LDFLAGS} -mtune=generic -w ${DFLAGS} -I${CONFIG}/inc src/deps/sqlite/sqlite3.c

68 ${CC} -shared -o ${CONFIG}/bin/libsqlite3.so ${LDFLAGS} ${LIBPATHS} ${CONFIG}/obj/sqlite3.o ${LIBS}

69

70 ${CC} -c -o ${CONFIG}/obj/sqlite.o -Wall -fPIC ${LDFLAGS} -mtune=generic ${DFLAGS} -I${CONFIG}/inc src/deps/sqlite/sqlite.c

71

72 ${CC} -o ${CONFIG}/bin/sqlite ${LDFLAGS} ${LIBPATHS} ${CONFIG}/obj/sqlite.o ${LIBS} -lsqlite3 ${LDFLAGS}

package-summary.html (https://github.com/scooter/scooter.git) HTML · 200 lines

122 </TR>

123 <TR BGCOLOR="white" CLASS="TableRowColor">

124 <TD WIDTH="15%"><B><A HREF="../../../../../com/scooterframework/orm/sqldataexpress/service/SqlServiceClient.html" title="class in com.scooterframework.orm.sqldataexpress.service">SqlServiceClient</A></B></TD>

125 <TD>SqlServiceClient class has helper methods on using SqlService.</TD>

126 </TR>

130 </TR>

131 <TR BGCOLOR="white" CLASS="TableRowColor">

132 <TD WIDTH="15%"><B><A HREF="../../../../../com/scooterframework/orm/sqldataexpress/service/SqlServiceConstants.html" title="class in com.scooterframework.orm.sqldataexpress.service">SqlServiceConstants</A></B></TD>

133 <TD>SqlServiceConstants class contains constants for SqlService.</TD>

134 </TR>

135 <TR BGCOLOR="white" CLASS="TableRowColor">

136 <TD WIDTH="15%"><B><A HREF="../../../../../com/scooterframework/orm/sqldataexpress/service/SqlServiceImpl.html" title="class in com.scooterframework.orm.sqldataexpress.service">SqlServiceImpl</A></B></TD>

137 <TD>SqlServiceImpl class implements SqlService interface.</TD>

138 </TR>

networking_tables_tests.cpp (https://github.com/HeroicCybersecurity/osquery.git) C++ · 79 lines

12

13 #include <osquery/logger.h>

14 #include <osquery/sql.h>

15

16 #include "osquery/tests/test_additional_util.h"

sql-statement-commit.md (https://github.com/pingcap/docs-cn.git) Markdown · 77 lines

2 title: COMMIT

3 summary: TiDB 数据库中 COMMIT 的使用概况。

4 aliases: ['/docs-cn/dev/sql-statements/sql-statement-commit/','/docs-cn/dev/reference/sql/statements/commit/']

5 ---

6

15 **CommitStmt:**

16

17 ![CommitStmt](/media/sqlgram/CommitStmt.png)

18

19 **CompletionTypeWithinTransaction:**

72 ## 另请参阅

73

74 * [START TRANSACTION](/sql-statements/sql-statement-start-transaction.md)

75 * [ROLLBACK](/sql-statements/sql-statement-rollback.md)

76 * [BEGIN](/sql-statements/sql-statement-begin.md)

77 * [事务的惰性检查](/transaction-overview.md#惰性检查)

78

README.md (https://github.com/HariSekhon/pytools.git) Markdown · 52 lines

2 =====================

3

4 Triggers GCP [Cloud SQL](https://cloud.google.com/sql) export backups to [GCS](https://cloud.google.com/storage).

5

6 Solution documentation:

23 - [Cloud Scheduler](https://cloud.google.com/scheduler) jobs to trigger backups

24 - see `gcp_cloud_schedule_sql_exports.sh` in [DevOps Bash tools](https://github.com/HariSekhon/DevOps-Bash-tools/) repo

25 - a service account with permissions to access [Cloud SQL](https://cloud.google.com/sql)

26 - see `gcp_sql_create_readonly_service_account.sh` in [DevOps Bash tools](https://github.com/HariSekhon/DevOps-Bash-tools/) repo

27 - each [Cloud SQL](https://cloud.google.com/sql) instance to be backed up requires objectCreator permissions to the [GCS](https://cloud.google.com/storage) bucket

drop-constraint.md (https://github.com/cockroachdb/docs.git) Markdown · 66 lines

12 ## Synopsis

13

14 {% include {{ page.version.version }}/sql/diagrams/drop_constraint.html %}

15

16 ## Required Privileges

Dockerfile (https://github.com/jburel/openmicroscopy.git) Dockerfile · 76 lines

47 COPY omero.class /src/

48 COPY setup.cfg /src/

49 COPY sql /src/sql

50 COPY test.xml /src/

51 COPY LICENSE.txt /src/

txnz_test.go (https://github.com/radondb/radon.git) Go · 97 lines

21 "github.com/stretchr/testify/assert"

22 "github.com/xelabs/go-mysqlstack/driver"

23 "github.com/xelabs/go-mysqlstack/sqlparser/depends/sqltypes"

24 "github.com/xelabs/go-mysqlstack/xlog"

25 )

dev_setup.md (https://github.com/WuTheFWasThat/vimflowy.git) Markdown · 84 lines

39

40 Notably, you can run a SQLite backend, for persistence to your server.

41 [See here for more info](docs/storage/SQLite.md).

42

43 ### Tests

upgrade-3.2.9.0.0-3.3.0.0.0.sql (https://github.com/cognovis/project-open.git) SQL · 276 lines

1 -- upgrade-3.2.9.0.0-3.3.0.0.0.sql

2

3 SELECT acs_log__debug('/packages/intranet-trans-invoices/sql/postgresql/upgrade/upgrade-3.2.9.0.0-3.3.0.0.0.sql','');

4

5

dbdump.rst (https://github.com/apache/trafficcontrol.git) ReStructuredText · 66 lines

56 Access-Control-Allow-Methods: POST,GET,OPTIONS,PUT,DELETE

57 Access-Control-Allow-Origin: *

58 Content-Type: application/sql

59 Content-Disposition: attachment

60 Set-Cookie: mojolicious=...; Path=/; Expires=Mon, 18 Nov 2019 17:40:54 GMT; Max-Age=3600; HttpOnly

intranet-invoices-drop.sql (https://gitlab.com/project-open/intranet-invoices.git) SQL · 74 lines

1 -- /packages/intranet-invoices/sql/oracle/intranet-invoices-drop.sql

2 --

3 -- Copyright (C) 2003 - 2009 ]project-open[

app.js (https://bitbucket.org/rollingstone99/botbuilder-azure-aeonx.git) JavaScript · 53 lines

5

6 -Using Azure SQL

7 -Create an Azure SQL database (https://docs.microsoft.com/en-us/azure/sql-database/sql-database-get-started-portal)

8 -Replace userName, password, server, database, and table to your preference in the code below.

9 -IMPORTANT: You should create your table before attempting to connect your bot to it.

sqm.adoc (https://github.com/hibernate/hibernate-orm.git) AsciiDoc · 55 lines

53

54

55 See the document `design/sql-ast.adoc` for details about the SQL AST, including its execution.

56

nonce.go (https://github.com/target/goalert.git) Go · 105 lines

3 import (

4 "context"

5 "database/sql"

6 "github.com/target/goalert/util"

7 "github.com/target/goalert/util/log"

encodable.go (https://github.com/campoy/justforfunc.git) Go · 99 lines

20 "bytes"

21

22 "gopkg.in/src-d/go-vitess.v1/sqltypes"

23 )

24

users.go (https://github.com/capitalone/checks-out.git) Go · 88 lines

20

21 import (

22 "database/sql"

23 "net/http"

24

SUMMARY.md (https://github.com/rspeele/Rezoom.SQL.git) Markdown · 45 lines

29 * [Vendor statements](doc/Language/VendorStatements.md)

30 * [Functions](doc/Language/Functions/README.md)

31 * [SQLite](doc/Language/Functions/SQLiteFunctions.md)

32 * [TSQL](doc/Language/Functions/TSQLFunctions.md)

33 * [Postgres](doc/Language/Functions/PostgresFunctions.md)

34 * [Quirks](doc/Language/Quirks/README.md)

35 * [SQLite](doc/Language/Quirks/SQLiteQuirks.md)

36 * [TSQL](doc/Language/Quirks/TSQLQuirks.md)

37 * [Postgres](doc/Language/Quirks/PostgresQuirks.md)

standing_order_item.go (https://gitlab.com/mahina/platform) Go · 316 lines

6 "errors"

7

8 "github.com/jmoiron/sqlx"

9 "github.com/jmoiron/sqlx/types"

aggregate_syntax.rs (https://github.com/antoyo/tql.git) Rust · 64 lines

56 //~^ ERROR no aggregate field named `avg` found

57

58 //sql!(Table.values(i32_field).aggregate(average = avg(i32_field)).filter(avrage < 20));

59 // TODO: propose similar names.

60

query_analyzer.go (https://gitlab.com/18runt88/vitess) Go · 119 lines

16 log "github.com/golang/glog"

17 "github.com/youtube/vitess/go/exit"

18 "github.com/youtube/vitess/go/vt/sqlparser"

19 )

20

SqlServerType.java (https://jedit.svn.sourceforge.net/svnroot/jedit) Java · 745 lines ✨ Summary

This Java code is part of a system that loads and manages SQL server types, including statements and connection parameters. It uses XML files to store this information and provides methods for loading and resolving entities in these files. The code also includes classes for representing statements and connection parameters, as well as a resolver for handling entity references in the XML files.

92 private final static String[] codebaseFiles =

93 {

94 "/sql/serverTypes/db2Local.xml",

95 "/sql/serverTypes/db2Remote.xml",

96 "/sql/serverTypes/mysql.xml",

97 "/sql/serverTypes/odbc.xml",

98 "/sql/serverTypes/oracle.xml",

99 "/sql/serverTypes/pgsql.xml",

100 "/sql/serverTypes/ASA.xml",

101 "/sql/serverTypes/MSSQL.jTDS.xml",

102 "/sql/serverTypes/Sybase.xml",

103 "/sql/serverTypes/Progress.xml"