Exemplos de create_new_engine em Python

Exemplo n.º 1

def main():
    """
    Main function to read records from the database to get the top albums

    :return: Nothing
    :rtype: None
    """

    # Getting the path for logging config using arparse
    log_config_file = helper.ARGUMENTS.logfile

    # Configuring logging
    helper.configure_logging(log_config_file)

    # Getting a new engine
    engine = connections.create_new_engine(helper.ARGUMENTS.dialect,
                                           helper.ARGUMENTS.driver,
                                           helper.ARGUMENTS.user,
                                           helper.ARGUMENTS.password,
                                           helper.ARGUMENTS.host,
                                           helper.ARGUMENTS.database)

    # Getting a session factory binded to previously created engine
    session_factory = connections.get_session_factory(engine)
    session = session_factory()

    db_aggregate.get_top_album_tracks(session, helper.ARGUMENTS.number)

Exemplo n.º 2

Arquivo: main_read.py Projeto: Praveenstein/musicSystem

def main():
    """
    Main function to read records from the database using join operations

    :return: Nothing
    :rtype: None
    """

    # Getting the path for logging config using arparse
    log_config_file = helper.ARGUMENTS.logfile

    # Configuring logging
    helper.configure_logging(log_config_file)

    engine = connections.create_new_engine(helper.ARGUMENTS.dialect,
                                           helper.ARGUMENTS.driver,
                                           helper.ARGUMENTS.user,
                                           helper.ARGUMENTS.password,
                                           helper.ARGUMENTS.host,
                                           helper.ARGUMENTS.database)

    session_factory = connections.get_session_factory(engine)
    session = session_factory()

    db_read.perform_read_join(session, helper.ARGUMENTS.number)

Exemplo n.º 3

Arquivo: main_add_genre_to_artist_q12.py Projeto: Praveenstein/musicSystem

def main():
    """
    Main function to to add Genre Tags to Artist

    :return: Nothing
    :rtype: None
    """

    # Getting the path for logging config using arparse
    log_config_file = helper.ARGUMENTS.logfile

    # Configuring logging
    helper.configure_logging(log_config_file)

    # Getting a new engine
    engine = connections.create_new_engine(helper.ARGUMENTS.dialect, helper.ARGUMENTS.driver,
                                           helper.ARGUMENTS.user, helper.ARGUMENTS.password,
                                           helper.ARGUMENTS.host, helper.ARGUMENTS.database)

    db_aggregate.add_genre_to_artist(engine, helper.ARGUMENTS.number)

Exemplo n.º 4

Arquivo: main_create.py Projeto: Praveenstein/musicSystem

def main():
    """
    Main function to perform the create operation

    :return: Nothing
    :rtype: None
    """

    # Getting the path for logging config using arparse
    log_config_file = helper.ARGUMENTS.logfile

    # Configuring logging
    helper.configure_logging(log_config_file)

    engine = connections.create_new_engine(helper.ARGUMENTS.dialect,
                                           helper.ARGUMENTS.driver,
                                           helper.ARGUMENTS.user,
                                           helper.ARGUMENTS.password,
                                           helper.ARGUMENTS.host,
                                           helper.ARGUMENTS.database)

    session_factory = connections.get_session_factory(engine)

    db_create.perform_create(session_factory)