o
    øU¨et  ã                   @   sZ   d dl Z d dlZd dlZdZej ej e¡¡Zej 	ee¡Z
dd„ Zdd„ Zdd„ ZdS )	é    Nzsong_check_data.dbc                 C   sœ   t  t¡}| ¡ }| d¡ | d| d | d | d | d | d | d | d	 | d
 | d | d | d | d t | d ¡| d | d f¡ | ¡  | ¡  d S )Na¾  CREATE TABLE IF NOT EXISTS songs (
        all_ok TEXT,
        created_by TEXT,
        song_id TEXT,
        song_title TEXT,
        arrangement_name TEXT,
        created_at TEXT,
        arrangement_id TEXT PRIMARY KEY,
        song_url TEXT,
        verse_start TEXT,
        uniqe_verse_elements TEXT,
        line_length TEXT,
        has_lyrics TEXT,
        verse_result TEXT,
        sequence_ok TEXT,
        lyrics_enabled TEXT
    )a8  INSERT OR REPLACE INTO songs (
        all_ok, created_by, song_id, song_title, arrangement_name, created_at,
        arrangement_id, song_url, verse_start, uniqe_verse_elements, line_length,
        has_lyrics, verse_result, sequence_ok, lyrics_enabled
    ) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)Úall_okÚ
created_byÚsong_idÚ
song_titleÚarrangement_nameÚ
created_atÚarrangement_idÚsong_urlÚverse_startÚuniqe_verse_elementsÚline_lengthÚ
has_lyricsÚverse_resultÚsequence_okÚlyrics_enabled)	Úsqlite3ÚconnectÚDATABASE_FILE_URLÚcursorÚexecuteÚjsonÚdumpsÚcommitÚclose)ÚentryÚconnr   © r   ú&/var/www/bmteknikk.ddns.net/DBtools.pyÚ
insertData	   s   

ûür   c                  C   s¶   t  t¡} |  ¡ }| d¡ | ¡ }g }|D ]7}|d |d |d |d |d |d |d |d	 |d
 |d |d |d |d |d |d dœ}| |¡ qtj|dd}|  	¡  |S )NzSELECT * FROM songsr   é   é   é   é   é   é   é   é   é	   é
   é   é   é   é   )r   r   r   r   r   r   r   r	   r
   Úunique_verse_elementsr   r   r   r   r   ©Úindent©
r   r   r   r   r   ÚfetchallÚappendr   r   r   ©r   r   ÚrowsÚ	data_listÚrowÚ	song_dataÚ	json_datar   r   r   Úreturn_all_data2   s4   

ñr9   c                  C   sn   t  t¡} |  ¡ }| d¡ | ¡ }g }|D ]}|d |d |d dœ}| |¡ qtj|dd}|  	¡  |S )NzLSELECT song_id, arrangement_id, song_title FROM songs WHERE all_ok = 'True';r   r   r    )r   r   r   r"   r.   r0   r3   r   r   r   Úreturn_arrangments_which_are_oka   s   

ýr:   )r   r   ÚosÚDATABASE_FILE_NAMEÚpathÚdirnameÚabspathÚ__file__ÚBASE_DIRÚjoinr   r   r9   r:   r   r   r   r   Ú<module>   s    )/