Table of Contents

• Requirements
• Installation
• Documentation
• Example
• Resources
• License

Requirements

Installation

Documentation

Example

CREATETABLE `users` (`id`INTEGERPRIMARY KEY AUTOINCREMENT,`email`varchar(255)NOT NULL,`password`varchar(255)NOT NULL);

importpycovenantsql# Connect to the database with dsn# host and port are your local CovenantSQL Adapter serverconnection=pycovenantsql.connect(dsn='covenantsql://your_database_id',host='localhost',port=11108,                             )try:withconnection.cursor()ascursor:# Create a new recordsql="INSERT INTO `users` (`email`, `password`) VALUES (%s, %s)"cursor.execute(sql, ('webmaster@python.org','very-secret'))# connection is autocommit. No need to commit in any case.# connection.commit()withconnection.cursor()ascursor:# Read a single recordsql="SELECT `id`, `password` FROM `users` WHERE `email`=%s"cursor.execute(sql, ('webmaster@python.org',))result=cursor.fetchone()print(result)finally:connection.close()

{'password':'very-secret','id':1}

Resources

License