from AndroidCodeGenerator.generator import Generator
from AndroidCodeGenerator.sql_validator import SQLTester
from AndroidCodeGenerator.db_table import (Table, Column, ForeignKey, Unique,
Trigger, Check)
from AndroidCodeGenerator.database_triggers import DatabaseTriggers
tables = []
triggers = []
tasklists = Table('tasklist')
tasklists.add_cols(
Column('title').text.not_null.default("''"),
Column('updated').integer,
Column('listtype').text,
Column('sorting').text,
Column('deleted').integer.not_null.default(0),
# New fields
Column('ctime').timestamp.default_current_timestamp,
Column('mtime').timestamp.default_current_timestamp,
# GTask fields
Column('account').text,
Column('remoteid').text)
tasklists.add_constraints(Unique('account', 'remoteid').on_conflict_replace)
tables.append(tasklists)
tasks = Table('task')
tasks.add_cols(
Column('title').text.not_null.default("''"),
Column('note').text.not_null.default("''"),
Column('completed').integer,
Column('updated').integer,
from AndroidCodeGenerator.generator import Generator
from AndroidCodeGenerator.sql_validator import SQLTester
from AndroidCodeGenerator.db_table import Table, Column, ForeignKey, Unique, Trigger, Check
from AndroidCodeGenerator.database_triggers import DatabaseTriggers
tables = []
triggers = []
tasklists = Table("tasklist")
tasklists.add_cols(
Column("title").text.not_null.default("''"),
Column("updated").integer,
Column("listtype").text,
Column("sorting").text,
Column("deleted").integer.not_null.default(0),
# New fields
Column("ctime").timestamp.default_current_timestamp,
Column("mtime").timestamp.default_current_timestamp,
# GTask fields
Column("account").text,
Column("remoteid").text,
)
tasklists.add_constraints(Unique("account", "remoteid").on_conflict_replace)
tables.append(tasklists)
tasks = Table("task")
tasks.add_cols(
Column("title").text.not_null.default("''"),
Column("note").text.not_null.default("''"),
Column("completed").integer,
