#-------------------------------------------------------------------------------
# Name:        module1
# Purpose:
#
# Author:      User
#
# Created:     15/02/2015
# Copyright:   (c) User 2015
# Licence:     <your licence>
#-------------------------------------------------------------------------------
 
# https://dev.mysql.com/doc/connector-python/en/connector-python-example-ddl.html
 
 
from __future__ import print_function
 
import mysql.connector
from mysql.connector import errorcode
import config# Settings
 
 
 
 
DB_NAME = config.sql_login["database"]
 
TABLES = {}
TABLES['story_metadata'] = (
    "CREATE TABLE `story_metadata` ("
    # Local stuff
    "  `primary_key` int NOT NULL AUTO_INCREMENT,"
    "  `version` int NOT NULL,"
    # From site
    "  `status` text NOT NULL,"
    "  `total_views` int NOT NULL,"
    "  `full_image` text NOT NULL,"
    "  `description` text NOT NULL,"
    "  `views` int NOT NULL,"
    "  `date_modified` int NOT NULL,"
    "  `url` text NOT NULL,"
    "  `image` text NOT NULL,"
    "  `title` text NOT NULL,"
    "  `dislikes` int NOT NULL,"
    "  `comments` int NOT NULL,"
    "  `content_rating` int NOT NULL,"
    "  `chapter_count` int NOT NULL,"
    # chapters [??]
    # author {name (string),id (int)}
    "  `author_name` text NOT NULL,"
    "  `author_id` int NOT NULL,"
    "  `words` int NOT NULL,"
    "  `content_rating_text` text NOT NULL,"
    "  `short_description` text NOT NULL,"
    "  `id` int NOT NULL,"
    # categories {??}
    "  `likes` int NOT NULL,"
    "  PRIMARY KEY (`primary_key`)"
    ") ENGINE=InnoDB")
 
 
 
TABLES['chapter_metadata'] = (
    "CREATE TABLE `chapter_metadata` ("
    # Local stuff
    "  `primary_key` int NOT NULL AUTO_INCREMENT,"
    "  `version` int NOT NULL,"
    "  `metadata_table_key` int NOT NULL,"
    "  `parent_story_id` int NOT NULL,"
    # From site
    "  `id` int NOT NULL,"
    "  `link` text NOT NULL,"
    "  `title` text NOT NULL,"
    "  `views` int NOT NULL,"
    "  `words` int NOT NULL,"
    "  PRIMARY KEY (`primary_key`)"
    ") ENGINE=InnoDB")
 
 
 
TABLES['chapter_texts'] = (
    "CREATE TABLE `chapter_texts` ("
    # Local stuff
    "  `primary_key` int NOT NULL AUTO_INCREMENT,"
    "  `version` int NOT NULL,"
    "  `metadata_table_key` int NOT NULL,"
    "  `parent_chapter_id` int NOT NULL,"
    "  `parent_story_id` int NOT NULL,"
    "  `parent_chapter_id` int NOT NULL,"
    # From site
    "  `chapter_text` text NOT NULL,"
    "  PRIMARY KEY (`primary_key`)"
    ") ENGINE=InnoDB")
 
 
 
TABLES['full_texts'] = (
    "CREATE TABLE `full_texts` ("
    # Local stuff
    "  `primary_key` int NOT NULL AUTO_INCREMENT,"
    "  `version` int NOT NULL,"
    "  `metadata_table_key` int NOT NULL,"
    "  `parent_story_id` int NOT NULL,"
    # From site
    "  `full_story_text` text NOT NULL,"
    "  PRIMARY KEY (`primary_key`)"
    ") ENGINE=InnoDB")
 
 
 
 
 
cnx = mysql.connector.connect(**config.sql_login)
cursor = cnx.cursor()
 
def create_database(cursor):
    try:
        cursor.execute(
            "CREATE DATABASE {} DEFAULT CHARACTER SET 'utf8'".format(DB_NAME))
    except mysql.connector.Error as err:
        print("Failed creating database: {}".format(err))
        exit(1)
 
try:
    cnx.database = DB_NAME
except mysql.connector.Error as err:
    if err.errno == errorcode.ER_BAD_DB_ERROR:
        create_database(cursor)
        cnx.database = DB_NAME
    else:
        print(err)
        exit(1)
 
 
 
 
 
for name, ddl in TABLES.iteritems():
    try:
        print("Creating table {}: ".format(name), end='')
        cursor.execute(ddl)
    except mysql.connector.Error as err:
        if err.errno == errorcode.ER_TABLE_EXISTS_ERROR:
            print("already exists.")
        print(err.msg)
    else:
        print("OK")
 
cursor.close()
cnx.close()
 
 
 
 
 
 
 
 
 
 
 
def main():
    pass
 
if __name__ == '__main__':
    main()