Zen

Source string Source string

tarantool> -- Connection function. Usage: conn = mysql_connect() tarantool> function mysql_connection() > local p = {} > p.host = 'widgets.com' > p.db = 'test' > conn = mysql.connect(p) > return conn > end --- ... tarantool> conn = mysql_connect() --- ...
319/10000 · 319
English Actions
Begin by making a ``require`` request for the mysql driver. We will assume that the name is ``mysql`` in further examples.
mysql = require('mysql')
Now, say:
*connection_name* = mysql.connect(*connection options*)
The connection-options parameter is a table. Possible options are:
:samp:`host = {host-name}` - string, default value = 'localhost'
:samp:`port = {port-number}` - number, default value = 3306
:samp:`user = {user-name}` - string, default value is operating-system user name
:samp:`password = {password}` - string, default value is blank
:samp:`db = {database-name}` - string, default value is blank
:samp:`raise = {true|false}` - boolean, default value is false
The option names, except for `raise`, are similar to the names that MySQL's mysql client uses, for details see the MySQL manual at `dev.mysql.com/doc/refman/5.6/en/connecting.html <https://dev.mysql.com/doc/refman/5.6/en/connecting.html>`_. The `raise` option should be set to :codenormal:`true` if errors should be raised when encountered. To connect with a Unix socket rather than with TCP, specify ``host = 'unix/'`` and :samp:`port = {socket-name}`.
Example, using a table literal enclosed in {braces}:
conn = mysql.connect({
host = '127.0.0.1',
port = 3306,
user = 'p',
password = 'p',
db = 'test',
raise = true
})
-- OR
conn = mysql.connect({
host = 'unix/',
port = '/var/run/mysqld/mysqld.sock'
})
Example, creating a function which sets each option in a separate line:
tarantool> -- Connection function. Usage: conn = mysql_connect()
tarantool> function mysql_connection()
> local p = {}
> p.host = 'widgets.com'
> p.db = 'test'
> conn = mysql.connect(p)
> return conn
> end
---
...
tarantool> conn = mysql_connect()
---
...
We will assume that the name is 'conn' in further examples.
How to ping
To ensure that a connection is working, the request is:
*connection-name*:ping()
**Example:**
tarantool> conn:ping()
---
- true
...
Executing a statement
For all MySQL statements, the request is:
*connection-name*:execute(*sql-statement* [, *parameters*])
where ``sql-statement`` is a string, and the optional ``parameters`` are extra values that can be plugged in to replace any question marks ("?"s) in the SQL statement.
tarantool> conn:execute('select table_name from information_schema.tables')
---
- - table_name: ALL_PLUGINS
- table_name: APPLICABLE_ROLES
- table_name: CHARACTER_SETS
<...>
- 78
...
Closing connection
To end a session that began with ``mysql.connect``, the request is:
*connection-name*:close()
tarantool> conn:close()
---
...

Loading…

User avatar None

New source string

testing_project / Documentation: reference/reference_rock/dbms — English

tarantool> -- Connection function. Usage: conn = mysql_connect()
tarantool> function mysql_connection()
> local p = {}
> p.host = 'widgets.com'
> p.db = 'test'
> conn = mysql.connect(p)
> return conn
> end
---
...
tarantool> conn = mysql_connect()
---
...
a year ago
Browse all string changes

Things to check

Ellipsis 1

The string uses three dots (...) instead of an ellipsis character (…)

Reset

Glossary

English English
No related strings found in the glossary.

String information

Flags
read-only
String age
a year ago
Last updated
a year ago
Source string age
a year ago
Translation file
string 39