Skip to main content

What If?

One would think this life would be easier than it currently is. I mean come on wouldn’t ou think that? Of course you would. So why can’t we each believe in it I for one would want to believe in it. It would give me something to do with my day at least. But well there’s something else on my mind. We have to be able to understand what it is exactly, if we don’t? Then that’s something quite different now isn’t it? Yeah that’s what I was thinking.
Post a Comment

Files Table in sql for SQLite3

Here's some code I'm working on for a sqlite3 database to store backup file content. Might add a BLOB type later for storing binary data. Not sure yet.


PRAGMA foreign_keys=OFF;
BEGIN TRANSACTION;
CREATE TABLE files (id INTEGER PRIMARY KEY,
 name TEXT,
 content TEXT,
 created_ts TEXT,
 modified_ts TEXT);
CREATE TABLE files_log(id INTEGER PRIMARY KEY,
  fileid TEXT,
  name TEXT,
  content TEXT,
  created_ts TEXT,
  modified_ts TEXT,
  dt TEXT);
CREATE TRIGGER files_trig AFTER INSERT ON files
BEGIN
  update files SET created_ts = datetime('now','localtime') WHERE id = NEW.id;
END;
CREATE TRIGGER files_update_trig AFTER UPDATE ON files
BEGIN
  update files SET modified_ts = datetime('now','localtime') WHERE id = OLD.id;
  insert into files_log(fileid, name, content, created_ts, modified_ts)
    values(OLD.id, OLD.name, OLD.content, OLD.created_ts, OLD.modified_ts);
END;
CREATE TRIGGER files_log_update_trig AFTER INSERT ON files_log
BEGIN
  update files_log SET dt = datetime('now', 'localtime') WHERE id = NEW.id;
END;
COMMIT;
Labels:

Comments

Post a Comment

Popular posts from this blog

Didn't Sleep

 What's the point of sleep anymore if I can't sleep? I don't think I slept any good last night. I was awake at 3 am wondering to myself, what on earth am I doing awake? Yeah, that happened. It doesn't make any sense. Fortunately, it's the weekend. So, I can catch up on sleep tonight. I don't have to be anywhere tomorrow, so it's a good opportunity to actually sleep for once. Whatever the case, I hope I'll be able to fall asleep and stay asleep. We will see what happens.
Post a Comment
Read more

Temptation Bible vs Book of Mormon

In the Bible in 1 Corinthians 10:13 we find: There hath no temptation taken you but such as is common to man: but God is faithful, who will not suffer you to be tempted above that ye are able ; but will with the temptation also make a way to escape, that ye may be able to bear it. But what might seem as a contradiction is found in Alma 13:28 But that ye would humble yourselves before the Lord, and call on his holy name, and watch and pray continually, that ye may not be tempted above that which ye can bear , and thus be led by the Holy Spirit, becoming humble, meek, submissive, patient, full of love and all long-suffering; So, which is it? Either God tempts you to a point and stops, or you have to actively pray not to be tempted beyond that no return point. Which is it?
Post a Comment
Read more

An Opposition In All Things

Long has been the story told about how there must be an opposition in all things. From the pre-existence there was Satan, Lucifer the Son of the Morning. In the beginning we were with God in his presence. We learned all we could while there. Until the moment we couldn’t progress any more, we were unable to become like God. So, we were given the opportunity to come to Earth to gain a body. A Savior would be provided to atone for our sins enabling us to come back to the presence of God. The idea that an opposition must be in all things comes from 2nd Nephi: For it must needs be, that there is an opposition in all things. If not so, my firstborn in the wilderness, righteousness could not be brought to pass, neither wickedness, neither holiness nor misery, neither good nor bad. Wherefore, all things must needs be a compound in one; wherefore, if it should be one body it must needs remain as dead, having no life neither death, nor corruption nor incorruption, happiness nor misery, neither...
Post a Comment
Read more